Core/WorldStates: Migrate Wintergrasp worldstates to new system

1 files changed, 54 insertions, 0 deletions

diff --git a/sql/updates/world/master/2022_06_26_01_world.sql b/sql/updates/world/master/2022_06_26_01_world.sql
new file mode 100644
index 00000000000..84c54e33a8e
--- /dev/null
+++ b/sql/updates/world/master/2022_06_26_01_world.sql
@@ -0,0 +1,54 @@
+DELETE FROM `world_state` WHERE `ID` IN (3490,3491,3680,3681,3698,3699,3700,3701,3702,3703,3704,3705,3706,3710,3711,3712,3713,3714,3749,3750,3751,3752,3753,3754,3755,3756,3757,3758,3759,3760,3761,3762,3763,3764,3765,3766,3767,3768,3769,3770,3771,3772,3773,3781,3801,3802,3803,4022,4023,4024,4025,4354);
+INSERT INTO `world_state` (`ID`,`DefaultValue`,`MapIDs`,`Comment`) VALUES
+(3490,0,'571,2118','Wintergrasp - Number of Horde vehicles'),
+(3491,0,'571,2118','Wintergrasp - Horde vehicle limit'),
+(3680,0,'571,2118','Wintergrasp - Number of Alliance vehicles'),
+(3681,0,'571,2118','Wintergrasp - Alliance vehicle limit'),
+(3698,0,'571,2138','Wintergrasp - Workshop'),
+(3699,0,'571,2138','Wintergrasp - Workshop'),
+(3700,0,'571,2138','Wintergrasp - Workshop'),
+(3701,0,'571,2138','Wintergrasp - Workshop'),
+(3702,0,'571,2138','Wintergrasp - Workshop'),
+(3703,0,'571,2138','Wintergrasp - Workshop'),
+(3704,0,'571,2138','Wintergrasp - Tower'),
+(3705,0,'571,2138','Wintergrasp - Tower'),
+(3706,0,'571,2138','Wintergrasp - Tower'),
+(3710,0,'571,2118','Wintergrasp - Show timer to battle end'),
+(3711,0,'571,2138','Wintergrasp - Keep tower'),
+(3712,0,'571,2138','Wintergrasp - Keep tower'),
+(3713,0,'571,2138','Wintergrasp - Keep tower'),
+(3714,0,'571,2138','Wintergrasp - Keep tower'),
+(3749,0,'571,2119','Wintergrasp - Wall'),
+(3750,0,'571,2120','Wintergrasp - Wall'),
+(3751,0,'571,2121','Wintergrasp - Wall'),
+(3752,0,'571,2122','Wintergrasp - Wall'),
+(3753,0,'571,2123','Wintergrasp - Wall'),
+(3754,0,'571,2124','Wintergrasp - Wall'),
+(3755,0,'571,2125','Wintergrasp - Wall'),
+(3756,0,'571,2126','Wintergrasp - Wall'),
+(3757,0,'571,2127','Wintergrasp - Wall'),
+(3758,0,'571,2128','Wintergrasp - Wall'),
+(3759,0,'571,2129','Wintergrasp - Wall'),
+(3760,0,'571,2130','Wintergrasp - Wall'),
+(3761,0,'571,2131','Wintergrasp - Wall'),
+(3762,0,'571,2132','Wintergrasp - Wall'),
+(3763,0,'571,2138','Wintergrasp - Keep gate'),
+(3764,0,'571,2133','Wintergrasp - Wall'),
+(3765,0,'571,2134','Wintergrasp - Wall'),
+(3766,0,'571,2134','Wintergrasp - Wall'),
+(3767,0,'571,2135','Wintergrasp - Wall'),
+(3768,0,'571,2134','Wintergrasp - Wall'),
+(3769,0,'571,2136','Wintergrasp - Wall'),
+(3770,0,'571,2134','Wintergrasp - Wall'),
+(3771,0,'571,2134','Wintergrasp - Wall'),
+(3772,0,'571,2138','Wintergrasp - Wall'),
+(3773,0,'571,2138','Wintergrasp - Relic gate'),
+(3781,0,'571,2118','Wintergrasp - Battle end time'),
+(3801,0,'571,2118','Wintergrasp - Show timer for next battle'),
+(3802,0,'571,2118','Wintergrasp - Defender'),
+(3803,0,'571,2118','Wintergrasp - Attacker'),
+(4022,0,'571,2118','Wintergrasp - Number of Horde wins as attacker'),
+(4023,0,'571,2118','Wintergrasp - Number of Alliance wins as attacker'),
+(4024,0,'571,2118','Wintergrasp - Number of Horde wins as defender'),
+(4025,0,'571,2118','Wintergrasp - Number of Alliance wins as defender'),
+(4354,0,'571,2118','Wintergrasp - Next battle start time');