From 5f601f53b8374ead5a6a8b734054ea623f74c24e Mon Sep 17 00:00:00 2001 From: Shauren Date: Mon, 11 Jul 2022 20:35:36 +0200 Subject: Core/WorldStates: Migrate pvp season worldstates to new system --- sql/updates/world/master/2022_07_11_02_world.sql | 7 +++++++ 1 file changed, 7 insertions(+) create mode 100644 sql/updates/world/master/2022_07_11_02_world.sql (limited to 'sql/updates') 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'); -- cgit v1.2.3