diff options
| author | Killyana <morphone1@gmail.com> | 2017-11-07 03:58:01 +0100 |
|---|---|---|
| committer | funjoker <funjoker109@gmail.com> | 2021-01-29 19:23:53 +0100 |
| commit | 343389dc8411b9b3ea5f7e3623ad7f32cf304490 (patch) | |
| tree | 4c6f4ab935ed527d1b517406330ed355c9eb0e68 | |
| parent | b14be7e985c4c3042c6d0e5081f9a4cbb25c149b (diff) | |
DB: Add some missing spawns
(cherry picked from commit 28cd4b5281c0737247e4478926dcacf9172f3cae)
| -rw-r--r-- | sql/updates/world/master/2021_01_25_07_world_2017_11_07_00_world.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_01_25_07_world_2017_11_07_00_world.sql b/sql/updates/world/master/2021_01_25_07_world_2017_11_07_00_world.sql new file mode 100644 index 00000000000..ff420db36fc --- /dev/null +++ b/sql/updates/world/master/2021_01_25_07_world_2017_11_07_00_world.sql @@ -0,0 +1,10 @@ +-- +DELETE FROM `creature` WHERE `guid` IN (81144,81145,81146); +INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `VerifiedBuild`) VALUES +(81144, 24580, 571, 0, 0, '0', 170, 0, 0, 1321.86, 5985.3, 24.0983, 5.96903, 180, 0, 0, 6986, 0, 0, 0), +(81145, 24580, 571, 0, 0, '0', 170, 0, 0, 1371.06, 5813.19, 6.16783, 1.20428, 180, 0, 0, 6986, 0, 0, 0), +(81146, 24580, 571, 0, 0, '0', 170, 0, 0, 1407.27, 5971.62, 5.82894, 0.959931, 180, 0, 0, 6986, 0, 0, 0); + +DELETE FROM `gameobject` WHERE `guid` IN (1430); +INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES +(1430, 187703, 571, 0, 0, '0', 170, 1325.65, 5984.97, 23.4195, 2.076939, 0, 0, 0.8616285, 0.5075394, 300, 255, 1, 0); |