The Arcive of vBulletin Modifications Site. |
|
Reset ALL users to 0 point? Details »»
|
|||||||||||||||||||||||||
Any know how to do this?
Show Your Support
|
|||||||||||||||||||||||||
| Comments |
|
#2
|
||||
|
||||
|
[sql]UPDATE user SET uttpoints='0';[/sql]
|
|
#3
|
||||
|
||||
|
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 |
|
#4
|
|||
|
|||
|
Are you using a table prefix? If yes, add it before the tablename.
|
|
#5
|
||||
|
||||
|
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'; |
![]() |
|
|