Query request / Maybe injection to characters - total money

[kito2]

Hi, I would like to have a query that searchs all money of a player on houses, depot and also on player items and then gives the total value...

If it could be possible, to inject it on searc character on modern?

 

[cbrm]

tile_items table does not store player guid :/

 

[kito2]

But tile_items see the tile id of a house and then at this tile id you can see of wich house id it is.

 

[Cykotitan]

If you're using binary house storage, it's harder

 

[kito2]

Im using a normal storage, where it saves the pos on a table with an ID, and then another table search this ID and creates the items.

PD: Also it should check player balance.