aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKillyana <morphone1@gmail.com>2017-04-19 20:08:54 +0200
committerKillyana <morphone1@gmail.com>2017-04-19 20:08:54 +0200
commitb3270f6c9476177665a2ef76e49c3222705d272c (patch)
tree0b475797d64acb6588ef54e064b4fcb7f0f4ecf6
parent73ec3a1d3b34b31ae67ea4215ce3d25a2adf392b (diff)
DB/Creature: Add missing Spirit Healer on Stranglethorn Vale
For 3.3.5 only
-rw-r--r--sql/updates/world/3.3.5/2017_04_19_01_world335.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2017_04_19_01_world335.sql b/sql/updates/world/3.3.5/2017_04_19_01_world335.sql
new file mode 100644
index 00000000000..7a668b30292
--- /dev/null
+++ b/sql/updates/world/3.3.5/2017_04_19_01_world335.sql
@@ -0,0 +1,4 @@
+--
+DELETE FROM `creature` WHERE `guid`=78805;
+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
+(78805, 6491, 0, 0, 0, 1, 1, 0, 0, -12546.896, -586.453, 39.552, 3.504853, 72000, 0, 0, 0, 0, 0, 0, 0, 0, 0);