diff options
| author | Kittnz <frederik156@hotmail.com> | 2016-05-08 11:39:55 +0200 |
|---|---|---|
| committer | Kittnz <frederik156@hotmail.com> | 2016-05-08 11:39:55 +0200 |
| commit | d99c09f5a0efd9ea1e0957becc03e373be45c432 (patch) | |
| tree | 0990b72eeecca6d3a9e3e98977fdd518f67c4ae6 | |
| parent | 99a6c8469f1f49613fa46130f76725079c055b00 (diff) | |
DB/Creature: Add spawns for Guard Didier & Caravan Mule
Updates #14947
| -rw-r--r-- | sql/updates/world/3.3.5/2016_05_08_00_world.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2016_05_08_00_world.sql b/sql/updates/world/3.3.5/2016_05_08_00_world.sql new file mode 100644 index 00000000000..cfbe1f6b9ad --- /dev/null +++ b/sql/updates/world/3.3.5/2016_05_08_00_world.sql @@ -0,0 +1,11 @@ +SET @CGUID:=84737; + +-- Add missing Caravan Mule & Guard Didier <Brotherhood of the Light> spawns +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+5; +INSERT INTO `creature` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `curhealth`) VALUES +(@CGUID+0, 16232, 0, 2308.195, -5297.163, 82.0796, 1.780236, 120, 0), -- [65] Caravan Mule +(@CGUID+1, 16232, 0, 2309.498, -5294.246, 82.07687, 1.727876, 120, 0), -- [66] Caravan Mule +(@CGUID+2, 16232, 0, 2306.324, -5294.137, 82.07687, 1.815142, 120, 0), -- [67] Caravan Mule +(@CGUID+3, 16232, 0, 2308.93, -5290.619, 82.10618, 1.797689, 120, 0), -- [68] Caravan Mule +(@CGUID+4, 16232, 0, 2305.878, -5290.338, 82.33588, 1.832596, 120, 0), -- [69] Caravan Mule +(@CGUID+5, 16226, 0, 2305.295, -5286.124, 82.02069, 4.834562, 120, 0); -- [70] Guard Didier <Brotherhood of the Light> |