DROP PROCEDURE IF EXISTS add_migration; DELIMITER ?? CREATE PROCEDURE `add_migration`() BEGIN DECLARE v INT DEFAULT 1; SET v = (SELECT COUNT(*) FROM `migrations` WHERE `id`='20260629001237'); IF v = 0 THEN INSERT INTO `migrations` VALUES ('20260629001237'); -- Add your query below. -- Abercrombie's Crate DELETE FROM `gameobject_template` WHERE `entry`=167; DELETE FROM `locales_gameobject` WHERE `entry`=167; DELETE FROM `gameobject_loot_template` WHERE `entry`=167; -- Wanted: Chok'Sul DELETE FROM `gameobject_template` WHERE `entry`=254; DELETE FROM `locales_gameobject` WHERE `entry`=254; -- Graveyard Banner DELETE FROM `gameobject_template` WHERE `entry`=13756; DELETE FROM `locales_gameobject` WHERE `entry`=13756; -- Mine Banner DELETE FROM `gameobject_template` WHERE `entry`=15001; DELETE FROM `locales_gameobject` WHERE `entry`=15001; -- Lumber Mill Banner DELETE FROM `gameobject_template` WHERE `entry`=15002; DELETE FROM `locales_gameobject` WHERE `entry`=15002; -- Farm Banner DELETE FROM `gameobject_template` WHERE `entry`=15003; DELETE FROM `locales_gameobject` WHERE `entry`=15003; -- Blacksmith Banner DELETE FROM `gameobject_template` WHERE `entry`=15004; DELETE FROM `locales_gameobject` WHERE `entry`=15004; -- Stable Banner DELETE FROM `gameobject_template` WHERE `entry`=15005; DELETE FROM `locales_gameobject` WHERE `entry`=15005; -- Cracked Necrotic Crystal DELETE FROM `gameobject_template` WHERE `entry`=16431; DELETE FROM `locales_gameobject` WHERE `entry`=16431; -- Lashh'an Spell Circle DELETE FROM `gameobject_template` WHERE `entry`=21511; DELETE FROM `locales_gameobject` WHERE `entry`=21511; -- Gizmorium Shipping Crate DELETE FROM `gameobject_template` WHERE `entry`=23505; DELETE FROM `locales_gameobject` WHERE `entry`=23505; -- Big house DELETE FROM `gameobject_template` WHERE `entry`=90000; DELETE FROM `locales_gameobject` WHERE `entry`=90000; -- Bonfire DELETE FROM `gameobject_template` WHERE `entry`=92254; DELETE FROM `locales_gameobject` WHERE `entry`=92254; -- Bonfire DELETE FROM `gameobject_template` WHERE `entry`=111839; DELETE FROM `locales_gameobject` WHERE `entry`=111839; -- Bonefire DELETE FROM `gameobject_template` WHERE `entry`=112879; DELETE FROM `locales_gameobject` WHERE `entry`=112879; -- auctionhouse DELETE FROM `gameobject_template` WHERE `entry`=151992; DELETE FROM `locales_gameobject` WHERE `entry`=151992; -- Bonfire DELETE FROM `gameobject_template` WHERE `entry`=181488; DELETE FROM `locales_gameobject` WHERE `entry`=181488; -- Bonfire DELETE FROM `gameobject_template` WHERE `entry`=181489; DELETE FROM `locales_gameobject` WHERE `entry`=181489; -- Summoning Portal DELETE FROM `gameobject_template` WHERE `entry`=181810; DELETE FROM `locales_gameobject` WHERE `entry`=181810; -- Campfire DELETE FROM `gameobject_template` WHERE `entry`=181870; DELETE FROM `locales_gameobject` WHERE `entry`=181870; -- Boat to Auberdine DELETE FROM `gameobject_template` WHERE `entry`=181985; DELETE FROM `locales_gameobject` WHERE `entry`=181985; -- Dark Brazier DELETE FROM `gameobject_template` WHERE `entry`=182013; DELETE FROM `locales_gameobject` WHERE `entry`=182013; -- Dark Brazier DELETE FROM `gameobject_template` WHERE `entry`=182014; DELETE FROM `locales_gameobject` WHERE `entry`=182014; -- Dark Brazier DELETE FROM `gameobject_template` WHERE `entry`=182018; DELETE FROM `locales_gameobject` WHERE `entry`=182018; -- Dark Brazier DELETE FROM `gameobject_template` WHERE `entry`=182020; DELETE FROM `locales_gameobject` WHERE `entry`=182020; -- Dark Brazier DELETE FROM `gameobject_template` WHERE `entry`=182021; DELETE FROM `locales_gameobject` WHERE `entry`=182021; -- Dark Brazier DELETE FROM `gameobject_template` WHERE `entry`=182022; DELETE FROM `locales_gameobject` WHERE `entry`=182022; -- Dark Brazier DELETE FROM `gameobject_template` WHERE `entry`=182023; DELETE FROM `locales_gameobject` WHERE `entry`=182023; -- Dark Brazier DELETE FROM `gameobject_template` WHERE `entry`=182028; DELETE FROM `locales_gameobject` WHERE `entry`=182028; -- Dark Brazier DELETE FROM `gameobject_template` WHERE `entry`=182029; DELETE FROM `locales_gameobject` WHERE `entry`=182029; -- Draenei Explosives DELETE FROM `gameobject_template` WHERE `entry`=182088; DELETE FROM `locales_gameobject` WHERE `entry`=182088; -- Vector Coil Fire (S) DELETE FROM `gameobject_template` WHERE `entry`=182089; DELETE FROM `locales_gameobject` WHERE `entry`=182089; -- Draenei Explosives DELETE FROM `gameobject_template` WHERE `entry`=182091; DELETE FROM `locales_gameobject` WHERE `entry`=182091; -- 0 DELETE FROM `gameobject_template` WHERE `entry`=182215; DELETE FROM `locales_gameobject` WHERE `entry`=182215; -- Bonfire DELETE FROM `gameobject_template` WHERE `entry`=182216; DELETE FROM `locales_gameobject` WHERE `entry`=182216; -- Bonfire DELETE FROM `gameobject_template` WHERE `entry`=182217; DELETE FROM `locales_gameobject` WHERE `entry`=182217; -- Bonfire DELETE FROM `gameobject_template` WHERE `entry`=182218; DELETE FROM `locales_gameobject` WHERE `entry`=182218; -- Bonfire DELETE FROM `gameobject_template` WHERE `entry`=182219; DELETE FROM `locales_gameobject` WHERE `entry`=182219; -- Bonfire DELETE FROM `gameobject_template` WHERE `entry`=182220; DELETE FROM `locales_gameobject` WHERE `entry`=182220; -- Bonfire DELETE FROM `gameobject_template` WHERE `entry`=182221; DELETE FROM `locales_gameobject` WHERE `entry`=182221; -- Eye of Veil Skith DELETE FROM `gameobject_template` WHERE `entry`=182506; DELETE FROM `locales_gameobject` WHERE `entry`=182506; -- Eye of Veil Reskk DELETE FROM `gameobject_template` WHERE `entry`=182507; DELETE FROM `locales_gameobject` WHERE `entry`=182507; -- Terokkar Chokeberry Bush DELETE FROM `gameobject_template` WHERE `entry`=182526; DELETE FROM `locales_gameobject` WHERE `entry`=182526; -- Burning Fire DELETE FROM `gameobject_template` WHERE `entry`=183314; DELETE FROM `locales_gameobject` WHERE `entry`=183314; -- Burning Fire DELETE FROM `gameobject_template` WHERE `entry`=183315; DELETE FROM `locales_gameobject` WHERE `entry`=183315; -- Durnholde Keep DELETE FROM `gameobject_template` WHERE `entry`=184057; DELETE FROM `locales_gameobject` WHERE `entry`=184057; -- Tarren Mill DELETE FROM `gameobject_template` WHERE `entry`=184058; DELETE FROM `locales_gameobject` WHERE `entry`=184058; -- Southshore DELETE FROM `gameobject_template` WHERE `entry`=184059; DELETE FROM `locales_gameobject` WHERE `entry`=184059; -- Tarren Mill DELETE FROM `gameobject_template` WHERE `entry`=184060; DELETE FROM `locales_gameobject` WHERE `entry`=184060; -- Southshore DELETE FROM `gameobject_template` WHERE `entry`=184061; DELETE FROM `locales_gameobject` WHERE `entry`=184061; -- Durnholde Keep DELETE FROM `gameobject_template` WHERE `entry`=184067; DELETE FROM `locales_gameobject` WHERE `entry`=184067; -- Bonfire DELETE FROM `gameobject_template` WHERE `entry`=184161; DELETE FROM `locales_gameobject` WHERE `entry`=184161; -- DELETE FROM `gameobject_template` WHERE `entry`=184461; DELETE FROM `locales_gameobject` WHERE `entry`=184461; -- Legion Hold Forge DELETE FROM `gameobject_template` WHERE `entry`=184846; DELETE FROM `locales_gameobject` WHERE `entry`=184846; -- Sealed Tome DELETE FROM `gameobject_template` WHERE `entry`=184847; DELETE FROM `locales_gameobject` WHERE `entry`=184847; -- Felcannon Ammunition DELETE FROM `gameobject_template` WHERE `entry`=184961; DELETE FROM `locales_gameobject` WHERE `entry`=184961; -- Felcannon Ammunition DELETE FROM `gameobject_template` WHERE `entry`=184962; DELETE FROM `locales_gameobject` WHERE `entry`=184962; -- Felcannon Ammunition DELETE FROM `gameobject_template` WHERE `entry`=184963; DELETE FROM `locales_gameobject` WHERE `entry`=184963; -- Eclipsion Communication Device DELETE FROM `gameobject_template` WHERE `entry`=185121; DELETE FROM `locales_gameobject` WHERE `entry`=185121; -- Moonglade Fountain DELETE FROM `gameobject_template` WHERE `entry`=185493; DELETE FROM `locales_gameobject` WHERE `entry`=185493; DELETE FROM `gameobject` WHERE `id`=185493; -- Beer Wagon DELETE FROM `gameobject_template` WHERE `entry`=186250; DELETE FROM `locales_gameobject` WHERE `entry`=186250; -- Grimbooze's Secret Recipe DELETE FROM `gameobject_template` WHERE `entry`=186263; DELETE FROM `locales_gameobject` WHERE `entry`=186263; -- Kyle's Lunch DELETE FROM `gameobject_template` WHERE `entry`=186265; DELETE FROM `locales_gameobject` WHERE `entry`=186265; -- Cauldron DELETE FROM `gameobject_template` WHERE `entry`=186451; DELETE FROM `locales_gameobject` WHERE `entry`=186451; DELETE FROM `gameobject` WHERE `id`=186451; -- Dark Iron Sabotage Plans DELETE FROM `gameobject_template` WHERE `entry`=186881; DELETE FROM `locales_gameobject` WHERE `entry`=186881; -- Cannon DELETE FROM `gameobject_template` WHERE `entry`=193011; DELETE FROM `locales_gameobject` WHERE `entry`=193011; -- Mug Smoke DELETE FROM `gameobject_template` WHERE `entry`=190396; DELETE FROM `locales_gameobject` WHERE `entry`=190396; -- Doodad_Nox_door_spider02 DELETE FROM `gameobject_template` WHERE `entry`=194022; DELETE FROM `locales_gameobject` WHERE `entry`=194022; -- Shopping Centre DELETE FROM `gameobject_template` WHERE `entry`=200001; DELETE FROM `locales_gameobject` WHERE `entry`=200001; -- Warsong Clan Banner 07 DELETE FROM `gameobject_template` WHERE `entry`=210068; DELETE FROM `locales_gameobject` WHERE `entry`=210068; -- New Year Alliance Hanging Banner DELETE FROM `gameobject_template` WHERE `entry`=210210; DELETE FROM `locales_gameobject` WHERE `entry`=210210; -- New Year Alliance Hanging Banner 02 DELETE FROM `gameobject_template` WHERE `entry`=210211; DELETE FROM `locales_gameobject` WHERE `entry`=210211; -- New Year Horde Hanging Banner DELETE FROM `gameobject_template` WHERE `entry`=210212; DELETE FROM `locales_gameobject` WHERE `entry`=210212; -- New Year Horde Hanging Banner 02 DELETE FROM `gameobject_template` WHERE `entry`=210213; DELETE FROM `locales_gameobject` WHERE `entry`=210213; -- New Year Alliance Standing Banner DELETE FROM `gameobject_template` WHERE `entry`=210214; DELETE FROM `locales_gameobject` WHERE `entry`=210214; -- New Year Horde Standing Banner DELETE FROM `gameobject_template` WHERE `entry`=210215; DELETE FROM `locales_gameobject` WHERE `entry`=210215; -- Excavation Tent Pavillion DELETE FROM `gameobject_template` WHERE `entry`=210286; DELETE FROM `locales_gameobject` WHERE `entry`=210286; -- Ahn'Qiraj Ossirian Crystal DELETE FROM `gameobject_template` WHERE `entry`=210312; DELETE FROM `locales_gameobject` WHERE `entry`=210312; -- Ahn'Qiraj Ossirian Crystal DELETE FROM `gameobject_template` WHERE `entry`=210313; DELETE FROM `locales_gameobject` WHERE `entry`=210313; -- Communication Crystal DELETE FROM `gameobject_template` WHERE `entry`=210327; DELETE FROM `locales_gameobject` WHERE `entry`=210327; -- Communication Crystal DELETE FROM `gameobject_template` WHERE `entry`=210328; DELETE FROM `locales_gameobject` WHERE `entry`=210328; -- Communication Crystal DELETE FROM `gameobject_template` WHERE `entry`=210329; DELETE FROM `locales_gameobject` WHERE `entry`=210329; -- Communication Crystal DELETE FROM `gameobject_template` WHERE `entry`=210330; DELETE FROM `locales_gameobject` WHERE `entry`=210330; -- Communication Crystal DELETE FROM `gameobject_template` WHERE `entry`=210331; DELETE FROM `locales_gameobject` WHERE `entry`=210331; -- Communication Crystal DELETE FROM `gameobject_template` WHERE `entry`=210332; DELETE FROM `locales_gameobject` WHERE `entry`=210332; -- Ahn'Qiraj Gong DELETE FROM `gameobject_template` WHERE `entry`=210334; DELETE FROM `locales_gameobject` WHERE `entry`=210334; -- Twilight Tablet DELETE FROM `gameobject_template` WHERE `entry`=210335; DELETE FROM `locales_gameobject` WHERE `entry`=210335; -- Twilight Tablet DELETE FROM `gameobject_template` WHERE `entry`=210336; DELETE FROM `locales_gameobject` WHERE `entry`=210336; -- Glyphed Crystal DELETE FROM `gameobject_template` WHERE `entry`=210337; DELETE FROM `locales_gameobject` WHERE `entry`=210337; -- Gorishi Silithid Crystal DELETE FROM `gameobject_template` WHERE `entry`=210338; DELETE FROM `locales_gameobject` WHERE `entry`=210338; -- Ahn'Qiraj Sand Trap DELETE FROM `gameobject_template` WHERE `entry`=210339; DELETE FROM `locales_gameobject` WHERE `entry`=210339; -- Hive Fireflies 01 DELETE FROM `gameobject_template` WHERE `entry`=210341; DELETE FROM `locales_gameobject` WHERE `entry`=210341; -- Sand Worm Rock Base DELETE FROM `gameobject_template` WHERE `entry`=210343; DELETE FROM `locales_gameobject` WHERE `entry`=210343; -- Silithus Crystal Formation 03 DELETE FROM `gameobject_template` WHERE `entry`=210344; DELETE FROM `locales_gameobject` WHERE `entry`=210344; -- Floating Red Crystal Broken 03 DELETE FROM `gameobject_template` WHERE `entry`=210345; DELETE FROM `locales_gameobject` WHERE `entry`=210345; -- Floating Red Crystal Broken 01 DELETE FROM `gameobject_template` WHERE `entry`=210346; DELETE FROM `locales_gameobject` WHERE `entry`=210346; -- Ahn'Qiraj Door 01 DELETE FROM `gameobject_template` WHERE `entry`=210347; DELETE FROM `locales_gameobject` WHERE `entry`=210347; -- Floating Purple Crystal Broken 01 DELETE FROM `gameobject_template` WHERE `entry`=210348; DELETE FROM `locales_gameobject` WHERE `entry`=210348; -- Gastric Exit DELETE FROM `gameobject_template` WHERE `entry`=210349; DELETE FROM `locales_gameobject` WHERE `entry`=210349; -- Anvil DELETE FROM `gameobject_template` WHERE `entry`=211016; DELETE FROM `locales_gameobject` WHERE `entry`=211016; -- Kre'tal's Wagon DELETE FROM `gameobject_template` WHERE `entry`=211017; DELETE FROM `locales_gameobject` WHERE `entry`=211017; -- Asheron's Tome of Summoning DELETE FROM `gameobject_template` WHERE `entry`=211018; DELETE FROM `locales_gameobject` WHERE `entry`=211018; -- Altar of Hyjal DELETE FROM `gameobject_template` WHERE `entry`=211019; DELETE FROM `locales_gameobject` WHERE `entry`=211019; -- Summoning Circle DELETE FROM `gameobject_template` WHERE `entry`=211020; DELETE FROM `locales_gameobject` WHERE `entry`=211020; -- Eye of Asheron DELETE FROM `gameobject_template` WHERE `entry`=211021; DELETE FROM `locales_gameobject` WHERE `entry`=211021; -- Commander's Tent DELETE FROM `gameobject_template` WHERE `entry`=211022; DELETE FROM `locales_gameobject` WHERE `entry`=211022; -- Black Portal DELETE FROM `gameobject_template` WHERE `entry`=211023; DELETE FROM `locales_gameobject` WHERE `entry`=211023; -- Black Portal DELETE FROM `gameobject_template` WHERE `entry`=211024; DELETE FROM `locales_gameobject` WHERE `entry`=211024; -- Banner DELETE FROM `gameobject_template` WHERE `entry`=211029; DELETE FROM `locales_gameobject` WHERE `entry`=211029; -- Gold Mine DELETE FROM `gameobject_template` WHERE `entry`=211032; DELETE FROM `locales_gameobject` WHERE `entry`=211032; -- Aura DELETE FROM `gameobject_template` WHERE `entry`=211033; DELETE FROM `locales_gameobject` WHERE `entry`=211033; -- Aura DELETE FROM `gameobject_template` WHERE `entry`=211034; DELETE FROM `locales_gameobject` WHERE `entry`=211034; -- Lair Exit DELETE FROM `gameobject_template` WHERE `entry`=211035; DELETE FROM `locales_gameobject` WHERE `entry`=211035; -- Fire Totem DELETE FROM `gameobject_template` WHERE `entry`=211036; DELETE FROM `locales_gameobject` WHERE `entry`=211036; -- Tree Stump DELETE FROM `gameobject_template` WHERE `entry`=211052; DELETE FROM `locales_gameobject` WHERE `entry`=211052; -- Mysterious Monument DELETE FROM `gameobject_template` WHERE `entry`=211053; DELETE FROM `locales_gameobject` WHERE `entry`=211053; -- Lava Crack DELETE FROM `gameobject_template` WHERE `entry`=211054; DELETE FROM `locales_gameobject` WHERE `entry`=211054; -- Elwynn Fence DELETE FROM `gameobject_template` WHERE `entry`=211062; DELETE FROM `locales_gameobject` WHERE `entry`=211062; -- Elwynn Fence DELETE FROM `gameobject_template` WHERE `entry`=211063; DELETE FROM `locales_gameobject` WHERE `entry`=211063; -- Rockwall Fence DELETE FROM `gameobject_template` WHERE `entry`=211064; DELETE FROM `locales_gameobject` WHERE `entry`=211064; -- Grave DELETE FROM `gameobject_template` WHERE `entry`=211065; DELETE FROM `locales_gameobject` WHERE `entry`=211065; -- Sarcophag DELETE FROM `gameobject_template` WHERE `entry`=211067; DELETE FROM `locales_gameobject` WHERE `entry`=211067; -- Fire Totem DELETE FROM `gameobject_template` WHERE `entry`=211068; DELETE FROM `locales_gameobject` WHERE `entry`=211068; -- Mephistroph's HellFire DELETE FROM `gameobject_template` WHERE `entry`=211084; DELETE FROM `locales_gameobject` WHERE `entry`=211084; -- Swirling Maelstrom DELETE FROM `gameobject_template` WHERE `entry`=300057; DELETE FROM `locales_gameobject` WHERE `entry`=300057; UPDATE `gameobject` SET `id`=180669, `position_x`=3489.12, `position_y`=-6614.89, `position_z`=-0.0012, `orientation`=4.62512, `rotation0`=0,`rotation1`=0, `rotation2`=-0.737277, `rotation3`=0.675591 WHERE `id`=300057; UPDATE `gameobject_template` SET `flags`=4 WHERE `entry`=180669; -- Porte de UBRS DELETE FROM `gameobject_template` WHERE `entry`=300200; DELETE FROM `locales_gameobject` WHERE `entry`=300200; -- Porte de sortie de l'arene UBRS DELETE FROM `gameobject_template` WHERE `entry`=300202; DELETE FROM `locales_gameobject` WHERE `entry`=300202; -- Apple Bob DELETE FROM `gameobject_template` WHERE `entry`=300203; DELETE FROM `locales_gameobject` WHERE `entry`=300203; -- Door DELETE FROM `gameobject_template` WHERE `entry`=300601; DELETE FROM `locales_gameobject` WHERE `entry`=300601; -- Equipment Crates DELETE FROM `gameobject_template` WHERE `entry`=987658; DELETE FROM `locales_gameobject` WHERE `entry`=987658; -- Kroshius' Remains DELETE FROM `gameobject_template` WHERE `entry`=3000491; DELETE FROM `locales_gameobject` WHERE `entry`=3000491; DELETE FROM `gameobject` WHERE `id`=3000491; -- End of migration. END IF; END?? DELIMITER ; CALL add_migration(); DROP PROCEDURE IF EXISTS add_migration;