diff options
| author | Killyana <morphone1@gmail.com> | 2020-01-18 17:26:57 +0100 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2021-12-20 23:01:30 +0100 |
| commit | 61ef6e5c90bd6f4bc8aecedb14a3f1f054d2bfcd (patch) | |
| tree | 3ea184879174bf83aceb0dc98b1f949ae1615e80 | |
| parent | 565ba0010c8d2af211f6c775faa13f41db5775a9 (diff) | |
DB/Creature: Fix Some spawns in Sholazar
(cherry picked from commit 50c9478b763e83c7ebdbbbc482bdd783afd584c6)
| -rw-r--r-- | sql/updates/world/master/2021_12_20_20_world_2020_01_18_01_world.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_12_20_20_world_2020_01_18_01_world.sql b/sql/updates/world/master/2021_12_20_20_world_2020_01_18_01_world.sql new file mode 100644 index 00000000000..4aeaa1354bf --- /dev/null +++ b/sql/updates/world/master/2021_12_20_20_world_2020_01_18_01_world.sql @@ -0,0 +1,8 @@ +-- +DELETE FROM `creature` WHERE `guid` IN(200010,200008) AND `id` IN (29057,29069); +DELETE FROM `spawn_group` WHERE `spawnId` IN (200010,200008) AND `spawnType`=0; +UPDATE `creature` SET `position_x`=6232.26, `position_y`=4944.96, `position_z`=-98.8431, `orientation`=3.43397, `spawndist`=0, `MovementType`=0 WHERE `guid`=115122; +UPDATE `creature` SET `position_x`=6241.88, `position_y`=4953.22, `position_z`=-98.7876, `orientation`=3.57534, `spawndist`=0, `MovementType`=0 WHERE `guid`=115126; +UPDATE `creature` SET `position_x`=6222.05, `position_y`=4943.04, `position_z`=-98.8662, `orientation`=3.62246, `spawndist`=0, `MovementType`=0 WHERE `guid`=115196; +UPDATE `creature` SET `position_x`=6203.99, `position_y`=4966.64, `position_z`=-98.9068, `orientation`=4.27041, `spawndist`=0, `MovementType`=0 WHERE `guid`=115136; +UPDATE `creature` SET `position_x`=6212.96, `position_y`=4974.03, `position_z`=-98.8272, `orientation`=4.08192, `spawndist`=0, `MovementType`=0 WHERE `guid`=115192; |