From 302af79bc250257c61f78e489986eaa1f20292c7 Mon Sep 17 00:00:00 2001 From: Machiavelli Date: Thu, 18 Mar 2010 17:27:40 +0100 Subject: Implement vendor item refund system. For info about this system, see: hxxp://us.blizzard.com/support/article.xml?locale=en_US&articleId=27351 Thanks to: - Opterman, Malcrom, Xanadu + anonymous colleagues for aiding research on packet structure - Aokromes and Svannon for testing --HG-- branch : trunk --- sql/updates/7604_characters_item_refund_instance.sql | 19 +++++++++++++++++++ 1 file changed, 19 insertions(+) create mode 100644 sql/updates/7604_characters_item_refund_instance.sql (limited to 'sql') diff --git a/sql/updates/7604_characters_item_refund_instance.sql b/sql/updates/7604_characters_item_refund_instance.sql new file mode 100644 index 00000000000..de7ce6d69a5 --- /dev/null +++ b/sql/updates/7604_characters_item_refund_instance.sql @@ -0,0 +1,19 @@ +DROP TABLE IF EXISTS `item_refund_instance`; +CREATE TABLE `item_refund_instance` ( +`item_guid` int(11) unsigned NOT NULL COMMENT 'Item GUID', +`player_guid` int(11) unsigned NOT NULL COMMENT 'Player GUID', +`paidMoney` int(11) unsigned NOT NULL DEFAULT '0', +`paidHonor` int(11) unsigned NOT NULL DEFAULT '0', +`paidArena` int(11) unsigned NOT NULL DEFAULT '0', +`paidItem_1` mediumint(6) unsigned NOT NULL DEFAULT '0' COMMENT 'item_template.entry', +`paidItemCount_1` mediumint(6) unsigned NOT NULL DEFAULT '0', +`paidItem_2` mediumint(6) unsigned NOT NULL DEFAULT '0', +`paidItemCount_2` mediumint(6) unsigned NOT NULL DEFAULT '0', +`paidItem_3` mediumint(6) unsigned NOT NULL DEFAULT '0', +`paidItemCount_3` mediumint(6) unsigned NOT NULL DEFAULT '0', +`paidItem_4` mediumint(6) unsigned NOT NULL DEFAULT '0', +`paidItemCount_4` mediumint(6) unsigned NOT NULL DEFAULT '0', +`paidItem_5` mediumint(6) unsigned NOT NULL DEFAULT '0', +`paidItemCount_5` mediumint(6) unsigned NOT NULL DEFAULT '0', +PRIMARY KEY (`item_guid`, `player_guid`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 -- cgit v1.2.3