From 014adaa0fd14a3f316588b0829ceea1960af12d5 Mon Sep 17 00:00:00 2001
From: Nyeriah <sarah.trysan@live.com>
Date: Wed, 3 Sep 2014 17:25:36 -0300
Subject: Core/Tickets: Send global GM system messages on ticket complete

---
 sql/updates/world/2014_09_03_01_world_trinity_string.sql | 5 +++++
 1 file changed, 5 insertions(+)
 create mode 100644 sql/updates/world/2014_09_03_01_world_trinity_string.sql

(limited to 'sql')

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');
+
-- 
cgit v1.2.3