DB query

[Rury]

Hello otland

my request is simple.


i need query for set 0 promotion to all players!

example

elder druid to druid
master sorcerer to sorcerer
elite knight to knight
royal paladin to paladin

 

[Nottinghster]

If you database have field 'promotion' in table players, use this command:

UPDATE players SET promotion = 0;

 

[Rury]

thx