diff options
| author | silinoron <none@none> | 2010-08-29 20:28:14 -0700 |
|---|---|---|
| committer | silinoron <none@none> | 2010-08-29 20:28:14 -0700 |
| commit | 08205afcc94045c8d74ee4283821db68c5333b1d (patch) | |
| tree | 2d3eff04fe18a1985d08708ed1d79d0a119c4cc6 /sql/updates | |
| parent | 1f9936399c6fbd2fe723f1d2e9ceacf463a24f52 (diff) | |
Rewrite much of the GM ticket system
* Extract storage and manipulation of tickets to TicketMgr (from ObjectMgr)
* Extract ticket commands to TicketCommands.cpp
* Adds support for sending GM responses and GM surveys.
* Fix structure of several ticket-related packets.
* Add support for understanding lag reports.
* Thanks Zor for some of the packet structures, and Cyrax for some sniffs
* Please report any issues encountered via the tracker.
--HG--
branch : trunk
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/9668_characters_gm_subsurveys.sql | 8 | ||||
| -rw-r--r-- | sql/updates/9668_characters_gm_surveys.sql | 9 | ||||
| -rw-r--r-- | sql/updates/9668_characters_gm_tickets.sql | 3 | ||||
| -rw-r--r-- | sql/updates/9668_characters_lag_reports.sql | 11 |
4 files changed, 31 insertions, 0 deletions
diff --git a/sql/updates/9668_characters_gm_subsurveys.sql b/sql/updates/9668_characters_gm_subsurveys.sql new file mode 100644 index 00000000000..4dae1442a3d --- /dev/null +++ b/sql/updates/9668_characters_gm_subsurveys.sql @@ -0,0 +1,8 @@ +DROP TABLE IF EXISTS `gm_subsurveys`; +CREATE TABLE `gm_subsurveys` ( + `surveyid` int(10) NOT NULL auto_increment, + `subsurveyid` int(11) UNSIGNED NOT NULL DEFAULT '0', + `rank` int(11) UNSIGNED NOT NULL DEFAULT '0', + `comment` longtext NOT NULL DEFAULT '', + PRIMARY KEY (`surveyid`,`subsurveyid`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System'; diff --git a/sql/updates/9668_characters_gm_surveys.sql b/sql/updates/9668_characters_gm_surveys.sql new file mode 100644 index 00000000000..4f7aa5a6c91 --- /dev/null +++ b/sql/updates/9668_characters_gm_surveys.sql @@ -0,0 +1,9 @@ +DROP TABLE IF EXISTS `gm_surveys`; +CREATE TABLE `gm_surveys` ( + `surveyid` int(10) NOT NULL auto_increment, + `player` int(11) UNSIGNED NOT NULL DEFAULT '0', + `mainSurvey` int(11) UNSIGNED NOT NULL DEFAULT '0', + `overall_comment` longtext NOT NULL DEFAULT '', + `timestamp` int(11) NOT NULL DEFAULT '0', + PRIMARY KEY (`surveyid`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System'; diff --git a/sql/updates/9668_characters_gm_tickets.sql b/sql/updates/9668_characters_gm_tickets.sql new file mode 100644 index 00000000000..71f13206f72 --- /dev/null +++ b/sql/updates/9668_characters_gm_tickets.sql @@ -0,0 +1,3 @@ +ALTER TABLE `gm_tickets` ADD COLUMN `completed` int(11) NOT NULL DEFAULT '0' AFTER `comment`; +ALTER TABLE `gm_tickets` ADD COLUMN `escalated` int(11) NOT NULL DEFAULT '0' AFTER `completed`; +ALTER TABLE `gm_tickets` ADD COLUMN `viewed` int(11) NOT NULL DEFAULT '0' AFTER `escalated`; diff --git a/sql/updates/9668_characters_lag_reports.sql b/sql/updates/9668_characters_lag_reports.sql new file mode 100644 index 00000000000..956bccba8f3 --- /dev/null +++ b/sql/updates/9668_characters_lag_reports.sql @@ -0,0 +1,11 @@ +DROP TABLE IF EXISTS `lag_reports`; +CREATE TABLE `lag_reports` ( + `report_id` int(10) NOT NULL auto_increment, + `player` int(11) UNSIGNED NOT NULL DEFAULT '0', + `lag_type` int(10) NOT NULL DEFAULT '0', + `map` int(11) NOT NULL DEFAULT '0', + `posX` float NOT NULL default '0', + `posY` float NOT NULL default '0', + `posZ` float NOT NULL default '0', + PRIMARY KEY (`report_id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System'; |