![]() |
Reset ALL users to 0 point?
Any know how to do this?
|
[sql]UPDATE user SET uttpoints='0';[/sql]
|
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 |
Are you using a table prefix? If yes, add it before the tablename.
|
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'; |
All times are GMT. The time now is 08:11 AM. |
Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|