AAC Reset promoted vocations to normal vocations

[ralke]

Hi guys! I have reset the server with this query AAC - Create season rank based on highscores (https://otland.net/threads/create-season-rank-based-on-highscores.282083/#post-2704573) but the vocations remain as promoted ones. Someone know how could I reset vocations to non-promoted ones with sql queries? Thanks in advance!

 

[lukaszml]

This query does not have a setter for vocation.If you want remain vocations but just downgrade from promoted state then check if voc is >4, and if yes then substract 4.
So if MS is 5 and Sorcerer is 1 after substracting 5-4 will be 1 again.

 

[ralke]

This query does not have a setter for vocation.If you want remain vocations but just downgrade from promoted state then check if voc is >4, and if yes then substract 4.
So if MS is 5 and Sorcerer is 1 after substracting 5-4 will be 1 again.

Thanks! Any idea of how the query should exactly be?
I'm worried of not screwing the database, otherwise, patching it back is a pain

Thanks in advance
Regards!

 

[Extrodus]

No need to over think it, always back up your DB before changes so you can be as wreckless as you want <3
PhpMyAdmin -> Select DB -> Select Export from top -> Save .db file named BeforeSystemName.db
Now you will always have a backup of the database "before adding system" ;D

UPDATE `players` SET `vocation` = 1 WHERE `vocation`= 5;
UPDATE `players` SET `vocation` = 2 WHERE `vocation`= 6;
UPDATE `players` SET `vocation` = 3 WHERE `vocation`= 7;
UPDATE `players` SET `vocation` = 4 WHERE `vocation`= 8;