diff options
| -rw-r--r-- | sql/updates/world/master/2023_07_04_02_world.sql | 121 |
1 files changed, 121 insertions, 0 deletions
diff --git a/sql/updates/world/master/2023_07_04_02_world.sql b/sql/updates/world/master/2023_07_04_02_world.sql new file mode 100644 index 00000000000..b32910593d9 --- /dev/null +++ b/sql/updates/world/master/2023_07_04_02_world.sql @@ -0,0 +1,121 @@ +-- Creature templates +UPDATE `creature_template` SET `faction`=1720, `speed_walk`=6.40000009536743164, `speed_run`=2.857142925262451171, `BaseAttackTime`=2000, `unit_flags`=33554688, `unit_flags2`=2048 WHERE `entry`=174261; -- Infernal Emitter +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=24933; -- Suspended Terrorguard +UPDATE `creature_template` SET `speed_walk`=1, `speed_run`=1.142857193946838378 WHERE `entry`=24918; -- Felblood Initiate +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=22461; -- Fel Cannon MKI +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=22403; -- Zeth'Gor Quest Credit Marker, They Must Burn, Tower Foothill +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=22402; -- Zeth'Gor Quest Credit Marker, They Must Burn, Tower Forge +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=22401; -- Zeth'Gor Quest Credit Marker, They Must Burn, Tower North +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=21391; -- Scarab Bunny +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=21182; -- Zeth'Gor Quest Credit Marker, They Must Burn, Tower South +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=21173; -- Zeth'Gor Quest Credit Marker, They Must Burn +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=20816; -- Zeth'Gor Quest Credit Marker, West Hovel +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=20815; -- Zeth'Gor Quest Credit Marker, East Hovel +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=20814; -- Zeth'Gor Quest Credit Marker, Stable +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=20813; -- Zeth'Gor Quest Credit Marker, Barracks +UPDATE `creature_template` SET `speed_walk`=1, `speed_run`=1.142857193946838378 WHERE `entry`=20798; -- Razorsaw +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=20679; -- Aylaan the Waterwaker +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=20678; -- Akoru the Firecaller +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=20677; -- Morod the Windstirrer +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=20251; -- Honor Hold Scout Archery Target +UPDATE `creature_template` SET `npcflag`=4737 WHERE `entry`=20231; -- Supply Officer Pestle +UPDATE `creature_template` SET `unit_flags`=33536, `unit_flags2`=2048 WHERE `entry`=20158; -- Slime-Covered Corpse +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=19681; -- Void Spawner L +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=19527; -- Vacillating Voidcaller +UPDATE `creature_template` SET `faction`=1651, `speed_run`=1.142857193946838378 WHERE `entry`=19461; -- Tamed Ravager +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=19440; -- Eye of Grillok +UPDATE `creature_template` SET `unit_flags2`=2097152 WHERE `entry`=19400; -- Fel Reaver Sentry +UPDATE `creature_template` SET `speed_run`=1.142857193946838378, `unit_flags2`=2097152 WHERE `entry`=19399; -- Fel Cannon +UPDATE `creature_template` SET `unit_flags2`=2097152 WHERE `entry`=19398; -- Gan'arg Peon +UPDATE `creature_template` SET `speed_walk`=1, `speed_run`=1.142857193946838378, `unit_flags2`=2097152 WHERE `entry`=19397; -- Mo'arg Overseer +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=19361; -- Naladu +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=19354; -- Arzeth the Merciless +UPDATE `creature_template` SET `faction`=1737, `speed_walk`=1 WHERE `entry`=19324; -- Armored Gryphon Destroyer +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=19282; -- Subjugator Shi'aziv +UPDATE `creature_template` SET `unit_flags3`=524288 WHERE `entry`=19259; -- Infernal Invader +UPDATE `creature_template` SET `faction`=1759, `unit_flags2`=0 WHERE `entry`=19225; -- Strength of the Storm Totem +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=19192; -- Mistress of Doom +UPDATE `creature_template` SET `speed_walk`=1, `speed_run`=1.142857193946838378 WHERE `entry`=19191; -- Arazzius the Cruel +UPDATE `creature_template` SET `faction`=1754 WHERE `entry`=19005; -- Wrath Master +UPDATE `creature_template` SET `npcflag`=80 WHERE `entry`=18990; -- Burko +UPDATE `creature_template` SET `speed_walk`=1, `speed_run`=1.142857193946838378 WHERE `entry`=18976; -- Urga'zz +UPDATE `creature_template` SET `unit_flags2`=2099200, `unit_flags3`=524288 WHERE `entry`=18946; -- Infernal Siegebreaker +UPDATE `creature_template` SET `faction`=1754 WHERE `entry`=18944; -- Fel Soldier +UPDATE `creature_template` SET `unit_flags`=768, `unit_flags2`=2048 WHERE `entry`=17062; -- Fel Orc Corpse +UPDATE `creature_template` SET `unit_flags3`=1 WHERE `entry`=17060; -- Hellfire Combat Dummy Small +UPDATE `creature_template` SET `unit_flags3`=1 WHERE `entry`=17059; -- Hellfire Combat Dummy +UPDATE `creature_template` SET `npcflag`=3 WHERE `entry`=17015; -- Taleris Dawngazer +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=16951; -- Terrorfiend +UPDATE `creature_template` SET `speed_walk`=1, `speed_run`=1.142857193946838378 WHERE `entry`=16946; -- Mo'arg Forgefiend +UPDATE `creature_template` SET `faction`=31, `speed_walk`=0.800000011920928955, `speed_run`=0.714285731315612792 WHERE `entry`=16927; -- Stonescythe Whelp +UPDATE `creature_template` SET `faction`=1734 WHERE `entry`=16781; -- Midsummer Celebrant +UPDATE `creature_template` SET `faction`=1668, `unit_flags`=0 WHERE `entry`=16582; -- Thrallmar Marksman + +-- Difficulty +UPDATE `creature_template_difficulty` SET `DifficultyID`=0 WHERE (`DifficultyID`=1 AND `Entry` IN (174261,66550,66533,66532,66531,51904,51903,51800,26223,26222,25934,25900,24937,24933,24919,24918,22461,22403,22402,22401,22323,22231,22177,22107,21847,21391,21279,21257,21182,21173,21133,20816,20815,20814,20813,20798,20793,20679,20678,20677,20251,20238,20237,20236,20235,20234,20232,20231,20195,20158,19937,19836,19766,19764,19763,19736,19717,19683,19682,19681,19652,19624,19562,19561,19560,19559,19558,19527,19461,19459,19458,19457,19455,19451,19447,19446,19445,19442,19440,19434,19432,19424,19423,19422,19409,19401,19400,19399,19398,19397,19367,19361,19359,19358,19354,19344,19335,19332,19329,19328,19326,19324,19316,19315,19314,19310,19309,19299,19298,19292,19291,19282,19279,19278,19277,19276,19275,19273,19264,19261,19259,19229,19225,19192,19191,19190,19136,19028,19008,19005,18986,18981,18978,18977,18976,18975,18972,18971,18969,18966,18965,18949,18948,18946,18945,18944,18931,18930,18849,18818,18677,17123,17084,17062,17060,17059,17057,17053,17035,17014,16993,16978,16977,16976,16972,16967,16966,16964,16960,16959,16951,16950,16947,16946,16915,16912,16911,16907,16906,16905,16904,16903,16901,16873,16871,16858,16848,16847,16846,16845,16576)); +UPDATE `creature_template_difficulty` SET `VerifiedBuild`=50000 WHERE (`DifficultyID`=0 AND `Entry` IN (174261,132930,66550,66533,66532,66531,61326,61325,51904,51903,51800,49789,47574,47573,35101,35100,35099,35093,30735,30734,30722,30721,26223,26222,25934,25900,24959,24937,24933,24921,24919,24918,22833,22467,22461,22432,22431,22430,22403,22402,22401,22323,22231,22227,22225,22177,22107,22003,22002,22001,21999,21996,21993,21847,21391,21283,21279,21257,21256,21237,21236,21209,21182,21175,21173,21133,20816,20815,20814,20813,20798,20793,20781,20679,20678,20677,20617,20513,20251,20238,20237,20236,20235,20234,20232,20231,20206,20195,20158,19937,19871,19836,19766,19764,19763,19736,19717,19701,19683,19682,19681,19652,19624,19562,19561,19560,19559,19558,19527,19461,19459,19458,19457,19455,19452,19451,19447,19446,19445,19444,19443,19442,19440,19436,19435,19434,19432,19426,19425,19424,19423,19422,19415,19414,19413,19411,19410,19409,19408,19401,19400,19399,19398,19397,19393,19392,19376,19367,19363,19361,19359,19358,19354,19350,19349,19344,19335,19332,19329,19328,19326,19324,19316,19315,19314,19312,19310,19309,19308,19299,19298,19297,19295,19294,19293,19292,19291,19282,19279,19278,19277,19276,19275,19273,19264,19263,19261,19259,19258,19257,19256,19255,19253,19229,19225,19215,19192,19191,19190,19189,19188,19179,19136,19032,19029,19028,19009,19008,19007,19006,19005,19004,19001,18998,18997,18991,18990,18987,18986,18981,18978,18977,18976,18975,18974,18972,18971,18970,18969,18966,18965,18952,18950,18949,18948,18946,18945,18944,18942,18931,18930,18906,18905,18849,18828,18827,18818,18802,18785,18779,18777,18776,18775,18774,18773,18772,18771,18758,18755,18754,18753,18752,18751,18749,18748,18747,18733,18729,18677,18365,18364,18363,18359,18357,18267,18266,17795,17794,17657,17585,17403,17402,17282,17277,17263,17251,17250,17230,17226,17123,17084,17062,17060,17059,17058,17057,17053,17052,17046,17035,17015,17014,17006,17004,17002,16993,16991,16978,16977,16976,16975,16974,16973,16972,16968,16967,16966,16964,16960,16959,16954,16951,16950,16947,16946,16938,16937,16934,16933,16932,16929,16927,16925,16915,16912,16911,16907,16906,16905,16904,16903,16901,16899,16898,16897,16896,16888,16887,16886,16885,16884,16880,16879,16878,16876,16873,16871,16870,16867,16865,16864,16863,16858,16857,16856,16852,16848,16847,16846,16845,16844,16843,16842,16839,16838,16837,16836,16835,16834,16833,16832,16831,16830,16829,16828,16827,16826,16825,16824,16823,16822,16821,16820,16819,16799,16798,16797,16796,16795,16794,16793,16792,16791,16790,16789,16602,16600,16599,16598,16591,16590,16589,16588,16587,16586,16585,16584,16583,16582,16580,16579,16578,16577,16576,16575,16574,15476,15242,15241,12999,3300,3230,2615,2614)); + +DELETE FROM `creature_template_difficulty` WHERE (`DifficultyID`=1 AND `Entry` IN (174261,132930,66550,66533,66532,66531,61326,61325,51904,51903,51800,49789,47574,47573,35101,35100,35099,35093,30735,30734,30722,30721,26223,26222,25934,25900,24959,24937,24933,24921,24919,24918,22833,22467,22461,22432,22431,22430,22403,22402,22401,22323,22231,22227,22225,22177,22107,22003,22002,22001,21999,21996,21993,21847,21391,21283,21279,21257,21256,21237,21236,21209,21182,21175,21173,21133,20816,20815,20814,20813,20798,20793,20781,20679,20678,20677,20617,20513,20251,20238,20237,20236,20235,20234,20232,20231,20206,20195,20158,19937,19871,19836,19766,19764,19763,19736,19717,19701,19683,19682,19681,19652,19624,19562,19561,19560,19559,19558,19527,19461,19459,19458,19457,19455,19452,19451,19447,19446,19445,19444,19443,19442,19440,19436,19435,19434,19432,19426,19425,19424,19423,19422,19415,19414,19413,19411,19410,19409,19408,19401,19400,19399,19398,19397,19393,19392,19376,19367,19363,19361,19359,19358,19354,19350,19349,19344,19335,19332,19329,19328,19326,19324,19316,19315,19314,19312,19310,19309,19308,19299,19298,19297,19295,19294,19293,19292,19291,19282,19279,19278,19277,19276,19275,19273,19264,19263,19261,19259,19258,19257,19256,19255,19253,19229,19225,19215,19192,19191,19190,19189,19188,19179,19136,19032,19029,19028,19009,19008,19007,19006,19005,19004,19001,18998,18997,18991,18990,18987,18986,18981,18978,18977,18976,18975,18974,18972,18971,18970,18969,18966,18965,18952,18950,18949,18948,18946,18945,18944,18942,18931,18930,18906,18905,18849,18828,18827,18818,18802,18785,18779,18777,18776,18775,18774,18773,18772,18771,18758,18755,18754,18753,18752,18751,18749,18748,18747,18733,18729,18677,18365,18364,18363,18359,18357,18267,18266,17795,17794,17657,17585,17403,17402,17282,17277,17263,17251,17250,17230,17226,17123,17084,17062,17060,17059,17058,17057,17053,17052,17046,17035,17015,17014,17006,17004,17002,16993,16991,16978,16977,16976,16975,16974,16973,16972,16968,16967,16966,16964,16960,16959,16954,16951,16950,16947,16946,16938,16937,16934,16933,16932,16929,16927,16925,16915,16912,16911,16907,16906,16905,16904,16903,16901,16899,16898,16897,16896,16888,16887,16886,16885,16884,16880,16879,16878,16876,16873,16871,16870,16867,16865,16864,16863,16858,16857,16856,16852,16848,16847,16846,16845,16844,16843,16842,16839,16838,16837,16836,16835,16834,16833,16832,16831,16830,16829,16828,16827,16826,16825,16824,16823,16822,16821,16820,16819,16799,16798,16797,16796,16795,16794,16793,16792,16791,16790,16789,16602,16600,16599,16598,16591,16590,16589,16588,16587,16586,16585,16584,16583,16582,16580,16579,16578,16577,16576,16575,16574,15476,15242,15241,12999,3300,3230,2615,2614)); + +UPDATE `creature_questitem` SET `VerifiedBuild`=50000 WHERE (`CreatureEntry`=19423 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=19459 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=16933 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=19458 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=16932 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=19189 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=16934 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=17058 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=19349 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=19350 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=16880 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=19457 AND `DifficultyID`=0 AND `Idx`=2) OR (`CreatureEntry`=19457 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=19457 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=19312 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=17057 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=16863 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=16879 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=16950 AND `DifficultyID`=0 AND `Idx`=0); + +-- Models +UPDATE `creature_model_info` SET `VerifiedBuild`=50000 WHERE `DisplayID` IN (87656, 45230, 29279, 32670, 8189, 36625, 35699, 35698, 29610, 29609, 29608, 29603, 27300, 27299, 27285, 27284, 23726, 23735, 23738, 23737, 16341, 16335, 20919, 22979, 14533, 17021, 69906, 1394, 20876, 20875, 7051, 4110, 1814, 20128, 19721, 19720, 21065, 21064, 31174, 1913, 19384, 19207, 7109, 19791, 19148, 19789, 19790, 18684, 20740, 18995, 18994, 18993, 18992, 18991, 19196, 16887, 2352, 37576, 19346, 15455, 3336, 3337, 18893, 18892, 18891, 18890, 18889, 21025, 19345, 1377, 1602, 8610, 4259, 18852, 9562, 18850, 18857, 18863, 18864, 18866, 18865, 18835, 18822, 16630, 18820, 18817, 18819, 18818, 18368, 18776, 18755, 17767, 18753, 20063, 20308, 18744, 18738, 76348, 18731, 18730, 18729, 18725, 18739, 18716, 18715, 20047, 18690, 18708, 18709, 18712, 18694, 18686, 18679, 10906, 18678, 18675, 18677, 18676, 18674, 18673, 18672, 18669, 18668, 16998, 18371, 9129, 20062, 18878, 10215, 19792, 18531, 18445, 18442, 18433, 18432, 17651, 1715, 18457, 18458, 18419, 16480, 18251, 20045, 17210, 18408, 18455, 15578, 15577, 15579, 15574, 18409, 18443, 14613, 14615, 2306, 18855, 4601, 4602, 4260, 18452, 18453, 3167, 5446, 7950, 18622, 16685, 18666, 18665, 18305, 18304, 17457, 18204, 18246, 18182, 18185, 18184, 18175, 18173, 18179, 18171, 18177, 18150, 18149, 18186, 18176, 18180, 18172, 18151, 18183, 18181, 20761, 17701, 17700, 17699, 17696, 17694, 18486, 18488, 17160, 17111, 20328, 17001, 16957, 16955, 16956, 16948, 16723, 6298, 9990, 16926, 16867, 18434, 16743, 16741, 3019, 18311, 20554, 16724, 16729, 16725, 16648, 18953, 16636, 850, 4177, 16592, 16588, 16523, 16522, 16519, 16518, 16520, 16521, 16634, 17081, 17089, 16880, 16573, 16875, 17005, 16484, 10070, 18832, 18373, 6172, 20297, 20309, 19844, 20456, 19850, 16479, 16468, 18501, 18500, 19644, 17741, 18088, 16506, 16507, 16504, 16503, 16505, 16502, 10029, 1145, 16451, 16449, 16450, 16430, 16428, 16624, 16429, 14338, 14337, 14583, 14582, 16572, 11410, 18859, 18854, 18851, 18849, 18861, 18862, 20741, 16418, 16420, 16419, 18701, 16411, 16409, 16742, 19643, 16402, 18497, 18498, 16401, 16396, 16395, 16393, 16391, 16388, 16389, 16387, 16390, 16384, 88841, 88847, 16383, 17823, 17824, 16380, 16382, 16381, 16379, 16728, 17766, 16378, 16375, 16374, 16376, 16377, 16373, 16372, 16371, 16370, 16369, 16368, 16367, 16366, 16365, 16364, 16410, 16362, 17818, 18441, 16726, 16727, 16721, 16071, 16722, 16720, 16719, 16718, 16717, 16433, 16442, 21085, 16320, 207, 2327, 1166, 16318, 16316, 16315, 15227, 16312, 16310, 16307, 16308, 16306, 16305, 16304, 16303, 16302, 16301, 16300, 16299, 16297, 16298, 16296, 16295, 16292, 16294, 16954, 16286, 16288, 16287, 16289, 16285, 16284, 16283, 16281, 5905, 15471, 15469, 15470, 15303, 17202, 1987, 1986, 1206, 1872); +UPDATE `creature_model_info` SET `BoundingRadius`=0.305999994277954101, `CombatReach`=1.5, `VerifiedBuild`=50000 WHERE `DisplayID`=23740; +UPDATE `creature_model_info` SET `DisplayID_Other_Gender`=0, `VerifiedBuild`=50000 WHERE `DisplayID`=20742; +UPDATE `creature_model_info` SET `BoundingRadius`=5.806284427642822265, `CombatReach`=5.550000190734863281, `VerifiedBuild`=50000 WHERE `DisplayID`=18275; +UPDATE `creature_model_info` SET `BoundingRadius`=0.237142860889434814, `CombatReach`=1.016326546669006347, `VerifiedBuild`=50000 WHERE `DisplayID`=4566; +UPDATE `creature_template_model` SET `VerifiedBuild`=50000 WHERE (`Idx`=3 AND `CreatureID` IN (51904,19392,20513,51903,26223,16976,15476,16599,16831,61326,16884,16904,16578,51800,18950,16843,17263,16580,16835,18965,17282,16600,19937,16842,19432,19258,26222,18970)) OR (`Idx`=2 AND `CreatureID` IN (51904,16582,16865,19392,20513,51903,26223,3300,16976,19398,15476,19397,16599,16831,61326,16884,16904,16578,16896,51800,19624,18950,16843,17263,16580,16835,18965,16864,17282,16600,61325,19937,16842,19432,19258,26222,18970)) OR (`Idx`=1 AND `CreatureID` IN (51904,16838,20814,16582,16865,21391,19393,19329,16591,19717,19392,20813,19028,19359,20513,16905,21993,51903,19358,26223,18986,18972,22833,21173,3300,19215,20206,16976,18849,19681,19398,2615,16925,19291,15476,16912,19277,20781,19397,16599,18948,19425,16831,61326,16884,20815,24959,19179,16904,16897,20816,16847,19009,16578,19444,19376,16898,21999,16896,51800,22003,22001,19624,18950,16843,22403,22402,17263,18949,19328,18758,16836,16580,16835,16846,22002,19326,18965,16864,19029,19276,17282,20617,21236,19279,2614,16600,18729,174261,61325,19871,19937,16899,21996,17794,16842,19426,19032,17795,21237,18818,18971,22177,21182,22401,19292,19432,19008,16590,19258,19278,19652,20251,26222,24921,21252,18970)) OR (`Idx`=0 AND `CreatureID` IN (51904,16827,16838,16977,22467,16830,20814,16901,19192,16598,18747,19259,18749,16582,16879,18733,19455,19451,16865,16823,18802,21391,19393,18974,19329,16934,17251,16791,19294,19408,18827,16583,19255,18751,16591,19717,19445,19005,19392,18776,16828,25900,20813,19409,19293,19001,16834,16927,19028,17002,18752,24933,20793,16946,18754,18978,19701,19359,19452,18779,20513,18357,19367,16905,19558,19458,19442,16932,17250,19399,21993,51903,19315,19358,20235,19447,26223,18986,18972,22833,16832,21173,18905,16794,16790,17403,19264,18365,19261,19335,3300,19446,19215,20206,16976,19527,18849,19681,16795,16938,19350,16799,16880,19443,16585,47573,17585,16579,19398,2615,16925,16576,19291,19190,20238,15476,18931,19436,15241,16886,16820,17060,19459,21133,18998,16991,17123,16912,16903,19191,19413,17004,16870,19277,20237,18266,22227,16822,21279,16858,19424,17226,16789,16937,19349,20781,16848,18976,19397,18755,16599,18948,19425,19308,21209,19559,19422,16831,19263,16967,17015,18942,16792,20158,19764,16586,21175,20236,20798,18267,16876,66533,19282,16950,61326,18945,19006,35100,16825,16884,20815,16907,16966,16973,17059,35099,24959,20231,20232,18966,19179,16821,16978,16904,19332,16897,20816,16873,17084,20678,19188,17052,16847,21847,16878,19009,19410,18363,16578,49789,19229,19444,22431,16826,19376,19736,16898,21999,16896,51800,20679,22003,16852,16911,3230,22001,18977,19624,18950,19253,19007,16839,16843,22432,22403,22402,19314,17263,17230,17057,17006,16833,16863,18949,30721,18359,19344,19836,16964,17014,19328,16933,18758,16836,16915,19763,19298,18828,16574,22323,18981,18930,16580,22430,18771,19562,16835,16972,19361,19004,16797,16846,16857,18748,16587,22002,19326,16959,18965,16864,17058,18906,19029,19415,21256,24937,19275,19276,18773,30734,17053,17282,20617,16845,21236,18753,24919,16960,22461,16867,19279,19435,18944,18775,19363,35101,18987,16824,16906,18677,18997,17277,16968,2614,16600,30722,24918,22225,19434,18729,174261,61325,22107,16993,19189,16793,16929,20677,17402,17062,16589,19411,66531,19871,18777,16887,19937,19683,16899,19440,19310,16885,18785,21996,18990,17794,35093,30735,21283,15242,19273,19401,16842,19426,16829,18772,16837,22231,16974,16888,19032,17795,16951,21237,18364,16588,16947,18818,16844,66532,19299,18971,19560,22177,19309,21182,22401,16871,19297,19295,17035,19766,16584,19400,19257,21257,19292,18975,19324,19432,19225,47574,18774,19561,19423,19008,18991,132930,19354,16796,16798,19461,19414,16590,16602,19258,19136,18952,19278,19652,20251,26222,16819,16856,19682,17657,19457,19316,16975,17046,19312,20195,16575,16577,24921,16954,25934,19256,66550,20234,18969,21252,18970,18946)); + +-- Gameobject templates +UPDATE `gameobject_template` SET `VerifiedBuild`=50000 WHERE `entry` IN (152328, 183340, 183375, 184498, 183917, 147766, 3849, 37036, 147284, 184816, 147282, 185528, 184144, 184018, 183914, 183916, 3850, 183347, 37035, 152326, 152329, 181475, 175014, 175025, 175010, 148735, 184025, 182175, 182525, 147757, 182152, 51703, 181389, 37031, 3772, 175029, 184454, 183843, 183514, 183105, 147743, 147753, 182945, 106327, 37029, 148750, 184448, 183161, 183836, 181381, 175004, 22913, 149051, 22928, 185167, 147285, 183498, 182798, 184013, 184015, 184009, 183339, 147764, 183898, 174859, 183906, 183911, 183912, 37028, 181369, 184037, 183038, 183382, 183370, 183342, 184011, 184019, 147771, 182147, 183902, 3847, 152332, 37038, 175027, 175023, 183497, 183374, 147754, 147742, 184640, 175013, 22882, 38148, 183376, 183834, 183833, 184022, 183842, 183844, 147756, 147747, 183903, 106336, 37032, 37027, 175009, 148746, 175019, 22885, 184717, 181385, 184016, 183377, 184030, 182799, 184010, 147748, 182936, 175026, 175021, 175016, 175015, 175024, 148756, 22894, 22887, 183994, 184852, 184032, 184655, 183380, 183378, 184497, 183896, 147751, 147752, 182149, 51702, 181305, 184023, 176584, 37026, 175030, 175006, 278574, 183504, 22914, 183992, 183846, 185190, 182150, 181310, 152330, 152331, 175020, 22884, 180575, 183991, 183372, 183160, 211498, 183918, 147768, 147749, 147769, 183908, 106326, 182797, 184912, 175008, 148757, 183502, 22912, 183996, 183438, 183436, 183845, 184455, 183837, 181664, 183913, 147758, 3851, 181372, 175018, 175003, 175002, 184034, 184027, 184439, 183840, 184020, 175017, 148747, 175005, 148759, 183993, 183437, 184026, 183368, 183371, 184021, 183839, 183915, 147767, 183899, 106325, 184564, 37033, 183832, 184014, 183515, 147744, 147770, 182153, 182148, 50983, 3848, 106335, 152327, 37025, 175028, 183500, 146441, 184024, 183381, 183499, 147759, 147762, 147761, 147755, 182154, 176586, 183910, 182789, 184289, 188152, 184563, 152325, 175007, 22883, 181388, 22902, 147283, 184029, 183383, 183369, 183831, 183517, 147745, 183348, 184414, 188157, 187918, 37030, 175012, 22911, 184036, 184035, 184500, 184437, 183838, 184499, 183897, 183835, 147765, 147763, 183907, 181280, 184290, 184565, 148763, 148760, 148753, 185180, 2551, 184033, 183338, 183037, 181663, 184501, 184028, 184438, 147760, 182151, 182937, 184415, 183333, 181380, 22929, 183501, 183379, 182173, 183841, 184012, 183900, 183920, 182938, 188156, 183791, 37037, 22886, 183503, 183995, 184657, 182861, 184436, 147750, 182174, 183905, 183904, 183901, 195140, 37034, 175022, 175011, 175001, 184853, 182860, 183373, 183159, 184456, 184496, 184017, 147746, 183909, 278457, 149038, 183919, 195139); +UPDATE `gameobject_template` SET `ContentTuningId`=37, `VerifiedBuild`=50000 WHERE `entry`=184715; -- Cursed Cauldron +UPDATE `gameobject_template` SET `Data8`=103829, `Data10`=30092, `VerifiedBuild`=50000 WHERE `entry`=50984; -- Heated Forge +UPDATE `gameobject_template` SET `Data1`=0, `Data30`=20048, `ContentTuningId`=37, `VerifiedBuild`=50000 WHERE `entry`=183934; -- Shredder Parts +UPDATE `gameobject_template` SET `Data1`=0, `Data30`=19885, `ContentTuningId`=37, `VerifiedBuild`=50000 WHERE `entry`=183394; -- Zeppelin Debris +UPDATE `gameobject_template` SET `ContentTuningId`=37, `VerifiedBuild`=50000 WHERE `entry`=182800; -- Bleeding Hollow Supplies +UPDATE `gameobject_template` SET `ContentTuningId`=37, `VerifiedBuild`=50000 WHERE `entry`=183122; -- Alliance Cannon +UPDATE `gameobject_template` SET `Data1`=0, `Data30`=18443, `ContentTuningId`=37, `VerifiedBuild`=50000 WHERE `entry`=181680; -- Drycap Mushroom +UPDATE `gameobject_template` SET `ContentTuningId`=37, `VerifiedBuild`=50000 WHERE `entry`=181580; -- Central Beacon +UPDATE `gameobject_template` SET `ContentTuningId`=37, `VerifiedBuild`=50000 WHERE `entry`=181581; -- Western Beacon +UPDATE `gameobject_template` SET `ContentTuningId`=37, `VerifiedBuild`=50000 WHERE `entry`=181582; -- Kaliri Nest +UPDATE `gameobject_template` SET `ContentTuningId`=37, `VerifiedBuild`=50000 WHERE `entry`=183341; -- Makha's Shield +UPDATE `gameobject_template` SET `Data1`=0, `Data30`=22013, `ContentTuningId`=37, `VerifiedBuild`=50000 WHERE `entry`=184115; -- Arelion's Knapsack +UPDATE `gameobject_template` SET `Data1`=0, `Data2`=1, `Data30`=20533, `ContentTuningId`=37, `VerifiedBuild`=50000 WHERE `entry`=184466; -- Metal Coffer +UPDATE `gameobject_template` SET `ContentTuningId`=37, `VerifiedBuild`=50000 WHERE `entry`=181579; -- Southern Beacon +UPDATE `gameobject_template` SET `Data1`=0, `Data2`=1, `Data30`=20578, `ContentTuningId`=37, `VerifiedBuild`=50000 WHERE `entry`=184478; -- Torn Pilgrim's Pack +UPDATE `gameobject_template` SET `ContentTuningId`=37, `VerifiedBuild`=50000 WHERE `entry`=181449; -- Altar of Aggonar +UPDATE `gameobject_template` SET `Data1`=0, `Data30`=19885, `ContentTuningId`=37, `VerifiedBuild`=50000 WHERE `entry`=183395; -- Zeppelin Debris +UPDATE `gameobject_template` SET `type`=5, `Data1`=0, `Data3`=0, `VerifiedBuild`=50000 WHERE `entry`=183343; -- Warboss Nekrogg's Orders +UPDATE `gameobject_template` SET `Data1`=0, `Data30`=18424, `ContentTuningId`=37, `VerifiedBuild`=50000 WHERE `entry`=181637; -- Sha'naar Relic +UPDATE `gameobject_template` SET `ContentTuningId`=37, `VerifiedBuild`=50000 WHERE `entry`=183940; -- Moh's Cage +UPDATE `gameobject_template` SET `Data1`=0, `Data30`=19885, `ContentTuningId`=37, `VerifiedBuild`=50000 WHERE `entry`=183396; -- Zeppelin Debris +UPDATE `gameobject_template` SET `ContentTuningId`=37, `VerifiedBuild`=50000 WHERE `entry`=182796; -- Bleeding Hollow Attack Plans +UPDATE `gameobject_template` SET `ContentTuningId`=37, `VerifiedBuild`=50000 WHERE `entry`=184656; -- Hellfire Quest - Rune of Spite Closed - 3.0 +UPDATE `gameobject_template` SET `Data1`=0, `Data30`=45589, `ContentTuningId`=1204, `VerifiedBuild`=50000 WHERE `entry`=216327; -- Soulstone Fragment +UPDATE `gameobject_template` SET `ContentTuningId`=394, `VerifiedBuild`=50000 WHERE `entry`=187963; -- Horde Bonfire +UPDATE `gameobject_template` SET `ContentTuningId`=394, `VerifiedBuild`=50000 WHERE `entry` IN (188153, 188151, 188154); -- Ice Stone +UPDATE `gameobject_template` SET `ContentTuningId`=37, `VerifiedBuild`=50000 WHERE `entry`=185166; -- Wanted Poster +UPDATE `gameobject_template` SET `ContentTuningId`=394, `VerifiedBuild`=50000 WHERE `entry`=187930; -- Alliance Bonfire +UPDATE `gameobject_template` SET `ContentTuningId`=37, `VerifiedBuild`=50000 WHERE `entry`=184694; -- Zelana's Alchemy Set +UPDATE `gameobject_template` SET `Data1`=0, `Data30`=19459, `ContentTuningId`=37, `VerifiedBuild`=50000 WHERE `entry`=182804; -- Mysteries of the Light +UPDATE `gameobject_template` SET `Data1`=0, `Data30`=19885, `ContentTuningId`=37, `VerifiedBuild`=50000 WHERE `entry`=183397; -- Zeppelin Debris +UPDATE `gameobject_template` SET `ContentTuningId`=37, `VerifiedBuild`=50000 WHERE `entry`=183941; -- Jakk's Cage +UPDATE `gameobject_template` SET `ContentTuningId`=37, `VerifiedBuild`=50000 WHERE `entry`=182935; -- Rune of Spite +UPDATE `gameobject_template` SET `ContentTuningId`=37, `VerifiedBuild`=50000 WHERE `entry`=184659; -- Mysteris of the Light Aura +UPDATE `gameobject_template` SET `Data3`=25190, `ContentTuningId`=37, `VerifiedBuild`=50000 WHERE `entry`=181638; -- Wanted Poster +UPDATE `gameobject_template` SET `ContentTuningId`=37, `VerifiedBuild`=50000 WHERE `entry`=184005; -- Unyielding Banner +UPDATE `gameobject_template` SET `Data8`=103828, `Data10`=30091, `VerifiedBuild`=50000 WHERE `entry`=51704; -- Anvil +UPDATE `gameobject_template` SET `ContentTuningId`=37, `VerifiedBuild`=50000 WHERE `entry`=181606; -- Haal'eshi Altar +UPDATE `gameobject_template` SET `ContentTuningId`=37, `VerifiedBuild`=50000 WHERE `entry`=184721; -- Cauldron Bubbles +UPDATE `gameobject_template` SET `ContentTuningId`=37, `VerifiedBuild`=50000 WHERE `entry`=183936; -- Manni's Cage +UPDATE `gameobject_template` SET `Data8`=103828, `Data10`=30091, `VerifiedBuild`=50000 WHERE `entry`=51705; -- Anvil +UPDATE `gameobject_template` SET `ContentTuningId`=37, `VerifiedBuild`=50000 WHERE `entry`=182934; -- Glyph Inscribed Obelisk +UPDATE `gameobject_template` SET `ContentTuningId`=37, `VerifiedBuild`=50000 WHERE `entry`=183123; -- Horde Blade Thrower + +UPDATE `gameobject_template_addon` SET `flags`=4 WHERE `entry`=216327; -- Soulstone Fragment +UPDATE `gameobject_template_addon` SET `faction`=114 WHERE `entry`=184659; -- Mysteris of the Light Aura +UPDATE `gameobject_template_addon` SET `flags`=32 WHERE `entry`=184415; -- Portal Kaalez +UPDATE `gameobject_template_addon` SET `flags`=278528 WHERE `entry`=176586; -- Mountain Silversage + +UPDATE `gameobject_questitem` SET `VerifiedBuild`=50000 WHERE (`Idx`=0 AND `GameObjectEntry` IN (182804,183397,183395,183394,182798,181680,184466,184115,183934,181637,182797,182937,181385,184478,182799,182936,182938,183396,216327,181372)); |