aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sql/updates/7134_world_command.sql3
-rw-r--r--sql/updates/7134_world_trinity_string.sql5
2 files changed, 5 insertions, 3 deletions
diff --git a/sql/updates/7134_world_command.sql b/sql/updates/7134_world_command.sql
index 442bced945a..a0727046d48 100644
--- a/sql/updates/7134_world_command.sql
+++ b/sql/updates/7134_world_command.sql
@@ -1,6 +1,7 @@
DELETE FROM command where name IN ('character titles','modify titles','titles add','titles current','titles remove','lookup title');
-INSERT INTO `command` VALUES
+INSERT INTO `command` (`name`, `security`, `help`)
+VALUES
('character titles',2,'Syntax: .character titles [$player_name]\r\n\r\nShow known titles list for selected player or player find by $player_name.'),
('titles add',2,'Syntax: .titles add #title\r\nAdd title #title (id or shift-link) to known titles list for selected player.'),
('titles current',2,'Syntax: .titles current #title\r\nSet title #title (id or shift-link) as current selected titl for selected player. If title not in known title list for player then it will be added to list.'),
diff --git a/sql/updates/7134_world_trinity_string.sql b/sql/updates/7134_world_trinity_string.sql
index 32b0887888d..ea344c19362 100644
--- a/sql/updates/7134_world_trinity_string.sql
+++ b/sql/updates/7134_world_trinity_string.sql
@@ -1,6 +1,7 @@
-DELETE FROM mangos_string WHERE entry in (349, 350, 351, 352, 353, 354, 355, 356);
+DELETE FROM trinity_string WHERE entry in (349, 350, 351, 352, 353, 354, 355, 356);
-INSERT INTO mangos_string VALUES
+INSERT INTO trinity_string (`entry`,`content_default`,`content_loc1`,`content_loc2`,`content_loc3`,`content_loc4`,`content_loc5`,`content_loc6`,`content_loc7`,`content_loc8`)
+VALUES
(349,'%d (idx:%d) - |cffffffff|Htitle:%d|h[%s %s]|h|r %s %s ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(350,'%d (idx:%d) - [%s %s] %s %s ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(351,'No titles found!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),