vb.org Archive - Major Additions

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)

Quote:

Originally Posted by Phalynx (Post 2078170)

Thanks :)

Attention to vBookie Users:
There is a new version of the vBookie integration. It fixes the problems by using vBExperience as a cash provider.
Please download this product and install it.

Thanks Phalynx.

Working great.

:D

Man, I'm still getting tons of sql errors. It looks like it happens when the cronjob runs.

Quote:

Database error in vBulletin 4.0.5:

Invalid SQL:
SELECT
P.userid, COUNT(userid) AS times
FROM thread AS T
INNER JOIN post AS P ON T.lastpostid=P.postid
WHERE P.userid=1853
GROUP BY P.userid
ORDER BY P.dateline DESC, P.userid;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Monday, August 2nd 2010 @ 08:22:58 PM
Error Date : Monday, August 2nd 2010 @ 08:24:02 PM
Script : xxx/forums/cron.php?rand=913204
Referrer : http://www.onlinedebate.net/
IP Address : xxxx
Username : Unregistered
Classname : vB_Database
MySQL Version :

Until the cronjob sql error is resolved, I have to disable this modification. Great mod...just not working for my community for some reason. I even edited the cronjob's time to go every 20 mins (vs 10)...still didn't help.

Quote:

Originally Posted by apokphp (Post 2078301)

Found the points area, thanks. I optimized what I could (by changing point values to zero on some activities...if that does anything).

However, a few questions:

1) When do you recommend recounting the Achievements? How do you know when you should recount them?

In normal case - never. This is just required if you changed something, for example added a new achievement.

Quote:

Originally Posted by apokphp (Post 2078301)

2) Also, for the option "Limit the Award to a position in query; Use 0 for GOLD Award, 1 for Silver, etc..."...where you can select Gold, Silver or Bronze, what exactly does this mean?

With this setting you can define multiple awards like first, second and third place

Quote:

Originally Posted by apokphp (Post 2078301)

3) For the "Referrals" activity...the award is not matching up with what shows in the statistics. The award winner isn't even close to being in the top 3. What's going on?

btw, thanks for the terrific support. Like others have said...it's probably the best supported mod here.

How many awards did you enabled for one user? Depending on that setting it can be that a user gets another award.

Quote:

Originally Posted by DS MrSinister (Post 2078363)

Thanks Phalynx.

Working great.

:D

Great news, I will add to the official ZIP. Thanks!

Quote:

Originally Posted by apokphp (Post 2078371)

Man, I'm still getting tons of sql errors. It looks like it happens when the cronjob runs.

vBExperience is only recounting via cronjob.

Quote:

Originally Posted by apokphp (Post 2078380)

It seems your server or just the SQL server is not able to handle it. I got this "server gone" error whenever MySQL reached the limit for open connections. Did you tried already to use persistent connections? ("usepconnect" in config.php)

I've updated the ZIP with the working vBookie integration.
If you want to use vBExperience as a cash system for vBookie, you need to install ZIP\extras\Addons\vBookie.xml
Existing installations can be upgraded.

No other changes have been included, so no need to update the main product.

how do we enable users to be able to bet their vBExperience on vBookie?

I looked at the vBookie settings in AdminCP >> Settings >> Options >> vBookie Settings but it did not show vBExperience as a Cash/Points system :S

Quote:

Originally Posted by doobiefillin (Post 2078556)

Choose "Custom".

Consuming points by downloading attachments ("pay" for attachments) (plugin) --> fixed?

Yes, i imported a level file, how to solve it?

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (9)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (5)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)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
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02892 seconds Memory Usage 1,746KB 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 (9)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (5)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)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
Messages: