How can i set all my users to specific point?

Right now, i am using vBulletin Version 3.0.7
And installed your latest version. It is great hack..

Now, i have about 55.000 members and their points way up..
how can i set my all members' points to 1.000.000 lets say?
is there a db code for this?

[Link14716]

Originally Posted by turkforum

Right now, i am using vBulletin Version 3.0.7
And installed your latest version. It is great hack..

Now, i have about 55.000 members and their points way up..
how can i set my all members' points to 1.000.000 lets say?
is there a db code for this?

[sql]UPDATE user SET uttpoints=uttpoints+'X';[/sql]

Change X to the amount of points (without the thousand seperator) you want to give.

[turkforum]

this did not RESET the points to 100
it adds what ever they have 100 points.

please advice

[Marco van Herwaarden]

Then use:
[sql]UPDATE user SET uttpoints=X;[/sql]

[turkforum]

thank you...