Thread: Add-On Releases - vBExperience
View Single Post
  #1217  
Old 06-28-2008, 07:21 PM
redg8r redg8r is offline
 
Join Date: May 2006
Posts: 7
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
I'm having ALOT of trouble utilizing the promotion system.

I have over 7000 members (using recommended level 3 "big" xml)
installed, ran counter, stats look good, now I want to promote existing members

I edited a copy of the same xml file (level 3)
default 100 levels:
levels 0-33 = no change, stay in usergroup 2 (default registered members)
levels 34-66 = promote to usergroup (id 32)
levels 67-100 = promote usergroup (id 33)

Code:
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (50,1,2)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (100,2,2)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (150,3,2)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (200,4,2)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (250,5,2)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (300,6,2)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (400,7,2)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (500,8,2)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (600,9,2)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (700,10,2)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (800,11,2)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (950,12,2)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (1100,13,2)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (1250,14,2)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (1400,15,2)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (1550,16,2)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (1750,17,2)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (1950,18,2)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (2150,19,2)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (2350,20,2)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (2550,21,2)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (2800,22,2)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (3050,23,2)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (3300,24,2)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (3550,25,2)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (3800,26,2)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (4100,27,2)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (4400,28,2)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (4700,29,2)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (5000,30,2)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (5300,31,2)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (5650,32,2)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (6000,33,2)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (6350,34,32)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (6700,35,32)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (7050,36,32)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (7450,37,32)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (7850,38,32)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (8250,39,32)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (8650,40,32)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (9050,41,32)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (9500,42,32)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (9950,43,32)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (10400,44,32)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (10850,45,32)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (11300,46,32)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (11800,47,32)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (12300,48,32)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (12800,49,32)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (13300,50,32)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (13800,51,32)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (14350,52,32)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (14900,53,32)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (15450,54,32)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (16000,55,32)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (16550,56,32)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (17150,57,32)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (17750,58,32)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (18350,59,32)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (18950,60,32)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (19550,61,32)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (20200,62,32)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (20850,63,32)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (21500,64,32)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (22150,65,32)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (22800,66,32)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (23500,67,33)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (24200,68,33)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (24900,69,33)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (25600,70,33)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (26300,71,33)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (27050,72,33)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (27800,73,33)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (28550,74,33)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (29300,75,33)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (30050,76,33)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (30850,77,33)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (31650,78,33)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (32450,79,33)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (33250,80,33)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (34050,81,33)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (34900,82,33)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (35750,83,33)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (36600,84,33)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (37450,85,33)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (38300,86,33)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (39200,87,33)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (40100,88,33)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (41000,89,33)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (41900,90,33)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (42800,91,33)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (43750,92,33)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (44700,93,33)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (45650,94,33)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (46600,95,33)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (47550,96,33)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (48550,97,33)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (49550,98,33)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (50550,99,33)");
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "xperience_level (xperience_points, xperience_level, usergroupid) VALUES (52000,100,34)");
Uploaded the xml (chose overwrite)
Deleted existing exp stats
re-ran the counters to populate the usergroups.............. no change
Yes I activated the vbexp promotion system & had no existing native VB promotions to conflict with.

Any ideas?
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01248 seconds
  • Memory Usage 1,863KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete