How can i set all my users to specific point?

[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?

[Link14716]

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?
UPDATE user SET uttpoints=uttpoints+'X';

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:
UPDATE user SET uttpoints=X;

[turkforum]

thank you... :)