aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorNyeriah <sarah.trysan@live.com>2014-09-03 17:25:36 -0300
committerNyeriah <sarah.trysan@live.com>2014-09-03 17:25:36 -0300
commit014adaa0fd14a3f316588b0829ceea1960af12d5 (patch)
tree1d03801f1575c03c7406c2b81a9c28c4a748a684 /sql
parentdd4dbdcd16bb72b1b45c7971cb8b9e06030b6e16 (diff)
Core/Tickets: Send global GM system messages on ticket complete
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/2014_09_03_01_world_trinity_string.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/world/2014_09_03_01_world_trinity_string.sql b/sql/updates/world/2014_09_03_01_world_trinity_string.sql
new file mode 100644
index 00000000000..0586c31e3d2
--- /dev/null
+++ b/sql/updates/world/2014_09_03_01_world_trinity_string.sql
@@ -0,0 +1,5 @@
+-- Implements in-game gm message when tickets are completed
+SET @LANG_COMMAND_TICKETCOMPLETED := 2030;
+DELETE FROM `trinity_string` WHERE `entry` = @LANG_COMMAND_TICKETCOMPLETED;
+INSERT INTO `trinity_string` (`entry`, `content_default`) VALUES (@LANG_COMMAND_TICKETCOMPLETED, '|cff00ff00Completed by|r:|cff00ccff %s|r');
+