From 40f4e580f5e1158081e73edc38a903d6db47c9a4 Mon Sep 17 00:00:00 2001 From: offl Date: Thu, 26 Nov 2020 02:26:14 +0200 Subject: DB/Instance/Eye of Eternity: Verify & update spawn positions & stats --- sql/updates/world/3.3.5/2020_11_26_07_world.sql | 9 +++++++++ 1 file changed, 9 insertions(+) create mode 100644 sql/updates/world/3.3.5/2020_11_26_07_world.sql (limited to 'sql') 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); -- cgit v1.2.3