diff options
| author | Machiavelli <none@none> | 2010-03-18 17:27:40 +0100 |
|---|---|---|
| committer | Machiavelli <none@none> | 2010-03-18 17:27:40 +0100 |
| commit | 302af79bc250257c61f78e489986eaa1f20292c7 (patch) | |
| tree | 08fc629bab8c01e088d097b0f7e93a83c1269515 /sql | |
| parent | 72833e158440dc8f411a75a386861f936bfe108b (diff) | |
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
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/7604_characters_item_refund_instance.sql | 19 |
1 files changed, 19 insertions, 0 deletions
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 |