diff options
| -rw-r--r-- | sql/updates/world/2011_10_07_01_world_command.sql | 3 | ||||
| -rw-r--r-- | sql/updates/world/2011_10_07_02_world_trinity_string.sql | 4 |
2 files changed, 7 insertions, 0 deletions
diff --git a/sql/updates/world/2011_10_07_01_world_command.sql b/sql/updates/world/2011_10_07_01_world_command.sql new file mode 100644 index 00000000000..c3767c7dc00 --- /dev/null +++ b/sql/updates/world/2011_10_07_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 diff --git a/sql/updates/world/2011_10_07_02_world_trinity_string.sql b/sql/updates/world/2011_10_07_02_world_trinity_string.sql new file mode 100644 index 00000000000..2dff16050e4 --- /dev/null +++ b/sql/updates/world/2011_10_07_02_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 |