View Full Version : Reset ALL users to 0 point?
ranger2kxlt
01-12-2005, 08:21 PM
Any know how to do this?
Link14716
01-12-2005, 09:24 PM
UPDATE user SET uttpoints='0';
djjeffa
01-23-2005, 10:13 PM
I tried and got this:
An error occurred while attempting to execute your query. The following information was returned.
error number: 1146
error desc: Table 'djjeffa_djjeffaVB.user' doesn't exist
Marco van Herwaarden
01-24-2005, 03:20 AM
Are you using a table prefix? If yes, add it before the tablename.
marinefiend
02-01-2005, 09:51 AM
Hmmm?
Get this error when I run the script
#1146 - Table 'aquarium_forum.user' doesn't exist
is there something I am mising in the querry?
Ha got it
Stupid me just realized what I was doing wrong
UPDATE `this is where you put you table prefix with the _user` SET uttpoints='0';
Also if you want to reset the bank to zero
UPDATE `this is where you put you table prefix with the _user` SET uttstore_bankdata='0';
and
UPDATE `this is where you put you table prefix with the _user` SET uttstore_bankqueue='0';
vBulletin® v3.8.12 by vBS, Copyright ©2000-2024, vBulletin Solutions Inc.