DB/Creature: Add some missing spawns

Night Watch Guard 10038 was remove as they must spawn only if horde players attack some areas like Darkshire

1 files changed, 17 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2018_10_10_08_world.sql b/sql/updates/world/3.3.5/2018_10_10_08_world.sql
new file mode 100644
index 00000000000..4bffdc276f7
--- /dev/null
+++ b/sql/updates/world/3.3.5/2018_10_10_08_world.sql
@@ -0,0 +1,17 @@
+DELETE FROM `creature` WHERE `guid` IN (6127,6133,86872,86881,86895,86899,86900,86926,86933,87016,87017,87018,87019,87020,87021);
+INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `MovementType`) VALUES
+(6133, 1475, 0, 1, 1, 0, 1, -3702.73, -875.307, 10.8532, 2.15864, 300,0,0),
+(6127, 1475, 0, 1, 1, 0, 1, -3708.92, -712.578, 9.17267, 4.02893, 300,0,0),
+(86872, 2188, 1, 1, 1, 0, 0, 8205.18, -942.167, -24.0992, 5.52606, 300, 8, 1),
+(86881, 2188, 1, 1, 1, 0, 0, 8141.94, -932.122, -22.4119, 4.78307, 300, 8, 1),
+(86895, 2188, 1, 1, 1, 0, 0, 8197.71, -1212.46, -51.4801, 4.93622, 300, 8, 1),
+(86899, 2188, 1, 1, 1, 0, 0, 8287.17, -1227.98, -79.8464, 1.18987, 300, 8, 1),
+(86900, 2188, 1, 1, 1, 0, 0, 8346.42, -1096.5, -82.6515, 3.75184, 300, 8, 1),
+(86926, 2188, 1, 1, 1, 0, 0, 8283.3, -1096.47, -64.8594, 0.0400507, 300, 8, 1),
+(86933, 2188, 1, 1, 1, 0, 0, 8253.2, -1117.77, -59.4172, 1.84882, 300, 8, 1),
+(87016, 2188, 1, 1, 1, 0, 0, 8143.82, -1092.24, -18.2926, 4.04637, 300, 8, 1),
+(87017, 2188, 1, 1, 1, 0, 0, 8223.68, -971.797, -46.0062, 1.82997, 300, 8, 1),
+(87018, 2188, 1, 1, 1, 0, 0, 8059.41, -894.016, -23.4058, 5.15614, 300, 8, 1),
+(87019, 2187, 1, 1, 1, 0, 0, 7951.68, -761.708, -16.9966, 2.80779, 300, 8, 1),
+(87020, 2187, 1, 1, 1, 0, 0, 7943.62, -902.689, -19.8649, 2.64677, 300, 8, 1),
+(87021, 2187, 1, 1, 1, 0, 0, 8035.47, -775.006, -30.7854, 0.0148895, 300, 8, 1);