From ce8462ccf9ba6730db6b1c17e4db95c0519a66e2 Mon Sep 17 00:00:00 2001 From: megamage Date: Sat, 28 Mar 2009 16:25:42 -0600 Subject: [7558] Implement command: .learn all_mypettalents Author: VladimirMangos Also output more correct messages at use .reset talents to pet --HG-- branch : trunk --- sql/updates/7558_01_mangos_mangos_string.sql | 9 +++++++++ sql/updates/7558_02_mangos_command.sql | 6 ++++++ 2 files changed, 15 insertions(+) create mode 100644 sql/updates/7558_01_mangos_mangos_string.sql create mode 100644 sql/updates/7558_02_mangos_command.sql (limited to 'sql/updates') 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).'); -- cgit v1.2.3