diff options
| -rw-r--r-- | sql/updates/world/master/2023_07_04_07_world.sql | 157 |
1 files changed, 157 insertions, 0 deletions
diff --git a/sql/updates/world/master/2023_07_04_07_world.sql b/sql/updates/world/master/2023_07_04_07_world.sql new file mode 100644 index 00000000000..99d62bcf53c --- /dev/null +++ b/sql/updates/world/master/2023_07_04_07_world.sql @@ -0,0 +1,157 @@ +-- Creature templates +UPDATE `creature_template` SET `BaseAttackTime`=2000, `unit_flags`=33555200, `unit_flags2`=67110912, `unit_flags3`=16777216 WHERE `entry`=113941; -- Invisible Stalker +UPDATE `creature_template` SET `speed_walk`=1, `speed_run`=1.142857193946838378 WHERE `entry`=23427; -- Illidari Lord Balthas +UPDATE `creature_template` SET `unit_flags3`=1 WHERE `entry`=23348; -- Captain Skyshatter +UPDATE `creature_template` SET `unit_flags3`=1 WHERE `entry`=23346; -- Wing Commander Mulverick +UPDATE `creature_template` SET `unit_flags3`=1 WHERE `entry`=23345; -- Wing Commander Ichman +UPDATE `creature_template` SET `unit_flags3`=1 WHERE `entry`=23344; -- Corlok the Vet +UPDATE `creature_template` SET `unit_flags3`=1 WHERE `entry`=23342; -- Trope the Filth-Belcher +UPDATE `creature_template` SET `unit_flags3`=1 WHERE `entry`=23340; -- Murg "Oldie" Muckjaw +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=23326; -- Nethermine Ravager +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=23324; -- Crazed Murkblood Miner +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=23309; -- Murkblood Overseer +UPDATE `creature_template` SET `speed_run`=1.142857193946838378, `unit_flags`=536904448, `unit_flags3`=8192 WHERE `entry`=23287; -- Murkblood Miner +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=23283; -- Lady Sinestra +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=23149; -- Mistress of the Mines +UPDATE `creature_template` SET `unit_flags`=33555200 WHERE `entry`=23033; -- Invisible Stalker (Floating) +UPDATE `creature_template` SET `speed_run`=1.385714292526245117, `unit_flags`=256, `unit_flags3`=524288 WHERE `entry`=22968; -- Light-Armored Elekk +UPDATE `creature_template` SET `unit_flags`=32768, `unit_flags2`=2099200, `unit_flags3`=0 WHERE `entry`=22859; -- Shadowhoof Summoner +UPDATE `creature_template` SET `unit_flags`=32768 WHERE `entry`=22857; -- Illidari Ravager +UPDATE `creature_template` SET `unit_flags3`=1 WHERE `entry`=22317; -- Netherwing Drake Escape Dummy +UPDATE `creature_template` SET `faction`=90, `speed_walk`=1, `speed_run`=1 WHERE `entry`=22315; -- Deathforge Mine +UPDATE `creature_template` SET `speed_walk`=4, `speed_run`=2.142857074737548828 WHERE `entry`=22096; -- Shadowlord Deathwail Visual Trigger +UPDATE `creature_template` SET `unit_flags3`=1 WHERE `entry`=22083; -- Illidan Stormrage +UPDATE `creature_template` SET `faction`=1965, `unit_flags2`=2052 WHERE `entry`=22082; -- Shadowmoon Slayer +UPDATE `creature_template` SET `unit_flags3`=8388608 WHERE `entry`=22080; -- Air Force Trip Wire - Rooftop (Aldor) +UPDATE `creature_template` SET `unit_flags3`=8388608 WHERE `entry`=22079; -- Air Force Guard Post (Aldor - Gryphon) +UPDATE `creature_template` SET `speed_walk`=1, `unit_flags3`=8912896 WHERE `entry`=22078; -- Air Force Alarm Bot (Aldor) +UPDATE `creature_template` SET `unit_flags3`=8912896 WHERE `entry`=22071; -- Air Force Alarm Bot (Scryer) +UPDATE `creature_template` SET `unit_flags3`=8388608 WHERE `entry`=22070; -- Air Force Trip Wire - Rooftop (Scryer) +UPDATE `creature_template` SET `unit_flags3`=8388608 WHERE `entry`=22066; -- Air Force Guard Post (Scryer - Dragonhawk) +UPDATE `creature_template` SET `speed_walk`=1, `unit_flags`=32768 WHERE `entry`=22061; -- Shadowmoon Soulstealer +UPDATE `creature_template` SET `unit_flags3`=1 WHERE `entry`=22054; -- Behemothon, King of the Colossi +UPDATE `creature_template` SET `speed_walk`=1 WHERE `entry`=22037; -- Smith Gorlunk +UPDATE `creature_template` SET `speed_run`=1.385714292526245117 WHERE `entry`=22018; -- Eclipsion Cavalier +UPDATE `creature_template` SET `speed_walk`=1, `speed_run`=1.385714292526245117, `unit_flags3`=1 WHERE `entry`=22006; -- Shadowlord Deathwail +UPDATE `creature_template` SET `speed_walk`=1, `speed_run`=1.385714292526245117, `unit_flags3`=524288 WHERE `entry`=22000; -- Dragonmaw Nether Drake +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=21961; -- Cataclysm Overseer +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=21949; -- Fel Reaver Sentinel +UPDATE `creature_template` SET `faction`=1813, `BaseAttackTime`=10000 WHERE `entry`=21908; -- Spellbound Terrorguard +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=21872; -- The Voice of Gorefiend +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=21826; -- Sanoru +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=21803; -- Ashtongue Handler +UPDATE `creature_template` SET `speed_walk`=1, `unit_flags`=32768 WHERE `entry`=21789; -- Nakansi +UPDATE `creature_template` SET `npcflag`=66177 WHERE `entry`=21744; -- Roldemar +UPDATE `creature_template` SET `speed_walk`=1 WHERE `entry`=21722; -- Enslaved Netherwing Drake +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=21711; -- Haalum +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=21709; -- Eykenen +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=21701; -- Ashtongue Deathsworn +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=21700; -- Akama +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=21699; -- Maiev Shadowsong +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=21663; -- Oronu the Elder +UPDATE `creature_template` SET `speed_walk`=1 WHERE `entry`=21648; -- Mature Netherwing Drake +UPDATE `creature_template` SET `speed_walk`=1, `speed_run`=1.142857193946838378, `unit_flags`=2147779136 WHERE `entry`=21506; -- Azaloth +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=21478; -- Rocknail Ripper +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=21416; -- Lakaan +UPDATE `creature_template` SET `unit_flags3`=1 WHERE `entry`=21334; -- Veneratus Spawn Node +UPDATE `creature_template` SET `unit_flags3`=1 WHERE `entry`=21316; -- Deathforged Infernal +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=21307; -- Eva +UPDATE `creature_template` SET `faction`=38 WHERE `entry`=21196; -- Ravenous Flayer +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=21195; -- Domesticated Felboar +UPDATE `creature_template` SET `faction`=1847 WHERE `entry`=21179; -- Demon Hunter Supplicant +UPDATE `creature_template` SET `unit_flags3`=1 WHERE `entry`=21096; -- Credit Marker: Air +UPDATE `creature_template` SET `unit_flags3`=1 WHERE `entry`=21095; -- Credit Marker: Water +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=21059; -- Enraged Water Spirit +UPDATE `creature_template` SET `unit_flags3`=1 WHERE `entry`=21041; -- Earthmender Wilda Trigger +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=20795; -- Keeper of the Cistern +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=20684; -- Lady Shav'rar +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=20683; -- Prophetess Cavrylin +UPDATE `creature_template` SET `unit_flags3`=1 WHERE `entry`=20431; -- Eclipse Point - Bloodcrystal Spell Orgin +UPDATE `creature_template` SET `unit_flags3`=1 WHERE `entry`=20289; -- Illadari Point - Succubi Caster Position 02 +UPDATE `creature_template` SET `unit_flags3`=1 WHERE `entry`=20288; -- Illadari Point - Succubi Caster Position 01 +UPDATE `creature_template` SET `unit_flags3`=1 WHERE `entry`=20286; -- Illadari Point - Succubi Spell Orgin 001 +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=19824; -- Son of Corok +UPDATE `creature_template` SET `unit_flags`=32768 WHERE `entry`=19784; -- Coilskar Cobra +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=19768; -- Coilskar Siren +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=19767; -- Coilskar Sorceress +UPDATE `creature_template` SET `unit_flags`=33554688 WHERE `entry`=19760; -- Cooling Infernal +UPDATE `creature_template` SET `unit_flags`=32768 WHERE `entry`=21080; -- Dormant Infernal +UPDATE `creature_template` SET `npcflag`=640 WHERE `entry`=19625; -- Alorya +UPDATE `creature_template` SET `npcflag`=640 WHERE `entry`=19518; -- Feranin +UPDATE `creature_template` SET `npcflag`=65 WHERE `entry`=19341; -- Grutah +UPDATE `creature_template` SET `speed_walk`=1, `BaseAttackTime`=2000, `unit_flags`=32832 WHERE `entry`=18696; -- Kraator +UPDATE `creature_template` SET `speed_walk`=1, `unit_flags`=32832 WHERE `entry`=18694; -- Collidus the Warp-Watcher +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=18528; -- Xi'ri +UPDATE `creature_template` SET `unit_flags2`=0 WHERE `entry`=2630; -- Earthbind Totem + +-- Difficulty +UPDATE `creature_template_difficulty` SET `DifficultyID`=0 WHERE (`DifficultyID`=1 AND `Entry` IN (66557,66545,66544,66543,25938,25905,23501,23496,23489,23454,23452,23443,23434,23427,23376,23370,23348,23346,23345,23344,23342,23340,23326,23324,23311,23309,23308,23291,23289,23287,23286,23285,23283,23269,23267,23264,23209,23188,23169,23166,23164,23150,23149,23148,23146,23145,23144,23143,23142,23141,23140,23139,22968,22966,22433,22417,22395,22317,22315,22274,22253,22252,22214,22211,22146,22139,22138,22137,22113,22112,22096,22093,22084,22083,22081,22080,22079,22078,22073,22071,22070,22066,22061,22058,22054,22037,22025,22024,22018,22017,22016,22012,22011,22006,22000,21986,21979,21961,21960,21955,21954,21953,21949,21928,21908,21901,21897,21892,21872,21860,21827,21826,21822,21797,21790,21789,21779,21778,21766,21754,21753,21746,21744,21743,21727,21725,21722,21721,21720,21719,21718,21717,21711,21709,21705,21704,21701,21700,21699,21663,21657,21648,21639,21520,21512,21506,21505,21503,21478,21477,21472,21471,21450,21420,21416,21402,21385,21384,21357,21347,21337,21334,21316,21315,21309,21307,21295,21293,21292,21291,21255,21205,21196,21195,21183,21180,21179,21178,21171,21168,21164,21102,21096,21095,21094,21092,21060,21059,21052,21049,21041,21029,21027,21026,21024,20795,20684,20683,20563,20502,20431,20288,20286,20076,19827,19826,19825,19824,19823,19806,19801,19796,19795,19792,19789,19788,19784,19769,19768,19767,19765,19762,19760,19759,21080,19756,19744,19649,19648,19631,19629,19628,19627,19626,19625,19581,19532,19530,19528,19526,19521,19520,19518,19517,19504,18696,18695,17008)); +UPDATE `creature_template_difficulty` SET `VerifiedBuild`=50000 WHERE (`DifficultyID`=0 AND `Entry` IN (113941,66557,66545,66544,66543,62621,62314,61385,49568,25938,25905,25099,24925,24868,23501,23496,23489,23454,23452,23443,23434,23427,23376,23370,23348,23346,23345,23344,23342,23340,23326,23324,23311,23309,23308,23291,23289,23287,23286,23285,23283,23269,23267,23264,23209,23188,23169,23166,23164,23150,23149,23148,23146,23145,23144,23143,23142,23141,23140,23139,23033,22968,22966,22934,22864,22863,22862,22861,22860,22859,22858,22857,22515,22433,22417,22395,22317,22315,22274,22265,22253,22252,22230,22214,22211,22146,22139,22138,22137,22134,22113,22112,22096,22093,22084,22083,22082,22081,22080,22079,22078,22073,22072,22071,22070,22066,22061,22058,22054,22043,22042,22037,22025,22024,22018,22017,22016,22012,22011,22006,22000,21986,21979,21961,21960,21955,21954,21953,21949,21938,21937,21928,21924,21909,21908,21901,21897,21892,21879,21878,21872,21860,21827,21826,21822,21808,21807,21803,21802,21797,21790,21789,21779,21778,21777,21775,21774,21773,21772,21771,21770,21769,21766,21754,21753,21749,21746,21744,21743,21742,21736,21727,21725,21722,21721,21720,21719,21718,21717,21711,21710,21709,21705,21704,21703,21701,21700,21699,21663,21657,21656,21648,21639,21520,21512,21506,21505,21503,21501,21500,21499,21478,21477,21476,21475,21472,21471,21462,21455,21454,21453,21450,21420,21419,21417,21416,21408,21404,21403,21402,21386,21385,21384,21359,21357,21348,21347,21340,21337,21336,21334,21330,21316,21315,21314,21310,21309,21307,21305,21302,21295,21293,21292,21291,21255,21211,21210,21207,21205,21196,21195,21183,21180,21179,21178,21171,21168,21166,21164,21153,21108,21102,21096,21095,21094,21092,21061,21060,21059,21052,21050,21049,21041,21029,21027,21026,21024,20887,20878,20872,20795,20684,20683,20563,20511,20510,20509,20508,20507,20506,20505,20504,20503,20502,20500,20494,20493,20492,20491,20490,20489,20488,20486,20431,20288,20286,20076,19827,19826,19825,19824,19823,19806,19802,19801,19800,19799,19796,19795,19792,19789,19788,19784,19769,19768,19767,19765,19762,19760,19759,21080,19757,19756,19755,19754,19744,19740,19649,19648,19631,19629,19628,19627,19626,19625,19581,19532,19530,19528,19526,19521,19520,19518,19517,19504,19395,19394,19388,19387,19384,19382,19379,19375,19374,19373,19372,19371,19370,19369,19368,19364,19362,19355,19353,19352,19351,19348,19345,19343,19342,19341,19339,19333,19319,19317,18939,18696,18695,18528,17407,17008,10017)); +UPDATE `creature_template_difficulty` SET `ContentTuningID`=43, `VerifiedBuild`=50000 WHERE (`DifficultyID`=0 AND `Entry` IN (23225,23020,21864,20289,18694,2630)); + +UPDATE `creature_questitem` SET `VerifiedBuild`=50000 WHERE (`CreatureEntry`=23269 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=23267 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=23501 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=21901 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=21657 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=21802 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=23020 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=21864 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=23169 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=21102 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=21648 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=23326 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=21462 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=23285 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=21721 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=20502 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=21108 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=22072 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=21722 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=19784 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=21879 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=21897 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=21878 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=23264 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=21408 AND `DifficultyID`=0 AND `Idx`=0); + +-- Models +UPDATE `creature_model_info` SET `VerifiedBuild`=50000 WHERE `DisplayID` IN (45238, 51621, 45622, 45923, 35802, 4268, 36544, 16339, 22894, 22742, 22699, 19400, 21375, 21519, 21505, 19885, 21441, 21438, 21426, 13475, 13470, 21424, 21422, 21421, 20068, 17760, 21403, 18284, 18281, 18282, 18285, 21401, 21394, 21392, 21342, 21316, 21412, 21299, 21446, 21286, 21285, 21284, 19975, 21283, 21281, 21280, 21279, 21278, 21289, 21288, 21276, 21275, 21274, 21193, 19872, 18775, 17409, 21128, 21127, 20387, 21002, 6271, 20892, 20893, 10831, 20896, 20891, 20890, 20867, 20866, 20841, 15786, 20813, 20811, 20792, 20791, 20794, 20793, 20795, 20803, 20800, 20802, 20798, 20799, 20777, 20776, 17852, 7009, 20743, 20864, 20601, 20713, 20712, 20714, 20715, 20723, 20722, 20720, 20721, 20719, 20718, 20717, 20716, 20702, 20701, 20699, 20684, 17905, 20674, 20645, 20673, 20633, 20632, 20631, 19215, 20612, 20610, 20600, 20596, 20592, 20571, 19249, 15433, 20558, 20524, 20523, 20478, 17679, 20475, 20474, 20472, 16063, 20464, 20463, 20462, 20461, 20460, 20459, 20458, 20457, 20455, 20453, 20454, 20452, 20451, 20447, 20450, 20448, 20449, 20437, 20436, 20435, 20434, 20444, 20446, 20445, 20443, 20427, 18272, 20500, 20499, 20493, 20494, 20501, 20502, 20507, 20508, 20440, 20441, 20439, 19071, 19073, 19074, 20422, 20681, 20628, 20398, 20593, 19980, 20381, 2879, 17287, 20342, 20339, 20341, 20337, 20335, 20336, 20338, 19715, 20509, 19867, 20555, 20304, 20303, 20302, 20301, 20294, 20312, 20333, 20334, 20293, 19075, 20577, 17312, 20280, 13210, 20270, 20272, 20274, 20271, 20244, 20243, 782, 2687, 20228, 20225, 12817, 20218, 20385, 20213, 20220, 20221, 20199, 20198, 20197, 20196, 9370, 20157, 20239, 20238, 20146, 20136, 20757, 20758, 20756, 20759, 20131, 20133, 20134, 20132, 20130, 20126, 20124, 20122, 20521, 20522, 19595, 5564, 18657, 20039, 20020, 20022, 20006, 20005, 20004, 16889, 20233, 20234, 20920, 19683, 12054, 12055, 17759, 17717, 17703, 17697, 20263, 4048, 7248, 17722, 17719, 17721, 17720, 17423, 20273, 20276, 20278, 20261, 20361, 20363, 20362, 18654, 19892, 20214, 19991, 20357, 20356, 20354, 20355, 20676, 20678, 20677, 20353, 20352, 20351, 20350, 19363, 19361, 19362, 19365, 19366, 19364, 19360, 7029, 169, 14518, 18621, 8611, 20044, 19082, 19081, 19080, 19057, 19056, 19055, 19054, 19053, 20972, 18963, 18964, 18959, 18965, 18952, 18950, 18949, 18948, 18940, 18942, 18943, 18941, 18815, 18814, 18791, 18788, 18789, 18790, 17718, 18784, 18782, 18781, 18780, 18779, 18787, 18778, 18777, 20117, 20118, 20114, 20116, 20113, 20115, 18483, 18484, 18749, 18750, 18751, 18752, 18748, 18747, 6308, 4356, 1313, 3866, 3865, 1866, 3869, 18734, 18732, 7250, 20810, 11347, 20590, 20306, 17055, 16642, 16448, 21083, 21084, 16444, 4588); +UPDATE `creature_model_info` SET `BoundingRadius`=0.400621026754379272, `VerifiedBuild`=50000 WHERE `DisplayID`=62384; +UPDATE `creature_model_info` SET `BoundingRadius`=3.138532161712646484, `CombatReach`=3, `VerifiedBuild`=50000 WHERE `DisplayID`=20750; +UPDATE `creature_model_info` SET `BoundingRadius`=1.299999952316284179, `CombatReach`=1.625, `VerifiedBuild`=50000 WHERE `DisplayID`=14559; +UPDATE `creature_template_model` SET `VerifiedBuild`=50000 WHERE (`Idx`=1 AND `CreatureID` IN (113941,22079,21872,21718,21041,22139,21512,22058,22861,23443,22071,21334,21347,21419,22084,23324,22016,19792,21753,22082,23142,21052,24925,19504,22863,22317,22083,20431,21503,21505,23225,23496,21094,61385,22081,23287,21717,21092,22054,19806,20288,21960,17407,21986,22417,19384,22966,22274,23308,21096,22395,21060,21210,21742,21095,22093,19353,21807,19355,22070,22018,21211,22934,21924,21403,19364,21720,22080,22017,49568,21179,21049,21302,22252,23454,21180,22078,21719,19796,19388,20289,21348,21417,23150,22066,21310,21749,22096,23033,23146,19795,21736,20286,21080,21754,19362,21743,23209,23311,19387,21153)) OR (`Idx`=0 AND `CreatureID` IN (113941,22112,21315,21746,22079,19769,21872,21979,19379,21385,21164,21718,22230,21041,21205,21704,22073,22139,19374,20511,20509,20505,19799,19754,21512,21779,22058,22861,23370,23345,21657,21826,23443,22071,21709,21471,19352,19394,20507,21334,21316,21938,20491,19348,23286,23264,22860,21454,21347,21183,19767,19768,22146,19827,21408,21770,22043,25099,21419,22084,23324,22211,19530,19526,19788,21195,19789,21703,22016,19792,17008,21108,19802,21753,19345,19333,20493,22082,22864,23284,23148,23142,23269,21196,21052,21207,21775,19759,21778,21386,21450,24925,23289,23309,22000,19627,19801,21520,21909,21802,19649,19631,21295,19504,21384,19373,19825,21499,25938,19319,22006,22863,23489,23346,23169,22317,21700,19517,21102,21648,22083,20431,21475,19757,21061,20510,21500,66545,21340,19740,19755,21503,21505,23166,23225,21901,23496,21954,21402,19765,21094,21797,20878,22025,66543,61385,19342,21171,22081,23376,23139,23287,21717,21663,21860,19629,2630,20795,21864,21092,22054,19806,22138,20288,10017,21960,17407,21178,23340,22214,21986,21027,21416,22417,21639,20504,19384,22024,66544,19317,21168,21506,22134,22966,23283,23149,22274,23308,21096,21699,21701,20076,21953,22395,21060,21024,21210,19351,21337,21725,22037,22072,21742,22433,21722,21477,19744,19520,21803,18694,21095,19784,22093,22315,21472,19762,21774,21357,21307,21928,19353,21807,21879,21769,19355,22862,23267,22070,22018,21026,21211,25905,20887,62314,19343,19339,22934,22061,23348,23434,19521,21924,21710,21705,22137,21050,22042,21403,21305,19826,19364,21336,20489,21314,21166,23326,23188,21720,19628,21955,19648,22080,21462,22017,19341,49568,21892,21179,23143,23141,23285,21721,19625,20502,21049,19368,20508,20503,21309,21330,21302,23291,23144,22253,22252,23501,19626,23454,21711,19824,21773,24868,19375,19395,21292,62621,66557,20492,20488,21180,22858,23140,23342,21455,21822,19581,23020,18695,21293,19371,21656,21727,20683,21772,20494,20486,22265,21908,23145,21827,21478,19518,21808,22078,21501,20872,21771,20500,21719,22113,18528,21744,21897,21453,19528,18696,20684,22012,20563,19796,19388,21937,19372,20506,20289,21878,21348,21417,22859,23150,23344,21766,22066,23452,21420,21291,21476,18939,19382,21310,21949,20490,21749,22096,22857,23033,23427,23146,21029,21255,19795,19370,21736,20286,19800,21080,21754,21359,19362,21743,22968,23164,23209,23311,19532,22011,19823,21059,19760,19756,19387,21777,19369,21404,21789,21961,21790,21153)) OR (`Idx`=2 AND `CreatureID` IN (22084,23324,22016,19792,22082,23142,24925,19504,21503,21505,61385,23287,19806,21960,21986,19384,21742,19353,22018,19364,22017,49568,21179,21180,19796,23150,21749,19795,21736,19362,23209,21153)) OR (`Idx`=3 AND `CreatureID` IN (23324,22016,19792,23142,19504,21503,21505,23287,19806,21986,19384,21742,19353,22018,19364,22017,21179,21180,19796,21749,21736,19362,21153)); + +-- Gameobject templates +UPDATE `gameobject_template` SET `VerifiedBuild`=50000 WHERE `entry` IN (182925, 182886, 182918, 184868, 182873, 183027, 182901, 182889, 182914, 182880, 184833, 184872, 185127, 182919, 182908, 184835, 183402, 185137, 183035, 207480, 195260, 185129, 185102, 182963, 182894, 182923, 182887, 182921, 184388, 184490, 183009, 184731, 182864, 182898, 182883, 184860, 180035, 3946, 185138, 183025, 182912, 216477, 184386, 182962, 182928, 182890, 182884, 184859, 183401, 185131, 184114, 184385, 184286, 183005, 187576, 183007, 184652, 182892, 187573, 184331, 3945, 184683, 182900, 182881, 182917, 182907, 184391, 182877, 182868, 182895, 182876, 182920, 182909, 184416, 182872, 183026, 183008, 182960, 182896, 182899, 182867, 182910, 184871, 184389, 185146, 184714, 182893, 182904, 182916, 182905, 181391, 185132, 184392, 181390, 182897, 182891, 182927, 182875, 182888, 182913, 182906, 182946, 184294, 184390, 3947, 3950, 182878, 182871, 183032, 3948, 182869, 183024, 182865, 182902, 182874, 182915, 182911, 182879, 184827, 184949, 3949, 183030, 182965, 187653, 182922, 182929, 182924, 182885, 195259, 184738, 182870, 184285, 183029, 183022, 183006, 184387, 183033, 183028, 182961, 182964, 184946, 149045, 183344, 183010, 183023, 182926, 182903, 182882, 184834, 195255, 149046, 184384, 185125, 3944, 182994, 182866, 185123, 3951, 182966, 195266, 184246); +UPDATE `gameobject_template` SET `Data1`=0, `Data2`=1, `Data30`=21291, `ContentTuningId`=43, `VerifiedBuild`=50000 WHERE `entry`=185233; -- The Doctor's Strongbox +UPDATE `gameobject_template` SET `Data26`=1, `ContentTuningId`=43, `VerifiedBuild`=50000 WHERE `entry`=184684; -- Ravenous Flayer Egg +UPDATE `gameobject_template` SET `Data1`=0, `Data2`=1, `Data30`=21291, `ContentTuningId`=43, `VerifiedBuild`=50000 WHERE `entry`=184947; -- The Doctor's Strongbox +UPDATE `gameobject_template` SET `Data1`=0, `Data30`=21231, `ContentTuningId`=43, `VerifiedBuild`=50000 WHERE `entry`=184870; -- Baa'ri Tablet Fragment +UPDATE `gameobject_template` SET `Data26`=1, `ContentTuningId`=43, `VerifiedBuild`=50000 WHERE `entry`=185059; -- Fel Reaver Control Console +UPDATE `gameobject_template` SET `type`=50, `Data0`=2864, `Data3`=0, `Data4`=0, `Data5`=0, `Data6`=30, `Data7`=0, `Data18`=10, `Data20`=185878, `ContentTuningId`=43, `VerifiedBuild`=50000 WHERE `entry`=185877; -- Nethercite Deposit +UPDATE `gameobject_template` SET `type`=50, `Data0`=2856, `Data3`=0, `Data4`=0, `Data5`=0, `Data6`=30, `Data7`=0, `Data18`=10, `Data20`=185878, `ContentTuningId`=43, `VerifiedBuild`=50000 WHERE `entry`=185881; -- Netherdust Bush +UPDATE `gameobject_template` SET `Data8`=103828, `Data10`=30091, `VerifiedBuild`=50000 WHERE `entry`=182971; -- Anvil +UPDATE `gameobject_template` SET `Data26`=1, `ContentTuningId`=43, `VerifiedBuild`=50000 WHERE `entry`=185061; -- Fel Reaver Control Console +UPDATE `gameobject_template` SET `ContentTuningId`=394, `VerifiedBuild`=50000 WHERE `entry`=187967; -- Horde Bonfire +UPDATE `gameobject_template` SET `Data1`=0, `Data30`=21292, `ContentTuningId`=43, `VerifiedBuild`=50000 WHERE `entry`=184948; -- Ever-burning Ash +UPDATE `gameobject_template` SET `ContentTuningId`=43, `VerifiedBuild`=50000 WHERE `entry` IN (185009, 185008, 185010); -- Arcano Control Unit +UPDATE `gameobject_template` SET `ContentTuningId`=43, `VerifiedBuild`=50000 WHERE `entry`=185126; -- Crystal Prison +UPDATE `gameobject_template` SET `Data1`=0, `Data30`=21023, `ContentTuningId`=43, `VerifiedBuild`=50000 WHERE `entry`=184795; -- Rotten Arakkoa Egg +UPDATE `gameobject_template` SET `Data8`=103828, `Data10`=30091, `VerifiedBuild`=50000 WHERE `entry`=182968; -- Anvil +UPDATE `gameobject_template` SET `ContentTuningId`=43, `VerifiedBuild`=50000 WHERE `entry` IN (185057, 185034, 185058); -- Fel Reaver Control Console +UPDATE `gameobject_template` SET `Data1`=0, `Data2`=1, `Data30`=21748, `ContentTuningId`=43, `VerifiedBuild`=50000 WHERE `entry`=185128; -- Lianthe's Strongbox +UPDATE `gameobject_template` SET `ContentTuningId`=43, `VerifiedBuild`=50000 WHERE `entry` IN (184796, 184797); -- Rotten Arakkoa Egg +UPDATE `gameobject_template` SET `Data8`=103828, `Data10`=30091, `VerifiedBuild`=50000 WHERE `entry`=183034; -- Anvil +UPDATE `gameobject_template` SET `Data26`=1, `ContentTuningId`=43, `VerifiedBuild`=50000 WHERE `entry`=185060; -- Fel Reaver Control Console +UPDATE `gameobject_template` SET `ContentTuningId`=43, `VerifiedBuild`=50000 WHERE `entry`=185156; -- Zuluhed's Chains +UPDATE `gameobject_template` SET `Data1`=0, `Data30`=21717, `ContentTuningId`=43, `VerifiedBuild`=50000 WHERE `entry`=184716; -- Coilskar Chest +UPDATE `gameobject_template` SET `Data8`=103828, `Data10`=30091, `VerifiedBuild`=50000 WHERE `entry`=182967; -- Anvil +UPDATE `gameobject_template` SET `ContentTuningId`=1014, `VerifiedBuild`=50000 WHERE `entry`=185550; -- Meeting Stone +UPDATE `gameobject_template` SET `Data1`=0, `Data15`=0, `Data30`=22116, `ContentTuningId`=43, `VerifiedBuild`=50000 WHERE `entry`=185915; -- Netherwing Egg +UPDATE `gameobject_template` SET `Data1`=0, `Data18`=676, `Data30`=39342, `ContentTuningId`=43, `VerifiedBuild`=50000 WHERE `entry`=207479; -- Silverbound Treasure Chest +UPDATE `gameobject_template` SET `ContentTuningId`=43, `VerifiedBuild`=50000 WHERE `entry`=184701; -- Shadowmoon Tuber Mound +UPDATE `gameobject_template` SET `Data8`=103828, `Data10`=30091, `VerifiedBuild`=50000 WHERE `entry`=182973; -- Anvil +UPDATE `gameobject_template` SET `Data8`=103828, `Data10`=30091, `VerifiedBuild`=50000 WHERE `entry`=182862; -- Anvil +UPDATE `gameobject_template` SET `ContentTuningId`=43, `VerifiedBuild`=50000 WHERE `entry`=184747; -- Flayer Fog +UPDATE `gameobject_template` SET `ContentTuningId`=43, `VerifiedBuild`=50000 WHERE `entry`=184801; -- Rotten Arakkoa Egg Dummy +UPDATE `gameobject_template` SET `Data1`=0, `Data30`=21750, `ContentTuningId`=43, `VerifiedBuild`=50000 WHERE `entry`=185130; -- Sketh'lon Feather +UPDATE `gameobject_template` SET `Data8`=103828, `Data10`=30091, `VerifiedBuild`=50000 WHERE `entry`=182969; -- Anvil +UPDATE `gameobject_template` SET `Data8`=103828, `Data10`=30091, `VerifiedBuild`=50000 WHERE `entry`=182972; -- Anvil +UPDATE `gameobject_template` SET `Data8`=103828, `Data10`=30091, `VerifiedBuild`=50000 WHERE `entry`=182863; -- Anvil +UPDATE `gameobject_template` SET `Data1`=0, `Data30`=21772, `ContentTuningId`=43, `VerifiedBuild`=50000 WHERE `entry`=185182; -- Nethervine Crystal +UPDATE `gameobject_template` SET `ContentTuningId`=43, `VerifiedBuild`=50000 WHERE `entry`=185878; -- Nethercite Smoke Effect +UPDATE `gameobject_template` SET `ContentTuningId`=394, `VerifiedBuild`=50000 WHERE `entry`=187935; -- Alliance Bonfire +UPDATE `gameobject_template` SET `Data8`=103828, `Data10`=30091, `VerifiedBuild`=50000 WHERE `entry`=183031; -- Anvil +UPDATE `gameobject_template` SET `ContentTuningId`=43, `VerifiedBuild`=50000 WHERE `entry`=184979; -- Deathforged Infernal +UPDATE `gameobject_template` SET `ContentTuningId`=43, `VerifiedBuild`=50000 WHERE `entry`=184945; -- Wanted Poster +UPDATE `gameobject_template` SET `ContentTuningId`=43, `VerifiedBuild`=50000 WHERE `entry`=185600; -- Netherwing Egg Trap (Gas) +UPDATE `gameobject_template` SET `Data1`=0, `Data30`=21231, `ContentTuningId`=43, `VerifiedBuild`=50000 WHERE `entry`=184869; -- Baa'ri Tablet Fragment +UPDATE `gameobject_template` SET `Data8`=103828, `Data10`=30091, `VerifiedBuild`=50000 WHERE `entry`=182970; -- Anvil +UPDATE `gameobject_template` SET `Data1`=0, `Data30`=22187, `ContentTuningId`=43, `VerifiedBuild`=50000 WHERE `entry`=185939; -- Nethermine Cargo + +UPDATE `gameobject_template_addon` SET `faction`=114 WHERE `entry`=216477; -- Boarded Gate +UPDATE `gameobject_template_addon` SET `flags`=278528 WHERE `entry`=185881; -- Netherdust Bush +UPDATE `gameobject_template_addon` SET `flags`=278528 WHERE `entry`=185877; -- Nethercite Deposit +UPDATE `gameobject_template_addon` SET `flags`=4 WHERE `entry` IN (185061, 185060, 185059); -- Fel Reaver Control Console +UPDATE `gameobject_template_addon` SET `faction`=1732 WHERE `entry`=184947; -- The Doctor's Strongbox +UPDATE `gameobject_template_addon` SET `flags`=4 WHERE `entry`=184834; -- Infernal +UPDATE `gameobject_template_addon` SET `faction`=114 WHERE `entry`=184827; -- Legion Display Device + +UPDATE `gameobject_questitem` SET `VerifiedBuild`=50000 WHERE (`Idx`=0 AND `GameObjectEntry` IN (185939,185182,184870,184869,185128,184795,185130,184859,185233,184947,184860,184948)); |