aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKillyana <morphone1@gmail.com>2016-07-06 18:27:31 +0200
committerKillyana <morphone1@gmail.com>2016-07-06 18:27:31 +0200
commit1f014cd129025e5711777a5a5b307c5e76132351 (patch)
treeb846f7edcfd900462290f1cc3d3ec5c01d0a2950
parente3de0ef531bf89a2f4193cf1beecf4bce05971af (diff)
DB/Creature: Add missing Spirit Healer in Grizzly Hills
-rw-r--r--sql/updates/world/3.3.5/2016_07_06_00_world.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2016_07_06_00_world.sql b/sql/updates/world/3.3.5/2016_07_06_00_world.sql
new file mode 100644
index 00000000000..3875299dde0
--- /dev/null
+++ b/sql/updates/world/3.3.5/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);