From b4b1ca954e2452c0eac34b98b8938728c2dc1269 Mon Sep 17 00:00:00 2001 From: Malcrom Date: Fri, 25 Mar 2011 14:38:40 +0000 Subject: DB/Creatures: Fix some triggers and incorrect spawns. --- sql/updates/world/2011_03_25_2_world_creatures.sql | 11 +++++++++++ 1 file changed, 11 insertions(+) create mode 100644 sql/updates/world/2011_03_25_2_world_creatures.sql (limited to 'sql') diff --git a/sql/updates/world/2011_03_25_2_world_creatures.sql b/sql/updates/world/2011_03_25_2_world_creatures.sql new file mode 100644 index 00000000000..c6e3f98a9d7 --- /dev/null +++ b/sql/updates/world/2011_03_25_2_world_creatures.sql @@ -0,0 +1,11 @@ +-- Arcanimus should not have random movement +UPDATE `creature` SET `spawndist`=0,`MovementType`=0 WHERE `guid`=96298; +-- Fixup Big Electromental Flavor +UPDATE `creature` SET `modelid`=0,`spawndist`=0,`MovementType`=0 WHERE `id`=21757; +UPDATE `creature_template` SET `InhabitType`=7 WHERE `entry`=21757; +-- Remove Fizzcrank Airman missspawn +DELETE FROM `creature` WHERE `guid` IN (117923); +DELETE FROM `creature_addon` WHERE `guid` IN (117923); +-- Fixup South Sinkhole, Northeast Sinkhole, Northwest Sinkhole Set as trigger +UPDATE `creature` SET `modelid`=0 WHERE `id` IN (25664,25665,25666); +UPDATE `creature_template` SET `InhabitType`=7,`flags_extra`=`flags_extra`|128 WHERE `entry` IN (25664,25665,25666); -- cgit v1.2.3