UPDATE gameobject_template SET type=2 WHERE entry IN (175226, 175227, 1585);
DELETE FROM gameobject_template WHERE entry IN  (179727,179728,179731,179733,179881,179899,180102,180125,180164,180165,180166,180167,180168,180184,180228,180229,180244,180247,180322,180323,180327,180358,180364,180365,180366,180369,180386,180392,180396,180397,180398,180400,180405,180406,180407,180408,180409,180410,180411,180412,180415,180417,180421,180422,180423,180424,180425,180426,180427,180428,180429,180431,180432,180433,180434,180435,180442,180448,180451,180471,180472,180497,180502,180503,180514,180523,180526,180529,180534,180632,180633,180655,180656,180657,180658,180663,180664,180666,180667,180682,180683,180684,180712,180728,180750,180788,180866,180898,180899,180904,180913,180915,181056,181075,181076,181077,181078,181079,181080,181081,181082,181103,181104,181106,181130,181131,181143,181144,181145,181236,181257,181355,181476,181598,181618,181619,181899,181955,182075,182076,182077,182078,182079,182080,182081,182096,182097,182106);
INSERT INTO `gameobject_template` VALUES
('180322', '5', '6391', 'Ghost Gate', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('180397', '5', '6135', 'PVP HOLIDAY GENERIC SIGNPOST', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('180400', '5', '6390', 'PVP HOLIDAY ALLIANCE CTF', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('180655', '25', '6434', 'Floating Debris', '1024', '4464896', '512', '1536', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('180682', '25', '6291', 'Oily Blackmouth School', '0', '0', '1', '1024', '4485120', '512', '1536', '0', '0', '0', '0', '0', '0', '', '0'),
('180683', '25', '6482', 'Firefin Snapper School', '0', '0', '1', '1024', '4485376', '512', '1536', '0', '0', '0', '0', '0', '0', '', '0'),
('180712', '25', '6742', 'Stonescale Eel Swarm', '0', '0', '1', '1024', '4489984', '512', '1536', '0', '0', '0', '0', '0', '0', '', '0'),
('180750', '25', '6291', 'Oily Blackmouth School', '0', '0', '1', '1024', '4489472', '512', '153', '0', '0', '0', '0', '0', '0', '', '0'),
('181355', '5', '6765', 'Standing, Medium, Exterior', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('179899', '6', '5931', 'Speed Buff', '0', '0', '1', '0', '0', '0', '6003456', '0', '768', '0', '0', '0', '0', '', '0'),
('179733', '5', '26', 'SI:7', '0', '0', '1', '256', '256', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('179731', '5', '26', 'Command Center', '0', '0', '1', '256', '256', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('179728', '5', '26', 'Champions\' Hall', '0', '0', '1', '256', '256', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('179727', '5', '26', 'Champions\' Hall', '0', '0', '1', '256', '256', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('180405', '5', '6351', 'G_Pumpkin_01', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('180410', '5', '6402', 'G_HangingSkeleton_01', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('180472', '5', '6418', 'HangingSkullLight02', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('180406', '5', '6398', 'G_Pumpkin_02', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('180471', '5', '6417', 'HangingSkullLight01', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('180407', '5', '6399', 'G_Pumpkin_03', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('180408', '5', '6400', 'G_WitchHat_01', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('180409', '5', '6401', 'G_WitchBroom_01', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('180411', '5', '6403', 'G_Ghost_01', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('180412', '5', '6404', 'G_CandyBucket_01', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('180415', '5', '4152', 'CandleBlack01', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('180425', '5', '6406', 'SkullCandle01', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('180426', '5', '6407', 'Bat01', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('180427', '5', '6408', 'Bat02', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('180428', '5', '6401', 'G_WitchBroom_01 scale 0.5', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('180429', '5', '6400', 'G_WitchHat_01 scale 0.5', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('180431', '5', '6351', 'G_Pumpkin_01 scale 4.0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('180432', '5', '6388', 'Forsaken Banner', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('180433', '1', '6422', 'The Wickerman', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('180434', '5', '6411', 'Bonfire', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('180523', '3', '6405', 'Apple Bob', '0', '0', '1', '23808', '4448768', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('180666', '2', '107', 'Draconic for Dummies', '0', '0', '1', '0', '0', '0', '1707520', '0', '0', '0', '0', '0', '0', '', '0'),
('182096', '29', '6834', 'Doodad_BattlefieldBanner_State_Base_Plaguelands02', '0', '0', '1', '20480', '2947840', '621056', '621312', '2705920', '2704896', '2739968', '2739712', '2740480', '2740224', '', '0'),
('182106', '10', '6834', 'Tower Banner', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('180728', '1', '6519', 'Firework, Show, Type 1 White', '0', '0', '1', '0', '0', '50331648', '0', '0', '256', '0', '0', '0', '0', '', '0'),
('179881', '1', '5951', 'The Severed Head of Nefarian', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('180396', '5', '6388', 'PVP HOLIDAY HORDE ARATHI', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('180656', '25', '6435', 'Sagefish School', '0', '0', '1', '1024', '4478464', '512', '1536', '0', '0', '0', '0', '0', '0', '', '0'),
('180658', '25', '6291', 'School of Deviate Fish', '0', '0', '1', '1024', '4478976', '512', '1536', '0', '0', '0', '0', '0', '0', '', '0'),
('180663', '25', '6435', 'Sagefish School', '0', '0', '1', '1024', '4480512', '1024', '2048', '0', '0', '0', '0', '0', '0', '', '0'),
('180684', '25', '6435', 'Greater Sagefish School', '0', '0', '1', '1024', '4484864', '512', '1536', '0', '0', '0', '0', '0', '0', '', '0'),
('180102', '6', '266', 'Neutral Banner Aura', '0', '0', '1', '0', '0', '0', '0', '256', '0', '0', '0', '0', '0', '', '0'),
('180125', '6', '4251', 'Liquid Fire', '0', '0', '1', '0', '15360', '0', '6136832', '0', '0', '16777216', '0', '0', '0', '', '0'),
('180164', '3', '2315', 'Sungrass', '0', '0', '1', '112896', '4403456', '0', '256', '256', '256', '0', '0', '0', '0', '', '0'),
('180165', '3', '2314', 'Purple Lotus', '0', '0', '1', '112384', '4403200', '0', '256', '256', '256', '0', '0', '0', '0', '', '0'),
('180166', '3', '4633', 'Mountain Silversage', '0', '0', '1', '286976', '4404224', '0', '256', '256', '256', '0', '0', '0', '0', '', '0'),
('180167', '3', '4652', 'Golden Sansam', '0', '0', '1', '286464', '4403712', '0', '256', '256', '256', '0', '0', '0', '0', '', '0'),
('180168', '3', '4635', 'Dreamfoil', '0', '0', '1', '286720', '4403968', '0', '256', '256', '256', '0', '0', '0', '0', '', '0'),
('180184', '25', '6291', 'School of Fish', '0', '0', '1', '768', '362240', '2560', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('180228', '3', '6393', 'Jinxed Hoodoo Pile', '0', '0', '1', '11008', '4418304', '0', '256', '0', '0', '0', '46143232', '0', '0', '', '0'),
('180229', '3', '6393', 'Jinxed Hoodoo Pile', '0', '0', '1', '11008', '4418304', '0', '256', '0', '0', '0', '46142463', '0', '0', '', '0'),
('180244', '6', '1287', 'Jinxed Hoodoo Pile', '0', '0', '1', '24320', '0', '0', '6191104', '256', '0', '0', '0', '0', '0', '', '0'),
('180247', '6', '1287', 'Jinxed Hoodoo Pile', '0', '0', '1', '24320', '0', '0', '0', '256', '0', '0', '0', '0', '0', '', '0'),
('180323', '0', '4552', 'Gates of Zul\'Gurub', '0', '0', '1', '0', '0', '167772160', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('180327', '1', '2570', 'Brazier of Madness', '0', '0', '1', '0', '414464', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('180358', '2', '5', 'Gri\'lek, with the Iron Blood', '0', '0', '1', '0', '0', '256', '1650688', '0', '0', '0', '0', '0', '0', '', '0'),
('180364', '2', '5', 'Hazza\'rah, the Dreamweaver', '0', '0', '1', '0', '0', '256', '1650944', '0', '0', '0', '0', '0', '0', '', '0'),
('180365', '2', '5', 'Renataki, of the Thousand Blades', '0', '0', '1', '0', '0', '256', '1651200', '0', '0', '0', '0', '0', '0', '', '0'),
('180366', '2', '318', 'Battered Tackle Box', '0', '0', '1', '11008', '1784576', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('180369', '25', '6291', 'Muddy Churning Waters', '0', '0', '1', '768', '4434176', '512', '768', '0', '0', '0', '0', '0', '0', '', '0'),
('180386', '5', '6383', 'Gong', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('180392', '3', '213', 'Full Jug', '0', '0', '1', '14592', '4436736', '0', '256', '0', '0', '0', '0', '0', '0', '', '0'),
('180398', '5', '5651', 'PVP HOLIDAY ALLIANCE ARATHI', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('180417', '5', '192', 'Campfire', '0', '0', '1', '1024', '2560', '527616', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('180421', '6', '6492', 'Alliance Banner Aura, Large', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('180422', '6', '1311', 'Horde Banner Aura, Large', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('180423', '6', '266', 'Neutral Banner Aura, Large', '0', '0', '1', '0', '0', '0', '0', '256', '0', '0', '0', '0', '0', '', '0'),
('180424', '0', '3751', 'Alterac Valley Gate', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('180435', '3', '323', 'Noggle\'s Satchel', '0', '0', '1', '23808', '4441344', '0', '256', '0', '0', '0', '0', '0', '0', '', '0'),
('180442', '8', '680', 'Bonfire', '0', '0', '1', '1024', '2560', '528896', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('180448', '2', '3053', 'Wanted Poster: Deathclasp', '0', '0', '1', '0', '1794304', '256', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('180451', '19', '1948', 'Mailbox', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('180497', '0', '6385', 'Forcefield', '0', '0', '1', '256', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('180502', '6', '3972', 'Wind Stone', '0', '0', '1', '0', '0', '0', '6349568', '0', '256', '0', '0', '0', '0', '', '0'),
('180503', '2', '470', 'Sandy Cookbook', '0', '0', '1', '0', '1795328', '256', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('180514', '1', '6431', 'Glyphed Crystal Prism', '0', '0', '1', '0', '0', '50331648', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('180526', '10', '1827', 'Gong of Bethekk', '0', '0', '1', '0', '0', '2320896', '50331648', '0', '0', '0', '0', '0', '0', '', '0'),
('180529', '2', '6425', 'Lesser Wind Stone', '0', '0', '1', '0', '0', '0', '1674240', '0', '0', '0', '0', '0', '0', '', '0'),
('180534', '2', '6426', 'Wind Stone', '0', '0', '1', '0', '0', '0', '1674752', '0', '0', '0', '0', '0', '0', '', '0'),
('180632', '8', '6467', 'Alchemy Lab', '0', '0', '1', '169728', '2560', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('180633', '2', '5746', 'Crystalline Tear', '0', '0', '1', '0', '1807872', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('180657', '25', '6482', 'Firefin Snapper School', '0', '0', '1', '1024', '4480000', '512', '1536', '0', '0', '0', '0', '0', '0', '', '0'),
('180664', '25', '6291', 'Oily Blackmouth School', '0', '0', '1', '1024', '4479232', '512', '1536', '0', '0', '0', '0', '0', '0', '', '0'),
('180667', '2', '6488', 'Draconic for Dummies', '0', '0', '1', '0', '0', '0', '1707008', '0', '0', '0', '0', '0', '0', '', '0'),
('180788', '5', '3972', 'AQDOORSOUND', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('180866', '5', '1287', 'Event Generator Saurfang Pre-War', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('180898', '0', '4134', 'AQRUNE', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('180899', '0', '4133', 'AQROOT', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('180904', '0', '4132', 'Ancient Door', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('180913', '8', '233', 'Forge', '0', '0', '1', '256', '2560', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('180915', '8', '197', 'Cooking Brazier', '0', '0', '1', '1024', '2560', '527616', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('181056', '15', '6637', 'Naxxramas', '0', '0', '1', '111616', '256', '256', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('181075', '5', '221', 'Table', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('181076', '7', '39', 'Inigo\'s Chair', '0', '0', '1', '256', '256', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('181077', '5', '159', 'Rug', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('181078', '7', '39', 'Marjhan\'s Chair', '0', '0', '1', '256', '256', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('181079', '7', '39', 'Eligor\'s Chair', '0', '0', '1', '256', '256', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('181080', '7', '39', 'Angela\'s Chair', '0', '0', '1', '256', '256', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('181081', '5', '222', 'Map of the Eastern Plaguelands', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('181082', '5', '240', 'Candelabra', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('181103', '5', '6662', 'Flower', '0', '0', '1', '0', '256', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('181104', '5', '20', 'Small Dirt Mound', '0', '0', '1', '0', '256', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('181106', '22', '6671', 'Lightwell', '0', '0', '1', '7135744', '1280', '256', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('181130', '8', '233', 'Forge', '0', '0', '1', '768', '2560', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('181131', '8', '273', 'Anvil', '0', '0', '1', '256', '2560', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('181143', '5', '564', 'Fish of the Day', '0', '0', '1', '0', '256', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('181144', '5', '563', 'Bowl of Fruit', '0', '0', '1', '0', '256', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('181145', '5', '566', 'Roast Boar Platter', '0', '0', '1', '0', '256', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('181236', '19', '1907', 'Mailbox', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('181257', '5', '6709', 'Argent Dawn Banner', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('181476', '5', '6774', 'Nox Portal Plaguewood', '0', '0', '1', '0', '0', '0', '256', '0', '0', '0', '0', '0', '0', '', '0'),
('181598', '10', '6862', 'Silithyst Geyser', '0', '0', '1', '5264976', '1635', '0', '0', '65536', '0', '1', '0', '0', '0', '', '0'),
('181618', '6', '2232', 'Tovv@vv - Flag Cap Counter, Alliance', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('181619', '6', '1311', 'Tovv@vv - Flag Cap Counter, Horde', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('181899', '29', '6834', 'Doodad_BattlefieldBanner_State_Base_Plaguelands01', '0', '0', '1', '20480', '2947840', '621056', '621312', '2705408', '2702336', '2738432', '2738176', '2738944', '2738688', '', '0'),
('181955', '10', '6873', 'Lordaeron Shrine', '0', '0', '1', '418560', '0', '0', '8388608', '0', '0', '0', '0', '0', '0', '', '0'),
('182075', '5', '6608', 'ElvenWoodenTable', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('182076', '5', '6035', 'Elf Crate', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('182077', '5', '6912', 'Night Elf Stool', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('182078', '5', '6913', 'Nightelf Glowing Bowl', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('182079', '5', '6914', 'Nightelf Stone Rune', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('182080', '5', '247', 'Nightelf Stone Rune', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('182081', '5', '236', 'Nightelf Stone Rune', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'),
('182097', '29', '6834', 'Doodad_BattlefieldBanner_State_Base_Plaguelands03', '0', '0', '1', '20480', '2947840', '621056', '621312', '2705664', '2704640', '2736384', '2736640', '2736896', '2737152', '', '0');
UPDATE gameobject_template SET `type`=2 WHERE entry=175320;
DELETE FROM gameobject_template WHERE entry IN ('210312', '210313', '210327', '210328', '210329', '210330', '210331', '210332', '210334', '210335', '210336', '210337', '210338', '210339', '210341', '210342', '210343', '210344', '210345', '210346', '210347', '210348', '210349'); 
INSERT INTO gameobject_template VALUES 
('210312', '5', '6486', 'Ahn\'Qiraj Ossirian Crystal', '0', '0', '5', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'), 
('210313', '5', '6486', 'Ahn\'Qiraj Ossirian Crystal', '0', '0', '4', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'), 
('210327', '0', '6427', 'Communication Crystal', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'), 
('210328', '0', '6426', 'Communication Crystal', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'), 
('210329', '0', '6425', 'Communication Crystal', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'), 
('210330', '0', '6427', 'Communication Crystal', '0', '0', '1', '0', '879', '655360', '0', '0', '0', '0', '0', '0', '0', '', '0'), 
('210331', '0', '6426', 'Communication Crystal', '0', '0', '1', '0', '879', '655360', '0', '0', '0', '0', '0', '0', '0', '', '0'), 
('210332', '0', '6425', 'Communication Crystal', '0', '0', '1', '0', '879', '655360', '0', '0', '0', '0', '0', '0', '0', '', '0'), 
('210334', '2', '4675', 'Ahn\'Qiraj Gong', '84', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'), 
('210335', '5', '6419', 'Twilight Tablet', '0', '40', '2', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'), 
('210336', '5', '6420', 'Twilight Tablet', '0', '40', '2', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'), 
('210337', '8', '6431', 'Glyphed Crystal', '0', '0', '3', '643', '15', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'), 
('210338', '8', '3431', 'Gorishi Silithid Crystal', '0', '0', '1', '643', '15', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'), 
('210339', '5', '6483', 'Ahn\'Qiraj Sand Trap', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'), 
('210341', '5', '6667', 'Hive Fireflies 01', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'), 
('210342', '5', '6431', 'Glyphed Crystal', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'), 
('210343', '5', '6559', 'Sand Worm Rock Base', '0', '0', '6.5', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'), 
('210344', '5', '6570', 'Silithus Crystal Formation 03', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'), 
('210345', '5', '6571', 'Floating Red Crystal Broken 03', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'), 
('210346', '5', '6573', 'Floating Red Crystal Broken 01', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'), 
('210347', '0', '6470', 'Ahn\'Qiraj Door 01', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'), 
('210348', '5', '1667', 'Floating Purple Crystal Broken 01', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0'), 
('210349', '2', '6486', 'Gastric Exit', '0', '40', '1', '0', '76', '1', '0', '0', '0', '0', '0', '0', '0', '', '0'); 
UPDATE gameobject_template SET name='Gate of Ahn\'Qiraj' WHERE entry='176146'; 
UPDATE gameobject_template SET name='Ahn\'Qiraj Gate Roots' WHERE entry='176147'; 
UPDATE gameobject_template SET name='Ahn\'Qiraj Gate Runes' WHERE entry='176148';
UPDATE `gameobject_template` SET `name` = 'Moonwell', `sound0` = '226048', `sound1` = '2560' WHERE `entry` = '177272';
UPDATE `gameobject_template` SET `sound0` = '1024', `sound1` = '2560', `sound2` = '38137856' WHERE `entry` = '171552';
UPDATE `gameobject_template` SET `sound0` = '241' WHERE `entry` =20808 LIMIT 1;
UPDATE `gameobject_template` SET `sound0` = '302' WHERE `entry` =164871 LIMIT 1;
UPDATE `gameobject_template` SET `sound0` = '285' WHERE `entry` =175080 LIMIT 1;
UPDATE `gameobject_template` SET `sound0` = '292' WHERE `entry` =176231 LIMIT 1;
UPDATE `gameobject_template` SET `sound0` = '293' WHERE `entry` =176244 LIMIT 1;
UPDATE `gameobject_template` SET `sound0` = '295' WHERE `entry` =176310 LIMIT 1;
UPDATE `gameobject_template` SET `sound0` = '301' WHERE `entry` =176495 LIMIT 1;
UPDATE `gameobject_template` SET `sound0` = '303' WHERE `entry` =177233 LIMIT 1;