diff options
| author | bibi <125542784+14shagov@users.noreply.github.com> | 2024-02-23 22:05:03 +0300 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2024-02-23 20:05:03 +0100 |
| commit | a666bdfc31f8df005a73c50d78a5c16dcec2c81c (patch) | |
| tree | 8e3f136b28b5aa194e780bece51a4c07e4cd7e17 /sql/updates/world | |
| parent | e835ab5014345962d84590cdd2ce71cc27608c80 (diff) | |
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 <shauren.trinity@gmail.com>
Diffstat (limited to 'sql/updates/world')
| -rw-r--r-- | sql/updates/world/3.3.5/2024_02_23_00_world.sql | 5 |
1 files changed, 5 insertions, 0 deletions
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); |