From 0cee18494e46832ee9c734b1b3d2d046cdde83e8 Mon Sep 17 00:00:00 2001
From: win32 <>
Date: Thu, 21 Jan 2010 11:38:19 +0200
Subject: update sql in prev commit to trinity format

--HG--
branch : trunk
---
 sql/updates/7134_world_command.sql        | 3 ++-
 sql/updates/7134_world_trinity_string.sql | 5 +++--
 2 files changed, 5 insertions(+), 3 deletions(-)

(limited to 'sql')

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),
-- 
cgit v1.2.3