aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKillyana <morphone1@gmail.com>2017-04-19 20:36:47 +0200
committerKillyana <morphone1@gmail.com>2017-04-19 20:36:47 +0200
commitde91af66f803cbe28032c40893835d85c7bf301d (patch)
treecdf90d0c0528b4245e9c72d7884f220a91c0dbd7
parentb3270f6c9476177665a2ef76e49c3222705d272c (diff)
DB/Creature: Add missing Spirit Healer on Arathi Highlands
For 3.3.5 only
-rw-r--r--sql/updates/world/3.3.5/2017_04_19_01_world_335.sql (renamed from sql/updates/world/3.3.5/2017_04_19_01_world335.sql)0
-rw-r--r--sql/updates/world/3.3.5/2017_04_19_02_world_335.sql4
2 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_world_335.sql
index 7a668b30292..7a668b30292 100644
--- a/sql/updates/world/3.3.5/2017_04_19_01_world335.sql
+++ b/sql/updates/world/3.3.5/2017_04_19_01_world_335.sql
diff --git a/sql/updates/world/3.3.5/2017_04_19_02_world_335.sql b/sql/updates/world/3.3.5/2017_04_19_02_world_335.sql
new file mode 100644
index 00000000000..782477bde73
--- /dev/null
+++ b/sql/updates/world/3.3.5/2017_04_19_02_world_335.sql
@@ -0,0 +1,4 @@
+--
+DELETE FROM `creature` WHERE `guid`=78806;
+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
+(78806, 6491, 0, 0, 0, 1, 1, 0, 0, -1314.7792, -3185.288, 37.3730, 5.495047, 72000, 0, 0, 0, 0, 0, 0, 0, 0, 0);