diff options
| author | Ovahlord <dreadkiller@gmx.de> | 2025-04-12 18:06:42 +0200 |
|---|---|---|
| committer | Ovahlord <dreadkiller@gmx.de> | 2025-04-12 18:06:42 +0200 |
| commit | 9df8b6d7596e58485ed8c77c750189a9ad521408 (patch) | |
| tree | e5b75dbf0c581c4e20362a014df1c6dba24dfb57 /sql | |
| parent | 2b404ee64ed0f445d86da27665f46c0e901187b4 (diff) | |
DB/Transports: restored several ship and zeppelin transports which have been removed post Cataclysm
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/cata_classic/2025_04_12_11_world.sql | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/sql/updates/world/cata_classic/2025_04_12_11_world.sql b/sql/updates/world/cata_classic/2025_04_12_11_world.sql new file mode 100644 index 00000000000..9017656381d --- /dev/null +++ b/sql/updates/world/cata_classic/2025_04_12_11_world.sql @@ -0,0 +1,12 @@ +-- Remove some post Cataclysm spawns (Construction site blockers) +DELETE FROM `gameobject` WHERE `guid` IN (501819, 501820, 501821, 502263); +DELETE FROM `gameobject_addon` WHERE `guid` IN (501819, 501820, 501821, 502263); + +DELETE FROM `transports` WHERE `guid` IN (1, 2, 6, 8, 9, 11); +INSERT INTO `transports` (`guid`, `entry`, `Name`, `phaseUseFlags`, `phaseId`, `phaseGroup`, `ScriptName`) VALUES +(1, 176495, 'Undercity, Tirisfal Glades and Grom\'gol Base Camp, Stranglethorn Vale ("The Purple Princess")', 0, 0, 0, ''), +(2, 176310, 'Stormwind Harbor and Auberdine, Darkshore ("Ship (The Bravery)")', 0, 0, 0, ''), +(6, 164871, 'Orgrimmar, Durotar and Undercity, Tirisfal Glades ("The Thundercaller")', 0, 0, 0, ''), +(8, 177233, 'The Forgotten Coast, Feralas and Feathermoon Stronghold, Sardor Isle, Feralas ("Feathermoon Ferry")', 0, 0, 0, ''), +(9, 181646, 'Valaar\'s Berth, Azuremyst Isle and Auberdine, Darkshore ("Elune\'s Blessing")', 0, 0, 0, ''), +(11, 181689, 'Undercity, Tirisfal Glades and Vengeance Landing, Howling Fjord ("Zeppelin, Horde (Cloudkisser)")', 0, 0, 0, ''); |