diff options
| -rw-r--r-- | sql/updates/world/cata_classic/2024_11_21_00_world.sql | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/sql/updates/world/cata_classic/2024_11_21_00_world.sql b/sql/updates/world/cata_classic/2024_11_21_00_world.sql new file mode 100644 index 00000000000..3ca50a838b3 --- /dev/null +++ b/sql/updates/world/cata_classic/2024_11_21_00_world.sql @@ -0,0 +1,19 @@ +DELETE FROM `gameobject_template` WHERE `entry` IN (365169 /*Ghost Gate Invisible (Scale 1x)*/, 452390 /*Instance Portal (Raid 4 Difficulties)*/); +INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `size`, `Data0`, `Data1`, `Data2`, `Data3`, `Data4`, `Data5`, `Data6`, `Data7`, `Data8`, `Data9`, `Data10`, `Data11`, `Data12`, `Data13`, `Data14`, `Data15`, `Data16`, `Data17`, `Data18`, `Data19`, `Data20`, `Data21`, `Data22`, `Data23`, `Data24`, `Data25`, `Data26`, `Data27`, `Data28`, `Data29`, `Data30`, `Data31`, `Data32`, `Data33`, `Data34`, `ContentTuningId`, `VerifiedBuild`) VALUES +(365169, 5, 66993, 'Ghost Gate Invisible (Scale 1x)', '', '', '', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 57359), -- Ghost Gate Invisible (Scale 1x) +(452390, 31, 74868, 'Instance Portal (Raid 4 Difficulties)', '', '', '', 5, 2, 216, 217, 216, 217, 83033, 0, 6, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 57359); -- Instance Portal (Raid 4 Difficulties) + +UPDATE `gameobject_template` SET `VerifiedBuild`=57564 WHERE `entry` IN (205164, 201517, 206111, 208807, 190536, 206110, 209692, 209039, 207416, 179965, 203751, 22538, 22537, 22536, 22535, 3800, 3799, 214538, 186463, 186432, 185321, 177928, 176231, 203762, 197085, 197084, 197083, 197082, 197081, 197080, 197079, 197014, 197013, 197009, 197095, 197094, 197017, 105175, 105174, 75296, 103664, 175756, 176681, 176665, 176689, 176673, 176669, 176693, 21581, 175753, 175761, 175749, 175739, 176682, 175738, 176678, 176686, 176666, 20726, 176690, 176674, 176670, 175730, 19284, 21582, 175758, 175734, 175754, 176683, 176675, 176667, 176679, 176691, 176684, 176687, 176671, 19283, 175727, 176680, 176676, 176685, 176668, 176692, 176688, 176677, 176672, 175781, 175779, 175774, 175773, 175780, 175775, 97802, 175777, 175776, 175772, 175771, 97803, 97801, 175778, 101855, 103820, 75300, 2042, 3703, 3704, 165632, 165630, 165628, 165633, 165631, 165629, 165627, 165626, 165625, 165624, 165623, 165622, 97701, 104589, 2041, 2046, 176495, 181689, 164871, 1628, 1624, 75299, 104591, 104600, 97700, 101854, 176594, 165619, 165618, 165620, 165621, 101852, 101853, 101850, 101851, 142145, 184414, 195140, 195139, 184290, 184415, 184289, 203226, 188215, 181310, 177203, 177047, 176579, 207208, 184164, 177048, 176580, 177049, 176901, 176633, 176577, 203224, 203225, 176694, 176578, 203289, 197007, 197055, 197047, 197071, 197063, 197076, 197068, 197060, 197052, 197044, 197092, 197065, 197057, 197049, 197089, 197073, 195141, 197070, 197062, 197054, 197046, 197051, 197091, 197075, 197067, 197059, 197072, 197064, 197056, 197048, 197061, 197053, 197093, 197045, 197069, 197090, 197074, 197066, 197058, 197050, 176310, 191605, 206500, 202273, 202271, 202267, 204988, 206294, 204281, 205105, 205104, 207561, 206754, 207555, 207554, 207553, 207552, 207564, 207563, 207557, 207560, 207559, 207558, 207556, 207562, 207463, 202738, 202741, 206580, 206664, 207724, 206906, 206570, 202740, 206651, 206652, 206644, 202780, 202749, 202747, 164767, 206586, 206843, 207703, 208227, 206844, 206576, 204588, 207704, 204589, 206885, 206845, 206598, 204590, 207716, 207694, 207693, 207692, 207691, 206594, 201453, 201452, 201451, 201450, 201449, 201448, 201447, 201446, 201445, 201521, 201504, 201498, 201496, 201495, 201494, 201493, 201492, 201491, 201490, 201489, 201488, 201422, 1684, 201497, 201512, 201523, 201511, 201522, 201509, 201508, 201506, 201503, 201501, 201500, 201514, 201513, 191164, 188537, 190174, 191729, 181030, 192788, 188527, 188526, 188528, 191016, 381416, 164839, 186705, 186696, 186697, 186695, 186703, 186693, 186701, 186706, 186698, 186690, 186610, 186756, 189978, 186692, 186612, 186700, 186689, 186609, 381414, 186694, 186702, 186691, 186707, 186699, 186611, 186608, 186704, 193059, 186688, 197124, 193963, 197137, 183384, 202007, 202022, 202017, 202016, 202015, 202012, 202009, 206623, 202008, 202031, 202029, 202034, 202033, 202032, 202030, 202028, 202027, 202026, 202025, 202024, 202023, 202010, 202004, 202036, 202035, 202021, 202020, 202019, 202018, 202014, 202013, 202006, 201981, 202005, 201989, 201980, 202003, 201997, 201996, 201991, 201987, 201995, 201994, 201993, 201992, 201983, 202048, 202046, 203930, 203929, 202064, 202063, 202062, 202061, 202060, 202059, 202050, 202049, 203947, 203945, 203944, 203943, 203942, 203941, 203940, 203938, 203937, 203936, 203934, 203933, 203932, 203928, 203946, 203939, 203935, 203931, 203927, 203926, 203925, 203924, 203955, 203953, 203954, 203950, 203951, 203949, 203948, 203952, 203988, 203987, 201619, 455401, 195467, 208438, 208437, 204284, 195468, 202365, 202364, 202363, 205144, 197196, 202011, 140911, 209297, 197096, 197020, 197097, 197028, 197027, 197026, 197025, 197031, 197030, 197029, 197018, 193981, 207661, 197032, 197024, 197023, 197012, 197011, 175729, 205553, 197099, 197022, 197021, 197190, 197187, 197126, 197098, 197193, 197192, 197191, 197189, 197188, 197136, 197138, 197125, 197123, 197184, 197182, 197176, 197140, 197139, 197122, 206602, 197183, 197181, 197178, 197177, 197134, 202260, 202259, 202258, 202257, 202256, 202253, 197185, 197180, 197179, 197121, 197131, 197133, 197132, 203978, 29784, 203801, 197186, 190942, 209114, 197135, 197119, 197116, 209124, 197173, 197172, 197148, 197118, 197117, 197175, 197174, 197150, 197149, 197147, 197146, 205106, 197120, 205107, 209116, 197142, 179558, 197145, 197143, 197144, 197141, 170073, 142076, 22776, 22775, 1560, 4090, 177498, 209544, 177495, 209548, 22783, 4087, 177503, 177500, 210177, 123244, 22804, 22772, 22812, 22777, 4089, 177497, 22774, 177502, 209635, 177494, 22806, 142075, 180045, 22803, 177499, 22811, 180034, 177496, 4088, 177504, 177501, 22773, 209538, 22813, 209634, 180043, 35591, 210176, 210175, 180726, 180735, 180725, 180733, 180729, 210107, 209275, 209282, 209283, 209274, 209284, 209288, 209287, 209273, 203800, 202002, 202045, 202052, 207722, 202051, 202047, 202044, 202055, 202058, 202056, 201985, 207723, 207719, 207721, 201998, 207720, 207718, 202057, 202054, 202053, 202043, 202001, 202000, 201999, 201986, 201982, 209753, 209860, 209859, 209858, 209819, 209818, 209820, 209332, 209342, 180524, 209286, 209320, 209295, 209294, 209293, 197088, 197086, 197008, 195427, 192210, 192209, 192199, 195532, 192208, 192207, 192202, 192851, 191466, 193205, 192850, 192844, 192224, 192223, 191943, 193173, 193086, 192222, 192221, 192218, 192217, 192216, 192215, 192214, 192213, 192212, 192211, 192201, 191465, 192205, 193930, 192068, 191956, 192206, 192203, 192200, 208316, 193933, 192204, 192197, 192196, 191953, 191732, 193932, 191733, 192093, 187299, 194147, 191990, 193174, 193175, 191916, 191915, 201933, 201297, 192841, 201931, 201295, 193931, 193627, 193626, 193625, 193624, 193578, 193189, 192893, 192840, 191910, 191735, 191444, 190960, 192838, 201298, 192839, 191994, 201932, 201296, 191995, 191909, 191734, 191911, 191993, 191917, 200297, 191992, 200296, 191998, 191997, 193921, 193190, 191919, 191914, 192092, 193922, 191913, 191912, 193927, 193924, 193936, 193935, 193934, 193925, 193923, 192088, 191951, 191935, 191934, 191932, 191931, 191930, 191929, 191928, 191927, 191926, 191925, 191924, 191918, 191674, 193929, 191933, 191988, 191989, 191986, 191686, 192198, 191991, 194115, 191999, 193951, 193950, 193949, 192091, 192089, 192067, 191987, 191952, 191942, 191688, 191675, 191445, 191898, 191468, 191897, 179976, 192083, 191676, 191895, 191894, 191903, 191467, 191683, 191896, 192842, 191893, 191891, 191904, 191892, 193422, 193928, 193926, 193916, 193423, 192090, 191687, 191478, 191477, 191476, 191475, 191474, 191473, 193919, 191470, 191984, 191480, 209115, 202616, 193920, 193918, 193917, 191983, 191974, 191954, 191482, 191481, 191479, 191471, 191469, 192818, 193610, 193987, 193915, 192087, 192010, 191981, 191980, 191975, 191678, 191677, 191472, 191464, 191463, 191462, 192828, 192103, 191461, 193084, 193083, 193082, 193081, 193080, 192836, 192109, 192102, 192086, 193085, 192097, 192084, 192112, 192096, 191941, 191679, 192117, 193909, 192113, 192098, 192085, 191957, 191950, 191681, 191680, 194943, 192099, 194945, 191959, 191958, 192114, 194942, 194938, 194939, 191965, 194944, 192116, 191964, 191960, 194946, 194941, 194940, 194937, 193903, 193902, 193901, 193900, 193899, 193898, 193897, 193781, 192892, 191966, 175735, 193896, 193071, 192824, 192220, 192219, 191940, 191939, 192827, 192059, 194394, 194393, 188230, 202443, 191229, 193019, 193202, 193214, 191230, 190353, 188539, 190160, 189992, 192773, 177278, 214516, 190019, 188534, 188344, 188342, 381415, 190236, 190173, 188457, 188476, 188475, 188491, 188419, 188474, 188446, 188445, 187085, 191142, 191228, 187886, 187314, 187388, 187387, 187315, 194026, 194025, 188164, 192046, 187902, 187240, 187449, 187448, 187450, 187447, 187446, 192051, 187658, 187106, 188657, 188656, 188655, 188653, 187703, 187852, 188426, 189973, 188007, 188008, 192052, 188131, 188015, 187676, 188160, 181275, 180403, 358410, 181556, 214503, 181278, 187880, 188016, 188018, 188104, 188085, 188084, 188017, 188120, 191370, 182072, 182071, 152614, 190548, 190547, 190546, 188163, 188112, 187568, 194954, 194953, 190194, 190193, 187560, 188692, 191699, 191698, 191697, 191304, 190352, 187884, 187773, 187565, 188521, 186238, 187258, 187259, 187256, 190287, 187980, 187851, 194677, 187558, 186838, 186837, 190556, 187889, 187316, 186844, 186843, 186842, 186841, 186840, 186839, 186836, 186835, 205490, 201460, 201459, 201458, 201457, 201456, 201455, 201454, 92011, 202274, 202272, 202270, 203976, 204987, 193585, 193584, 193583, 180047, 201463, 201462, 201461, 201485, 201483, 201482, 201481, 201484, 201480, 201479, 201478, 201477, 201476, 201474, 201475, 201421, 201417, 206560, 201420, 201419, 201418, 201416, 201415, 209041, 209101, 209040, 209054, 209053, 209052, 209051, 209047, 209046, 209045, 209044, 209043, 202758, 209050, 209049, 209048, 209042, 179882, 1731, 1619, 1617, 203732, 203731, 202578, 151972, 151971, 151970, 151969, 151968, 151967, 151966, 151965, 151964, 151963, 151962, 151961, 151960, 151959, 151958, 151957, 151956, 151955, 151954, 151953, 142179, 207535, 175732, 164909, 207513, 180564, 180438, 180554, 180559, 180549, 180439, 180529, 180441, 180440, 180539, 180534, 180503, 180442, 180544, 180502, 181634, 181633, 181617, 180788, 180633, 180455, 142142, 176583, 2047, 180914, 180451, 180448, 180915, 180913, 180904, 180899, 180898, 175404, 181598, 176584, 207565, 181619, 207566, 181618, 141931, 153126, 207487, 50988, 50989, 204983, 204984, 204982, 202107, 204990, 143979, 142073, 142143, 178224, 179469, 177188, 177189, 177192, 176228, 176227, 176229, 22246, 204793, 204792, 195095, 177366, 1734, 177400, 177399, 177397, 176752, 50805, 176751, 195687, 195674, 2043, 177444, 204766, 204769, 3897, 204768, 204767, 204763, 174847, 204764, 204759, 195601, 3911, 3909, 3906, 3905, 3904, 3902, 3893, 3892, 204761, 204760, 195535, 3908, 3901, 3900, 3898, 3894, 3891, 3888, 204757, 204756, 204755, 204752, 207523, 204754, 204753, 204751, 204750, 1735, 177706, 195450, 195438, 195497, 195600, 195517, 1733, 207522, 1623, 203431, 203186, 105173, 11899, 11898, 207709, 195012, 194651, 194311, 194203, 191369, 194310, 206854, 1732, 195021, 175207, 17182, 194211, 194113, 207521, 103687, 194112, 180655, 180683, 180682, 2045, 17183, 204774, 204132, 204131, 194107, 194105, 194145, 13359, 1620, 194089, 194088, 194090, 1621, 180663, 180684, 324, 176588, 176586, 208192, 202787, 202846, 208449, 209096, 208454, 208444, 202776, 209080, 204119, 203383, 207327, 204878, 204118, 203169, 209081, 202754, 176296, 207411, 445089, 204979, 191083, 206206, 207218, 207410, 207219, 206207, 207725, 202309, 207454, 445419, 207674, 206506, 202314, 202306, 207802, 207663, 207375, 202311, 207669, 207349, 202308, 207673, 207665, 207377, 202313, 207726, 207662, 207374, 202310, 204972, 202307, 207452, 207672, 207449, 207664, 207376, 202312, 207445, 207547, 207973, 164639, 183957, 203199, 205542, 202742, 207406, 208302, 207998, 204339, 208301, 207997, 204341, 204338, 445518, 204340, 207209, 201535, 201534, 201528, 201527, 201526, 201525, 201524, 201541, 201540, 201536, 201533, 201544, 201543, 201542, 201539, 201538, 201537, 201532, 201531, 201530, 201529, 201510, 201507, 201505, 201499, 200317, 200316, 200315, 200314, 200313, 200311, 200310, 200309, 200307, 124374, 205190, 200312, 200308, 200306, 200320, 200323, 200322, 200321, 200319, 200318, 200331, 200330, 200329, 200328, 200327, 200326, 201520, 201502, 201516, 201560, 201559, 201558, 201557, 201556, 201555, 201519, 201518, 201515, 201554, 201552, 201551, 201553, 201550, 201549, 201548, 201547, 201546, 201545, 179706, 187113, 187111, 187335, 187112, 187431, 187428, 187363, 187116, 187080, 187078, 187120, 188081, 187333, 181281, 187357, 187356, 188172, 187675, 207528, 182145, 182054, 181276, 214500, 183385, 183386, 181280, 180035, 184801, 184795, 184797, 184796, 185130, 182973, 182972, 182971, 182970, 182969, 182968, 182967, 182965, 182963, 182961, 182966, 182964, 182962, 182960, 214507, 183441, 182925, 182924, 182887, 182886, 182885, 182884, 182883, 182882, 182881, 182900, 183035, 183034, 183033, 183032, 183030, 183029, 183028, 183027, 183026, 183025, 183010, 183008, 183007, 183006, 182929, 182928, 182926, 182922, 182903, 182901, 182898, 182889, 182888, 183031, 183024, 183023, 183022, 183009, 182927, 182923, 182904, 182902, 182899, 182890, 182875, 182874, 182867, 183005, 182897, 182896, 182895, 182894, 182893, 182892, 182891, 182873, 182872, 184946, 182871, 184652, 182876, 182869, 182868, 182866, 182865, 182864, 182863, 182862, 182870, 182878, 182877, 184286, 184285, 182994, 183402, 183401, 184948, 184872, 184859, 184871, 184860, 184835, 184834, 184833, 181569, 184246, 185123, 149046, 149045, 184827, 184984, 185952, 184983, 185913, 184982, 185549, 185219, 185218, 185217, 185216, 184807, 184800, 184799, 182585, 182584, 182591, 183414, 183413, 183364, 186030, 183431, 186029, 186028, 185019, 185000, 186143, 184136, 184135, 187056, 185980, 183318, 187058, 187057, 186145, 185987, 185976, 185975, 185998, 185997, 185994, 184137, 188126, 186022, 185996, 185995, 186097, 186096, 186099, 185325, 183848, 186098, 183849, 194466, 186089, 186100, 186121, 186123, 186106, 186107, 186122, 186120, 186095, 186094, 186093, 186182, 186181, 186179, 184401, 186180, 184396, 184395, 183045, 182122, 184644, 181271, 182599, 182265, 182504, 182484, 182492, 182494, 182491, 182487, 182493, 182489, 182486, 182490, 182488, 182499, 182497, 182498, 182503, 182500, 182496, 182495, 182502, 182521, 182501, 182959, 184316, 182350, 182298, 182297, 183099, 182203, 182210, 184314, 182307, 182303, 182300, 183289, 183287, 182349, 183171, 183286, 183288, 183170, 186117, 186116, 186113, 186112, 186110, 186111, 186144, 194468, 194467, 185988, 185979, 185993, 185992, 185991, 185990, 185969, 185968, 186019, 187345, 185989, 185986, 185972, 185971, 185967, 185985, 188127, 186020, 185970, 184555, 183325, 183323, 185984, 185983, 185978, 185977, 186018, 186017, 184554, 183435, 186016, 186015, 184559, 184558, 186014, 186009, 183355, 195533, 186025, 186013, 186012, 183433, 184139, 183203, 183202, 183169, 186115, 186114, 186023, 186011, 186010, 185511, 185510, 185509, 185508, 185507, 185506, 185505, 185459, 186026, 183294, 184477, 183104, 182601, 182581, 185202, 185204, 185203, 183411, 185205, 183412, 182541, 181385, 181664, 183502, 183501, 183503, 147285, 147283, 147282, 146441, 175002, 175003, 147284, 185302, 181475, 180575, 22914, 22902, 149051, 38148, 22929, 22928, 22913, 22912, 22911, 22894, 175010, 175020, 175014, 175019, 181380, 175028, 175027, 175025, 175021, 175017, 175013, 175007, 175006, 148760, 148757, 148756, 148747, 148746, 148735, 175024, 175018, 175016, 175015, 175009, 175008, 175030, 175029, 175026, 175023, 175022, 175012, 175011, 175005, 175004, 175001, 152328, 148763, 148759, 148753, 148750, 152325, 181369, 152332, 152331, 152330, 152327, 152326, 37028, 37026, 152329, 37038, 37037, 37036, 37035, 37034, 37033, 37032, 37031, 37030, 37029, 37027, 37025, 3772, 183515, 182173, 181555, 183396, 183397, 183394, 182797, 182799, 183395, 182525, 182174, 184852, 183514, 184657, 183996, 182175, 181372, 181270, 184912, 184565, 184564, 184563, 183333, 183791, 197087, 197078, 197077, 182592, 185429, 185428, 185427, 185425, 185421, 185412, 185411, 185410, 185409, 185406, 185403, 185402, 185401, 185396, 185395, 185420, 185408, 185432, 185431, 185430, 185426, 185424, 185423, 185422, 185419, 185418, 185417, 185415, 185414, 185413, 185407, 185405, 185404, 185400, 185399, 185394, 185416, 185398, 185397, 182589, 112309, 112308, 112305, 112322, 112321, 112317, 112316, 112312, 112311, 112310, 112303, 112302, 112301, 184304, 112319, 174995, 174998, 174997, 174996, 174994, 36977, 22926, 22922, 22921, 22674, 22673, 22672, 22671, 22670, 22927, 22924, 22923, 22925, 22910, 22685, 180570, 22684, 184305, 22904, 22884, 22886, 22909, 22883, 22919, 184332, 38147, 22920, 22918, 22917, 22916, 22915, 22908, 22887, 22885, 22882, 3804, 3803, 174874, 160849, 160848, 160847, 160846, 149423, 22657, 22646, 22644, 22642, 22641, 22640, 3819, 3818, 3817, 3816, 3815, 174881, 174873, 160851, 160850, 3802, 3801, 23014, 23015, 23013, 147076, 184393, 147075, 147077, 214502, 187216, 187224, 187228, 187222, 187218, 187221, 187227, 187225, 187229, 187223, 187220, 187219, 187226, 187215, 187214, 187207, 187206, 187578, 188173, 188523, 188421, 188119, 187765, 188165, 188166, 188064, 187770, 188065, 187990, 187896, 187766, 188524, 188075, 188118, 187764, 187979, 188171, 214501, 187115, 187114, 185999, 185170, 185982, 185981, 185974, 185973, 186002, 186000, 186131, 186128, 186127, 184140, 186730, 186134, 186041, 186040, 186039, 186133, 186038, 186037, 186036, 187073, 183349, 181582, 183438, 181663, 183437, 181638, 184501, 184500, 181581, 183839, 184499, 184497, 184496, 184011, 184498, 183837, 184438, 183838, 183831, 183517, 184020, 184019, 184455, 184439, 184437, 184436, 183836, 183835, 183834, 183833, 183832, 211498, 184012, 183913, 183914, 183915, 183916, 184025, 183917, 183918, 183498, 183497, 184024, 183920, 183919, 182937, 184023, 182798, 182938, 182936, 182789, 182090, 191946, 193172, 192845, 191889, 191684, 191890, 191888, 191887, 193087, 193176, 201687, 201686, 201685, 201680, 201679, 201676, 170351, 170350, 170347, 22638, 22606, 22605, 22604, 22603, 22602, 170349, 170348, 1618, 180050, 180046, 180048, 209571, 179968, 179967, 179970, 179977, 179969, 179972, 180007, 180026, 179964, 185168, 2561, 181738, 181735, 181737, 181734, 181736, 209348, 176498, 183827, 183826, 185191, 183828, 183877, 183825, 183824, 183823, 183830, 186731, 186129, 183432, 186024, 186027, 180339, 181877, 181982, 181820, 181816, 181812, 181924, 181821, 181817, 181813, 181925, 181921, 181822, 181818, 181814, 181926, 181922, 181766, 181713, 181819, 181815, 181811, 181927, 181923, 181823, 181277, 183789, 182524, 186032, 186031, 186033, 186034, 186136, 186001, 186003, 186004, 186006, 186005, 187370, 186126, 186007, 186147, 186125, 186148, 186008, 186124, 186130, 184557, 186135, 186146, 183418, 207478, 183044, 183043, 183177, 185497, 181637, 181580, 184032, 183340, 183338, 183846, 183845, 183342, 183105, 184015, 183995, 183994, 183991, 183993, 183992, 183504, 183500, 181066, 181064, 181063, 181065, 22623, 22622, 192095, 191947, 193914, 192094, 193913, 193911, 193910, 193912, 191902, 191901, 191900, 191899, 192888, 207257, 207256, 207255, 207254, 202451, 202421, 375, 175544, 202422, 208833, 175566, 104593, 206864, 206863, 206862, 206861, 175726, 191492, 191493, 191486, 202563, 191491, 209862, 191497, 191496, 191494, 191490, 191489, 191488, 191487, 191495, 202900, 202899, 202901, 113574, 208828, 36102, 113753, 184503, 77813, 58619, 58617, 52176, 113754, 98343, 98349, 58616, 208816, 58620, 58618, 207408, 445433, 177884, 58606, 33998, 36080, 170354, 33999, 153695, 98350, 98347, 36126, 36077, 36072, 36070, 34013, 58615, 175725, 113570, 207324, 204334, 58599, 58597, 98348, 3705, 204331, 170355, 36098, 113575, 98354, 36398, 36397, 36094, 36079, 34012, 175731, 103600, 36127, 58614, 113571, 113568, 36078, 58609, 52175, 40303, 204329, 58624, 58622, 36073, 204330, 113756, 113755, 58623, 58598, 36113, 190704, 177064, 177044, 58625, 58608, 58607, 204333, 136101, 58629, 58621, 36096, 113577, 98351, 36118, 36105, 36086, 36082, 208839, 113569, 36092, 36085, 180666, 58627, 58626, 3662, 37097, 58612, 58611, 208876, 208874, 195142, 207472, 102985, 192835, 23018, 23017, 23016, 174626, 205423, 177789, 2040, 176264, 205559, 185563, 205560, 177464, 175458, 175457, 175535, 176631, 175474, 175537, 175534, 175536, 181085, 153469, 175825, 175447, 175445, 175455, 175454, 175437, 175436, 175435, 175466, 175478, 176249, 176352, 176346, 176327, 176350, 176351, 176309, 176308, 176307, 176304, 176224, 153464, 175380, 175450, 175358, 175373, 175467, 175462, 175356, 175376, 175824, 175439, 175967, 176194, 175481, 175433, 175472, 175354, 175479, 175374, 175444, 175377, 175471, 175355, 175352, 175968, 175359, 175449, 175442, 175381, 175969, 175463, 175443, 175461, 175372, 175470, 175441, 175440, 175375, 175796, 176424, 175357, 175368, 175350, 175477, 175351, 175379, 175353, 175405, 175438, 175469, 175434, 194919, 194923, 194917, 175369, 194918, 194916, 194934, 175370, 175432, 201644, 201642, 201643, 180665, 201645, 2657, 201673, 201674, 201646, 201656, 201657, 201684, 201658, 201683, 201647, 201681, 175752, 201694, 201659, 201691, 201693, 201648, 201692, 201678, 21583, 201677, 175746, 201641, 201649, 201843, 201688, 201669, 201670, 201665, 201671, 201664, 201690, 201689, 201682, 201675, 201672, 201668, 201667, 201663, 201655, 201654, 201653, 201652, 201651, 201650, 175750, 175745, 201822, 201666, 201662, 201661, 201660); +UPDATE `gameobject_template` SET `Data0`=60, `VerifiedBuild`=57564 WHERE `entry`=185322; -- Meeting Stone +UPDATE `gameobject_template` SET `name`='Doodad_GeneralChairLoEnd05', `VerifiedBuild`=57564 WHERE `entry`=210112; -- Chair +UPDATE `gameobject_template` SET `name`='Doodad_GeneralChairLoEnd04', `VerifiedBuild`=57564 WHERE `entry`=210111; -- Chair +UPDATE `gameobject_template` SET `name`='Doodad_GeneralChairLoEnd03', `VerifiedBuild`=57564 WHERE `entry`=210110; -- Chair +UPDATE `gameobject_template` SET `name`='Doodad_GeneralChairLoEnd02', `VerifiedBuild`=57564 WHERE `entry`=210109; -- Chair +UPDATE `gameobject_template` SET `name`='Doodad_GeneralChairLoEnd01', `VerifiedBuild`=57564 WHERE `entry`=210108; -- Chair +UPDATE `gameobject_template` SET `Data0`=28, `VerifiedBuild`=57564 WHERE `entry`=178844; -- Meeting Stone +UPDATE `gameobject_template` SET `VerifiedBuild`=57359 WHERE `entry` IN (445427, 207409, 205365, 205564, 445428, 207596, 207365, 445433, 207408, 207307, 445434, 207335, 207334, 206683, 206293, 207454, 207452, 207449, 445419, 207669, 207445, 207349, 204972, 207725, 207674, 207673, 207665, 207662, 207377, 202313, 202309, 207374, 206506, 202314, 202310, 202306, 207802, 207663, 207375, 202307, 202311, 207672, 207664, 207726, 207376, 202312, 202308, 207547, 205562, 445420, 202738, 202752, 202779, 206390, 208241, 208238, 207280, 206691, 207130, 208240, 205266, 207698, 207151, 206690, 207338, 205540, 208239, 205539, 207166, 205106, 205107, 197120, 459352, 207412, 126342, 126345, 126341, 126340, 126339, 126338, 126335, 126314, 126313, 126312, 202832, 126337, 459353, 179585, 179879, 179584, 452217, 161536, 149046, 149045, 206853, 167291, 176584, 142142, 202831, 2040, 207303, 207328, 206987, 201665, 201664, 201663, 201668, 201667, 201661, 201660, 175753, 175745, 201822, 201666, 201662, 175727, 175738, 175752, 201642, 175730, 201644, 201649, 201648, 201647, 201646, 201645, 201643, 201641, 180665, 175735, 21582, 21581, 2657, 201689, 201684, 201683, 201682, 201681, 201675, 201674, 201672, 201655, 201654, 201653, 201652, 21583, 201694, 201693, 201692, 201691, 201690, 201688, 201687, 201685, 201680, 201679, 201678, 201677, 201676, 201673, 201659, 201657, 201656, 201651, 201650, 201686, 201658, 208260, 208259, 204381, 444993, 207407, 207343, 208261, 208257, 208256, 205565, 205273, 204407, 205127, 205131, 204959, 205115, 205161, 205129, 205359, 205133, 205128, 207593, 205122, 445078, 205120, 205119, 205121, 205111, 204018, 205112, 205272, 204576, 205116, 205113, 205125, 204837, 205151, 205126, 207597, 205130, 205110, 205102, 205152, 205146, 197190, 197189, 197187, 197139, 197175, 197174, 197147, 197193, 197192, 197191, 197188, 197117, 197116, 197138, 197122, 197121, 197150, 197148, 197149, 197146, 197134, 203978, 197135, 29784, 202259, 202257, 202253, 197123, 202260, 202258, 202256, 197140, 197119, 197186, 197185, 197184, 197183, 197182, 197181, 197180, 197179, 197178, 197177, 197176, 197125, 202742, 445518, 204340, 208301, 207997, 204341, 208302, 207998, 204338, 204339, 207209, 204962, 445556, 207871, 203692, 203622, 203623, 203616, 207870, 203691, 203693, 207872, 207869, 203456, 203454, 207656, 202896, 202749, 207657, 202748, 202736, 202759, 203395, 203397, 203401, 202916, 203372, 202788, 203985, 203305, 203137, 202897, 203390, 202766, 203400, 204851, 203211, 204848, 203388, 203398, 203402, 203213, 203399, 203301, 204850, 203391, 203386, 203210, 203418, 202871, 203218, 203212, 202887, 203735, 207695, 207694, 207693, 207692, 207691, 206594, 205105, 205104, 191605, 206294, 204988, 202271, 204987, 202274, 202272, 202270, 201485, 201481, 201463, 201462, 201461, 201484, 201483, 201482, 201480, 201479, 201478, 201477, 201476, 201475, 201474, 193585, 193584, 193583, 180047, 92011, 203976, 201453, 201452, 201451, 201448, 201447, 201446, 201445, 201460, 201459, 201458, 201457, 201454, 201450, 201449, 206560, 201420, 201419, 201418, 201417, 201416, 201415, 201456, 201455, 201421, 209051, 1684, 209101, 209053, 209052, 209048, 209047, 209046, 209045, 209044, 202758, 209042, 209040, 209054, 209050, 209049, 209043, 209041, 207718, 202009, 202007, 201986, 201985, 206623, 202036, 202035, 202034, 202033, 202032, 202031, 202030, 202029, 202022, 202021, 202020, 202019, 202018, 202017, 202016, 202015, 202014, 202013, 202012, 202008, 201981, 201980, 207723, 207722, 207721, 202028, 202027, 202026, 202025, 202024, 202023, 202001, 202010, 202006, 202004, 202003, 202000, 201999, 201998, 201997, 201996, 201995, 201994, 201993, 201992, 201991, 202011, 202005, 202002, 201987, 201983, 140911, 209297, 201989, 197126, 197136, 205553, 207661, 197099, 197098, 197097, 197022, 197021, 197018, 197088, 197086, 197031, 197030, 197029, 197028, 197027, 197026, 197025, 197024, 197023, 175758, 175729, 197020, 197011, 197032, 197012, 197008, 197076, 197060, 197044, 197089, 197073, 197057, 197070, 197054, 197067, 197051, 197064, 197048, 197093, 197061, 197045, 197090, 197074, 197058, 197007, 197071, 197055, 197068, 197052, 197065, 197049, 197062, 197046, 197091, 197075, 197059, 197072, 197056, 197069, 197053, 197066, 197050, 197063, 197047, 197092, 197009, 176310, 197083, 105174, 197080, 197013, 197084, 105175, 197081, 197017, 197094, 197014, 197085, 197082, 197095, 197079, 195532, 195427, 193205, 191470, 193926, 191892, 191894, 193423, 193928, 191890, 191946, 191891, 192845, 191889, 191684, 193172, 193930, 193422, 192851, 192850, 192844, 191943, 191904, 191903, 191888, 191887, 191466, 192828, 191990, 191733, 191469, 191468, 191467, 191465, 191461, 191983, 191999, 191951, 191935, 191919, 193923, 192211, 194147, 208316, 194115, 191932, 191916, 191676, 191980, 192092, 192208, 193920, 193936, 192224, 191993, 191929, 191913, 191481, 192089, 193933, 193949, 192221, 200297, 192205, 193917, 191686, 191926, 193626, 191910, 191734, 191974, 193578, 191478, 191462, 191942, 192842, 192218, 192202, 191987, 191475, 192067, 192839, 193927, 193175, 192215, 192199, 191952, 191984, 201296, 193924, 192212, 192196, 191229, 190960, 192093, 191997, 191933, 191917, 191981, 191677, 201933, 193921, 192209, 192893, 191994, 193950, 191930, 191914, 192090, 193086, 191482, 192010, 191674, 192222, 192206, 193918, 193934, 193214, 193610, 192087, 191975, 191687, 193019, 191479, 191991, 191927, 191911, 191735, 191463, 193931, 193627, 192203, 193915, 191732, 193624, 191444, 191924, 191476, 192068, 191988, 191956, 192840, 192200, 202616, 193176, 192216, 200296, 193189, 191953, 191473, 192197, 193925, 193173, 192213, 201297, 191998, 191934, 191918, 191678, 191230, 202443, 193922, 192210, 201931, 193202, 201298, 192091, 179976, 191995, 193951, 191931, 191915, 191675, 193087, 192223, 192207, 193919, 193935, 192827, 187299, 201295, 191992, 201932, 193987, 191688, 192088, 191928, 191912, 191464, 191480, 193932, 192204, 193916, 192824, 193625, 191989, 191445, 191925, 192841, 191909, 191477, 193929, 192217, 192201, 191986, 191954, 191474, 193190, 192838, 192198, 193174, 192214, 192818, 182011, 205476, 91138, 36738, 205479, 205477, 445441, 18972, 18934, 35598, 35594, 18971, 18935, 18936, 18895, 18899, 35596, 35595, 101811, 35593, 101812, 18900, 18973, 35597, 18901, 205039, 445442, 205044, 178845, 1619, 170046, 22531, 170040, 3797, 170045, 22530, 207485, 205534, 170044, 170043, 170042, 170041, 170039, 170038, 170037, 170036, 170035, 112012, 22600, 22595, 22589, 22534, 22533, 3798, 103815, 22599, 22598, 22594, 22593, 22592, 22591, 22590, 205165, 205143, 205541, 205350, 206956, 22567, 22566, 22565, 22564, 22563, 175933, 22712, 22710, 22709, 22707, 1897, 1767, 207089, 22711, 22708, 207090, 180682, 1733, 1723, 207279, 206944, 206950, 2043, 203450, 1623, 180684, 2702, 175383, 2652, 1874, 2041, 202978, 202977, 202976, 445089, 207411, 205869, 205870, 205866, 205488, 206312, 206384, 204853, 205871, 205867, 206313, 206314, 205868, 209263, 206018, 206017, 445095, 205489, 205487, 205486, 203179, 203173, 1624, 203182, 1620, 203184, 203188, 176231, 22223, 175689, 175687, 175688, 171548, 208860, 177222, 175761, 175750, 175746, 175742, 175739, 175736, 175734, 175726, 175725, 175686, 171561, 171560, 175685, 175684, 171562, 175683, 175682, 175681, 175680, 175679, 175265, 174848, 171566, 171565, 171564, 171563, 171531, 171530, 171529, 171528, 171551, 171550, 171756, 171755, 171754, 171753, 171752, 171751, 171743, 171742, 171679, 171678, 143362, 143337, 143333, 32416, 193981, 171750, 171749, 171556, 171555, 144162, 143338, 137647, 1685, 171748, 171741, 171740, 171739, 171735, 171734, 171733, 171732, 171731, 171730, 171706, 171607, 171606, 171605, 171604, 171554, 142851, 37478, 171738, 171737, 171736, 171710, 171709, 171708, 171707, 149412, 143255, 143251, 143250, 32429, 171747, 171746, 171553, 143336, 32404, 171559, 171552, 171527, 171526, 171525, 143254, 171659, 171658, 171587, 171581, 171558, 171557, 149413, 143249, 171651, 171650, 171583, 171582, 171580, 171535, 143321, 143320, 171657, 171656, 171655, 171654, 171653, 171652, 171539, 171538, 171536, 143318, 171618, 171617, 171616, 171615, 171614, 171613, 171612, 171611, 171610, 171609, 171608, 171540, 171537, 143322, 143319, 139852, 205077, 204088, 204396, 204116, 205921, 204089, 203973, 204254, 204397, 203862, 205938, 204090, 204379, 206552, 203195, 205872, 205587, 203260, 205937, 205936, 204097, 204117, 203257, 203193, 206037, 205585, 205919, 205920, 205080, 205079, 203975, 205586, 205819, 204098, 203756, 152614, 206103, 179984, 174746, 171524, 144159, 137646, 32431, 32427, 143324, 143323, 176924, 176629, 176628, 176627, 176624, 171698, 26499, 207320, 187294, 176626, 176625, 171701, 171699, 171697, 171696, 171636, 171635, 208375, 171704, 171702, 171700, 142838, 137644, 32424, 32385, 203613, 203614, 203615, 203609, 143253, 171703, 171579, 171693, 171695, 171578, 171575, 171574, 190684, 190683, 190681, 190680, 171694, 171692, 171577, 171576, 171573, 171572, 171571, 171570, 171569, 171544, 149418, 143317, 32349, 171547, 171546, 171545, 171543, 203612, 171685, 171683, 171680, 171661, 171660, 171647, 171646, 171542, 171541, 184955, 171681, 208244, 171776, 171775, 171774, 171773, 171772, 171771, 171770, 171769, 171765, 171745, 171744, 171684, 171682, 143328, 142871, 203415, 180728, 206975, 205221, 205220, 34360, 171768, 171600, 143256, 143296, 171597, 142341, 32389, 143301, 143245, 143314, 143242, 171594, 171602, 143247, 26495, 171767, 171599, 143295, 32383, 143244, 142340, 171596, 32425, 171601, 171593, 143273, 143342, 195141, 143246, 171598, 171766, 143243, 171595, 171603, 208870, 143363, 32355, 207290, 207079, 445271, 208002, 123213, 123209, 17154, 16398, 123210, 16399, 123207, 16400, 17153, 123212, 123208, 16397, 13965, 1849, 43118, 43122, 43120, 43119, 43117, 43116, 43121, 1621, 445399, 445398, 1732, 178834, 405870, 358410, 180403, 194340, 204015, 204017, 3643, 204016, 204014, 186559, 207129, 1842, 130666, 180124, 203982, 203972, 2724, 1622, 204005, 203838, 180663, 23014, 23013, 156561, 68, 36998, 36997, 36996, 36989, 36988, 36987, 36986, 36985, 36984, 36983, 36982, 36981, 36980, 36979, 3769, 1731, 142076, 3800, 3799, 1617, 197141, 197145, 197144, 197143, 197173, 197172, 197142, 197133, 197132, 197131, 197124, 197137, 201514, 201496, 201495, 201494, 201493, 201492, 201491, 201490, 201489, 201488, 201422, 201512, 201511, 203801, 201544, 201543, 201536, 201535, 201534, 201533, 201528, 201527, 201526, 201525, 201524, 201503, 201500, 201542, 201541, 201540, 201539, 201538, 201537, 201532, 201531, 201530, 201529, 201523, 201521, 201509, 201508, 201506, 201504, 201513, 201510, 201507, 201505, 201498, 201522, 201497, 203800, 201502, 201501, 201499, 203762, 200311, 205190, 200317, 200316, 200315, 200314, 200313, 200312, 200310, 200309, 200308, 200307, 200306, 124374, 209692, 209039, 207416, 206110, 190536, 206111, 201554, 201550, 201549, 201548, 201547, 201545, 201519, 201515, 179706, 201555, 201546, 201559, 201518, 201553, 201552, 201558, 201551, 201556, 201520, 201557, 201560, 201516, 200329, 200328, 200330, 200327, 200326, 200331, 201517, 200323, 200322, 200321, 200320, 200319, 200318, 188215, 207973, 203199, 205542, 207406, 202273, 202267, 206602, 207595, 207594, 197118, 176497, 2561, 184966, 183957, 184972, 164639, 184493, 184380, 184381, 191083, 367129, 184382, 181621, 181622, 184899, 184891, 184875, 184883, 184720, 184904, 184896, 184888, 184880, 184970, 184901, 184893, 184885, 184877, 184898, 184890, 184882, 184874, 184964, 184719, 184903, 184895, 184887, 184879, 184977, 184900, 184892, 184876, 184884, 184974, 184889, 184873, 184897, 184881, 184902, 184894, 184886, 184878, 190942, 207387, 207388, 22538, 22537, 22536, 22535, 192686, 182094, 185292, 181556, 181569, 214503, 181278, 181275, 184023, 183920, 183919, 183918, 183917, 183499, 183916, 182817, 183913, 182938, 182937, 182936, 183915, 183914, 184024, 183497, 183498, 184025, 182789, 183410, 183995, 183994, 183993, 183991, 183992, 181664, 182798, 183504, 183500, 183502, 183501, 183503, 147282, 146441, 147285, 147284, 147283, 22887, 22885, 185302, 180575, 22929, 22928, 22902, 181475, 149051, 22914, 22894, 175003, 22912, 175010, 175002, 181380, 175025, 175021, 175020, 175019, 175014, 148735, 38148, 22913, 22911, 22886, 22884, 22883, 22882, 175028, 175017, 175013, 175008, 175007, 175006, 148757, 148747, 148746, 175030, 175029, 175027, 175026, 175024, 175023, 175018, 175016, 175015, 175009, 175001, 148763, 148760, 148759, 148756, 148753, 175022, 175012, 175011, 175005, 175004, 152328, 148750, 181369, 181067, 181066, 181065, 181064, 181063, 152325, 152327, 152332, 37028, 37026, 152331, 152330, 152329, 152326, 37038, 37037, 37036, 37035, 37034, 37033, 37032, 37030, 37029, 37031, 37027, 37025, 3772, 176583, 183515, 182173, 183395, 183394, 182797, 183397, 182799, 183396, 182174, 182525, 181555, 184852, 183514, 184657, 183996, 182175, 181372, 184912, 181270, 182090, 180125, 185168, 209348, 181737, 181738, 181734, 214500, 181735, 181736, 184565, 183791, 183333, 184289, 195139, 184414, 184290, 195140, 184415, 203226, 181310, 203225, 177203, 177047, 176579, 207208, 184164, 177048, 176580, 203224, 177049, 176901, 176633, 176577, 176694, 176578, 203289, 197087, 209114, 209124, 209116, 21680, 170073, 22776, 22775, 1560, 210177, 22783, 4087, 177503, 177495, 123244, 22804, 22772, 22812, 177500, 209538, 209635, 22777, 4089, 177497, 177494, 22806, 22774, 177502, 209548, 209544, 180045, 175749, 22803, 177499, 22811, 142075, 177496, 4088, 177504, 177501, 22773, 22813, 180043, 4090, 177498, 180034, 209634, 35591, 210176, 210175, 209273, 179965, 180729, 180726, 209819, 180735, 180733, 180725, 209275, 210107, 209288, 209287, 209284, 209283, 209282, 209274, 187376, 210216, 209753, 209269, 209860, 209859, 209858, 209818, 209820, 209332, 209342, 209320, 180524, 209286, 209295, 209294, 209293, 183816, 181877, 181982, 181821, 181817, 181925, 181813, 181921, 211498, 181822, 181818, 181926, 181814, 181922, 181766, 181819, 181923, 181811, 181823, 181815, 181927, 181713, 181820, 181812, 181816, 181924, 181595, 192059, 192883, 209115, 207586, 207578, 207583, 191364, 207588, 207580, 207585, 207577, 207582, 207587, 207579, 207584, 207589, 207581, 194097, 209098, 433389, 433391, 428217, 209035, 201722, 207734, 164839, 207354, 209255, 209252, 209073, 209137, 209277, 209066, 208835, 208873, 208877, 209253, 206541, 207327, 203169, 208454, 208449, 208444, 203383, 452391, 179944, 209128, 203310, 209080, 204119, 204878, 204118, 202754, 209081, 206615, 20691, 1964, 1961, 264, 263, 204827, 204826, 175080, 176495, 143979, 204828, 1826, 204464, 204457, 1628, 1827, 1735, 177256, 177255, 177254, 177253, 177252, 177251, 177250, 177249, 179487, 204389, 204976, 1810, 204975, 148662, 148658, 178573, 148677, 148696, 148695, 148680, 148675, 148669, 148659, 1814, 1815, 148683, 148714, 148686, 148707, 148697, 148693, 148692, 148684, 148674, 148668, 148665, 148664, 148660, 148661, 148725, 148694, 148691, 148682, 148671, 148670, 148663, 103628, 1816, 1811, 1812, 1813, 180655, 204443, 204425, 204424, 204347, 204349, 204582, 204441, 204435, 204395, 204344, 204442, 175404, 37118, 324, 177248, 177247, 177246, 177245, 153459, 203707, 153460, 148436, 148766, 148765, 148743, 148731, 148730, 148732, 148764, 148733, 148748, 148728, 148755, 148752, 148749, 148741, 148767, 148773, 148769, 148758, 148754, 148729, 164618, 148768, 148762, 148511, 203753, 203229, 203752, 36396, 153221, 142145, 176586, 181280, 147771, 147770, 147769, 147765, 147764, 147768, 147767, 147766, 147763, 147755, 147753, 147745, 147743, 147762, 147761, 147760, 147748, 147747, 147746, 147744, 147759, 147758, 147757, 147756, 147754, 147752, 147751, 147750, 147749, 183899, 147742, 183901, 183898, 183897, 182154, 182153, 182152, 182151, 182150, 182149, 182148, 182147, 184017, 183936, 183343, 183934, 184018, 184015, 183846, 183342, 183105, 184014, 183845, 183842, 184022, 183844, 183843, 184456, 182607, 184499, 184496, 183839, 184498, 184497, 184438, 184011, 183838, 183837, 183831, 183517, 184455, 184439, 184436, 184020, 184019, 183836, 183835, 183834, 183833, 184437, 183832, 184012, 181271, 184564, 184563, 202839, 202835, 202834, 202833, 165748, 203842, 175784, 171938, 165750, 165747, 165746, 18083, 12665, 202587, 165740, 3084, 190549, 165742, 165743, 202580, 165751, 165745, 165744, 165741, 165749, 206574, 204187, 204166, 204165, 206737, 204666, 204665, 204659, 204658, 204645, 204193, 204189, 204188, 204186, 204184, 204177, 204176, 204175, 203471, 176275); +UPDATE `gameobject_template` SET `displayId`=10628, `VerifiedBuild`=57359 WHERE `entry`=209251; -- Firelands Sulfuron Bridge + +DELETE FROM `gameobject_questitem` WHERE (`GameObjectEntry`=181276 AND `Idx`=0); +INSERT INTO `gameobject_questitem` (`GameObjectEntry`, `Idx`, `ItemId`, `VerifiedBuild`) VALUES +(181276, 0, 35229, 57564); -- Flame Cap |