From bcfff09c74ec3e7cc6bd4c42938701c501f3bfd7 Mon Sep 17 00:00:00 2001 From: tartalo Date: Mon, 2 Nov 2009 21:05:54 +0100 Subject: *Implementation of 'No Fly Zone' (Dalaran and Wintergrasp), by Spp --HG-- branch : trunk --- sql/FULL/world_spell_full.sql | 4 ++++ sql/FULL/world_trinity_string_full.sql | 1 + 2 files changed, 5 insertions(+) (limited to 'sql/FULL') diff --git a/sql/FULL/world_spell_full.sql b/sql/FULL/world_spell_full.sql index dc95e228bdc..24707ac9c61 100644 --- a/sql/FULL/world_spell_full.sql +++ b/sql/FULL/world_spell_full.sql @@ -2284,6 +2284,10 @@ INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comm update game_graveyard_zone set ghost_zone = 4603 where id = 1474; +-- No Fly Zone +INSERT INTO `spell_linked_spell` (spell_trigger, spell_effect, type, comment) VALUES + (-58600, 61243, 0, 'No fly zone - Parachute'), + (-58730, 61243, 0, 'No fly zone - Parachute'); -- temp diff --git a/sql/FULL/world_trinity_string_full.sql b/sql/FULL/world_trinity_string_full.sql index 6ac81f93144..30396a6d24c 100644 --- a/sql/FULL/world_trinity_string_full.sql +++ b/sql/FULL/world_trinity_string_full.sql @@ -628,6 +628,7 @@ INSERT INTO `trinity_string` (`entry`, `content_default`, `content_loc1`, `conte (813, 'Veteran', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), (814, 'Member', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), (815, 'Initiate', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), +(816, 'You have entered a No-Fly Zone and are about to be dismounted.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1000, 'Exiting daemon...', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1001, 'Account deleted: %s', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1002, 'Account %s NOT deleted (probably sql file format was updated)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), -- cgit v1.2.3