From 27510aa299112233c1018e80132cc44a16828c8d Mon Sep 17 00:00:00 2001
From: Killyana <morphone1@gmail.com>
Date: Sun, 14 Oct 2018 18:49:30 +0200
Subject: DB/Creature: Add more Spirit healer

Ref #19253
---
 sql/updates/world/master/2018_10_14_01_world.sql | 9 +++++++++
 1 file changed, 9 insertions(+)
 create mode 100644 sql/updates/world/master/2018_10_14_01_world.sql

(limited to 'sql')

diff --git a/sql/updates/world/master/2018_10_14_01_world.sql b/sql/updates/world/master/2018_10_14_01_world.sql
new file mode 100644
index 00000000000..af90bb4965d
--- /dev/null
+++ b/sql/updates/world/master/2018_10_14_01_world.sql
@@ -0,0 +1,9 @@
+-- 
+DELETE FROM `creature` WHERE `guid` IN (252337,252342,252345,252346,252347,252352);
+INSERT INTO `creature` (`guid`,`id`,`map`,`zoneId`,`areaId`,`spawnDifficulties`,`PhaseId`,`PhaseGroup`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`,`ScriptName`,`VerifiedBuild`) VALUES 
+(252337,6491,1,0,0,1,169,0,0,0,161.04580, -1700.3441, 93.747, 1.440328,120,0,0,0,0,0,0,0,0,'',0),
+(252342,6491,1,0,0,1,169,0,0,0,1457.0593, 1278.31543, 170.95, 6.161450,120,0,0,0,0,0,0,0,0,'',0),
+(252345,6491,1,0,0,1,169,0,0,0,-5538.097, -1548.5739, 89.196, 0.608690,120,0,0,0,0,0,0,0,0,'',0),
+(252346,6491,1,0,0,1,169,0,0,0,-4985.759, -1012.1699, 1.3009, 0.872665,120,0,0,0,0,0,0,0,0,'',0),
+(252347,6491,1,0,0,1,169,0,0,0,-4338.628, -384.58416, 37.382, 0.617579,120,0,0,0,0,0,0,0,0,'',0),
+(252352,6491,1,0,0,1,169,0,0,0,-3132.315, 2537.77368, 54.513, 3.212281,120,0,0,0,0,0,0,0,0,'',0);
-- 
cgit v1.2.3