diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2018_10_10_08_world.sql | 17 |
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); |