vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.7 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=228)
-   -   Add-On Releases - vBExperience (https://vborg.vbsupport.ru/showthread.php?t=171014)

maidos 02-29-2008 01:55 PM

thanks for the update but is it possible to move the bars below the post count

maidos 02-29-2008 02:06 PM

how goes the promotion for points and level for vbexperience level 70

Paradigm 02-29-2008 02:07 PM

I installed the update (allowing it to overwrite the files) and when I went to update the counters I get this Database error:

Database error in vBulletin 3.7.0 Beta 5:

Code:

Invalid SQL:
UPDATE vbxperience_stats
                SET
                points_thread=0,
                points_threads=0,
                points_thread_votes=0,
                points_thread_replycount=0,
                points_thread_views=0,
                points_thread_stickies=0,
                points_post=0,
                points_posts=0,
                points_post_thanks=,
                points_user=1373,
                points_user_infractions=0,
                points_user_reputation=100,
                points_user_online=1273.69496528,
                points_user_socialgroup=0,
                points_user_visitormessages=0,
                points_user_albumpictures=0,
                points_post_attachment=0,
                points_thread_tags=0,
                points_misc=0,
                points_misc_ldm=0,
                points_misc_dl2=0,
                points_misc_ppg=0,
                points_user_referrals=0,
                points_misc_ppd=0,
                dateline=1204301100       
                WHERE userid=1;

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 '
                points_user=1373,
                points_user_infractions=0,
                points_user_reputation=10' at line 11
Error Number  : 1064
Date          : Saturday, March 1st 2008 @ 01:05:41 AM
Script        : http://www.bigonline.org/admincp/misc.php?do=xperience_recount_xp
Referrer      : http://www.bigonline.org/admincp/misc.php?do=chooser
Username      : Paradigm
Classname    : vB_Database
MySQL Version : 4.1.22-standard-log


Phalynx 02-29-2008 02:19 PM

Quote:

Originally Posted by maidos (Post 1453671)
thanks for the update but is it possible to move the bars below the post count

Edit the template postbit/postbit_legacy and move $template_hook[postbit_userinfo_left] where you will have it.


Quote:

Originally Posted by maidos (Post 1453680)
how goes the promotion for points and level for vbexperience level 70

You decide, take a look at the Excel Sheet. You have to enter there the usergroupid's.

Quote:

Originally Posted by Paradigm (Post 1453681)
I installed the update (allowing it to overwrite the files) and when I went to update the counters I get this Database error:

Fixed. Please download ZIP and overwrite class_xperience.php. Please let me also know if the PayPal addition works.

Paradigm 02-29-2008 02:22 PM

On my way to do that now. Thanks for the fast fix!!

Paradigm 02-29-2008 02:27 PM

That fixed the Database error. Testing the paypal function now.

maidos 02-29-2008 02:27 PM

its the wrong code $template_hook[postbit_userinfo_left]

when i delete it teh nav bars is still there

maidos 02-29-2008 02:38 PM

also i dont know how to edit the exel something :S
i tried editing with the usegroup 6,7,2,5,1,20,13,11,17,12,9,14,19,18,22
but nothing happends every member are still on level 1

Paradigm 02-29-2008 02:47 PM

Ok, from what I can tell it has not worked. I set the points per donation unit (which is in USD) to 20. I made a $15 donation, confirmed it and then updated the counters. I then went to the xperience tab in my profile to see if I had received 300 points but I didn't. Also under the xperience tab in the profiles shouldn't there be a section that says Points for donations just like it says points for posts and threads?

Mephisteus 02-29-2008 03:44 PM

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;


All times are GMT. The time now is 12:55 PM.

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.02915 seconds
  • Memory Usage 1,745KB
  • 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
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (4)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