Incase I want to see if the item for eg.icepick exists on the server and get his charid or accid
In which all tables can the item go?
inventory
cart_inventory
storage
mail
char
what will be sql query?
I turned up with something like this,
but it ain't working :|
SELECT c.char_id,c.account_id,c.name
FROM `char` c,`auction` a,`cart_inventory` ci,`guild_storage` g,`inventory` i,`mail` m,`storage` s
WHERE a.nameid=4035 OR ci.nameid=4035 OR g.nameid=4035 OR i.nameid=4035 OR s.nameid=4035;