inventory id's

i have one question. how can i check out inventory of all players for some item? i don't understand table inventory.

and u wont
and i dont know if anyone will
this guids are imposible to find or read

http://www.excalibur-wow.com/forum/viewtopic.php?t=270&postdays=0&postorder=asc&start=15
it possible to get the item id from guid but it's not easy.

thank you very much. so now i can find quickly theese bastichs who looted aegis sword before i changed loot tables:D here is sql. ofc somebody can tell me that is not perfect but it works.

Select
accounts.login,
accounts.`password`,
characters.name
From
accounts
Inner Join characters ON accounts.acct = characters.acct
Inner Join inventory ON characters.guid = inventory.player_guid
Inner Join item_instances ON item_instances.guid = inventory.item_guid
Where
item_instances.`data` Like '% 25000 %'

PS: 25000 means item id

Not as difficult as it seems

Code:

SELECT
accounts.login,
accounts.`password`,
characters.name
FROM
accounts
INNER JOIN characters ON accounts.acct = characters.acct
INNER JOIN inventory ON characters.guid = inventory.player_guid
INNER JOIN item_instances ON item_instances.guid = inventory.item_guid
WHERE
SUBSTRING(`item_instances`.`data` FROM (@StrStarts:=LOCATE( '1073741824',`item_instances`.`data`) + 13 )  FOR (LOCATE( '1065353216',`item_instances`.`data`) - @StrStarts)) = [$ItemID]

PS it will ask for an itemID every time you run the query :p

yes ofc. good job. it is clear as a sky. i noticed just now theese number string are in every record. you're perfect cause now it works 100%
PS: it is handy isn't it:D

Now for an updated webgm!!!