The Arcive of vBulletin Modifications Site.

[HOW TO:] Reset Points & Bank To Specific Amount · **Released**: 03-22-2006

All Steps require SQL Query:
(Back up your database)

How to reset or specify the amount of points per user:

Code:

UPDATE user SET vbbux='x' WHERE userid='y'

X = points; y = User ID; use the Table prefix for "user" if exists

How to reset or specify the amount in the bank per user:

Code:

UPDATE user SET vbbank='x' WHERE userid='y'

X = points; y = User ID; use the Table prefix for "user" if exists

How to reset or specify the amount of points per Usergroup:

Code:

UPDATE user SET vbbux='x' WHERE usergroupid='y'

X = points; y = Usergroup ID; use the Table prefix for "user" if exists

How to reset or specify the amount in the bank per Usergroup

Code:

UPDATE user SET vbbank='x' WHERE usergroupid='y'

X = points; y = Usergroup ID; use the Table prefix for "user" if exists