diff options
-rw-r--r-- | sql/updates/world/6.x/2016_09_28_01_world.sql | 570 |
1 files changed, 570 insertions, 0 deletions
diff --git a/sql/updates/world/6.x/2016_09_28_01_world.sql b/sql/updates/world/6.x/2016_09_28_01_world.sql new file mode 100644 index 00000000000..a0fd8aec43f --- /dev/null +++ b/sql/updates/world/6.x/2016_09_28_01_world.sql @@ -0,0 +1,570 @@ +DELETE FROM `gameobject_template` WHERE `entry` IN (254132 /*Bonfire*/, 247539 /*Plaque*/, 251757 /*Glimmering Treasure Chest*/, 247959 /*Brimstone Destroyer Core*/, 252872 /*The Song of Scales*/, 233523 /*Mysterious Petrified Pod*/, 250102 /*Treasure Chest*/, 252390 /*Ink-splattered Page*/, 252871 /*Beyond the Throne of Air*/, 245335 /*Proximity Bomb*/, 257865 /*Doodad_7LG_Legion_CageHanging001*/, 255000 /*Twisting Roots*/, 251995 /*Portal*/, 251555 /*Eye of Il'gynoth's Forcefield*/, 248850 /*Wall of Roots*/, 248849 /*Wall of Roots*/, 248848 /*NgihtmareRaid_UnGoro_RootWall03*/, 251997 /*Portal*/, 254247 /*Corrupted Power Crystal*/, 254248 /*Corrupted Power Crystal*/, 254249 /*Corrupted Power Crystal*/, 251980 /*Nightmare Iris*/, 254273 /*The Emerald Dreamway*/, 254271 /*Thunder Bluff*/, 254272 /*Grizzly Hills*/, 254270 /*Un'goro Crater*/, 248927 /*Thunder Bluff Vines*/, 248925 /*Entrance Vines*/, 248928 /*Grizzly Vines*/, 248929 /*Dragons Vines*/, 248926 /*Ungoro Vines*/, 260550 /*Doodad_7DU_Nightmare_RootWall008*/, 260552 /*Doodad_7DU_Nightmare_RootWall010*/, 260551 /*Doodad_7DU_Nightmare_RootWall009*/, 251534 /*Doodad_7DU_Nightmare_RootWall002*/, 251533 /*Doodad_7DU_Nightmare_RootWall001*/, 251535 /*Doodad_7DU_Nightmare_RootWall003*/, 251536 /*Doodad_7DU_Nightmare_RootWall004*/, 247497 /*Wild Northern Barracuda School*/); +INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `size`, `Data0`, `Data1`, `Data2`, `Data3`, `Data4`, `Data5`, `Data6`, `Data7`, `Data8`, `Data9`, `Data10`, `Data11`, `Data12`, `Data13`, `Data14`, `Data15`, `Data16`, `Data17`, `Data18`, `Data19`, `Data20`, `Data21`, `Data22`, `Data23`, `Data24`, `Data25`, `Data26`, `Data27`, `Data28`, `Data29`, `Data30`, `Data31`, `Data32`, `RequiredLevel`, `VerifiedBuild`) VALUES +(254132, 8, 9241, 'Bonfire', '', '', '', 0.9300001, 4, 10, 2066, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 22566), -- Bonfire +(247539, 9, 13616, 'Plaque', 'inspect', '', '', 1, 5252, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 22566), -- Plaque +(251757, 3, 33266, 'Glimmering Treasure Chest', '', 'Opening', '', 2, 1744, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 21400, 0, 0, 0, 110, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1476, 66936, 0, 0, 98, 22566), -- Glimmering Treasure Chest +(247959, 3, 25536, 'Brimstone Destroyer Core', '', '', '', 10, 38, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 46832, 110, 1, 0, 0, 0, 800, 800, 0, 205060, 0, 0, 0, 60612, 0, 0, 98, 22566), -- Brimstone Destroyer Core +(252872, 3, 34727, 'The Song of Scales', 'openhandglow', 'Retrieving', '', 1.5, 1691, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 23645, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 67961, 1, 0, 0, 22566), -- The Song of Scales +(233523, 3, 7918, 'Mysterious Petrified Pod', '', 'Opening', '', 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 21400, 0, 0, 0, 93, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 54529, 0, 0, 92, 22566), -- Mysterious Petrified Pod +(250102, 3, 33265, 'Treasure Chest', '', 'Opening', '', 1, 57, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 21400, 0, 0, 0, 110, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1357, 66167, 0, 0, 98, 22566), -- Treasure Chest +(252390, 9, 15781, 'Ink-splattered Page', '', '', '', 1, 5419, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 22566), -- Ink-splattered Page +(252871, 3, 36036, 'Beyond the Throne of Air', 'openhandglow', 'Retrieving', '', 1, 1691, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 23645, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 67960, 1, 0, 0, 22566), -- Beyond the Throne of Air +(245335, 6, 20538, 'Proximity Bomb', '', '', '', 0.5, 0, 112, 2, 196155, 1, 0, 0, 4, 0, 0, 0, 0, 0, 0, 0, 27108, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 22566), -- Proximity Bomb +(257865, 5, 31442, 'Doodad_7LG_Legion_CageHanging001', '', '', '', 1.107711, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 22566), -- Doodad_7LG_Legion_CageHanging001 +(255000, 0, 32552, 'Twisting Roots', '', '', '', 3.87, 1, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 22566), -- Twisting Roots +(251995, 10, 36949, 'Portal', '', '', '', 1.39, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 22566), -- Portal +(251555, 0, 6391, 'Eye of Il''gynoth''s Forcefield', '', '', '', 2.37, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 22566), -- Eye of Il'gynoth's Forcefield +(248850, 0, 32552, 'Wall of Roots', '', '', '', 1.79, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 22566), -- Wall of Roots +(248849, 0, 32552, 'Wall of Roots', '', '', '', 1.74, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 22566), -- Wall of Roots +(248848, 0, 32552, 'NgihtmareRaid_UnGoro_RootWall03', '', '', '', 1.13, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 22566), -- NgihtmareRaid_UnGoro_RootWall03 +(251997, 10, 36949, 'Portal', '', '', '', 0.82, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 22566), -- Portal +(254247, 10, 2974, 'Corrupted Power Crystal', '', '', '', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 224937, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 22566), -- Corrupted Power Crystal +(254248, 10, 2973, 'Corrupted Power Crystal', '', '', '', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 224938, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 22566), -- Corrupted Power Crystal +(254249, 10, 2972, 'Corrupted Power Crystal', '', '', '', 1.1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 224939, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 22566), -- Corrupted Power Crystal +(251980, 10, 35699, 'Nightmare Iris', 'openhand', '', '', 1.738989, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 224881, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 22566), -- Nightmare Iris +(254273, 5, 36810, 'The Emerald Dreamway', '', '', '', 4, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 22566), -- The Emerald Dreamway +(254271, 5, 36808, 'Thunder Bluff', '', '', '', 4, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 22566), -- Thunder Bluff +(254272, 5, 36809, 'Grizzly Hills', '', '', '', 4, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 22566), -- Grizzly Hills +(254270, 5, 36807, 'Un''goro Crater', '', '', '', 4, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 22566), -- Un'goro Crater +(248927, 10, 33127, 'Thunder Bluff Vines', '', '', '', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 22566), -- Thunder Bluff Vines +(248925, 10, 33125, 'Entrance Vines', '', '', '', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 22566), -- Entrance Vines +(248928, 10, 33128, 'Grizzly Vines', '', '', '', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 22566), -- Grizzly Vines +(248929, 10, 33129, 'Dragons Vines', '', '', '', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 22566), -- Dragons Vines +(248926, 10, 33126, 'Ungoro Vines', '', '', '', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 22566), -- Ungoro Vines +(260550, 0, 32552, 'Doodad_7DU_Nightmare_RootWall008', '', '', '', 1.75465, 1, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 22566), -- Doodad_7DU_Nightmare_RootWall008 +(260552, 0, 32552, 'Doodad_7DU_Nightmare_RootWall010', '', '', '', 1.75465, 1, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 22566), -- Doodad_7DU_Nightmare_RootWall010 +(260551, 0, 32552, 'Doodad_7DU_Nightmare_RootWall009', '', '', '', 1.75465, 1, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 22566), -- Doodad_7DU_Nightmare_RootWall009 +(251534, 0, 32552, 'Doodad_7DU_Nightmare_RootWall002', '', '', '', 1.819293, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 22566), -- Doodad_7DU_Nightmare_RootWall002 +(251533, 0, 32552, 'Doodad_7DU_Nightmare_RootWall001', '', '', '', 1.819293, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 22566), -- Doodad_7DU_Nightmare_RootWall001 +(251535, 0, 32552, 'Doodad_7DU_Nightmare_RootWall003', '', '', '', 1.819293, 1, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 22566), -- Doodad_7DU_Nightmare_RootWall003 +(251536, 0, 32552, 'Doodad_7DU_Nightmare_RootWall004', '', '', '', 2.030513, 1, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 22566), -- Doodad_7DU_Nightmare_RootWall004 +(247497, 25, 6435, 'Wild Northern Barracuda School', '', '', '', 1, 4, 64835, 1, 2, 1628, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 22566); -- Wild Northern Barracuda School + +UPDATE `gameobject_template` SET `RequiredLevel`=92, `VerifiedBuild`=22566 WHERE `entry`=236139; -- Explorer Canister +UPDATE `gameobject_template` SET `RequiredLevel`=92, `VerifiedBuild`=22566 WHERE `entry`=236178; -- Evermorn Supply Cache +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=233150; -- Laughing Skull Mask +UPDATE `gameobject_template` SET `RequiredLevel`=92, `VerifiedBuild`=22566 WHERE `entry`=233149; -- Laughing Skull Cache +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=236290; -- Cooking Fire +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=236291; -- Forge +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=236292; -- Anvil +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=237569; -- Cooking Fire +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=236253; -- Cooking Fire +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=233959; -- Do Not Touch +UPDATE `gameobject_template` SET `RequiredLevel`=92, `VerifiedBuild`=22566 WHERE `entry`=233917; -- Femur of Improbability +UPDATE `gameobject_template` SET `Data8`=0, `VerifiedBuild`=22566 WHERE `entry`=233367; -- Ogre Cage +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=228007; -- Doodad_StratholmeFloatingEmbers076 +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=238650; -- Bonfire +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=238600; -- Bonfire +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=216829; -- Bed Roll +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=224372; -- Camp Fire +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=238617; -- Brazier +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=236479; -- Bench +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=236478; -- Bench +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=236477; -- Bench +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=236476; -- Campfire +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=236481; -- Campfire +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=236482; -- Campfire +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=221662; -- Sloppy Blood Pool +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=221990; -- Orc Arrow +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=190169; -- Tiger Lily +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=190621; -- Blight Spreader +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=192057; -- Nettlefish School +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=190702; -- Lifeblood Shard +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=190768; -- Timeworn Coffer +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=190509; -- Activation Switch Theta +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=189980; -- Saronite Deposit +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=193991; -- Altar of the Ebon Depths +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=190171; -- Lichbloom +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=192242; -- The Skybreaker +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=193471; -- 193471 +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=192241; -- Orgrim's Hammer +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=192820; -- 192820 +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=201761; -- The Pit of Saron Portcullis +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=201760; -- The Halls of Reflection Gate +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=201759; -- The Forge of Souls Portcullis +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=192234; -- Argent Vanguard Tower +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=192233; -- Argent Vanguard Support +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=192232; -- Argent Vanguard Tower +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=192231; -- Argent Vanguard Support +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=192230; -- Argent Vanguard Tower +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=192229; -- Argent Vanguard Support +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=192228; -- Argent Vanguard Support +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=192227; -- Argent Vanguard Tower +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=194012; -- Portal to The Violet Citadel +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=194018; -- Chair +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=194011; -- Portal to The Purple Parlor +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=194019; -- Chair +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=193786; -- Bench +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=192070; -- Lamp Post +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=193933; -- Stool +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=193932; -- Stool +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=191886; -- Chair +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=192855; -- Gnome & Goblin Engineering Manuals Available Inside! +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=192854; -- Lamp Post +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=192856; -- Like Clockwork +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=192847; -- Legendary Leathers +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=187299; -- Guild Vault +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=194147; -- Mailbox +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=192849; -- Talismanic Textiles +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=192852; -- Lamp Post +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=193624; -- Chair +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=193578; -- Chair +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=191732; -- Sisters Sorcerous +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=193627; -- Chair +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=192843; -- First to Your Aid +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=191230; -- Teleport to Dalaran Crystal +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=193214; -- Uncut Azure Focus +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=193189; -- Chair +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=192841; -- Chair +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=192840; -- Chair +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=192838; -- Chair +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=192839; -- Chair +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=193190; -- Stove +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=191956; -- Mailbox +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=193929; -- Stool +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=191444; -- Lamp Post +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=193949; -- Chair +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=192067; -- Lamp Post +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=192068; -- Lamp Post +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=191952; -- Mailbox +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=191445; -- Lamp Post +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=191688; -- A Hero's Welcome +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=214500; -- Instance Portal (Party + Heroic) +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=193987; -- Unidentified Remains +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=192010; -- Chair +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=192103; -- Lamp +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=192116; -- Lamp Post +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=192090; -- Lamp +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=191687; -- Curiosities & Moore Consignment House +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=192102; -- Lamp +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=191677; -- The Arsenal Absolute +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=192220; -- Bench +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=192219; -- Bench +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=193071; -- Mailbox +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=193916; -- Stool +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=191954; -- Mailbox +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=191984; -- Chair +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=191983; -- Chair +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=193918; -- Stool +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=192087; -- Lamp Post +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=193915; -- Stool +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=191678; -- Dalaran Visitor Center +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=192086; -- Lamp Post +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=191941; -- NEW IN STOCK! Enchanted Ammunition from Azeroth & Beyond! +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=191679; -- The Hunter's Reach +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=192905; -- The Old Wizard's Almanac +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=164659; -- Green Power Crystal +UPDATE `gameobject_template` SET `type`=50, `Data0`=38, `Data3`=0, `Data4`=245, `Data5`=295, `Data6`=15, `Data12`=55, `Data13`=1, `Data18`=10, `Data19`=0, `VerifiedBuild`=22566 WHERE `entry`=175404; -- Rich Thorium Vein +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=164958; -- Bloodpetal Sprout +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=164779; -- Green Power Crystal +UPDATE `gameobject_template` SET `type`=50, `Data3`=0, `Data4`=270, `Data5`=320, `Data6`=15, `Data12`=47, `Data13`=1, `Data18`=10, `Data19`=0, `Data23`=0, `Data24`=0, `VerifiedBuild`=22566 WHERE `entry`=142144; -- Ghost Mushroom +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=324; -- Small Thorium Vein +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=142142; -- Sungrass +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=206742; -- Twilight Cage +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=206767; -- Magatha's Bonds Controller +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=206743; -- Twilight Cage +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=205368; -- Grimtotem Weapon Rack +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=175675; -- Cooking Fire +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=1734; -- Gold Vein +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=2045; -- Stranglekelp +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=2040; -- Mithril Deposit +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=203228; -- Needles Iron Pyrite +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=203221; -- The Ancient Brazier +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=2555; -- Musty Scroll +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=177928; -- Onyxia's Gate +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=20968; -- Campfire +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=186630; -- Forge +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=186629; -- Mailbox +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=186631; -- Anvil +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=20849; -- Bonfire +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=202596; -- Frazzlecraz Explosives +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=2041; -- Liferoot +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=180684; -- Greater Sagefish School +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=186301; -- Blackhoof Armaments +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=2046; -- Goldthorn +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=1735; -- Iron Deposit +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=201703; -- Fresh Carcass +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=202405; -- Northwatch Supply Crate +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=186287; -- Blackhoof Cage +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=195146; -- Thunderhead Summit +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=195206; -- Curious Pirate Landmark +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=169969; -- Forge +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=169968; -- Anvil +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=175729; -- Mount Hyjal and Illidan's Gift +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=174858; -- Ironzar's Imported Weaponry +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=169967; -- Blacksmith +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=175731; -- Exile of the High Elves +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=169966; -- Anvil +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=56898; -- Plate-n-Chain +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=21679; -- Forge +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=174857; -- Jazzik's General Goods +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=21277; -- Crate with Holes +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=20808; -- Ship (The Maiden's Fancy) +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=203825; -- Campfire +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=3729; -- Briarthorn +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=3727; -- Mageroyal +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=3725; -- Silverleaf +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=174849; -- 174849 +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=3724; -- Peacebloom +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=180663; -- Sagefish School +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=186714; -- Shoutbox +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=186173; -- Brewfest Keg Breakable +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=186682; -- Brewfest Beer Tent +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=186681; -- Brewfest Food Tent +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=186229; -- BREWFEST +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=180749; -- Cheer Speaker +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=186709; -- Standing Brewfest Keg +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=180037; -- Haybail 01 +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=179975; -- Water Trough Small +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=186252; -- Fence +UPDATE `gameobject_template` SET `Data26`=1, `VerifiedBuild`=22566 WHERE `entry`=186189; -- Alcohol-Free Brewfest Sampler +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=180698; -- Party Table +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=195265; -- Standing, Large - Brewfest +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=186680; -- Brewfest Canopy +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=215424; -- Portal to Honeydew Village +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=215131; -- Opened Door 03 +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=214535; -- Opened Door 02 +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=214534; -- Opened Door 01 +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=214501; -- Instance Portal (Party + Heroic) +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=243393; -- Mysterious Skeleton +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=241127; -- Unguarded Thistleleaf Treasure +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=190536; -- Ship, Icebreaker (Stormwind's Pride) +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=187884; -- Evanor's Prison +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=190352; -- Doodad_HU_Portcullis03 +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=188514; -- Doodad_Nexus_Elevator_BaseStructure_01 +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=188521; -- Elevator +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=254125; -- Firmament Stone +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=165658; -- Dark Iron Deposit +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=175739; -- War of the Three Hammers +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=175725; -- The Old Gods and the Ordering of Azeroth +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=175736; -- Ironforge - the Awakening of the Dwarves +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=246664; -- Test Kitchen Results +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=246710; -- Nomi's Silver Mackerel +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=246664; -- Test Kitchen Results +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=246710; -- Nomi's Silver Mackerel +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=208807; -- Nexus Runes (Large) +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=191083; -- Demonic Circle: Summon +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=208595; -- Ghost State - 2.00 +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=208591; -- Haunted War Drum +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=216057; -- Portal to Vale of Eternal Blossoms +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=175739; -- War of the Three Hammers +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=175736; -- Ironforge - the Awakening of the Dwarves +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=175725; -- The Old Gods and the Ordering of Azeroth +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=165658; -- Dark Iron Deposit +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=246664; -- Test Kitchen Results +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=246710; -- Nomi's Silver Mackerel +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=246664; -- Test Kitchen Results +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=246710; -- Nomi's Silver Mackerel +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=241127; -- Unguarded Thistleleaf Treasure +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=204018; -- Alliance Gunship +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=175739; -- War of the Three Hammers +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=175736; -- Ironforge - the Awakening of the Dwarves +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=175725; -- The Old Gods and the Ordering of Azeroth +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=165658; -- Dark Iron Deposit +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=246664; -- Test Kitchen Results +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=246710; -- Nomi's Silver Mackerel +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=175736; -- Ironforge - the Awakening of the Dwarves +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=175725; -- The Old Gods and the Ordering of Azeroth +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=175739; -- War of the Three Hammers +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=165658; -- Dark Iron Deposit +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=243393; -- Mysterious Skeleton +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=246664; -- Test Kitchen Results +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=246710; -- Nomi's Silver Mackerel +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=243563; -- Barrel of Fish Oil +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=243393; -- Mysterious Skeleton +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=243564; -- Basket of Dried Herbs +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=249395; -- Twilight Dragon Egg +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=249394; -- Twilight Dragon Egg +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=202736; -- Obsidium Deposit +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=202750; -- Heartblossom +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=204018; -- Alliance Gunship +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=214501; -- Instance Portal (Party + Heroic) +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=246664; -- Test Kitchen Results +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=246710; -- Nomi's Silver Mackerel +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=241127; -- Unguarded Thistleleaf Treasure +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=246664; -- Test Kitchen Results +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=246710; -- Nomi's Silver Mackerel +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=241127; -- Unguarded Thistleleaf Treasure +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=246664; -- Test Kitchen Results +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=246710; -- Nomi's Silver Mackerel +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=241127; -- Unguarded Thistleleaf Treasure +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=246664; -- Test Kitchen Results +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=246710; -- Nomi's Silver Mackerel +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=254125; -- Firmament Stone +UPDATE `gameobject_template` SET `type`=5, `Data2`=0 WHERE `entry`=258226; -- Black Rook Gate +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=241127; -- Unguarded Thistleleaf Treasure +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=208595; -- Ghost State - 2.00 +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=208591; -- Haunted War Drum +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=246664; -- Test Kitchen Results +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=246710; -- Nomi's Silver Mackerel +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=186738; -- Brewfest Pony Keg +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=186738; -- Brewfest Pony Keg +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=251122; -- Ancient Highborne Tome +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=214501; -- Instance Portal (Party + Heroic) +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=243564; -- Basket of Dried Herbs +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=243563; -- Barrel of Fish Oil +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=243393; -- Mysterious Skeleton +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=324; -- Small Thorium Vein +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=180684; -- Greater Sagefish School +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=2046; -- Goldthorn +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=1735; -- Iron Deposit +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=1624; -- Kingsblood +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=2043; -- Khadgar's Whisker +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=2042; -- Fadeleaf +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=142143; -- Blindweed +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=202596; -- Frazzlecraz Explosives +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=186287; -- Blackhoof Cage +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=2041; -- Liferoot +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=201738; -- Budding Flower +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=201737; -- Budding Flower +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=220178; -- Bonfire +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=149038; -- Table Cooker +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=106326; -- Blazing Fire +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=143982; -- Mailbox +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=106335; -- Blazing Fire +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=123328; -- Campfire +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=3727; -- Mageroyal +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=3729; -- Briarthorn +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=174849; -- 174849 +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=20808; -- Ship (The Maiden's Fancy) +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=3726; -- Earthroot +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=180663; -- Sagefish School +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=180047; -- Westfall Chair +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=126051; -- Bench +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=126050; -- Bench +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=183871; -- Blunt Weapons +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=246664; -- Test Kitchen Results +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=246710; -- Nomi's Silver Mackerel +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=246664; -- Test Kitchen Results +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=246710; -- Nomi's Silver Mackerel +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=202747; -- Cinderbloom +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=205359; -- Portal to Therazane's Throne +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=204018; -- Alliance Gunship +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=205120; -- Blood Elf Square Crate 002 +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=205122; -- Blood Elf Lantern 01 +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=205131; -- Blood Elf Bottle 04 +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=205130; -- Blood Elf Bottle 01 (scale x0.5) +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=205128; -- Dark Iron Crate 01 (scale x0.5) +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=205133; -- Blood Elf Cup 01 +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=205127; -- Skull Candle 01 +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=205125; -- Book Medium Open 04 +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=205129; -- Dark Iron Crate 02 (scale x0.5) +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=205126; -- G_Book 01 Green +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=205119; -- Blood Elf Square Crate 001 +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=205121; -- Blood Elf Square Crate 003 +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=205110; -- Brewfest Crate +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=205116; -- Mug 01 +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=205111; -- Stormwind Crate +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=205115; -- General Lantern 01 (scale x0.5) +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=205102; -- Excavation Banner Stand 02 +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=205113; -- Replace Crate 01 +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=205112; -- Stormwind Crate (scale x0.5) +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=202750; -- Heartblossom +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=205272; -- Portal to Stormwind +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=214503; -- Instance Portal (Party + Heroic) +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=246664; -- Test Kitchen Results +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=246710; -- Nomi's Silver Mackerel +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=214501; -- Instance Portal (Party + Heroic) +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=246664; -- Test Kitchen Results +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=246710; -- Nomi's Silver Mackerel +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=250263; -- Weapon Rack +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=245350; -- Shipwrecked Supplies +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=208903; -- Bonfire +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=215404; -- Shroud of Mist +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=221991; -- Shao-Tien Rice +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=212975; -- Doodad_VEB_greatwall_elevator_003 +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=213395; -- Doodad_GreatWall_Door_001 +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=213396; -- Doodad_GreatWall_Door_002 +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=215364; -- Doodad_GreatWall_Door_020 +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=212876; -- Mogu Container +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=214900; -- Shao-Tien Stormcaller +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=209311; -- Ghost Iron Deposit +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=209328; -- Rich Ghost Iron Deposit +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=212883; -- Mogu Campfire +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=214535; -- Opened Door 02 +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=214534; -- Opened Door 01 +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=212881; -- Mogu Crate, Wide +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=211228; -- Faction Hub Taken +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=211508; -- Horde Banner +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=211231; -- Faction Hub Taken +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=211230; -- Faction Hub Taken +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=211241; -- Faction Hub Taken +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=211240; -- Faction Hub Taken +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=211229; -- Faction Hub Taken +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=211539; -- Lucky Burlap Incense +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=211813; -- Stool +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=211812; -- Stool +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=211811; -- Stool +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=211810; -- Stool +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=211809; -- Stool +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=211531; -- Yaungol Oil Derrick +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=211530; -- Yaungol Oil Derrick +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=210943; -- Mailbox +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=215081; -- Campfire +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=211340; -- Burning Incense +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=219227; -- Luckydo +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=211338; -- Travel Incense +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=211181; -- Lucky Burlap Incense Bundle +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=211180; -- Jasmine Incense Bundle +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=210948; -- Campfire +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=215082; -- Campfire +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=219228; -- Luckydon't +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=214415; -- The Saurok and the Jinyu +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=215131; -- Opened Door 03 +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=210565; -- Dark Soil +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=210869; -- Door +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=210870; -- Door +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=211615; -- Ancient Mogu Door +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=209349; -- Green Tea Leaf +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=211614; -- Ancient Mogu Door +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=211693; -- Inner Doors +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=210868; -- Outer Doors +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=215391; -- Doodad_PA_YakWash_Brushes001 +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=215699; -- Yaungol Windmill Fire Spout +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=192069; -- Lamp Post +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=194941; -- Brazier +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=193088; -- Guild Vault +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=193180; -- Bench +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=193179; -- Bench +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=193901; -- Bench +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=193903; -- Bench +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=193071; -- Mailbox +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=192220; -- Bench +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=193900; -- Bench +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=193902; -- Bench +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=194940; -- Brazier +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=193089; -- Guild Vault +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=194945; -- Brazier +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=194944; -- Brazier +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=192118; -- Lamp +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=194943; -- Brazier +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=191950; -- Mailbox +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=192116; -- Lamp Post +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=191681; -- The Filthy Animal +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=191679; -- The Hunter's Reach +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=191941; -- NEW IN STOCK! Enchanted Ammunition from Azeroth & Beyond! +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=191984; -- Chair +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=192068; -- Lamp Post +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=191983; -- Chair +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=191687; -- Curiosities & Moore Consignment House +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=193915; -- Stool +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=191678; -- Dalaran Visitor Center +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=193918; -- Stool +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=193916; -- Stool +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=192090; -- Lamp +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=192891; -- To Do Today +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=235390; -- Nagrand Arrowbloom +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=249424; -- Plank +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=254125; -- Firmament Stone +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=259375; -- Chair +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=191083; -- Demonic Circle: Summon +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=178832; -- Meeting Stone +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=176767; -- Torch +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=176186; -- Campfire +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=176187; -- Campfire +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=212899; -- Instance Portal (Party + Heroic + Challenge) +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=176745; -- Caer Darrow Skeleton 001 +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=180684; -- Greater Sagefish School +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=2045; -- Stranglekelp +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=170073; -- Wooden Chair +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=3800; -- Cozy Fire +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=3799; -- Cozy Fire +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=2042; -- Fadeleaf +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=22777; -- Cozy Fire +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=22772; -- Cozy Fire +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=22776; -- Cozy Fire +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=22775; -- Cozy Fire +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=174626; -- Scholomance Door +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=2043; -- Khadgar's Whisker +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=1735; -- Iron Deposit +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=175761; -- Civil War in the Plaguelands +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=180047; -- Westfall Chair +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=181689; -- Zeppelin, Horde (Cloudkisser) +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=176495; -- Zeppelin (The Purple Princess) +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=20656; -- upperLdoor +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=20650; -- upperLdoor +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=20651; -- lowerLdoor +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=20657; -- lowerLdoor +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=20655; -- Undervator +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=20649; -- Undervator +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=20653; -- upperLdoor +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=20652; -- Undervator +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=20654; -- lowerLdoor +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=105174; -- Chest of Containment Coffers +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=105175; -- Cantation of Manifestation +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=202736; -- Obsidium Deposit +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=205272; -- Portal to Stormwind +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=204018; -- Alliance Gunship +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=214503; -- Instance Portal (Party + Heroic) +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=205110; -- Brewfest Crate +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=205116; -- Mug 01 +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=205111; -- Stormwind Crate +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=205102; -- Excavation Banner Stand 02 +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=205112; -- Stormwind Crate (scale x0.5) +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=205115; -- General Lantern 01 (scale x0.5) +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=205113; -- Replace Crate 01 +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=205122; -- Blood Elf Lantern 01 +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=205120; -- Blood Elf Square Crate 002 +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=205131; -- Blood Elf Bottle 04 +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=205130; -- Blood Elf Bottle 01 (scale x0.5) +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=205133; -- Blood Elf Cup 01 +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=205127; -- Skull Candle 01 +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=205128; -- Dark Iron Crate 01 (scale x0.5) +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=205125; -- Book Medium Open 04 +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=205126; -- G_Book 01 Green +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=205121; -- Blood Elf Square Crate 003 +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=205129; -- Dark Iron Crate 02 (scale x0.5) +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=205119; -- Blood Elf Square Crate 001 +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=204407; -- Incense Burner +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=205273; -- Portal to Orgrimmar +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=253556; -- Bench +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=214992; -- Mogu Statue +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=1623; -- Wild Steelbloom +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=2041; -- Liferoot +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=1622; -- Bruiseweed +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=1732; -- Tin Vein +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=3727; -- Mageroyal +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=3729; -- Briarthorn +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=3725; -- Silverleaf +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=58389; -- Brazier +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=58388; -- Brazier +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=126051; -- Bench +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=126050; -- Bench +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=246664; -- Test Kitchen Results +UPDATE `gameobject_template` SET `VerifiedBuild`=22566 WHERE `entry`=246710; -- Nomi's Silver Mackerel + +DELETE FROM `gameobject_questitem` WHERE (`GameObjectEntry`=252872 AND `Idx`=0) OR (`GameObjectEntry`=252871 AND `Idx`=0); +INSERT INTO `gameobject_questitem` (`GameObjectEntry`, `Idx`, `ItemId`, `VerifiedBuild`) VALUES +(252872, 0, 140123, 22566), -- The Song of Scales +(252871, 0, 140124, 22566); -- Beyond the Throne of Air + +UPDATE `gameobject_questitem` SET `VerifiedBuild`=22566 WHERE (`GameObjectEntry`=190702 AND `Idx`=0); -- Lifeblood Shard +UPDATE `gameobject_questitem` SET `VerifiedBuild`=22566 WHERE (`GameObjectEntry`=203228 AND `Idx`=0); -- Needles Iron Pyrite +UPDATE `gameobject_questitem` SET `VerifiedBuild`=22566 WHERE (`GameObjectEntry`=186301 AND `Idx`=0); -- Blackhoof Armaments +UPDATE `gameobject_questitem` SET `VerifiedBuild`=22566 WHERE (`GameObjectEntry`=202405 AND `Idx`=0); -- Northwatch Supply Crate +UPDATE `gameobject_questitem` SET `VerifiedBuild`=22566 WHERE (`GameObjectEntry`=195206 AND `Idx`=0); -- Curious Pirate Landmark +UPDATE `gameobject_questitem` SET `VerifiedBuild`=22566 WHERE (`GameObjectEntry`=21277 AND `Idx`=0); -- Crate with Holes +UPDATE `gameobject_questitem` SET `VerifiedBuild`=22566 WHERE (`GameObjectEntry`=246710 AND `Idx`=0); -- Nomi's Silver Mackerel +UPDATE `gameobject_questitem` SET `VerifiedBuild`=22566 WHERE (`GameObjectEntry`=246710 AND `Idx`=0); -- Nomi's Silver Mackerel +UPDATE `gameobject_questitem` SET `VerifiedBuild`=22566 WHERE (`GameObjectEntry`=246710 AND `Idx`=0); -- Nomi's Silver Mackerel +UPDATE `gameobject_questitem` SET `VerifiedBuild`=22566 WHERE (`GameObjectEntry`=246710 AND `Idx`=0); -- Nomi's Silver Mackerel +UPDATE `gameobject_questitem` SET `VerifiedBuild`=22566 WHERE (`GameObjectEntry`=246710 AND `Idx`=0); -- Nomi's Silver Mackerel +UPDATE `gameobject_questitem` SET `VerifiedBuild`=22566 WHERE (`GameObjectEntry`=246710 AND `Idx`=0); -- Nomi's Silver Mackerel +UPDATE `gameobject_questitem` SET `VerifiedBuild`=22566 WHERE (`GameObjectEntry`=243563 AND `Idx`=0); -- Barrel of Fish Oil +UPDATE `gameobject_questitem` SET `VerifiedBuild`=22566 WHERE (`GameObjectEntry`=243564 AND `Idx`=0); -- Basket of Dried Herbs +UPDATE `gameobject_questitem` SET `VerifiedBuild`=22566 WHERE (`GameObjectEntry`=246710 AND `Idx`=0); -- Nomi's Silver Mackerel +UPDATE `gameobject_questitem` SET `VerifiedBuild`=22566 WHERE (`GameObjectEntry`=246710 AND `Idx`=0); -- Nomi's Silver Mackerel +UPDATE `gameobject_questitem` SET `VerifiedBuild`=22566 WHERE (`GameObjectEntry`=246710 AND `Idx`=0); -- Nomi's Silver Mackerel +UPDATE `gameobject_questitem` SET `VerifiedBuild`=22566 WHERE (`GameObjectEntry`=246710 AND `Idx`=0); -- Nomi's Silver Mackerel +UPDATE `gameobject_questitem` SET `VerifiedBuild`=22566 WHERE (`GameObjectEntry`=246710 AND `Idx`=0); -- Nomi's Silver Mackerel +UPDATE `gameobject_questitem` SET `VerifiedBuild`=22566 WHERE (`GameObjectEntry`=243564 AND `Idx`=0); -- Basket of Dried Herbs +UPDATE `gameobject_questitem` SET `VerifiedBuild`=22566 WHERE (`GameObjectEntry`=243563 AND `Idx`=0); -- Barrel of Fish Oil +UPDATE `gameobject_questitem` SET `VerifiedBuild`=22566 WHERE (`GameObjectEntry`=201738 AND `Idx`=0); -- Budding Flower +UPDATE `gameobject_questitem` SET `VerifiedBuild`=22566 WHERE (`GameObjectEntry`=201737 AND `Idx`=0); -- Budding Flower +UPDATE `gameobject_questitem` SET `VerifiedBuild`=22566 WHERE (`GameObjectEntry`=246710 AND `Idx`=0); -- Nomi's Silver Mackerel +UPDATE `gameobject_questitem` SET `VerifiedBuild`=22566 WHERE (`GameObjectEntry`=246710 AND `Idx`=0); -- Nomi's Silver Mackerel +UPDATE `gameobject_questitem` SET `VerifiedBuild`=22566 WHERE (`GameObjectEntry`=246710 AND `Idx`=0); -- Nomi's Silver Mackerel +UPDATE `gameobject_questitem` SET `VerifiedBuild`=22566 WHERE (`GameObjectEntry`=246710 AND `Idx`=0); -- Nomi's Silver Mackerel +UPDATE `gameobject_questitem` SET `VerifiedBuild`=22566 WHERE (`GameObjectEntry`=105174 AND `Idx`=0); -- Chest of Containment Coffers +UPDATE `gameobject_questitem` SET `VerifiedBuild`=22566 WHERE (`GameObjectEntry`=105175 AND `Idx`=0); -- Cantation of Manifestation +UPDATE `gameobject_questitem` SET `VerifiedBuild`=22566 WHERE (`GameObjectEntry`=246710 AND `Idx`=0); -- Nomi's Silver Mackerel |