diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/725_characters.sql | 3 | ||||
| -rw-r--r-- | sql/updates/739_characters.sql | 1 | ||||
| -rw-r--r-- | sql/updates/741_characters.sql | 4 | ||||
| -rw-r--r-- | sql/updates/741_world.sql | 10 | ||||
| -rw-r--r-- | sql/updates/747_world.sql | 1 | ||||
| -rw-r--r-- | sql/updates/748_world_scripts.sql | 3 |
6 files changed, 20 insertions, 2 deletions
diff --git a/sql/updates/725_characters.sql b/sql/updates/725_characters.sql index c875bf9399c..17a87769b12 100644 --- a/sql/updates/725_characters.sql +++ b/sql/updates/725_characters.sql @@ -2,5 +2,4 @@ ALTER TABLE `character_ticket` RENAME TO `gm_tickets`; ALTER TABLE gm_tickets CHANGE `guid` `playerGuid` int(11) unsigned NOT NULL default '0'; ALTER TABLE gm_tickets CHANGE `ticket_id` `guid` int(11) unsigned NOT NULL default '0'; ALTER TABLE gm_tickets CHANGE `ticket_text` `message` text(0) NOT NULL; -ALTER TABLE gm_tickets CHANGE `ticket_lastchange` `timestamp` int(10) NOT NULL default '0'; -ALTER TABLE gm_tickets ADD( `closed` bit(1) NOT NULL, `assignedto` int(10) NOT NULL default '0', `comment` text(0) NOT NULL default '');
\ No newline at end of file +ALTER TABLE gm_tickets CHANGE `ticket_lastchange` `timestamp` int(10) NOT NULL default '0';
\ No newline at end of file diff --git a/sql/updates/739_characters.sql b/sql/updates/739_characters.sql new file mode 100644 index 00000000000..3cbcca9837b --- /dev/null +++ b/sql/updates/739_characters.sql @@ -0,0 +1 @@ +ALTER TABLE gm_tickets ADD `comment` text(0) NOT NULL;
\ No newline at end of file diff --git a/sql/updates/741_characters.sql b/sql/updates/741_characters.sql new file mode 100644 index 00000000000..aeba6f8c9ac --- /dev/null +++ b/sql/updates/741_characters.sql @@ -0,0 +1,4 @@ +ALTER TABLE `gm_tickets` CHANGE `closed` `closed` tinyint(1) NOT NULL default '0'; +ALTER TABLE `gm_tickets` ADD `closed` bit(1) NOT NULL AFTER `timestamp`; +ALTER TABLE `gm_tickets` ADD `assignedto` int(10) NOT NULL default '0' AFTER `timestamp`; + diff --git a/sql/updates/741_world.sql b/sql/updates/741_world.sql new file mode 100644 index 00000000000..a93d4e2bd01 --- /dev/null +++ b/sql/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/747_world.sql b/sql/updates/747_world.sql new file mode 100644 index 00000000000..b526781b141 --- /dev/null +++ b/sql/updates/747_world.sql @@ -0,0 +1 @@ +UPDATE `trinity_string` SET `content_default`='Ticket %d is already assigned.' WHERE (`entry`='2008');
\ No newline at end of file diff --git a/sql/updates/748_world_scripts.sql b/sql/updates/748_world_scripts.sql new file mode 100644 index 00000000000..484c71f3199 --- /dev/null +++ b/sql/updates/748_world_scripts.sql @@ -0,0 +1,3 @@ +update creature_template set scriptname='npc_infused_crystal', flags_extra=0 where entry=16364; +update quest_template set specialflags=2, reqcreatureorgoid1=1, reqcreatureorgocount1=1 where entry=8490; +delete from creature where id=17086;
\ No newline at end of file |