diff options
| author | offl <offl@users.noreply.github.com> | 2020-11-26 02:26:14 +0200 |
|---|---|---|
| committer | offl <offl@users.noreply.github.com> | 2020-11-26 02:26:14 +0200 |
| commit | 40f4e580f5e1158081e73edc38a903d6db47c9a4 (patch) | |
| tree | 3687a143acbdd22531a676252eee179ada2fc207 | |
| parent | 6af54eb508b337dd61ba6039ddf60ff6438308a3 (diff) | |
DB/Instance/Eye of Eternity: Verify & update spawn positions & stats
| -rw-r--r-- | sql/updates/world/3.3.5/2020_11_26_07_world.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2020_11_26_07_world.sql b/sql/updates/world/3.3.5/2020_11_26_07_world.sql new file mode 100644 index 00000000000..52be427da1d --- /dev/null +++ b/sql/updates/world/3.3.5/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); |