aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorRushor <PBienati@web.de>2016-02-10 20:56:32 +0100
committerRushor <PBienati@web.de>2016-02-10 20:56:32 +0100
commit6f07e9fcd5901053355ce9e0d4de643042714089 (patch)
tree18bc663e913308e705709079d0d8e73579a63f50 /sql
parent43f245d4b763d7213e1cdd92206decc326578e05 (diff)
DB/Creature: Nalpak Spawn
* by Saben65 * closes #16114
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/2016_02_10_03_world.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/world/2016_02_10_03_world.sql b/sql/updates/world/2016_02_10_03_world.sql
new file mode 100644
index 00000000000..9e53fa3431a
--- /dev/null
+++ b/sql/updates/world/2016_02_10_03_world.sql
@@ -0,0 +1,5 @@
+-- DB/Creature: Nalpak Spawn
+SET @CGUID := 452399;
+DELETE FROM `creature` WHERE `guid`=@CGUID;
+INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `MovementType`) VALUES
+(@CGUID, 5767, 43, 1, -150.298, 123.82, -75.95126, 3.228859, 7200, 0, 0); -- 5767 (Area: -1)