aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKinzcool <kinzzcool@hotmail.com>2013-04-02 21:27:26 -0400
committerKinzcool <kinzzcool@hotmail.com>2013-04-02 21:27:26 -0400
commitc02ec5cc4d4a5521c6779337fc25d18427fed32f (patch)
tree0e797a96459a5f0bc9428a1dcc3a14476f5e64f0
parent25d7cd24eb62cd122be9846b4adeac8ae8aa4625 (diff)
DB/Creatures: Added a missing innkeeper in Dragon Maw Base Camp.
-rw-r--r--sql/updates/world/2013_04_02_02_world_creature.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/world/2013_04_02_02_world_creature.sql b/sql/updates/world/2013_04_02_02_world_creature.sql
new file mode 100644
index 00000000000..194eee288d2
--- /dev/null
+++ b/sql/updates/world/2013_04_02_02_world_creature.sql
@@ -0,0 +1,5 @@
+SET @CGUID := 40471;
+
+DELETE FROM `creature` WHERE `guid`=@CGUID;
+INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `MovementType`) VALUES
+(@CGUID, 23143, 530, 1, 1, -5142.569, 581.3281, 84.13567, 0.5061455, 120, 0, 0); -- Horus (Area: Netherwing Ledge)