diff options
| -rw-r--r-- | sql/updates/world/master/2023_06_28_09_world.sql | 45 |
1 files changed, 45 insertions, 0 deletions
diff --git a/sql/updates/world/master/2023_06_28_09_world.sql b/sql/updates/world/master/2023_06_28_09_world.sql new file mode 100644 index 00000000000..f01acb3ba18 --- /dev/null +++ b/sql/updates/world/master/2023_06_28_09_world.sql @@ -0,0 +1,45 @@ +-- Creature templates +UPDATE `creature_template` SET `speed_walk`=1, `unit_flags3`=8912896 WHERE `entry`=22069; -- Air Force Alarm Bot (Stormspire) +UPDATE `creature_template` SET `unit_flags3`=8912896 WHERE `entry`=21974; -- Air Force Alarm Bot (Area 52) +UPDATE `creature_template` SET `speed_walk`=1, `speed_run`=2.142857074737548828 WHERE `entry`=21267; -- Mana Beast +UPDATE `creature_template` SET `speed_walk`=1, `speed_run`=0.857142865657806396 WHERE `entry`=21135; -- Fel Imp +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=20930; -- Hatecryer +UPDATE `creature_template` SET `unit_flags`=33587456, `unit_flags3`=524288 WHERE `entry`=20796; -- Netherstorm Target +UPDATE `creature_template` SET `speed_walk`=4, `unit_flags3`=524288 WHERE `entry`=20782; -- Ethereum Archon Energy Cell +UPDATE `creature_template` SET `speed_walk`=1, `unit_flags3`=524288 WHERE `entry`=20498; -- Sundered Shard +UPDATE `creature_template` SET `speed_walk`=1, `speed_run`=1.142857193946838378 WHERE `entry`=20132; -- Socrethar +UPDATE `creature_template` SET `speed_walk`=1, `unit_flags3`=524288 WHERE `entry`=19913; -- Area 52 Spotlight +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=19653; -- Glacius +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=19635; -- Captain Arathyn +UPDATE `creature_template` SET `npcflag`=3 WHERE `entry`=19481; -- Archmage Vargoth +UPDATE `creature_template` SET `unit_flags3`=524288 WHERE `entry`=17066; -- Ribbon Pole Debug Target +UPDATE `creature_template` SET `faction`=1733 WHERE `entry`=16781; -- Midsummer Celebrant +UPDATE `creature_template` SET `unit_flags2`=0, `unit_flags3`=524288 WHERE `entry`=16592; -- Midsummer Bonfire + +-- Difficulty +DELETE FROM `creature_template_difficulty` WHERE (`DifficultyID`=1 AND `Entry` IN (143231,107619,107610,107599,72823,64374,62627,62625,58152,54650,54649,54648,40209,29145,28344,28343,26355,26258,25994,25962,24977,24974,23396,22899,22822,22821,22494,22491,22479,22427,22358,22350,22348,22293,22280,22279,22068,22065,22063,21997,21923,21805,21783,21751,21734,21733,21732,21493,21262,21261,21259,21233,21157,21090,21089,21065,21058,20989,20985,20984,20981,20980,20934,20933,20928,20922,20921,20913,20907,20903,20899,20871,20858,20825,20811,20810,20804,20803,20801,20800,20780,20778,20777,20775,20774,20773,20772,20770,20769,20764,20755,20727,20685,20676,20673,20671,20634,20611,20610,20608,20607,20561,20554,20552,20520,20516,20515,20512,20501,20495,20485,20484,20483,20476,20475,20474,20473,20471,20470,20464,20463,20459,20458,20456,20454,20453,20452,20451,20450,20449,20448,20447,20435,20415,20411,20410,20409,20404,20397,20394,20393,20389,20341,20340,20338,20337,20336,20333,20332,20326,20296,20285,20248,20243,20242,20226,20221,20215,20210,20207,20205,20204,20203,20202,20194,20162,20154,20153,20148,20141,20140,20139,20138,20136,20135,20134,20133,20112,20111,20110,20102,20092,20084,20071,20068,20067,20066,19940,19939,19926,19881,19880,19868,19867,19866,19853,19852,19849,19845,19840,19839,19832,19831,19830,19780,19779,19776,19738,19737,19731,19728,19727,19724,19723,19709,19707,19705,19690,19686,19656,19655,19654,19651,19645,19643,19642,19641,19634,19623,19621,19620,19619,19618,19617,19612,19610,19593,19589,19588,19583,19582,19578,19576,19575,19574,19573,19572,19571,19570,19569,19568,19565,19554,19550,19549,19548,19547,19546,19545,19544,19543,19541,19540,19539,19538,19537,19536,19535,19534,19533,19531,19529,19494,19489,19488,19484,19483,19482,19481,19469,19468,19467,19466,19453,19439,19437,19421,19336,19217,18938,18886,18885,18884,18883,18882,18881,18880,18879,18877,18875,18873,18872,18870,18869,18867,18866,18865,18864,18860,18859,18858,18857,18856,18855,18853,18852,18850,18593,17636,17408,16949,16948,16944,16943,16781,15384,6368,6271,2334)); + +UPDATE `creature_template_difficulty` SET `DifficultyID`=0 WHERE (`DifficultyID`=1 AND `Entry` IN (26520,26401,25918,25913,23491,22351,22069,21974,21267,21135,20931,20930,20929,20920,20796,20782,20553,20551,20498,20416,20281,20132,19913,19657,19653,19635,17066,16592)); +UPDATE `creature_template_difficulty` SET `VerifiedBuild`=50000 WHERE (`DifficultyID`=0 AND `Entry` IN (26520,26401,25918,25913,23491,22351,22069,21974,21267,21135,20931,20930,20929,20920,20796,20782,20553,20551,20498,20416,20281,20132,19913,19657,19653,19635,17066,16592,143231,107619,107610,107599,72823,64374,62627,62625,58152,54650,54649,54648,40209,29145,28344,28343,26355,26258,25994,25962,24977,24974,23396,22899,22822,22821,22494,22491,22479,22427,22358,22350,22348,22293,22280,22279,22068,22065,22063,21997,21923,21805,21783,21751,21734,21733,21732,21493,21262,21261,21259,21233,21157,21090,21089,21065,21058,20989,20985,20984,20981,20980,20934,20933,20928,20922,20921,20913,20907,20903,20899,20871,20858,20825,20811,20810,20804,20803,20801,20800,20780,20778,20777,20775,20774,20773,20772,20770,20769,20764,20755,20727,20685,20676,20673,20671,20634,20611,20610,20608,20607,20561,20554,20552,20520,20516,20515,20512,20501,20495,20485,20484,20483,20476,20475,20474,20473,20471,20470,20464,20463,20459,20458,20456,20454,20453,20452,20451,20450,20449,20448,20447,20435,20415,20411,20410,20409,20404,20397,20394,20393,20389,20341,20340,20338,20337,20336,20333,20332,20326,20296,20285,20248,20243,20242,20226,20221,20215,20210,20207,20205,20204,20203,20202,20194,20162,20154,20153,20148,20141,20140,20139,20138,20136,20135,20134,20133,20112,20111,20110,20102,20092,20084,20071,20068,20067,20066,19940,19939,19926,19881,19880,19868,19867,19866,19853,19852,19849,19845,19840,19839,19832,19831,19830,19780,19779,19776,19738,19737,19731,19728,19727,19724,19723,19709,19707,19705,19690,19686,19656,19655,19654,19651,19645,19643,19642,19641,19634,19623,19621,19620,19619,19618,19617,19612,19610,19593,19589,19588,19583,19582,19578,19576,19575,19574,19573,19572,19571,19570,19569,19568,19565,19554,19550,19549,19548,19547,19546,19545,19544,19543,19541,19540,19539,19538,19537,19536,19535,19534,19533,19531,19529,19494,19489,19488,19484,19483,19482,19481,19469,19468,19467,19466,19453,19439,19437,19421,19336,19217,18938,18886,18885,18884,18883,18882,18881,18880,18879,18877,18875,18873,18872,18870,18869,18867,18866,18865,18864,18860,18859,18858,18857,18856,18855,18853,18852,18850,18593,17636,17408,16949,16948,16944,16943,16781,15384,6368,6271,2334)); + +UPDATE `creature_questitem` SET `VerifiedBuild`=50000 WHERE (`CreatureEntry`=20332 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=18877 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=20607 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=18884 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=20773 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=20673 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=20671 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=19852 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=20243 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=20610 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=20931 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=20775 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=20777 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=20634 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=21058 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=18880 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=18880 AND `DifficultyID`=0 AND `Idx`=0); + +-- Models +UPDATE `creature_model_info` SET `VerifiedBuild`=50000 WHERE `DisplayID` IN (88088, 70200, 70198, 70195, 50854, 45988, 2177, 40011, 27942, 23768, 22393, 29078, 25624, 7341, 10746, 8409, 23789, 23791, 16340, 23438, 22790, 22780, 21462, 21132, 21103, 21102, 21061, 21060, 21062, 21051, 21045, 17647, 18671, 20906, 20905, 20606, 20438, 20430, 20429, 20428, 20326, 14273, 20171, 18505, 16890, 20060, 20061, 19239, 20035, 20032, 20031, 19964, 20050, 19918, 19919, 5238, 19912, 18525, 19486, 19904, 19903, 19896, 19891, 9832, 19881, 19655, 19200, 20751, 19899, 17200, 19782, 15380, 19779, 19776, 19775, 2850, 19774, 19739, 19722, 19704, 19705, 19758, 19771, 37779, 19695, 19681, 19676, 19675, 21072, 19917, 20043, 8834, 11710, 5050, 11375, 11377, 11376, 1122, 7919, 19657, 19654, 20988, 19642, 19641, 19638, 19637, 19635, 19633, 19632, 19631, 19634, 19648, 19629, 19628, 19653, 20095, 20096, 19610, 19603, 19602, 19601, 19593, 20097, 19579, 19578, 19580, 19626, 19540, 19537, 18646, 14501, 18659, 19512, 19511, 19513, 19514, 19501, 17773, 17776, 8612, 17716, 19446, 19445, 19443, 19444, 19421, 19417, 19419, 19420, 19418, 19414, 19660, 19381, 19293, 19459, 19460, 19464, 19465, 19463, 17446, 19492, 19491, 19120, 19466, 19469, 19467, 19468, 19359, 19358, 19382, 19380, 29243, 16431, 21019, 17689, 17685, 20101, 19119, 16946, 19238, 19237, 19664, 19645, 16269, 6173, 19357, 19210, 19203, 19205, 19202, 19198, 19496, 19494, 19495, 19493, 19197, 18370, 19167, 19288, 19285, 18274, 19287, 19161, 17612, 19151, 19442, 19440, 19441, 19439, 19150, 19502, 19084, 13069, 4606, 17907, 17904, 17903, 19079, 19461, 19462, 20985, 18848, 19111, 39831, 19047, 19046, 19043, 19038, 19076, 19077, 19019, 19013, 6889, 15200, 19004, 18174, 10742, 7098, 7099, 10743, 20622, 19000, 18999, 18998, 18997, 20011, 17188, 18978, 18973, 18972, 18971, 18967, 18969, 18968, 18966, 18660, 20987, 19957, 19956, 19955, 19959, 19960, 19301, 18928, 18927, 18920, 19284, 18905, 18906, 18903, 20518, 19488, 19487, 19490, 19489, 15880, 18685, 18661, 37716, 19458, 18700, 19979, 19690, 19456, 19662, 19416, 19435, 19272, 19650, 19102, 19100, 19099, 19101, 19103, 19106, 19107, 19104, 18990, 18050, 19003, 15438, 19916, 19672, 19586, 18699, 18448, 19126, 19125, 19201, 19116, 19117, 19118, 19115, 19449, 19450, 19451, 19448, 19122, 19121, 19124, 19123, 19453, 19452, 18016, 18018, 18019, 17138, 17054, 19190, 19189, 19035, 19168, 16436, 16443, 16446, 16432, 16413, 16412, 16414, 16447, 5555, 5586, 5556, 4960, 4959, 11686); +UPDATE `creature_template_model` SET `VerifiedBuild`=50000 WHERE (`Idx`=0 AND `CreatureID` IN (19705,20561,20332,20111,20448,16944,16948,19727,18865,20338,25962,20811,20204,20473,21157,22351,20929,20551,18870,18877,19619,19731,19543,21733,20485,19536,18858,20922,64374,20248,19657,20154,19568,20397,19547,20135,19642,19779,72823,19612,58152,54649,19621,19849,20133,18860,20326,20769,20066,20409,19481,20336,20337,18857,19217,17066,18938,19582,18872,19535,21135,20930,62627,22479,19728,19723,19634,26355,107610,19655,22068,20931,16943,19656,19421,20803,21267,18883,20140,20110,20452,20520,20921,20810,20194,19867,19881,19831,19852,19686,19643,107619,20871,20205,20685,20210,20340,20778,19738,20934,20498,21259,16781,20484,20202,20913,20516,15384,304,19565,20153,20903,20933,20404,21065,20410,20463,19839,20243,26258,19469,19845,21751,19654,19610,20084,20242,19534,20067,22069,64993,20501,20673,20671,19939,20415,19868,19453,18593,18873,19538,2334,21233,22293,18882,20341,14505,20447,20474,20796,25918,19574,19570,19832,19589,20394,40625,22494,19940,19489,19635,29145,17636,22279,20102,40165,22491,20727,19866,19549,18875,20333,21262,19571,22280,54648,54650,21058,20470,18859,20112,17408,21089,18880,54741,20984,20450,22822,20221,19724,21732,19651,19880,19645,19588,19583,20801,19437,20804,19483,71486,20139,20825,20773,20495,18867,19840,19830,20136,20772,26401,107599,20476,28363,20608,20451,20449,20858,19707,19550,18852,28343,20389,19573,19617,143231,19575,21997,22063,19541,20981,19529,20775,20777,20634,20132,59072,20552,19554,20071,20454,20782,19620,19545,19546,20134,19468,19780,40209,18864,20800,21923,22899,19539,20610,20774,20141,62625,356,20676,20453,19926,24974,19709,22358,20068,18879,305,20899,20770,20607,22821,19593,20483,19494,19548,19690,25994,19623,21493,19531,18886,22350,20920,20203,25064,20435,20554,20553,19336,20459,19618,19544,18855,21261,19913,20989,20980,19484,47654,19653,19488,18866,18885,18856,25913,28344,19572,23396,19578,20928,19569,56921,20092,20764,18884,20411,20464,6368,18853,21734,21974,20162,22065,20475,20780,65011,20515,18869,20985,20907,20456,20296,20416,19776,19482,19467,19466,16949,22348,20393,18379,21090,21783,20512,18850,19853,19641,26520,19737,18881,19540,19537,19533,20138,20148,23491,20226,68288,20207,21805,20755,20458,20611,20281,6271,20215,19439,16592,24977,19576,20471,22427,20285,35362)) OR (`Idx`=3 AND `CreatureID` IN (20561,19731,20922,20248,19779,18872,16781,19453,18593,18873,21058,19651,19707,18852,19541,20134,18855,6368,18853,20207)) OR (`Idx`=2 AND `CreatureID` IN (20561,19731,20485,20922,20248,19779,18872,19881,20934,16781,19610,19453,18593,18873,22494,21058,19651,20139,19707,18852,19541,20134,20203,18855,6368,18853,20207)) OR (`Idx`=1 AND `CreatureID` IN (20561,19727,20473,21157,19731,20485,20922,20248,20135,19779,20769,18857,18872,19723,19655,22068,19656,19421,20140,20520,19867,19881,19643,20934,16781,15384,20933,19654,19610,22069,19939,19868,19453,18593,18873,20796,22494,20102,40165,19866,21262,21058,21089,20221,19724,19651,19437,20804,19483,20139,20825,20136,20476,20608,20858,19707,18852,21997,22063,19541,19529,20782,20134,20676,22358,20203,19336,18855,21261,19484,20764,6368,18853,21974,22065,20475,20296,21090,18850,23491,20226,20207,20755,6271,19439,24977)); + +-- Gameobject templates +UPDATE `gameobject_template` SET `VerifiedBuild`=50000 WHERE `entry` IN (182418, 183814, 195264, 184072, 184612, 186137, 184510, 181915, 182430, 182422, 182419, 184433, 269966, 182811, 186729, 184507, 184589, 160871, 184121, 182421, 182447, 183945, 183807, 183768, 181281, 184584, 160869, 182420, 248956, 182443, 182413, 188020, 183811, 181393, 184296, 184447, 183935, 182415, 183805, 184665, 184678, 184680, 184579, 184590, 182433, 182429, 182414, 183767, 186139, 184670, 160870, 182424, 182439, 179975, 182788, 195256, 182559, 184443, 184056, 183806, 186141, 186140, 176583, 184298, 184674, 184514, 184585, 184310, 182426, 182450, 182445, 182437, 184124, 184050, 184052, 183306, 183270, 188021, 184297, 183097, 184681, 183956, 182810, 186142, 181355, 184667, 184682, 184512, 184253, 182434, 182441, 180037, 195253, 184607, 184430, 214500, 184509, 184560, 182436, 184672, 184426, 184513, 184073, 182449, 182451, 182440, 183813, 184051, 184421, 184031, 184508, 184516, 184108, 184077, 184252, 182432, 182416, 184053, 183770, 181302, 182605, 183047, 181555, 181557, 184431, 184418, 184583, 184581, 184300, 182438, 182452, 182427, 184320, 184071, 278676, 181392, 184117, 183098, 181556, 184428, 184254, 160868, 182428, 182809, 181306, 259114, 2041, 181569, 184422, 184429, 184732, 184145, 184383, 182431, 182423, 183268, 181401, 184669, 184675, 184668, 184671, 184427, 184425, 184735, 184677, 184434, 184055, 182448, 182442, 183947, 184092, 181270, 184424, 184998, 160867, 184123, 182425, 183266, 184054, 183808, 184152, 187299, 181605, 187667, 183048, 184420, 184676, 184511, 183269, 191817, 183298, 183297, 187572, 184255, 181271, 183507, 183299, 195257, 183096, 184423, 186138, 184075, 184582, 184613, 182435, 182446, 181307, 184488, 184419, 184515, 160866, 183267, 183300, 183771, 184070, 184295, 184666, 184588, 184734, 184679, 184580, 184265, 184078, 182444, 182417, 184122, 184085, 184608, 184673, 181279, 184330); +UPDATE `gameobject_template` SET `ContentTuningId`=394, `VerifiedBuild`=50000 WHERE `entry`=187949; -- Horde Bonfire +UPDATE `gameobject_template` SET `Data3`=0, `Data6`=0, `ContentTuningId`=394, `VerifiedBuild`=50000 WHERE `entry`=181377; -- Midsummer Bonfire Campfire Spell Focus +UPDATE `gameobject_template` SET `ContentTuningId`=42, `VerifiedBuild`=50000 WHERE `entry`=184312; -- Ara Control Console +UPDATE `gameobject_template` SET `ContentTuningId`=394, `VerifiedBuild`=50000 WHERE `entry`=187942; -- Alliance Bonfire +UPDATE `gameobject_template` SET `ContentTuningId`=42, `VerifiedBuild`=50000 WHERE `entry`=184109; -- Ethereal Teleport Pad +UPDATE `gameobject_template` SET `ContentTuningId`=42, `VerifiedBuild`=50000 WHERE `entry`=184143; -- Arklon Brazier +UPDATE `gameobject_template` SET `Data26`=1, `ContentTuningId`=42, `VerifiedBuild`=50000 WHERE `entry`=184615; -- Crystal + +UPDATE `gameobject_template_addon` SET `flags`=34 WHERE `entry`=184488; -- Salvaged Ethereum Prison +UPDATE `gameobject_template_addon` SET `flags`=4 WHERE `entry`=184310; -- Suspicious Outhouse +UPDATE `gameobject_template_addon` SET `faction`=35 WHERE `entry`=181377; -- Midsummer Bonfire Campfire Spell Focus + +UPDATE `gameobject_questitem` SET `VerifiedBuild`=50000 WHERE (`Idx`=0 AND `GameObjectEntry` IN (184075,184031,184077,184560,184443,183935,184310,184123,184122,184589,184121,183945,183814,183813,183767,184607,184433,186729)); |