PDA

View Full Version : Any way to convert points?


RDX1
04-29-2006, 10:51 AM
Okay, weird request. I set up my points weird, is there any way to convert the points to a different, or recalculate points on the new setting? Users have points in the thousands and I would rather have actions cost less points and change those points to the new values. I don't want to wipe all their points.

CMX_CMGSCCC
04-30-2006, 07:59 PM
Unfortunately not at this time.

There are a couple options u could play with --> Admin CP -> vbBux -> Mass Points Giveaway.. u could set their points equal to the number of posts they have?

-CMX

RDX1
04-30-2006, 08:54 PM
The easiest way IMO is just a script that divides the points by whatever number you choose. If someone has 20,000 points you can divide them down 1/10th to 2,000 points. I don't know if anyone would use this, but I would be grateful if you added something like this.

Also can't wait for the real item store.

CMX_CMGSCCC
04-30-2006, 09:11 PM
You could do that in a query though...


UPDATE (TABLE_PREFIX)user SET vbbux = vbbux / 10;


-CMX

RDX1
04-30-2006, 10:26 PM
Oh really? Sweet. So that would divide the points by 10 for everyone? I'll have to try that out on a test copy.

I ran this and it only removed around 200 points.

UPDATE user SET vbbux = vbbux / 5;

CMX_CMGSCCC
05-01-2006, 12:10 AM
That would take their points down to 20% of what they were before.

-CMX