diff options
author | Killyana <morphone1@gmail.com> | 2018-10-14 18:49:30 +0200 |
---|---|---|
committer | Killyana <morphone1@gmail.com> | 2018-10-14 18:49:30 +0200 |
commit | 27510aa299112233c1018e80132cc44a16828c8d (patch) | |
tree | a07d7378035b156e28914e83a8bbbd15833ebc84 /sql | |
parent | b993e3b278e1bf320a9b5d4b59920b539e0854f7 (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.sql | 9 |
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); |