diff options
| author | Rushor <PBienati@web.de> | 2016-02-12 23:30:38 +0100 |
|---|---|---|
| committer | Rushor <PBienati@web.de> | 2016-02-12 23:30:38 +0100 |
| commit | c3dcbbbe2ba23be86880babe7aba92447470b769 (patch) | |
| tree | 6d329b00c5c9b487cd705527f66a8ffe8c54aa54 | |
| parent | ff45a422c5e525c4d9465e91200803ffa95700d2 (diff) | |
DB/Creature: Bloodsail Traitor - Add spawnpoint
* by Gargarensis
* closes #16540
| -rw-r--r-- | sql/updates/world/2016_02_12_00_world.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/sql/updates/world/2016_02_12_00_world.sql b/sql/updates/world/2016_02_12_00_world.sql new file mode 100644 index 00000000000..af599148e04 --- /dev/null +++ b/sql/updates/world/2016_02_12_00_world.sql @@ -0,0 +1,7 @@ +-- +-- Spawn creature ID 16399 Bloodsail Traitor: +SET @CGUID := 1528; -- selected by TC team + +DELETE FROM `creature` WHERE `id` = 16399; +INSERT INTO `creature` (`guid`,`id`,`map`,`zoneId`,`areaId`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`,`VerifiedBuild`) VALUES +(@CGUID, 16399, 0, 0, 0, 1, 1, 2557, 1, -14184.4, 192.764, 20.6905, 3.735, 300, 0, 0, 2059, 0, 0, 0, 0, 0, 0); |
