aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKillyana <morphone1@gmail.com>2016-07-06 18:27:31 +0200
committerjoschiwald <joschiwald.trinity@gmail.com>2017-02-05 00:57:14 +0100
commitaa62383f3c149291e102506edba7c3d4ce2ea6ce (patch)
treedd35faa87b4f8bdcca5aa61a63a7245c539a42e5
parent3781b052634f1e76f08aef78deb23b85fa299e0e (diff)
DB/Creature: Add missing Spirit Healer in Grizzly Hills
(cherry picked from commit 1f014cd129025e5711777a5a5b307c5e76132351)
-rw-r--r--sql/updates/world/master/2017_02_04_27_world_2016_07_06_00_world.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_02_04_27_world_2016_07_06_00_world.sql b/sql/updates/world/master/2017_02_04_27_world_2016_07_06_00_world.sql
new file mode 100644
index 00000000000..3875299dde0
--- /dev/null
+++ b/sql/updates/world/master/2017_02_04_27_world_2016_07_06_00_world.sql
@@ -0,0 +1,5 @@
+--
+SET @GUID := 12459;
+DELETE FROM `creature` WHERE `guid` IN (@GUID);
+INSERT INTO `creature` (`guid`, `id`, `map`, `SpawnMask`, `modelid`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `MovementType`) VALUES
+(@GUID, 6491, 571, 1, 0, 4105.362, -4818.6, 76.074, 0.149361, 7200, 0, 0);