[HOW TO:] Reset Points & Bank To Specific Amount

[Freesteyelz]

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

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

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:

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:

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

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


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