diff options
| -rw-r--r-- | sql/updates/world/cata_classic/2024_10_21_00_world.sql | 48 |
1 files changed, 48 insertions, 0 deletions
diff --git a/sql/updates/world/cata_classic/2024_10_21_00_world.sql b/sql/updates/world/cata_classic/2024_10_21_00_world.sql new file mode 100644 index 00000000000..f8689597356 --- /dev/null +++ b/sql/updates/world/cata_classic/2024_10_21_00_world.sql @@ -0,0 +1,48 @@ +DELETE FROM `gameobject_template` WHERE `entry` IN (328418 /*Horde Flag*/, 328416 /*Alliance Flag*/, 328419 /*Horde Flag*/, 328417 /*Alliance Flag*/, 445442 /*Instance Portal (Party + Heroic)*/); +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 +(328418, 37, 5913, 'Horde Flag', '', '', '', 2.5, 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, 56713), -- Horde Flag +(328416, 37, 5912, 'Alliance Flag', '', '', '', 2.5, 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, 56713), -- Alliance Flag +(328419, 36, 5913, 'Horde Flag', '', '', '', 2.5, 0, 301089, 0, 1, 0, 1, 0, 10000, 10000, 328418, 1, 1546, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 56713), -- Horde Flag +(328417, 36, 5912, 'Alliance Flag', '', '', '', 2.5, 0, 301091, 0, 1, 0, 1, 0, 10000, 10000, 328416, 1, 1545, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 56713), -- Alliance Flag +(445442, 31, 74868, 'Instance Portal (Party + Heroic)', '', '', '', 1, 1, 214, 215, 0, 0, 0, 0, 2, 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, 56713); -- Instance Portal (Party + Heroic) + +UPDATE `gameobject_template` SET `VerifiedBuild`=56713 WHERE `entry` IN (191605, 208607, 190942, 191790, 197142, 180408, 191083, 203800, 197124, 191164, 190536, 197190, 197187, 1624, 75296, 197188, 197192, 197125, 197189, 197193, 197136, 197191, 186328, 97700, 1628, 104600, 75299, 186269, 104591, 186314, 186327, 181191, 176310, 209692, 209039, 208219, 208218, 201517, 180433, 207941, 180431, 197137, 205106, 197123, 197138, 205107, 197184, 197183, 197182, 197176, 180429, 180428, 197181, 197178, 197177, 197140, 197139, 197122, 190040, 180523, 197179, 197180, 197185, 197186, 197133, 197132, 197131, 202260, 202258, 197119, 197134, 202256, 197121, 197149, 197120, 197150, 197147, 202259, 197148, 202253, 197174, 197146, 197173, 180425, 202257, 180415, 197175, 180471, 197172, 203978, 197135, 180426, 180427, 203762, 180410, 208200, 197118, 206111, 203801, 197117, 197116, 185107, 180472, 180411, 180407, 180406, 180405, 197099, 197022, 197021, 207661, 197097, 197031, 197030, 197029, 197028, 197027, 197026, 197025, 197024, 197023, 175758, 175729, 197088, 197086, 197011, 197032, 197020, 197012, 197008, 197092, 197076, 197060, 197044, 197089, 197073, 197057, 197070, 197054, 197067, 197051, 195141, 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, 197009, 197083, 197080, 197013, 197084, 105174, 197081, 197017, 197094, 197014, 197085, 105175, 197082, 197095, 197079, 195532, 195427, 194064, 209115, 194072, 208545, 202736, 194297, 203147, 204431, 202748, 202747, 202776, 202846, 203169, 209096, 204878, 204118, 209080, 208162, 202754, 204119, 209081, 207694, 207693, 207692, 207691, 206594, 3800, 3799, 185454, 201453, 201446, 201452, 201451, 201450, 201449, 201448, 201447, 201445, 209101, 209041, 209040, 209054, 209052, 209047, 209046, 209045, 209044, 209043, 209053, 207416, 209051, 209050, 209049, 209048, 209042, 202758, 206110, 201496, 201495, 201494, 201493, 201492, 201491, 201490, 201489, 201488, 201422, 201497, 201512, 201523, 201511, 201501, 201522, 201509, 201508, 201506, 201503, 201500, 201514, 201513, 197098, 209116, 209124, 209114, 202028, 202027, 202026, 202025, 202024, 202023, 201995, 201991, 202006, 201997, 201994, 202010, 202004, 202003, 201996, 201993, 201992, 197126, 202005, 201998, 179965, 197018, 201987, 201983, 202002, 205553, 202011, 209297, 201989, 140911, 201504, 201521, 200317, 200320, 200318, 200323, 200322, 200321, 200319, 200316, 205190, 200330, 124374, 200331, 200329, 200315, 200314, 200313, 200312, 200311, 200310, 200307, 200306, 200328, 200327, 200326, 200309, 200308, 201505, 201510, 201507, 201498, 201520, 201499, 201516, 201502, 201560, 201558, 201557, 201518, 201515, 201519, 201559, 201556, 201551, 201555, 201553, 201552, 179706, 201554, 201550, 201549, 201548, 201547, 201546, 201545, 202364, 202363, 202365, 205144, 197196, 202001, 202000, 201999, 201982, 197096, 176217, 176216, 176215, 181085, 176325, 176249, 175966, 175535, 176351, 175463, 175462, 175461, 175857, 175741, 175737, 176112, 175858, 175537, 175534, 175467, 176349, 175458, 175761, 175753, 175749, 175762, 175754, 175457, 175748, 175470, 175434, 175433, 175536, 207389, 177287, 176350, 176346, 176245, 175756, 176352, 176304, 153464, 176353, 176309, 176308, 176307, 176248, 176224, 175373, 175441, 175469, 175445, 175437, 175405, 175377, 175353, 175381, 176194, 176424, 175379, 175350, 175358, 175968, 175442, 175967, 175374, 175472, 175466, 175459, 175354, 175438, 175436, 175447, 175439, 175368, 175351, 175444, 175483, 175355, 175376, 175471, 175435, 175359, 175484, 175375, 175443, 175969, 175796, 175356, 175380, 175460, 175825, 175824, 175440, 175352, 175372, 175357, 177464, 175432, 207488, 205873, 182059, 182058, 194917, 194916, 194919, 205537, 194918, 194923, 194934, 177264, 180684, 2040, 176389, 176272, 175370, 175369, 176275, 176390, 2043, 207580, 207577, 207587, 207584, 207581, 207578, 191364, 207588, 207585, 207582, 207579, 207589, 207586, 207583, 192886, 193604, 192887, 192905, 190488, 192891, 185106, 192890, 182198, 184802, 214501, 183965, 183961, 184318, 183362, 183962, 184319, 183363, 183963, 183964, 185018, 185015, 184632, 184449, 184322, 183788, 191817, 186138, 186137, 184735, 184732, 184734, 184488, 160868, 160867, 160866, 160871, 160870, 160869, 207479, 184300, 181279, 184421, 184418, 184423, 184422, 184420, 184419, 184310, 184588, 182436, 182435, 182434, 182426, 182425, 182421, 182420, 182415, 182414, 183507, 182450, 182449, 182448, 182447, 182446, 182445, 182438, 182437, 182433, 182432, 182430, 182429, 182428, 182424, 182423, 182452, 182451, 182444, 182440, 182439, 182431, 182427, 182422, 182417, 182416, 182413, 182443, 182442, 182441, 182419, 182418, 183269, 183267, 184320, 183268, 184433, 183947, 183266, 184431, 184430, 184429, 184428, 184427, 184426, 184425, 184424, 183159, 183160, 184030, 184478, 187073, 183789, 182524, 182591, 183877, 185522, 185519, 185460, 185105, 183104, 183852, 183413, 182196, 183516, 183036, 182947, 182940, 181556, 181278, 182943, 182942, 183295, 183296, 183968, 183518, 183414, 184458, 214507, 182585, 182584, 184810, 184813, 184812, 184809, 184811, 184807, 184800, 184799, 183412, 183411, 183922, 183895, 182118, 182117, 190097, 182588, 180414, 183168, 183166, 183167, 182957, 180409, 181277, 183152, 183294, 183132, 183141, 183137, 182583, 182582, 182581, 182541, 182601, 185202, 185204, 185205, 185203, 181606, 181271, 181582, 181270, 181680, 181580, 183515, 182173, 183514, 182174, 184020, 184019, 184011, 183835, 182525, 181915, 181671, 181439, 181438, 181435, 182540, 181440, 181436, 181441, 181437, 181442, 182539, 184496, 184497, 184456, 184499, 209348, 181736, 181737, 181738, 181734, 181735, 182175, 184498, 184013, 183843, 184014, 183842, 183838, 184438, 183837, 183517, 214500, 183834, 176583, 184455, 184439, 184437, 184436, 183836, 183833, 183831, 184021, 183832, 181664, 211498, 184012, 183914, 183915, 183916, 184025, 183917, 183918, 183498, 183497, 184024, 183920, 183919, 184023, 182937, 182936, 182938, 182798, 182799, 181372, 182797, 181555, 182789, 184415, 184289, 184414, 184290, 184912, 184564, 184563, 184565, 183791, 183333, 195140, 195139, 203226, 181310, 142145, 203224, 177047, 184164, 176580, 176577, 207208, 177048, 203225, 176901, 176578, 203289, 177049, 176633, 176694, 177203, 176579, 206602, 1860, 1622, 445272, 144111, 3662, 3705, 123211, 19019, 75293, 207079, 1732, 445271, 208002, 17154, 123213, 123209, 123207, 16400, 16398, 16399, 17153, 123212, 16397, 123210, 123208, 13965, 1849, 43122, 43120, 43119, 43118, 43117, 43116, 43121, 445399, 445398, 405870, 178834, 180403, 2057, 358410, 204015, 194340, 204016, 186559, 3643, 204017, 204014, 207129, 36, 1617, 130666, 1621, 203972, 3804, 3803, 290, 1618, 1731, 1837, 2724, 1620, 180682, 206039, 206038, 202018, 202019, 202014, 202013, 202020, 209064, 209072, 209065, 202017, 206294, 202273, 202271, 202267, 201456, 92011, 204988, 202274, 202272, 202270, 201460, 201459, 201458, 201457, 201454, 203976, 204987, 201461, 201455, 201463, 201462, 180047, 201485, 201483, 201481, 201482, 201474, 201484, 201480, 201479, 201477, 201476, 201478, 201475, 201421, 201417, 201420, 201419, 201415, 206560, 201418, 201416, 202022, 202021, 202016, 202015, 202012, 202036, 202035, 202034, 202033, 202032, 202031, 202030, 202029, 202009, 202007, 201981, 206623, 202008, 197087, 194071, 208935, 209548, 209538, 209635, 209634, 180043, 22776, 22775, 1560, 22783, 177502, 177495, 177496, 177494, 189303, 177499, 22806, 22811, 22804, 22803, 22812, 177498, 177497, 22813, 22772, 22777, 22773, 22774, 177501, 177500, 177504, 177503, 142075, 4087, 4090, 4089, 4088, 123244, 186615, 186614, 186234, 186720, 180700, 210177, 180034, 209544, 180045, 170073, 142076, 179882, 101832, 101831, 101834, 101833, 207290, 183384, 176456, 176428, 175886, 136946, 176432, 176433, 136928, 136925, 176429, 136927, 136926, 175949, 176454, 176434, 176426, 175588, 176442, 136922, 175194, 136954, 136935, 175271, 176455, 136948, 176436, 175382, 136929, 136961, 176449, 176462, 136942, 176430, 175195, 136955, 176443, 136923, 153469, 175272, 136936, 175528, 164725, 175607, 136949, 176437, 175970, 175266, 136962, 136930, 176450, 176463, 136943, 176431, 175196, 176444, 175529, 136937, 176425, 176457, 175533, 175608, 176089, 164726, 136950, 176438, 175267, 136963, 136931, 176451, 175609, 136944, 175197, 136957, 176445, 175946, 136938, 176458, 175530, 136951, 176439, 175385, 175268, 136932, 136964, 176452, 177606, 175334, 176461, 175185, 175153, 136945, 175198, 176446, 175947, 176459, 175531, 136939, 176427, 175245, 175706, 136952, 176440, 176090, 175269, 136965, 136933, 175621, 175186, 175199, 136959, 176447, 175244, 176460, 175532, 136940, 175950, 136941, 175705, 176441, 179880, 175270, 136966, 136934, 136947, 175187, 176435, 175200, 176448, 175606, 175785, 175124, 202057, 202043, 203953, 203988, 203987, 203955, 203954, 203952, 203951, 203950, 203948, 203949, 170592, 170551, 170554, 170553, 170552, 170502, 170504, 170503, 158674, 170515, 170514, 170501, 170500, 170499, 170496, 170490, 170487, 170513, 170491, 170489, 170488, 170481, 170477, 170475, 158599, 170493, 170492, 170482, 170478, 170476, 170505, 170498, 170497, 170495, 170494, 170486, 170485, 170508, 170507, 170506, 170484, 170483, 170480, 170479, 170474, 170473, 170472, 170510, 170509, 170511, 170512, 174745, 169243, 164638, 170523, 170526, 170525, 170524, 174744, 170530, 170527, 170529, 170528, 170546, 170545, 170544, 170543, 170539, 170541, 170540, 170548, 170547, 170542, 170550, 170549, 170537, 170533, 170538, 170534, 170536, 170535, 170532, 170531, 170522, 170521, 170520, 158608, 170519, 170518, 170517, 170516, 174045, 179553, 158579, 174702, 174701, 174700, 158585, 140403, 140402, 158564, 174420, 174417, 158561, 164689, 158555, 174699, 158571, 174424, 174408, 158568, 170440, 158565, 174418, 158562, 166872, 158559, 158556, 140396, 174409, 140393, 174422, 158566, 140390, 158563, 158547, 174416, 158576, 158560, 174410, 174698, 174423, 174407, 158567, 140391, 170439, 164766, 164765, 164764, 164763, 164762, 164761, 209034, 164767, 164760, 164759, 204284, 195468, 201539, 201538, 176497, 21680, 208222, 208220, 208210, 180037, 208214, 208186, 208072, 208069, 180038, 208395, 208394, 208223, 208221, 208216, 208215, 208213, 208212, 208211, 208078, 195212, 195164, 197144, 197141, 197145, 197143, 428217, 204337, 207415, 204381, 207343, 207407, 444993, 433391, 433079, 193963, 186887, 183957, 22623, 22622, 170351, 170350, 170349, 170348, 170347, 22638, 22606, 22605, 22604, 22603, 22602, 180050, 180048, 180046, 179968, 179977, 179972, 179970, 179969, 179967, 180007, 179964, 180026, 209571, 206733, 205371, 205230, 206734, 204728, 195142, 206722, 204691, 204690, 207101, 206716, 206711, 204625, 204624, 203977, 207099, 206715, 206710, 206709, 204620, 206708, 206707, 205494, 207100, 205544, 204729, 204676, 206714, 206712, 204730, 206713, 203979, 207098, 207094, 204627, 207414, 204723, 204626, 197279, 179707, 207097, 207096, 206530, 197257, 204724, 206741, 206736, 206735, 204725, 204710, 204640, 204628, 204623, 204622, 204621, 204196, 204192, 204191, 202717, 204709, 164871, 204607, 204197, 204639, 204608, 204606, 204611, 204610, 204605, 204198, 204194, 202590, 175788, 175787, 203471, 204662, 204604, 206603, 204207, 204206, 204199, 205108, 204210, 204202, 205142, 175080, 206727, 204609, 204601, 204215, 204212, 206109, 204603, 206725, 204209, 204201, 204600, 204664, 206726, 204214, 203969, 205109, 206995, 204211, 204163, 206608, 204602, 206609, 206610, 204208, 204663, 204647, 204213, 194633, 180663, 194493, 205937, 206037, 205921, 205585, 205077, 205938, 205586, 206103, 205080, 205587, 205919, 205079, 205819, 203756, 205872, 205936, 206552, 205920, 3695, 142210, 142215, 142211, 142214, 142209, 142216, 142217, 142208, 142219, 142212, 142218, 142213, 142696, 3659, 142476, 208335, 208333, 175084, 19020, 142207, 144179, 175085, 208325, 74447, 146085, 90858, 142344, 142475, 146086, 142487, 85556, 147771, 147770, 147769, 147764, 147755, 147753, 147765, 147760, 147743, 147763, 147768, 147767, 147762, 147761, 147766, 147759, 147757, 147749, 147748, 147747, 147758, 147756, 147745, 147744, 147746, 194566, 147752, 147751, 147750, 147754, 147742, 106336, 106327, 106325, 178864, 149038, 106326, 204875, 203822, 106335, 203823, 194997, 181690, 194458, 2041, 194575, 20725, 20724, 194991, 19021, 194349, 177225, 194263, 190549, 445441, 205476, 35593, 18934, 35598, 18971, 18899, 35595, 101811, 35597, 18936, 18973, 18901, 75295, 35594, 18935, 18895, 205477, 36738, 182011, 91138, 75298, 18972, 205479, 35596, 101812, 18900, 205044, 126051, 126050, 161752, 61936, 61935, 4141, 4072, 3729, 208343, 3727, 208345, 201291, 206559, 201293, 3725, 58389, 58388, 204732, 204731, 202819, 197278, 197312, 197322, 105576, 206549, 206538, 197280, 197276, 206546, 206545, 206539, 206529, 197323, 197313, 204634, 197287, 197284, 204633, 204632, 204631, 204204, 204203, 204195, 206729, 206116, 204200, 204205, 208595, 208591, 203732, 203731, 202578, 151968, 151965, 151958, 151955, 151953, 151966, 151962, 151961, 151972, 151971, 151970, 151969, 151967, 151964, 151963, 151960, 151959, 151957, 151956, 151954, 21009, 1940, 206987, 176584, 207303, 207232, 206881, 206882, 179782, 149032, 149020, 152036, 2866, 152039, 2047, 148498, 179862, 179844, 1734, 148506, 153241, 202831, 153240, 161536, 445089, 207411, 1619, 203265, 147787, 142102, 111202, 111206, 111205, 111204, 147786, 111226, 111225, 111224, 111223, 111222, 111221, 111220, 111217, 111215, 111212, 111207, 111203, 269, 175746, 111227, 111216, 203195, 203193, 208247, 208246, 208245, 203242, 203259, 203258, 203256, 203243, 204117, 204116, 203260, 204397, 204396, 203257, 179984, 174746, 180728, 208244, 184955, 143247, 34360, 143246, 142340, 32425, 206975, 205221, 205220, 22223, 29151, 29150, 176231, 179486, 2045, 175383, 2652, 2704, 2667, 207387, 207388, 207408, 445433, 2046, 2691, 20980, 20978, 20979, 20977, 1623, 153239, 203989, 176865, 176209, 181236, 181130, 181103, 181131, 176277, 142142, 1735, 202055, 202053, 207720, 207719, 207718, 202054, 201986, 201985, 207723, 207722, 207721, 201980, 204874, 176498, 201544, 201543, 201536, 201532, 201531, 201530, 201529, 201542, 201537, 201535, 201534, 201533, 201541, 201540, 201528, 201527, 201526, 201525, 201524, 202862, 194099, 126342, 126345, 126335, 126312, 205566, 126341, 126339, 126338, 126337, 126314, 179585, 202832, 126340, 126313, 459353, 180322, 452217, 179584, 207412, 459352, 148420, 208321, 148421, 148419, 148418, 149431, 149432, 149433, 207513, 206307, 37099, 179554, 30856, 30854, 180712, 30855, 176587, 324, 37118, 22550, 175404, 92458, 148677, 148662, 148658, 31, 1817, 180655, 204446, 204445, 204444, 204442, 204441, 204435, 204425, 204424, 1820, 204346, 1819, 178572, 1809, 204349, 204582, 204344, 203838, 175751, 1562, 180025, 56, 176793, 1945, 1946, 178504, 1947, 1948, 1561, 92015, 197043, 197042, 197041, 197040, 197039, 197035, 197034, 197033, 197038, 197037, 197036, 197015, 197010, 176296, 205898, 205951, 205869, 206384, 209263, 206017, 194282, 203726, 203728, 203725, 203727, 207354, 207679, 205223, 203719, 205228, 203724, 205087, 205225, 203633, 203721, 205088, 205222, 205950, 203718, 205227, 203723, 205224, 203632, 203720, 452396, 205901, 203717, 205226, 203722, 179944, 206018, 208225, 206313, 204853, 452397, 206312, 206848, 206846, 205358, 205356, 205250, 206329, 207858, 204951, 205248, 208311, 208209, 204950, 207859, 204952, 204949, 205105, 205104, 192889, 202738, 204837, 202750, 205360, 208260, 208259, 205273, 204407, 205121, 204018, 205126, 205110, 205359, 205128, 205113, 205129, 205133, 205125, 205102, 445078, 205130, 205122, 205115, 205131, 205111, 205127, 205119, 205120, 205272, 204576, 205112, 205116, 207695, 179905, 206654, 208206, 203710, 181621, 206541, 207075, 179907, 179899, 179904, 206653, 208205, 179906, 208207, 206655, 179871, 207076, 180731, 180741, 180739, 180737, 180730, 209819, 209820, 209818, 209332, 180524, 209342, 209320, 209286, 209295, 209294, 209293, 180736, 209274, 209284, 209275, 209273, 209287, 209283, 209282, 180724, 180740, 180727, 180734, 180735, 180733, 180729, 180726, 180725, 209753, 209288, 205039, 445420, 205562, 207349, 207218, 206206, 207410, 207219, 206207, 207672, 207664, 207376, 202312, 202308, 207725, 207673, 207665, 207377, 202313, 202309, 445419, 207726, 207674, 207662, 207374, 206506, 202314, 202310, 204972, 202306, 207802, 207663, 207375, 202307, 202311, 207669, 207547); +UPDATE `gameobject_template` SET `Data1`=0, `VerifiedBuild`=56713 WHERE `entry`=186267; -- Pumpkin Shrine +UPDATE `gameobject_template` SET `Data6`=0, `VerifiedBuild`=56713 WHERE `entry`=208164; -- Candy Bucket +UPDATE `gameobject_template` SET `name`='Pip\'s Mole Machine', `VerifiedBuild`=56713 WHERE `entry` IN (207327, 207328); -- Finkle's Mole Machine +UPDATE `gameobject_template` SET `Data0`=56, `VerifiedBuild`=56713 WHERE `entry`=178831; -- Meeting Stone +UPDATE `gameobject_template` SET `Data20`=70, `VerifiedBuild`=56713 WHERE `entry`=184849; -- Cache of the Legion +UPDATE `gameobject_template` SET `Data0`=69, `VerifiedBuild`=56713 WHERE `entry`=182559; -- Meeting Stone +UPDATE `gameobject_template` SET `Data12`=1, `Data25`=1892, `VerifiedBuild`=56713 WHERE `entry`=185169; -- Reinforced Fel Iron Chest +UPDATE `gameobject_template` SET `Data6`=0, `VerifiedBuild`=56713 WHERE `entry`=176453; -- Meat Rack +UPDATE `gameobject_template` SET `Data6`=0, `VerifiedBuild`=56713 WHERE `entry`=136924; -- Bench +UPDATE `gameobject_template` SET `Data7`=0, `VerifiedBuild`=56713 WHERE `entry`=164839; -- Explosive Trap +UPDATE `gameobject_template` SET `Data6`=0, `VerifiedBuild`=56713 WHERE `entry`=180701; -- Hay Bale 2 +UPDATE `gameobject_template` SET `Data7`=0, `VerifiedBuild`=56713 WHERE `entry`=2561; -- Freezing Trap +UPDATE `gameobject_template` SET `Data7`=0, `VerifiedBuild`=56713 WHERE `entry`=164839; -- Explosive Trap +UPDATE `gameobject_template` SET `Data1`=0, `VerifiedBuild`=56713 WHERE `entry`=186267; -- Pumpkin Shrine +UPDATE `gameobject_template` SET `Data1`=0, `VerifiedBuild`=56713 WHERE `entry`=186267; -- Pumpkin Shrine +UPDATE `gameobject_template` SET `Data1`=0, `VerifiedBuild`=56713 WHERE `entry`=186267; -- Pumpkin Shrine +UPDATE `gameobject_template` SET `Data7`=0, `VerifiedBuild`=56713 WHERE `entry`=164839; -- Explosive Trap +UPDATE `gameobject_template` SET `Data6`=0, `VerifiedBuild`=56713 WHERE `entry`=180701; -- Hay Bale 2 +UPDATE `gameobject_template` SET `Data6`=0, `VerifiedBuild`=56713 WHERE `entry`=180701; -- Hay Bale 2 +UPDATE `gameobject_template` SET `Data1`=0, `VerifiedBuild`=56713 WHERE `entry`=186267; -- Pumpkin Shrine +UPDATE `gameobject_template` SET `Data1`=0, `VerifiedBuild`=56713 WHERE `entry`=186267; -- Pumpkin Shrine +UPDATE `gameobject_template` SET `Data6`=0, `VerifiedBuild`=56713 WHERE `entry`=180701; -- Hay Bale 2 +UPDATE `gameobject_template` SET `Data7`=0, `VerifiedBuild`=56713 WHERE `entry`=164639; -- Frost Trap +UPDATE `gameobject_template` SET `Data7`=0, `VerifiedBuild`=56713 WHERE `entry`=164839; -- Explosive Trap +UPDATE `gameobject_template` SET `Data7`=0, `VerifiedBuild`=56713 WHERE `entry`=2561; -- Freezing Trap +UPDATE `gameobject_template` SET `Data7`=0, `VerifiedBuild`=56713 WHERE `entry`=164839; -- Explosive Trap +UPDATE `gameobject_template` SET `Data7`=0, `VerifiedBuild`=56713 WHERE `entry`=164639; -- Frost Trap +UPDATE `gameobject_template` SET `Data0`=17, `VerifiedBuild`=56713 WHERE `entry`=178845; -- Meeting Stone +UPDATE `gameobject_template` SET `VerifiedBuild`=55141 WHERE `entry` IN (201645, 180665, 201642, 175761, 2657, 201643, 175738, 201647, 201646, 175752, 21582, 201644, 175730, 175727, 201649, 201648, 201641, 175746, 21583, 21581, 201665, 201664, 201663, 201655, 201657, 201656, 201654, 201662, 201661, 201660, 201658, 201653, 201652, 175745, 201843, 201822, 201671, 201670, 201669, 201668, 201667, 201666, 201659, 201651, 201650, 175753, 175750, 201690, 201689, 201688, 201687, 201685, 201678, 201677, 201694, 201693, 201692, 201691, 201686, 201682, 201680, 201679, 201676, 201675, 201673, 201672, 201684, 201683, 201681, 201674, 195467, 208438, 208437, 164767, 204284, 205144, 197196, 197007, 197078, 197077, 197061, 197057, 197055, 197054, 197053, 197052, 197073, 197071, 197059, 197056, 197051, 197050, 197093, 197047, 197070, 197076, 197075, 197074, 197072, 197069, 197068, 197067, 197066, 197065, 197064, 197063, 197062, 197060, 197058, 197049, 197048, 197046, 197045, 197044, 197092, 197079, 195141, 197095, 197085, 197084, 197083, 197082, 197081, 197080, 197014, 197008, 197094, 197091, 197090, 197089, 197017, 197013, 105175, 105174, 197009, 197031, 197030, 197029, 197088, 197087, 197086, 197028, 197027, 197026, 197025, 197020, 197096, 202365, 202364, 197097, 1561, 197012, 197032, 207661, 197011, 175729, 197023, 175758, 197024, 197021, 197018, 197022, 197142, 205107, 205106, 197098, 197174, 197173, 197172, 197150, 197149, 197147, 197120, 197118, 197175, 197148, 197146, 197117, 197099, 205553, 197125, 197186, 197119, 197184, 197176, 197133, 197183, 197135, 197132, 197131, 203978, 197185, 197182, 197181, 197180, 197179, 197178, 197177, 197116, 202260, 202259, 202258, 202257, 202256, 202253, 197140, 197139, 197134, 197122, 197121, 197136, 197193, 197192, 197191, 197190, 197189, 197188, 197187, 197138, 197123, 197126, 206623, 202008, 202028, 202027, 202024, 202023, 202026, 202025, 202010, 202006, 202004, 202005, 201989, 202003, 201997, 201996, 201995, 201994, 201993, 201992, 201991, 201987, 201983, 209297, 202011, 140911, 202002, 202001, 202000, 201999, 201998, 201982, 207721, 202036, 202035, 202034, 202033, 202032, 202031, 202030, 202029, 202022, 202021, 202020, 202019, 202018, 202017, 202016, 202015, 202013, 202012, 201981, 201980, 207722, 202014, 207723, 201986, 207720, 207719, 207718, 201985, 202064, 202063, 202057, 202056, 202055, 202054, 202053, 202051, 202050, 202049, 202048, 202046, 202045, 202062, 202061, 202059, 202058, 202052, 202047, 202043, 203943, 203941, 203938, 203937, 203934, 203933, 203932, 203930, 203928, 202060, 202044, 203945, 203944, 203942, 203940, 203936, 203931, 203929, 203947, 203946, 203939, 203935, 203927, 203926, 203925, 203924, 201619, 203949, 203948, 203951, 203950, 203954, 207691, 206594, 202009, 202007, 204281, 22538, 22537, 22536, 22535, 201460, 201459, 201458, 201457, 201456, 201455, 201454, 92011, 202273, 202271, 202267, 206294, 205105, 202274, 202272, 205104, 202270, 204988, 203976, 3800, 3799, 209114, 204987, 180047, 201461, 201463, 201462, 209116, 201485, 201484, 201483, 201482, 201481, 201480, 201479, 201478, 201477, 201476, 201475, 201474, 209124, 206560, 201421, 201420, 201419, 201418, 201417, 201416, 201415, 201453, 201452, 201451, 201450, 201449, 201448, 201447, 201446, 201445, 209040, 209043, 209041, 209046, 209044, 209101, 209045, 209047, 209054, 209053, 209052, 209051, 209050, 209049, 209048, 209042, 202758, 201492, 201491, 201490, 201496, 201495, 201494, 201493, 201489, 201488, 201422, 207416, 201512, 201511, 201535, 201528, 201527, 201533, 201543, 201524, 201526, 201534, 201544, 201525, 201536, 203801, 201542, 201541, 201540, 201539, 201538, 201537, 201532, 201531, 197137, 201523, 201514, 201500, 201521, 201509, 201508, 201506, 201504, 201503, 201498, 201513, 197124, 201522, 201497, 201529, 201530, 201510, 201507, 201505, 206110, 201501, 190536, 176310, 209039, 209692, 179965, 206111, 201545, 201547, 201548, 201546, 201549, 201553, 201556, 201554, 201552, 201551, 201550, 201499, 200323, 200318, 179706, 200320, 201555, 200322, 200319, 200321, 201559, 201502, 201560, 201518, 201558, 201557, 201519, 201515, 203800, 200331, 203762, 200326, 200327, 200330, 200328, 200329, 200317, 200311, 201516, 200310, 200315, 200309, 200314, 200307, 200308, 200313, 205190, 201520, 201517, 200316, 200312, 200306, 124374); + +DELETE FROM `gameobject_questitem` WHERE (`Idx`=1 AND `GameObjectEntry` IN (184813,184812,184811)); +INSERT INTO `gameobject_questitem` (`GameObjectEntry`, `Idx`, `ItemId`, `VerifiedBuild`) VALUES +(184813, 1, 30524, 56713), -- Sealed Coffin +(184812, 1, 30524, 56713), -- Sealed Coffin +(184811, 1, 30525, 56713); -- Sealed Coffin + +UPDATE `gameobject_questitem` SET `VerifiedBuild`=56713 WHERE (`Idx`=0 AND `GameObjectEntry` IN (203800,203762,203801,105174,105175,202846,202754,140911,205144,176249,207389,177287,177464,205537,177264,185015,184310,184433,184478,182940,181556,181278,182584,184810,184813,184812,184811,181277,182581,182541,182601,181271,181680,181671,209348,182937,182936,182938,182798,182799,181372,182797,181555,203224,204015,194340,204016,204017,204014,203972,290,2724,1560,175949,175588,175382,175385,175334,175950,175606,175785,179553,204284,207415,203977,203979,203969,142344,194566,194997,20725,194349,194263,205476,205477,36738,182011,91138,205479,161752,3729,3727,3725,206881,206882,148506,2691,153239,203989,176209,37099,30856,30854,30855,22550,204425,204424,204346,1562,176793,205250,209274,209284,209275,209273,209287,209283)); +UPDATE `gameobject_questitem` SET `ItemId`=30526, `VerifiedBuild`=56713 WHERE (`GameObjectEntry`=184810 AND `Idx`=1); -- Sealed Coffin +UPDATE `gameobject_questitem` SET `VerifiedBuild`=55141 WHERE (`Idx`=0 AND `GameObjectEntry` IN (204284,205144,105175,105174,140911,204281,203801,203800,203762)); |