diff options
| author | click <none@none> | 2010-08-17 11:49:53 +0200 |
|---|---|---|
| committer | click <none@none> | 2010-08-17 11:49:53 +0200 |
| commit | 3695accf5023516d05a028adc3d339053044a499 (patch) | |
| tree | 2ad7e0c09237558954b1bf5b9241de1031e10eb0 /sql | |
| parent | 26386d1e206f4b1fbc3018d7be9d00da9a5aeddf (diff) | |
Core: Add support for reloading gossip_scripts + add missing SQL for earlier inserted commands (gossip_menu and gossip_menu_option)
Thanks to Kaelima
Fixes issue 2433
--HG--
branch : trunk
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/base/world_database.sql | 3 | ||||
| -rw-r--r-- | sql/updates/9427_world_command.sql | 5 |
2 files changed, 8 insertions, 0 deletions
diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql index 16ecbc9399e..6099d56ce93 100644 --- a/sql/base/world_database.sql +++ b/sql/base/world_database.sql @@ -584,6 +584,9 @@ INSERT INTO `command` VALUES ('reload gameobject_scripts',3,'Syntax: .reload gameobject_scripts\nReload gameobject_scripts table.'), ('reload game_graveyard_zone',3,'Syntax: .reload game_graveyard_zone\nReload game_graveyard_zone table.'), ('reload game_tele',3,'Syntax: .reload game_tele\nReload game_tele table.'), +('reload gossip_menu',3,'Syntax: .reload gossip_menu\nReload gossip_menu table.'), +('reload gossip_menu_option',3,'Syntax: .reload gossip_menu_option\nReload gossip_menu_option table.'), +('reload gossip_scripts',3,'Syntax: .reload gossip_scripts\nReload gossip_scripts table.'), ('reload gm_tickets',3,'Syntax: .reload gm_tickets\nReload gm_tickets table.'), ('reload item_enchantment_template',3,'Syntax: .reload item_enchantment_template\nReload item_enchantment_template table.'), ('reload item_loot_template',3,'Syntax: .reload item_loot_template\nReload item_loot_template table.'), diff --git a/sql/updates/9427_world_command.sql b/sql/updates/9427_world_command.sql new file mode 100644 index 00000000000..3f294a387c6 --- /dev/null +++ b/sql/updates/9427_world_command.sql @@ -0,0 +1,5 @@ +DELETE FROM `command` WHERE `name` IN ('reload gossip_menu','reload gossip_menu_option','reload gossip_scripts'); +INSERT INTO `command` (`name`,`security`,`help`) VALUES +('reload gossip_menu',3, 'Syntax: .reload gossip_menu\nReload gossip_menu table.'), +('reload gossip_menu_option',3, 'Syntax: .reload gossip_menu_option\nReload gossip_menu_option table.'), +('reload gossip_scripts',3, 'Syntax: .reload gossip_scripts\nReload gossip_scripts table.'), |