diff options
| author | Malcrom <malcromdev@gmail.com> | 2012-05-31 23:35:05 -0230 |
|---|---|---|
| committer | Malcrom <malcromdev@gmail.com> | 2012-05-31 23:35:05 -0230 |
| commit | 2b3b8f6dde22c645d4288a8402feabb2bde825f7 (patch) | |
| tree | 6874fa8f0d8324be4298503c7a56b5641751c63f | |
| parent | 189e32cab99bc5a2cc8987298089b90dafa8c222 (diff) | |
DB/creature: Add missing 7th Legion Chain Gun spawns for quest "The Chain Gun and You"
| -rw-r--r-- | sql/updates/world/2012_05_31_12_world_creature.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/sql/updates/world/2012_05_31_12_world_creature.sql b/sql/updates/world/2012_05_31_12_world_creature.sql new file mode 100644 index 00000000000..cad0364d021 --- /dev/null +++ b/sql/updates/world/2012_05_31_12_world_creature.sql @@ -0,0 +1,9 @@ +-- Add missing 7th Legion Chain Gun spawns +DELETE FROM `creature` WHERE `guid` IN (42569,42570,42663,42664); +INSERT INTO `creature` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`) VALUES +(42569,27714,571,1,1,25331,0,3665.613,-1209.412,102.4201,4.206244,120,0,0,1,0,0), +(42570,27714,571,1,1,25331,0,3660.56,-1207.094,102.4201,4.29351,120,0,0,1,0,0), +(42663,27714,571,1,1,25331,0,3677.009,-1174.462,102.3367,1.169371,120,0,0,1,0,0), +(42664,27714,571,1,1,25331,0,3682.874,-1177.179,102.4757,1.169371,120,0,0,1,0,0); +-- Add Spells for 7th Legion Chain Gun +UPDATE `creature_template` SET `spell1`=49190,`spell2`=49550 WHERE `entry`=27714; |