diff options
| author | Shauren <shauren.trinity@gmail.com> | 2022-07-11 20:35:36 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2022-07-11 20:35:36 +0200 |
| commit | 5f601f53b8374ead5a6a8b734054ea623f74c24e (patch) | |
| tree | 0f7303c357dd385dd1bdf0ce91fd98d683bcb919 /sql | |
| parent | 020166649dd5afb94dddbfcc990d4bb51e231ab1 (diff) | |
Core/WorldStates: Migrate pvp season worldstates to new system
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2022_07_11_02_world.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_07_11_02_world.sql b/sql/updates/world/master/2022_07_11_02_world.sql new file mode 100644 index 00000000000..136c8958bb4 --- /dev/null +++ b/sql/updates/world/master/2022_07_11_02_world.sql @@ -0,0 +1,7 @@ +UPDATE `world_state` SET `Comment`='Battlegrounds - Horde bases' WHERE `ID`=1778; +UPDATE `world_state` SET `Comment`='Battlegrounds - Alliance bases' WHERE `ID`=1779; + +DELETE FROM `world_state` WHERE `ID` IN (3191,3901); +INSERT INTO `world_state` (`ID`,`DefaultValue`,`MapIDs`,`AreaIDs`,`ScriptName`,`Comment`) VALUES +(3191,0,NULL,NULL,'','PvpSeason - Current season ID'), +(3901,0,NULL,NULL,'','PvpSeason - Previous season ID'); |