diff options
| author | root <root@wow.freakz.ro> | 2011-10-07 20:08:22 +0300 |
|---|---|---|
| committer | root <root@wow.freakz.ro> | 2011-10-07 20:08:22 +0300 |
| commit | c89b1f6989ce1f5a48c48766993c3dd8101cc21b (patch) | |
| tree | cc9b40e22720f1708eeb0e265918dee4078adbba | |
| parent | 8a0e7537b5ab127e49aa88db12c8a417b5bdfb6f (diff) | |
Core/Misc: Add the SQLs for ticket reset
| -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 |