aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorKillyana <morphone1@gmail.com>2018-10-14 18:49:30 +0200
committerKillyana <morphone1@gmail.com>2018-10-14 18:49:30 +0200
commit27510aa299112233c1018e80132cc44a16828c8d (patch)
treea07d7378035b156e28914e83a8bbbd15833ebc84 /sql
parentb993e3b278e1bf320a9b5d4b59920b539e0854f7 (diff)
DB/Creature: Add more Spirit healer
Ref #19253
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/master/2018_10_14_01_world.sql9
1 files changed, 9 insertions, 0 deletions
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);