[SQL] SQL command to all shop points to all players on server

[Xevis]

Hello! I need SQL Command to add premium points to all players on server.


Thanks!

rep rep rep ;>

 

[GarQet]

update `account` set `premium_points` = `premium_points` + NUMBEROFPOINTS;

 

[Xevis]

Błąd
zapytanie SQL:
pdate `account` SET `premium_points` = `premium_points` +50
MySQL zwrócił komunikat: http://localhost/phpmyadmin/themes/original/img/b_help.png
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'pdate `account` set `premium_points` = `premium_points` + 50' at line 1

 

[GarQet]

update `accounts` set `premium_points` = `premium_points` + 50;

 

[Xevis]

Works!
thanks rep+

please close!

 

[skenchu]

and in shop system you can give players donation points if you have admin rights on the AAC

 

[God Mythera]

sql command to make all points to 0?

 

[imkingran]

sql command to make all points to 0?

UPDATE `accounts` SET `premium_points` = 0;

 

[God Mythera]

UPDATE `accounts` SET `premium_points` = 0;

Thank you a bunch man