From a35d4f08a3f9f086eae94dccbfda2ff0c8eb5ae3 Mon Sep 17 00:00:00 2001 From: FrancescoBorzi Date: Mon, 25 Feb 2019 19:24:20 +0100 Subject: Import DB wiki from TC 335 --- docs/item_refund_instance.md | 100 +++++++++++++++++++++++++++++++++++++++---- 1 file changed, 92 insertions(+), 8 deletions(-) (limited to 'docs/item_refund_instance.md') 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** + + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +

Field

Type

Attributes

Key

Null

Default

Extra

Comment

item_guid

int(10)

unsigned

PRI

NO

 

Unique

Item GUID

player_guid

int(10)

unsigned

PRI

NO

 

 

Player GUID

paidMoney

int(10)

unsigned

 

NO

0

 

 

paidExtendedCost

smallint(5)

unsigned

 

NO

0

 

 

+ +**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. -- cgit