Reset ALL users to 0 point?

[ranger2kxlt]

Any know how to do this?

[Link14716]

Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------

[djjeffa]

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]

Are you using a table prefix? If yes, add it before the tablename.

[marinefiend]

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';