vb.org Archive
Page 52 of 68 « First 2425051 52 535462 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   Major Additions - vBExperience 4 (https://vborg.vbsupport.ru/showthread.php?t=245023)

chrisngrod 10-11-2011 12:24 AM
I have achievements but only some show up in the postbit.

Also does anyone know a way to give points for purchasing a subscription? Thanks.

chrisngrod 10-11-2011 12:56 PM
Quote:
Originally Posted by kmckay (Post 2255673)
I've found a bug in the file functions_xperience.php, within the function "DoAchievements" ..

The result of the bug is that the scheduled task that calculates achievements will eventually prematurely end before processing all achievements.

The limit variable that is passed which is defaulted to 100, is being reached early causing the function to return before running all achievements. The variable seems to be used inconsistently as it's used to limit the stats pulled for an achievement, but rather than looping through groups of the achievement, it returns out of the function with no way of continuing from where it left off. Also, the processed count is incremented on non-related activities, so it wouldn't be a reliable count to use for continuing the process anyway.

Has anyone noticed this? (It was found in version 4.0.4)
Could this possibly be why it shows that I satisfy the need for the 50,000 experience points, but have not been assigned the achievement?

Budget101 10-14-2011 03:02 PM
Quote:
Originally Posted by Phalynx (Post 2060972)
The system calculates the activity (week, month and also a custom defined datespan, 60) by counting the actions a user has done. An action can be a post, a new thread, rating, download, etc....
Whereabouts is this setting, as I reinstalled for the umpteenth time & as far as I can see, it's STILL not available. . .

Phalynx 10-17-2011 08:05 AM
Settings, Experience: Activity, Timeframe for Activity

Budget101 10-17-2011 12:17 PM
Quote:
Originally Posted by Phalynx (Post 2258082)
Settings, Experience: Activity, Timeframe for Activity
Unfortunately that is only for "Posts Per Day"- which really doesn't effect anything at all & isn't useful.

Quote:
The system calculates the activity (week, month and also a custom defined datespan, 60) by counting the actions a user has done.An action can be a post, a new thread, rating, download, etc
The way it's written it makes the mod sounds as if it has the ability to choose a date to start calculating points, which is Clearly NOT the case.
IF It actually had a Custom Defined Datespan for counting the actions a user has done than rather than taking in an entire Decade worth of info- we could calculate activity for this year only, or the last 3 months, an actual "custom defined datespan".

Phalynx 10-17-2011 12:44 PM
That phrase hasn't been refreshed since the change from posts to all possible things. So yes, it counts for ALL, not only for postings.

LoudBox 10-17-2011 02:09 PM
How can I do this:

1. Automatic achievement when someone starts a thread in a certain category?

2. Automatic achievement if that thread is updated at least x times a week for x days, months, years?

3. Automatic achievement when user sets a profile picture, and when he sets a signature?

Also: how can you set achievements that are NOT based on forum behavior, but that any user can request at any time?

Thanks!

Phalynx 10-18-2011 06:43 AM
Automatic something can only be done with a vBExperience Plugin, see CDP documentation.

There are awards that you can manually assign to a user upon a request.

Budget101 10-18-2011 10:23 AM
Quote:
Originally Posted by Phalynx (Post 2258191)
That phrase hasn't been refreshed since the change from posts to all possible things. So yes, it counts for ALL, not only for postings.
then why, when I change it to 30 days and recalculate the following:

update experience points
update activity PPD

does the points still remain the same? It STILL Calculates from the beginning of the boards time, in this case, over a Decade of points, NOT the 30 days I entered into this value.

I have registered members with 300,000+ points that haven't logged into the site in 6 YEARS, so how exactly is this only pulling data from the past 30 days?? Their points value should be ZERO.

Phalynx 10-18-2011 11:04 AM
Please don't mix activity and points. Activity says how active a user the last X days was. But points are always calculated from the beginning. There are a few requests to make calculations work since day Y, but currently I don't have time for this.

It would be great if you mark this as "Installed", I appreciate this.

listisimo.es 10-19-2011 10:01 AM
This seems like a really useful mod so I have installed it. The problem is I can't work out how to use it. I do not have a technical background, so I need clear instructions on how all the settings work. Is there a page with detailed instructions on all the configuration options? I haven't seen one yet. Also, does anyone offer a service to set it up? I want a very simple set-up to start with, just points for starting and posting in threads, nothing else.

Budget101 10-19-2011 11:03 AM
Quote:
Originally Posted by Phalynx (Post 2258530)
Please don't mix activity and points. Activity says how active a user the last X days was. But points are always calculated from the beginning. There are a few requests to make calculations work since day Y, but currently I don't have time for this.

It would be great if you mark this as "Installed", I appreciate this.
**Uninstalled AGAIN* Mod is useless until Points can be calculated from a set date.

Phalynx 10-19-2011 11:07 AM
Quote:
Originally Posted by listisimo.es (Post 2258910)
This seems like a really useful mod so I have installed it. The problem is I can't work out how to use it. I do not have a technical background, so I need clear instructions on how all the settings work. Is there a page with detailed instructions on all the configuration options? I haven't seen one yet. Also, does anyone offer a service to set it up? I want a very simple set-up to start with, just points for starting and posting in threads, nothing else.
PM me if you still need help.

Phalynx 10-20-2011 11:16 AM
Currently preparing vBExperience 4.1, which will contain the possibility to calculate points starting from a given date (this has been sponsored by a user!).

Please leave a post about what you would like to see in this upcoming release. Please take also a look at the Bug and Feature Request Tracker: http://www.vbaddict.net/project.php?projectid=2

Phalynx 10-20-2011 12:57 PM
Quote:
Originally Posted by Teascu Dorin (Post 2253939)
Romanian translation for this addon (vBExperience 4 v4.0.4)

Enjoy!

-Dorin
Thanks for sharing! Will include this in 4.1

Bob Meta 10-21-2011 08:42 PM
On installation, will this award achievements retroactively to users who have already met the requirements?

Phalynx 10-21-2011 10:34 PM
Yes. You need to run recount to assign all achievements.

Phalynx 10-21-2011 10:44 PM
vBExperience 4.1.0 Beta 1 has been released.

- Introduced the feature to start the calculation by a defined date. By default all data will be considered for calculation. You need to re-install all plugins to have them obeying the new calculation limit. This feature has been sponsored by BryanB. Thanks!
- Fixed Discussion Ender, can be now disabled by setting value to 0
- Fixed Arm of Law, can be now disabled by setting value to 0

- Added: Romanian Translation (thanks to Teascu Dorin)

Sarab 10-21-2011 11:22 PM
Hello,

Thank you for all your great work =)

I was wondering what table & column should I use for vbshop?

Can you tell me please?

Best Regards
Sarab

Bob Meta 10-22-2011 12:08 AM
Quote:
Originally Posted by Phalynx (Post 2259911)
Yes. You need to run recount to assign all achievements.
Thanks for getting back to me, it sounds like you have answered that question many times before :) I will install this soon!

Megaboost 10-22-2011 12:37 AM
Just updated to 4.1.0 beta and everything works fine apart from the error below when I go to Recount/update experience points.

Quote:
Database error in vBulletin 4.1.7:

Invalid SQL:
SELECT
SUM(totaldownloads) as sum_downloads
FROM dl2_files
WHERE uploaderid=1
AND dl2_files.dateline > 315532800
GROUP BY uploaderid;

MySQL Error : Unknown column 'dl2_files.dateline' in 'where clause'
Error Number : 1054
Request Date : Friday, October 21st 2011 @ 08:34:15 PM
Error Date : Friday, October 21st 2011 @ 08:34:16 PM
Any Idea's on a fix?

ahobilam 10-22-2011 02:53 AM
Thanks for the VBExperience Upgrade info.
I downloaded and installed it. I like this product very much.
But, regarding levels, It always showing only Level 1 for any higher points:
Level completed: 99%,
Points required for next Level: 0
I think, that I have not made proper settings to work this?
Please guide me, can you send your reply through pm?
thanks in advance

ahobilam 10-22-2011 08:13 AM
Today I installed the update and tried to do recount
I am getting the following error:
Database error in vBulletin 4.1.7:

Invalid SQL:
SELECT
COUNT(*) AS count_threads,
SUM(votetotal/votenum) AS count_votes,
SUM(replycount) AS count_replycount,
SUM(views) AS count_views,
SUM(sticky) AS count_stickies
FROM brahmins_thread
WHERE visible=1 AND forumid NOT IN(4,5,8)
AND postuserid=1
AND thread.dateline > 315532800;

MySQL Error : Unknown column 'thread.dateline' in 'where clause'
Error Number : 1054
Request Date : Saturday, October 22nd 2011 @ 05:09:29 AM
Error Date : Saturday, October 22nd 2011 @ 05:09:29 AM
do=xperience_admin_recount_xp
do=recount
Classname : vB_Database
MySQL Version : 5.1.56

Phalynx 10-22-2011 11:23 AM
Quote:
Originally Posted by Sarab (Post 2259921)
Hello,

Thank you for all your great work =)

I was wondering what table & column should I use for vbshop?

Can you tell me please?

Best Regards
Sarab
That will not work, as vBShop does not support vBExperience. Only the Point Market System is currently supporting vBExperience.




Quote:
Originally Posted by ahobilam (Post 2260005)
Thanks for the VBExperience Upgrade info.
I downloaded and installed it. I like this product very much.
But, regarding levels, It always showing only Level 1 for any higher points:
Level completed: 99%,
Points required for next Level: 0
I think, that I have not made proper settings to work this?
Please guide me, can you send your reply through pm?
thanks in advance
You need to install a higher level xml


Quote:
Originally Posted by ahobilam (Post 2260069)
Today I installed the update and tried to do recount
I am getting the following error:
Database error in vBulletin 4.1.7:

Invalid SQL:
SELECT
COUNT(*) AS count_threads,
SUM(votetotal/votenum) AS count_votes,
SUM(replycount) AS count_replycount,
SUM(views) AS count_views,
SUM(sticky) AS count_stickies
FROM brahmins_thread
WHERE visible=1 AND forumid NOT IN(4,5,8)
AND postuserid=1
AND thread.dateline > 315532800;

MySQL Error : Unknown column 'thread.dateline' in 'where clause'
Error Number : 1054
Request Date : Saturday, October 22nd 2011 @ 05:09:29 AM
Error Date : Saturday, October 22nd 2011 @ 05:09:29 AM
do=xperience_admin_recount_xp
do=recount
Classname : vB_Database
MySQL Version : 5.1.56
Quote:
Originally Posted by Megaboost (Post 2259944)
Just updated to 4.1.0 beta and everything works fine apart from the error below when I go to Recount/update experience points.



Any Idea's on a fix?

Please update to Beta 2, just replace class_xperience.php

snowlion 10-22-2011 01:18 PM
I got this error (Beta 2) when update Experience points
Code:

Database error in vBulletin 4.1.4:
Invalid SQL:
SELECT
  COUNT(*) AS count_events
  FROM sty_event
  WHERE visible=1
  AND userid=1
  AND event.dateline > 315532800;
MySQL Error  : Unknown column 'event.dateline' in 'where clause'
Error Number  : 1054
Request Date  : Saturday, October 22nd 2011 @ 09:15:12 AM
Error Date    : Saturday, October 22nd 2011 @ 09:15:13 AM
Script        : admincp/xperience_admin.php?do=xperience_admin_recount_xp
Referrer      : admincp/xperience_admin.php?do=recount
IP Address    : 113.170.3.155
Username      : kisibachda
Classname    : vB_Database
MySQL Version : 5.1.56
Stack Trace:
#0 vB_Database->halt() called in [path]/includes/class_core.php on line 423
#1 vB_Database->execute_query() called in [path]/includes/class_core.php on line 456
#2 vB_Database->query_read() called in [path]/includes/class_xperience.php on line 227
#3 xPerience->CalculateXP() called in [path]/admincp/xperience_admin.php on line 287

digicom 10-22-2011 03:27 PM
After updating to 4.1.0 beta 2 i recieve this error when i try to Update Experience Points.
Any help would be apprciated,Thanks
Code:
Database error in vBulletin 4.1.4:
Invalid SQL:
SELECT
SUM(totaldownloads) as sum_downloads
FROM dl2_files
WHERE uploaderid=1
AND dl2_files.date > 315532800
GROUP BY uploaderid;

MySQL Error  : Unknown column 'dl2_files.date' in 'where clause'
Error Number  : 1054
Request Date  : Saturday, October 22nd 2011 @ 04:18:29 PM
Error Date    : Saturday, October 22nd 2011 @ 04:18:32 PM
Script        : /admincp/xperience_admin.php?do=xperience_admin_recount_xp
Referrer      : /admincp/xperience_admin.php?do=recount
Classname    : vB_Database
MySQL Version : 5.1.56

Phalynx 10-22-2011 05:58 PM
Please download Beta 3 and replace class_xperience.php
Also, if you have some vBExperience plugins installed, please install new version!

digicom 10-22-2011 06:37 PM
Hi Phalynx i updated to 4.1.0 beta 3 and still recieved a error when i tryed to Update Experience Points.
Code:
Database error in vBulletin 4.1.4:
Invalid SQL:
SELECT
            SUM(totaldownloads) as sum_downloads
            FROM dl2_files
            WHERE uploaderid=1
            AND date > 315532800
            GROUP BY uploaderid;

MySQL Error  : Unknown column 'date' in 'where clause'
Error Number  : 1054
Request Date  : Saturday, October 22nd 2011 @ 07:32:43 PM
Error Date    : Saturday, October 22nd 2011 @ 07:32:46 PM
Script        : admincp/xperience_admin.php?do=xperience_admin_recount_xp
Referrer      :admincp/xperience_admin.php?do=recount
Classname    : vB_Database
MySQL Version : 5.1.56

Phalynx 10-22-2011 06:59 PM
Ok, there were a change of that column from "date" to "dateadd". Still I was using v5 of DownloadsII. Please update the class_xperience.php of the new added ZIP.

digicom 10-22-2011 07:19 PM
Much apprciated Phalynx Experience Points now updating ok :up:

Quote:
Originally Posted by Phalynx (Post 2260264)
Ok, there were a change of that column from "date" to "dateadd". Still I was using v5 of DownloadsII. Please update the class_xperience.php of the new added ZIP.

hakkuo23 10-22-2011 08:52 PM
Tried to recalculate Experience:
Code:
Database error in vBulletin 4.1.7:

Invalid SQL:
SELECT
                                SUM(points) AS sum_points
                                FROM vb_infraction
                                WHERE action<>2 AND userid=1
                                AND infraction.dateline > 315532800;

MySQL Error  : Unknown column 'infraction.dateline' in 'where clause'
Error Number  : 1054
Request Date  : Saturday, October 22nd 2011 @ 02:52:11 PM
Error Date    : Saturday, October 22nd 2011 @ 02:52:11 PM
Script        : http://xxx/admincp/xperience_admin.php?do=xperience_admin_recount_xp
Referrer      : http://xxx/admincp/xperience_admin.php?do=recount
IP Address    :
Username      : silence
Classname    : vB_Database_MySQLi
MySQL Version : 5.1.56

Phalynx 10-22-2011 10:48 PM
Please update to Beta 4, just replace class_xperience.php

vanquish.securi 10-23-2011 12:51 AM
Uploaded the class_xperience.php like you said for beta 4. Went to recount for experience and got this:

Quote:
Database error in vBulletin 4.1.7:

Invalid SQL:
SELECT
SUM(yesno) AS sum_answers
FROM helpfulanswer as h
INNER JOIN post AS p ON p.postid=h.postid
WHERE p.userid=1
AND post.dateline > 315532800
GROUP BY p.userid;

MySQL Error : Unknown column 'post.dateline' in 'where clause'
Error Number : 1054
Request Date : Saturday, October 22nd 2011 @ 08:49:59 PM
Error Date : Saturday, October 22nd 2011 @ 08:49:59 PM
Script : http://www.vanquishcoding.com/commun...min_recount_xp
Referrer : http://www.vanquishcoding.com/commun...php?do=recount
IP Address :

hakkuo23 10-23-2011 12:54 AM
LOL Will the db errors every end xD

hakkuo23 10-23-2011 02:09 AM
Code:
Database error in vBulletin 4.1.7:

Invalid SQL:
SELECT *
                FROM vb_xperience_level
                WHERE xperience_points<8170
                ORDER BY xperience_points DESC LIMIT 0,1;

MySQL Error  : Table 'xxx.vb_xperience_level' doesn't exist
Error Number  : 1146
Request Date  : Saturday, October 22nd 2011 @ 08:08:25 PM
Error Date    : Saturday, October 22nd 2011 @ 08:08:26 PM
Script        : http://xenogamers.org/admincp/xperience_admin.php?do=xperience_admin_recount_xp
Referrer      : http://xenogamers.org/admincp/xperience_admin.php?do=recount
Username      : silence
Classname    : vB_Database_MySQLi
MySQL Version : 5.1.56

Phalynx 10-23-2011 05:16 PM
Quote:
Originally Posted by vanquish.securi (Post 2260373)
Uploaded the class_xperience.php like you said for beta 4. Went to recount for experience and got this:
Please install the plugin Helpful_Answers.xml from Beta 4 ZIP!

Quote:
Originally Posted by hakkuo23 (Post 2260401)
Code:
Database error in vBulletin 4.1.7:

Invalid SQL:
SELECT *
                FROM vb_xperience_level
                WHERE xperience_points<8170
                ORDER BY xperience_points DESC LIMIT 0,1;

MySQL Error  : Table 'xxx.vb_xperience_level' doesn't exist
Error Number  : 1146
Request Date  : Saturday, October 22nd 2011 @ 08:08:25 PM
Error Date    : Saturday, October 22nd 2011 @ 08:08:26 PM
Script        : http://xenogamers.org/admincp/xperience_admin.php?do=xperience_admin_recount_xp
Referrer      : http://xenogamers.org/admincp/xperience_admin.php?do=recount
Username      : silence
Classname    : vB_Database_MySQLi
MySQL Version : 5.1.56
Did you installed already a level file?

hakkuo23 10-23-2011 09:25 PM
oops lol. Seems disabling vbX removed the level plugin. Thanks!

vanquish.securi 10-24-2011 12:26 PM
Quote:
Originally Posted by Phalynx (Post 2260605)
Please install the plugin Helpful_Answers.xml from Beta 4 ZIP!
Ok installed the Helpful Answers and that fixed that issue. Atempted to do a recount again and now got this:

Quote:
Database error in vBulletin 4.1.7:

Invalid SQL:
SELECT
SUM(bet_amount_won) AS sumbets
FROM vbookie_bets_placed
WHERE bet_settled='Y' AND userid=1
AND dateline > 315532800
GROUP BY userid;

MySQL Error : Unknown column 'dateline' in 'where clause'
Error Number : 1054
Request Date : Monday, October 24th 2011 @ 08:23:00 AM
Error Date : Monday, October 24th 2011 @ 08:23:00 AM
Script : http://www.vanquishcoding.com/commun...min_recount_xp
Referrer : http://www.vanquishcoding.com/commun...php?do=recount
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.0.92-community

I saw that it was giving an error about vBookie, so I downloaded the beta 4 vbookie mod and checked over write thinking that would fix it, but it did not.

weexto 10-24-2011 06:32 PM
hello,
I seek the opportunity to change the start date of the contest .... is that possible?
best regards
w

StonePilot 10-26-2011 01:37 AM
My members have been asking about this, but I'm wait until I hear from more people that it's stable. I've got enough problems that are stealing all of my time.


All times are GMT. The time now is 05:16 AM.
Page 52 of 68 « First 2425051 52 535462 Last »
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02918 seconds
  • Memory Usage 1,864KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (6)bbcode_code_printable
  • (20)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete