aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sql/updates/world/2016_02_12_00_world.sql7
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);