From 673ab0019cdd402f4359b505dc865d2c67e75163 Mon Sep 17 00:00:00 2001 From: Spp Date: Fri, 12 Mar 2010 19:20:11 +0100 Subject: Some Ticket text formating changes to help addons to parse data Linked issue 466 --HG-- branch : trunk --- sql/updates/7549_world_trinity_string.sql | 6 ++++++ sql/world.sql | 8 ++++---- 2 files changed, 10 insertions(+), 4 deletions(-) create mode 100644 sql/updates/7549_world_trinity_string.sql (limited to 'sql') diff --git a/sql/updates/7549_world_trinity_string.sql b/sql/updates/7549_world_trinity_string.sql new file mode 100644 index 00000000000..793df940408 --- /dev/null +++ b/sql/updates/7549_world_trinity_string.sql @@ -0,0 +1,6 @@ +DELETE FROM `trinity_string` WHERE `entry` in (2017,2022,2023,2024); +INSERT INTO `trinity_string` (`entry`, `content_default`) VALUES +(2017, '|cffaaffaaTicket|r:|cffaaccff %d.|r '), +(2022, '|cff00ff00Ticket Message|r: [%s]|r'), +(2023, '|cff00ff00GM Comment|r: [%s]|r'), +(2024, '|cff00ccff%s|r |cff00ff00Added comment|r: [%s]|r'); diff --git a/sql/world.sql b/sql/world.sql index f4812fa3498..d42dfb2dcc8 100644 --- a/sql/world.sql +++ b/sql/world.sql @@ -14769,14 +14769,14 @@ INSERT INTO `trinity_string` (`entry`,`content_default`,`content_loc1`,`content_ (2014, 'Ticket %d is not assigned, you cannot unassign it.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), (2015, 'You cannot unassign tickets from staffmembers with a higher security level than yourself.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), (2016, 'Cannot close ticket %d, it is assigned to another GM.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), -(2017, '|cff00ff00Ticket|r:|cff00ccff %d.|r ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), +(2017, '|cffaaffaaTicket|r:|cffaaccff %d.|r ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), (2018, '|cff00ff00Created by|r:|cff00ccff %s|r ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), (2019, '|cff00ff00Last change|r:|cff00ccff %s ago|r ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), (2020, '|cff00ff00Assigned to|r:|cff00ccff %s|r ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), (2021, '|cff00ff00Unassigned by|r:|cff00ccff %s|r ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), -(2022, '\n|cff00ff00Message|r: "%s"|r ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), -(2023, '\n|cff00ff00Comment|r: "%s"|r ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), -(2024, '\n|cff00ccff%s|r |cff00ff00Added comment|r: "%s"|r ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), +(2022, '|cff00ff00Ticket Message|r: [%s]|r', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), +(2023, '|cff00ff00GM Comment|r: [%s]|r', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), +(2024, '|cff00ccff%s|r |cff00ff00Added comment|r: [%s]|r', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), (2025, '|cff00ff00Created|r:|cff00ccff %s ago|r ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), (5000, 'You froze player %s.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), (5001, 'It might be amusing but no... you cant freeze yourself!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), -- cgit v1.2.3