diff options
| -rw-r--r-- | sql/updates/world/cata_classic/2025_04_16_09_world.sql | 47 |
1 files changed, 47 insertions, 0 deletions
diff --git a/sql/updates/world/cata_classic/2025_04_16_09_world.sql b/sql/updates/world/cata_classic/2025_04_16_09_world.sql new file mode 100644 index 00000000000..ff1a6f662e7 --- /dev/null +++ b/sql/updates/world/cata_classic/2025_04_16_09_world.sql @@ -0,0 +1,47 @@ +DELETE FROM `event_script_names` WHERE `Id` IN (47548,47549,47550); +UPDATE `spell_scripts` SET `effIndex`=1 WHERE `id`=45071 AND `effIndex`=2; +DELETE FROM `phase_area` WHERE `PhaseId` IN (1687,5626,5899,5920,5931,5935,5936,6666,7434,10034,10035,10036,10037,10275,10559,11595,11867,11955,12882,13306,14345,14601,16013,16786,19121,19122,19123,19125,19133,19142,19176,19268,19329,19820,19932,19933,19934,20143,20340,20675,21386,21687,21855,22310,22403); +DELETE FROM `terrain_swap_defaults` WHERE `TerrainSwapMap` IN (1190,1817,1158); +DELETE FROM `terrain_worldmap` WHERE `TerrainSwapMap` IN (1190,1817); +DELETE FROM `spawn_group` WHERE `spawnType`=0 AND `spawnId` IN (305537,305539,305540,305542,305546,305549,305550,305551,305552,305563,305564,305565,305568,305569,305571,305572,305573,305574,305575,305576,305577,305578,305579,305580,305581,305597,305616,305626,305635,305660,305675,305692,305701,305711,305712,305721,306002,306003,306004,306005,306006,306009,306010,306011,306013,306021,306024,306025,306027,306074,306079,307473,382309,384084,137747,166919,167203,223959,223960,223961,223962,223963,223964,223965,223966,223967,223968,223969,223971,223972); +DELETE FROM `spawn_group` WHERE `spawnType`=1 AND `spawnId` IN (229457,301115,301116,301204,301205,600228,600251,253255,253256,253257,253258,253259,253260); +DELETE FROM `creature_formations` WHERE `leaderGUID` IN (395277,395282,395291,395297,395316,395362); +UPDATE `conditions` SET `ConditionValue1`=773 WHERE `SourceTypeOrReferenceId`=19 AND `SourceEntry`=29515 AND `ConditionValue1`=2514; +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=18 AND `SourceGroup` IN (35431,35433); +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=17 AND `SourceEntry` IN (161625,227412,247532,325429,369730,370111); +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry` IN (29528,69855,191664,362405,364239,375652,388008,411873,411877,374570,411873,411874); +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `ConditionTypeOrReference`=31 AND `ConditionValue1`=3 AND `ConditionValue2` IN (162935,74228,88703,168459,53714,57873,58662,79655,79635,79656,81556,55370,89884,93105,132397,133663,139645,149760,174955,167146,161709,162817,193563,181954,181954,184519,181954,188011,187969,189162,189162,189162,189162,189896,190509,186644,186644,193563,190051,190054,190055,190059,190060,188011,197204,190509,122773,122778,184519,184519,190509,197204,183033,60197,183033); +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `ConditionTypeOrReference`=51 AND `ConditionValue1`=5 AND `ConditionValue2` IN (80087,122773,122778,122818,83670,81895); +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (-1,-2,-3,-4); +UPDATE `conditions` SET `ConditionValue1`=773, `ConditionValue2`=350 WHERE `SourceTypeOrReferenceId`=1 AND `SourceGroup` IN (26679,26708,27546,27676) AND `ConditionValue1`=2512; +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=1 AND `SourceGroup` IN (150228,150237,156676,162817); +UPDATE `conditions` SET `ConditionValue1`=171, `ConditionValue2`=425 WHERE `SourceTypeOrReferenceId`=4 AND `SourceGroup` IN (26959,26960,26961,26962,27078,27079,27080,27081) AND `ConditionValue1`=2483; +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=4 AND `SourceGroup`=40268; +DELETE FROM `conditions` WHERE `ConditionTypeOrReference`=56 AND `ConditionValue1`=81408; +DELETE FROM `conditions` WHERE `ConditionTypeOrReference` IN (8,9,28,47) AND `ConditionValue1` IN (59350,59773,59315,50058,40644,40378,44184,59254,56034,59938,59939,55196,55763,55764,55881,55882,55639,55965,55981,56344,54952,55173,59339,55173,57102,57677,57261,58147,56775,59321,59314,59927,59933,59935,59934,59939,59938,59941,55173,55186,55173,55184,37860,50313,49467,58209,40519,44663,55882,55146,55142,53152,53500,51803,50058,50305,49772,47099,40379,38765,40076,40077,38759,42370,40519,44663,37566,42372,39049,39938,41106,40644,38765,39654,37659,37450,37860,38232,38237,38232,38237,38232,38237,37486,37510,37727,37728,38834,37566,31145,59928,58208,59942,59942,59928,59928,59940,59942,46727,46728,55174,59931,59932,55174,46727,46728,60151,63986,65302,65279,65306,65594,65594,65595,66270,65594,66393,66395,66648,66589,66589,66589,65436,66589,66589,67700,66589,67700,72071,72071,66263,66264,66267,66262,67071,67071,72426,75265,75918,75890,75890,75890,77423,55193,55879,59940,59942,38857,42271,37853,37859,37862,37857,37660,37957,37855,42756,37862,37861,37736,37733,36920,37492,37538,37507,37467,37497,34445,36307,37677,34423,34421,35933,34392,34583,35240,33815,34378,34584,34586,34402,34364,34582,34422,34423,35297,34420,33815,34393,60125,34421,34364,35240,34402,34586,31490,31493,31495,31497,31514,31516,31440,31447,31442,31448,36797,66560,29409,29410,63976,31495,31497,31490,31493,34423,34398,61874,72409,31161,31163,34423,36881,34398,34586,38813,66560,66560,38813,50476,46729,47186,34398,34398,57584,58903,58902,63977,59774,60735,63977,61874,66596,66577,72240,72405,72408); +UPDATE `conditions` SET `ConditionValue1`=6, `ConditionValue1`=67 WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=10144 AND `SourceEntry`=1 AND `ConditionTypeOrReference`=16; +UPDATE `conditions` SET `ConditionValue1`=6, `ConditionValue1`=469 WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=10144 AND `SourceEntry`=0 AND `ConditionTypeOrReference`=16; +DELETE FROM `conditions` WHERE `ConditionTypeOrReference`=48 AND `ConditionValue1` IN (431998,406783,406784,280770,273075,278472,278473,280770,278955,396925,406783,429653,429654,429652,335216,395159,395215,392770); +UPDATE `conditions` SET `ConditionValue1`=426650 WHERE `ConditionTypeOrReference`=48 AND `ConditionValue1`=261021; +UPDATE `conditions` SET `ConditionValue1`=426651 WHERE `ConditionTypeOrReference`=48 AND `ConditionValue1`=261022; +UPDATE `conditions` SET `ConditionValue1`=424912 WHERE `ConditionTypeOrReference`=48 AND `ConditionValue1`=263462; +UPDATE `conditions` SET `SourceGroup`=8 WHERE `SourceTypeOrReferenceId`=13 AND `SourceGroup`=4 AND `SourceEntry`=69162; +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=19 AND `SourceEntry` IN (43056,43057,55173,55184,55186,55193,59935,59938,59939,59940,66265,66266,66268,66269); +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=29; +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=32 AND `SourceGroup`=5 AND `SourceEntry` IN (149917,151088,151088,151088,151089,151089,151089,154170,154170,154170,156398,156398,156609,156609,156610,156610,156612,156612,156651,156651,156662,157093,157093,166163,166163,166164,166164,166165,166165,166166,166166,166573,166784,166786,166786,166787,166787,166787,166791,166791,166792,166792,166792,166796,166796,166797,166797,166797,166800,166824,166824,166827,166906,166906,166997); +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=32 AND `SourceGroup`=8 AND `SourceEntry` IN (378473,411616,414929); +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=26 AND `SourceGroup` IN (22403,3627,598,597,596,3626,592,593,12240,594,12241,595,2801,3146,3236,20675,20675,16786,16786,16786,3623,3793,3794,11595,21687,21687,22310); +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=14 AND `SourceGroup` IN (25345,25113,27524,30163,25121,25345,25356,25356); +UPDATE `conditions` SET `SourceGroup`=1 WHERE `SourceTypeOrReferenceId`=13 AND `SourceGroup`=3 AND `SourceEntry`=36450; +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceGroup` IN (1,2) AND `SourceEntry`=5628; +DELETE FROM `conditions` WHERE `ConditionTypeOrReference`=11 AND `ConditionValue1` IN (8809,8808,8805,8799,8809,8808,8805,8799,8809,8808,8805,8799,8809,8808,8805,8799,8809,8853,8853,8852,8852,8851,8851); +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=31 AND `SourceGroup`=580; +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=26 AND `SourceEntry` IN (12881,11955,13377,10639,10453,10452,9796,10424,6066); +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=26 AND `SourceGroup` IN (5935,10489,11955,12881,14983,3207,3208,3209,3210,3248,3249,3250,3265,3414,3670,3763,3764,3910,3910,3911,3911,3946,3946,3947,3947,3947,3947,4010,4010,4011,4011,4142,4143,4150,4151,4374,4375,4462,4462,4476,4757,4758,4761,4762,4763,4764,4925,4927,4931,4932,5259,5260,5261,5462,5463,5464,5533,5534,5658,5658,5931,5936,9001,10034,10035,10275,10827,10845,13783,13783,13783,13783,14026,14027,14601,15181,15190,15319,15331,15331,15895,15935); +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=25 AND `SourceEntry`=1817; +UPDATE `conditions` SET `ConditionValue1`=409629 WHERE `ConditionTypeOrReference`=48 AND `ConditionValue1`=262445; +UPDATE `conditions` SET `ConditionValue1`=409630 WHERE `ConditionTypeOrReference`=48 AND `ConditionValue1`=262446; +UPDATE `conditions` SET `ConditionValue1`=409631 WHERE `ConditionTypeOrReference`=48 AND `ConditionValue1`=262447; +UPDATE `conditions` SET `ConditionValue1`=409632 WHERE `ConditionTypeOrReference`=48 AND `ConditionValue1`=262448; +DELETE FROM `conditions` WHERE `ConditionTypeOrReference` IN (1,25) AND `ConditionValue1` IN (305522,173426,305742,321670,325368,159127,159126,161625,158985,116219,125610); +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=27 AND `SourceGroup` IN (10218,10053,10028,5785,5840,6145,6170,6176,6450,6451,6452,6453,6454,6455,6456,6757); |