Auctions?

[thijsd]

Hey,

I want to make a auction house, but than on our homepage. THis is not a problem, but when i read the "auctions" table, the problem comes:

What does the number under "item" mean? F.A.: 4611686018427388108
It is a pair of boots, but how to find this out? (where is it declaired?)



+Rep for helpers



BTW: 100st post =D

[Power of Illuminati]

I think that ID is a special ID for the item, person and alot of information stored in it.

[thijsd]

oki, but now i need to now how to read it :P

[arigity]

think it's the Items GUID. go into your playeritems table and search for an item with a similar id.

[thijsd]

OK, yes it is the GUID, but it isnt in the playeritems table, becouse my autcion is:

4611686018427388108

and my highest number in the playeritem is:

255 So that isnt it :P

--Edit--

This is what the core says:

 CharacterDatabase.Execute("INSERT INTO auctions VALUES(%u, %u, "I64FMTD", %u, %u, %u, %u, %u, %u)",
        Id, AuctionHouseId, pItem->GetGUID(), Owner, BuyoutPrice, ExpiryTime, HighestBidder, HighestBid,
        DepositAmount);

[doublehex]

cant say it any better than spidey has:

That is the item guid.
See, items are like NPCs, they have entries and they have ids.
That's why when you place gems in your item, only your item gets the gems, not all the items of the same id. Same for enchants.

[thijsd]

Yeah ok, But where is stored that item: 4611686018427388108 is BLALBALA?
or how to read 4611686018427388108 ?

I understand 4611686018427388108 is a unique number, SOMEWHERE must be standing witch item it is?! :P