diff options
| author | tartalo <none@none> | 2009-11-02 21:05:54 +0100 |
|---|---|---|
| committer | tartalo <none@none> | 2009-11-02 21:05:54 +0100 |
| commit | bcfff09c74ec3e7cc6bd4c42938701c501f3bfd7 (patch) | |
| tree | 18140ff9d2ec1dfa1d56424a704242be793e2d7d /sql | |
| parent | ae2a36d13e32e7aae945c8cc1862b340f4669744 (diff) | |
*Implementation of 'No Fly Zone' (Dalaran and Wintergrasp), by Spp
--HG--
branch : trunk
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/FULL/world_spell_full.sql | 4 | ||||
| -rw-r--r-- | sql/FULL/world_trinity_string_full.sql | 1 | ||||
| -rw-r--r-- | sql/updates/6171_world.sql | 5 |
3 files changed, 10 insertions, 0 deletions
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), diff --git a/sql/updates/6171_world.sql b/sql/updates/6171_world.sql new file mode 100644 index 00000000000..f3b628e1dda --- /dev/null +++ b/sql/updates/6171_world.sql @@ -0,0 +1,5 @@ +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'); +INSERT INTO `trinity_string` (entry, content_default, content_loc1, content_loc2, content_loc3, content_loc4, content_loc5, content_loc6, content_loc7, content_loc8) VALUES + (816, 'You have entered a No-Fly Zone and are about to be dismounted.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); |