DB/Nagrand: Update templates and difficulties

1 files changed, 147 insertions, 0 deletions

diff --git a/sql/updates/world/master/2023_06_01_09_world.sql b/sql/updates/world/master/2023_06_01_09_world.sql
new file mode 100644
index 00000000000..97bac93b996
--- /dev/null
+++ b/sql/updates/world/master/2023_06_01_09_world.sql
@@ -0,0 +1,147 @@
+-- Creature templates
+UPDATE `creature_template` SET `npcflag`=1, `BaseAttackTime`=2000, `unit_flags`=33536, `unit_flags2`=2048 WHERE `entry`=121086; -- Shawn
+UPDATE `creature_template` SET `faction`=14, `speed_walk`=2, `speed_run`=2.142857074737548828, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE `entry`=115655; -- Ohme
+UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=24866; -- Lakoor
+UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=23268; -- Seer Jovar
+UPDATE `creature_template` SET `speed_walk`=1 WHERE `entry`=22362; -- Deathshadow Imp
+UPDATE `creature_template` SET `speed_walk`=1 WHERE `entry`=22313; -- Rumbling Earth-Heart
+UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=22309; -- Crashing Wave-Spirit
+UPDATE `creature_template` SET `npcflag`=0 WHERE `entry`=21483; -- Tasaldan
+UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry` IN (20812, 18445, 18369); -- Corki
+UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=20240; -- Trader Narasu
+UPDATE `creature_template` SET `unit_flags3`=1 WHERE `entry`=19212; -- Fel Cannon: Hate Target
+UPDATE `creature_template` SET `unit_flags3`=1 WHERE `entry`=19211; -- Fel Cannon: Fear Target
+UPDATE `creature_template` SET `speed_run`=1.142857193946838378, `unit_flags3`=1 WHERE `entry`=19210; -- Fel Cannon: Fear
+UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=19156; -- Telaari Jailor
+UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=19141; -- Kurenai Pitfighter
+UPDATE `creature_template` SET `unit_flags3`=1 WHERE `entry`=19139; -- Nagrand Target Dummy
+UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=19068; -- Garadar Wolf Rider
+UPDATE `creature_template` SET `speed_run`=1.142857193946838378, `unit_flags3`=1 WHERE `entry`=19067; -- Fel Cannon: Hate
+UPDATE `creature_template` SET `speed_walk`=1 WHERE `entry`=19023; -- Stabled Tallstrider
+UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=19017; -- Borto
+UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=19014; -- Ogir
+UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=19012; -- Sparik
+UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=18683; -- Voidhunter Yar
+UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=18661; -- Terrorguard
+UPDATE `creature_template` SET `speed_walk`=1, `speed_run`=1.142857193946838378 WHERE `entry`=18567; -- Mo'arg Master Planner
+UPDATE `creature_template` SET `speed_walk`=1, `speed_run`=1.142857193946838378 WHERE `entry`=18536; -- Xirkos, Overseer of Fear
+UPDATE `creature_template` SET `speed_walk`=1, `speed_run`=1.142857193946838378 WHERE `entry`=18535; -- Demos, Overseer of Hate
+UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=18488; -- Telaari Watcher
+UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=18408; -- Warden Moi'bff Jill
+UPDATE `creature_template` SET `unit_flags3`=1 WHERE `entry`=18307; -- Burning Blade Pyre (03)
+UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=18299; -- Bleeding Hollow Orphan
+UPDATE `creature_template` SET `unit_flags`=0 WHERE `entry`=18297; -- Gankly Rottenfist
+UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=18296; -- Sunspring Post Orphan
+UPDATE `creature_template` SET `faction`=250, `npcflag`=0 WHERE `entry`=18294; -- Kristen Dipswitch
+UPDATE `creature_template` SET `unit_flags`=0 WHERE `entry`=18259; -- Banthar
+UPDATE `creature_template` SET `unit_flags`=536904448, `unit_flags3`=8192 WHERE `entry`=18240; -- Sunspring Villager
+UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=18233; -- Elementalist Ioki
+UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=18224; -- Poli'lukluk the Wiser
+UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=18223; -- Mo'mor the Breaker
+UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=18222; -- Otonbu the Sage
+UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=18211; -- Murkblood Brute
+UPDATE `creature_template` SET `npcflag`=0 WHERE `entry`=18210; -- Mag'har Captive
+UPDATE `creature_template` SET `npcflag`=0, `speed_run`=1.142857193946838378, `unit_flags`=295680 WHERE `entry`=18209; -- Kurenai Captive
+UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=18207; -- Murkblood Scavenger
+UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=18204; -- Ortor of Murkblood
+UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=18203; -- Murkblood Raider
+UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=18202; -- Murkblood Putrefier
+UPDATE `creature_template` SET `faction`=495, `npcflag`=0 WHERE `entry`=18200; -- Shado 'Fitz' Farstrider
+UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=18183; -- Arechron
+UPDATE `creature_template` SET `faction`=495, `npcflag`=0 WHERE `entry`=18180; -- Hemet Nesingwary
+UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=18145; -- Watoosun's Polluted Essence
+UPDATE `creature_template` SET `unit_flags3`=8388608 WHERE `entry`=18102; -- Kalandrios
+UPDATE `creature_template` SET `unit_flags3`=8388608 WHERE `entry`=18101; -- Aborius
+UPDATE `creature_template` SET `unit_flags3`=8388608 WHERE `entry`=18100; -- Incineratus
+UPDATE `creature_template` SET `unit_flags3`=8388608 WHERE `entry`=18099; -- Gordawg
+UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=18074; -- Elementalist Morgh
+UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=18073; -- Elementalist Lo'ap
+UPDATE `creature_template` SET `speed_walk`=1 WHERE `entry`=18062; -- Enraged Crusher
+UPDATE `creature_template` SET `npcflag`=0, `speed_run`=1.142857193946838378 WHERE `entry`=17545; -- K'ure
+UPDATE `creature_template` SET `speed_walk`=1 WHERE `entry`=17157; -- Shattered Rumbler
+UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=17155; -- Lake Surger
+UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=17154; -- Muck Spawn
+UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=17153; -- Lake Spirit
+UPDATE `creature_template` SET `speed_walk`=1 WHERE `entry`=17141; -- Windyreed Wretch
+UPDATE `creature_template` SET `speed_walk`=1 WHERE `entry`=17139; -- Windyreed Scavenger
+UPDATE `creature_template` SET `speed_walk`=1, `speed_run`=1.142857193946838378 WHERE `entry`=16945; -- Mo'arg Engineer
+UPDATE `creature_template` SET `faction`=1693, `speed_run`=0.857142865657806396 WHERE `entry`=12922; -- Imp Minion
+
+-- Difficulty
+DELETE FROM `creature_template_difficulty` WHERE (`DifficultyID`=2 AND `Entry` IN (1412,24866));
+DELETE FROM `creature_template_difficulty` WHERE (`DifficultyID`=1 AND `Entry` IN (12922,61369,61366,61325,61141,61081,61080,22003,22001,21999,21996,21993,21233,19687,19656,19161,15384,15241,4075,3300,2914,2620,2615,2614,1420,1412,721));
+DELETE FROM `creature_template_difficulty` WHERE (`Entry`=24866 AND `DifficultyID`=0);
+INSERT INTO `creature_template_difficulty` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `HealthScalingExpansion`, `HealthModifier`, `ManaModifier`, `CreatureDifficultyID`, `TypeFlags`, `TypeFlags2`, `VerifiedBuild`) VALUES
+(24866, 0, 0, 0, 40, 1, 1, 1, 22890, 0, 0, 49801);
+
+UPDATE `creature_template_difficulty` SET `DifficultyID`=0 WHERE (`DifficultyID` IN (1,2) AND `Entry` IN (121086,115655,66552,66539,66538,66537,62620,24881,24866,24222,23268,23265,23026,23022,23007,22981,22979,22893,22839,22838,22836,22400,22394,22393,22363,22362,22357,22343,22342,22341,22313,22311,22310,22309,22199,22148,22144,22143,21893,21484,21483,21474,20812,20241,20240,20097,20096,20072,19844,19660,19646,19590,19212,19211,19210,19201,19183,19158,19157,19156,19152,19151,19149,19141,19140,19139,19137,19133,19071,19068,19067,19041,19035,19030,19027,19026,19025,19024,19023,19022,19021,19020,19019,19018,19017,19015,19014,19013,19012,19011,18964,18914,18913,18842,18841,18840,18821,18816,18808,18789,18683,18662,18661,18660,18658,18590,18589,18567,18536,18535,18532,18489,18488,18471,18445,18444,18440,18428,18418,18417,18416,18415,18414,18413,18408,18407,18395,18393,18391,18388,18369,18354,18353,18352,18351,18346,18335,18334,18333,18308,18307,18306,18305,18302,18301,18300,18299,18298,18297,18296,18294,18293,18292,18290,18289,18278,18276,18274,18272,18265,18264,18261,18259,18258,18257,18240,18238,18234,18233,18229,18228,18224,18223,18222,18220,18218,18215,18211,18210,18209,18208,18207,18205,18204,18203,18202,18200,18196,18192,18183,18180,18145,18144,18143,18142,18141,18110,18106,18102,18101,18100,18099,18090,18074,18073,18072,18071,18069,18068,18067,18066,18065,18064,18063,18062,18043,18037,18033,17981,17545,17160,17159,17158,17157,17156,17155,17154,17153,17152,17151,17150,17149,17148,17147,17146,17144,17141,17139,17138,17137,17136,17135,17134,17133,17132,17131,17130,17129,17128,16945));
+UPDATE `creature_template_difficulty` SET `VerifiedBuild`=49801 WHERE (`DifficultyID`=0 AND `Entry` IN (61369,61366,61325,61141,61081,61080,22003,22001,21999,21996,21993,21233,19687,19656,19161,15384,15241,4075,3300,2914,2620,2615,2614,1420,1412,721));
+UPDATE `creature_template_difficulty` SET `VerifiedBuild`=49801 WHERE (`DifficultyID`=0 AND `Entry` IN (121086,115655,66552,66539,66538,66537,62620,24881,24222,23268,23265,23026,23022,23007,22981,22979,22893,22839,22838,22836,22400,22394,22393,22363,22362,22357,22343,22342,22341,22313,22311,22310,22309,22199,22148,22144,22143,21893,21484,21483,21474,20812,20241,20097,20096,20072,19844,19660,19646,19590,19212,19211,19210,19201,19183,19158,19157,19149,19141,19140,19139,19137,19133,19071,19068,19067,19041,19035,19026,19025,19024,19023,19022,19021,19020,19018,19017,19015,19014,19013,19012,19011,18964,18913,18842,18841,18840,18821,18816,18808,18683,18662,18661,18660,18658,18590,18589,18567,18536,18535,18532,18489,18488,18471,18445,18444,18440,18428,18418,18417,18416,18415,18414,18413,18408,18407,18395,18393,18391,18388,18369,18354,18353,18352,18351,18346,18335,18334,18333,18308,18307,18306,18305,18302,18301,18300,18299,18298,18297,18296,18294,18293,18292,18290,18289,18278,18276,18274,18272,18265,18264,18261,18259,18258,18257,18240,18238,18234,18233,18229,18228,18224,18223,18222,18220,18218,18215,18211,18210,18209,18208,18207,18205,18204,18203,18202,18200,18196,18192,18183,18180,18145,18144,18143,18142,18141,18110,18106,18102,18101,18100,18099,18090,18074,18073,18072,18071,18069,18068,18067,18066,18065,18064,18063,18062,18043,18037,18033,17981,17545,17160,17159,17158,17157,17156,17155,17154,17153,17152,17151,17150,17149,17148,17147,17146,17144,17141,17139,17138,17137,17136,17135,17134,17133,17132,17131,17130,17129,17128,16945));
+UPDATE `creature_template_difficulty` SET `ContentTuningID`=40, `VerifiedBuild`=49801 WHERE (`Entry`=12922 AND `DifficultyID`=0);
+UPDATE `creature_template_difficulty` SET `ContentTuningID`=40, `VerifiedBuild`=49801 WHERE (`DifficultyID`=0 AND `Entry` IN (20240,19156,19152,19151,19030,19027,19019,18914,12922));
+UPDATE `creature_template_difficulty` SET `ContentTuningID`=881, `VerifiedBuild`=49801 WHERE (`Entry`=18789 AND `DifficultyID`=0);
+
+UPDATE `creature_questitem` SET `VerifiedBuild`=49801 WHERE (`CreatureEntry`=18289 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=18290 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=18259 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=22394 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=23026 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=18964 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=18258 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=17133 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=19183 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=17131 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=17132 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=18033 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=18334 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=17144 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=18205 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=115655 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=17130 AND `DifficultyID`=0 AND `Idx`=0);
+
+-- Models
+UPDATE `creature_model_info` SET `VerifiedBuild`=49801 WHERE `DisplayID` IN (76088, 75086, 45232, 5379, 2838, 45618, 42575, 22710, 22460, 17956, 21390, 21210, 21195, 18660, 21172, 4877, 12829, 21110, 6195, 16889, 20952, 20948, 20950, 20951, 20946, 12231, 20432, 5564, 20346, 19906, 20173, 20311, 20310, 20305, 19498, 19334, 19333, 19375, 19213, 20168, 20169, 18645, 19584, 18568, 18567, 18576, 18574, 18572, 18575, 18538, 18545, 16074, 18536, 18532, 18505, 18473, 1977, 1339, 865, 4714, 18470, 18469, 18468, 18466, 18465, 18464, 18463, 18462, 18461, 18460, 18459, 18319, 18318, 18243, 18233, 21068, 18348, 19681, 18060, 18061, 18051, 18373, 18049, 18048, 18056, 18057, 18370, 17880, 18291, 17971, 18506, 18507, 18508, 18513, 18512, 18514, 17836, 11536, 17788, 17789, 17790, 17791, 17772, 17771, 17770, 17769, 17768, 11550, 17763, 17762, 17742, 17705, 17690, 11545, 10170, 17841, 18271, 17678, 17897, 17896, 19645, 17188, 17670, 17669, 17668, 20542, 17662, 20545, 20546, 17660, 17664, 17666, 17665, 17667, 18045, 17902, 17652, 17840, 17191, 20174, 17647, 17659, 37745, 19223, 18383, 17624, 17623, 17622, 17621, 17619, 17617, 17616, 17611, 17612, 17604, 17603, 17602, 18380, 17597, 17594, 17595, 17593, 17592, 17589, 17590, 17591, 19582, 17586, 17584, 17583, 17580, 18259, 18260, 18253, 18258, 17560, 17557, 36529, 17534, 17200, 17527, 15538, 13444, 12129, 17525, 17520, 17463, 17464, 17465, 17466, 47200, 17468, 17467, 17453, 11576, 11546, 17452, 14505, 17459, 17449, 17460, 17458, 19909, 741, 18366, 17072, 10315, 14503, 14506, 17461, 5562, 5561, 5047, 18288, 20988, 18365, 17964, 17957, 17966, 20763, 18350, 18349, 18357, 18333, 18356, 18354, 11549, 19581, 19583, 19220, 19219, 18378, 18377, 18646, 19668, 17202, 4449, 1072, 901, 134, 4626, 328);
+UPDATE `creature_model_info` SET `BoundingRadius`=0.828900098800659179, `CombatReach`=0, `VerifiedBuild`=49801 WHERE `DisplayID` IN (22709, 19497);
+UPDATE `creature_model_info` SET `BoundingRadius`=0.994680166244506835, `CombatReach`=0, `DisplayID_Other_Gender`=0, `VerifiedBuild`=49801 WHERE `DisplayID`=18571;
+UPDATE `creature_model_info` SET `DisplayID_Other_Gender`=0, `VerifiedBuild`=49801 WHERE `DisplayID` IN (18561, 18563, 18564, 18562, 18554);
+UPDATE `creature_model_info` SET `BoundingRadius`=0.795000016689300537, `CombatReach`=1.5, `VerifiedBuild`=49801 WHERE `DisplayID`=599;
+UPDATE `creature_model_info` SET `BoundingRadius`=1.19080519676208496, `CombatReach`=1, `VerifiedBuild`=49801 WHERE `DisplayID`=4907;
+UPDATE `creature_template_model` SET `VerifiedBuild`=49801 WHERE (`Idx`=1 AND `CreatureID` IN (21996,19211,19158,19660,61080,19152,18428,16945,19071,22343,18264,18307,721,19590,2614,15384,22838,22342,19656,19151,22363,18299,19212,19157,17148,22400,19646,18292,18489,17146,18567,61325,18334,18043,18192,19041,18658,18293,22839,22003,18240,19161,18662,19149,2615,18211,18488,19156,21999,18207,22341,18296,19068,61366,21993,22001,17147,18306,19687)) OR (`Idx`=0 AND `CreatureID` IN (21996,18660,18265,18590,19211,19067,19158,18300,18068,19660,66552,18388,61080,19152,17545,18440,18428,16945,19201,18415,18471,17137,18808,18100,19071,18354,18352,17157,62620,18233,22343,18210,18069,18393,17136,19023,22311,18071,17132,18391,18218,18222,18789,24866,18444,18589,18417,18204,18209,18264,18033,18307,18261,721,19590,17128,18416,18408,20096,2614,18290,18259,18346,18202,15384,22148,18223,18220,22838,18274,22362,22342,17152,18229,17133,18335,20241,19656,2620,22199,19151,115655,22393,22363,18445,17129,22893,19140,23265,19026,18299,18141,18099,17130,22143,22981,19212,19157,18101,17148,18143,17139,1420,15241,19137,19019,22400,18065,21233,18203,21484,17141,18914,19030,21474,18301,18063,19646,18292,18489,17146,18142,18183,19021,18224,18298,18567,21893,18414,61325,18334,18278,19027,18043,18208,18215,17155,17144,18192,19011,18090,19015,66539,19041,18369,18205,18658,17149,18238,24881,18842,19025,18293,22839,22003,18276,23026,18240,18816,19024,19161,20240,18662,18272,18395,18064,21483,19139,18407,18308,22144,19017,19149,18353,22836,121086,18532,20812,18106,2615,19035,17159,17134,18297,23022,12922,18418,18211,18413,18821,19013,19133,18234,22309,18102,66537,18488,18200,18180,18661,18536,22357,22979,18964,17138,18066,20097,66538,24222,19141,23268,19156,17150,18333,18196,18257,17154,19018,22310,18074,21999,18683,17981,23007,18840,18207,18841,19022,22313,18062,17158,17156,61081,18144,22341,22394,18037,20072,18067,18296,19068,61141,61366,18110,61369,19183,17151,19020,18228,21993,17153,17131,1412,19014,18258,18145,18913,18073,22001,17135,18294,19012,18289,19844,19210,18535,17160,18302,18072,18351,17147,18305,18306,19687)) OR (`Idx`=3 AND `CreatureID` IN (19158,19152,18428,19151,19157,18292,18489,18043,18192,18658,18293,18240,19161,18662,19149,19068,19687)) OR (`Idx`=2 AND `CreatureID` IN (19158,19152,18428,19071,19151,19157,18292,18489,61325,18334,18043,18192,18658,18293,18240,19161,18662,19149,18488,19156,18207,19068,61366,19687));
+
+-- Gameobject templates
+UPDATE `gameobject_template` SET `VerifiedBuild`=49801 WHERE `entry` IN (181450, 183193, 3928, 3918, 3924, 3919, 182162, 185136, 182519, 183158, 181451, 181656, 3839, 182210, 183197, 181570, 181660, 184316, 183192, 3843, 3845, 174953, 182159, 183439, 181271, 186177, 186174, 181312, 181767, 182257, 278347, 182203, 183272, 181311, 181658, 186972, 182156, 3917, 182158, 184314, 181270, 181569, 278575, 184647, 3914, 3922, 3913, 186179, 183195, 183194, 186180, 184396, 181557, 181455, 181659, 184644, 3844, 3923, 3921, 3926, 182161, 184397, 186175, 3842, 3930, 181555, 186178, 185181, 183198, 182155, 3932, 183099, 184395, 185205, 181281, 183190, 3840, 3929, 3912, 183783, 185204, 183218, 183180, 182391, 182160, 3841, 3915, 181387, 182349, 183149, 183191, 3931, 183287, 181456, 181427, 181655, 183882, 183196, 182157, 181556, 183171, 184645, 184646, 184401, 185203, 182955, 183273, 181452, 3920, 3934, 183203, 181657, 183313, 183265, 3916, 183202, 186176, 3925, 183782, 183169, 181446, 183204, 183170, 184317, 181453, 3927, 183294, 185202, 183271, 183946, 183883, 183148, 183189, 183821, 3933, 183288, 183289, 183286);
+UPDATE `gameobject_template` SET `Data1`=0, `Data30`=19289, `ContentTuningId`=40, `VerifiedBuild`=49801 WHERE `entry`=182265; -- Bleeding Hollow Supply Crate
+UPDATE `gameobject_template` SET `Data8`=0, `VerifiedBuild`=49801 WHERE `entry`=182496; -- Warmaul Prison
+UPDATE `gameobject_template` SET `ContentTuningId`=40, `VerifiedBuild`=49801 WHERE `entry`=183147; -- Mysterious Egg
+UPDATE `gameobject_template` SET `Data8`=0, `VerifiedBuild`=49801 WHERE `entry`=182492; -- Warmaul Prison
+UPDATE `gameobject_template` SET `ContentTuningId`=40, `VerifiedBuild`=49801 WHERE `entry`=182951; -- Pure Water
+UPDATE `gameobject_template` SET `Data8`=0, `VerifiedBuild`=49801 WHERE `entry`=182503; -- Warmaul Prison
+UPDATE `gameobject_template` SET `Data8`=0, `VerifiedBuild`=49801 WHERE `entry`=182521; -- Corki's Prison
+UPDATE `gameobject_template` SET `Data1`=0, `Data30`=18759, `ContentTuningId`=40, `VerifiedBuild`=49801 WHERE `entry`=182128; -- Dung
+UPDATE `gameobject_template` SET `Data8`=0, `VerifiedBuild`=49801 WHERE `entry`=182494; -- Warmaul Prison
+UPDATE `gameobject_template` SET `Data8`=0, `VerifiedBuild`=49801 WHERE `entry`=182491; -- Warmaul Prison
+UPDATE `gameobject_template` SET `ContentTuningId`=40, `VerifiedBuild`=49801 WHERE `entry` IN (182263, 182261); -- First Burning Blade Pyre
+UPDATE `gameobject_template` SET `ContentTuningId`=40, `VerifiedBuild`=49801 WHERE `entry`=182959; -- Bluefish School
+UPDATE `gameobject_template` SET `Data1`=0, `Data30`=20890, `ContentTuningId`=40, `VerifiedBuild`=49801 WHERE `entry`=184741; -- Dented Footlocker
+UPDATE `gameobject_template` SET `ContentTuningId`=40, `VerifiedBuild`=49801 WHERE `entry`=182392; -- Garadar Bulletin Board
+UPDATE `gameobject_template` SET `Data3`=1, `ContentTuningId`=40, `VerifiedBuild`=49801 WHERE `entry`=182275; -- Destroyed Wyvern Roost
+UPDATE `gameobject_template` SET `ContentTuningId`=40, `VerifiedBuild`=49801 WHERE `entry`=182393; -- Telaar Bulletin Board
+UPDATE `gameobject_template` SET `Data8`=0, `VerifiedBuild`=49801 WHERE `entry`=182498; -- Warmaul Prison
+UPDATE `gameobject_template` SET `Data8`=0, `VerifiedBuild`=49801 WHERE `entry`=182497; -- Warmaul Prison
+UPDATE `gameobject_template` SET `Data8`=0, `VerifiedBuild`=49801 WHERE `entry`=182504; -- Warmaul Prison
+UPDATE `gameobject_template` SET `Data1`=0, `Data30`=19264, `ContentTuningId`=40, `VerifiedBuild`=49801 WHERE `entry`=182258; -- Oshu'gun Crystal Fragment
+UPDATE `gameobject_template` SET `Data1`=0, `Data30`=19351, `ContentTuningId`=40, `VerifiedBuild`=49801 WHERE `entry`=182520; -- Telaar Supply Crate
+UPDATE `gameobject_template` SET `Data3`=1, `ContentTuningId`=40, `VerifiedBuild`=49801 WHERE `entry`=182276; -- Destroyed Wyvern Roost
+UPDATE `gameobject_template` SET `Data8`=0, `VerifiedBuild`=49801 WHERE `entry`=182499; -- Warmaul Prison
+UPDATE `gameobject_template` SET `Data8`=0, `VerifiedBuild`=49801 WHERE `entry`=182500; -- Warmaul Prison
+UPDATE `gameobject_template` SET `Data8`=0, `VerifiedBuild`=49801 WHERE `entry`=182501; -- Warmaul Prison
+UPDATE `gameobject_template` SET `Data8`=0, `VerifiedBuild`=49801 WHERE `entry`=182488; -- Warmaul Prison
+UPDATE `gameobject_template` SET `ContentTuningId`=40, `VerifiedBuild`=49801 WHERE `entry`=183146; -- Jump-a-tron 4000
+UPDATE `gameobject_template` SET `Data8`=103829, `Data10`=30092, `VerifiedBuild`=49801 WHERE `entry`=184303; -- Blazing Fire
+UPDATE `gameobject_template` SET `Data8`=0, `VerifiedBuild`=49801 WHERE `entry`=182493; -- Warmaul Prison
+UPDATE `gameobject_template` SET `ContentTuningId`=40, `VerifiedBuild`=49801 WHERE `entry`=182958; -- Mudfish School
+UPDATE `gameobject_template` SET `Data8`=0, `VerifiedBuild`=49801 WHERE `entry`=182502; -- Warmaul Prison
+UPDATE `gameobject_template` SET `Data1`=0, `Data30`=19429, `ContentTuningId`=40, `VerifiedBuild`=49801 WHERE `entry`=182599; -- Telaari Frond
+UPDATE `gameobject_template` SET `Data8`=0, `VerifiedBuild`=49801 WHERE `entry`=182484; -- Warmaul Prison
+UPDATE `gameobject_template` SET `Data2`=0, `Data8`=0, `VerifiedBuild`=49801 WHERE `entry`=182350; -- Corki's Prison
+UPDATE `gameobject_template` SET `Data3`=1, `ContentTuningId`=40, `VerifiedBuild`=49801 WHERE `entry`=182266; -- Destroyed Wyvern Roost
+UPDATE `gameobject_template` SET `Data3`=1, `ContentTuningId`=40, `VerifiedBuild`=49801 WHERE `entry`=182277; -- Destroyed Wyvern Roost
+UPDATE `gameobject_template` SET `ContentTuningId`=40, `VerifiedBuild`=49801 WHERE `entry`=182264; -- Second Burning Blade Pyre
+UPDATE `gameobject_template` SET `ContentTuningId`=40, `VerifiedBuild`=49801 WHERE `entry`=182182; -- Earthen Brand
+UPDATE `gameobject_template` SET `Data8`=0, `VerifiedBuild`=49801 WHERE `entry`=182490; -- Warmaul Prison
+UPDATE `gameobject_template` SET `ContentTuningId`=40, `VerifiedBuild`=49801 WHERE `entry`=182369; -- Blazing Warmaul Pyre
+UPDATE `gameobject_template` SET `Data8`=0, `VerifiedBuild`=49801 WHERE `entry`=182487; -- Warmaul Prison
+UPDATE `gameobject_template` SET `Data8`=0, `VerifiedBuild`=49801 WHERE `entry`=182486; -- Warmaul Prison
+UPDATE `gameobject_template` SET `Data8`=0, `VerifiedBuild`=49801 WHERE `entry`=182489; -- Warmaul Prison
+UPDATE `gameobject_template` SET `Data8`=0, `VerifiedBuild`=49801 WHERE `entry`=182495; -- Warmaul Prison
+UPDATE `gameobject_template` SET `Data1`=0, `Data30`=19329, `ContentTuningId`=40, `VerifiedBuild`=49801 WHERE `entry`=182355; -- Kil'sorrow Armaments
+UPDATE `gameobject_template` SET `ContentTuningId`=40, `VerifiedBuild`=49801 WHERE `entry`=182262; -- Third Burning Blade Pyre
+
+UPDATE `gameobject_template_addon` SET `flags`=278528 WHERE `entry`=181570; -- Rich Adamantite Deposit
+UPDATE `gameobject_template_addon` SET `flags`=278528 WHERE `entry`=181557; -- Khorium Vein
+
+UPDATE `gameobject_questitem` SET `VerifiedBuild`=49801 WHERE (`Idx`=0 AND `GameObjectEntry` IN (182520,182128,182265,182599,182355));