diff options
| author | Malcrom <malcromdev@gmail.com> | 2011-03-25 14:38:40 +0000 |
|---|---|---|
| committer | Nay <dnpd.dd@gmail.com> | 2011-03-25 14:38:40 +0000 |
| commit | b4b1ca954e2452c0eac34b98b8938728c2dc1269 (patch) | |
| tree | f3034f4ee96e15428ea17c34df16b05d744cc176 | |
| parent | 31c0334064926100c52b2a359d3694c590b75d56 (diff) | |
DB/Creatures: Fix some triggers and incorrect spawns.
| -rw-r--r-- | sql/updates/world/2011_03_25_2_world_creatures.sql | 11 |
1 files changed, 11 insertions, 0 deletions
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); |