From 4112a0d087aa14654c487433edb95b5d7fceeb0c Mon Sep 17 00:00:00 2001 From: Bizzy Date: Tue, 4 Oct 2011 17:14:04 +0200 Subject: Core/Commands: Added '.ticket reset' for resetting ticket-id counter. Author: Bizzy --- sql/updates/world/2011_10_04_00_world_trinity_string.sql | 4 ++++ sql/updates/world/2011_10_04_01_world_command.sql | 3 +++ 2 files changed, 7 insertions(+) create mode 100644 sql/updates/world/2011_10_04_00_world_trinity_string.sql create mode 100644 sql/updates/world/2011_10_04_01_world_command.sql (limited to 'sql') diff --git a/sql/updates/world/2011_10_04_00_world_trinity_string.sql b/sql/updates/world/2011_10_04_00_world_trinity_string.sql new file mode 100644 index 00000000000..2dff16050e4 --- /dev/null +++ b/sql/updates/world/2011_10_04_00_world_trinity_string.sql @@ -0,0 +1,4 @@ +DELETE FROM `trinity_string` WHERE `entry` IN(2027,2028); +INSERT INTO `trinity_string` (`entry`, `content_default`) VALUES +('2027', 'There are pending open tickets, please close them first!'), +('2028', 'All closed tickets were deleted and counter is reseted to |cffff00ff 1|r'); \ No newline at end of file diff --git a/sql/updates/world/2011_10_04_01_world_command.sql b/sql/updates/world/2011_10_04_01_world_command.sql new file mode 100644 index 00000000000..c3767c7dc00 --- /dev/null +++ b/sql/updates/world/2011_10_04_01_world_command.sql @@ -0,0 +1,3 @@ +DELETE FROM `command` WHERE `name` = 'ticket reset'; +INSERT INTO `command` (`name`, `security`, `help`) VALUES +('ticket reset', 3, 'Syntax: .ticket reset\nRemoves all closed tickets and resets the counter, if no pending open tickets are existing.'); \ No newline at end of file -- cgit v1.2.3