Here's a bug, when you put a value for points to 0 (such as days) it messes up the query causing an error when updating counters.
UPDATE vB_xperience_stats
SET
points_thread=252,
points_threads=80,
points_thread_votes=0,
points_thread_replycount=61.2,
points_thread_views=56.4,
points_thread_stickies=50,
points_post=434,
points_posts=406,
points_post_thanks=0,
points_user=16,
points_user_infractions=0,
points_user_reputation=10,
points_user_online=,
points_user_socialgroup=0,
points_user_visitormessages=3,
points_user_albumpictures=3,
points_post_attachment=28.5,
points_thread_tags=5,
points_misc=0,
points_misc_ldm=0,
points_misc_dl2=0,
points_misc_ppg=0,
points_user_referrals=0,
points_misc_ppd=0,
dateline=1204305480
WHERE userid=1;
|