Saints Anathema
Old School Doleran
Code:
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
Code:
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
Code:
SELECT * FROM player_items, player_depotitems, tile_items WHERE item_id = 10016
Code:
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?