query please :3

[Z e r o]

query to find all character that has item item im looking for XD cant find the table for the equipped items XD

[Patskie]

SQL :

 

Execute this on your database :

SELECT CONCAT(`char`.`name`, " has item ", `inventory`.`nameid`) "Character Name" FROM `inventory` JOIN
`char` ON `inventory`.`char_id` = `char`.`char_id` WHERE `inventory`.`nameid` = '2301';

Change 2301 to whatever item id you wishes to look for. Note also that this is only for inventory. Storage, auction, mail etc. is a different story.

[Z e r o]

ill try it thanks

by the way im looking for cards i got no result

[Emistry]

something like this ?

http://upaste.me/r/54d5fb

[Patskie]

ill try it thanks

by the way im looking for cards i got no result

Change nameid to card id? If you got no result meaning characters doesn't have those items

 

Here is a screenshot of mine doing the query :

[Emistry]

@Patskie

perhap he refer to the card that compounded into the equipments..

in that case you have to check for these column

card0
card1
card2
card3

or maybe within other location like

storage
guild storage
cart
mail
etc

 

@Zero

be specify ~give more details..

[Schwierig]

@Emistry

But when you are doing that be careful to put everything in one query. Looping through 4 queries for "n"-times will kill your server pretty fast when you got a bigger playerbase