Core/AreaTriggers: Added SpawnDifficulties for spawned areatriggers (#29284)

1 files changed, 23 insertions, 0 deletions

diff --git a/sql/updates/world/master/2023_09_06_02_world.sql b/sql/updates/world/master/2023_09_06_02_world.sql
new file mode 100644
index 00000000000..9a99a48bcb8
--- /dev/null
+++ b/sql/updates/world/master/2023_09_06_02_world.sql
@@ -0,0 +1,23 @@
+ALTER TABLE `areatrigger`
+    ADD COLUMN `SpawnDifficulties` VARCHAR(100) NOT NULL DEFAULT '0' COLLATE 'utf8mb4_unicode_ci' AFTER `MapId`;
+
+UPDATE `areatrigger` SET `SpawnDifficulties` = '0' WHERE `MapId` IN(0,1064,1105,1107,1116,1190,1191,1220,1265,1463,1464,1468,1469,1479,1481,1502,1512,1513,1514,1515,1519,1540,1637,1642,1643,1669,1718,1750,1779,1860,1865,1929,1,2081,2107,2147,2175,2222,2261,2268,2297,2364,2369,2370,2374,2444,2453,2454,2512,2523,2524,2534,2570,30,369,530,571,572,609,646,648,654,726,730,732,749,761,860,861,870,974);
+UPDATE `areatrigger` SET `SpawnDifficulties` = '1' WHERE `MapId` IN(109,1152,1153,1158,1159,129,1330,1331,1358,1763,1877,209,2284,229,230,2516,329,349,34,389,429,43,47,48,70,90);
+UPDATE `areatrigger` SET `SpawnDifficulties` = '1,2' WHERE `MapId` IN(1001,1175,1209,189,269,289,33,36,540,542,543,545,546,547,552,553,554,555,556,557,558,560,568,574,575,576,578,585,595,599,600,601,602,604,608,619,632,643,644,645,650,658,668,670,725,755,859);
+UPDATE `areatrigger` SET `SpawnDifficulties` = '1,2,8' WHERE `MapId` IN(1004,1007,1011,1175,1176,1279,959,960,961,962,994);
+UPDATE `areatrigger` SET `SpawnDifficulties` = '1,2,8,23' WHERE `MapId` IN(1195,1544,1771,1754,1763,1841,1862,1864,1877,2284,2285,2286,2287,2290,2291,2293,1182,1208,1456,1458,1466,1477,1492,1493,1501,1594,2289,2519,2521,2526,2527,657,2451,2515,2516,2520,2527);
+UPDATE `areatrigger` SET `SpawnDifficulties` = '12' WHERE `MapId` IN(1460,1475,1478,1703,1760,1904,1906,1955,2464,2471);
+UPDATE `areatrigger` SET `SpawnDifficulties` = '14,15,16,17' WHERE `MapId` IN(1136,1205,1228,1448,1520,1530,1648,1676,1712,1861,2070,2096,2164,2217,2296,2450,2481,2569);
+UPDATE `areatrigger` SET `SpawnDifficulties` = '14,15,33' WHERE `MapId` = 720;
+UPDATE `areatrigger` SET `SpawnDifficulties` = '14,33' WHERE `MapId` IN(564, 603);
+UPDATE `areatrigger` SET `SpawnDifficulties` = '14,15,16,17' WHERE `MapId` = 2296;
+UPDATE `areatrigger` SET `SpawnDifficulties` = '2,23' WHERE `MapId` = 1651;
+UPDATE `areatrigger` SET `SpawnDifficulties` = '2,8,23' WHERE `MapId` IN(1516,1571,1677,1753,1762,2097,2441);
+UPDATE `areatrigger` SET `SpawnDifficulties` = '3' WHERE `MapId` IN(509,532);
+UPDATE `areatrigger` SET `SpawnDifficulties` = '3,4' WHERE `MapId` IN(249,533,615,616,624,757);
+UPDATE `areatrigger` SET `SpawnDifficulties` = '3,4,5,6' WHERE `MapId` IN(631,649,669,671,724,754);
+UPDATE `areatrigger` SET `SpawnDifficulties` = '3,4,5,6,7' WHERE `MapId` IN(1008,1009,967,996);
+UPDATE `areatrigger` SET `SpawnDifficulties` = '3,5' WHERE `MapId` = 1098;
+UPDATE `areatrigger` SET `SpawnDifficulties` = '4' WHERE `MapId` IN(534,544,548,550,565,580);
+UPDATE `areatrigger` SET `SpawnDifficulties` = '9' WHERE `MapId` IN(531);
+UPDATE `areatrigger` SET `SpawnDifficulties` = '9,18' WHERE `MapId` IN(409, 469);