Locating database tables?

[ik0uu]

Looking for tables where users furni that they've bought is stored in. e.g if I buy a suitcase, which table in the database stores the fact that I have a suitcase in my hand?

Another table I'm looking for is the table that stores where furniture is located within a specified room, as items_rooms is missing in our database.

In general a breakdown of what the tables are used for and where things are stored would be helpful.

 

[Jerry]

`items` table - it's all there.

 

[Joe]

You can also filter things inside that table, for example you can find out what furniture is in a certain room, if it’s set to 0 then it’s in somebody’s inventory, etc.

 

[Core]

If you run this query it will get them for you
-- REMOVED BY MODERATOR --

P.s. Make sure you back the table up before running it.