diff options
| author | Aokromes <Aokromes@users.noreply.github.com> | 2024-10-10 09:27:07 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2024-10-10 09:27:07 +0200 |
| commit | 57c17269e4e6dd52d4b7ad6b2f0c865c15141cb8 (patch) | |
| tree | 0ed25855730b3c9624788a4e640faf609faef4fb | |
| parent | e3daa2b90058192b9e62dcfddd3cc403ffbfd39a (diff) | |
DB/Gameobject: Add 4 missing gameobjects in Thunderbluff
closes #30333 by CraftedRO
| -rw-r--r-- | sql/updates/world/3.3.5/2024_10_10_00_world.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2024_10_10_00_world.sql b/sql/updates/world/3.3.5/2024_10_10_00_world.sql new file mode 100644 index 00000000000..5f949e62eb5 --- /dev/null +++ b/sql/updates/world/3.3.5/2024_10_10_00_world.sql @@ -0,0 +1,8 @@ +-- Add 4 missing gameobjects in Thunderbluff +SET @OGUID=9901; -- four consecutive free gob guids atm +DELETE FROM `gameobject` WHERE `guid` IN (@OGUID,@OGUID+1,@OGUID+2,@OGUID+3); +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`, `StringId`, `VerifiedBuild`) VALUES +(@OGUID, 152583, 1, 0, 0, 1, 1, -1257.8424072265625, 24.41799354553222656, 128.217498779296875, 2.888511419296264648, 0, 0, 0.99200439453125, 0.126203224062919616, 120, 100, 1, '', NULL, 0), +(@OGUID+1, 185004, 1, 0, 0, 1, 1, -1049.5347900390625, -290.34722900390625, 159.0303497314453125, 0.209439441561698913, 0, 0, 0.104528427124023437, 0.994521915912628173, 120, 100, 1, '', NULL, 0), +(@OGUID+2, 185004, 1, 0, 0, 1, 1, -1050.2257080078125, -290.552093505859375, 159.0303497314453125, 2.495818138122558593, 0, 0, 0.948323249816894531, 0.317305892705917358, 120, 100, 1, '', NULL, 0), +(@OGUID+3, 182257, 1, 0, 0, 1, 1, -1049.82470703125, -286.196197509765625, 159.0303497314453125, 2.548179388046264648, 0, 0, 0.956304550170898437, 0.292372345924377441, 120, 100, 1, '', NULL, 0); |