diff options
| -rw-r--r-- | sql/updates/world/master/2023_06_01_03_world.sql | 47 |
1 files changed, 47 insertions, 0 deletions
diff --git a/sql/updates/world/master/2023_06_01_03_world.sql b/sql/updates/world/master/2023_06_01_03_world.sql new file mode 100644 index 00000000000..abc9d0d49d8 --- /dev/null +++ b/sql/updates/world/master/2023_06_01_03_world.sql @@ -0,0 +1,47 @@ +-- Creature templates +UPDATE `creature_template` SET `npcflag`=80 WHERE `entry`=33618; -- Skinning +UPDATE `creature_template` SET `npcflag`=80 WHERE `entry`=33617; -- Mining +UPDATE `creature_template` SET `npcflag`=80 WHERE `entry`=33616; -- Herbalism +UPDATE `creature_template` SET `npcflag`=80 WHERE `entry`=33615; -- Inscription +UPDATE `creature_template` SET `npcflag`=80 WHERE `entry`=33614; -- Jewelcrafting +UPDATE `creature_template` SET `npcflag`=80 WHERE `entry`=33612; -- Leatherworking +UPDATE `creature_template` SET `npcflag`=80 WHERE `entry`=33611; -- Engineering +UPDATE `creature_template` SET `npcflag`=80 WHERE `entry`=33610; -- Enchanting +UPDATE `creature_template` SET `npcflag`=80 WHERE `entry`=33609; -- Blacksmithing +UPDATE `creature_template` SET `npcflag`=80 WHERE `entry`=33608; -- Alchemy +UPDATE `creature_template` SET `unit_flags3`=8388608 WHERE `entry`=25992; -- Big Bruiser +UPDATE `creature_template` SET `faction`=1720 WHERE `entry`=24411; -- Shattered Hand Centurion Image +UPDATE `creature_template` SET `speed_walk`=1, `speed_run`=1.142857193946838378 WHERE `entry`=24410; -- Vazruden the Herald Image +UPDATE `creature_template` SET `npcflag`=80 WHERE `entry`=20125; -- Zula Slagfury +UPDATE `creature_template` SET `npcflag`=80 WHERE `entry`=20124; -- Kradu Grimblade +UPDATE `creature_template` SET `unit_flags3`=8388608 WHERE `entry`=19687; -- Shattrath City Peacekeeper +UPDATE `creature_template` SET `unit_flags`=0 WHERE `entry`=19665; -- Ewe +UPDATE `creature_template` SET `npcflag`=81 WHERE `entry`=19184; -- Mildred Fletcher +UPDATE `creature_template` SET `unit_flags3`=8388608 WHERE `entry`=18568; -- Scryer Arcane Guardian + +-- Difficulty +DELETE FROM `creature_template_difficulty` WHERE (`DifficultyID`=1 AND `Entry` IN (24411,19665,19337,19153,19390,19213,22212,22213,19196,22208,19187,23699,25992,19033,22819,19283,19289,18584,24412,24410,24437,24370,24369,22442,19186,19064,23948,19182,23854,23855,23852,23853,23850,23845,23830,19271,18585,19270,25967,18762,18756,19076,18484,19077,23462,23463,19184,23464,23461,23433,23466,23465,18652,18653,18597,18600,24393,24416,24436,19163,19144,19045,19047,19164,19051,35002,19162,19150,19155,20124,20125,34999,35000,20123,18622,22326,22373,18596,22292,50143,20807,19318,23484,23270,19034,19321,19049,19074,22429,19052,33684,33683,19065,19063,19043,21906,24728,24727,20616,19378,19138,18538,19161,19050,19377,27711,19046,27723,21518,18549,19346,33680,33682,18537,33681,23271,19142,25195,33678,33675,19726,19720,19725,33676,33677,33674,33679,19702,33635,33641,33636,33631,33630,25196,33639,33634,19236,23272,19240,33615,20613,19251,19242,19234,33619,19245,19340,19235,18530,33613,33609,33612,33611,33610,33623,33617,33621,33616,33608,19252,19248,33618,33614,21905,33642,19249,19250,18531,19485,21816,19238,19232,18547,19243,18594,19239,19330,21517,19244,18568,19662,19227,19663,33633,19661,19678,33637,33640,33638,115546,21411,21434,35001,22940,19197,19195,19194,66540,66541,19223,47575,66542,19185,66553,19664,19180,21655,23263,19331,23483,23273,20808,50139,19246,19338,50140,18593,5202,19680,19475,22987,18940,23449,25885,25138,19202,25140,50145,19075,19216,25143,25141,25136,25134,25135,25137,25115,19715,24938,24932,50021,25167,50019,50020,50016,24928,50018,50017,19120,50127,18166,19684,22497,18525,52268,50137,50136,50130,50128,50012,18893,27667,50013,50010,27666,20331,25153,50007,25142,52278,20791,25155,52277,19687,21432,19170,50025,50023,18481,50024,24936)); +DELETE FROM `creature_template_difficulty` WHERE (`DifficultyID`=0 AND `Entry` IN (19337,19153,19390)); +INSERT INTO `creature_template_difficulty` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `HealthScalingExpansion`, `HealthModifier`, `ManaModifier`, `CreatureDifficultyID`, `TypeFlags`, `TypeFlags2`, `VerifiedBuild`) VALUES +(19337, 0, 0, 0, 870, 1, 1, 1, 15165, 0, 0, 48526), +(19153, 0, 0, 0, 870, 1, 1, 1, 14944, 0, 0, 48526), +(19390, 0, 0, 0, 870, 1, 1, 1, 15217, 0, 0, 48526); + +UPDATE `creature_template_difficulty` SET `VerifiedBuild`=48526 WHERE (`DifficultyID`=0 AND `Entry` IN (19213,22212,22213,19196,22208,19187,23699,25992,19033,22819,19283,19289,18584,24412,24410,24437,24370,24369,22442,19186,19064,23948,19182,23854,23855,23852,23853,23850,23845,23830,19271,18585,19270,25967,18762,18756,19076,18484,19077,23462,23463,19184,23464,23461,23433,23466,23465,18652,18653,18597,18600,24393,24416,24436,19163,19144,19045,19047,19164,19051,35002,19162,19150,19155,20124,20125,34999,35000,20123,18622,22326,22373,18596,22292,50143,20807,19318,23484,23270,19034,19321,19049,19074,22429,19052,33684,33683,19065,19063,19043,21906,24728,24727,20616,19378,19138,18538,19161,19050,19377,27711,19046,27723,21518,18549,19346,33680,33682,18537,33681,23271,19142,25195,33678,33675,19726,19720,19725,33676,33677,33674,33679,19702,33635,33641,33636,33631,33630,25196,33639,33634,19236,23272,19240,33615,20613,19251,19242,19234,33619,19245,19340,19235,18530,33613,33609,33612,33611,33610,33623,33617,33621,33616,33608,19252,19248,33618,33614,21905,33642,19249,19250,18531,19485,21816,19238,19232,18547,19243,18594,19239,19330,21517,19244,18568,19662,19227,19663,33633,19661,19678,33637,33640,33638,115546,21411,21434,35001,22940,19197,19195,19194,66540,66541,19223,47575,66542,19185,66553,19664,19180,21655,23263,19331,23483,23273,20808,50139,19246,19338,50140,18593,5202,19680,19475,22987,18940,23449,25885,25138,19202,25140,50145,19075,19216,25143,25141,25136,25134,25135,25137,25115,19715,24938,24932,50021,25167,50019,50020,50016,24928,50018,50017,19120,50127,18166,19684,22497,18525,52268,50137,50136,50130,50128,50012,18893,27667,50013,50010,27666,20331,25153,50007,25142,52278,20791,25155,52277,19687,21432,19170,50025,50023,18481,50024,24936)); +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `VerifiedBuild`=48526 WHERE (`Entry`=24411 AND `DifficultyID`=0); +UPDATE `creature_template_difficulty` SET `ContentTuningID`=825, `VerifiedBuild`=48526 WHERE (`Entry`=19665 AND `DifficultyID`=0); + +-- Models +UPDATE `creature_model_info` SET `VerifiedBuild`=48526 WHERE `DisplayID` IN (73866, 21344, 45621, 45620, 45619, 37819, 37818, 37817, 36969, 36970, 36971, 36972, 36968, 36967, 36966, 36965, 36964, 36958, 36959, 36960, 36961, 36962, 36963, 36954, 36951, 36945, 36946, 36947, 36949, 36950, 35700, 29519, 29518, 29517, 29516, 28809, 28808, 28807, 28806, 28805, 28804, 28803, 28802, 28801, 28800, 28799, 28770, 28797, 28796, 28792, 28793, 28794, 28798, 28795, 28791, 28790, 28789, 28788, 28758, 28738, 24761, 24730, 24731, 19926, 19282, 23467, 18743, 22968, 22954, 22955, 22956, 22959, 22957, 22931, 22763, 22752, 22757, 22753, 22929, 22930, 22928, 22939, 22940, 22927, 22925, 22944, 22942, 22926, 22936, 22924, 22933, 22932, 22918, 22914, 22922, 22768, 22762, 22759, 13069, 22747, 599, 22609, 1122, 22425, 22419, 22414, 17200, 7346, 22386, 22387, 17645, 21697, 21573, 21572, 21524, 21522, 21523, 21520, 21525, 21521, 21514, 21504, 21389, 21155, 19905, 21100, 17072, 21022, 20766, 15534, 20818, 20869, 20868, 20873, 16202, 15531, 19695, 20388, 17327, 16706, 338, 20290, 20279, 19795, 19794, 17082, 19699, 19698, 19132, 19130, 19131, 19355, 19356, 19354, 19160, 19159, 19156, 19153, 20168, 20170, 20167, 20169, 19127, 19129, 19108, 856, 19089, 19086, 19087, 19088, 18924, 18914, 18745, 18768, 18767, 18741, 18740, 18769, 18770, 18735, 18733, 18704, 18703, 18702, 18707, 18706, 18691, 18689, 18773, 18775, 18772, 18774, 18771, 18766, 18765, 18764, 18763, 18762, 18761, 18760, 18759, 18758, 18757, 18756, 18754, 18664, 18663, 22951, 18656, 18648, 18642, 18641, 18640, 18639, 18630, 18629, 18627, 18625, 18626, 18623, 18617, 18618, 18619, 19091, 14616, 19315, 19314, 14589, 19092, 152, 11650, 17544, 17628, 17627, 18567, 18566, 18568, 18569, 18558, 18559, 18543, 18542, 18544, 18539, 18540, 18541, 18551, 18548, 18550, 18552, 18528, 18529, 18530, 18524, 18522, 18521, 18520, 18518, 18489, 18519, 18517, 18516, 18499, 18496, 18495, 17867, 18487, 18485, 17859, 18482, 18480, 18481, 18475, 18472, 20969, 20659, 18156, 18148, 221, 18044, 17191, 18024, 18026, 18027, 18022, 18021, 18020, 18019, 18016, 18017, 18018, 11548, 18405, 17972, 17904, 17905, 17903, 17907, 17892, 17893, 17895, 17894, 17882, 17881, 17878, 17875, 17870, 17689, 18135, 56765, 11686, 3020, 2176, 1418, 1141, 304); +UPDATE `creature_template_model` SET `VerifiedBuild`=48526 WHERE (`Idx`=0 AND `CreatureID` IN (25992,23466,24393,20123,19153,18549,18531,19232,21434,24423,18484,18653,35002,19321,19049,24728,33678,33676,20613,33623,33612,18568,50139,22212,19289,23853,19045,19051,20124,19318,23271,33679,19242,66541,19202,23462,18596,19074,33682,19142,33639,19249,25138,25134,19213,23948,23830,23464,20125,19034,33641,19236,19235,33614,19185,50013,22373,19378,19161,27711,19240,33611,19248,33638,35001,66542,19338,50019,19046,21905,50145,25135,52278,18481,18756,23461,23465,19155,4075,19052,33635,18940,25167,50020,50017,19076,19163,33630,66553,27667,50012,50016,18166,25142,50023,19196,23699,19182,23845,25967,35000,24727,19346,33636,33642,21517,19663,50128,20331,21432,24370,23852,19184,20616,19390,19725,23449,50024,305,18585,19377,33619,33617,33608,19238,19715,19687,304,19337,24429,19064,23433,19047,19150,19665,23270,19050,18537,33681,33677,33631,19661,19223,19331,19246,19216,25137,52268,356,24412,19271,18652,19144,18538,33616,23273,50140,19075,19120,50025,35362,19187,23484,19063,33634,19245,19485,19243,20808,5202,25885,25064,24437,19077,19726,18594,33640,19678,50007,14505,22208,18600,24436,19138,33610,19197,21655,24938,50136,68288,19186,22326,50143,33683,33680,19250,21816,19180,18379,22819,19283,18584,22429,21906,21518,33675,19251,19330,19244,115546,33633,19227,19194,19664,18593,25115,64993,19162,34999,18622,19065,19234,33621,33609,19195,25143,40625,24416,20807,25195,19239,47575,23263,23483,19475,18893,52277,50137,19170,50010,24928,24936,65011,22213,19033,23854,19270,18597,15214,22292,19720,18530,33618,33613,19252,22940,25136,24932,18525,27666,47654,22442,23850,23463,19164,33684,27723,19702,25196,23272,19340,33615,18547,33637,19662,50018,19684,22497,50021,25153,50130,25155,50127,59072,24369,23855,18762,19043,33674,21411,66540,620,19680,22987,25140,25141,20791,71486)) OR (`Idx`=3 AND `CreatureID` IN (19153,18549,19289,19142,25134,19161,25135,19155,19163,25142,19390,19377,19687,19337,19150,25137,19075,19120,18600,19138,19283,18593,25195,19170,25136,19164,19702,18547,25153,25155,22987)) OR (`Idx`=2 AND `CreatureID` IN (19153,18549,19289,19142,25134,19161,25135,19155,4075,19163,25142,20331,19390,19377,19687,19337,19150,25137,19144,19075,19120,19077,18600,19138,19283,18593,25195,19170,25136,19164,19702,18547,19684,25153,25155,22987)) OR (`Idx`=1 AND `CreatureID` IN (19153,18549,19289,23853,19142,25134,23830,19161,25135,19155,4075,19076,19163,25142,23845,20331,23852,19390,19377,19687,19337,19150,19665,25137,24412,19144,19075,19120,24437,19077,18600,19138,24938,19283,18593,25115,19162,25195,19475,19170,24928,24936,23854,15214,25136,23850,19164,27723,19702,18547,19684,25153,25155,23855,22987)); + +-- Gameobject templates +DELETE FROM `gameobject_template_addon` WHERE `entry` IN (280815 /*Letter from Ms. Graham*/, 280814 /*Pyramid*/, 280813 /*Fish*/, 280812 /*Feather*/); +INSERT INTO `gameobject_template_addon` (`entry`, `faction`, `flags`, `WorldEffectID`, `AIAnimKitID`) VALUES +(280815, 0, 262144, 0, 0), -- Letter from Ms. Graham +(280814, 1375, 0, 0, 0), -- Pyramid +(280813, 1375, 0, 0, 0), -- Fish +(280812, 1375, 0, 0, 0); -- Feather + +UPDATE `gameobject_template_addon` SET `flags`=32 WHERE `entry`=183294; -- The Shadow Labyrinth +UPDATE `gameobject_template_addon` SET `faction`=35 WHERE `entry`=184911; -- Invisible Cooking Object |