diff options
| author | Killyana <morphone1@gmail.com> | 2017-06-02 19:55:40 +0200 |
|---|---|---|
| committer | Killyana <morphone1@gmail.com> | 2017-06-02 19:55:40 +0200 |
| commit | a87bc7826a2a8598ca16ece93d3a3267f45721a9 (patch) | |
| tree | c929937598af174d2b36ec99b050d36eef313de3 | |
| parent | 96ee23487fe2a5fc2cf79e5d2ec4ec38b965e70d (diff) | |
DB/Creature: Add some Ziggurat Defender spawns
| -rw-r--r-- | sql/updates/world/3.3.5/2017_06_02_02_world.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2017_06_02_02_world.sql b/sql/updates/world/3.3.5/2017_06_02_02_world.sql new file mode 100644 index 00000000000..92d43a41058 --- /dev/null +++ b/sql/updates/world/3.3.5/2017_06_02_02_world.sql @@ -0,0 +1,7 @@ +-- +DELETE FROM `creature` WHERE `guid` IN (80342, 80351, 80364, 80378); +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 +(80342, 26202, 571, 0, 0, 1, 1, 0, 0, 3247.804, 3688.892, 21.705, 3.158267, 300, 7, 0, 1, 0, 1, 0, 0, 0, -1), +(80351, 26202, 571, 0, 0, 1, 1, 0, 0, 3180.858, 3820.200, 28.555, 3.158267, 300, 7, 0, 1, 0, 1, 0, 0, 0, -1), +(80364, 26202, 571, 0, 0, 1, 1, 0, 0, 3190.193, 3852.021, 27.972, 3.158267, 300, 7, 0, 1, 0, 1, 0, 0, 0, -1), +(80378, 26202, 571, 0, 0, 1, 1, 0, 0, 3158.872, 3841.474, 25.945, 3.158267, 300, 7, 0, 1, 0, 1, 0, 0, 0, -1); |