diff options
| -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); |