searching an item

[darking123]

i am searching an item to my database... because i want to count or to know the people that has the items..example is item id 2541

i want to know who has it

[Fai T.Flowright]

well, if u re using windows as server side, u can easily search it via mysql work bench

[darking123]

i am using linux sir

[Feefty]

if you're using phpmyadmin you can try running this in your sql query SELECT * FROM `inventory` WHERE `nameid` = 2541

[darking123]

works..but will this SELECT * FROM `inventory` WHERE `nameid` = 2541 will also search the item even if it is equiped or in storage or cart

[AnnieRuru]

select * from inventory where nameid = 2541;
select * from cart_inventory where nameid = 2541;
select * from storage where nameid = 2541;
select * from guild_storage where nameid = 2541;
select * from mail where nameid = 2541;
select * from auction where nameid = 2541;

[Emistry]

try this...

http://pastebin.com/raw.php?i=UkUn1fwT

and...since the sql data are not updated immeadiately...you have to wait sometime to get the correct amount of item...

depend on the value you have set for default server saving time...

else..try create item then relog..and check again

EDIT :

I get the idea wrongly LOL...suppose to show WHO get the item...and not the no of item exist in server.....

[darking123]

about your post sir emistry?/how does it work??will i input the item id??

and does it work in eathena svn?