diff options
| author | FrancescoBorzi <borzifrancesco@gmail.com> | 2019-02-25 19:24:20 +0100 |
|---|---|---|
| committer | FrancescoBorzi <borzifrancesco@gmail.com> | 2019-02-25 19:24:20 +0100 |
| commit | a35d4f08a3f9f086eae94dccbfda2ff0c8eb5ae3 (patch) | |
| tree | 91e0cde00f6f27b730b0df3f4338fcf99fa8447a /docs/item_refund_instance.md | |
| parent | d8d1823802ded97300fa57405d80b16736603489 (diff) | |
| download | wiki-a35d4f08a3f9f086eae94dccbfda2ff0c8eb5ae3.tar.gz wiki-a35d4f08a3f9f086eae94dccbfda2ff0c8eb5ae3.tar.bz2 wiki-a35d4f08a3f9f086eae94dccbfda2ff0c8eb5ae3.zip | |
Import DB wiki from TC 335
Diffstat (limited to 'docs/item_refund_instance.md')
| -rw-r--r-- | docs/item_refund_instance.md | 100 |
1 files changed, 92 insertions, 8 deletions
diff --git a/docs/item_refund_instance.md b/docs/item_refund_instance.md index 22ff069..566cd46 100644 --- a/docs/item_refund_instance.md +++ b/docs/item_refund_instance.md @@ -1,8 +1,92 @@ -[Database Structure](Database-Structure) > [Character-Database](Character-Database) > [item_refund_instance](item_refund_instance) - -Column | Type | Description ---- | --- | --- -Item_guid | int(10) unsigned | -Player_guid | int(10) unsigned | -PaidMoney | int(10) unsigned | -PaidExtendedCost | smallint(5) unsigned | +# item\_refund\_instance + +`Back-to:Characters` + +**The \`item\_refund\_instance\` table** + +This table serves as a receipt of refundable purchases during a 2 hour ingame time window. It holds information on what currency was spent to purchase the item. + +**Structure** + +<table> +<colgroup> +<col width="12%" /> +<col width="12%" /> +<col width="12%" /> +<col width="12%" /> +<col width="12%" /> +<col width="12%" /> +<col width="12%" /> +<col width="12%" /> +</colgroup> +<tbody> +<tr class="odd"> +<td><p><strong>Field</strong></p></td> +<td><p><strong>Type</strong></p></td> +<td><p><strong>Attributes</strong></p></td> +<td><p><strong>Key</strong></p></td> +<td><p><strong>Null</strong></p></td> +<td><p><strong>Default</strong></p></td> +<td><p><strong>Extra</strong></p></td> +<td><p><strong>Comment</strong></p></td> +</tr> +<tr class="even"> +<td><p><a href="#item_refund_instance-item_guid">item_guid</a></p></td> +<td><p>int(10)</p></td> +<td><p>unsigned</p></td> +<td><p>PRI</p></td> +<td><p>NO</p></td> +<td><p> </p></td> +<td><p>Unique</p></td> +<td><p>Item GUID</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#item_refund_instance-player_guid">player_guid</a></p></td> +<td><p>int(10)</p></td> +<td><p>unsigned</p></td> +<td><p>PRI</p></td> +<td><p>NO</p></td> +<td><p> </p></td> +<td><p> </p></td> +<td><p>Player GUID</p></td> +</tr> +<tr class="even"> +<td><p><a href="#item_refund_instance-paidMoney">paidMoney</a></p></td> +<td><p>int(10)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +<td><p> </p></td> +</tr> +<tr class="odd"> +<td><p><a href="#item_refund_instance-paidExtendedCost">paidExtendedCost</a></p></td> +<td><p>smallint(5)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +<td><p> </p></td> +</tr> +</tbody> +</table> + +**Description of the fields** + +### item\_guid + +The GUID of the item bought by the vendor. See item\_instance.guid. + +### player\_guid + +The GUID of the player eligible for the refund. See characters.guid. + +### paidMoney + +The amount of money (in copper) paid for the item. + +### paidExtendedCost + +The ItemExtendedCost.dbc ID that was paid for the item. |