From a666bdfc31f8df005a73c50d78a5c16dcec2c81c Mon Sep 17 00:00:00 2001 From: bibi <125542784+14shagov@users.noreply.github.com> Date: Fri, 23 Feb 2024 22:05:03 +0300 Subject: Scripts/Sunken Temple: fix Shade of Eranikus and Jammal'an the Prophet (#29663) * Also minor modernization for instance script Co-authored-by: 14shagov <14shagov> Co-authored-by: Shauren --- sql/updates/world/3.3.5/2024_02_23_00_world.sql | 5 +++++ 1 file changed, 5 insertions(+) create mode 100644 sql/updates/world/3.3.5/2024_02_23_00_world.sql (limited to 'sql') diff --git a/sql/updates/world/3.3.5/2024_02_23_00_world.sql b/sql/updates/world/3.3.5/2024_02_23_00_world.sql new file mode 100644 index 00000000000..c07b9498e2a --- /dev/null +++ b/sql/updates/world/3.3.5/2024_02_23_00_world.sql @@ -0,0 +1,5 @@ +SET @GUID := 11011; -- (unused GUID from TDB 335.24011) + +DELETE FROM `gameobject` WHERE `guid` = @GUID; +INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `ScriptName`, `VerifiedBuild`) VALUES +(@GUID, 149431, 109, 0, 0, 1, 1, -518.154, -85.2353, -74.488, 3.14159, -0, -0, -1, -0.00000126759, 43200, 100, 1, '', 0); -- cgit v1.2.3