From 6147bfaf041a1f1cf059f2f11770fba5ca50f197 Mon Sep 17 00:00:00 2001 From: Muhaha Date: Tue, 10 Feb 2009 19:35:52 +0100 Subject: * Stormwind Harbor Taxi. Author: FrozenDB --HG-- branch : trunk --- sql/updates/1307_world.sql | 1 + sql/updates/2.4.3_updates/1018_world.sql | 6 ++++++ sql/updates/2.4.3_updates/1018_wrold.sql | 6 ------ sql/updates/CMakeLists.txt | 1 + 4 files changed, 8 insertions(+), 6 deletions(-) create mode 100644 sql/updates/1307_world.sql create mode 100644 sql/updates/2.4.3_updates/1018_world.sql delete mode 100644 sql/updates/2.4.3_updates/1018_wrold.sql (limited to 'sql') diff --git a/sql/updates/1307_world.sql b/sql/updates/1307_world.sql new file mode 100644 index 00000000000..ddb0b9732c9 --- /dev/null +++ b/sql/updates/1307_world.sql @@ -0,0 +1 @@ +UPDATE `creature_template` SET `ScriptName`='npc_stormwindharbor_taxi' WHERE `entry`='29154'; \ No newline at end of file diff --git a/sql/updates/2.4.3_updates/1018_world.sql b/sql/updates/2.4.3_updates/1018_world.sql new file mode 100644 index 00000000000..ca298faa8f3 --- /dev/null +++ b/sql/updates/2.4.3_updates/1018_world.sql @@ -0,0 +1,6 @@ +DELETE FROM `spell_linked_spell` WHERE `spell_trigger` IN (31224,41292,44007,44867); +INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES +(31224, -1543, 2, 'Cloak of Shadows - Flare'), +(41292, 42017, 2, 'Aura of Suffering'), +(44007, -43657, 2, 'Storm Eye Safe Zone Immune'), +(44867, -46019, 2, 'Spectral Exhaustion - Teleport: Spectral Realm'); \ No newline at end of file diff --git a/sql/updates/2.4.3_updates/1018_wrold.sql b/sql/updates/2.4.3_updates/1018_wrold.sql deleted file mode 100644 index ca298faa8f3..00000000000 --- a/sql/updates/2.4.3_updates/1018_wrold.sql +++ /dev/null @@ -1,6 +0,0 @@ -DELETE FROM `spell_linked_spell` WHERE `spell_trigger` IN (31224,41292,44007,44867); -INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES -(31224, -1543, 2, 'Cloak of Shadows - Flare'), -(41292, 42017, 2, 'Aura of Suffering'), -(44007, -43657, 2, 'Storm Eye Safe Zone Immune'), -(44867, -46019, 2, 'Spectral Exhaustion - Teleport: Spectral Realm'); \ No newline at end of file diff --git a/sql/updates/CMakeLists.txt b/sql/updates/CMakeLists.txt index 3a90daa799c..751629ef23c 100644 --- a/sql/updates/CMakeLists.txt +++ b/sql/updates/CMakeLists.txt @@ -27,4 +27,5 @@ INSTALL(FILES 1018_world.sql 1026_world.sql 1028_world_scripts.sql +1307_world.sql DESTINATION share/trinity/sql/updates) \ No newline at end of file -- cgit v1.2.3