Windows Questions about Items in Databse

[Saints Anathema]

SELECT * FROM player_items WHERE item_id = 10016;

tried running that as a sql query in my phpmyadmin.. 10016 is a winged hat of trickery on my server.

i get this as a error

Error
SQL query:  

SELECT * 
FROM player_items
WHERE item_id =10016
LIMIT 0 , 30 

MySQL said:  

#1054 - Unknown column 'item_id' in 'where clause'

So, i tried the other query i had

SELECT * FROM player_items, player_depotitems, tile_items WHERE item_id = 10016

Error
SQL query:  

SELECT * 
FROM player_items, player_depotitems, tile_items
WHERE item_id =10016
LIMIT 0 , 30 

MySQL said:  

#1054 - Unknown column 'item_id' in 'where clause'

Anyone know why this isnt working? or what command i need to search for specific items in characters/depots/houses?

 

[Guitar Freak]

Are you sure you have the "item_id" column on the database? I might be mistaking it with something else but usually the column is called "itemtype"..

I also used this query to test it:

SELECT * FROM player_items WHERE itemtype = 1988

And it worked, but then I added player_depotitems (player_items, player_depotitems) and it didnt work, I think the query to search in various tables at the same time is another one, but Idk which sorry.

 

[Saints Anathema]

ah figured it out thanks for pointing me in the right direction

rep+

 

[Guitar Freak]

ah figured it out thanks for pointing me in the right direction

rep+

Could you post the working query (for searching on various tables)? Id like to know it aswell

 

[Saints Anathema]

for my situation on my server, i actually only needed to search for a item in either the depot/house/character..

i just switched it to itemtype, for searching one of the 3.

i didnt really go that much further with it after that, i was just finding items that shouldntve have been out on my server.

 

[Sync]

for my situation on my server, i actually only needed to search for a item in either the depot/house/character..

i just switched it to itemtype, for searching one of the 3.

i didnt really go that much further with it after that, i was just finding items that shouldntve have been out on my server.

(Ty chris) xD