vb.org Archive - Add-On Releases

Database error in vBulletin 3.8.3:



Invalid SQL:

UPDATE setting SET value= WHERE varname='xperience_avgppd';



MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE varname='xperience_avgppd'' at line 1

Error Number  : 1064

Request Date  : Monday, August 31st 2009 @ 02:55:04 PM

Error Date    : Monday, August 31st 2009 @ 02:55:04 PM

Script        : http://www.sandboxgamers.net/forum/admincp/xperience_admin.php?do=xperience_admin_recount_ppd

Referrer      : http://www.sandboxgamers.net/forum/admincp/xperience_admin.php?do=recount

IP Address    : 65.115.209.2

Username      : Bleed0ut

Classname     : vB_Database

MySQL Version : 5.0.81-community

Phalynx

08-31-2009 07:06 PM

What is your PPD Timeframe?

Bleed0ut

08-31-2009 07:10 PM

Heres my full settings:

Average Posts Per Day: 0 (Set automaticly, not by me)
Timeframe for activity: 10
Include User's Posts: No
Include Users Blog: No
Include Users Visitor Mess: No
Include Users Social Group: No
Include Users Last Activity Date: Yes (Which doesn't seem to be working, but I'm not sure)

Phalynx

08-31-2009 07:34 PM

That's the fault. Last Activity Date does not increase the PPD, it's decreasing it. For every day the user is not online (in the timeframe), it's decrease in 0.1 steps.
As you disabled all calculations, the PPD is 0.

This cannot work.

Bleed0ut

08-31-2009 07:51 PM

Ah so your saying I have to have at least one thing active. Ok, so if I set Include User's Posts: Yes and recount I still have PPD of 0 is that normal?

Phalynx

08-31-2009 08:33 PM

No, it's not normal. Do you have any forums/users on exception list?

BostWick-x

08-31-2009 09:15 PM

Is there any way that I can limit what types of points that my users give to each other? I only want them to be able to give custom points to each other.

The reason being is that I want the points for posts, etc. to be the way of measuring their experience, but I want the custom points to be their spendable money, as it's the only currency that's accepted in the shop.

Thanks, and great mod. My members absolutely love it. :)

Bleed0ut

08-31-2009 09:22 PM

Phalynx. I have one or 2 users on exception list (Due to them being RSS Bots) and no forums are on it. Do I need to take them off? I think I have ignore inactive users set to if that makes a difference.

Bleed0ut

08-31-2009 09:24 PM

Just to verify I have one user disabled (Due to being a Bot) and Only Active Users set to Yes.
Thanks for any help.

All times are GMT. The time now is 08:05 AM.

Page 123 of 227

123

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02784 seconds Memory Usage 1,737KB 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 (1)bbcode_code_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (6)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: