How does "Playeritems" work?

[thijsd]

Hey there,

Can someone explain me how the table "playeritems" work? I need to find out witch item a player has in his bags, bank and what he wears. but i cant find out how it works.


Someone?

[Lauren]

If you want to know what a Player has in his/hers bag.
Just use .showitems

[thijsd]

Its not that simple :P I am making an application, so a command wont work :P

anyone?
(Filler)

[mager1794]

if you dont know the way the database works itself i advise you dont write the program for it

[metehan]

Ill tell you what the columns mean
Ownerguid- the ID referring to a character every character has one GUID, its kind of like an items ID.
Guid- This is like the ID of the item FOR that SPECIFIC character, it usually goes up by 1 it is used to sort the items out.
Entry- this is the item id
WrapperitemID- the id of the item if it is wrapped in wrapping paper
Wrappedcreator - the person who rapped the item
creator- if its a crafted item the person who created it
count- how many
charges- how many uses left on it
flags- I do not know
randomprop - i do not know
Randomsuffix - of the whale of the monkey ect ect
itemtext- of its a mail letter or something
durability - how much durability left
container slot - if its a bag what slot its in
slot - what bag slot the item is in
enchantments - the ids of the enchants it has on it

[thijsd]

Ill tell you what the columns mean
Ownerguid- the ID referring to a character every character has one GUID, its kind of like an items ID.
Guid- This is like the ID of the item FOR that SPECIFIC character, it usually goes up by 1 it is used to sort the items out.
Entry- this is the item id
WrapperitemID- the id of the item if it is wrapped in wrapping paper
Wrappedcreator - the person who rapped the item
creator- if its a crafted item the person who created it
count- how many
charges- how many uses left on it
flags- I do not know
randomprop - i do not know
Randomsuffix - of the whale of the monkey ect ect
itemtext- of its a mail letter or something
durability - how much durability left
container slot - if its a bag what slot its in
slot - what bag slot the item is in
enchantments - the ids of the enchants it has on it

Hmm,, thnx for the info, but not totaly true:
I checked this with my borther, i made a screen of what he had.
Then there where some weird things:

slot Means all slots, so bags, equiped, and bank.
container slot Is also weird, when i use '19' I get his second bag, but when i use '-1' I get all his other bags, and his equipement. So thats little bit weird.

if you dont know the way the database works itself i advise you dont write the program for it

How can u say i dont understand the database? :P
I know how it works, but i can hapen i don't know something? im just a human