diff options
| -rw-r--r-- | sql/updates/world/master/2023_06_28_07_world.sql | 154 |
1 files changed, 154 insertions, 0 deletions
diff --git a/sql/updates/world/master/2023_06_28_07_world.sql b/sql/updates/world/master/2023_06_28_07_world.sql new file mode 100644 index 00000000000..06670a6f228 --- /dev/null +++ b/sql/updates/world/master/2023_06_28_07_world.sql @@ -0,0 +1,154 @@ +-- Creature templates +UPDATE `creature_template` SET `faction`=14, `speed_walk`=1.60000002384185791, `speed_run`=1.428571462631225585, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE `entry`=115644; -- Scalewing Queen +UPDATE `creature_template` SET `faction`=1781, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE `entry`=115598; -- Empowered Earth Elemental +UPDATE `creature_template` SET `faction`=1781, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE `entry`=115597; -- Geo-Lord Garug +UPDATE `creature_template` SET `npcflag`=1073741824, `BaseAttackTime`=2000, `unit_flags`=33280, `unit_flags2`=2048 WHERE `entry`=62638; -- Skittering Cavern Crawler +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=51612; -- Death's Door Fel Cannon +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=23473; -- Aether-tech Apprentice +UPDATE `creature_template` SET `unit_flags3`=1 WHERE `entry`=23282; -- Obsidia +UPDATE `creature_template` SET `unit_flags3`=1 WHERE `entry`=23281; -- Insidion +UPDATE `creature_template` SET `unit_flags3`=1 WHERE `entry`=23261; -- Furywing +UPDATE `creature_template` SET `speed_run`=2.142857074737548828 WHERE `entry`=23257; -- Skyguard Windcharger +UPDATE `creature_template` SET `unit_flags`=33554432, `unit_flags2`=2099200, `unit_flags3`=524288 WHERE `entry`=23119; -- Bombing Run Explosion Bunny +UPDATE `creature_template` SET `unit_flags3`=8388608 WHERE `entry`=23115; -- Ogri'la Peacekeeper +UPDATE `creature_template` SET `unit_flags3`=524289 WHERE `entry`=23082; -- Legion Flak Cannon +UPDATE `creature_template` SET `unit_flags`=33554688, `unit_flags3`=524288 WHERE `entry`=23077; -- [PH]Knockdown Fel Cannon Dummy +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=23076; -- Legion Flak Cannon +UPDATE `creature_template` SET `unit_flags3`=1 WHERE `entry`=23061; -- Rivendark +UPDATE `creature_template` SET `unit_flags3`=8388608 WHERE `entry`=22923; -- Simon Game Bunny +UPDATE `creature_template` SET `unit_flags`=33280 WHERE `entry`=22911; -- Vim'gol the Vile +UPDATE `creature_template` SET `unit_flags3`=1 WHERE `entry`=22465; -- Natasha +UPDATE `creature_template` SET `unit_flags3`=8388608 WHERE `entry`=22410; -- Expedition Outrider +UPDATE `creature_template` SET `speed_walk`=1, `speed_run`=0.857142865657806396 WHERE `entry`=22396; -- Draaca Longtail +UPDATE `creature_template` SET `speed_walk`=1, `speed_run`=0.857142865657806396 WHERE `entry`=22308; -- Wyrmcult Hunter +UPDATE `creature_template` SET `faction`=16 WHERE `entry`=23385; -- Simon Unit +UPDATE `creature_template` SET `speed_walk`=0.5, `speed_run`=0.571428596973419189, `unit_flags3`=8388608 WHERE `entry`=22206; -- Expedition Druid +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=22180; -- Shard-Hide Boar +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=22175; -- Apexis Flayer +UPDATE `creature_template` SET `unit_flags3`=8388608 WHERE `entry`=22151; -- Ruuan Weald Sister +UPDATE `creature_template` SET `speed_walk`=1 WHERE `entry`=22130; -- Baron Sablemane's Blackwhelp +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=22123; -- Rip-Blade Ravager +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=22110; -- Tethik +UPDATE `creature_template` SET `speed_walk`=1 WHERE `entry`=22108; -- Blackwhelp +UPDATE `creature_template` SET `unit_flags3`=8388608 WHERE `entry`=22090; -- Air Force Guard Post (Toshley's Station - Flying Machine) +UPDATE `creature_template` SET `speed_walk`=1, `unit_flags2`=2099200, `unit_flags3`=8912896 WHERE `entry`=22089; -- Toshley Flying Machine +UPDATE `creature_template` SET `speed_walk`=1 WHERE `entry`=22053; -- Mosswood the Ancient +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=22021; -- O'Mally's Instrument Bunny +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=21944; -- Gnome Cannon Shooter #Ruuan +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=21942; -- Gnome Cannon Shooter #Singing Ridge +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=21935; -- Gnome Cannon Shooter #Shattrath +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=21930; -- Gnome Cannon Shooter #0 +UPDATE `creature_template` SET `unit_flags`=32768 WHERE `entry`=21837; -- Summoned Wrath Hound +UPDATE `creature_template` SET `unit_flags3`=524288 WHERE `entry`=21814; -- Nether Drake Egg Bunny +UPDATE `creature_template` SET `speed_walk`=1 WHERE `entry`=21811; -- Wyrmcult Broodling +UPDATE `creature_template` SET `unit_flags3`=524288 WHERE `entry`=21757; -- Big Electromental Flavor +UPDATE `creature_template` SET `unit_flags3`=524288 WHERE `entry`=21737; -- Mini-Electromental Flavor +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=21690; -- R-3D0 +UPDATE `creature_template` SET `unit_flags`=832 WHERE `entry`=21497; -- Blackscale +UPDATE `creature_template` SET `speed_walk`=1 WHERE `entry`=21492; -- Wyrmcult Blessed +UPDATE `creature_template` SET `unit_flags3`=1 WHERE `entry`=21447; -- Blade's Edge - Toshley's - Def Gun Attack Origin +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=21413; -- Gnome Cannon Shooter #1 +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=21393; -- Cannon Channeler +UPDATE `creature_template` SET `speed_walk`=1 WHERE `entry`=21387; -- Wyrmcult Blackwhelp +UPDATE `creature_template` SET `BaseAttackTime`=2000 WHERE `entry`=21254; -- Dullgrom Dredger +UPDATE `creature_template` SET `npcflag`=80 WHERE `entry`=21087; -- Grikka +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=21022; -- Grovestalker Lynx +UPDATE `creature_template` SET `speed_walk`=1, `speed_run`=2.142857074737548828 WHERE `entry`=20998; -- Ridgespine Horror +UPDATE `creature_template` SET `unit_flags`=33554688 WHERE `entry`=20736; -- Blade's Edge - Legion - Invis Bunny +UPDATE `creature_template` SET `speed_walk`=1, `speed_run`=1.428571462631225585 WHERE `entry`=20714; -- Ridgespine Stalker +UPDATE `creature_template` SET `BaseAttackTime`=2000 WHERE `entry`=20668; -- Fiendling Flesh Beast +UPDATE `creature_template` SET `speed_run`=1.142857193946838378 WHERE `entry`=20557; -- Wrath Hound +UPDATE `creature_template` SET `speed_walk`=1.399999976158142089, `speed_run`=1.428571462631225585 WHERE `entry`=20327; -- Grishna Raven +UPDATE `creature_template` SET `npcflag`=0, `speed_walk`=1, `unit_flags3`=524288 WHERE `entry`=20214; -- Arakkoa Egg +UPDATE `creature_template` SET `speed_walk`=1 WHERE `entry`=20126; -- Sylvanaar Ancient Protector +UPDATE `creature_template` SET `unit_flags3`=1 WHERE `entry`=20093; -- Blade's Edge - Arakkoa Spell Origin +UPDATE `creature_template` SET `unit_flags3`=1 WHERE `entry`=20024; -- Blade's Edge Kneel Target 03 +UPDATE `creature_template` SET `unit_flags3`=1 WHERE `entry`=20023; -- Blade's Edge Kneel Target 02 +UPDATE `creature_template` SET `unit_flags3`=1 WHERE `entry`=20003; -- Blade's Edge Kneel Target 01 +UPDATE `creature_template` SET `speed_walk`=1, `speed_run`=1.142857193946838378 WHERE `entry`=19960; -- Doomforge Engineer +UPDATE `creature_template` SET `speed_walk`=1, `speed_run`=1.142857193946838378 WHERE `entry`=19747; -- Baelmon the Hound-Master +UPDATE `creature_template` SET `unit_flags`=0 WHERE `entry`=15476; -- Scorpid + +UPDATE `creature_template_addon` SET `mount`=21156 WHERE `entry`=23335; -- 23335 (Skyguard Khatie) + +-- Difficulty +DELETE FROM `creature_template_difficulty` WHERE (`DifficultyID`=2 AND `Entry` IN (23347,23362,23256,23115,23112,23110,22271,22270,22264)); +DELETE FROM `creature_template_difficulty` WHERE (`DifficultyID`=1 AND `Entry` IN (68841,62628,62184,61326,61081,61080,50481,23280,23257,23040,22995,22987,22982,22980,22941,22502,22495,22480,22474,22472,22443,22423,22422,22126,22125,22124,22044,22003,22001,21999,21996,21993,21984,21810,21809,21757,21659,21519,21516,21349,21300,21238,21233,21203,21189,21176,21147,21124,21123,21117,21033,21032,21004,20998,20925,20855,20853,20852,20851,20771,20751,20749,20748,20736,20714,20670,20668,20614,20609,20601,20600,20514,20216,20095,20058,19992,19991,19979,19978,19957,19952,19948,19837,19656,19479,19478,19476,19474,19472,19471,19470,19450,19449,18953,18248,17855,16952,15476,15241,10204,3681,2615,2614,1412,883,721)); + +UPDATE `creature_template_difficulty` SET `DifficultyID`=0 WHERE (`DifficultyID` IN (1,2) AND `Entry` IN (115644,115598,115597,62638,51612,23512,23500,23473,23428,23413,23395,23392,23382,23378,23362,23347,23335,23334,23316,23301,23300,23282,23281,23278,23262,23261,23256,23255,23253,23246,23233,23228,23212,23208,23199,23173,23154,23153,23120,23119,23115,23112,23110,23082,23078,23077,23076,23061,23059,22924,22923,22922,22919,22918,22911,22801,22800,22799,22798,22500,22471,22469,22468,22465,22455,22410,22396,22386,22384,22368,22367,22356,22312,22308,22306,22305,22298,22291,22282,22271,22270,22268,22266,22264,22255,22254,22244,22243,23385,22242,22241,22216,22215,22206,22204,22196,22195,22181,22180,22175,22160,22151,22150,22149,22142,22141,22136,22135,22133,22130,22127,22123,22116,22110,22108,22103,22099,22090,22089,22053,22052,22040,22039,22021,22020,22019,22007,22004,21983,21981,21975,21956,21944,21942,21935,21930,21896,21895,21851,21840,21839,21837,21824,21819,21814,21811,21782,21755,21737,21692,21691,21690,21637,21497,21496,21494,21492,21469,21461,21460,21447,21422,21413,21393,21389,21387,21383,21382,21381,21380,21352,21326,21325,21311,21296,21277,21254,21234,21197,21158,21152,21151,21142,21118,21115,21114,21113,21112,21111,21110,21107,21106,21105,21103,21088,21087,21086,21085,21084,21083,21082,21081,21074,21066,21053,21048,21047,21046,21042,21040,21023,21022,21021,20987,20924,20917,20916,20915,20889,20856,20768,20766,20765,20757,20756,20753,20747,20732,20731,20730,20729,20728,20726,20723,20713,20666,20635,20557,20334,20330,20329,20327,20250,20249,20230,20214,20211,20161,20127,20126,20113,20109,20093,20024,20023,20003,19998,19997,19996,19995,19994,19993,19990,19989,19988,19987,19986,19985,19984,19983,19982,19980,19973,19961,19960,19945,19944,19943,19747,19500,19499,19498,19497,19495,19473,18937,18693,18098)); +UPDATE `creature_template_difficulty` SET `VerifiedBuild`=49890 WHERE (`DifficultyID`=0 AND `Entry` IN (68841,62628,62184,61326,61081,61080,50481,23280,23257,23040,22995,22987,22982,22980,22941,22502,22495,22480,22474,22472,22443,22423,22422,22126,22125,22124,22044,22003,22001,21999,21996,21993,21984,21810,21809,21757,21659,21519,21516,21349,21300,21238,21233,21203,21189,21176,21147,21124,21123,21117,21033,21032,21004,20998,20925,20855,20853,20852,20851,20771,20751,20749,20748,20736,20714,20670,20668,20614,20609,20601,20600,20514,20216,20095,20058,19992,19991,19979,19978,19957,19952,19948,19837,19656,19479,19478,19476,19474,19472,19471,19470,19450,19449,18953,18248,17855,16952,15476,15241,10204,3681,2615,2614,1412,883,721)); +UPDATE `creature_template_difficulty` SET `VerifiedBuild`=49890 WHERE (`DifficultyID`=0 AND `Entry` IN (115644,115598,115597,62638,51612,23512,23500,23473,23428,23413,23395,23392,23382,23378,23362,23347,23335,23334,23316,23301,23300,23282,23281,23278,23262,23261,23256,23255,23253,23246,23233,23228,23212,23208,23199,23173,23154,23120,23119,23115,23112,23110,23082,23078,23077,23076,23061,23059,22924,22923,22922,22919,22918,22911,22801,22800,22799,22798,22500,22471,22469,22468,22465,22455,22410,22396,22386,22384,22368,22367,22356,22312,22308,22306,22305,22298,22291,22282,22271,22270,22268,22266,22264,22255,22254,22244,22243,23385,22242,22241,22216,22215,22206,22204,22196,22195,22181,22180,22175,22160,22151,22150,22149,22142,22141,22136,22135,22133,22130,22127,22123,22116,22110,22108,22103,22099,22090,22089,22053,22052,22040,22039,22021,22020,22019,22007,22004,21983,21981,21975,21944,21942,21935,21930,21896,21895,21851,21840,21839,21837,21824,21819,21814,21811,21782,21755,21737,21692,21691,21690,21637,21497,21496,21494,21492,21469,21461,21460,21447,21422,21413,21393,21389,21387,21383,21382,21381,21380,21352,21326,21325,21311,21296,21277,21254,21234,21197,21158,21152,21151,21142,21118,21115,21114,21113,21112,21111,21110,21107,21106,21105,21103,21088,21087,21086,21085,21084,21083,21082,21081,21074,21066,21053,21048,21047,21046,21042,21040,21023,21022,21021,20987,20924,20917,20916,20915,20889,20856,20768,20766,20765,20757,20756,20753,20747,20732,20731,20730,20729,20728,20726,20723,20713,20666,20635,20557,20334,20330,20329,20327,20250,20249,20230,20214,20211,20161,20127,20126,20113,20109,20093,20024,20023,20003,19998,19997,19996,19995,19994,19993,19990,19989,19988,19987,19986,19985,19984,19983,19982,19980,19973,19961,19960,19945,19944,19943,19747,19500,19499,19498,19497,19495,19473,18937,18693,18098)); +UPDATE `creature_template_difficulty` SET `ContentTuningID`=41, `VerifiedBuild`=49890 WHERE (`DifficultyID`=0 AND `Entry` IN (23153,21956)); + +UPDATE `creature_questitem` SET `VerifiedBuild`=49890 WHERE (`CreatureEntry`=22255 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=21124 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=20330 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=20925 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=21389 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=20987 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=21387 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=22181 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=21022 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=20713 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=22052 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=22180 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=20058 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=115597 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=23061 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=23061 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=21956 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=20924 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=20557 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=20748 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=21033 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=21123 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=19980 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=22123 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=23281 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=23281 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=23261 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=23261 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=20729 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=23282 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=23282 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=21004 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=21032 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=115644 AND `DifficultyID`=0 AND `Idx`=1) OR (`CreatureEntry`=115644 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=20728 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=20751 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=20749 AND `DifficultyID`=0 AND `Idx`=0) OR (`CreatureEntry`=21839 AND `DifficultyID`=0 AND `Idx`=0); + +-- Models +UPDATE `creature_model_info` SET `VerifiedBuild`=49890 WHERE `DisplayID` IN (73904, 73882, 73881, 47021, 45953, 4268, 36544, 21499, 47209, 21480, 21459, 18288, 47207, 47206, 21415, 21414, 47196, 21405, 21398, 12869, 21194, 47195, 47194, 21487, 47210, 7816, 21258, 16946, 19906, 47208, 21343, 24139, 21155, 21156, 21169, 21183, 21182, 21184, 21136, 5441, 19661, 18031, 14501, 45899, 17188, 21034, 21033, 257, 21035, 20982, 20970, 20926, 20923, 17876, 12231, 21307, 14430, 47205, 47204, 4585, 47203, 47202, 20901, 20894, 20989, 20895, 20898, 20871, 12051, 29440, 17095, 18671, 20855, 21282, 20831, 20840, 20836, 20830, 20829, 20827, 20825, 20822, 13672, 2160, 17086, 20965, 20808, 20807, 20789, 8011, 19770, 1088, 20843, 9535, 20711, 20680, 20928, 60766, 20700, 20679, 20657, 20634, 21052, 21058, 17834, 11997, 20520, 17612, 497, 20480, 20482, 20483, 20481, 20485, 20484, 20486, 20487, 4249, 20442, 21059, 20418, 20417, 2421, 20380, 20379, 20377, 20378, 20531, 20532, 8574, 21055, 20325, 12894, 876, 15435, 16925, 14355, 397, 20258, 20257, 20256, 20255, 20254, 20253, 20251, 20252, 20329, 15774, 20240, 20249, 20250, 20215, 20203, 20202, 20206, 20204, 19756, 20181, 18505, 20149, 21234, 20121, 20111, 20112, 20150, 20110, 19742, 20094, 20092, 20091, 20086, 20331, 20332, 20088, 20082, 20083, 20081, 20084, 20080, 20079, 20078, 20077, 20075, 20074, 20073, 20072, 20059, 20058, 20057, 20056, 20055, 20054, 20051, 20053, 20052, 20038, 20024, 20018, 20019, 20017, 20013, 20604, 101348, 17094, 20158, 16975, 19705, 16890, 19980, 16876, 16877, 16879, 8666, 2220, 2232, 19759, 20842, 20839, 20838, 9370, 7898, 20093, 19758, 18358, 19785, 19728, 19634, 19595, 17200, 20987, 19772, 19692, 19691, 20853, 1204, 11544, 19531, 20001, 7999, 12044, 19667, 10056, 20730, 2429, 18434, 19347, 15880, 19765, 11583, 18070, 19762, 19755, 17782, 17835, 19905, 19604, 19606, 17868, 19368, 19190, 19168, 18368, 18139, 19961, 19486, 11549, 11550, 10708, 19605, 17858, 18485, 19208, 20533, 4843, 4842, 4841, 4844, 1712, 4404, 2055, 10582, 18917, 18918, 18915, 18913, 18912, 18911, 18909, 18907, 18898, 20207, 20209, 20208, 20210, 20192, 20193, 20762, 17635, 17524, 20618, 20621, 20620, 20619, 18193, 15469, 15471, 5905, 15470, 17202, 4449, 9492, 10045, 11686, 134, 347, 4626, 328); +UPDATE `creature_model_info` SET `BoundingRadius`=0.409200012683868408, `CombatReach`=1.65000009536743164, `DisplayID_Other_Gender`=0, `VerifiedBuild`=49890 WHERE `DisplayID`=21295; +UPDATE `creature_model_info` SET `BoundingRadius`=0.623502552509307861, `VerifiedBuild`=49890 WHERE `DisplayID`=13673; +UPDATE `creature_model_info` SET `CombatReach`=0.979591846466064453, `VerifiedBuild`=49890 WHERE `DisplayID`=20738; +UPDATE `creature_template_model` SET `VerifiedBuild`=49890 WHERE (`Idx`=1 AND `CreatureID` IN (22422,22003,20230,22471,21447,20749,20853,22800,23119,22090,20852,21383,19656,21944,19500,19449,21935,21300,22410,22801,23500,21142,20003,20889,20670,23382,21819,2614,721,22135,23154,23512,15476,22021,23082,22502,22423,21382,22980,23301,61326,21053,22982,22923,22126,21809,22799,22474,20736,21814,22356,23059,23255,21352,22001,2615,21422,21234,20023,20851,22125,21810,22500,22495,21413,21203,21081,23228,21074,21942,20855,23077,19978,50481,61080,23262,20771,22308,23278,23257,21999,21152,23395,17855,22987,21993,62184,22039,22123,22040,23212,23199,23378,20024,23040,20856,22798,21637,21176,21115,23173,21996,21033,22472,21930,20093,20666,22254,21114,40165,22124,23078,21393)) OR (`Idx`=0 AND `CreatureID` IN (22422,22922,22282,22003,20230,19991,115598,23280,21311,22471,21737,21447,20749,20214,21840,20998,20601,20853,21981,21811,22800,23119,21690,21757,22090,21086,22241,22255,20852,22368,22130,21383,22175,19656,21023,15241,19995,21944,22136,22004,21692,20614,20668,20216,22099,19500,19449,21935,22312,22142,21085,21300,22410,22801,21492,23500,22298,23076,21151,21975,20728,21142,21837,21824,20714,20751,20003,20747,20889,20670,23382,18098,22469,21197,18937,19450,19479,21494,21111,21118,21819,2614,21032,21189,115644,68841,721,22135,23154,22216,20756,19996,22116,22941,23233,23512,20109,21349,51612,15476,21106,1412,21839,59072,22911,22021,20987,19988,21326,21387,22196,23253,22181,23082,19945,19495,19499,21022,20713,20732,19470,22502,22423,21519,21107,21496,65011,22242,19961,19960,21983,20211,19990,21042,21382,22980,23300,23301,21158,19497,19474,21984,20768,61326,19984,22468,21084,14505,22919,21053,20609,22150,883,22480,22103,20924,20557,22982,22923,20730,21277,20748,21659,21460,47654,20514,62628,20916,22053,22126,18693,22384,19994,21809,22799,21851,21325,23392,23316,22266,20731,19471,22474,20736,21461,21814,19979,21087,305,20925,16952,22356,21389,23208,23059,22271,23255,22204,19498,19998,21352,22001,2615,22443,21516,21422,21234,20023,21082,64993,20851,22465,22924,22125,20330,22396,21810,22291,21147,19473,10204,22500,22495,21413,21203,21083,21081,356,23281,23261,20249,20250,19987,20729,3681,21047,23228,23335,23282,22306,21074,21381,19952,19837,21942,21004,22141,54741,22244,20855,22133,22367,22160,22215,20327,21497,22019,22195,23112,22180,23077,62638,19992,20058,18248,19978,50481,61080,22110,23262,23153,21124,20771,22149,22308,23278,23413,23257,20126,21238,19476,21999,21152,20161,21105,68288,23395,21233,19997,17855,22987,19973,22044,19944,19957,19948,21993,22089,62184,21088,25064,21123,22020,22151,20917,19985,12922,19993,19989,23473,23362,22270,22039,21380,20095,19980,22123,21896,71486,20915,21782,20757,20753,22206,22040,23212,23199,23061,23378,20127,20334,21956,21113,21691,20024,18379,23040,20856,20329,22798,21048,22264,20113,21066,21469,22052,21895,28363,22007,19986,22108,21637,23334,23347,20723,21296,21176,19747,21115,21254,19983,19982,40625,21021,22386,23173,23120,23428,23115,21996,20726,18953,21117,21033,22472,21930,21755,20093,21103,61081,35362,23246,22243,20666,22918,22268,21046,22254,23256,23386,115597,19478,19472,21110,21112,21114,22305,40165,20635,22127,22124,22995,21040,23078,23110,19943,20766,20765,21393,20600,22455,304)) OR (`Idx`=2 AND `CreatureID` IN (20749,21383,19500,19449,21300,22135,23154,15476,21382,22980,61326,21809,21810,21081,22308,23257,17855,22987,21637,21115,22254,21114)) OR (`Idx`=3 AND `CreatureID` IN (21383,19500,19449,21300,22135,23154,15476,21382,22980,61326,21809,21810,22308,23257,17855,22987,21637,21115,22254,21114)); + +-- Gameobject templates +UPDATE `gameobject_template` SET `ContentTuningId`=41, `VerifiedBuild`=49890 WHERE `entry` IN (185613, 185674, 185771, 185645, 185657, 185773, 185670, 185809, 185851, 185626, 185804, 185854, 185831, 185797, 185621, 185839, 185650, 185823, 185655, 185785, 185827, 185788, 185666, 185782, 185843, 185815, 185835, 185638); -- Red Cluster +UPDATE `gameobject_template` SET `ContentTuningId`=41, `VerifiedBuild`=49890 WHERE `entry` IN (185633, 185759, 185712, 185701, 185751, 185622, 185801, 185722, 185729, 185747, 185693, 185705, 185725, 185614, 185766, 185685, 185677, 185697, 185735, 185755, 185680, 185629, 185689, 185760, 185739, 185718, 185743, 185711); -- Simon Game Base Yellow Small +UPDATE `gameobject_template` SET `ContentTuningId`=41, `VerifiedBuild`=49890 WHERE `entry` IN (185671, 185789, 185774, 185810, 185805, 185786, 185654, 185822, 185667, 185838, 185855, 185651, 185826, 185639, 185798, 185850, 185627, 185781, 185646, 185675, 185830, 185842, 185768, 185834, 185611, 185619, 185658, 185814); -- Green Cluster +UPDATE `gameobject_template` SET `ContentTuningId`=41, `VerifiedBuild`=49890 WHERE `entry` IN (185706, 185723, 185744, 185740, 185686, 185732, 185736, 185698, 185719, 185726, 185681, 185715, 185630, 185616, 185730, 185678, 185800, 185764, 185708, 185763, 185608, 185634, 185752, 185756, 185692, 185690, 185702, 185748); -- Simon Game Base Blue Small +UPDATE `gameobject_template` SET `VerifiedBuild`=49890 WHERE `entry` IN (184097, 185030, 183420, 185257, 184147, 183923, 183356, 184370, 185538, 185535, 185530, 184342, 184397, 184742, 184467, 185270, 183467, 182606, 185285, 184101, 185026, 185029, 185534, 185265, 185965, 185920, 278574, 184729, 185287, 184098, 184372, 185529, 184349, 183424, 183408, 183430, 184737, 185284, 185286, 185463, 185025, 185028, 185271, 184471, 184004, 185246, 184347, 184351, 185512, 184595, 185289, 185466, 184944, 185571, 184103, 184105, 185281, 185533, 184356, 185251, 185923, 183930, 183931, 184212, 185192, 184377, 185531, 184354, 183924, 184400, 184364, 184504, 185268, 183177, 185279, 185275, 185031, 184369, 184473, 185259, 183949, 183427, 184350, 184689, 181271, 181569, 185272, 184462, 184368, 184358, 184355, 184399, 185161, 183483, 181556, 185241, 184095, 183942, 185919, 182585, 184313, 185157, 185162, 185164, 185239, 185280, 185273, 184343, 185245, 183926, 184360, 185465, 185238, 185276, 184475, 185261, 185159, 184362, 185290, 185464, 185240, 185477, 184366, 185539, 183419, 184470, 185260, 183421, 184346, 184744, 185288, 185243, 185237, 185460, 184100, 184104, 184096, 184376, 184472, 185254, 184344, 185235, 184093, 184357, 184340, 185258, 184146, 185930, 185244, 183925, 183423, 181557, 181270, 185120, 184373, 185537, 185924, 185248, 184359, 184361, 183465, 185269, 184148, 185461, 185236, 184724, 185249, 278347, 185467, 188132, 184102, 185194, 185274, 185278, 185154, 184341, 185264, 185256, 185252, 185602, 185935, 185158, 184745, 185283, 185242, 184396, 185572, 185573, 184371, 184367, 183422, 185163, 183484, 185267, 184395, 185921, 185555, 184099, 185024, 185532, 184474, 185253, 185250, 183943, 183950, 184348, 183428, 152614, 185922, 185023, 185277, 185301, 185262, 183944, 183984, 185931, 184631, 181280, 185462, 184867, 183393, 183293, 185536, 185266, 184398, 183927, 184906, 278575, 183291, 184094, 184375, 184374, 185153, 184003, 184345, 181555, 183292, 185027, 185282, 185263, 185255, 181281, 185929, 185247, 184339, 185160, 183425, 183429, 183290); +UPDATE `gameobject_template` SET `Data3`=0, `ContentTuningId`=41, `VerifiedBuild`=49890 WHERE `entry`=185195; -- Legion Obelisk +UPDATE `gameobject_template` SET `Data1`=0, `Data30`=21771, `ContentTuningId`=41, `VerifiedBuild`=49890 WHERE `entry`=182941; -- Grishnath Orb +UPDATE `gameobject_template` SET `ContentTuningId`=41, `VerifiedBuild`=49890 WHERE `entry` IN (185714, 185731, 185720, 185620, 185716, 185749, 185699, 185682, 185733, 185762, 185635, 185802, 185727, 185631, 185691, 185745, 185741, 185679, 185737, 185612, 185757, 185695, 185703, 185710, 185753, 185767, 185687, 185707); -- Simon Game Base Red Small +UPDATE `gameobject_template` SET `ContentTuningId`=41, `VerifiedBuild`=49890 WHERE `entry` IN (185806, 185833, 185837, 185653, 185813, 185672, 185849, 185803, 185790, 185656, 185644, 185668, 185775, 185664, 185769, 185787, 185811, 185829, 185852, 185841, 185615, 185624, 185783, 185623, 185825, 185636, 185648, 185821); -- Yellow Cluster +UPDATE `gameobject_template` SET `ContentTuningId`=41, `VerifiedBuild`=49890 WHERE `entry`=185906; -- Kronk's Book +UPDATE `gameobject_template` SET `ContentTuningId`=41, `VerifiedBuild`=49890 WHERE `entry` IN (185816, 185844, 185604, 185640, 185795, 185660, 185776); -- Large Blue Cluster +UPDATE `gameobject_template` SET `ContentTuningId`=41, `VerifiedBuild`=49890 WHERE `entry` IN (185746, 185628, 185632, 185700, 185758, 185750, 185709, 185696, 185704, 185799, 185765, 185754, 185610, 185683, 185761, 185618, 185742, 185713, 185728, 185717, 185688, 185734, 185738, 185684, 185694, 185724, 185721, 185676); -- Simon Game Base Green Smalll +UPDATE `gameobject_template` SET `ContentTuningId`=41, `VerifiedBuild`=49890 WHERE `entry`=185936; -- Rivendark's Egg +UPDATE `gameobject_template` SET `ContentTuningId`=41, `VerifiedBuild`=49890 WHERE `entry` IN (185845, 185606, 185794, 185662, 185642, 185817, 185778); -- Large Red Cluster +UPDATE `gameobject_template` SET `ContentTuningId`=41, `VerifiedBuild`=49890 WHERE `entry` IN (185625, 185665, 185780, 185791, 185836, 185609, 185807, 185796, 185808, 185828, 185824, 185647, 185812, 185840, 185637, 185669, 185784, 185617, 185659, 185770, 185832, 185649, 185673, 185848, 185652, 185772, 185853, 185820); -- Blue Cluster +UPDATE `gameobject_template` SET `Data3`=0, `ContentTuningId`=41, `VerifiedBuild`=49890 WHERE `entry`=185193; -- Legion Obelisk +UPDATE `gameobject_template` SET `ContentTuningId`=41, `VerifiedBuild`=49890 WHERE `entry`=185944; -- Apexis Monument +UPDATE `gameobject_template` SET `ContentTuningId`=41, `VerifiedBuild`=49890 WHERE `entry` IN (185605, 185777, 185793, 185846, 185818, 185661, 185641); -- Large Green Cluster +UPDATE `gameobject_template` SET `ContentTuningId`=41, `VerifiedBuild`=49890 WHERE `entry` IN (185819, 185792, 185663, 185607, 185779, 185643, 185847); -- Large Yellow Cluster +UPDATE `gameobject_template` SET `ContentTuningId`=41, `VerifiedBuild`=49890 WHERE `entry` IN (185963, 185962, 185964, 185959); -- Proton Accelerator Controller +UPDATE `gameobject_template` SET `ContentTuningId`=41, `VerifiedBuild`=49890 WHERE `entry`=185937; -- Furywing's Egg +UPDATE `gameobject_template` SET `Data3`=0, `ContentTuningId`=41, `VerifiedBuild`=49890 WHERE `entry`=185196; -- Legion Obelisk +UPDATE `gameobject_template` SET `ContentTuningId`=41, `VerifiedBuild`=49890 WHERE `entry`=185309; -- Altar of Goc +UPDATE `gameobject_template` SET `ContentTuningId`=41, `VerifiedBuild`=49890 WHERE `entry`=185296; -- Battered Cage +UPDATE `gameobject_template` SET `ContentTuningId`=41, `VerifiedBuild`=49890 WHERE `entry` IN (185124, 185148, 185147); -- Fertile Volcanic Soil +UPDATE `gameobject_template` SET `Data1`=0, `Data18`=676, `Data30`=39341, `ContentTuningId`=41, `VerifiedBuild`=49890 WHERE `entry`=207480; -- Silverbound Treasure Chest +UPDATE `gameobject_template` SET `ContentTuningId`=41, `VerifiedBuild`=49890 WHERE `entry`=184736; -- Thunderlord Clan Tablet +UPDATE `gameobject_template` SET `Data26`=1, `ContentTuningId`=41, `VerifiedBuild`=49890 WHERE `entry`=185214; -- Fermented Seed Beer Keg +UPDATE `gameobject_template` SET `ContentTuningId`=41, `VerifiedBuild`=49890 WHERE `entry`=185932; -- Obsidia's Egg +UPDATE `gameobject_template` SET `Data26`=1, `ContentTuningId`=41, `VerifiedBuild`=49890 WHERE `entry`=184969; -- The Fourth Prophecy +UPDATE `gameobject_template` SET `ContentTuningId`=41, `VerifiedBuild`=49890 WHERE `entry`=184840; -- Wyrmcult Egg +UPDATE `gameobject_template` SET `ContentTuningId`=41, `VerifiedBuild`=49890 WHERE `entry`=185945; -- Apexis Decharger +UPDATE `gameobject_template` SET `ContentTuningId`=41, `VerifiedBuild`=49890 WHERE `entry`=184825; -- Lashh'an Tome +UPDATE `gameobject_template` SET `ContentTuningId`=41, `VerifiedBuild`=49890 WHERE `entry`=185165; -- Legion Communicator +UPDATE `gameobject_template` SET `Data3`=0, `ContentTuningId`=41, `VerifiedBuild`=49890 WHERE `entry`=185198; -- Legion Obelisk +UPDATE `gameobject_template` SET `Data26`=1, `ContentTuningId`=41, `VerifiedBuild`=49890 WHERE `entry`=185213; -- Ripe Moonshine Keg +UPDATE `gameobject_template` SET `Data3`=0, `ContentTuningId`=41, `VerifiedBuild`=49890 WHERE `entry`=185197; -- Legion Obelisk +UPDATE `gameobject_template` SET `Data1`=0, `Data30`=22114, `ContentTuningId`=41, `VerifiedBuild`=49890 WHERE `entry`=185911; -- Apexis Shard Formation +UPDATE `gameobject_template` SET `Data1`=0, `Data2`=1, `Data30`=20831, `ContentTuningId`=41, `VerifiedBuild`=49890 WHERE `entry`=184727; -- Thunderlord Clan Arrow +UPDATE `gameobject_template` SET `Data20`=1, `Data26`=1, `ContentTuningId`=41, `VerifiedBuild`=49890 WHERE `entry`=185234; -- Gorgrom's Altar +UPDATE `gameobject_template` SET `ContentTuningId`=41, `VerifiedBuild`=49890 WHERE `entry` IN (184660, 185035); -- Wanted Poster +UPDATE `gameobject_template` SET `Data1`=0, `Data2`=1, `Data30`=21757, `ContentTuningId`=41, `VerifiedBuild`=49890 WHERE `entry`=185152; -- Grulloc's Sack +UPDATE `gameobject_template` SET `ContentTuningId`=41, `VerifiedBuild`=49890 WHERE `entry`=185894; -- Relic Decharger +UPDATE `gameobject_template` SET `Data26`=1, `ContentTuningId`=41, `VerifiedBuild`=49890 WHERE `entry`=185206; -- Green Spot Grog Keg +UPDATE `gameobject_template` SET `ContentTuningId`=41, `VerifiedBuild`=49890 WHERE `entry`=185890; -- Apexis Relic +UPDATE `gameobject_template` SET `Data26`=1, `ContentTuningId`=41, `VerifiedBuild`=49890 WHERE `entry`=184950; -- The First Prophecy +UPDATE `gameobject_template` SET `Data26`=1, `ContentTuningId`=41, `VerifiedBuild`=49890 WHERE `entry`=184967; -- The Second Prophecy +UPDATE `gameobject_template` SET `ContentTuningId`=41, `VerifiedBuild`=49890 WHERE `entry`=185938; -- Insidion's Egg +UPDATE `gameobject_template` SET `Data1`=0, `Data2`=1, `Data30`=20832, `ContentTuningId`=41, `VerifiedBuild`=49890 WHERE `entry`=184728; -- Thunderlord Clan Tablet +UPDATE `gameobject_template` SET `Data26`=1, `ContentTuningId`=41, `VerifiedBuild`=49890 WHERE `entry`=184968; -- The Third Prophecy +UPDATE `gameobject_template` SET `Data1`=0, `Data2`=1, `Data30`=20830, `ContentTuningId`=41, `VerifiedBuild`=49890 WHERE `entry`=184726; -- Thunderlord Clan Drum +UPDATE `gameobject_template` SET `ContentTuningId`=41, `VerifiedBuild`=49890 WHERE `entry`=184702; -- Cage +UPDATE `gameobject_template` SET `ContentTuningId`=41, `VerifiedBuild`=49890 WHERE `entry`=185861; -- Fel Cannonball Stack +UPDATE `gameobject_template` SET `ContentTuningId`=41, `VerifiedBuild`=49890 WHERE `entry`=185927; -- Fel Crystal Prism + +UPDATE `gameobject_template_addon` SET `WorldEffectID`=8830 WHERE `entry`=278574; -- Hero's Call Board +UPDATE `gameobject_template_addon` SET `faction`=1735 WHERE `entry`=188132; -- Mailbox +UPDATE `gameobject_template_addon` SET `faction`=14 WHERE `entry`=185922; -- Crystalforge controller +UPDATE `gameobject_template_addon` SET `flags`=262144 WHERE `entry`=185234; -- Gorgrom's Altar +UPDATE `gameobject_template_addon` SET `flags`=0 WHERE `entry`=183356; -- Theatric Lightning + +UPDATE `gameobject_questitem` SET `VerifiedBuild`=49890 WHERE (`Idx`=0 AND `GameObjectEntry` IN (184726,184728,184727,184689,185152,184744,182606)); |