aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorclick <none@none>2010-11-14 00:29:34 +0100
committerclick <none@none>2010-11-14 00:29:34 +0100
commitc0536f374abcd64d3e7e5b68fb570edffc2f23df (patch)
treed5fc3f02ed4fed987b59594d03cbae03e96f0e63 /sql
parent9ba52c474bc236406c8f8562c7db3f3316bcfabc (diff)
Core: Allow toggling ticketsystem on/off by config-setting (patch by leak)
Closes issue 4744. --HG-- branch : trunk
Diffstat (limited to 'sql')
-rw-r--r--sql/base/world_database.sql2
-rw-r--r--sql/updates/10431_world_trinity_string.sql4
2 files changed, 6 insertions, 0 deletions
diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql
index 120e47ae6d1..d75ba033309 100644
--- a/sql/base/world_database.sql
+++ b/sql/base/world_database.sql
@@ -27752,6 +27752,8 @@ INSERT INTO `trinity_string` (`entry`,`content_default`,`content_loc1`,`content_
(1331, 'The Frostwolf General is Dead!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1332, 'The Stormpike General is Dead!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1333, 'The Battle for Alterac Valley begins in 2 minutes.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1134, 'Sending tickets is allowed.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(1135, 'Sending tickets is not allowed.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(2000, '|cff00ff00New ticket from|r|cffff00ff %s.|r |cff00ff00Ticket entry:|r|cffff00ff %d.|r', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(2001, '|cff00ff00Character|r|cffff00ff %s |r|cff00ff00edited his/her ticket:|r|cffff00ff %d.|r', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(2002, '|cff00ff00Character|r|cffff00ff %s |r|cff00ff00abandoned ticket entry:|r|cffff00ff %d.|r', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
diff --git a/sql/updates/10431_world_trinity_string.sql b/sql/updates/10431_world_trinity_string.sql
new file mode 100644
index 00000000000..227fb43fd4d
--- /dev/null
+++ b/sql/updates/10431_world_trinity_string.sql
@@ -0,0 +1,4 @@
+DELETE FROM `trinity_string` WHERE `entry` IN (1134, 1135);
+INSERT INTO `trinity_string` (`entry`, `content_default`) VALUES
+(1134, 'Sending tickets is allowed.'),
+(1135, 'Sending tickets is not allowed.');