From a87bc7826a2a8598ca16ece93d3a3267f45721a9 Mon Sep 17 00:00:00 2001 From: Killyana Date: Fri, 2 Jun 2017 19:55:40 +0200 Subject: DB/Creature: Add some Ziggurat Defender spawns --- sql/updates/world/3.3.5/2017_06_02_02_world.sql | 7 +++++++ 1 file changed, 7 insertions(+) create mode 100644 sql/updates/world/3.3.5/2017_06_02_02_world.sql (limited to 'sql') 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); -- cgit v1.2.3