[7558] Implement command: .learn all_mypettalents Author: VladimirMangos

    Also output more correct messages at use .reset talents to pet

--HG--
branch : trunk

2 files changed, 15 insertions, 0 deletions

diff --git a/sql/updates/7558_01_mangos_mangos_string.sql b/sql/updates/7558_01_mangos_mangos_string.sql
new file mode 100644
index 00000000000..79012b791ad
--- /dev/null
+++ b/sql/updates/7558_01_mangos_mangos_string.sql
@@ -0,0 +1,9 @@
+ALTER TABLE db_version CHANGE COLUMN required_7544_01_mangos_uptime required_7558_01_mangos_mangos_string bit;
+
+DELETE FROM mangos_string WHERE entry IN (1123,1124,1125);
+INSERT INTO mangos_string VALUES
+(1123,'Not pet found',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
+(1124,'Wrong pet type',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
+(1125,'Your pet learned all talents',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
+(1126,'Your pet talents have been reset.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
+(1127,'Talents of %s\'s pet reset.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
diff --git a/sql/updates/7558_02_mangos_command.sql b/sql/updates/7558_02_mangos_command.sql
new file mode 100644
index 00000000000..cd5b2ff89bf
--- /dev/null
+++ b/sql/updates/7558_02_mangos_command.sql
@@ -0,0 +1,6 @@
+ALTER TABLE db_version CHANGE COLUMN required_7558_01_mangos_mangos_string required_7558_02_mangos_command bit;
+
+DELETE FROM `command` WHERE `name` IN ('learn all_mypettalents');
+
+INSERT INTO `command` VALUES
+('learn all_mypettalents',3,'Syntax: .learn all_mypettalents\r\n\r\nLearn all talents for your pet available for his creature type (only for hunter pets).');