From 08205afcc94045c8d74ee4283821db68c5333b1d Mon Sep 17 00:00:00 2001 From: silinoron Date: Sun, 29 Aug 2010 20:28:14 -0700 Subject: 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 --- sql/updates/9668_characters_gm_subsurveys.sql | 8 ++++++++ sql/updates/9668_characters_gm_surveys.sql | 9 +++++++++ sql/updates/9668_characters_gm_tickets.sql | 3 +++ sql/updates/9668_characters_lag_reports.sql | 11 +++++++++++ 4 files changed, 31 insertions(+) create mode 100644 sql/updates/9668_characters_gm_subsurveys.sql create mode 100644 sql/updates/9668_characters_gm_surveys.sql create mode 100644 sql/updates/9668_characters_gm_tickets.sql create mode 100644 sql/updates/9668_characters_lag_reports.sql (limited to 'sql/updates') 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'; -- cgit v1.2.3