Add premium days in MYSQL

[arturhaddad]

My server went down for 6 days and i want to add 6 premium days to everybody that was already premium account.

What's the SQL command (is that term right?) ?

Thanks

 

[Pykera]

Players_ADD premium_time 6

I think is that im not sure

 

[arturhaddad]

Hmm, don't think so. Doesn't work

 

[tosuxo]

isn't it more of "UPDATE table blah blah blah"
Josu, you're more clueless than me with sql databases...

 

[bolero]

UPDATE `accounts` SET `premdays` = `premdays` + 6 WHERE `premdays` >= 1

Rep++

 

[tosuxo]

UPDATE `accounts` SET `premdays` = `premdays` + 6 WHERE `premdays` >= 1

Rep++

that's the ticket

 

[arturhaddad]

That's what i mean bolero
Thanks, rep'd