Core/WorldStates: Migrate battleground worldstates to new system

1 files changed, 298 insertions, 0 deletions

diff --git a/sql/updates/world/master/2022_07_10_00_world.sql b/sql/updates/world/master/2022_07_10_00_world.sql
new file mode 100644
index 00000000000..616bdc6aa53
--- /dev/null
+++ b/sql/updates/world/master/2022_07_10_00_world.sql
@@ -0,0 +1,298 @@
+ALTER TABLE `world_state` MODIFY `MapIDs` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL AFTER `DefaultValue`;
+
+DELETE FROM `world_state` WHERE `ID` IN (601,602,801,804,922,923,1043,1044,1181,1182,1183,1184,1185,1186,1187,1188,1301,1302,1303,1304,1325,1326,1327,1328,1329,1330,1331,1332,1333,1334,1335,1336,1337,1338,1339,1340,1341,1342,1343,1344,1346,1347,1348,1349,1351,
+1352,1355,1356,1357,1358,1359,1360,1361,1362,1363,1364,1365,1366,1367,1368,1370,1371,1372,1373,1374,1375,1376,1377,1378,1379,1380,1381,1382,1383,1384,1385,1387,1388,1389,1390,1392,1393,1394,1395,1545,1546,1547,1581,1582,1601,1664,1767,1768,1769,1770,1772,1773,
+1774,1775,1776,1777,1778,1779,1780,1782,1783,1784,1785,1787,1788,1789,1790,1792,1793,1794,1795,1842,1843,1844,1845,1846,1955,1966,2338,2339,2718,2719,2720,2722,2723,2724,2725,2726,2727,2728,2729,2730,2731,2732,2733,2752,2753,3127,3128,3133,3134,3136,3557,3564,
+3565,3571,3600,3601,3610,3614,3617,3620,3623,3626,3627,3628,3629,3630,3631,3632,3633,3634,3635,3636,3637,3638,3644,3645,3690,3849,3955,3956,4221,4222,4226,4227,4228,4229,4230,4232,4234,4235,4247,4248,4287,4289,4293,4294,4296,4297,4298,4299,4300,4301,4302,4303,
+4304,4305,4306,4307,4308,4309,4310,4311,4312,4313,4314,4315,4317,4318,4319,4320,4321,4322,4323,4324,4325,4326,4327,4328,4339,4340,4341,4342,4343,4344,4345,4346,4347,4348,4352,4353,5834,8524,8529,8799,8805,8808,8809,8863,9808,9809,13401,15480,15481,17303,17322,
+17323,17324,17325,17326,17327,17328,17329,17330,17331,17361,17362,17363,17364,17365,17366,17367,17368,17377,17712,17713,21322,21427);
+INSERT INTO `world_state` (`ID`,`DefaultValue`,`MapIDs`,`AreaIDs`,`ScriptName`,`Comment`) VALUES
+(601,1,'30,2197',NULL,'','Alterac Valley - Drek\'Thar alive'),
+(602,1,'30,2197',NULL,'','Alterac Valley - Vandaar alive'),
+(801,0,'30,2197',NULL,'','Alterac Valley - Irondeep Mine - owner'),
+(804,0,'30,2197',NULL,'','Alterac Valley - Coldtooth Mine - owner'),
+(922,200,'30,2197',NULL,'','Alterac Valley - Stormpike Soldier\'s Blood max'),
+(923,0,'30,2197',NULL,'','Alterac Valley - Stormpike Soldier\'s Blood count'),
+(1043,0,'30,2197',NULL,'','Alterac Valley - Storm Crystals count'),
+(1044,200,'30,2197',NULL,'','Alterac Valley - Storm Crystals max'),
+(1181,1,'30,2197',NULL,'','Alterac Valley - Dun Baldar South Bunker - Owner'),
+(1182,1,'30,2197',NULL,'','Alterac Valley - Dun Baldar North Bunker - Owner'),
+(1183,1,'30,2197',NULL,'','Alterac Valley - Icewing Bunker - Owner'),
+(1184,1,'30,2197',NULL,'','Alterac Valley - Stonehearth Bunker - Owner'),
+(1185,2,'30,2197',NULL,'','Alterac Valley - West Frostwolf Tower - Owner'),
+(1186,2,'30,2197',NULL,'','Alterac Valley - East Frostwolf Tower - Owner'),
+(1187,2,'30,2197',NULL,'','Alterac Valley - Tower Point - Owner'),
+(1188,2,'30,2197',NULL,'','Alterac Valley - Iceblood Tower - Owner'),
+(1301,0,'30,2197',NULL,'','Alterac Valley - Stonehearth Graveyard - Horde Controlled'),
+(1302,1,'30,2197',NULL,'','Alterac Valley - Stonehearth Graveyard - Alliance Controlled'),
+(1303,0,'30,2197',NULL,'','Alterac Valley - Stonehearth Graveyard - In Conflict'),
+(1304,0,'30,2197',NULL,'','Alterac Valley - Stonehearth Graveyard - In Conflict'),
+(1325,1,'30,2197',NULL,'','Alterac Valley - Stormpike Aid Station - Alliance Controlled'),
+(1326,0,'30,2197',NULL,'','Alterac Valley - Stormpike Aid Station - In Conflict'),
+(1327,0,'30,2197',NULL,'','Alterac Valley - Stormpike Aid Station - Horde Controlled'),
+(1328,0,'30,2197',NULL,'','Alterac Valley - Stormpike Aid Station - In Conflict'),
+(1329,0,'30,2197',NULL,'','Alterac Valley - Frostwolf Relief Hut - Alliance Controlled'),
+(1330,1,'30,2197',NULL,'','Alterac Valley - Frostwolf Relief Hut - Horde Controlled'),
+(1331,0,'30,2197',NULL,'','Alterac Valley - Frostwolf Relief Hut - In Conflict'),
+(1332,0,'30,2197',NULL,'','Alterac Valley - Frostwolf Relief Hut - In Conflict'),
+(1333,1,'30,2197',NULL,'','Alterac Valley - Stormpike Graveyard - Alliance Controlled'),
+(1334,0,'30,2197',NULL,'','Alterac Valley - Stormpike Graveyard - Horde Controlled'),
+(1335,0,'30,2197',NULL,'','Alterac Valley - Stormpike Graveyard - In Conflict'),
+(1336,0,'30,2197',NULL,'','Alterac Valley - Stormpike Graveyard - In Conflict'),
+(1337,0,'30,2197',NULL,'','Alterac Valley - Frostwolf Graveyard - Alliance Controlled'),
+(1338,1,'30,2197',NULL,'','Alterac Valley - Frostwolf Graveyard - Horde Controlled'),
+(1339,0,'30,2197',NULL,'','Alterac Valley - Frostwolf Graveyard - In Conflict'),
+(1340,0,'30,2197',NULL,'','Alterac Valley - Frostwolf Graveyard - In Conflict'),
+(1341,0,'30,2197',NULL,'','Alterac Valley - Snowfall Graveyard - Alliance Controlled'),
+(1342,0,'30,2197',NULL,'','Alterac Valley - Snowfall Graveyard - Horde Controlled'),
+(1343,0,'30,2197',NULL,'','Alterac Valley - Snowfall Graveyard - In Conflict'),
+(1344,0,'30,2197',NULL,'','Alterac Valley - Snowfall Graveyard - In Conflict'),
+(1346,0,'30,2197',NULL,'','Alterac Valley - Iceblood Graveyard - Alliance Controlled'),
+(1347,1,'30,2197',NULL,'','Alterac Valley - Iceblood Graveyard - Horde Controlled'),
+(1348,0,'30,2197',NULL,'','Alterac Valley - Iceblood Graveyard - In Conflict'),
+(1349,0,'30,2197',NULL,'','Alterac Valley - Iceblood Graveyard - In Conflict'),
+(1351,1,'30,2197',NULL,'','Alterac Valley - Balinda alive'),
+(1352,1,'30,2197',NULL,'','Alterac Valley - Galvagar alive'),
+(1355,0,'30,2197',NULL,'','Alterac Valley - Coldtooth Mine - Alliance Controlled'),
+(1356,0,'30,2197',NULL,'','Alterac Valley - Coldtooth Mine - Horde Controlled'),
+(1357,1,'30,2197',NULL,'','Alterac Valley - Coldtooth Mine - Kobold Controlled'),
+(1358,0,'30,2197',NULL,'','Alterac Valley - Irondeep Mine - Alliance Controlled'),
+(1359,0,'30,2197',NULL,'','Alterac Valley - Irondeep Mine - Horde Controlled'),
+(1360,1,'30,2197',NULL,'','Alterac Valley - Irondeep Mine - Trogg Controlled'),
+(1361,1,'30,2197',NULL,'','Alterac Valley - Dun Baldar South Bunker - Alliance Controlled'),
+(1362,1,'30,2197',NULL,'','Alterac Valley - Dun Baldar North Bunker - Alliance Controlled'),
+(1363,1,'30,2197',NULL,'','Alterac Valley - Icewing Bunker - Alliance Controlled'),
+(1364,1,'30,2197',NULL,'','Alterac Valley - Stonehearth Bunker - Alliance Controlled'),
+(1365,0,'30,2197',NULL,'','Alterac Valley - West Frostwolf Tower - Destroyed'),
+(1366,0,'30,2197',NULL,'','Alterac Valley - East Frostwolf Tower - Destroyed'),
+(1367,0,'30,2197',NULL,'','Alterac Valley - Tower Point - Destroyed'),
+(1368,0,'30,2197',NULL,'','Alterac Valley - Iceblood Tower - Destroyed'),
+(1370,0,'30,2197',NULL,'','Alterac Valley - Dun Baldar South Bunker - Destroyed'),
+(1371,0,'30,2197',NULL,'','Alterac Valley - Dun Baldar North Bunker - Destroyed'),
+(1372,0,'30,2197',NULL,'','Alterac Valley - Icewing Bunker - Destroyed'),
+(1373,0,'30,2197',NULL,'','Alterac Valley - Stonehearth Bunker - Destroyed'),
+(1374,0,'30,2197',NULL,'','Alterac Valley - Dun Baldar South Bunker - In Conflict'),
+(1375,0,'30,2197',NULL,'','Alterac Valley - Dun Baldar North Bunker - In Conflict'),
+(1376,0,'30,2197',NULL,'','Alterac Valley - Icewing Bunker - In Conflict'),
+(1377,0,'30,2197',NULL,'','Alterac Valley - Stonehearth Bunker - In Conflict'),
+(1378,0,'30,2197',NULL,'','Alterac Valley - Dun Baldar South Bunker - In Conflict'),
+(1379,0,'30,2197',NULL,'','Alterac Valley - Dun Baldar North Bunker - In Conflict'),
+(1380,0,'30,2197',NULL,'','Alterac Valley - Icewing Bunker - In Conflict'),
+(1381,0,'30,2197',NULL,'','Alterac Valley - Stonehearth Bunker - In Conflict'),
+(1382,1,'30,2197',NULL,'','Alterac Valley - West Frostwolf Tower - Horde Controlled'),
+(1383,1,'30,2197',NULL,'','Alterac Valley - East Frostwolf Tower - Horde Controlled'),
+(1384,1,'30,2197',NULL,'','Alterac Valley - Tower Point - Horde Controlled'),
+(1385,1,'30,2197',NULL,'','Alterac Valley - Iceblood Tower - Horde Controlled'),
+(1387,0,'30,2197',NULL,'','Alterac Valley - West Frostwolf Tower - In Conflict'),
+(1388,0,'30,2197',NULL,'','Alterac Valley - East Frostwolf Tower - In Conflict'),
+(1389,0,'30,2197',NULL,'','Alterac Valley - Tower Point - In Conflict'),
+(1390,0,'30,2197',NULL,'','Alterac Valley - Iceblood Tower - In Conflict'),
+(1392,0,'30,2197',NULL,'','Alterac Valley - West Frostwolf Tower - In Conflict'),
+(1393,0,'30,2197',NULL,'','Alterac Valley - East Frostwolf Tower - In Conflict'),
+(1394,0,'30,2197',NULL,'','Alterac Valley - Tower Point - In Conflict'),
+(1395,0,'30,2197',NULL,'','Alterac Valley - Iceblood Tower - In Conflict'),
+(1545,1,'489,726,2106',NULL,'','Warsong Gulch/Twin Peaks - Alliance flag state'),
+(1546,1,'489,726,2106',NULL,'','Warsong Gulch/Twin Peaks - Horde flag state'),
+(1547,0,'489,726,2106',NULL,'','Warsong Gulch/Twin Peaks - Neutral flag state'),
+(1581,0,'489,726,2106',NULL,'','Warsong Gulch/Twin Peaks - Alliance flag captures'),
+(1582,0,'489,726,2106',NULL,'','Warsong Gulch/Twin Peaks - Horde flag captures'),
+(1601,3,'489,726,2106',NULL,'','Warsong Gulch/Twin Peaks - Max flag captures'),
+(1664,1,'489,2106',NULL,'','Warsong Gulch - unknown state, enables Save the Day achievement (not the only requirement)'),
+(1767,0,'529',NULL,'','Arathi Basin - Stables Alliance controlled'),
+(1768,0,'529',NULL,'','Arathi Basin - Stables Horde controlled'),
+(1769,0,'529',NULL,'','Arathi Basin - Stables Alliance - contested'),
+(1770,0,'529',NULL,'','Arathi Basin - Stables Horde - contested'),
+(1772,0,'529',NULL,'','Arathi Basin - Farm Alliance controlled'),
+(1773,0,'529',NULL,'','Arathi Basin - Farm Horde controlled'),
+(1774,0,'529',NULL,'','Arathi Basin - Farm Alliance - contested'),
+(1775,0,'529',NULL,'','Arathi Basin - Farm Horde - contested'),
+(1776,0,'529,566,761,968,1105,1681,2107,2177',NULL,'','Battlegrounds - Alliance resources'),
+(1777,0,'529,566,761,968,1105,1681,2107,2177',NULL,'','Battlegrounds - Horde resources'),
+(1778,0,'529,761,1681,2107,2177',NULL,'','Battlegrounds - Alliance bases'),
+(1779,0,'529,761,1681,2107,2177',NULL,'','Battlegrounds - Horde bases'),
+(1780,1500,'529,566,761,968,1105,1681,2107,2177',NULL,'','Battlegrounds - Max resources'),
+(1782,0,'529',NULL,'','Arathi Basin - Blacksmith Alliance controlled'),
+(1783,0,'529',NULL,'','Arathi Basin - Blacksmith Horde controlled'),
+(1784,0,'529',NULL,'','Arathi Basin - Blacksmith Alliance - contested'),
+(1785,0,'529',NULL,'','Arathi Basin - Blacksmith Horde - contested'),
+(1787,0,'529',NULL,'','Arathi Basin - Gold Mine Alliance controlled'),
+(1788,0,'529',NULL,'','Arathi Basin - Gold Mine Horde controlled'),
+(1789,0,'529',NULL,'','Arathi Basin - Gold Mine Alliance - contested'),
+(1790,0,'529',NULL,'','Arathi Basin - Gold Mine Horde - contested'),
+(1792,0,'529',NULL,'','Arathi Basin - Lumber Mill Alliance controlled'),
+(1793,0,'529',NULL,'','Arathi Basin - Lumber Mill Horde controlled'),
+(1794,0,'529',NULL,'','Arathi Basin - Lumber Mill Alliance - contested'),
+(1795,0,'529',NULL,'','Arathi Basin - Lumber Mill Horde - contested'),
+(1842,1,'529',NULL,'','Arathi Basin - Stables uncontrolled POI'),
+(1843,1,'529',NULL,'','Arathi Basin - Gold Mine uncontrolled POI'),
+(1844,1,'529',NULL,'','Arathi Basin - Lumber Mill uncontrolled POI'),
+(1845,1,'529',NULL,'','Arathi Basin - Farm uncontrolled POI'),
+(1846,1,'529',NULL,'','Arathi Basin - Blacksmith uncontrolled POI'),
+(1955,1400,'529,1681,2107,2177',NULL,'','Arathi Basin - Near victory resource level warning'),
+(1966,1,'30,2197',NULL,'','Alterac Valley - Snowfall Graveyard - Uncontrolled'),
+(2338,1,'489,2106',NULL,'','Warsong Gulch - Horde flag control state'),
+(2339,1,'489,2106',NULL,'','Warsong Gulch - Alliance flag control state'),
+(2718,0,'566',NULL,'','Eye of the Storm - Show capturing progress bar'),
+(2719,50,'566',NULL,'','Eye of the Storm - Capturing progress bar current value'),
+(2720,40,'566',NULL,'','Eye of the Storm - Capturing progress bar neutral zone size'),
+(2722,1,'566,968',NULL,'','Eye of the Storm - Blood Elf Tower uncontrolled POI'),
+(2723,0,'566,968',NULL,'','Eye of the Storm - Blood Elf Tower Alliance control POI'),
+(2724,0,'566,968',NULL,'','Eye of the Storm - Blood Elf Tower Horde control POI'),
+(2725,1,'566,968',NULL,'','Eye of the Storm - Fel Reaver Ruins uncontrolled POI'),
+(2726,0,'566,968',NULL,'','Eye of the Storm - Fel Reaver Ruins Alliance control POI'),
+(2727,0,'566,968',NULL,'','Eye of the Storm - Fel Reaver Ruins Horde control POI'),
+(2728,1,'566,968',NULL,'','Eye of the Storm - Mage Tower uncontrolled POI'),
+(2729,0,'566,968',NULL,'','Eye of the Storm - Mage Tower Horde control POI'),
+(2730,0,'566,968',NULL,'','Eye of the Storm - Mage Tower Alliance control POI'),
+(2731,1,'566,968',NULL,'','Eye of the Storm - Draenei Ruins uncontrolled POI'),
+(2732,0,'566,968',NULL,'','Eye of the Storm - Draenei Ruins Alliance control POI'),
+(2733,0,'566,968',NULL,'','Eye of the Storm - Draenei Ruins Horde control POI'),
+(2752,0,'566,968',NULL,'','Eye of the Storm - Alliance bases controlled'),
+(2753,0,'566,968',NULL,'','Eye of the Storm - Horde bases controlled'),
+(3127,700,'30',NULL,'','Alterac Valley - Alliance Reinforcements'),
+(3128,700,'30',NULL,'','Alterac Valley - Horde Reinforcements'),
+(3133,1,'30',NULL,'','Alterac Valley - Show Horde Reinforcements'),
+(3134,1,'30',NULL,'','Alterac Valley - Show Alliance Reinforcements'),
+(3136,700,'30',NULL,'','Alterac Valley - Max Reinforcements'),
+(3557,0,'607',NULL,'','Strand of the Ancients - Timer'),
+(3564,0,'607',NULL,'','Strand of the Ancients - Show timer'),
+(3565,0,'607',NULL,'','Strand of the Ancients - Show timer'),
+(3571,0,'607',NULL,'','Strand of the Ancients - Show bonus timer'),
+(3600,0,'559,562,572,617,618,980,1134,1504,1505,1552,1672,1825,1911,2167,2373,2509,2511,2547',NULL,'','Arenas - Green Team Players remaining'),
+(3601,0,'559,562,572,617,618,980,1134,1504,1505,1552,1672,1825,1911,2167,2373,2509,2511,2547',NULL,'','Arenas - Gold Team Players remaining'),
+(3610,1,'559,562,572,617,618,980,1134,1504,1505,1552,1672,1825,1911,2167,2373,2509,2511,2547',NULL,'','Arenas - Show players remaining'),
+(3614,1,'607',NULL,'','Strand of the Ancients - Gate of the Purple Amethyst'),
+(3617,1,'607',NULL,'','Strand of the Ancients - Gate of the Red Sun'),
+(3620,1,'607',NULL,'','Strand of the Ancients - Gate of the Blue Sapphire'),
+(3623,1,'607',NULL,'','Strand of the Ancients - Gate of the Green Emerald'),
+(3626,0,'607',NULL,'','Strand of the Ancients - The Frostbreaker - Alliance Offense'),
+(3627,0,'607',NULL,'','Strand of the Ancients - The Graceful Maiden - Alliance Offense'),
+(3628,0,'607',NULL,'','Strand of the Ancients - The Blightbringer - Horde Offense'),
+(3629,0,'607',NULL,'','Strand of the Ancients - The Casket Carrier - Horde Offense'),
+(3630,0,'607',NULL,'','Strand of the Ancients - Alliance Defense'),
+(3631,0,'607',NULL,'','Strand of the Ancients - Horde Defense'),
+(3632,0,'607',NULL,'','Strand of the Ancients - East Graveyard - Horde Controlled'),
+(3633,0,'607',NULL,'','Strand of the Ancients - West Graveyard - Horde Controlled'),
+(3634,0,'607',NULL,'','Strand of the Ancients - South Graveyard - Horde Controlled'),
+(3635,0,'607',NULL,'','Strand of the Ancients - West Graveyard - Alliance Controlled'),
+(3636,0,'607',NULL,'','Strand of the Ancients - East Graveyard - Alliance Controlled'),
+(3637,0,'607',NULL,'','Strand of the Ancients - South Graveyard - Alliance Controlled'),
+(3638,1,'607',NULL,'','Strand of the Ancients - Gate of the Yellow Moon'),
+(3644,0,'529,761,1681,2107,2177',NULL,'','Battlegrounds - Alliance overcame resource disadvantage'),
+(3645,0,'529,761,1681,2107,2177',NULL,'','Battlegrounds - Horde overcame resource disadvantage'),
+(3690,0,'607',NULL,'','Strand of the Ancients - Attacker team'),
+(3849,1,'607',NULL,'','Strand of the Ancients - Chamber of Ancient Relics'),
+(3955,0,'607',NULL,'','Strand of the Ancients - Destroyed Alliance vehicles'),
+(3956,0,'607',NULL,'','Strand of the Ancients - Destroyed Horde vehicles'),
+(4221,1,'628',NULL,'','Isle of Conquest - Show Alliance reinforcements'),
+(4222,1,'628',NULL,'','Isle of Conquest - Show Horde reinforcements'),
+(4226,400,'628',NULL,'','Isle of Conquest - Alliance reinforcements'),
+(4227,400,'628',NULL,'','Isle of Conquest - Horde reinforcements'),
+(4228,0,'628',NULL,'','Isle of Conquest - Workshop - In Conflict Alliance'),
+(4229,0,'628',NULL,'','Isle of Conquest - Workshop - Alliance Controlled'),
+(4230,0,'628',NULL,'','Isle of Conquest - Workshop - Horde Controlled'),
+(4232,0,'628',NULL,'','Isle of Conquest - Workshop - Owner'),
+(4234,0,'628',NULL,'','Isle of Conquest - Hangar - Owner'),
+(4235,0,'628',NULL,'','Isle of Conquest - Docks - Owner'),
+(4247,0,'489,726,2106',NULL,'','Warsong Gulch/Twin Peaks - Show timer'),
+(4248,0,'489,726,2106',NULL,'','Warsong Gulch/Twin Peaks - Timer'),
+(4287,0,'628',NULL,'','Isle of Conquest - Refinery - Owner'),
+(4289,0,'628',NULL,'','Isle of Conquest - Quarry - Owner'),
+(4293,0,'628',NULL,'','Isle of Conquest - Workshop - In Conflict Horde'),
+(4294,1,'628',NULL,'','Isle of Conquest - Workshop - Uncontrolled'),
+(4296,1,'628',NULL,'','Isle of Conquest - Hangar - Uncontrolled'),
+(4297,0,'628',NULL,'','Isle of Conquest - Hangar - In Conflict Horde'),
+(4298,0,'628',NULL,'','Isle of Conquest - Hangar - Horde Controlled'),
+(4299,0,'628',NULL,'','Isle of Conquest - Hangar - Alliance Controlled'),
+(4300,0,'628',NULL,'','Isle of Conquest - Hangar - In Conflict Alliance'),
+(4301,1,'628',NULL,'','Isle of Conquest - Docks - Uncontrolled'),
+(4302,0,'628',NULL,'','Isle of Conquest - Docks - In Conflict Horde'),
+(4303,0,'628',NULL,'','Isle of Conquest - Docks - Horde Controlled'),
+(4304,0,'628',NULL,'','Isle of Conquest - Docks - Alliance Controlled'),
+(4305,0,'628',NULL,'','Isle of Conquest - Docks - In Conflict Alliance'),
+(4306,1,'628',NULL,'','Isle of Conquest - Quarry - Uncontrolled'),
+(4307,0,'628',NULL,'','Isle of Conquest - Quarry - In Conflict Horde'),
+(4308,0,'628',NULL,'','Isle of Conquest - Quarry - Horde Controlled'),
+(4309,0,'628',NULL,'','Isle of Conquest - Quarry - Alliance Controlled'),
+(4310,0,'628',NULL,'','Isle of Conquest - Quarry - In Conflict Alliance'),
+(4311,1,'628',NULL,'','Isle of Conquest - Refinery - Uncontrolled'),
+(4312,0,'628',NULL,'','Isle of Conquest - Refinery - In Conflict Horde'),
+(4313,0,'628',NULL,'','Isle of Conquest - Refinery - Horde Controlled'),
+(4314,0,'628',NULL,'','Isle of Conquest - Refinery - Alliance Controlled'),
+(4315,0,'628',NULL,'','Isle of Conquest - Refinery - In Conflict Alliance'),
+(4317,1,'628',NULL,'','Isle of Conquest - Horde Front Gate'),
+(4318,1,'628',NULL,'','Isle of Conquest - Horde West Gate'),
+(4319,1,'628',NULL,'','Isle of Conquest - Horde East Gate'),
+(4320,0,'628',NULL,'','Isle of Conquest - Horde East Gate - Destroyed'),
+(4321,0,'628',NULL,'','Isle of Conquest - Horde West Gate - Destroyed'),
+(4322,0,'628',NULL,'','Isle of Conquest - Horde Front Gate - Destroyed'),
+(4323,0,'628',NULL,'','Isle of Conquest - Alliance Front Gate - Destroyed'),
+(4324,0,'628',NULL,'','Isle of Conquest - Alliance West Gate - Destroyed'),
+(4325,0,'628',NULL,'','Isle of Conquest - Alliance East Gate - Destroyed'),
+(4326,1,'628',NULL,'','Isle of Conquest - Alliance East Gate'),
+(4327,1,'628',NULL,'','Isle of Conquest - Alliance West Gate'),
+(4328,1,'628',NULL,'','Isle of Conquest - Alliance Front Gate'),
+(4339,1,'628',NULL,'','Isle of Conquest - Alliance Keep - Alliance Controlled'),
+(4340,0,'628',NULL,'','Isle of Conquest - Alliance Keep - Horde Controlled'),
+(4341,0,'628',NULL,'','Isle of Conquest - Alliance Keep - Uncontrolled'),
+(4342,0,'628',NULL,'','Isle of Conquest - Alliance Keep - In Conflict Alliance'),
+(4343,0,'628',NULL,'','Isle of Conquest - Alliance Keep - In Conflict Horde'),
+(4344,0,'628',NULL,'','Isle of Conquest - Horde Keep - Alliance Controlled'),
+(4345,1,'628',NULL,'','Isle of Conquest - Horde Keep - Horde Controlled'),
+(4346,0,'628',NULL,'','Isle of Conquest - Horde Keep - Uncontrolled'),
+(4347,0,'628',NULL,'','Isle of Conquest - Horde Keep - In Conflict Alliance'),
+(4348,0,'628',NULL,'','Isle of Conquest - Horde Keep - In Conflict Horde'),
+(4352,0,'607',NULL,'','Strand of the Ancients - Alliance Attacker'),
+(4353,0,'607',NULL,'','Strand of the Ancients - Horde Attacker'),
+(5834,0,'529,1681,2107,2177',NULL,'','Arathi Basin - Stables control state POI'),
+(8524,0,'559,562,572,617,618,980,1134,1504,1505,1552,1672,1825,1911,2167,2373,2509,2511,2547',NULL,'','Arenas - Show Time remaining'),
+(8529,0,'559,562,572,617,618,980,1134,1504,1505,1552,1672,1825,1911,2167,2373,2509,2511,2547',NULL,'','Arenas - Time remaining'),
+(8799,0,'529,1681,2107,2177',NULL,'','Arathi Basin - Blacksmith control state POI'),
+(8805,0,'529,1681,2107,2177',NULL,'','Arathi Basin - Lumber Mill control state POI'),
+(8808,0,'529,1681,2107,2177',NULL,'','Arathi Basin - Farm control state POI'),
+(8809,0,'529,1681,2107,2177',NULL,'','Arathi Basin - Gold Minecontrol state POI'),
+(8863,0,'566,968',NULL,'','Eye of the Storm - Flag POI'),
+(9808,0,'566,968',NULL,'','Eye of the Storm - Alliance Flag UI'),
+(9809,0,'566,968',NULL,'','Eye of the Storm - Horde Flag UI'),
+(13401,0,'559,562,572,617,618,980,1134,1504,1505,1552,1672,1825,1911,2167,2373,2509,2511,2547',NULL,'','Arenas - Show Extra Lives'),
+(15480,0,'559,562,572,617,618,980,1134,1504,1505,1552,1672,1825,1911,2167,2373,2509,2511,2547',NULL,'','Arenas - Green Team Extra Lives'),
+(15481,0,'559,562,572,617,618,980,1134,1504,1505,1552,1672,1825,1911,2167,2373,2509,2511,2547',NULL,'','Arenas - Gold Team Extra Lives'),
+(17303,3,'489,726,2106',NULL,'','Warsong Gulch/Twin Peaks - Max flag captures (new)'),
+(17322,0,'529,1681,2107,2177',NULL,'','Arathi Basin - Stables Alliance control state widget'),
+(17323,0,'529,1681,2107,2177',NULL,'','Arathi Basin - Gold Mine Alliance control state widget'),
+(17324,0,'529,1681,2107,2177',NULL,'','Arathi Basin - Blacksmith Alliance control state widget'),
+(17325,0,'529,1681,2107,2177',NULL,'','Arathi Basin - Farm Alliance control state widget'),
+(17326,0,'529,1681,2107,2177',NULL,'','Arathi Basin - Lumber Mill Alliance control state widget'),
+(17327,0,'529,1681,2107,2177',NULL,'','Arathi Basin - Blacksmith Horde control state widget'),
+(17328,0,'529,1681,2107,2177',NULL,'','Arathi Basin - Farm Horde control state widget'),
+(17329,0,'529,1681,2107,2177',NULL,'','Arathi Basin - Gold Mine Horde control state widget'),
+(17330,0,'529,1681,2107,2177',NULL,'','Arathi Basin - Lumber Mill Horde control state widget'),
+(17331,0,'529,1681,2107,2177',NULL,'','Arathi Basin - Stables Horde control state widget'),
+(17361,0,'566,968',NULL,'','Eye of the Storm - Mage Tower Horde control state'),
+(17362,0,'566,968',NULL,'','Eye of the Storm - Draenei Ruins Horde control state'),
+(17363,0,'566,968',NULL,'','Eye of the Storm - Blood Elf Tower Horde control state'),
+(17364,0,'566,968',NULL,'','Eye of the Storm - Fel Reaver Ruins Horde control state'),
+(17365,0,'566,968',NULL,'','Eye of the Storm - Blood Elf Tower Alliance control state'),
+(17366,0,'566,968',NULL,'','Eye of the Storm - Draenei Ruins Alliance control state'),
+(17367,0,'566,968',NULL,'','Eye of the Storm - Fel Reaver Ruins Alliance control state'),
+(17368,0,'566,968',NULL,'','Eye of the Storm - Mage Tower Alliance control state'),
+(17377,400,'628',NULL,'','Isle of Conquest - Max reinforcements'),
+(17712,0,'2106',NULL,'','Warsong Scramble - Horde flag picked up count'),
+(17713,0,'2106',NULL,'','Warsong Scramble - Alliance flag picked up count'),
+(21322,0,'559,562,572,617,618,980,1134,1504,1505,1552,1672,1825,1911,2167,2373,2509,2511,2547',NULL,'','Arenas - Show Solo Shuffle round'),
+(21427,0,'559,562,572,617,618,980,1134,1504,1505,1552,1672,1825,1911,2167,2373,2509,2511,2547',NULL,'','Arenas - Solo Shuffle round');
+
+DELETE FROM `criteria_data` WHERE `ScriptName` IN (
+'achievement_resilient_victory',
+'achievement_bg_control_all_nodes',
+'achievement_save_the_day',
+'achievement_bg_ic_resource_glut',
+'achievement_bg_ic_glaive_grave',
+'achievement_bg_ic_mowed_down',
+'achievement_bg_sa_artillery',
+'achievement_sickly_gazelle',
+'achievement_everything_counts',
+'achievement_bg_av_perfection',
+'achievement_bg_sa_defense_of_ancients',
+'achievement_not_even_a_scratch'
+);