aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorDrahy <none@none>2009-02-10 23:41:14 +0100
committerDrahy <none@none>2009-02-10 23:41:14 +0100
commite5057ce3b9ec08f09b770b77c6c692bae2601211 (patch)
treee016f44642c9503890fa075c3ff8c6e6821b1bd7
parent846855698f85677380bdd4b467a38ed62b4c0e66 (diff)
* Forgot to add *.sql to some filenames, pardon me
* Added one lost sql file from 2.4.3 folder --HG-- branch : trunk
-rw-r--r--sql/updates/2.4.3_updates/741_world.sql10
-rw-r--r--sql/updates/CMakeLists.txt16
2 files changed, 18 insertions, 8 deletions
diff --git a/sql/updates/2.4.3_updates/741_world.sql b/sql/updates/2.4.3_updates/741_world.sql
new file mode 100644
index 00000000000..a93d4e2bd01
--- /dev/null
+++ b/sql/updates/2.4.3_updates/741_world.sql
@@ -0,0 +1,10 @@
+REPLACE INTO `command` (`name`,`security`,`help`) VALUES ('ticket list','1','Displays a list of open GM tickets.');
+REPLACE INTO `command` (`name`,`security`,`help`) VALUES ('ticket onlinelist','1','Displays a list of open GM tickets whose owner is online.');
+REPLACE INTO `command` (`name`,`security`,`help`) VALUES ('ticket viewname','1','Usage: .ticket viewname $creatorname. \r\nReturns details about specified ticket. Ticket must be open and not deleted.');
+REPLACE INTO `command` (`name`,`security`,`help`) VALUES ('ticket viewid','1','Usage: .ticket viewid $ticketid.\r\nReturns details about specified ticket. Ticket must be open and not deleted.');
+REPLACE INTO `command` (`name`,`security`,`help`) VALUES ('ticket close','2','Usage: .ticket close $ticketid.\r\nCloses the specified ticket. Does not delete permanently.');
+REPLACE INTO `command` (`name`,`security`,`help`) VALUES ('ticket delete','3','Usage: .ticket delete $ticketid.\r\nDeletes the specified ticket permanently. Ticket must be closed first.');
+REPLACE INTO `command` (`name`,`security`,`help`) VALUES ('ticket assign','3','Usage: .ticket assign $ticketid $gmname.\r\nAssigns the specified ticket to the specified Game Master.');
+REPLACE INTO `command` (`name`,`security`,`help`) VALUES ('ticket unassign','3','Usage: .ticket unassign $ticketid.\r\nUnassigns the specified ticket from the current assigned Game Master.');
+REPLACE INTO `command` (`name`,`security`,`help`) VALUES ('ticket comment','2','Usage: .ticket comment $ticketid $comment.\r\nAllows the adding or modifying of a comment to the specified ticket.');
+REPLACE INTO `command` (`name`,`security`,`help`) VALUES ('reload tickets','4','Usage: .reload tickets.\r\nReloads GM Tickets from the database and re-caches them into memory.');
diff --git a/sql/updates/CMakeLists.txt b/sql/updates/CMakeLists.txt
index 6665a9db53b..ab729b11de8 100644
--- a/sql/updates/CMakeLists.txt
+++ b/sql/updates/CMakeLists.txt
@@ -1,7 +1,7 @@
add_subdirectory(2.4.3_updates)
INSTALL(FILES
-805_world_scripts
+805_world_scripts.sql
875_mangos_7047_01_characters_character_spell.sql
875_mangos_7059_01_characters_pet_spell.sql
1026_mangos_7113_01_characters_character_achievement_progress.sql
@@ -22,15 +22,15 @@ INSTALL(FILES
1185_mangos_7214_03_world_spell_proc_event.sql
1206_world_scripts.sql
1207_world_scripts.sql
-1237_mangos_7230_01_world_spell_bonus_data
-1248_mangos_7235_01_world_command
+1237_mangos_7230_01_world_spell_bonus_data.sql
+1248_mangos_7235_01_world_command.sql
1018_world.sql
1026_world.sql
1028_world_scripts.sql
-1288_mangos_7242_01_world_spell_bonus_data
-1293_mangos_7249_01_world_spell_proc_event
-1296_mangos_7252_01_world_command
-1296_mangos_7252_02_world_trinity_string
-1299_mangos_7255_01_characters_characters
+1288_mangos_7242_01_world_spell_bonus_data.sql
+1293_mangos_7249_01_world_spell_proc_event.sql
+1296_mangos_7252_01_world_command.sql
+1296_mangos_7252_02_world_trinity_string.sql
+1299_mangos_7255_01_characters_characters.sql
1307_world.sql
DESTINATION share/trinity/sql/updates) \ No newline at end of file