diff options
| author | Malcrom <malcromdev@gmail.com> | 2013-01-17 20:11:39 -0330 |
|---|---|---|
| committer | Malcrom <malcromdev@gmail.com> | 2013-01-17 20:11:39 -0330 |
| commit | d37b9bdd120ab56180bb1836a567dd45d0bb4013 (patch) | |
| tree | 3a8e438bcbd5810938dfacc67336a7040ed17b54 | |
| parent | b115abde310d0354f0ada05a08078cd5a510efec (diff) | |
DB/creature: Add some missing Zul'Gurub Panther Trigger spawns
| -rw-r--r-- | sql/updates/world/2013_01_17_01_world_creature.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/sql/updates/world/2013_01_17_01_world_creature.sql b/sql/updates/world/2013_01_17_01_world_creature.sql new file mode 100644 index 00000000000..84ded6edcb2 --- /dev/null +++ b/sql/updates/world/2013_01_17_01_world_creature.sql @@ -0,0 +1,8 @@ +-- Spawn 4 missing Zul'Gurub Panther Triggers +SET @GUID := 48311; +DELETE FROM `creature` WHERE `guid` IN (@GUID,@GUID+1,@GUID+2,@GUID+3); +INSERT INTO `creature` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`, `position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`) VALUES +(@GUID,15091,309,1,1,0,0,-11518.29,-1649.965,41.38264,5.131268,7200,0,0,1,0,0,0,0,0), +(@GUID+1,15091,309,1,1,0,0,-11518.51,-1649.303,41.38264,5.864306,7200,0,0,1,0,0,0,0,0), +(@GUID+2,15091,309,1,1,0,0,-11518.46,-1651.542,41.38264,0.2617994,7200,0,0,1,0,0,0,0,0), +(@GUID+3,15091,309,1,1,0,0,-11516.86,-1604.25,41.38264,5.288348,7200,0,0,1,0,0,0,0,0); |