Implement .reload all_gossips, .reload quest_poi, .reload locales_gossip_menu_option. Original code by VladimirMangos, ported by Ramus. Closes issue #3466, issue #3637 and issue #3477

--HG--
branch : trunk

2 files changed, 8 insertions, 0 deletions

diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql
index d7153a86a60..b4af6b72227 100644
--- a/sql/base/world_database.sql
+++ b/sql/base/world_database.sql
@@ -555,6 +555,7 @@ INSERT INTO `command` VALUES
 ('recall',1,'Syntax: .recall [$playername]\r\n\r\nTeleport $playername or selected player to the place where he has been before last use of a teleportation command. If no $playername is entered and no player is selected, it will teleport you.'),
 ('reload',3,'Syntax: .reload $subcommand\nType .reload to see the list of possible subcommands or .help reload $subcommand to see info on subcommands'),
 ('reload all',3,'Syntax: .reload all\r\n\r\nReload all tables with reload support added and that can be _safe_ reloaded.'),
+('reload all_gossips',3,'Syntax: .reload all_gossips\nReload gossip_menu, gossip_menu_option, gossip_scripts, npc_gossip, points_of_interest tables.'),
 ('reload all_item',3,'Syntax: .reload all_item\nReload page_text, item_enchantment_table tables.'),
 ('reload all_locales',3,'Syntax: .reload all_locales\r\n\r\nReload all `locales_*` tables with reload support added and that can be _safe_ reloaded.'),
 ('reload all_loot',3,'Syntax: .reload all_loot\r\n\r\nReload all `*_loot_template` tables. This can be slow operation with lags for server run.'),
@@ -593,6 +594,7 @@ INSERT INTO `command` VALUES
 ('reload item_set_names',3,'Syntax: .reload item_set_names\nReload item_set_names table.'),
 ('reload locales_creature',3,'Syntax: .reload locales_creature\nReload locales_creature table.'),
 ('reload locales_gameobject',3,'Syntax: .reload locales_gameobject\nReload locales_gameobject table.'),
+('reload locales_gossip_menu_option',3, 'Syntax: .reload locales_gossip_menu_option\nReload locales_gossip_menu_option table.'),
 ('reload locales_item',3,'Syntax: .reload locales_item\nReload locales_item table.'),
 ('reload locales_item_set_name',3,'Syntax: .reload locales_item_set_name\nReload locales_item_set_name table.'),
 ('reload locales_npc_text',3,'Syntax: .reload locales_npc_text\nReload locales_npc_text table.'),
@@ -609,6 +611,7 @@ INSERT INTO `command` VALUES
 ('reload prospecting_loot_template',3,'Syntax: .reload prospecting_loot_template\nReload prospecting_loot_template table.'),
 ('reload quest_end_scripts',3,'Syntax: .reload quest_end_scripts\nReload quest_end_scripts table.'),
 ('reload mail_loot_template',3,'Syntax: .reload mail_loot_template\nReload mail_loot_template table.'),
+('reload quest_poi',3,'Syntax: .reload quest_poi\nReload quest_poi table.'),
 ('reload quest_start_scripts',3,'Syntax: .reload quest_start_scripts\nReload quest_start_scripts table.'),
 ('reload quest_template',3,'Syntax: .reload quest_template\nReload quest_template table.'),
 ('reload reference_loot_template',3,'Syntax: .reload reference_loot_template\nReload reference_loot_template table.'),
diff --git a/sql/updates/9644_world_command.sql b/sql/updates/9644_world_command.sql
new file mode 100644
index 00000000000..d1e5687f68e
--- /dev/null
+++ b/sql/updates/9644_world_command.sql
@@ -0,0 +1,5 @@
+DELETE FROM command WHERE name IN ('reload all_gossips', 'reload locales_gossip_menu_option', 'reload quest_poi');
+INSERT INTO command (name, security, help) VALUES
+('reload all_gossips',3,'Syntax: .reload all_gossips\nReload gossip_menu, gossip_menu_option, gossip_scripts, npc_gossip, points_of_interest tables.'),
+('reload locales_gossip_menu_option',3, 'Syntax: .reload locales_gossip_menu_option\nReload locales_gossip_menu_option table.'),
+('reload quest_poi',3,'Syntax: .reload quest_poi\nReload quest_poi table.');
\ No newline at end of file