diff options
| author | offl <offl@users.noreply.github.com> | 2020-11-26 02:26:14 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2022-03-01 23:29:33 +0100 |
| commit | 09e612c565c1477a8f5ae3fb6cc3e4e4aa663587 (patch) | |
| tree | f59481d40c96c3cb81250fe5915fef78c77e1a15 | |
| parent | 95d46bb7df729e1424510c3c72d41acb3bfcc8c7 (diff) | |
DB/Instance/Eye of Eternity: Verify & update spawn positions & stats
(cherry picked from commit 40f4e580f5e1158081e73edc38a903d6db47c9a4)
| -rw-r--r-- | sql/updates/world/master/2022_03_01_13_world_2020_11_26_07_world.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_03_01_13_world_2020_11_26_07_world.sql b/sql/updates/world/master/2022_03_01_13_world_2020_11_26_07_world.sql new file mode 100644 index 00000000000..df9a9b6a36c --- /dev/null +++ b/sql/updates/world/master/2022_03_01_13_world_2020_11_26_07_world.sql @@ -0,0 +1,9 @@ +-- +UPDATE `creature` SET `VerifiedBuild` = 12340 WHERE `map` = 616 AND `id` IN (22517,30090,30118,30334,32448); +UPDATE `creature` SET `position_x` = 754.255, `position_y` = 1301.72, `position_z` = 266.253, `orientation` = 1.23918, `VerifiedBuild` = 12340 WHERE `id` = 31253; + +-- Remove empty addon +DELETE FROM `creature_addon` WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` = 30334); + +-- Power Spark & Scion of Eternity +-- UPDATE `creature_template` SET `minlevel` = 80, `maxlevel` = 80 WHERE `entry` IN (30084,30249); |