diff options
| author | Bizzy <bizzymail67@googlemail.com> | 2011-10-04 17:14:04 +0200 |
|---|---|---|
| committer | Bizzy <bizzymail67@googlemail.com> | 2011-10-04 17:41:55 +0200 |
| commit | 4112a0d087aa14654c487433edb95b5d7fceeb0c (patch) | |
| tree | b2ff46329793366d3a364960b036c5b4c93a5757 /sql | |
| parent | 5db7bf9cc33ee30b5201ab46a2fc788bbad2ab35 (diff) | |
Core/Commands: Added '.ticket reset' for resetting ticket-id counter. Author: Bizzy
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/2011_10_04_00_world_trinity_string.sql | 4 | ||||
| -rw-r--r-- | sql/updates/world/2011_10_04_01_world_command.sql | 3 |
2 files changed, 7 insertions, 0 deletions
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 |