diff options
| author | Aokromes <Aokromes@users.noreply.github.com> | 2024-05-26 14:11:48 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2024-05-26 14:11:48 +0200 |
| commit | f96f8476e675035d7094e59e32bab69e8a46b1b8 (patch) | |
| tree | 649c7f2fad50cf9171c6e5bfda2295a87dfd42c7 /sql/updates | |
| parent | 1e196f6016fd344ab872526a346058b8348d70a7 (diff) | |
DB/Gameobject: Add 3 gameobjects in Shattrath - Aldor Rise
closes #30008 by CraftedRO
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/world/3.3.5/2024_05_26_01_world.sql | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2024_05_26_01_world.sql b/sql/updates/world/3.3.5/2024_05_26_01_world.sql new file mode 100644 index 00000000000..d661f9ff9be --- /dev/null +++ b/sql/updates/world/3.3.5/2024_05_26_01_world.sql @@ -0,0 +1,6 @@ +-- Add 3 gameobjects in Shattrath - Aldor Rise +DELETE FROM `gameobject` WHERE `guid` IN (9898,9899,9900) AND `id` IN (194466,194467,194468); +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 +(9898, 194466, 530, 0, 0, 1, 1, -1737.48095703125, 5632.6103515625, 128.9701995849609375, 0, 0, 0, 0, 1, 120, 255, 1, '', 54847), -- Alchemy Lab +(9899, 194467, 530, 0, 0, 1, 1, -1745.2545166015625, 5646.84228515625, 128.023193359375, 5.567600727081298828, 0, 0, -0.35020732879638671, 0.936672210693359375, 120, 255, 1, '', 54847), -- Blacksmith's Anvil +(9900, 194468, 530, 0, 0, 1, 1, -1747.6688232421875, 5648.66162109375, 128.023193359375, 4.049167633056640625, 0, 0, -0.89879322052001953, 0.438372820615768432, 120, 255, 1, '', 54847); -- Forge |