diff options
| author | Dr-J <daniel.jarrott0@gmail.com> | 2014-07-29 14:12:08 +0100 |
|---|---|---|
| committer | Dr-J <daniel.jarrott0@gmail.com> | 2014-07-29 14:12:08 +0100 |
| commit | 5aa900dd535b288524c1f2767dbf6656442405cb (patch) | |
| tree | e7660be01cd4f20c07cfb4bcf838db8bfdca577a | |
| parent | 0e52b111f3731611ff6c5be2bf0bd849d4e012fb (diff) | |
DB/Creature: Spawn missing spawns (3.3.5)
Spawn Miles Sidney and Wright Williams who are missing from 3.3.5 world db
| -rw-r--r-- | sql/updates/world/2014_07_29_00_335_world_sai.sql | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/2014_07_29_00_335_world_sai.sql b/sql/updates/world/2014_07_29_00_335_world_sai.sql new file mode 100644 index 00000000000..2d431886124 --- /dev/null +++ b/sql/updates/world/2014_07_29_00_335_world_sai.sql @@ -0,0 +1,6 @@ +SET @CGUID := 45215; + +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+1; +INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `MovementType`) VALUES +(@CGUID+0, 28355, 0, 1, 1, -8670.599, 427.4635, 100.9918, 0.9599311, 120, 0, 0), +(@CGUID+1, 28347, 0, 1, 1, -8672.78, 430.8922, 100.9918, 0.6632251, 120, 0, 0); |