diff options
| -rw-r--r-- | sql/updates/world/2014_10_31_02_world.sql | 268 |
1 files changed, 268 insertions, 0 deletions
diff --git a/sql/updates/world/2014_10_31_02_world.sql b/sql/updates/world/2014_10_31_02_world.sql new file mode 100644 index 00000000000..a3cfa1f57ce --- /dev/null +++ b/sql/updates/world/2014_10_31_02_world.sql @@ -0,0 +1,268 @@ +UPDATE `gameobject_template` SET `VerifiedBuild`=17538 WHERE `entry` IN (1766, 1767, 1804, 1806, 1819, 1820, 1848, 1859, 1916, 1941, 1944, 1952, 1953, 1954, 1957, 1967, 2076, 2551, 2849, 3189, 3190, 3200, 3236, 3296, 3640, 3642, 3662, 3937, 3938, 3942, 18077, 20921, 20922, 20979, 21145, 21146, 21147, 21148, 22640, 22641, 22642, 22644, 22646, 22657, 22684, 22685, 22904, 22908, 22909, 22910, 22915, 22916, 22917, 22918, 22919, 22920, 22921, 22922, 22923, 22924, 22925, 22926, 22927, 23575, 31409, 31411, 31580, 36085, 36092, 36977, 36979, 36980, 36981, 36982, 36983, 36984, 36985, 36986, 36987, 36988, 36989, 38147, 40303, 52175, 55615, 58609, 61924, 61925, 85562, 92142, 92143, 102985, 104555, 104593, 112301, 112302, 112303, 112305, 112308, 112309, 112310, 112311, 112312, 112316, 112317, 112319, 112321, 112322, 113569, 120584, 141972, 144070, 147075, 147076, 147077, 149031, 149423, 160846, 160847, 160848, 160849, 160850, 160851, 163645, 164759, 164760, 164761, 164762, 164763, 164764, 164765, 164766, 164767, 164870, 166863, 167288, 174873, 174874, 174881, 174994, 174995, 174996, 174997, 174998, 175669, 175933, 176464, 176489, 176501, 176504, 176557, 176594, 176746, 176747, 176785, 176896, 177164, 177165, 177264, 177269, 178084, 178085, 178304, 178364, 178940, 179064, 179086, 179264, 179424, 179425, 179443, 179444, 179453, 179473, 179482, 179585, 179881, 180124, 180218, 180219, 180340, 180353, 180362, 180395, 180405, 180406, 180407, 180408, 180409, 180410, 180411, 180412, 180414, 180415, 180419, 180420, 180425, 180426, 180427, 180428, 180429, 180431, 180432, 180433, 180434, 180437, 180454, 180471, 180472, 180523, 180570, 180609, 180610, 180611, 180633, 180634, 180635, 180636, 180655, 180690, 180745, 180788, 180901, 181103, 181110, 181166, 181250, 181251, 181252, 181275, 181276, 181278, 181324, 181325, 181326, 181327, 181357, 181378, 181427, 181435, 181436, 181437, 181438, 181439, 181440, 181441, 181442, 181446, 181449, 181450, 181451, 181452, 181453, 181455, 181456, 181570, 181572, 181581, 181585, 181587, 181589, 181590, 181591, 181592, 181593, 181597, 181637, 181638, 181655, 181656, 181657, 181658, 181659, 181660, 181663, 181671, 181697, 181713, 181766, 181767, 181811, 181812, 181813, 181814, 181815, 181816, 181817, 181818, 181819, 181820, 181821, 181822, 181823, 181921, 181922, 181923, 181924, 181925, 181926, 181927, 181980, 181982, 181989, 181990, 182059, 182069, 182082, 182094, 182117, 182118, 182128, 182139, 182165, 182198, 182203, 182205, 182206, 182210, 182222, 182258, 182265, 182267, 182272, 182273, 182274, 182280, 182281, 182282, 182297, 182298, 182299, 182300, 182302, 182304, 182306, 182308, 182354, 182359, 182369, 182376, 182377, 182378, 182488, 182501, 182502, 182521, 182528, 182533, 182535, 182538, 182539, 182540, 182558, 182568, 182579, 182589, 182592, 182607, 182809, 182829, 182936, 182937, 183037, 183049, 183051, 183099, 183112, 183113, 183114, 183116, 183146, 183147, 183159, 183160, 183161, 183163, 183164, 183165, 183180, 183265, 183338, 183339, 183340, 183341, 183343, 183345, 183346, 183355, 183362, 183363, 183368, 183369, 183370, 183371, 183372, 183373, 183374, 183375, 183376, 183377, 183378, 183379, 183380, 183381, 183382, 183383, 183398, 183413, 183414, 183437, 183438, 183442, 183454, 183455, 183456, 183457, 183458, 183459, 183460, 183461, 183491, 183492, 183493, 183496, 183788, 183805, 183806, 183807, 183808, 183821, 183840, 183841, 183852, 183882, 183883, 183894, 183896, 183922, 183934, 183936, 183940, 183941, 183961, 183962, 183963, 183964, 183965, 183985, 183986, 184009, 184010, 184016, 184017, 184018, 184026, 184027, 184028, 184029, 184030, 184031, 184032, 184033, 184034, 184035, 184036, 184037, 184051, 184053, 184054, 184069, 184072, 184092, 184114, 184115, 184125, 184126, 184144, 184294, 184304, 184305, 184317, 184318, 184319, 184322, 184324, 184325, 184326, 184327, 184328, 184329, 184331, 184332, 184384, 184385, 184386, 184387, 184388, 184389, 184390, 184391, 184392, 184393, 184397, 184401, 184416, 184449, 184458, 184466, 184478, 184500, 184501, 184566, 184567, 184591, 184594, 184596, 184597, 184612, 184632, 184666, 184667, 184668, 184669, 184670, 184671, 184672, 184673, 184674, 184685, 184740, 184793, 184802, 184816, 184867, 184926, 184974, 184976, 185015, 185018, 185102, 185103, 185104, 185105, 185119, 185125, 185127, 185131, 185132, 185137, 185138, 185146, 185169, 185292, 185298, 185322, 185394, 185395, 185396, 185397, 185398, 185399, 185400, 185401, 185402, 185403, 185404, 185405, 185406, 185407, 185408, 185409, 185410, 185411, 185412, 185413, 185414, 185415, 185416, 185417, 185418, 185419, 185420, 185421, 185422, 185423, 185424, 185425, 185426, 185427, 185428, 185429, 185430, 185431, 185432, 185439, 185440, 185441, 185442, 185443, 185444, 185445, 185446, 185447, 185478, 185479, 185480, 185481, 185482, 185483, 185485, 185486, 185487, 185488, 185489, 185490, 185501, 185550, 185882, 185883, 185884, 185885, 185886, 185887, 185888, 185892, 185905, 186031, 186032, 186043, 186044, 186053, 186054, 186083, 186135, 186136, 186152, 186153, 186179, 186180, 186181, 186182, 186218, 186234, 186243, 186251, 186261, 186262, 186272, 186273, 186278, 186283, 186287, 186406, 186407, 186472, 186607, 186614, 186615, 186618, 186679, 186720, 186728, 186858, 186972, 187115, 187457, 187697, 187986, 188013, 188108, 188216, 190040, 190047, 190069, 190071, 190084, 190103, 190217, 190334, 190335, 190475, 190487, 190488, 190589, 190598, 190599, 191028, 191029, 191030, 191310, 191440, 191460, 191461, 191462, 191463, 191464, 191465, 191466, 191467, 191468, 191469, 191470, 191471, 191472, 191474, 191475, 191476, 191477, 191478, 191479, 191480, 191481, 191482, 191510, 191665, 191679, 191680, 191682, 191683, 191684, 191731, 191733, 191741, 191768, 191769, 191886, 191887, 191888, 191889, 191890, 191891, 191892, 191893, 191894, 191895, 191896, 191897, 191898, 191899, 191900, 191901, 191902, 191903, 191904, 191941, 191943, 191945, 191946, 191947, 191948, 191949, 191955, 191956, 191957, 191988, 191989, 191990, 191991, 191992, 191993, 191994, 191995, 191997, 191998, 191999, 192059, 192068, 192069, 192070, 192083, 192084, 192085, 192086, 192087, 192093, 192094, 192095, 192096, 192097, 192098, 192099, 192102, 192103, 192109, 192110, 192111, 192112, 192113, 192114, 192116, 192117, 192121, 192122, 192219, 192220, 192235, 192242, 192267, 192268, 192274, 192406, 192440, 192443, 192444, 192449, 192450, 192498, 192582, 192583, 192584, 192600, 192601, 192625, 192627, 192628, 192629, 192686, 192697, 192823, 192825, 192836, 192842, 192843, 192844, 192845, 192846, 192847, 192848, 192849, 192850, 192851, 192852, 192853, 192854, 192855, 192856, 192882, 193071, 193080, 193081, 193082, 193083, 193084, 193085, 193088, 193172, 193178, 193184, 193205, 193422, 193423, 193604, 193782, 193783, 193784, 193785, 193786, 193787, 193904, 193909, 193910, 193911, 193912, 193913, 193914, 193926, 193928, 193930, 193931, 193942, 193985, 194011, 194019, 194020, 194025, 194026, 194054, 194082, 194115, 194148, 194232, 194253, 194255, 194261, 194262, 194264, 194274, 194276, 194300, 194316, 194360, 194361, 194362, 194363, 194364, 194365, 194416, 194437, 194441, 194442, 194462, 194481, 194484, 194519, 194541, 194542, 194543, 194553, 194554, 194555, 194556, 194557, 194558, 194559, 194560, 194565, 194569, 194625, 194630, 194631, 194634, 194635, 194636, 194637, 194663, 194664, 194665, 194666, 194675, 194704, 194705, 194706, 194707, 194715, 194716, 194739, 194740, 194741, 194742, 194743, 194744, 194745, 194746, 194747, 194748, 194749, 194750, 194752, 194767, 194773, 194774, 194775, 194776, 194904, 194905, 194907, 194910, 194911, 194912, 194913, 194914, 194915, 194959, 194960, 194962, 194963, 195063, 195066, 195067, 195068, 195069, 195087, 195090, 195119, 195121, 195130, 195131, 195132, 195133, 195144, 195145, 195149, 195150, 195151, 195152, 195153, 195154, 195155, 195156, 195157, 195158, 195164, 195191, 195192, 195194, 195195, 195196, 195197, 195198, 195199, 195200, 195212, 195215, 195222, 195232, 195235, 195237, 195276, 195303, 195307, 195313, 195314, 195315, 195316, 195320, 195326, 195327, 195331, 195332, 195333, 195334, 195335, 195336, 195337, 195338, 195339, 195340, 195341, 195342, 195343, 195371, 195376, 195377, 195391, 195392, 195393, 195396, 195398, 195402, 195403, 195410, 195411, 195412, 195413, 195414, 195415, 195416, 195417, 195418, 195430, 195437, 195439, 195491, 195664, 195701, 195702, 195703, 195705, 195706, 196399, 196400, 196401, 196404, 196412, 196413, 196472, 196841, 196846, 196849, 196850, 196851, 196854, 196866, 196867, 196868, 196869, 196879, 196880, 197333, 197338, 200296, 200297, 200305, 201295, 201296, 201297, 201298, 201608, 201609, 201697, 201905, 201925, 201931, 201932, 201933, 201968, 202113, 202216, 202217, 202434, 202591, 202600, 202601, 202602, 202616, 202618, 202624, 202625, 202626, 202627, 202628, 202629, 202630, 202631, 202632, 202633, 202634, 202635, 202636, 202637, 202638, 202639, 202640, 202641, 202642, 202643, 202644, 202645, 202646, 202648, 202665, 202666, 202667, 202668, 202669, 202670, 202671, 202672, 202673, 202674, 202675, 202676, 202677, 202678, 202679, 202680, 202681, 202682, 202683, 202684, 202685, 202686, 202687, 202688, 202689, 202690, 202691, 202692, 202693, 202694, 202695, 202696, 202711, 202712, 202724, 202802, 202803, 202804, 202805, 202811, 202812, 202813, 202814, 202816, 202817, 202833, 202834, 202835, 202839, 203030, 203049, 203050, 203051, 203052, 203053, 203054, 203057, 203058, 203059, 203060, 203112, 203451, 203839, 203840, 203841, 203843, 203844, 203845, 203846, 203847, 203848, 203849, 203851, 203852, 203856, 203857, 204135, 204181, 204328, 204346, 204347, 204350, 204358, 204395, 204398, 204423, 204588, 204589, 204590, 204598, 204612, 204614, 204615, 204616, 204617, 204618, 204619, 204635, 204637, 204638, 204643, 204678, 204679, 204680, 204681, 204684, 204685, 204689, 204694, 204695, 204696, 204698, 204706, 204707, 204708, 204719, 204940, 204941, 204986, 205005, 205006, 205007, 205009, 205010, 205011, 205012, 205013, 205014, 205015, 205018, 205024, 205025, 205028, 205029, 205030, 205031, 205032, 205033, 205040, 205041, 205046, 205068, 205076, 205090, 205435, 205436, 205437, 205438, 205439, 205440, 205441, 205442, 205443, 205444, 205445, 205446, 205447, 205448, 205449, 205450, 205451, 205452, 205453, 205454, 205455, 205456, 205457, 205458, 205459, 205460, 205461, 205462, 205463, 205464, 205465, 205466, 205467, 205468, 205469, 205528, 205529, 205530, 205531, 205532, 205533, 206576, 206586, 206589, 206590, 206598, 206693, 206738, 206843, 206844, 206845, 206885, 206896, 206897, 206910, 206986, 207092, 207093, 207206, 207210, 207215, 207280, 207329, 207330, 207391, 207417, 207474, 207479, 207487, 207529, 207631, 207633, 207636, 207646, 207687, 207688, 207689, 207703, 207704, 207736, 207941, 207965, 208001, 208054, 208069, 208072, 208078, 208125, 208147, 208186, 208198, 208200, 208210, 208211, 208212, 208213, 208214, 208215, 208218, 208219, 208220, 208221, 208222, 208223, 208227, 208394, 208395, 208420, 208444, 208449, 208454, 208676, 208685, 208700, 208712, 208772, 208833, 208864, 208963, 208965, 209064, 209065, 209076, 209094, 210282, 210542, 210545, 210807, 210915, 210930, 210943, 210948, 211126, 211138, 211180, 211181, 211287, 211288, 211321, 211338, 211342, 211344, 211345, 211346, 211349, 211361, 211476, 211513, 211541, 211559, 211598, 211707, 211712, 211796, 211860, 211898, 211900, 211901, 211911, 211912, 211914, 211915, 211916, 211917, 211919, 211920, 211921, 211922, 211923, 211924, 211925, 211926, 211927, 211928, 211929, 211930, 211931, 211932, 211933, 211934, 211935, 211936, 211937, 211938, 211939, 211940, 211941, 211942, 211943, 211944, 211945, 211946, 211947, 211948, 211949, 211950, 211951, 211952, 211954, 211957, 211965, 211990, 211993, 211996, 211997, 211998, 211999, 212000, 212001, 212002, 212043, 212044, 212045, 212046, 212157, 212159, 212185, 212190, 212191, 212192, 212193, 212209, 212224, 212228, 212283, 212284, 212285, 212286, 212287, 212288, 212489, 212496, 212499, 212500, 212503, 212506, 212693, 212735, 212767, 212768, 212859, 212887, 212892, 212897, 212964, 212965, 212966, 212967, 212970, 212971, 213004, 213143, 213249, 213286, 213287, 213301, 213317, 213318, 213320, 213321, 213322, 213323, 213324, 213328, 213329, 213331, 213332, 213333, 213410, 213412, 213422, 213436, 213438, 213461, 213502, 213685, 213690, 213691, 213694, 213695, 213698, 213699, 213701, 213717, 213803, 213811, 213846, 213852, 213885, 213887, 213976, 214062, 214102, 214103, 214104, 214139, 214140, 214141, 214142, 214144, 214145, 214146, 214169, 214220, 214234, 214254, 214255, 214256, 214257, 214266, 214275, 214276, 214346, 214347, 214348, 214349, 214378, 214440, 214499, 214515, 214545, 214546, 214614, 214630, 214631, 214635, 214636, 214639, 214640, 214723, 214740, 214748, 214749, 214756, 214758, 214791, 214833, 214840, 214864, 214890, 214891, 214892, 214897, 214898, 214902, 214903, 214904, 214905, 214966, 214978, 214979, 214987, 215068, 215069, 215074, 215075, 215081, 215185, 215187, 215317, 215683, 215684, 215686, 215687, 215692, 215693, 215768, 215797, 215831, 215843, 215844, 215849, 215850, 215859, 215860, 215882, 215915, 215967, 216162, 216163, 216307, 216477, 216679, 216706, 216883, 218070, 218209, 218210, 218211, 218212, 218213, 218214, 218215, 218216, 218217, 218218, 218219, 218220, 218221, 218222, 218223, 218226, 218227, 218228, 218229, 218230, 218231, 218232, 218233, 218234, 218235, 218236, 218237, 218238, 218239, 218240, 218241, 218242, 218243, 218244, 218245, 218246, 218247, 218248, 218249, 218250, 218251, 218252, 218253, 218254, 218255, 218256, 218257, 218258, 218259, 218260, 218261, 218262, 218263, 218264, 218265, 218266, 218267, 218268, 218269, 218270, 218271, 218272, 218273, 218274, 218275, 218276, 218277, 218278, 218279, 218280, 218281, 218282, 218283, 218284, 218285, 218286, 218287, 218288, 218289, 218290, 218291, 218292, 218293, 218294, 218295, 218296, 218297, 218298, 218299, 218300, 218301, 218302, 218303, 218304, 218305, 218306, 218307, 218308, 218309, 218310, 218311, 218312, 218313, 218314, 218315, 218316, 218317, 218318, 218319, 218320, 218321, 218322, 218323, 218324, 218325, 218326, 218327, 218328, 218329, 218330, 218331, 218332, 218333, 218334, 218335, 218336, 218337, 218338, 218339, 218340, 218341, 218342, 218343, 218344, 218345, 218346, 218347, 218348, 218349, 218350, 218351, 218352, 218353, 218354, 218355, 218356, 218357, 218358, 218359, 218360, 218361, 218362, 218363, 218364, 218365, 218366, 218367, 218368, 218369, 218370, 218951, 219095, 219099, 219227, 219228, 220069, 220087, 220165, 220174, 220906, 220907, 221037, 222794); +UPDATE `gameobject_template` SET `IconName`='GatherHerbs', `Data6`=0, `questItem1`=71035, `VerifiedBuild`=17538 WHERE `entry`=209059; -- Blood Nettle +UPDATE `gameobject_template` SET `IconName`='Inspect', `Data6`=0, `VerifiedBuild`=17538 WHERE `entry`=209870; -- STAY OUT - NO VISITORS +UPDATE `gameobject_template` SET `IconName`='Interact', `Data5`=16675, `VerifiedBuild`=17538 WHERE `entry`=214249; -- Great Banquet of the Oven +UPDATE `gameobject_template` SET `IconName`='inspect', `VerifiedBuild`=17538 WHERE `entry`=214572; -- Tablet of Thunder +UPDATE `gameobject_template` SET `castBarCaption`='Collecting', `Data14`=19676, `questItem1`=77432, `VerifiedBuild`=17538 WHERE `entry`=210085; -- Ancient Sutra +UPDATE `gameobject_template` SET `castBarCaption`='Collecting', `Data14`=19676, `questItem1`=77432, `VerifiedBuild`=17538 WHERE `entry`=210086; -- Ancient Sutra +UPDATE `gameobject_template` SET `castBarCaption`='Collecting', `Data14`=19676, `questItem1`=77452, `VerifiedBuild`=17538 WHERE `entry`=210087; -- Defender's Arrow +UPDATE `gameobject_template` SET `castBarCaption`='Collecting', `Data14`=19676, `questItem1`=80227, `VerifiedBuild`=17538 WHERE `entry`=211017; -- Root Vegetable +UPDATE `gameobject_template` SET `castBarCaption`='Collecting', `Data14`=19676, `questItem1`=83129, `VerifiedBuild`=17538 WHERE `entry`=214479; -- Shiny Egg +UPDATE `gameobject_template` SET `castBarCaption`='Collecting', `Data14`=19676, `questItem1`=83129, `VerifiedBuild`=17538 WHERE `entry`=214480; -- Shiny Egg +UPDATE `gameobject_template` SET `castBarCaption`='Collecting', `Data14`=19676, `questItem1`=83129, `VerifiedBuild`=17538 WHERE `entry`=214481; -- Shiny Egg +UPDATE `gameobject_template` SET `castBarCaption`='Collecting', `Data14`=19676, `questItem1`=83130, `VerifiedBuild`=17538 WHERE `entry`=212318; -- Shan'ze Tablet +UPDATE `gameobject_template` SET `castBarCaption`='Collecting', `Data14`=19676, `questItem1`=83130, `VerifiedBuild`=17538 WHERE `entry`=212319; -- Shan'ze Tablet +UPDATE `gameobject_template` SET `castBarCaption`='Collecting', `Data14`=19676, `questItem1`=85211, `VerifiedBuild`=17538 WHERE `entry`=212987; -- Spiny Starfish +UPDATE `gameobject_template` SET `castBarCaption`='Collecting', `Data14`=19676, `questItem1`=85211, `VerifiedBuild`=17538 WHERE `entry`=212988; -- Spiny Starfish +UPDATE `gameobject_template` SET `castBarCaption`='Collecting', `Data14`=19676, `questItem1`=85573, `VerifiedBuild`=17538 WHERE `entry`=213267; -- Dreadshade +UPDATE `gameobject_template` SET `castBarCaption`='Collecting', `Data14`=19676, `questItem1`=86431, `VerifiedBuild`=17538 WHERE `entry`=213795; -- Stormstout Secrets +UPDATE `gameobject_template` SET `castBarCaption`='Deactivating', `Data6`=1, `Data10`=127683, `Data13`=1, `Data14`=33516, `Data23`=1, `VerifiedBuild`=17538 WHERE `entry`=214477; -- Deactivate Final Spirit Wall +UPDATE `gameobject_template` SET `castBarCaption`='Digging', `Data14`=35059, `Data17`=15980, `questItem1`=80817, `VerifiedBuild`=17538 WHERE `entry`=211420; -- Lump of Sand +UPDATE `gameobject_template` SET `castBarCaption`='Fixing', `Data6`=65969, `VerifiedBuild`=17538 WHERE `entry`=214379; -- Broken Incense Burner +UPDATE `gameobject_template` SET `castBarCaption`='Gathering', `Data14`=24982, `questItem1`=81261, `VerifiedBuild`=17538 WHERE `entry`=211521; -- Blackmane Booty Barrel +UPDATE `gameobject_template` SET `castBarCaption`='Gathering', `Data14`=24982, `questItem1`=84779, `VerifiedBuild`=17538 WHERE `entry`=212902; -- Solidified Amber +UPDATE `gameobject_template` SET `castBarCaption`='Gathering', `Data5`=1, `Data10`=121264, `Data14`=24982, `Data17`=1, `Data22`=16699, `Data23`=1, `VerifiedBuild`=17538 WHERE `entry`=212131; -- Niuzao Food Supply +UPDATE `gameobject_template` SET `castBarCaption`='Gathering', `Data5`=1, `Data10`=121266, `Data14`=24982, `Data22`=16699, `Data23`=1, `VerifiedBuild`=17538 WHERE `entry`=212132; -- Niuzao Food Supply +UPDATE `gameobject_template` SET `castBarCaption`='Gathering', `Data5`=1, `Data10`=121269, `Data14`=24982, `Data22`=16699, `Data23`=1, `VerifiedBuild`=17538 WHERE `entry`=212133; -- Niuzao Food Supply +UPDATE `gameobject_template` SET `castBarCaption`='Gathering', `Data6`=0, `Data8`=29756, `Data14`=24982, `questItem1`=75214, `VerifiedBuild`=17538 WHERE `entry`=209825; -- Tidemist Cap +UPDATE `gameobject_template` SET `castBarCaption`='Gathering', `Data8`=30807, `Data14`=24982, `questItem1`=81269, `VerifiedBuild`=17538 WHERE `entry`=211526; -- Waterfall-Polished Stone +UPDATE `gameobject_template` SET `castBarCaption`='Grabbing', `Data5`=1, `Data6`=0, `Data10`=102879, `Data14`=37379, `Data22`=12776, `Data23`=1, `VerifiedBuild`=17538 WHERE `entry`=209551; -- Boiling Cauldron +UPDATE `gameobject_template` SET `castBarCaption`='Grabbing', `Data7`=210857, `Data14`=37379, `questItem1`=79039, `VerifiedBuild`=17538 WHERE `entry`=210858; -- Dry Fire Wood +UPDATE `gameobject_template` SET `castBarCaption`='Honoring', `Data10`=141464, `Data14`=57770, `Data22`=21636, `Data23`=1, `VerifiedBuild`=17538 WHERE `entry`=220365; -- Seer Hao Pham Roo's Leftover Rope +UPDATE `gameobject_template` SET `castBarCaption`='Looting', `Data14`=37733, `VerifiedBuild`=17538 WHERE `entry`=211326; -- Tap Tool +UPDATE `gameobject_template` SET `castBarCaption`='Opening', `Data13`=1, `Data14`=21400, `Data17`=15343, `Data26`=147919, `Data30`=49475, `VerifiedBuild`=17538 WHERE `entry`=223098; -- Moss-Covered Chest +UPDATE `gameobject_template` SET `castBarCaption`='Opening', `Data13`=1, `Data14`=21400, `Data17`=15343, `Data26`=147953, `Data30`=49476, `VerifiedBuild`=17538 WHERE `entry`=223114; -- Moss-Covered Chest +UPDATE `gameobject_template` SET `castBarCaption`='Opening', `Data13`=1, `Data14`=21400, `Data17`=15343, `Data26`=147956, `Data28`=1, `Data30`=49407, `VerifiedBuild`=17538 WHERE `entry`=221617; -- Skull-Covered Chest +UPDATE `gameobject_template` SET `castBarCaption`='Opening', `Data13`=1, `Data14`=21400, `Data17`=15343, `Data26`=147957, `Data30`=49407, `VerifiedBuild`=17538 WHERE `entry`=221671; -- Sturdy Chest +UPDATE `gameobject_template` SET `castBarCaption`='Opening', `Data13`=1, `Data14`=21400, `Data17`=15343, `Data26`=147958, `Data30`=49407, `VerifiedBuild`=17538 WHERE `entry`=223116; -- Sturdy Chest +UPDATE `gameobject_template` SET `castBarCaption`='Opening', `Data13`=1, `Data14`=21400, `Data17`=15343, `Data26`=147959, `Data30`=49407, `VerifiedBuild`=17538 WHERE `entry`=223117; -- Sturdy Chest +UPDATE `gameobject_template` SET `castBarCaption`='Opening', `Data13`=1, `Data14`=21400, `Data17`=15343, `Data26`=147962, `Data30`=49408, `VerifiedBuild`=17538 WHERE `entry`=221672; -- Smoldering Chest +UPDATE `gameobject_template` SET `castBarCaption`='Opening', `Data13`=1, `Data14`=21400, `Data17`=15343, `Data26`=147964, `Data30`=49408, `VerifiedBuild`=17538 WHERE `entry`=223119; -- Smoldering Chest +UPDATE `gameobject_template` SET `castBarCaption`='Opening', `Data13`=1, `Data14`=21400, `Data17`=15343, `Data26`=148393, `Data30`=49406, `VerifiedBuild`=17538 WHERE `entry`=223204; -- Moss-Covered Chest +UPDATE `gameobject_template` SET `castBarCaption`='Opening', `Data13`=1, `Data14`=21400, `Data17`=15343, `Data26`=151937, `Data28`=1, `Data30`=49413, `VerifiedBuild`=17538 WHERE `entry`=220908; -- Mist-Covered Treasure Chest +UPDATE `gameobject_template` SET `castBarCaption`='Opening', `Data13`=1, `Data14`=21400, `Data17`=22051, `Data26`=81040, `Data28`=1, `Data29`=51, `Data30`=48337, `VerifiedBuild`=17538 WHERE `entry`=220832; -- Sunken Treasure +UPDATE `gameobject_template` SET `castBarCaption`='Placing', `Data10`=124340, `Data14`=35196, `Data22`=17314, `Data23`=1, `VerifiedBuild`=17538 WHERE `entry`=213304; -- Sra'thik Idol +UPDATE `gameobject_template` SET `castBarCaption`='Placing', `Data10`=124370, `Data14`=35196, `Data22`=17314, `Data23`=1, `VerifiedBuild`=17538 WHERE `entry`=213309; -- Sra'thik Idol +UPDATE `gameobject_template` SET `castBarCaption`='Placing', `Data10`=124371, `Data14`=35196, `Data22`=17314, `Data23`=1, `VerifiedBuild`=17538 WHERE `entry`=213306; -- Sra'thik Idol +UPDATE `gameobject_template` SET `castBarCaption`='Placing', `Data10`=124391, `Data14`=35196, `Data22`=17315, `Data23`=1, `VerifiedBuild`=17538 WHERE `entry`=213307; -- Sra'thik Siege Weapon +UPDATE `gameobject_template` SET `castBarCaption`='Placing', `Data10`=124392, `Data14`=35196, `Data22`=17315, `Data23`=1, `VerifiedBuild`=17538 WHERE `entry`=213308; -- Sra'thik Siege Weapon +UPDATE `gameobject_template` SET `castBarCaption`='Placing', `Data10`=124393, `Data14`=35196, `Data22`=17315, `Data23`=1, `VerifiedBuild`=17538 WHERE `entry`=213310; -- Sra'thik Siege Weapon +UPDATE `gameobject_template` SET `castBarCaption`='Placing', `Data10`=124394, `Data14`=35196, `Data22`=17315, `Data23`=1, `VerifiedBuild`=17538 WHERE `entry`=213311; -- Sra'thik Siege Weapon +UPDATE `gameobject_template` SET `castBarCaption`='Retrieving', `Data14`=23645, `questItem1`=87790, `VerifiedBuild`=17538 WHERE `entry`=214394; -- Ancient Guo-Lai Artifact +UPDATE `gameobject_template` SET `castBarCaption`='Unlocking', `Data10`=115452, `Data14`=24815, `Data22`=15966, `Data23`=1, `VerifiedBuild`=17538 WHERE `entry`=211365; -- Ball and Chain +UPDATE `gameobject_template` SET `Data10`=1, `VerifiedBuild`=17538 WHERE `entry`=180376; -- Berserk Buff +UPDATE `gameobject_template` SET `Data10`=1, `VerifiedBuild`=17538 WHERE `entry`=184966; -- Berserk Buff +UPDATE `gameobject_template` SET `Data10`=1, `VerifiedBuild`=17538 WHERE `entry`=184972; -- Berserk Buff +UPDATE `gameobject_template` SET `Data10`=115716, `Data23`=1, `VerifiedBuild`=17538 WHERE `entry`=211445; -- Spare Raft +UPDATE `gameobject_template` SET `Data10`=118687, `Data23`=1, `VerifiedBuild`=17538 WHERE `entry`=211654; -- The Refreshing Bucket +UPDATE `gameobject_template` SET `Data10`=122122, `Data11`=1, `Data13`=1, `Data22`=16749, `Data23`=1, `VerifiedBuild`=17538 WHERE `entry`=213571; -- Shan'ze Cage +UPDATE `gameobject_template` SET `Data10`=122122, `Data11`=1, `Data13`=1, `Data22`=16749, `Data23`=1, `VerifiedBuild`=17538 WHERE `entry`=213572; -- Shan'ze Cage +UPDATE `gameobject_template` SET `Data10`=122122, `Data11`=1, `Data13`=1, `Data22`=16749, `Data23`=1, `VerifiedBuild`=17538 WHERE `entry`=213573; -- Shan'ze Cage +UPDATE `gameobject_template` SET `Data10`=122122, `Data11`=1, `Data13`=1, `Data22`=16749, `Data23`=1, `VerifiedBuild`=17538 WHERE `entry`=213574; -- Shan'ze Cage +UPDATE `gameobject_template` SET `Data10`=122122, `Data11`=1, `Data13`=1, `Data22`=16749, `Data23`=1, `VerifiedBuild`=17538 WHERE `entry`=213575; -- Shan'ze Cage +UPDATE `gameobject_template` SET `Data10`=122122, `Data11`=1, `Data13`=1, `Data22`=16749, `Data23`=1, `VerifiedBuild`=17538 WHERE `entry`=213576; -- Shan'ze Cage +UPDATE `gameobject_template` SET `Data10`=122122, `Data11`=1, `Data13`=1, `Data22`=16749, `Data23`=1, `VerifiedBuild`=17538 WHERE `entry`=213577; -- Shan'ze Cage +UPDATE `gameobject_template` SET `Data10`=122122, `Data11`=1, `Data13`=1, `Data22`=16749, `Data23`=1, `VerifiedBuild`=17538 WHERE `entry`=213578; -- Shan'ze Cage +UPDATE `gameobject_template` SET `Data10`=122122, `Data11`=1, `Data13`=1, `Data22`=16749, `Data23`=1, `VerifiedBuild`=17538 WHERE `entry`=213579; -- Shan'ze Cage +UPDATE `gameobject_template` SET `Data10`=122122, `Data11`=1, `Data13`=1, `Data22`=16749, `Data23`=1, `VerifiedBuild`=17538 WHERE `entry`=213580; -- Shan'ze Cage +UPDATE `gameobject_template` SET `Data10`=122122, `Data11`=1, `Data13`=1, `Data22`=16749, `Data23`=1, `VerifiedBuild`=17538 WHERE `entry`=213581; -- Shan'ze Cage +UPDATE `gameobject_template` SET `Data10`=122122, `Data11`=1, `Data13`=1, `Data22`=16749, `Data23`=1, `VerifiedBuild`=17538 WHERE `entry`=213582; -- Shan'ze Cage +UPDATE `gameobject_template` SET `Data10`=122122, `Data11`=1, `Data13`=1, `Data22`=16749, `Data23`=1, `VerifiedBuild`=17538 WHERE `entry`=213583; -- Shan'ze Cage +UPDATE `gameobject_template` SET `Data10`=122122, `Data11`=1, `Data13`=1, `Data22`=16749, `Data23`=1, `VerifiedBuild`=17538 WHERE `entry`=213584; -- Shan'ze Cage +UPDATE `gameobject_template` SET `Data10`=122122, `Data11`=1, `Data13`=1, `Data22`=16749, `Data23`=1, `VerifiedBuild`=17538 WHERE `entry`=213585; -- Shan'ze Cage +UPDATE `gameobject_template` SET `Data10`=122122, `Data11`=1, `Data13`=1, `Data22`=16749, `Data23`=1, `VerifiedBuild`=17538 WHERE `entry`=213586; -- Shan'ze Cage +UPDATE `gameobject_template` SET `Data10`=122122, `Data11`=1, `Data13`=1, `Data22`=16749, `Data23`=1, `VerifiedBuild`=17538 WHERE `entry`=213587; -- Shan'ze Cage +UPDATE `gameobject_template` SET `Data10`=122122, `Data11`=1, `Data13`=1, `Data22`=16749, `Data23`=1, `VerifiedBuild`=17538 WHERE `entry`=213588; -- Shan'ze Cage +UPDATE `gameobject_template` SET `Data10`=122122, `Data11`=1, `Data13`=1, `Data22`=16749, `Data23`=1, `VerifiedBuild`=17538 WHERE `entry`=213589; -- Shan'ze Cage +UPDATE `gameobject_template` SET `Data10`=122122, `Data11`=1, `Data13`=1, `Data22`=16749, `Data23`=1, `VerifiedBuild`=17538 WHERE `entry`=213590; -- Shan'ze Cage +UPDATE `gameobject_template` SET `Data10`=122122, `Data11`=1, `Data13`=1, `Data22`=16749, `Data23`=1, `VerifiedBuild`=17538 WHERE `entry`=213591; -- Shan'ze Cage +UPDATE `gameobject_template` SET `Data10`=122122, `Data11`=1, `Data13`=1, `Data22`=16749, `Data23`=1, `VerifiedBuild`=17538 WHERE `entry`=215570; -- Shan'ze Cage +UPDATE `gameobject_template` SET `Data10`=122122, `Data11`=1, `Data13`=1, `Data22`=16749, `Data23`=1, `VerifiedBuild`=17538 WHERE `entry`=215571; -- Shan'ze Cage +UPDATE `gameobject_template` SET `Data10`=122122, `Data11`=1, `Data13`=1, `Data22`=16749, `Data23`=1, `VerifiedBuild`=17538 WHERE `entry`=215572; -- Shan'ze Cage +UPDATE `gameobject_template` SET `Data10`=122122, `Data11`=1, `Data13`=1, `Data22`=16749, `Data23`=1, `VerifiedBuild`=17538 WHERE `entry`=215573; -- Shan'ze Cage +UPDATE `gameobject_template` SET `Data10`=122122, `Data11`=1, `Data13`=1, `Data22`=16749, `Data23`=1, `VerifiedBuild`=17538 WHERE `entry`=215574; -- Shan'ze Cage +UPDATE `gameobject_template` SET `Data10`=122122, `Data11`=1, `Data13`=1, `Data22`=16749, `Data23`=1, `VerifiedBuild`=17538 WHERE `entry`=215575; -- Shan'ze Cage +UPDATE `gameobject_template` SET `Data10`=122122, `Data11`=1, `Data13`=1, `Data22`=16749, `Data23`=1, `VerifiedBuild`=17538 WHERE `entry`=215576; -- Shan'ze Cage +UPDATE `gameobject_template` SET `Data10`=122122, `Data11`=1, `Data13`=1, `Data22`=16749, `Data23`=1, `VerifiedBuild`=17538 WHERE `entry`=215577; -- Shan'ze Cage +UPDATE `gameobject_template` SET `Data10`=122122, `Data11`=1, `Data13`=1, `Data22`=16749, `Data23`=1, `VerifiedBuild`=17538 WHERE `entry`=215578; -- Shan'ze Cage +UPDATE `gameobject_template` SET `Data10`=122122, `Data11`=1, `Data13`=1, `Data22`=16749, `Data23`=1, `VerifiedBuild`=17538 WHERE `entry`=215579; -- Shan'ze Cage +UPDATE `gameobject_template` SET `Data10`=122122, `Data11`=1, `Data13`=1, `Data22`=16749, `Data23`=1, `VerifiedBuild`=17538 WHERE `entry`=215580; -- Shan'ze Cage +UPDATE `gameobject_template` SET `Data10`=122122, `Data11`=1, `Data13`=1, `Data22`=16749, `Data23`=1, `VerifiedBuild`=17538 WHERE `entry`=215581; -- Shan'ze Cage +UPDATE `gameobject_template` SET `Data10`=122122, `Data11`=1, `Data13`=1, `Data22`=16749, `Data23`=1, `VerifiedBuild`=17538 WHERE `entry`=215582; -- Shan'ze Cage +UPDATE `gameobject_template` SET `Data10`=122122, `Data11`=1, `Data13`=1, `Data22`=16749, `Data23`=1, `VerifiedBuild`=17538 WHERE `entry`=215583; -- Shan'ze Cage +UPDATE `gameobject_template` SET `Data10`=122122, `Data11`=1, `Data13`=1, `Data22`=16749, `Data23`=1, `VerifiedBuild`=17538 WHERE `entry`=215584; -- Shan'ze Cage +UPDATE `gameobject_template` SET `Data10`=123164, `Data17`=1, `Data18`=1, `Data23`=1, `VerifiedBuild`=17538 WHERE `entry`=212779; -- Defiled Yaungol Remains +UPDATE `gameobject_template` SET `Data10`=123531, `Data22`=17063, `Data23`=1, `VerifiedBuild`=17538 WHERE `entry`=212933; -- Sonar Tower +UPDATE `gameobject_template` SET `Data10`=126662, `Data13`=1, `Data22`=17750, `Data23`=1, `VerifiedBuild`=17538 WHERE `entry`=214281; -- Kypari Ik Beacon +UPDATE `gameobject_template` SET `Data10`=129446, `Data22`=17574, `Data23`=1, `VerifiedBuild`=17538 WHERE `entry`=211597; -- Shrine of the Seeker's Body +UPDATE `gameobject_template` SET `Data10`=129448, `Data22`=17574, `Data23`=1, `VerifiedBuild`=17538 WHERE `entry`=211601; -- Shrine of the Seeker's Breath +UPDATE `gameobject_template` SET `Data10`=129452, `Data22`=17574, `Data23`=1, `VerifiedBuild`=17538 WHERE `entry`=211602; -- Shrine of the Seeker's Heart +UPDATE `gameobject_template` SET `Data10`=131450, `Data22`=19109, `Data23`=1, `VerifiedBuild`=17538 WHERE `entry`=215700; -- Northeast Feeder +UPDATE `gameobject_template` SET `Data10`=131450, `Data22`=19109, `Data23`=1, `VerifiedBuild`=17538 WHERE `entry`=215703; -- North Feeder +UPDATE `gameobject_template` SET `Data10`=131450, `Data22`=19109, `Data23`=1, `VerifiedBuild`=17538 WHERE `entry`=215761; -- East Feeder +UPDATE `gameobject_template` SET `Data10`=131450, `Data22`=19109, `Data23`=1, `VerifiedBuild`=17538 WHERE `entry`=215762; -- Central Feeder +UPDATE `gameobject_template` SET `Data10`=134254, `Data22`=19761, `Data23`=1, `VerifiedBuild`=17538 WHERE `entry`=216427; -- Hammer of Fellowship +UPDATE `gameobject_template` SET `Data10`=147279, `Data23`=1, `VerifiedBuild`=17538 WHERE `entry`=221615; -- Spirit Light +UPDATE `gameobject_template` SET `Data13`=1, `VerifiedBuild`=17538 WHERE `entry`=211313; -- Brew Tap +UPDATE `gameobject_template` SET `Data13`=1, `VerifiedBuild`=17538 WHERE `entry`=211314; -- Brew Tap +UPDATE `gameobject_template` SET `Data13`=1, `VerifiedBuild`=17538 WHERE `entry`=211315; -- Brew Tap +UPDATE `gameobject_template` SET `Data20`=70, `questItem1`=72663, `VerifiedBuild`=17538 WHERE `entry`=184849; -- Cache of the Legion +UPDATE `gameobject_template` SET `Data20`=80, `VerifiedBuild`=17538 WHERE `entry`=194201; -- Rare Cache of Winter +UPDATE `gameobject_template` SET `Data20`=80, `VerifiedBuild`=17538 WHERE `entry`=194308; -- Cache of Winter +UPDATE `gameobject_template` SET `Data20`=80, `VerifiedBuild`=17538 WHERE `entry`=194314; -- Cache of Storms +UPDATE `gameobject_template` SET `Data20`=80, `VerifiedBuild`=17538 WHERE `entry`=194331; -- Freya's Gift +UPDATE `gameobject_template` SET `Data20`=80, `VerifiedBuild`=17538 WHERE `entry`=194822; -- Gift of the Observer +UPDATE `gameobject_template` SET `Data20`=80, `VerifiedBuild`=17538 WHERE `entry`=194956; -- Cache of Innovation +UPDATE `gameobject_template` SET `Data20`=80, `VerifiedBuild`=17538 WHERE `entry`=195047; -- Cache of Living Stone +UPDATE `gameobject_template` SET `Data23`=600, `Data24`=600, `VerifiedBuild`=17538 WHERE `entry`=203078; -- Nerubian Archaeology Find +UPDATE `gameobject_template` SET `Data23`=600, `Data24`=600, `VerifiedBuild`=17538 WHERE `entry`=207187; -- Orc Archaeology Find +UPDATE `gameobject_template` SET `Data23`=600, `Data24`=600, `VerifiedBuild`=17538 WHERE `entry`=207188; -- Draenei Archaeology Find +UPDATE `gameobject_template` SET `Data23`=65, `Data24`=115, `VerifiedBuild`=17538 WHERE `entry`=3726; -- Earthroot +UPDATE `gameobject_template` SET `Data4`=1, `VerifiedBuild`=17538 WHERE `entry`=213747; -- NPC Fishing Bobber Ducky +UPDATE `gameobject_template` SET `Data4`=1, `Data16`=1, `VerifiedBuild`=17538 WHERE `entry`=210857; -- Dry Fire Wood +UPDATE `gameobject_template` SET `Data4`=1, `Data16`=1, `VerifiedBuild`=17538 WHERE `entry`=210981; -- Melon Trap +UPDATE `gameobject_template` SET `Data4`=1, `Data5`=1, `Data17`=17797, `Data18`=86, `Data19`=8, `Data26`=127188, `VerifiedBuild`=17538 WHERE `entry`=213651; -- Equipment Locker +UPDATE `gameobject_template` SET `Data4`=1, `Data5`=1, `Data17`=17814, `Data18`=89, `Data19`=8, `Data26`=127211, `VerifiedBuild`=17538 WHERE `entry`=213961; -- Abandoned Crate of Goods +UPDATE `gameobject_template` SET `Data4`=1, `Data5`=1, `Data18`=85, `Data19`=8, `Data26`=127181, `VerifiedBuild`=17538 WHERE `entry`=213742; -- Hammer of Ten Thunders +UPDATE `gameobject_template` SET `Data4`=1, `Data5`=1, `Data18`=86, `Data19`=6, `Data26`=127179, `VerifiedBuild`=17538 WHERE `entry`=213741; -- Ancient Jinyu Staff +UPDATE `gameobject_template` SET `Data4`=1, `Data5`=1, `Data18`=86, `Data19`=8, `Data26`=127187, `VerifiedBuild`=17538 WHERE `entry`=213653; -- Pandaren Fishing Spear +UPDATE `gameobject_template` SET `Data4`=1, `Data5`=1, `Data18`=87, `Data19`=6, `Data26`=127190, `VerifiedBuild`=17538 WHERE `entry`=214439; -- Barrel of Banana Infused Rum +UPDATE `gameobject_template` SET `Data4`=1, `Data5`=1, `Data18`=87, `Data19`=8, `Data26`=127197, `VerifiedBuild`=17538 WHERE `entry`=213765; -- Tablet of Ren Yun +UPDATE `gameobject_template` SET `Data4`=1, `Data5`=1, `Data18`=89, `Data19`=8, `Data26`=127214, `VerifiedBuild`=17538 WHERE `entry`=213962; -- Wind-Reaver's Dagger of Quick Strikes +UPDATE `gameobject_template` SET `Data4`=1, `Data5`=1, `Data18`=89, `Data19`=8, `Data26`=127217, `VerifiedBuild`=17538 WHERE `entry`=213966; -- Amber Encased Necklace +UPDATE `gameobject_template` SET `Data4`=1, `Data5`=1, `Data18`=89, `Data19`=8, `Data26`=132607, `VerifiedBuild`=17538 WHERE `entry`=213971; -- Swarmkeeper's Medallion +UPDATE `gameobject_template` SET `Data4`=1, `Data5`=1, `Data6`=0, `Data18`=85, `Data19`=1, `Data23`=600, `Data24`=615, `VerifiedBuild`=17538 WHERE `entry`=209329; -- Rich Kyparite Deposit +UPDATE `gameobject_template` SET `Data4`=1, `Data5`=1, `Data6`=0, `Data18`=85, `Data19`=1, `Data23`=605, `Data24`=620, `VerifiedBuild`=17538 WHERE `entry`=209330; -- Rich Trillium Vein +UPDATE `gameobject_template` SET `Data4`=1, `Data5`=1, `Data7`=212348, `Data18`=85, `Data19`=1, `Data23`=600, `Data24`=600, `questItem1`=79049, `VerifiedBuild`=17538 WHERE `entry`=211163; -- Pandaren Archaeology Find +UPDATE `gameobject_template` SET `Data4`=1, `Data5`=1, `Data7`=212348, `Data18`=85, `Data19`=1, `Data23`=600, `Data24`=600, `questItem1`=79049, `VerifiedBuild`=17538 WHERE `entry`=211174; -- Mogu Archaeology Find +UPDATE `gameobject_template` SET `Data4`=1, `Data5`=1, `Data7`=212348, `Data18`=85, `Data19`=1, `Data23`=600, `Data24`=600, `questItem1`=79049, `VerifiedBuild`=17538 WHERE `entry`=218950; -- Mantid Archaeology Find +UPDATE `gameobject_template` SET `Data4`=1, `Data5`=1, `Data7`=215404, `Data18`=85, `Data19`=1, `Data23`=575, `Data24`=600, `VerifiedBuild`=17538 WHERE `entry`=215403; -- Sha-Touched Herb +UPDATE `gameobject_template` SET `Data4`=1, `Data5`=1, `Data7`=215404, `Data18`=85, `Data19`=1, `Data23`=575, `Data24`=600, `VerifiedBuild`=17538 WHERE `entry`=215411; -- Sha-Touched Herb +UPDATE `gameobject_template` SET `Data4`=1, `Data5`=16313, `Data6`=1, `VerifiedBuild`=17538 WHERE `entry`=211642; -- Lucky Golden Coin +UPDATE `gameobject_template` SET `Data4`=1, `Data5`=17058, `Data6`=1, `VerifiedBuild`=17538 WHERE `entry`=212926; -- Stone Monolith +UPDATE `gameobject_template` SET `Data4`=1, `Data5`=17059, `Data6`=1, `VerifiedBuild`=17538 WHERE `entry`=212925; -- Stone Monolith +UPDATE `gameobject_template` SET `Data4`=1, `Data5`=17060, `Data6`=1, `VerifiedBuild`=17538 WHERE `entry`=212924; -- Stone Monolith +UPDATE `gameobject_template` SET `Data4`=1, `Data7`=2, `Data9`=1, `Data14`=1, `Data16`=1, `VerifiedBuild`=17538 WHERE `entry`=214842; -- Ancient Rune of Striking +UPDATE `gameobject_template` SET `Data4`=1, `Data7`=4, `VerifiedBuild`=17538 WHERE `entry`=214541; -- Kunchong Trap +UPDATE `gameobject_template` SET `Data4`=1628, `VerifiedBuild`=17538 WHERE `entry`=211423; -- Shipwreck Debris +UPDATE `gameobject_template` SET `Data4`=1628, `VerifiedBuild`=17538 WHERE `entry`=218632; -- Large Swarm of Panicked Paddlefish +UPDATE `gameobject_template` SET `Data4`=1628, `VerifiedBuild`=17538 WHERE `entry`=218633; -- Brew Frenzied Emperor Salmon +UPDATE `gameobject_template` SET `Data4`=1628, `VerifiedBuild`=17538 WHERE `entry`=218634; -- Large Pool of Brew Frenzied Emperor Salmon +UPDATE `gameobject_template` SET `Data4`=1628, `VerifiedBuild`=17538 WHERE `entry`=218652; -- Glimmering Jewel Danio Pool +UPDATE `gameobject_template` SET `Data4`=2, `Data16`=1, `VerifiedBuild`=17538 WHERE `entry`=211428; -- Riverblade Spike Trap +UPDATE `gameobject_template` SET `Data4`=217, `Data5`=11471, `Data7`=6, `VerifiedBuild`=17538 WHERE `entry`=214442; -- Instance Portal (Raid 4 Difficulties) +UPDATE `gameobject_template` SET `Data4`=217, `Data7`=5, `VerifiedBuild`=17538 WHERE `entry`=214524; -- Instance Portal (Raid 10/25 No Heroic) +UPDATE `gameobject_template` SET `Data4`=5676324, `VerifiedBuild`=17538 WHERE `entry`=212906; -- Doodad_bonfirenorthrend_001 +UPDATE `gameobject_template` SET `Data4`=5687288, `VerifiedBuild`=17538 WHERE `entry`=214970; -- Brazier +UPDATE `gameobject_template` SET `Data4`=5687288, `VerifiedBuild`=17538 WHERE `entry`=214971; -- Brazier +UPDATE `gameobject_template` SET `Data4`=5687288, `VerifiedBuild`=17538 WHERE `entry`=214972; -- Brazier +UPDATE `gameobject_template` SET `Data4`=5687288, `VerifiedBuild`=17538 WHERE `entry`=214973; -- Brazier +UPDATE `gameobject_template` SET `Data4`=5705884, `VerifiedBuild`=17538 WHERE `entry`=212325; -- Doodad_hz_camp_fire_001 +UPDATE `gameobject_template` SET `Data5`=-1, `VerifiedBuild`=17538 WHERE `entry`=218203; -- Doodad_SubwayCar02 +UPDATE `gameobject_template` SET `Data5`=-1, `VerifiedBuild`=17538 WHERE `entry`=218204; -- Doodad_SubwayCar09 +UPDATE `gameobject_template` SET `Data5`=-1, `VerifiedBuild`=17538 WHERE `entry`=218205; -- Doodad_SubwayCar11 +UPDATE `gameobject_template` SET `Data5`=-1, `VerifiedBuild`=17538 WHERE `entry`=218206; -- Doodad_SubwayCar12 +UPDATE `gameobject_template` SET `Data5`=-1, `VerifiedBuild`=17538 WHERE `entry`=218208; -- Doodad_SubwayCar01 +UPDATE `gameobject_template` SET `Data5`=-1, `Data6`=58633, `Data8`=71667, `Data10`=130300, `VerifiedBuild`=17538 WHERE `entry`=218207; -- Doodad_SubwayCar13 +UPDATE `gameobject_template` SET `Data5`=0, `VerifiedBuild`=17538 WHERE `entry`=194370; -- Tower of Frost +UPDATE `gameobject_template` SET `Data5`=0, `VerifiedBuild`=17538 WHERE `entry`=194371; -- Tower of Flames +UPDATE `gameobject_template` SET `Data5`=0, `VerifiedBuild`=17538 WHERE `entry`=194375; -- Tower of Life +UPDATE `gameobject_template` SET `Data5`=0, `VerifiedBuild`=17538 WHERE `entry`=194377; -- Tower of Storms +UPDATE `gameobject_template` SET `Data5`=0, `VerifiedBuild`=17538 WHERE `entry`=194398; -- Storm Beacon +UPDATE `gameobject_template` SET `Data5`=0, `VerifiedBuild`=17538 WHERE `entry`=194399; -- Storm Beacon +UPDATE `gameobject_template` SET `Data5`=0, `VerifiedBuild`=17538 WHERE `entry`=194400; -- Storm Beacon +UPDATE `gameobject_template` SET `Data5`=0, `VerifiedBuild`=17538 WHERE `entry`=194401; -- Storm Beacon +UPDATE `gameobject_template` SET `Data5`=0, `VerifiedBuild`=17538 WHERE `entry`=194402; -- Storm Beacon +UPDATE `gameobject_template` SET `Data5`=0, `VerifiedBuild`=17538 WHERE `entry`=194403; -- Storm Beacon +UPDATE `gameobject_template` SET `Data5`=0, `VerifiedBuild`=17538 WHERE `entry`=194404; -- Storm Beacon +UPDATE `gameobject_template` SET `Data5`=0, `VerifiedBuild`=17538 WHERE `entry`=194405; -- Storm Beacon +UPDATE `gameobject_template` SET `Data5`=0, `VerifiedBuild`=17538 WHERE `entry`=194406; -- Storm Beacon +UPDATE `gameobject_template` SET `Data5`=0, `VerifiedBuild`=17538 WHERE `entry`=194407; -- Storm Beacon +UPDATE `gameobject_template` SET `Data5`=0, `VerifiedBuild`=17538 WHERE `entry`=194408; -- Storm Beacon +UPDATE `gameobject_template` SET `Data5`=0, `VerifiedBuild`=17538 WHERE `entry`=194409; -- Storm Beacon +UPDATE `gameobject_template` SET `Data5`=0, `VerifiedBuild`=17538 WHERE `entry`=194410; -- Storm Beacon +UPDATE `gameobject_template` SET `Data5`=0, `VerifiedBuild`=17538 WHERE `entry`=194411; -- Storm Beacon +UPDATE `gameobject_template` SET `Data5`=0, `VerifiedBuild`=17538 WHERE `entry`=194412; -- Storm Beacon +UPDATE `gameobject_template` SET `Data5`=0, `VerifiedBuild`=17538 WHERE `entry`=194413; -- Storm Beacon +UPDATE `gameobject_template` SET `Data5`=0, `VerifiedBuild`=17538 WHERE `entry`=194414; -- Storm Beacon +UPDATE `gameobject_template` SET `Data5`=0, `VerifiedBuild`=17538 WHERE `entry`=194415; -- Storm Beacon +UPDATE `gameobject_template` SET `Data5`=0, `VerifiedBuild`=17538 WHERE `entry`=194506; -- Storm Beacon +UPDATE `gameobject_template` SET `Data5`=0, `VerifiedBuild`=17538 WHERE `entry`=195494; -- Horde Gate +UPDATE `gameobject_template` SET `Data5`=0, `VerifiedBuild`=17538 WHERE `entry`=195495; -- Horde Gate +UPDATE `gameobject_template` SET `Data5`=0, `VerifiedBuild`=17538 WHERE `entry`=195496; -- Horde Gate +UPDATE `gameobject_template` SET `Data5`=0, `VerifiedBuild`=17538 WHERE `entry`=195698; -- Alliance Gate +UPDATE `gameobject_template` SET `Data5`=0, `VerifiedBuild`=17538 WHERE `entry`=195699; -- Alliance Gate +UPDATE `gameobject_template` SET `Data5`=0, `VerifiedBuild`=17538 WHERE `entry`=195700; -- Alliance Gate +UPDATE `gameobject_template` SET `Data5`=1, `Data10`=112954, `Data23`=1, `VerifiedBuild`=17538 WHERE `entry`=211319; -- Relief Bucket +UPDATE `gameobject_template` SET `Data5`=1, `Data10`=118681, `Data22`=19282, `Data23`=1, `VerifiedBuild`=17538 WHERE `entry`=211653; -- Chair +UPDATE `gameobject_template` SET `Data5`=1, `Data10`=130231, `Data23`=1, `VerifiedBuild`=17538 WHERE `entry`=215134; -- Applebloom Cider +UPDATE `gameobject_template` SET `Data5`=1, `Data10`=130806, `Data22`=16752, `Data23`=1, `VerifiedBuild`=17538 WHERE `entry`=212324; -- Mogu Burial Urn +UPDATE `gameobject_template` SET `Data5`=1, `Data10`=131413, `Data22`=19101, `VerifiedBuild`=17538 WHERE `entry`=215695; -- Barrel of Honeybrew +UPDATE `gameobject_template` SET `Data5`=1, `Data10`=149345, `Data23`=1, `VerifiedBuild`=17538 WHERE `entry`=223538; -- Riverspeaker's Trident +UPDATE `gameobject_template` SET `Data5`=1, `Data22`=19763, `VerifiedBuild`=17538 WHERE `entry`=216360; -- Untamed Amber +UPDATE `gameobject_template` SET `Data5`=1, `Data8`=19442, `Data11`=1, `Data12`=1000, `VerifiedBuild`=17538 WHERE `entry`=212091; -- Orb of Power +UPDATE `gameobject_template` SET `Data5`=1, `Data8`=19442, `Data11`=1, `Data12`=1000, `VerifiedBuild`=17538 WHERE `entry`=212092; -- Orb of Power +UPDATE `gameobject_template` SET `Data5`=1, `Data8`=19442, `Data11`=1, `Data12`=1000, `VerifiedBuild`=17538 WHERE `entry`=212093; -- Orb of Power +UPDATE `gameobject_template` SET `Data5`=1, `Data8`=19442, `Data11`=1, `Data12`=1000, `VerifiedBuild`=17538 WHERE `entry`=212094; -- Orb of Power +UPDATE `gameobject_template` SET `Data5`=12774, `Data6`=1, `VerifiedBuild`=17538 WHERE `entry`=209550; -- Blushleaf Cluster +UPDATE `gameobject_template` SET `Data5`=17004, `Data6`=1, `VerifiedBuild`=17538 WHERE `entry`=212900; -- Cho's Teapot +UPDATE `gameobject_template` SET `Data5`=17580, `Data6`=1, `VerifiedBuild`=17538 WHERE `entry`=213191; -- Bird Feed +UPDATE `gameobject_template` SET `Data5`=22184, `VerifiedBuild`=17538 WHERE `entry`=194086; -- Seaforium Bomb +UPDATE `gameobject_template` SET `Data5`=5681380, `VerifiedBuild`=17538 WHERE `entry`=213697; -- Bench +UPDATE `gameobject_template` SET `Data5`=5681380, `VerifiedBuild`=17538 WHERE `entry`=213703; -- Banner +UPDATE `gameobject_template` SET `Data5`=5687288, `VerifiedBuild`=17538 WHERE `entry`=214954; -- Doodad_hz_cage_006 +UPDATE `gameobject_template` SET `Data5`=5687288, `VerifiedBuild`=17538 WHERE `entry`=214955; -- Doodad_hz_cage_007 +UPDATE `gameobject_template` SET `Data5`=5687288, `VerifiedBuild`=17538 WHERE `entry`=214956; -- Doodad_hz_cage_008 +UPDATE `gameobject_template` SET `Data5`=5687288, `VerifiedBuild`=17538 WHERE `entry`=214957; -- Doodad_hz_cage_009 +UPDATE `gameobject_template` SET `Data5`=5687288, `VerifiedBuild`=17538 WHERE `entry`=214958; -- Doodad_hz_cage_010 +UPDATE `gameobject_template` SET `Data5`=5687288, `VerifiedBuild`=17538 WHERE `entry`=214959; -- Doodad_hz_cage_011 +UPDATE `gameobject_template` SET `Data5`=5687288, `VerifiedBuild`=17538 WHERE `entry`=214960; -- Doodad_hz_cage_012 +UPDATE `gameobject_template` SET `Data5`=5705884, `VerifiedBuild`=17538 WHERE `entry`=211527; -- Doodad_Mogu_Tile_Lightning001 +UPDATE `gameobject_template` SET `Data5`=5705884, `VerifiedBuild`=17538 WHERE `entry`=211528; -- Doodad_Mogu_Tile_Lightning001 +UPDATE `gameobject_template` SET `Data5`=5705884, `VerifiedBuild`=17538 WHERE `entry`=212376; -- Doodad_PA_brazier_30 +UPDATE `gameobject_template` SET `Data5`=923, `VerifiedBuild`=17538 WHERE `entry`=215112; -- Dalaran +UPDATE `gameobject_template` SET `Data5`=923, `VerifiedBuild`=17538 WHERE `entry`=215113; -- Shattrath +UPDATE `gameobject_template` SET `Data6`=0 WHERE `entry` > 210000 AND `VerifiedBuild`=-18019; +UPDATE `gameobject_template` SET `Data6`=0, `VerifiedBuild`=17538 WHERE `entry`=180701; -- Hay Bale 2 +UPDATE `gameobject_template` SET `Data6`=0, `VerifiedBuild`=17538 WHERE `entry`=209628; -- Mogu Altar +UPDATE `gameobject_template` SET `Data6`=0, `VerifiedBuild`=17538 WHERE `entry`=209779; -- Meditation Candle +UPDATE `gameobject_template` SET `Data6`=0, `VerifiedBuild`=17538 WHERE `entry`=209786; -- Pungent Ritual Candle Prop +UPDATE `gameobject_template` SET `Data6`=0, `VerifiedBuild`=17538 WHERE `entry`=209787; -- Chipped Ritual Bowl Prop +UPDATE `gameobject_template` SET `Data6`=0, `VerifiedBuild`=17538 WHERE `entry`=209788; -- Jade Cong Prop +UPDATE `gameobject_template` SET `Data6`=0, `VerifiedBuild`=17538 WHERE `entry`=209814; -- Broken Pottery +UPDATE `gameobject_template` SET `Data6`=0, `VerifiedBuild`=17538 WHERE `entry`=209815; -- Broken Pottery +UPDATE `gameobject_template` SET `Data6`=0, `VerifiedBuild`=17538 WHERE `entry`=209845; -- Mouthwatering Brew +UPDATE `gameobject_template` SET `Data6`=0, `VerifiedBuild`=17538 WHERE `entry`=209850; -- Meditation Candle +UPDATE `gameobject_template` SET `Data6`=0, `VerifiedBuild`=17538 WHERE `entry`=209851; -- Meditation Candle +UPDATE `gameobject_template` SET `Data6`=0, `VerifiedBuild`=17538 WHERE `entry`=209852; -- Meditation Candle +UPDATE `gameobject_template` SET `Data6`=0, `VerifiedBuild`=17538 WHERE `entry`=209853; -- Soothing Incense +UPDATE `gameobject_template` SET `Data6`=0, `VerifiedBuild`=17538 WHERE `entry`=209855; -- Slicky String +UPDATE `gameobject_template` SET `Data6`=0, `VerifiedBuild`=17538 WHERE `entry`=209918; -- Anvil +UPDATE `gameobject_template` SET `Data6`=0, `VerifiedBuild`=17538 WHERE `entry`=209919; -- Forge +UPDATE `gameobject_template` SET `Data6`=0, `Data9`=1, `VerifiedBuild`=17538 WHERE `entry`=209578; -- Unstable Solenoid +UPDATE `gameobject_template` SET `Data6`=0, `questItem1`=74760, `VerifiedBuild`=17538 WHERE `entry`=209700; -- Chipped Ritual Bowl +UPDATE `gameobject_template` SET `Data6`=0, `questItem1`=74761, `VerifiedBuild`=17538 WHERE `entry`=209701; -- Pungent Ritual Candle +UPDATE `gameobject_template` SET `Data6`=0, `questItem1`=74762, `VerifiedBuild`=17538 WHERE `entry`=209699; -- Jade Cong +UPDATE `gameobject_template` SET `Data6`=0, `questItem1`=76209, `VerifiedBuild`=17538 WHERE `entry`=209863; -- Chunk of Jade +UPDATE `gameobject_template` SET `Data6`=1, `VerifiedBuild`=17538 WHERE `entry`=220360; -- Remote Viewing Console +UPDATE `gameobject_template` SET `Data6`=1, `Data10`=121798, `Data23`=1, `VerifiedBuild`=17538 WHERE `entry`=212229; -- Shado-Pan Rope +UPDATE `gameobject_template` SET `Data6`=1, `Data10`=130559, `Data23`=1, `VerifiedBuild`=17538 WHERE `entry`=215393; -- Shado-Pan Rope +UPDATE `gameobject_template` SET `Data6`=10000, `Data8`=1, `Data9`=3000, `VerifiedBuild`=17538 WHERE `entry`=184142; -- Netherstorm Flag +UPDATE `gameobject_template` SET `Data6`=16159, `VerifiedBuild`=17538 WHERE `entry`=211514; -- Mist-Shaman's Torch +UPDATE `gameobject_template` SET `Data6`=30, `Data10`=108905, `Data22`=13510, `Data23`=1, `VerifiedBuild`=17538 WHERE `entry`=210116; -- Bell of a Thousand Whispers +UPDATE `gameobject_template` SET `Data6`=32010, `Data17`=16591, `questItem1`=82764, `VerifiedBuild`=17538 WHERE `entry`=211967; -- King's Coffer +UPDATE `gameobject_template` SET `Data7`=1, `VerifiedBuild`=17538 WHERE `entry`=220867; -- Really Skunky Beer +UPDATE `gameobject_template` SET `Data7`=5793, `VerifiedBuild`=17538 WHERE `entry`=216719; -- Mogu Crypt Door +UPDATE `gameobject_template` SET `Data8`=1, `VerifiedBuild`=17538 WHERE `entry`=211132; -- Sliding Door +UPDATE `gameobject_template` SET `Data8`=1, `VerifiedBuild`=17538 WHERE `entry`=211133; -- Sliding Door +UPDATE `gameobject_template` SET `Data8`=1, `VerifiedBuild`=17538 WHERE `entry`=211134; -- Sliding Door +UPDATE `gameobject_template` SET `Data8`=1, `VerifiedBuild`=17538 WHERE `entry`=211135; -- Sliding Door +UPDATE `gameobject_template` SET `Data8`=1, `VerifiedBuild`=17538 WHERE `entry`=211136; -- Sliding Door +UPDATE `gameobject_template` SET `Data8`=1, `VerifiedBuild`=17538 WHERE `entry`=211137; -- Sliding Door +UPDATE `gameobject_template` SET `Data8`=1, `Data9`=1, `VerifiedBuild`=17538 WHERE `entry`=212181; -- Ancient Statue +UPDATE `gameobject_template` SET `Data8`=31119, `Data16`=1, `Data17`=18153, `questItem1`=84762, `VerifiedBuild`=17538 WHERE `entry`=212877; -- Highly Explosive Yaungol Oil Barrel +UPDATE `gameobject_template` SET `Data9`=1, `VerifiedBuild`=17538 WHERE `entry`=214473; -- Spirit Wall +UPDATE `gameobject_template` SET `Data9`=2, `Data13`=1, `Data17`=1, `Data19`=13123, `Data22`=12861, `VerifiedBuild`=17538 WHERE `entry`=212182; -- Ancient Statue Torso +UPDATE `gameobject_template` SET `Data9`=2, `Data13`=1, `Data17`=1, `Data19`=13125, `VerifiedBuild`=17538 WHERE `entry`=212183; -- Ancient Statue Arm +UPDATE `gameobject_template` SET `Data9`=2, `Data13`=1, `Data17`=1, `Data19`=13126, `VerifiedBuild`=17538 WHERE `entry`=212184; -- Ancient Statue Shoulder +UPDATE `gameobject_template` SET `Data9`=2, `Data13`=1, `Data17`=1, `Data19`=13127, `VerifiedBuild`=17538 WHERE `entry`=212186; -- Ancient Statue Head |