diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2024_11_05_04_world.sql | 62 |
1 files changed, 62 insertions, 0 deletions
diff --git a/sql/updates/world/master/2024_11_05_04_world.sql b/sql/updates/world/master/2024_11_05_04_world.sql new file mode 100644 index 00000000000..1b75f05b760 --- /dev/null +++ b/sql/updates/world/master/2024_11_05_04_world.sql @@ -0,0 +1,62 @@ +-- Creature templates +UPDATE `creature_template` SET `unit_flags3`=0x5000000 WHERE `entry`=109860; -- Crooked Tree Crow +UPDATE `creature_template` SET `speed_run`=0.857142865657806396, `unit_flags`=0x2000000, `unit_flags3`=0x80000 WHERE `entry`=54148; -- Eerie Spider (H) +UPDATE `creature_template` SET `unit_flags`=0x100 WHERE `entry`=54142; -- Hired Courier + +UPDATE `creature_template_difficulty` SET `StaticFlags1`=0x10080000, `VerifiedBuild`=57388 WHERE (`Entry`=54142 AND `DifficultyID`=0); -- 54142 (Hired Courier) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=81, `StaticFlags1`=0x10080000, `VerifiedBuild`=57388 WHERE (`Entry`=54148 AND `DifficultyID`=0); -- 54148 (Eerie Spider (H)) - Amphibious, CanSwim + +UPDATE `waypoint_path` SET `Comment`='Black Cat - Cosmetic Path' WHERE `PathId`=2281600; +UPDATE `waypoint_path_node` SET `Delay`=10 WHERE `PathId`=2281600 AND `NodeId` IN (0,1); +UPDATE `waypoint_path` SET `Flags`=0x2, `Velocity`=1.75, `Comment`='Crooked Tree Crow - Cyclic Path' WHERE `PathId` BETWEEN 10986000 AND 10986004; + +-- Gameobject templates +UPDATE `gameobject_template` SET `VerifiedBuild`=57388 WHERE `entry` IN (165637, 164840, 178226, 2727, 2726, 2722, 207474, 208060, 2728, 103748, 2729, 2713, 148865, 2695, 2687, 2661, 103749, 2665, 103750, 181053, 208067, 208073, 202879, 177224, 2666, 205947, 205946, 205945, 203758, 203759, 208076, 208075, 185455, 205894, 207158, 205821, 205823, 207162, 204917, 207571, 207649, 202569, 207651, 207648, 207655, 207348, 207614, 208312, 207263, 207259, 207426, 205111, 207227, 208827, 207277, 207859, 207858, 205248, 204952, 208077, 208209, 204950, 204949, 204951, 205250, 208311, 205538, 206411, 206410, 206408, 206387, 205852, 205851, 205850, 205849, 205848, 205847, 205846, 205844, 205845, 207495, 206203, 205370, 206696, 205842, 205841, 205840, 202659, 205843, 205822, 205550, 205551, 205549, 206292, 206199, 210038, 206957, 204880, 206673, 206672, 206389, 190192, 204931, 204415, 204416, 204933, 204417, 204932, 204930, 205357, 205355, 202777, 202751, 206557, 205944, 205943, 205942, 205863, 205862, 205861, 205860, 205859, 205858, 205857, 205838, 206328, 206757, 205909, 205839, 205837, 205836, 206414, 206413, 206412, 205910, 205907, 205906, 205905, 205904, 205908, 205903, 206417, 206416, 206415, 205856, 205854, 205855, 205853, 207298, 206329, 206105, 206291, 206290, 206289, 206195, 206841, 206839, 203475, 203476, 184396, 184395, 204918, 202737, 202747, 202738, 202976, 202978, 202977, 177666, 1875, 1879, 1876, 203282, 1878, 1877, 1628, 203264, 1867, 208088, 1868, 1866, 164890, 204100, 1870, 205488, 205487, 202934, 205489, 203288, 203287, 203283, 1869, 331, 203286, 203285, 179486, 203237, 180662, 35591, 148866, 142094, 138614, 61925, 61924, 61923, 61922, 61921, 61920, 61919, 20986, 2010, 177507, 177505, 177508, 177513, 177511, 177510, 177509, 177506, 203247, 177514, 177512, 2734, 171645, 171644, 171643, 171642, 171641, 171640, 171638, 171639, 171673, 171672, 171671, 171670, 171669, 171668, 171667, 171666, 171665, 171664, 171555, 143255, 142916, 142915, 142914, 142912, 142911, 171556, 171554, 143251, 171553, 171754, 171753, 171750, 171749, 149412, 143362, 143250, 171752, 171751, 171748, 171738, 171737, 171736, 143337, 175684, 175679, 171756, 171755, 171741, 171740, 171739, 171735, 171734, 171733, 171732, 171731, 171730, 171706, 144162, 142851, 37478, 1685, 175734, 175682, 175681, 175680, 175265, 174848, 171551, 143338, 244886, 244883, 175683, 171607, 171606, 171605, 171604, 171550, 208860, 177222, 175687, 175686, 175685, 171743, 171742, 171679, 171678, 171566, 171565, 171564, 143333, 137647, 171560, 171563, 175689, 175688, 171562, 171561, 171549, 171548, 171531, 171530, 171529, 171528, 32416, 171714, 171713, 171533, 171626, 171591, 171589, 171534, 171532, 32391, 171627, 171625, 171623, 171592, 171590, 143299, 143298, 143297, 171716, 171691, 171690, 171689, 171688, 171632, 171631, 171630, 171629, 143349, 143344, 171687, 171686, 171624, 142873, 142872, 171745, 171744, 171728, 171727, 171726, 171725, 171724, 171628, 142874, 143348, 150087, 142341, 143295, 171765, 171603, 171602, 143363, 143328, 143314, 143296, 143247, 143246, 143245, 143243, 143242, 142871, 142340, 34360, 32425, 32389, 143347, 184955, 208244, 143342, 143273, 143244, 171776, 171775, 171774, 171773, 171772, 171771, 171766, 171729, 171601, 171600, 171599, 171598, 171597, 171596, 171595, 171594, 171593, 143301, 143256, 32383, 32355, 26495, 171767, 171747, 171746, 171559, 171552, 171527, 171526, 171525, 143254, 32429, 171659, 171658, 171558, 171657, 171656, 171655, 171651, 171650, 171557, 143249, 171654, 171653, 171705, 171717, 171536, 171715, 32404, 171652, 143336, 143343, 171710, 171709, 171708, 171540, 171535, 171770, 171768, 171712, 171711, 171707, 171647, 171646, 171539, 143345, 143334, 142339, 143346, 203607, 203605, 171769, 171685, 171684, 171683, 171682, 171681, 171680, 171542, 32358, 26496, 171541, 203612, 203613, 171764, 203611, 171723, 309564, 208375, 203610, 203604, 171722, 171661, 171660, 171547, 171546, 171543, 149417, 26494, 308115, 308114, 307673, 303171, 245052, 203615, 203614, 203609, 203608, 190684, 190683, 171636, 171633, 171545, 171544, 171538, 171537, 143318, 171694, 190680, 171692, 190681, 149413, 149418, 171582, 171634, 171635, 171571, 171580, 171581, 143326, 171703, 171583, 171586, 171587, 171584, 187294, 171702, 171588, 171585, 143320, 171704, 171695, 171572, 171570, 171569, 143325, 143319, 143317, 139852, 32349, 143324, 143322, 171698, 171697, 171573, 171699, 171576, 171577, 171574, 143321, 171575, 171578, 171617, 171579, 171618, 171616, 171613, 171693, 171612, 171615, 171614, 171611, 171609, 143253, 171608, 171610, 32431, 171524, 137646, 32424, 137644, 142838, 32427, 32385, 208870, 207320, 171701, 171700, 171696, 144159, 143323, 26499, 176924, 176629, 176628, 176627, 176626, 176625, 176624, 180756, 180755, 179984, 174746, 181688, 203243, 203242, 203130, 203129, 386, 372, 28603, 26449, 176785, 1941, 29782, 29783, 29781, 32580, 32581, 32570, 29780, 19874, 32578, 1749, 32572, 32574, 32573, 1748, 34571, 32571, 203256, 203263, 203262, 208872, 204359, 203252, 142102, 111206, 203265, 147787, 111223, 111222, 111221, 111220, 111204, 111202, 205077, 111212, 111216, 203259, 203258, 147786, 111227, 111226, 111225, 111224, 111217, 111215, 111207, 111205, 111203, 269, 206552, 205819, 208247, 208246, 205872, 205587, 205586, 205585, 205938, 205937, 205936, 205921, 205920, 205919, 206037, 205080, 205079, 207450, 204669, 204668, 204254, 203973, 203862, 203249, 204098, 204097, 152614, 176231, 204379, 203975, 208255, 208254, 208253, 208252, 208251, 208245, 204088, 203756, 3200, 204090, 204089, 20877, 1928, 204117, 204116, 204667, 203260, 203195, 203193, 203257, 206975, 205221, 29747, 29745, 29744, 29743, 29742, 29741, 29746, 204397, 204396, 268896, 18341, 1911, 1914, 194378, 144133, 144132, 111255, 32596, 28073, 28070, 142103, 28075, 28074, 147792, 111265, 111262, 111256, 111254, 175736, 147793, 147279, 111268, 111266, 111261, 111260, 111271, 111269, 111259, 111258, 111257, 29155, 29154, 29152, 29151, 29150, 28072, 28071, 28069, 256, 22223, 206103, 203415, 205220, 1915, 194389, 207473, 205089, 207497, 206298, 206202, 206201, 209263, 206384, 206848, 206846, 206017, 205870, 205871, 206296, 206313, 205867, 204853, 206314, 206018, 205868, 206019, 205869, 206315, 206312, 206300, 205866, 142690, 32883, 206320, 204461, 102994, 103003, 102992, 102991, 204460, 204459, 205967, 205966, 102993, 102998, 102995, 102997, 102988, 103000, 102999, 102996, 102990, 153350, 103004, 103002, 103001, 102989, 144181, 144180, 206336, 142694, 206517, 2044, 142695, 208299, 204583, 207077, 206941, 142691, 204970, 202440, 208068, 204969, 185437, 164868, 164867, 204439, 152043, 252245, 50982, 152034, 152032, 149031, 149030, 204438, 204440, 185434, 206659, 152035, 179585, 126345, 126342, 126341, 126340, 126339, 126337, 126314, 126313, 233436, 126338, 126335, 126312, 211498, 174729, 174730, 167290, 207489, 176898, 178125, 176897, 206607, 176899, 176896, 176895, 176894, 161536, 206977, 2866, 207303, 2047, 207328, 207304, 2040, 149046, 149045, 204351, 204295, 1805, 1801, 204425, 204424, 206375, 202858, 202860, 202861, 180682, 24798, 180683, 144055, 133467, 133468, 204814, 133466, 133469, 206558, 205548, 176768, 205545, 28024, 207513, 206307, 37099, 206334, 30854, 92099, 30855, 1829, 202756, 30856, 22550, 32569, 1831, 175752, 175742, 51707, 51706, 50985, 3845, 3844, 3843, 3842, 3841, 3840, 3839, 157637, 3962, 206503, 176587, 3968, 3967, 203192, 74135, 192037, 192036, 153359, 192034, 194802, 153203, 192035, 208070, 202116, 208062, 202124, 202123, 202122, 153460, 153459, 150082, 203707, 203183, 148436, 37031, 37027, 37025, 3772, 37034, 152327, 37037, 37038, 37035, 37032, 37029, 148437, 37036, 152329, 37033, 152326, 37030, 37028, 152331, 37026, 152330, 152328, 152332, 152325, 147282, 147285, 147283, 146441, 164618, 147284, 185436, 239088, 239087, 185438, 148511, 239091, 36396, 239092, 239099, 239094, 147742, 239090, 239108, 239096, 239109, 239103, 239095, 239104, 239089, 239107, 239106, 239105, 239102, 239101, 239100, 239098, 239097, 239093, 203752, 203229, 147767, 147756, 147754, 147752, 147751, 147750, 147747, 147746, 147745, 147744, 147768, 147766, 147765, 147748, 203753, 147769, 147764, 176583, 147770, 147763, 147761, 147759, 147758, 147757, 147743, 203230, 147771, 147762, 147760, 147755, 147753, 147749, 125475, 203224, 324, 180712, 205020, 205019, 185435, 207085, 207084, 205039, 209129, 205034, 205035, 207081, 207080, 142145, 175404, 408860, 176584, 176586, 203289, 92254, 94191, 204406, 204432, 2087, 1985, 59858, 175757, 148910, 148909, 148906, 61918, 59857, 59856, 59851, 59850, 59848, 59517, 56901, 148905, 148911, 175854, 175856, 175855, 148902, 148912, 148898, 148904, 59865, 59864, 148913, 175732, 148895, 56910, 144127, 59861, 74091, 148915, 148887, 60395, 148893, 148892, 2574, 59862, 148891, 148914, 60439, 59854, 60438, 56897, 21678, 148885, 21582, 60440, 148903, 148889, 148899, 59860, 59852, 148886, 148884, 148894, 59863, 148900, 148888, 2575, 148901, 59853, 59859, 180391, 59855, 56898, 204578, 59845, 187299, 59847, 56911, 91692, 56905, 144126, 59846, 59518, 56903, 178204, 208420, 2083, 1984, 204336, 180901, 207215, 204398, 202601, 202600, 202602, 398729, 176493, 176492, 176491, 176488, 176790, 208333, 2551, 2076, 51703, 176496, 51702, 94186, 50983, 195586, 176504, 176490, 176489, 163645, 1967, 216761, 1969, 204247, 175080, 202603, 202605, 202604, 2892, 2371, 3798, 3797, 207486, 1959, 180497, 1960, 216764, 1732, 143979, 204828, 207485, 148774, 148766, 148745, 148744, 148743, 148742, 148740, 148738, 148737, 148734, 148731, 148730, 129206, 148773, 148769, 148768, 148767, 148765, 148764, 148762, 148758, 148755, 148754, 148752, 148749, 148748, 148741, 148733, 148732, 148729, 148728, 307286, 307343, 307268, 307262, 307331, 307344, 307315, 307294, 307264, 174863, 160410, 160409, 307291, 307288, 307284, 307260, 3804, 3803, 307293, 175756, 307301, 307289, 307270, 203982, 22674, 22673, 22672, 22671, 22670, 203972, 307271, 357515, 2724, 307280, 23015, 23014, 23013, 307325, 307265, 36998, 36997, 36996, 3769, 36989, 36988, 36984, 36983, 36982, 36981, 36980, 36979, 36987, 36986, 36985, 310709, 266354); +UPDATE `gameobject_template` SET `displayId`=98396, `VerifiedBuild`=57388 WHERE `entry`=208091; -- HangingSkullLight01 (Scale 2.0) +UPDATE `gameobject_template` SET `displayId`=98384, `VerifiedBuild`=57388 WHERE `entry` IN (190082, 208120, 208153, 208152, 208129, 208128, 208151, 208131, 208150, 208130, 208135, 208136, 190044, 190039, 190036, 190043, 208124, 208137, 208121, 208143, 208138, 208126, 208139, 190086, 208144, 208122, 208123, 190103, 208147, 190084, 208125, 190047); -- Candy Bucket +UPDATE `gameobject_template` SET `VerifiedBuild`=57388 WHERE `entry` IN (182829, 182828, 181584, 180600, 180918, 185440, 185441, 182359, 185439, 185445, 185446, 185444, 185447, 185443, 185442, 181594, 181166, 183165, 181990, 181989, 181378, 184591, 181980, 181360, 183162, 3719, 184712, 184711, 184710, 184709, 184708, 184707, 184706, 184705, 183447, 183446, 184245, 182620, 182619, 182618, 182624, 182623, 182326, 182325, 182324, 182323, 184090, 182609, 184091, 182626, 182625, 182608, 182357, 182356, 187390, 182758, 182755, 182638, 182637, 182738, 182841, 182840, 182636, 182635, 182843, 182842, 182640, 182639, 182839, 182641, 182844, 182642, 185473, 182646, 182319, 182318, 182852, 182740, 185453, 182854, 182853, 182851, 182850, 182849, 207325, 185451, 182643, 185452, 182835, 182644, 185472, 182836, 182834, 175759, 182757, 182615, 182340, 182360, 206620, 182341, 182338, 182339, 206624, 182362, 182616, 182617, 185448, 182833, 182733, 182730, 182729, 182726, 182732, 182731, 182808, 182725, 182830, 182753, 182322, 182321, 182320, 182614, 182330, 182329, 182328, 182327, 182364, 183760, 183759, 183757, 182748, 182316, 183758, 182756, 182744, 182704, 182649, 182648, 182647, 182317, 182762, 182760, 182334, 182333, 182332, 182331, 182711, 182628, 182627, 182630, 182629, 182739, 182363, 182634, 182633, 182632, 182631, 182777, 182776, 182784, 185450, 182778, 182785, 182779, 325977, 185449, 184502, 22634, 22620, 22619, 22617, 22616, 22615, 22636, 205002, 205259, 205258, 205257, 292625, 292624, 176145, 205003, 185498, 177286, 205246, 1895, 1894, 288284, 1893, 288283, 1892, 288323, 174880, 22664, 22658, 22654, 22652, 22651, 22650, 22649, 1765, 58610, 288238, 2006, 205099, 207459, 288272, 288273, 206769, 206785, 2005, 191346, 24777, 24776, 204856, 69282, 2001, 1627, 178845, 205044, 2002, 205541, 22567, 22566, 22565, 22564, 22563, 207089, 175933, 1767, 207090, 207279, 207213, 207212, 207211, 184617, 184616, 204452, 204451, 204449, 175748, 204453, 1898, 1740, 206944, 206950, 181649, 32592, 31504, 32591, 32583, 32594, 31508, 32593, 32590, 32582, 31507, 31509, 32584, 61069, 61047, 61046, 61045, 61044, 61043, 61042, 34572, 32585, 61091, 61087, 61066, 61065, 61050, 61040, 61052, 61041, 61049, 61048, 61092, 61060, 61071, 61070, 61068, 61067, 61088, 61098, 61089, 2558, 61096, 61072, 61073, 61099, 61085, 61074, 61093, 61100, 61086, 61061, 61095, 61077, 61076, 61051, 61097, 61059, 61102, 61101, 61094, 61090, 61084, 61083, 61082, 61081, 61080, 61079, 61078, 61075, 61058, 61057, 61056, 61036, 144011, 61064, 61063, 61062, 61055, 61054, 61053, 61039, 61038, 61037, 61035, 147042, 147041, 147040, 147039, 147038, 147037, 147036, 29765, 29764, 29763, 29762, 29761, 29760, 29759, 20975, 290348, 290347, 290346, 290345, 290344, 290342, 290341, 290340, 290328, 290327, 290283, 144067, 144066, 142714, 142713, 142707, 142706, 142705, 142704, 142703, 142702, 18045, 18043, 290361, 18063, 290288, 18064, 290312, 290310, 290290, 142970, 142969, 18067, 290298, 290289, 142139, 18065, 179922, 290287, 290282, 142971, 20981, 290313, 290281, 142972, 18068, 179895, 179887, 179886, 179885, 2068, 179908, 142967, 29776, 29766, 34030, 29767, 29775, 34027, 29769, 34029, 34028, 34031, 29777, 34026, 34025, 29774, 29768, 29770, 29772, 29773, 29771, 206755, 290284, 181645, 20976); +UPDATE `gameobject_template` SET `displayId`=98384, `VerifiedBuild`=57388 WHERE `entry` IN (190067, 190068, 190073, 190072, 208134, 208146, 190074, 208145, 190078, 190054, 190089, 208127); -- Candy Bucket +UPDATE `gameobject_template` SET `VerifiedBuild`=57388 WHERE `entry` IN (203515, 203537, 203536, 203519, 203518, 203517, 203516, 203497, 203496, 203495, 203492, 203531, 203512, 203493, 203538, 203532, 203494, 203550, 203549, 203548, 203544, 203543, 203540, 203539, 203534, 203533, 203530, 203529, 203526, 203525, 203485, 203505, 203504, 203503, 203488, 203547, 203546, 203545, 203520, 203506, 203502, 203490, 203489, 203528, 203527, 203521, 203551, 203541, 203524, 203523, 203522, 203513, 203508, 203507, 203501, 203498, 203491, 203487, 203486, 203542, 203535, 203514, 203511, 203510, 203509, 203500, 203499, 203582, 203583, 203584, 203585, 203600, 203579, 203580, 203569, 203571, 203570, 203572, 203568, 203575, 203574, 207344, 203592, 203591, 203581, 203578, 203577, 203573, 203567, 203566, 203565, 203564, 203561, 203555, 203603, 203602, 203601, 203599, 203598, 203597, 203596, 203594, 203576, 203557, 203556, 203559, 203595, 203593, 203590, 203588, 203587, 203586, 203562, 203560, 203558, 203589, 203563, 204356, 207462, 207460, 203701, 207871, 207870, 203702, 203698, 203695, 203694, 203623, 203616, 203700, 203696, 203692, 203454, 207869, 207872, 203693, 203691, 178646, 207657, 204862, 204861, 204860, 204859, 203220, 203219, 203115, 204093, 207656, 203126, 204092, 203985, 203418, 203372, 203400, 203402, 203401, 203397, 203218, 203735, 203399, 203398, 202749, 204850, 204851, 204848, 202788, 203137, 202897, 202748, 202736); +UPDATE `gameobject_template` SET `displayId`=98384, `VerifiedBuild`=57388 WHERE `entry` IN (208132, 208155, 208154, 208133, 208142, 208141); -- Candy Bucket +UPDATE `gameobject_template` SET `VerifiedBuild`=57388 WHERE `entry` IN (239888, 227133, 225650, 224691, 224690, 224689, 224688, 228574, 238265, 230799, 238264, 238252, 238251, 238250, 238249, 243927, 228564, 228493, 225924, 234119, 229069, 228563, 224707, 237016, 228571, 224359, 225789, 234022, 236912, 234023, 227276, 237486, 234110, 223027, 227277, 234021, 236143, 234109, 234111, 237485, 231248, 230994, 232543, 232545, 235886, 233378, 233377, 232507, 232252, 230126, 230125, 230124, 230123, 230122, 230121, 230120, 232248, 235885, 235389, 233835, 235376, 235390, 235391, 235388, 235387, 228708, 228698, 228690, 228697, 228699, 228694, 228704, 234638, 232250, 244568, 234637, 228706, 228702, 228701, 228696, 228695, 228693, 228692, 228691, 228592, 242447, 240228, 236721, 228593, 228594, 228595, 235909, 228597, 236001, 233141, 225784, 244478, 244475, 240423, 230865, 234303, 232251, 237721, 232249, 194282, 237722, 239791, 194999, 230772, 239186, 239180, 230773, 230378, 230377, 230365, 226871, 234651, 230486, 234678, 233544, 234664, 236246, 236230, 234648, 237027, 233541, 236243, 237061, 234661, 234645, 232544, 236240, 237058, 234658, 234642, 233122, 237407, 227597, 236237, 234655, 234639, 230127, 233119, 236234, 233548, 234668, 234652, 236247, 236231, 233545, 234665, 234649, 233542, 225540, 236244, 237062, 234662, 234646, 237059, 236241, 234659, 234643, 233123, 232542, 236238, 237056, 234656, 234640, 233120, 230987, 233546, 232379, 236235, 232509, 234669, 234653, 236744, 236440, 235992, 236248, 236232, 234666, 234650, 233543, 236245, 234663, 233540, 234647, 237060, 233537, 234660, 234644, 237057, 236242, 233380, 233124, 234657, 224799, 236239, 234641, 233121, 236236, 232380, 234670, 234654, 233547, 233177, 237961, 236249, 236233, 232541, 234667, 442664, 434984, 434968, 433018, 436046, 461506, 441669, 434981, 434965, 433031, 436043, 452050, 434978, 430324, 433028, 433928, 434991, 434975, 433025, 433925, 436053, 434988, 434972, 430318, 433022, 439874, 442665, 434985, 434969, 433019, 439903, 439855, 461507, 441670, 434982, 434966, 412066, 423244, 402605, 424343, 414379, 252247, 452860, 452218, 429128, 413986, 413975, 413956, 411754, 433016, 436044, 434979, 434963, 433029, 439846, 439849, 434992, 434976, 433926, 436054, 434989, 434973, 433023, 452003, 436051, 441668, 434986, 434970, 433020, 430316, 441671, 434983, 434967, 435959, 433017, 441748, 436045, 434980, 433014, 434964, 433030, 439450, 434977, 430323, 433027, 433927, 434990, 434974, 433024, 430320, 434987, 434971, 433021, 430317, 439777); +UPDATE `gameobject_template` SET `displayId`=98384, `VerifiedBuild`=57388 WHERE `entry`=243912; -- Candy Bucket +UPDATE `gameobject_template` SET `displayId`=98401, `VerifiedBuild`=57388 WHERE `entry`=244476; -- Tiny Wickerman +UPDATE `gameobject_template` SET `displayId`=98384, `VerifiedBuild`=57388 WHERE `entry` IN (401756, 401757, 401755, 401736, 401753, 401754, 401752, 401751, 401750, 401749, 401748, 401725, 401714, 401723, 401724, 401726, 401746, 401741, 401745, 401740, 401738, 401739, 401742, 401743, 401744, 401747, 401727, 401733, 401734, 401731, 407048, 401728, 401729, 401730, 401732, 401737, 401735); -- Candy Bucket +UPDATE `gameobject_template` SET `VerifiedBuild`=57388 WHERE `entry` IN (251128, 242664, 251826, 251824, 251823, 251822, 251768, 251765, 251706, 243099, 243807, 244000, 243089, 242449, 266111, 266110, 240614, 227577, 244001, 245652, 241741, 241639, 244994, 242666, 251959, 245650, 244995, 267017, 242660, 205038, 205037, 205036, 243636, 242665, 253936, 246489, 246153, 266416, 240608, 249419, 253129, 241127, 257289, 253280, 244775, 245324, 242242, 242675, 252558, 266303, 243322, 242678, 242250, 243007, 242350, 242671, 243323, 246963, 251272, 242669, 247396, 254128, 244776, 241390, 243321, 245790, 240636, 240635, 245883, 240877, 256790, 252183, 240665, 240634, 240046, 239910, 249396, 251185, 251187, 246488, 245325, 253561, 253560, 252232, 239984, 239452, 259237, 251552, 258325, 244706, 239985, 249761, 265474, 249746, 245573, 245574, 251168, 240291, 252563, 252560, 243192, 251183, 248821, 239122, 239959, 251643, 244774, 245572, 241743, 265435, 261535, 261533, 252803, 280902, 280898, 253126, 252218, 266106, 252691, 252219, 252191, 280899, 266919, 280901, 280897, 251620, 252248, 252772, 280900, 280896, 266029, 254149, 265521, 241726, 254147, 246493, 252408, 231252, 231251, 258959, 251312, 251311, 251286, 243247, 259820, 251212, 250406, 268047, 250417, 251209, 250405, 250407, 251210, 268054, 250404, 251211, 250396, 250403, 250401, 250402, 250398, 250400, 250399, 250395, 250397, 266129, 259240, 253969, 253968, 226911, 252663, 250390, 250391, 248522, 268368, 268079, 248523, 248933, 250387, 248822, 250389, 268060, 250392, 259375, 248855, 250388, 247579, 269969, 247558, 248852, 247564, 248858, 248859, 248860, 248857, 247572, 259377, 259374, 259373, 259372, 259369, 251304, 250393, 247571, 259376, 259371, 259359, 259370, 259379, 259358, 259361, 259362, 259352, 259355, 259365, 259354, 259357, 259360, 259356, 250260, 250311, 259368, 250312, 259363, 268066, 259364, 250308, 259378, 250303, 250309, 259366, 259353, 250304, 250394, 259367, 248856, 369303, 250261, 242029, 250258, 250306, 250305, 250259, 250307, 242030, 250310, 250301, 259285, 250302, 242220, 242175, 259834, 242127, 242128, 259351, 268052, 250455, 245368, 245355, 247848, 248842, 247849, 248843, 259284, 248841, 246002, 250456, 250454, 250514, 250509, 250522, 250523, 250513, 250510, 250521, 250511, 250512, 242129, 242126, 250453, 250525, 250528, 250524, 259390, 250526, 250527, 250435, 242130, 250476, 268065, 259387, 242125, 259384, 259383, 259382, 259381, 259380, 250517, 250516, 250515, 250507, 250506, 250505, 250503, 250502, 250501, 249362, 242131, 241959, 268046, 250504, 250508, 242132, 259288, 250518, 259286, 259287, 247337, 246008, 242648, 246708, 280797, 250519, 247858, 250520, 245353, 268057, 259346, 248844, 248093, 247797, 242641, 242640, 242639, 242638, 242637, 242636, 242216, 241951, 259345, 249919, 247019, 247018, 247013, 244824, 242050, 241968, 241965, 241961, 241952, 268081, 259296, 242215, 242049, 242048, 242047, 242042, 251992, 247692, 246001, 246154, 244536, 251579, 241506, 246463, 268051, 268059, 241480, 268072, 382533, 247693, 269037, 268053, 241513, 244562, 268073, 266618, 235098, 254236, 266851, 249730, 270855, 269967, 268067, 241445, 268048, 244537, 251105, 200297, 382534, 266619, 268078, 268086, 245623, 268074, 235099, 249731, 268087, 267991, 194115, 251624, 249732, 246465, 369301, 268049, 382535, 250631, 188215, 244651, 235100, 241453, 266761, 251305, 148502, 246466, 369302, 241511, 241419, 268043, 200296, 250576, 266736, 249729, 268061, 243374, 241512, 268044, 266705, 184633, 268045, 244534, 244950, 241446, 382531, 251883, 247691, 252331, 244560, 241620, 269989, 224813, 245249, 242366, 244561, 241447, 245691, 382532, 250319, 242201, 259270, 250491, 250354, 242223, 251582, 242040, 241970, 259275, 250346, 242199, 241954, 241964, 241946, 242051, 250494, 250338, 242039, 246258, 242234, 241969, 259312, 250478, 250320, 250470, 259398, 259349, 259290, 250463, 251595, 241945, 250460, 242198, 250262, 250215, 250499, 259341, 250216, 259304, 250343, 241948, 250217, 250483, 250335, 242118, 250467, 259280, 248079, 250356, 242231, 241921, 258330, 241967, 241943, 246260, 250359, 250351, 259293, 259395, 259835, 250332, 259283, 259267, 250490, 241972, 250457, 250323, 265470, 259426, 250300, 250353, 259272, 242228, 246944, 242041, 251592, 250485, 250452, 250345, 242172, 259343, 251584, 241956, 250348, 250340, 250496, 250315, 259338, 250480, 250472, 250337, 259392, 259264, 259415, 250321, 265469, 246257, 250219, 242038, 245832, 250329, 259317, 251033, 259335, 250218, 259306, 242233, 241958, 259309, 259929, 250449, 242174, 242224, 259277, 259274, 259337, 242123, 259348, 242177, 250322, 259269, 242169, 241950, 241953, 251581, 242200, 259295, 250493, 250477, 250462, 250469, 259397, 267068, 245662, 250313, 250438, 251594, 242043, 254276, 245661, 242230, 259308, 250487, 250214, 241963, 249516, 250314, 250498, 250350, 250459, 246262, 241966, 250482, 250342, 250339, 250358, 250334, 250474, 242045, 250298, 242052, 259394, 250331, 259282, 259266, 259342, 250299, 259311, 242218, 242235, 259303, 259289, 242044, 259292, 242227, 259279, 250297, 250451, 241971, 241944, 241955, 259347, 242037, 259334, 250436, 259271, 241947, 241920, 250355, 250347, 258327, 242202, 258329, 250495, 250479, 259276, 250471, 259391, 259350, 259339, 250464, 251580, 241922, 246941, 250360, 250500, 259294, 259305, 250336, 250317, 250492, 242054, 250328, 250324, 242232, 250352, 259344, 250458, 259307, 242176, 246945, 250484, 242237, 241960, 250344, 250468, 250316, 260236, 242046, 254239, 259396, 259268, 259291, 259416, 241957, 259273, 245663, 242226, 248516, 250461, 251593, 246942, 259262, 250349, 250450, 251585, 254238, 250341, 245833, 250497, 259310, 250333, 246261, 246943, 259336, 242229, 250318, 250481, 241949, 250357, 250473, 242236, 242225, 259393, 254148, 259281, 242170, 259265, 258328, 254145, 259278); +UPDATE `gameobject_template` SET `displayId`=98384, `VerifiedBuild`=57388 WHERE `entry` IN (251671, 251670, 251672); -- Candy Bucket +UPDATE `gameobject_template` SET `VerifiedBuild`=57388 WHERE `entry` IN (277419, 298826, 302859, 298814, 298810, 298843, 298825, 298806, 298812, 298823, 298831, 298813, 298819, 298815, 298808, 298827, 292904, 298802, 292584, 298803, 298800, 299064, 298809, 298796, 298811, 298801, 298792, 298844, 298798, 298807, 298788, 298784, 298840, 310516, 298824, 298820, 298794, 298816, 298804, 298797, 298799, 299065, 290706, 289436, 289529, 289558, 279684, 280640, 218387, 279675, 279339, 304055, 327525, 316905, 279682, 291115, 281560, 290705, 298793, 298841, 298795, 298790, 298789, 293983, 298842, 298785, 298791, 298837, 298833, 298832, 298786, 298821, 298787, 298817, 298805, 298838, 298783, 298834, 278212, 303219, 298822, 298830, 298828, 298839, 298829, 282771, 278211, 298818, 302951, 299284, 302952, 295464, 335630, 294940, 295011, 299281, 295454, 294987, 295000, 294866, 299282, 295001, 294988, 295475, 299283, 295453, 295119, 294942, 294938, 294840, 294808, 295118, 295456, 294982, 294979, 295116, 295117, 295457, 287123, 295085, 292873, 278571, 294232, 294997, 292910, 294995, 295716, 295715, 295714, 295365, 295017, 295016, 295015, 294996, 294994, 294993, 294992, 294930, 294234, 294233, 294231, 303085, 295028, 294946, 295470, 295765, 295461, 295758, 295766, 295770, 295759, 294246, 294253, 295769, 294242, 294245, 294248, 294247, 295768, 294244, 295402, 295767, 295762, 294243, 294241, 295763, 295401, 294239, 295776, 294240, 295760, 295773, 297905, 295720, 295774, 295719, 295761, 295775, 295021, 295718, 295777, 295717, 295756, 303008, 303007, 303001, 302998, 302997, 302996, 295764, 295757, 295467, 294238, 294237, 295771, 295753, 301133, 301132, 295772, 295755, 295754, 295487, 295486, 295476, 295473, 295471, 295462, 295415, 294961, 294858, 295020, 294906, 293965, 303013, 303012, 303011, 303010, 303005, 302995, 302994, 303004, 294977, 294807, 295022, 295025, 295024, 295023, 303002, 303009, 294902, 303003, 294903, 294904, 294847, 302999, 303006, 316675, 303000, 295778, 295013, 303067, 303061, 303055, 303049, 303059, 303060, 295124, 295123, 295122, 303052, 303057, 303053, 303045, 303041, 303040, 292913, 292912, 279594, 279587, 303056, 303047, 295731, 295730, 295729, 295728, 295727, 295726, 295725, 295724, 294955, 295721, 295723, 303043, 295722, 295733, 295734, 295732, 281095, 295400, 301128, 295420, 295419, 295161, 295160, 295159, 295158, 295157, 295156, 295155, 295012, 294856, 294857, 294973, 294956, 294901, 295408, 290675, 321725, 312156, 321755, 321735, 321719, 321732, 321754, 321753, 321734, 321733, 321730, 321724, 321721, 321720, 321718, 320928, 317398, 301134, 239174, 301131, 296155, 295411, 295363, 299261, 295048, 299259, 294976, 365067, 294952, 294491, 295096, 294896, 365064, 295091, 299251, 292872, 302944, 295360, 295432, 294544, 299344, 299264, 294949, 365069, 299256, 295088, 294890, 295469, 294887, 295357, 292869, 302858, 302949, 302941, 323531, 239179, 298879, 298911, 321797, 369893, 280662, 313618, 282246, 298886, 298913, 312127, 299008, 316429, 316422, 306854, 321760, 316423, 301127, 299009, 282465, 288469, 298914, 293844, 316424, 297145, 298881, 281065, 293838, 316430, 298882, 279586, 316904, 253128, 325968, 325967, 298915, 292695, 303017, 281609, 298876, 323548, 293552, 298909, 288433, 239178, 297937, 303145, 321795, 298883, 312208, 303018, 279717, 214679, 323383, 303146, 278570, 298878, 298912, 302839, 281647, 316427, 229465, 309572, 298884, 298885, 298910, 287435, 282258, 294493, 294954, 294485, 294898, 299322, 299253, 295093, 295018, 295050, 302946, 301130, 295362, 294546, 299258, 294975, 295098, 365066, 295055, 294951, 294490, 365071, 299250, 295090, 302791, 292547, 295399, 294999, 292871, 294543, 301135, 303207, 299343, 293132, 299263, 299255, 294900, 295087, 295052, 295095, 294905, 295417, 295057, 299260, 294948, 296460, 302948, 294953, 302940, 295364, 295049, 294974, 365068, 299257, 294492, 294484, 294950, 299252, 298980, 295409, 295092, 294889, 295361, 302790, 294545, 302945, 301129, 295481, 295097, 295398, 294998, 365065, 296478, 294481, 294489, 299265, 295089, 302857, 295054, 295414, 292870, 302950, 302942, 295358, 299342, 294891, 294897, 365070, 295051, 294963, 295053, 294899, 299262, 299254, 295094, 295086, 295019, 294888, 295056, 294275, 302947); +UPDATE `gameobject_template` SET `displayId`=98384, `VerifiedBuild`=57388 WHERE `entry` IN (316754, 316755); -- Candy Bucket +UPDATE `gameobject_template` SET `VerifiedBuild`=57388 WHERE `entry` IN (378877, 378869, 381177, 381179, 381174, 381173, 383616, 381172, 381178, 381175, 381188, 381189, 402507, 379026, 379025, 409032, 376883, 376387, 376388, 382264, 381271, 381270, 381265, 381267, 382262, 381266, 381274, 382268, 381309, 382269, 381269, 385960, 408277, 381308, 408060, 385955, 385959, 377604, 382273, 382272, 381275, 385012, 381264, 381262, 381307, 381263, 381273, 381306, 381272, 381268, 409031, 398745, 381301, 381300, 381241, 381226, 381225, 384998, 381187, 381186, 381185, 381184, 381183, 381182, 409027, 383585, 383605, 383604, 383603, 383589, 383588, 381149, 381146, 386379, 383586, 386380, 383587, 386381, 386477, 383613, 383602, 383601, 383600, 381147, 383610, 383599, 381148, 378264, 383592, 383612, 383609, 383608, 383611, 383615, 383606, 376753, 383607, 386475, 386473, 401758, 383591, 383590, 383614, 409034, 377123, 379330, 379329, 376833, 381028, 380452, 380454, 381033, 381026, 380449, 380455, 381030, 383596, 383595, 381035, 381034, 378880, 378889, 382267, 380974, 380981, 381029, 380451, 378885, 405380, 401761, 382168, 405489, 377118, 386389, 382680, 245436, 381653, 405378, 409010, 401759, 376927, 386374, 255306, 410348, 383676, 386474, 405593, 380823, 421718, 385958, 378263, 401760, 383677, 386375, 378042, 381687, 381736, 386378, 410356, 387719, 378860, 383597, 381025, 379027, 383593, 380977, 380978, 380973, 380985, 380448, 385015, 382271, 378878, 385018, 381086, 378868, 379019, 383594, 384587, 378890, 382263, 384276, 380982, 382270, 378871, 382276, 380986, 383623, 382266, 378876, 383622, 380983, 382260, 378887, 380979, 382345, 378883, 383619, 383618, 378879, 381032, 398685, 380975, 398684, 380987, 379024, 380971, 381031, 382182, 378859, 386621, 380972, 382474, 381027, 381176, 386620, 379022, 385017, 384275, 380980, 380984, 382473, 378886, 382274, 380988, 378884, 382261, 390256, 383598, 378888, 380453, 380976, 382275, 385016, 378882, 380970, 382265, 398686); +UPDATE `gameobject_template` SET `VerifiedBuild`=57388 WHERE `entry` IN (204118, 209081, 204878, 204119, 209080, 249699, 278214, 209096, 202754, 202846, 202776, 204431, 203143, 203147, 203095, 203093, 203092, 204219, 202660, 202703, 203383, 203067, 203066, 204218, 204217, 204216, 202712, 202711, 202706, 204580, 202732, 202731, 202723, 202702, 177281, 311320, 202387, 203187, 202973, 202972, 202955, 202954, 405525, 206585, 408027, 206764, 206852, 408028, 311342, 206382, 206625, 142140, 409914, 206963, 403546, 207063, 311368, 311363, 311358, 208454, 208449, 208444, 311372, 311333, 204162, 204161, 311340, 206398, 207105, 207104, 311305, 311304, 204158, 204157, 176091, 311301, 3718, 311306, 204160, 311310, 311290, 204159, 3716, 311300, 3717, 311298, 153516, 207126, 195007, 194208, 194714, 194209, 194130, 194124, 194133, 194131, 194122, 284503, 284502, 284492, 204774, 204132, 204131, 177278, 194107, 194105, 194145, 194787, 311297, 311288, 284603, 284545, 176291, 176289, 207533, 194090, 194089, 194088, 13359, 311731, 311291, 175984, 207179, 208189, 175929, 203169, 207327, 247045, 247042, 247040, 247052, 179863, 175931, 175811, 176749, 179125, 176588, 278492, 175927, 208192, 179864, 176404, 176748); +UPDATE `gameobject_template` SET `displayId`=98384, `VerifiedBuild`=57388 WHERE `entry` IN (208162, 208164, 208163, 208158, 208159, 208115, 190106); -- Candy Bucket +UPDATE `gameobject_template` SET `displayId`=98384, `VerifiedBuild`=57388 WHERE `entry` IN (208183, 208181, 190105, 208177, 208180, 208179, 208178, 190107, 208160, 208116, 190053, 208161, 190088, 190104, 190052, 190102, 208170, 190085, 208171, 208168, 208167, 190065, 190070, 190083, 208157, 190051, 208176, 190050, 208175, 190080, 208174, 208172, 208173, 208169, 190076, 208119, 190035, 208118, 208117, 190079, 208166, 208165, 190064, 190069, 208140); -- Candy Bucket +UPDATE `gameobject_template` SET `VerifiedBuild`=57388 WHERE `entry` IN (205565, 208258, 205272, 204018, 205133, 205125, 205130, 205161, 205126, 204959, 205129, 205131, 205152, 205273, 205122, 205110, 205102, 205121, 205128, 205127, 204407, 205146, 205115, 205113, 207593, 205120, 205119, 205151, 205112, 207597, 340644, 203060, 203053, 334110, 334109, 182560, 178765, 178764, 203054, 144112, 175335, 203056, 203042, 175763, 148504, 141838, 203049, 203059, 202198, 186218, 296451, 214613, 214612, 187912, 214500, 184532, 184531, 184530, 184006, 214502, 203821, 181095, 214503, 247028, 335629, 149026, 175491, 149027, 202407, 149029, 149028, 195037, 201925, 166863, 161505, 202082, 204812, 201867, 201866, 164958, 195022, 164658, 164778, 148503, 205251, 208240, 208241, 208238, 208239, 206390, 205540, 205266, 207698, 202752, 206897, 206910, 206896, 206895, 206911, 206899, 206898, 206891, 206900, 205539, 206892, 206939, 206904, 206893, 206691, 206690, 202741, 205527, 277691, 207151, 207280, 207166, 207130, 277689, 202779, 208242, 179565, 178553, 180544, 277600, 277599, 180534, 180503, 277602, 180539, 180529, 180502, 277604, 277601, 277605, 180448, 277606, 180718, 277620, 277611, 180904, 181618, 181603, 277916, 277598, 207565, 181619, 181617, 281420, 281071, 281076, 281072, 289521, 281073, 281077, 281078, 281075, 281074, 276377, 276388, 276382, 276380, 276385, 276384, 276387, 276386, 202606, 142091, 142185, 142188, 202222, 202085, 202221, 202115, 202114, 142073, 142090, 204989, 204990, 202107, 204981, 204980, 202164, 204984, 204983, 204982, 204985, 176278, 176318, 148840, 202793, 41188, 41190, 41189, 41192, 41191, 41186, 41187, 143986, 141069, 177192, 177189, 178224, 177188, 179469, 177198, 408296, 408313, 408300, 408298, 205432, 205421, 408297, 202206, 408307, 408304, 205416, 175675, 408315, 408303, 205368, 203228, 408294, 202207, 82136, 176324, 82138, 82137, 203051, 206835, 206832, 203058, 206834, 203055, 203052, 202959, 202304, 202303, 202961, 202958, 202957, 202956, 207437, 207436, 207433, 202960, 194147, 203090, 203057, 203050, 202975, 207455, 207447, 207439, 207451, 207443, 207435, 207444, 206767, 205116, 203248, 203152, 207448, 207438, 207440, 207458, 207434, 203221, 203153, 207453, 207441, 207457, 207442, 207446, 207250, 206743, 206742, 186426, 186233, 186230, 186232, 186231, 186332, 20359, 186463, 186441, 186450, 20925, 208948, 142095, 186322, 20985, 187252, 20831, 20830, 20829, 3251, 3972, 169969, 174858, 21277, 21530, 169968, 68865, 220176, 174857, 169967, 169966, 149036, 21679, 174872, 144125, 143399, 143398, 107042, 107041, 107040, 107039, 107037, 106641, 106638, 195205, 195203, 195187, 3252, 202300, 202298, 141863, 141862, 48516, 142198, 204997, 202323, 202322, 202321, 201696, 202325, 202324, 202320, 202335, 202405, 142197, 207475, 186301, 20966, 202080, 20965, 181626, 23018, 23017, 23016, 186423, 177164, 177165, 21127, 186432, 177928, 21459, 205332, 186631, 186630, 186629, 20849, 202476, 204996, 204995, 200302, 200303, 202535, 202597, 207487, 204994, 204999, 204993, 208059, 201588, 201587, 201943, 201878, 201876, 202478, 202477, 203814, 201810, 195505, 195504, 195503, 195502, 175786, 202467, 201792, 201602, 202595, 202596, 201724, 202174, 202173, 202172, 186287, 201738, 201737, 204290, 202176, 202175, 153482, 142131, 153402, 153400, 153399, 3308, 2908, 74445, 15069, 143984, 50548, 50547, 50549, 74444, 74443, 74442, 74441, 74440, 18035, 15068, 2914, 186264, 74439, 3656, 3076, 2911, 2910, 2912, 209538, 50450, 50449, 50448, 50447, 50446, 50445, 178571, 177268, 177267, 177266, 160426, 3315, 3303, 152583, 177265, 3298, 3286, 143985, 177270, 207323, 187295, 50469, 50468, 177269, 3296, 209635, 209634, 208880, 208875, 208867, 180043, 74146, 177369, 177397, 177365, 177243, 177398, 177366, 177400, 177399, 177524, 179896, 175853, 176635, 176582, 175852, 175851, 195094, 65407, 176751, 316907, 176752, 195687, 195097, 195674, 195108, 195107, 177444, 204761, 204749, 195601, 178908, 175146, 175145, 175144, 176319, 195588, 177706, 203384, 208095, 203374, 203377, 203376, 202572, 176506, 321185, 321184, 266049, 176509, 176508, 176507, 49487, 49486, 49485, 321182, 143983, 203141, 203146, 203145, 203148, 203174, 11898, 194477, 194476, 11899, 203429, 194473, 194475, 194474, 19603, 203235, 203443, 203291, 203290, 203279, 50831, 50830, 2335, 204800, 204805, 204804, 203253, 194504, 2334, 203041, 207522, 195450, 177288, 176787, 203186, 195600, 92427, 92426, 204797, 3730, 195217, 195220, 180045, 210177, 208888, 195517, 195497, 208889, 180034, 208887, 141871, 195438, 203446, 208890, 203234, 209544, 4170, 4171, 203431, 47297, 203239, 47296, 203292, 202136, 201395, 204293, 204292, 204291, 201707, 201708, 201391, 201394, 201399, 23577, 201393, 201701, 201392, 3963, 3964, 220177, 4166, 143982, 123328, 58369, 23570, 195118, 3726, 3725, 376849, 376846, 376845, 376704, 376842, 376840, 376839, 376837, 376708, 376674, 204360, 204169, 204168, 204170, 204167, 204172, 204173, 58595, 204171, 202819, 204732, 204731, 58389, 58388, 140113, 178195, 6288, 195111, 208790, 195135, 195138, 194296, 195024, 178247, 186455, 149021, 179489, 195012, 17783, 194620, 194619, 203020, 176999, 176998, 20962, 191369, 206854, 175104, 142117, 175179, 175180, 195079, 194778, 194777, 194779, 194803, 175181, 195077, 19015, 194651, 195005, 195002, 194203, 194311, 194310, 3722, 194309, 194175, 194809, 18643, 178147, 20806, 178146, 194566, 203822, 178864, 204875, 203823, 195110, 140105, 190549, 6287, 6286, 182255, 140111, 6292, 6291, 140110, 140109, 6290, 6289, 194616, 140112, 194617, 194297, 194482, 181686, 194615, 194997, 194458, 181690, 194493, 21004, 206559, 201293, 208345, 201291, 208343, 177794, 3740, 126053, 126052, 126051, 126050, 195119, 3727, 220359, 3729, 20810, 3724, 174849, 5622, 5621, 5620, 5619, 31407, 203850, 221516, 186727, 221518, 221517, 221519, 31574, 55250, 3849, 18079, 3848, 18075, 18076, 3850, 174859, 31579, 31578, 3847, 3851, 3658, 31580, 31577, 143981, 106325, 207207, 106327, 31575, 149038, 106336, 106335, 106326, 31572, 31573, 203851, 375041, 203852, 202839, 202835, 207484, 203853, 203854, 3290, 203855, 55615, 204164, 204189, 180762, 204185, 204177, 204182, 206574, 204166, 204190, 204174, 204187, 204165, 204184, 204176, 252071, 180759, 204178, 204186, 206575, 204183, 204175, 204181, 204188, 204180, 204193, 204179, 204657, 205371, 205230, 204728, 206734, 203977, 252303, 281107, 251028, 268690, 204624, 243460, 204625, 273293, 298892, 207101, 206709, 273286, 207099, 243459, 307614, 207100, 339344, 273300, 243462, 243461, 207098, 207097, 207096, 207094, 206708, 204627, 204626, 204620, 179707, 323850, 323852, 204646, 323853, 204658, 323855, 323851, 323849, 204730, 204729, 204656, 203979, 194283, 206737, 204666, 204665, 278281, 204655, 204645, 204650, 383583, 204651, 204662, 204647, 204664, 204710, 204663, 204623, 204163, 206735, 204628, 204622, 204724, 204621, 204212, 204639, 204709, 206727, 204725, 204640, 204213, 204208, 204207, 204202, 204198, 204199, 204194, 206736, 204604, 204197, 377216, 204605, 204602, 204600, 204191, 204606, 204211, 204201, 387697, 206725, 204601, 204196, 175787, 206726, 204610, 204607, 204603, 204215, 204210, 175788, 387718, 206995, 204609, 204608, 204214, 204209, 204205, 204200, 206729, 206741, 204195, 204192, 202717, 206733, 204723, 207150, 207149, 207148, 207147, 207146, 206732, 206530, 204722, 197257, 3301, 204634, 204631, 204632, 206549, 197279, 197276, 206738, 206546, 206545, 206539, 206538, 205090, 204719, 204689, 197323, 206739, 205091, 204720, 197280, 50805, 50804, 50803, 384511, 209114, 206547, 204721, 204633, 197322, 197278, 206508, 209124, 206548, 207690, 207689, 207687, 206595, 206509, 204727, 204688, 197287, 197286, 197285, 197284, 207686, 206730, 207688, 206529, 197312, 197311, 197307, 105576, 197314, 207635, 204203, 197313, 210059, 207646, 204204, 204700, 204726, 293684, 206740, 197315, 197310, 197309, 237942, 210058, 208534, 207634, 204699, 204693, 202799, 202798, 197260, 197259, 197207, 207630, 204643, 202810, 202809, 202808, 202801, 202800, 208270, 208269, 204695, 204679, 197261, 186722, 207633, 204939, 204938, 204937, 204936, 204696, 204681, 202802, 202804, 208054, 207632, 204698, 204678, 202815, 202805, 202803, 204694, 204680, 202814, 202813, 202812, 202811, 204941, 204940, 204706, 202817, 202816, 207631, 204707, 204708, 204612, 204613, 204638, 204614, 205142, 204616, 204619, 195222, 205108, 205109, 204637, 204617, 204618, 207636, 204615, 339239, 281340, 207638, 204702, 204685, 204684, 204636, 204635, 204701, 187376, 207642, 207640, 207637, 351922, 207736, 351430, 351918, 207641, 204716, 204712, 204704, 204713, 204692, 351923, 207645, 204677, 204642, 351924, 351920, 204715, 204717, 207414, 209867, 186238, 204718, 204714, 204711, 204682, 204686, 206608, 269949, 204703, 204641, 206609, 351925, 206610, 351921, 351926, 204705, 207639, 203969, 204683, 204687, 351919, 223814, 223739, 204611, 203378, 202590, 196462, 152622, 141870, 152620, 203471, 142121, 204237, 204236, 204235, 204234, 204233, 201400, 152621, 152631, 207267, 207269, 207268, 207266, 207265, 207264, 207220, 208052, 204122, 204121, 375181, 20918, 204245, 195639, 195638, 204246, 196475, 204786, 205082, 88496, 204784, 207425, 88497, 204785, 201386, 201302, 195365, 204244, 199333, 207889, 196837, 204243, 204226, 204127, 204222, 204128, 204225, 204224, 204223, 207576, 207575, 204221, 204220); +UPDATE `gameobject_template` SET `VerifiedBuild`=57388 WHERE `entry` IN (185136, 183273, 183272, 183271, 182955, 182393, 184303, 183218, 182265, 182599, 182958, 184316, 182959, 182493, 182257, 182499, 182498, 182497, 182495, 182500, 182503, 182496, 182502, 182521, 182501, 182392, 183313, 183149, 183148, 182391, 185181, 182350, 183171, 182210, 183170, 182107, 182401, 182343, 182209, 182115, 183039, 182271, 182270, 182269, 182066, 182065, 182062, 184041, 184040, 184039, 184038, 184046, 184045, 183818, 183795, 183787, 184048, 184049, 184047, 184043, 184042, 184044, 183042, 182377, 182376, 182206, 182205, 182116, 183046, 182952, 182953, 182954, 183113, 183116, 183118, 183119, 183121, 183120, 182570, 182569, 183111, 182567, 183117, 183114, 182568, 182561, 182165, 183346, 183345, 183112, 182095, 183044, 183043, 182053, 183284, 183040, 182571, 183177, 185927, 185861, 185248, 183950, 185249, 185247, 184825, 183949, 185246, 185245, 185244, 182529, 184147, 185035, 184631, 184504, 184350, 183430, 182606, 184724, 188132, 184944, 184212, 185159, 183465, 185270, 185269, 184467, 183467, 185268, 185267, 184660, 183484, 183483, 184148, 185160, 185158, 185157, 184341, 185154, 185153, 185120, 185477, 185461, 185512, 185464, 185463, 185462, 184595, 183290, 185467, 183291, 185944, 185301, 183292, 185465, 185296, 183293, 185466, 184071, 184070, 186140, 186139, 183048, 183047, 184488, 183768, 183767, 181279, 191817, 269966, 184255, 186142, 183306, 183298, 183299, 183297, 186141, 183300, 184085, 183811, 184418, 184423, 184422, 184421, 184420, 184419, 184588, 184330, 184431, 184430, 184429, 184428, 184427, 184426, 184425, 184424, 184454, 184500, 184501, 181638, 183437, 183438, 181663, 183037, 185528, 183038, 182861, 182860, 183436, 184018, 184017, 183343, 183341, 183339, 183105, 184009, 183940, 183936, 183934, 183902, 183901, 183904, 183903, 181310, 183348, 183347, 181381, 183911, 183906, 183905, 183909, 183908, 183907, 183912, 183910, 183915, 183918, 183499, 183917, 183916, 183123, 182938, 182937, 182936, 184025, 182789, 183122, 182799, 182798, 175013, 175014, 148746, 175021, 175002, 175003, 175020, 175028, 175019, 175010, 148735, 22887, 22885, 183500, 182797, 183504, 22929, 22928, 22912, 180575, 22902, 22914, 183502, 183503, 183501, 22894, 149051, 181475, 175017, 175009, 175008, 148760, 148747, 175025, 175027, 22913, 22911, 22882, 22886, 22884, 38148, 148759, 22883, 148757, 181380, 175007, 148763, 175018, 175006, 175016, 175026, 175015, 148756, 175030, 184640, 175029, 175024, 175023, 175022, 175012, 175011, 175005, 175004, 175001, 148753, 148750, 181369, 181067, 181066, 181065, 181064, 181063, 183396, 183515, 182173, 183395, 183394, 182174, 182525, 184005, 183397, 183514, 182175, 181372, 184912, 184289, 184414, 184290, 184415, 184701, 184747, 184716, 184684, 184490, 185010, 185009, 185008, 181569, 185102, 181556, 180035, 184801, 184795, 182973, 182972, 182971, 182970, 182969, 182968, 182967, 182965, 182964, 182962, 185130, 184797, 184796, 182961, 182966, 182963, 182960, 182909, 182910, 182911, 182879, 182880, 182907, 182914, 182921, 182920, 182919, 182918, 182917, 182916, 182915, 182913, 182912, 182908, 182906, 182905, 183030, 183028, 182884, 182883, 182882, 182881, 183006, 183026, 183007, 182924, 183008, 183034, 182887, 183029, 183027, 182886, 182885, 182900, 183033, 183025, 183032, 182925, 183035, 183024, 182903, 183010, 182929, 182928, 182888, 182889, 182901, 182867, 182898, 182926, 182922, 182899, 182927, 182923, 182904, 182902, 182897, 182896, 182895, 182894, 182893, 182892, 182891, 182890, 182876, 182875, 182874, 182865, 183022, 182862, 183023, 182863, 182864, 183009, 182866, 183031, 182873, 183005, 182872, 182871, 182869, 182868, 182877, 182870, 182994, 182878, 184652, 185458, 184946, 184286, 184285, 183402, 184948, 183401, 182149, 182148, 182153, 182152, 185456, 182150, 182147, 182154, 182151, 182946, 184945, 181280, 185123, 184246, 207478, 182549, 183126, 183125, 181271, 183399, 183124, 181270, 181277, 174987, 174981, 174980, 112095, 112092, 112128, 112123, 174979, 112100, 112115, 112097, 112096, 174976, 174977, 112129, 112098, 174978, 174975, 174974, 174982, 184838, 182587, 174986, 174985, 174984, 174983, 112112, 183144, 184837, 179975, 182939, 183895, 183168, 185139, 182588, 183922, 183167, 182117, 182118, 183166, 185547, 181664, 182591, 181555, 183414, 182601, 183413, 182541, 186066, 186062, 186080, 186073, 186082, 186081, 186079, 186078, 186118, 186077, 186076, 183367, 183366, 186119, 186069, 184133, 183365, 183364, 186075, 186068, 186071, 186067, 186065, 186064, 186063, 186042, 186054, 186047, 186056, 186044, 186057, 186055, 186061, 186048, 186045, 186051, 186043, 183294, 186083, 186060, 186059, 186058, 186046, 186053, 187115, 186111, 186110, 185457, 186144, 186116, 186113, 186112, 186117, 184134, 186092, 186090, 186108, 186093, 186109, 186106, 186095, 186094, 186091, 186085, 186084, 186105, 186104, 186103, 186102, 186087, 186086, 186107, 186101, 186100, 186089, 186088, 194468, 194467, 194466, 186145, 186098, 186097, 186096, 186099, 185325, 184138, 184137, 186022, 186021, 184556, 209115, 188126, 185998, 185997, 185996, 185995, 185994, 188127, 186016, 186015, 185993, 185991, 185992, 183412, 185989, 185990, 186018, 186017, 185972, 185971, 184911, 183435, 183288, 185976, 185981, 185973, 185986, 185970, 185999, 185983, 185967, 185980, 183289, 185977, 183286, 185974, 183411, 183104, 185204, 182349, 185205, 183323, 187356, 187056, 187357, 183318, 183325, 187057, 187345, 185202, 187058, 185203, 185987, 186000, 185968, 185984, 185978, 183287, 185975, 185988, 185969, 185985, 185982, 185979, 183203, 183169, 183202); +UPDATE `gameobject_template` SET `displayId`=98384, `ContentTuningId`=425, `VerifiedBuild`=57388 WHERE `entry` IN (190060, 190098, 190109, 190057, 190096, 190058, 190061, 190100, 190062, 190099, 190112, 190114, 190113, 190091, 190056, 190090, 190055, 190115, 190116, 190063, 190101, 190059, 190097, 190111, 190110); -- Candy Bucket +UPDATE `gameobject_template` SET `VerifiedBuild`=57388 WHERE `entry` IN (181147, 184236, 184234, 184232, 184230, 181884, 184239, 184229, 181885, 184233, 181883, 184231, 184237, 181331, 184238, 184235, 182056, 182055, 280691, 181895, 181918, 182950, 181889, 181757, 182012, 202275, 182252, 187291, 183860, 183857, 182251, 207322, 182200, 204879, 183859, 183858, 183861, 182948, 181805, 182279, 182278, 181790, 181651, 182949, 181652, 181650, 183864, 184923, 184922, 183870, 183793, 183878, 183865, 183862, 181849, 183863, 183867, 183866, 183891, 194497, 293886, 293885, 208831, 187296, 187337, 142110, 207321, 92696, 92543, 92544, 92695, 195530, 195529, 92539, 92540, 92542, 92541, 92528, 92527, 92693, 92694, 32880, 177272, 142109, 2740, 208046, 1673, 92533, 92529, 92525, 92534, 92535, 92526, 148423, 92699, 180758, 267842, 267843, 195112, 208825, 175730, 267838, 267841, 208814, 208830, 208829, 208815, 267839, 267840, 188123, 91673, 92538, 92536, 91672, 92700, 92524, 92530, 92537); +UPDATE `gameobject_template` SET `displayId`=98384, `VerifiedBuild`=57388 WHERE `entry` IN (190075, 190045, 190041, 190037, 190034, 190038); -- Candy Bucket +UPDATE `gameobject_template` SET `displayId`=98384, `ContentTuningId`=425, `VerifiedBuild`=57388 WHERE `entry` IN (192018, 194084, 194060, 194077, 194059, 194076, 194068, 194061, 194078, 194067, 194066, 194062, 194079, 194065, 194074, 194075, 194073, 191883, 191881, 191882, 191880, 191879, 191878, 194080, 194070, 194119, 194069, 194063, 194064); -- Candy Bucket +UPDATE `gameobject_template` SET `displayId`=98384, `VerifiedBuild`=57388 WHERE `entry` IN (194081, 194071, 194072); -- Candy Bucket +UPDATE `gameobject_template` SET `displayId`=98384, `castBarCaption`='Examining', `Data6`=24124, `ContentTuningId`=425, `VerifiedBuild`=57388 WHERE `entry`=194057; -- Candy Bucket +UPDATE `gameobject_template` SET `displayId`=98384, `castBarCaption`='Examining', `Data6`=24124, `ContentTuningId`=425, `VerifiedBuild`=57388 WHERE `entry`=194056; -- Candy Bucket +UPDATE `gameobject_template` SET `displayId`=98384, `castBarCaption`='Examining', `Data6`=24124, `ContentTuningId`=425, `VerifiedBuild`=57388 WHERE `entry`=194058; -- Candy Bucket +UPDATE `gameobject_template` SET `displayId`=98384, `castBarCaption`='Examining', `Data6`=24124, `ContentTuningId`=425, `VerifiedBuild`=57388 WHERE `entry`=215881; -- Candy Bucket +UPDATE `gameobject_template` SET `displayId`=98384, `ContentTuningId`=425, `VerifiedBuild`=57388 WHERE `entry` IN (215879, 215905, 215906, 215903, 215915, 215875, 215900, 215895, 215899, 215914, 215902, 215877, 215876, 215892, 215904, 215894, 215907, 215891, 215889, 215880, 215884, 215886, 215874); -- Candy Bucket +UPDATE `gameobject_template` SET `displayId`=98384, `VerifiedBuild`=57388 WHERE `entry` IN (215897, 215908); -- Candy Bucket +UPDATE `gameobject_template` SET `displayId`=98384, `castBarCaption`='Examining', `Data6`=24124, `ContentTuningId`=425, `VerifiedBuild`=57388 WHERE `entry`=215898; -- Candy Bucket +UPDATE `gameobject_template` SET `VerifiedBuild`=57388 WHERE `entry` IN (215858, 211720, 214537, 214482, 209891, 216612, 215785, 214638, 215855, 209987, 210300, 210297, 210301, 210298, 210299, 209907, 210296, 211696, 201774, 210520, 216305, 215780, 216757, 216310, 213460, 212507, 215047, 215046, 214061, 214059, 214058, 214057, 213890, 214040, 214060, 214045, 214037, 214054, 214038, 214056, 214055, 214053, 214052, 214051, 214050, 214049, 214048, 214047, 214046, 214044, 214043, 214042, 214041, 214039, 214036, 209572, 215706, 215705, 210938, 210462, 210451, 210448, 210447, 210446, 210445, 210444, 210443, 213461, 215768, 211117, 210946, 210945, 215958, 215854, 213459, 209954, 209953, 210812, 209955, 210811, 210760, 210765, 210769, 214461, 210766, 214465, 210767, 210764, 214361, 214463, 221993, 221992, 210537, 214804, 214801, 214808, 214798, 214805, 210539, 214802, 214809, 214806, 215043, 210538, 214803, 214800, 214807, 215044, 214799, 214797, 214762, 214761, 213058, 213057, 213056, 213055, 213060, 213038, 213064, 213061, 213039, 213065, 213059, 213040, 213037, 213066, 213063, 215039, 215040, 213044, 213043, 213041, 213042, 210803, 215041, 213067, 210763, 213068, 213034, 213033, 212513, 212516, 213045, 213046, 214982, 212518, 212514, 212517, 212515, 213048, 213047, 212520, 212519, 213052, 213062, 213053, 213369, 213334, 213054, 213051, 213800, 213050, 213049, 213414, 213607, 213606, 212106, 213599, 213598, 213608, 213626, 213625, 213635, 212119, 212116, 213620, 213617, 212110, 215119, 213614, 214260, 213619, 213618, 213616, 213609, 213604, 213602, 212117, 212115, 214258, 213636, 213615, 213601, 213628, 213627, 213603, 213600, 213227, 213226, 212118, 213610, 214712, 213632, 213641, 214702, 214713, 214714, 214715, 214716, 214717, 214718, 213629, 214703, 213642, 214711, 212107, 214704, 213643, 214710, 213631, 213630, 214705, 213613, 213644, 214721, 214706, 214698, 214697, 213645, 213224, 212113, 214708, 214683, 214699, 214719, 213647, 214709, 214684, 214681, 214700, 214720, 213648, 214707, 214701, 214689, 214688, 214682, 213612, 213611, 213605, 213225, 222780, 214685, 213831, 213654, 222779, 214687, 214686, 213826, 213825, 213824, 213823, 213655, 213623, 212223, 212221, 212219, 212216, 212215, 212214, 220175, 213830, 213829, 213828, 213827, 212693, 211796, 213004, 177664, 209883, 209882, 209881, 214418, 212296, 212287, 212286, 212285, 209903, 212288, 211797, 214421, 212284, 212283, 209857, 214417, 214339, 214522, 213517, 213519, 213516, 213520, 213518, 213700, 214232, 213683, 213684, 213729, 213730, 214231, 213715, 213705, 213677, 213675, 213674, 213673, 213672, 213122, 213702, 213716, 213697, 215127, 214233, 213728, 213703, 213699, 213678, 213667, 213143, 213142, 213141, 213116, 213115, 213671, 213114, 213693, 213717, 214234, 213668, 213688, 213685, 213692, 215128, 213689, 213680, 213694, 213690, 213706, 213691, 213695, 213686, 213986, 213669, 213987, 213701, 213687, 213727, 214728, 214176, 213991, 213990, 213989, 213726, 213723, 213722, 213704, 213698, 213681, 213670, 213133, 213984, 213721, 213724, 213985, 213714, 213132, 214729, 214727, 213710, 213711, 213725, 213719, 222777, 213720, 213718, 213713, 213712, 213709, 213708, 213707, 213682, 222778, 213696, 212975, 215366, 215365, 215364, 213396, 213298, 213297, 213296, 213295, 210407, 215130, 213395, 213398, 213397, 212976, 215171, 144111, 215363, 214471, 216060, 213254, 334798, 222753, 214539, 218956, 211305, 221677, 221245, 214993, 218953, 218954, 222679, 221751, 218951, 221447, 218955, 214219, 214223, 213156, 221620, 334804, 220372, 221761, 218952, 213162, 214224, 221758, 220369, 334801, 211665, 221678, 213159, 248954, 211662, 222811, 214214, 214895, 222683, 221755, 214380, 222680, 221759, 221752, 213166, 212876, 214220, 219354, 221679, 213157, 334805, 220373, 218957, 214207, 223214, 222754, 334802, 220370, 214218, 214206, 211663, 334799, 221775, 221760, 221663, 214211, 213349, 214885, 214217, 221756, 221676, 222809, 214212, 222681, 221750, 221753, 219353, 214221, 214205, 219355, 214225, 214209, 212927, 214213, 212870, 334806, 221446, 220374, 214899, 212874, 218958, 214222, 214226, 214210, 213347, 213155, 212883, 210680, 334803, 220371, 222682, 221754, 334800, 214208, 214900, 212020, 213255, 221757, 213165, 212881, 213160, 213167, 213161, 212882, 213164, 211664, 214535, 214534, 212880, 212879, 212878, 212771, 212484, 212775, 212664, 212773, 212772, 212774, 214163, 212776, 212777, 212177, 212650, 212649, 212480, 211226, 214772, 214771, 214773, 213355, 213354, 211115, 211114, 211113, 212481, 212479, 211220, 212652, 212651, 214510, 211196, 211195, 211194, 213806, 211147, 211148, 211143, 215966, 215965, 215964, 213379, 212487, 211175, 211172, 211124, 212486, 214766, 214765, 213382, 214764, 214763, 215081, 210943, 219228, 219227, 215082, 211539, 211340, 211181, 211180, 210948, 215131, 210944, 213443, 211325, 211324, 211323, 211508, 211231, 211230, 211228, 211241, 211240, 211229, 213511, 215869, 211548, 211547, 211549, 212013, 214166, 212661, 212660, 212659, 215084, 215083, 213802, 213281, 214968, 212557, 213455, 212175, 209351, 211541, 212971, 212970, 212859, 213803, 210869, 211213, 211210, 211614, 211963, 210870, 211703, 215699, 211615, 211343, 186459, 212903, 211704, 211516, 211204, 211212, 211702, 211446, 211209, 211540, 211205, 186458, 214426, 212048, 215382, 215381, 212047, 214752, 211504, 214753, 211507, 211505, 212973, 211506, 214423, 212445, 212444, 212442, 212441, 214108, 211518, 211515, 210362, 211517, 211619, 211871, 214820, 211872, 211863, 211873, 214739, 214170, 215872, 214818, 213432, 213431, 213428, 213427, 215076, 214991, 214544, 213435, 213434, 213433, 213430, 213429, 212641, 214546, 214545, 215412, 214840, 212016, 209312, 212085, 212084, 211624, 211620, 213249, 212105, 212104, 212100, 212099, 211622, 211621, 215992, 215404, 213195, 209355, 209330, 215910, 214645, 216613, 213637, 213882, 213881, 204272, 213444, 215885, 215077, 213374, 213302, 214907, 214281, 213071, 213381, 213378, 213377, 213376, 214615, 214617, 214616, 216162, 213078, 216304, 214976, 212154, 216274, 216287, 216275, 216300, 214415, 214165, 212658, 212657, 212656, 213865, 214989, 213864, 215170, 213293, 213292, 213291, 212931, 213299, 211474, 212935, 212932, 210209, 215069, 215068, 214440, 212159, 210858, 210857, 210348, 212163, 209350, 211982, 211981, 210618, 210620, 210214, 210191, 222810, 212172, 211977, 210619, 211976, 210228, 210213, 209938, 214355, 212696, 212694, 216675, 216281, 210519, 209921, 216781, 210188, 210186, 210185, 210184, 214164, 212655, 213407, 216838, 195424, 216476, 195436, 216355, 216358, 195451, 195452, 216357, 195425, 216291, 216356, 216250, 216249, 216354, 216248, 216359, 213764, 213762, 213763, 212169, 215187, 215185, 211718, 211717, 215351, 215349, 215973, 210805, 210691, 210622, 210623, 210611, 210615, 210612, 211795, 210614, 210613, 210674, 210616, 175544, 214644, 211609, 211608, 211607, 211577, 211574, 211575, 211773, 211576, 211573, 209586, 209595, 209827, 209830, 209829, 209828, 215318, 213436, 210807, 188216, 212897, 212893, 212892, 212887, 214424, 214408, 212898, 212894, 209354, 212770, 212769, 340097, 212613, 213170, 215781, 213421, 213833, 213832, 210054, 214506, 214505, 215963, 212149, 211813, 211812, 211811, 211810, 211809, 215962, 209784, 209951, 209833, 209826, 214410, 210953, 210941, 210939, 215799, 210940, 214416, 213976, 214414, 214425, 214565, 214564, 211466, 211465, 211464, 209886, 214563, 213840, 213839, 213841, 213838, 210806, 214955, 214954, 214952, 214951, 209313, 214958, 214957, 213982, 213981, 213980, 213979, 213978, 213977, 214960, 214959, 214956, 212174, 216309, 214953, 214411, 211769, 214950, 214949, 214372, 210565, 213090, 213269, 211651, 210925, 214878, 214870, 214869, 213270, 213268, 211956, 211955, 209622, 213271, 213091, 209436, 211771, 212633, 212631, 212626, 212632, 212630, 212629, 212628, 212627, 212620, 212619, 212618, 212617, 212616, 212615, 212614, 212178, 211496, 211495, 211494, 209353, 209462, 209463, 209461, 209460, 209328, 213446, 212325, 209550, 219095, 215692, 212181, 212925, 212624, 214893, 215562, 215756, 210804, 209311, 209780, 215843, 215687, 215693, 215850, 212171, 215860, 215849, 209349, 215684, 215686, 215859, 215683, 215695, 215422, 212625, 212594, 212580, 212186, 212182, 212579, 211693, 212588, 212926, 212590, 216301, 214894, 214569, 212561, 212569, 212621, 211531, 212563, 215563, 212582, 215423, 215391, 212183, 212622, 214568, 211668, 212581, 214987, 212595, 216302, 212564, 212586, 214570, 212570, 212578, 212576, 212565, 212567, 210868, 214567, 212566, 215564, 212623, 212184, 212583, 212924, 212571, 214988, 212559, 212587, 212593, 212584, 212568, 212562, 212589, 212591, 211530, 212560, 212585, 212969, 214566, 212572, 212592); +UPDATE `gameobject_template` SET `displayId`=98384, `castBarCaption`='Examining', `Data6`=24124, `ContentTuningId`=425, `VerifiedBuild`=57388 WHERE `entry`=215873; -- Candy Bucket +UPDATE `gameobject_template` SET `VerifiedBuild`=57388 WHERE `entry` IN (215073, 215864, 215863, 215782, 215072, 216307, 211640, 214179, 210002, 210001, 210023, 213756); + +UPDATE `gameobject_template_addon` SET `flags`=0x40000 WHERE `entry`=251706; -- Crooked Tree Cauldron + +-- Spawns +UPDATE `gameobject` SET `PhaseGroup`=0, `phaseUseFlags`=1 WHERE `id`=208131; + +DELETE FROM `gameobject` WHERE `guid`=3808020 AND `id`=180448; +SET @UPDATED := EXISTS(SELECT * FROM `gameobject` WHERE `guid`=3808020); +UPDATE `gameobject` SET `guid`=`guid`-1 WHERE @UPDATED=0 AND `guid` BETWEEN 3808021 AND 3808386; +DELETE FROM `gameobject` WHERE `guid`=3808387 AND `id`=180453; +SET @UPDATED := EXISTS(SELECT * FROM `gameobject` WHERE `guid` IN (3808386,3808387)); +UPDATE `gameobject` SET `guid`=`guid`-2 WHERE @UPDATED=0 AND `guid` BETWEEN 3808387 AND 3808498; +DELETE FROM `game_event_gameobject` WHERE `guid` IN (3808497,3808498); |