diff options
| -rw-r--r-- | sql/updates/world/master/2023_12_26_01_world.sql | 154 |
1 files changed, 154 insertions, 0 deletions
diff --git a/sql/updates/world/master/2023_12_26_01_world.sql b/sql/updates/world/master/2023_12_26_01_world.sql new file mode 100644 index 00000000000..a38039dd4a1 --- /dev/null +++ b/sql/updates/world/master/2023_12_26_01_world.sql @@ -0,0 +1,154 @@ +-- Outland +DELETE FROM `creature_questitem` WHERE `DifficultyID`=1 AND `CreatureEntry` IN (19784,20502,21102,21108,21408,21462,21648,21657,21721,21722,21802,21864,21878,21879,21897,21901,22072,23020,23169,23264,23267,23269,23285,23326,23501,16863,16879,16880,16932,16933,16934,16950,17057,17058,19189,19312,19423,19457,19457,19457,19458,19459,18877,18880,18880,18884,19852,20243,20332,20607,20610,20634,20671,20673,20773,20775,20777,20931,21058,19980,20058,20330,20557,20713,20728,20729,20748,20749,20751,20924,20925,20987,21004,21022,21032,21033,21123,21124,21387,21389,21839,21956,22052,22123,22180,22181,22255,23061,23061,23261,23261,23281,23281,23282,23282,115597,115644,18128,18129,18130,18131,18132,18133,18133,18201,18213,18214,18280,18283,18283,18285,18461,18476,18586,19349,19350,19706,19729,19730,20196,20197,20198,20198,20279,20280,20283,20324,20387,21854,17130,17131,17132,17133,17144,18033,18205,18258,18259,18289,18290,18334,18585,18588,18670,18964,19183,21723,21724,21816,22100,22105,22394,22807,23026,23219,115655); +DELETE FROM `creature_questitem` WHERE `DifficultyID`=0 AND `Idx`=1 AND `CreatureEntry` IN (18258,18259,18290); + +-- Mana Tombs +DELETE FROM `creature_template_difficulty` WHERE `DifficultyID`=0 AND `VerifiedBuild`=0 AND `Entry` IN (18394,18429,18430,22927,83996,54694,54692,19307,19306,18431,18344,18343,18341,18331,18317,18315,18314,18313,18312,18311,18309); + +UPDATE `creature_template_difficulty` SET `DifficultyID`=0 WHERE `DifficultyID`=1 AND `Entry` IN (18394,18429,18430,83996,54694,54692,19307,19306,18431,18344,18343,18341,18331,18317,18315,18314,18313,18312,18311,18309); +UPDATE `creature_template_difficulty` SET `DifficultyID`=0 WHERE `DifficultyID`=2 AND `Entry` IN (22927); + +DELETE FROM `creature_questitem` WHERE `DifficultyID`=1 AND `CreatureEntry` IN (18341,18343,18344); + +-- Sethekk Halls +DELETE FROM `creature_template_difficulty` WHERE `DifficultyID`=0 AND `VerifiedBuild`=0 AND `Entry` IN (23136,23135,23134,54847,54840,21931,21904,21891,20343,19429,19428,18956,18703,18701,18473,18472,18328,18327,18326,18325,18323,18322,18321,18320,18319,18318); + +UPDATE `creature_template_difficulty` SET `DifficultyID`=0 WHERE `DifficultyID`=1 AND `Entry` IN (54847,54840,21931,21904,21891,20343,19429,19428,18956,18703,18701,18473,18472,18328,18327,18326,18325,18323,18322,18321,18320,18319,18318); +UPDATE `creature_template_difficulty` SET `DifficultyID`=0 WHERE `DifficultyID`=2 AND `Entry` IN (23136,23135,23134); +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=2, `LevelScalingDeltaMax`=2, `ContentTuningID`=224 WHERE `DifficultyID`=0 AND `Entry`=23035; +UPDATE `creature_template_difficulty` SET `ContentTuningID`=1068, `CreatureDifficultyID`=14006, `VerifiedBuild`=52649 WHERE `DifficultyID`=2 AND `Entry`=18320; + +DELETE FROM `creature_questitem` WHERE `DifficultyID`=1 AND `CreatureEntry` IN (18472,18473,19428); + +-- Auchenai Crypts +DELETE FROM `creature_template_difficulty` WHERE `DifficultyID`=0 AND `VerifiedBuild`=0 AND `Entry` IN (18778,18503,18702,18501,18500,54725,54698,18766,18726,18700,18559,18558,18557,18556,18524,18521,18506,18499,18498,18497,18495,18493,18373,18371); + +UPDATE `creature_template_difficulty` SET `DifficultyID`=0 WHERE `DifficultyID`=1 AND `Entry` IN (18778,18503,18702,18501,18500,54725,54698,18766,18726,18700,18559,18558,18557,18556,18524,18521,18506,18499,18498,18497,18495,18493,18373,18371); + +-- Shadow Labyrinth +DELETE FROM `creature_template_difficulty` WHERE `DifficultyID`=0 AND `VerifiedBuild`=0 AND `Entry` IN (18848,54895,54893,54891,54890,21159,19427,19226,19224,18891,18830,18797,18796,18794,18793,18732,18731,18708,18667,18663,18642,18641,18640,18639,18638,18637,18636,18635,18634,18633,18632,18631); + +UPDATE `creature_template_difficulty` SET `DifficultyID`=0 WHERE `DifficultyID`=1 AND `Entry` IN (18848,54895,54893,54891,54890,21159,19427,19226,19224,18891,18830,18797,18796,18794,18793,18732,18731,18708,18667,18663,18642,18641,18640,18639,18638,18637,18636,18635,18634,18633,18632,18631); +UPDATE `creature_template_difficulty` SET `ContentTuningID`=1069, `CreatureDifficultyID`=14407, `VerifiedBuild`=52649 WHERE `DifficultyID`=2 AND `Entry`=18663; + +DELETE FROM `creature_questitem` WHERE `DifficultyID`=1 AND `CreatureEntry` IN (18642,18667,18732); + +-- The Underbog +DELETE FROM `creature_template_difficulty` WHERE `DifficultyID`=0 AND `VerifiedBuild`=0 AND `Entry` IN (17729,17894,54678,54675,54674,20465,19632,18409,18105,17992,17990,17827,17885,17882,17871,17826,17771,17770,17735,17734,17732,17731,17730,17728,17727,17726,17725,17724,17723); + +UPDATE `creature_template_difficulty` SET `DifficultyID`=0 WHERE `DifficultyID`=1 AND `Entry` IN (17729,17894,54678,54675,54674,20465,19632,18409,18105,17992,17990,17827,17885,17882,17871,17826,17771,17770,17735,17734,17732,17731,17730,17728,17727,17726,17725,17724,17723); +UPDATE `creature_template_difficulty` SET `ContentTuningID`=234, `VerifiedBuild`=52649 WHERE `DifficultyID`=0 AND `Entry`=22299; + +DELETE FROM `creature_questitem` WHERE `DifficultyID`=1 AND `CreatureEntry` IN (17724,17731,17882,18105); + +-- The Slave Pens +DELETE FROM `creature_template_difficulty` WHERE `DifficultyID`=0 AND `VerifiedBuild`=0 AND `Entry` IN (18176,18179,20208,21126,22421,21128,21127,18206,17991,17964,17963,17962,17961,17960,17959,17958,17957,17942,17941,17940,17938,17893,17890,17817,17816); +DELETE FROM `creature_template_difficulty` WHERE `DifficultyID`=19 AND `Entry` IN (21126); + +UPDATE `creature_template_difficulty` SET `DifficultyID`=0 WHERE `DifficultyID`=1 AND `Entry` IN (18176,18179,20208,21126,21128,21127,18206,17991,17964,17963,17962,17961,17960,17959,17958,17957,17942,17941,17940,17938,17893,17890,17817,17816); +UPDATE `creature_template_difficulty` SET `DifficultyID`=0 WHERE `DifficultyID`=2 AND `Entry` IN (22421); + +DELETE FROM `creature_questitem` WHERE `DifficultyID`=1 AND `CreatureEntry` IN (17942,17991); + +-- The Steamvault +DELETE FROM `creature_template_difficulty` WHERE `DifficultyID`=0 AND `VerifiedBuild`=0 AND `Entry` IN (54852,54851,54849,54848,21696,21695,21694,21338,20926,17954,17951,17917,17805,17803,17802,17801,17800,17799,17798,17797,17796,17722,17721); +DELETE FROM `creature_template_difficulty` WHERE `DifficultyID`=1 AND `Entry` IN (6827); + +UPDATE `creature_template_difficulty` SET `DifficultyID`=0 WHERE `DifficultyID`=1 AND `Entry` IN (54852,54851,54849,54848,21696,21695,21694,21338,20926,17954,17951,17917,17805,17803,17802,17801,17800,17799,17798,17797,17796,17722,17721); + +DELETE FROM `creature_questitem` WHERE `DifficultyID`=1 AND `CreatureEntry` IN (17796,17797); + +-- Serpentshrine Cavern +DELETE FROM `creature_template_difficulty` WHERE `DifficultyID`=0 AND `VerifiedBuild`=0 AND `Entry` IN (21260,21932,22820,22486,22352,22335,22250,22238,22236,22119,22104,22091,22057,22056,22055,22036,22009,21987,21966,21965,21964,21958,21934,21933,21216,21863,21812,21806,21508,21339,21301,21299,21298,21263,21253,21251,21246,21232,21231,21230,21229,21228,21227,21226,21225,21224,21221,21220,21218,21217,21215,21214,21213,21212); + +UPDATE `creature_template_difficulty` SET `DifficultyID`=0 WHERE `DifficultyID`=4 AND `Entry` IN (21260,21932,22820,22486,22352,22335,22250,22238,22236,22119,22104,22091,22057,22056,22055,22036,22009,21987,21966,21965,21964,21958,21934,21933,21216,21863,21812,21806,21508,21339,21301,21299,21298,21263,21253,21251,21246,21232,21231,21230,21229,21228,21227,21226,21225,21224,21221,21220,21218,21217,21215,21214,21213,21212); + +DELETE FROM `creature_questitem` WHERE `DifficultyID`=1 AND `CreatureEntry` IN (21212); + +-- Gruul's Lair +DELETE FROM `creature_template_difficulty` WHERE `DifficultyID`=0 AND `VerifiedBuild`=0 AND `Entry` IN (21350,19389,19044,18847,18836,18835,18834,18832,18831); + +UPDATE `creature_template_difficulty` SET `DifficultyID`=0 WHERE `DifficultyID`=4 AND `Entry` IN (21350,19389,19044,18847,18836,18835,18834,18832,18831); + +DELETE FROM `creature_questitem` WHERE `DifficultyID`=1 AND `CreatureEntry` IN (19044); + +-- The Botanica +DELETE FROM `creature_template_difficulty` WHERE `DifficultyID`=0 AND `VerifiedBuild`=0 AND `Entry` IN (19969,19964,19962,19958,19953,19949,19920,19919,19633,19865,19843,19608,19598,19557,19555,19513,19512,19511,19509,19508,19507,19505,19486,18587,18422,18421,18420,18419,18405,18404,18155,17994,17993,17980,17978,17977,17976,17975); + +UPDATE `creature_template_difficulty` SET `DifficultyID`=0 WHERE `DifficultyID`=1 AND `Entry` IN (19969,19964,19962,19958,19953,19949,19920,19919,19633,19865,19843,19608,19598,19557,19555,19513,19512,19511,19509,19508,19507,19505,19486,18587,18422,18421,18420,18419,18405,18404,18155,17994,17993,17980,17978,17977,17976,17975); + +DELETE FROM `creature_questitem` WHERE `DifficultyID`=1 AND `CreatureEntry` IN (17976,17977,17980); + +-- The Arcatraz +DELETE FROM `creature_template_difficulty` WHERE `DifficultyID`=0 AND `VerifiedBuild`=0 AND `Entry` IN (21414,21346,21101,21030,20911,21290,20908,20906,20857,20905,20909,21962,21761,21702,21440,21439,21438,21437,21436,21395,21304,21303,21186,20978,20977,20912,20910,20904,20902,20901,20900,20898,20897,20896,20886,20885,20883,20882,20881,20880,20879,20875,20873,20870,20869,20868,20867,20866,20865,20864,20859); + +UPDATE `creature_template_difficulty` SET `DifficultyID`=0 WHERE `DifficultyID`=1 AND `Entry` IN (21414,21346,21101,21030,20911,21290,20908,20906,20857,20905,20909,21962,21761,21702,21440,21439,21438,21437,21436,21395,21304,21303,21186,20978,20977,20912,20910,20904,20902,20901,20900,20898,20897,20896,20886,20885,20883,20882,20881,20880,20879,20875,20873,20870,20869,20868,20867,20866,20865,20864,20859); + +DELETE FROM `creature_questitem` WHERE `DifficultyID`=1 AND `CreatureEntry` IN (20866,20906); + +-- The Mechanar +DELETE FROM `creature_template_difficulty` WHERE `DifficultyID`=0 AND `VerifiedBuild`=0 AND `Entry` IN (21062,20405,20481,20478,19221,19220,20990,20988,19716,19168,19712,19510,19231,20059,19735,19713,19710,19219,19218,19167,19166); + +UPDATE `creature_template_difficulty` SET `DifficultyID`=0 WHERE `DifficultyID`=1 AND `Entry` IN (21062,20405,20481,20478,19221,19220,20990,20988,19716,19168,19712,19510,19231,20059,19735,19713,19710,19219,19218,19167,19166); + +DELETE FROM `creature_questitem` WHERE `DifficultyID`=1 AND `CreatureEntry` IN (19220); + +-- Tempest Keep +DELETE FROM `creature_template_difficulty` WHERE `DifficultyID`=0 AND `VerifiedBuild`=0 AND `Entry` IN (21369,21364,21362,21274,21273,21272,21271,21270,21269,21268,21002,18928,18925,18806,20602,20064,20063,20062,20060,20052,20050,20049,20048,20047,20046,20045,20044,20043,20042,20041,20040,20039,20038,20037,20036,20035,20034,20033,20032,20031,19622,19551,19516,19514,18805); + +UPDATE `creature_template_difficulty` SET `DifficultyID`=0 WHERE `DifficultyID`=4 AND `Entry` IN (21369,21364,21362,21274,21273,21272,21271,21270,21269,21268,21002,18928,18925,18806,20602,20064,20063,20062,20060,20052,20050,20049,20048,20047,20046,20045,20044,20043,20042,20041,20040,20039,20038,20037,20036,20035,20034,20033,20032,20031,19622,19551,19516,19514,18805); + +DELETE FROM `creature_questitem` WHERE `DifficultyID`=1 AND `CreatureEntry` IN (19622,20038,20039); + +-- Hellfire Ramparts +DELETE FROM `creature_template_difficulty` WHERE `DifficultyID`=0 AND `VerifiedBuild`=0 AND `Entry` IN (54607,54606,17540,17537,17307,17517,17478,17455,17309,17308,17306,17281,17280,17271,17270,17269,17264,17259); + +UPDATE `creature_template_difficulty` SET `DifficultyID`=0 WHERE `DifficultyID`=1 AND `Entry` IN (54607,54606,17540,17537,17307,17517,17478,17455,17309,17308,17306,17281,17280,17271,17270,17269,17264,17259); + +DELETE FROM `creature_questitem` WHERE `DifficultyID`=1 AND `CreatureEntry` IN (17280,17306,17307,17308); + +-- The Blood Furnace +DELETE FROM `creature_template_difficulty` WHERE `DifficultyID`=0 AND `VerifiedBuild`=0 AND `Entry` IN (55108,54637,54636,21174,19016,18894,17662,17653,17626,17624,17491,17477,17429,17416,17414,17401,17400,17399,17398,17397,17395,17381,17380,17377,17371,17370); + +UPDATE `creature_template_difficulty` SET `DifficultyID`=0 WHERE `DifficultyID`=1 AND `Entry` IN (55108,54637,54636,21174,19016,18894,17662,17653,17626,17624,17491,17477,17429,17416,17414,17401,17400,17399,17398,17397,17395,17381,17380,17377,17371,17370); + +DELETE FROM `creature_questitem` WHERE `DifficultyID`=1 AND `CreatureEntry` IN (17370,17371,17377,17381,17395,17397,17398,17401,17414,17429,17491,17624,17626); + +-- The Shattered Halls +DELETE FROM `creature_template_difficulty` WHERE `DifficultyID`=0 AND `VerifiedBuild`=0 AND `Entry` IN (20923,17301,17295,17296,17297,17302,57909,57908,55136,54932,54931,20709,19524,19523,18370,17695,17694,17693,17687,17671,17670,17669,17623,17622,17621,17611,17578,17552,17471,17465,17464,17462,17461,17427,17420,17357,17356,17083,16809,16808,16807,16704,16700,16699,16594,16593,16523,16507); + +UPDATE `creature_template_difficulty` SET `DifficultyID`=0 WHERE `DifficultyID`=1 AND `Entry` IN (20923,17301,17295,17296,17297,17302,57909,57908,55136,54932,54931,20709,19524,19523,18370,17695,17694,17693,17687,17671,17670,17669,17623,17622,17621,17611,17578,17552,17471,17465,17464,17462,17461,17427,17420,17357,17356,17083,16809,16808,16807,16704,16700,16699,16594,16593,16523,16507); + +UPDATE `creature_template_difficulty` SET `ContentTuningID`=231, `VerifiedBuild`=52649 WHERE `DifficultyID`=0 AND `Entry` IN (17301,20923); + +DELETE FROM `creature_questitem` WHERE `DifficultyID`=1 AND `CreatureEntry` IN (16807,16808,16809,17669); + +-- Magtheridon's Lair +DELETE FROM `creature_template_difficulty` WHERE `DifficultyID`=0 AND `VerifiedBuild`=0 AND `Entry` IN (18829,17474,17376,17257); + +UPDATE `creature_template_difficulty` SET `DifficultyID`=0 WHERE `DifficultyID`=4 AND `Entry` IN (18829,17474,17376,17257); + +-- Black Temple +DELETE FROM `creature_template_difficulty` WHERE `DifficultyID`=0 AND `VerifiedBuild`=0 AND `Entry` IN (22894,23369,23379,23499); + +UPDATE `creature_template_difficulty` SET `HealthModifier`=23.52000045776367187, `ManaModifier`=40, `CreatureDifficultyID`=126942, `VerifiedBuild`=52649 WHERE (`Entry`=22876 AND `DifficultyID`=14); +UPDATE `creature_template_difficulty` SET `DifficultyID`=0, `ContentTuningID`=1014, `DamageModifier`=1, `VerifiedBuild`=52649 WHERE `DifficultyID`=14 AND `Entry` IN (22894,23369,23379,23499); +UPDATE `creature_template_difficulty` SET `ContentTuningID`=778, `VerifiedBuild`=52649 WHERE `DifficultyID`=0 AND `Entry`=123252; + +UPDATE `creature_template_difficulty` ctd +LEFT JOIN `creature_template_difficulty` ctd2 ON ctd.`Entry`=ctd2.`Entry` AND ctd.`DifficultyID`!=ctd2.`DifficultyID` +SET + ctd.`LevelScalingDeltaMin`=ctd2.`LevelScalingDeltaMin`, + ctd.`LevelScalingDeltaMax`=ctd2.`LevelScalingDeltaMax`, + ctd.`ContentTuningID`=ctd2.`ContentTuningID`, + ctd.`DamageModifier`=ctd2.`DamageModifier`, + ctd.`LootID`=ctd2.`LootID`, + ctd.`PickPocketLootID`=ctd2.`PickPocketLootID`, + ctd.`SkinLootID`=ctd2.`SkinLootID`, + ctd.`GoldMin`=ctd2.`GoldMin`, + ctd.`GoldMax`=ctd2.`GoldMax`, + ctd.`VerifiedBuild`=52649 +WHERE ctd.`DifficultyID`=0 +AND ctd.`Entry` IN (22876,23524,23523,23502,23469,23451,23448,23436,23429,23421,23420,23419,23418,23417,23412,23411,23410,23403,23402,23401,23400,23399,23398,23397,23394,23374,23371,23351,23339,23337,23336,23330,23319,23318,23288,23259,23239,23237,23236,23235,23232,23226,23223,23222,23216,23215,23210,23197,23196,23191,23172,23159,23158,23157,23147,23124,23123,23095,23089,23084,23083,23080,23049,23047,23030,23028,23018,22997,22996,22984,22965,22964,22963,22962,22960,22959,22957,22956,22955,22954,22953,22952,22951,22950,22949,22948,22947,22946,22945,22939,22929,22917,22898,22896,22887,22886,22885,22884,22883,22882,22881,22880,22879,22878,22877,22875,22874,22873,22871,22869,22856,22855,22853,22849,22848,22847,22846,22845,22844,22841); + +DELETE FROM `creature_questitem` WHERE `DifficultyID`=1 AND `CreatureEntry` IN (23083,22946,23232,22917,22885,22884); |