diff options
| author | Shocker <shocker@freakz.ro> | 2011-10-07 09:55:03 -0700 |
|---|---|---|
| committer | Shocker <shocker@freakz.ro> | 2011-10-07 09:55:03 -0700 |
| commit | f130ca8d0a22e284675bd30e2c4c18815bd7d05a (patch) | |
| tree | 496f88f4e4544fb05119382437f4d950722451d8 /sql/updates | |
| parent | a3c46d70237194a08b60440a7ccc18f7e5250d7f (diff) | |
| parent | 4112a0d087aa14654c487433edb95b5d7fceeb0c (diff) | |
Merge pull request #3392 from Bizzy/Bizzy
Core/Commands: Added '.ticket reset' for resetting ticket-id counter. Aut
Diffstat (limited to 'sql/updates')
| -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 |