[Help]500k ep Query

05/24/2010 20:02 WickedSweet#1
Yes i told my Players if we got rank 1 in vote sites each site we had it i would give them 500k eps.


So i was curious how would i make a script to award all players 500k eps?
05/24/2010 20:29 KikkenF#2
Well should be like this,

Code:
UPDATE cq_user set emoney=+500000;
But i tryed on my server and well in spite of adding, it changes to that value.

So now im curious too.
05/24/2010 20:39 WickedSweet#3
lol ya
05/24/2010 20:52 Eurion#4
Quote:
Originally Posted by KikkenF View Post
Well should be like this,

Code:
UPDATE cq_user set emoney=+500000;
But i tryed on my server and well in spite of adding, it changes to that value.

So now im curious too.
Close :) It should be something like.

Code:
UPDATE cq_user SET emoney=emoney+ 500000;
05/24/2010 21:20 KikkenF#5
I though += would work but it doesnt.

And yeah forgot that count formula (x=x+1).
05/24/2010 22:31 King_Arthur#6
Going along with what KikkenF just said, += works if you coding your cq_action. You can't use cq_action syntax with mysql guys. :p

Eurion's query is the correct query to use.
Quote:
Originally Posted by Eurion View Post
Close :) It should be something like.

Code:
UPDATE cq_user SET emoney=emoney+ 500000;