• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Search for someones items REP+

enriel

Big L
Joined
Dec 14, 2007
Messages
1,254
Reaction score
2
Location
Montenegro
Is there a way to search for a certain item and see who owns it? Like money counter, If I can check somehow who has most money etc.
 
Is there a way to search for a certain item and see who owns it? Like money counter, If I can check somehow who has most money etc.

open sql or mysql databate
search or find
put the item id and you will see who haves more money or that certain item.
 
I'm kinda nooby, should i search for player_items, how can I search so it checks depot etc

what kind you use? mysql or sqlite?

i will try to help:
sqlite
open the sqlite database and you will se the tables
player_items -- if you want search the itens that is with the player
player_depotitems-- item in his depot
click in one of those, and search, put in the itemtype the item id and you will se who have that item.

mysql
the tables are the same.
click search and choose one of those tables i said and put in the
"Word(s) or value(s) to search for (wildcard: "%"): item id here "
than click on go
after he will tell the amont of find results
click on browse and you will see who have that item.

i tryed to help..
 
Last edited:
Back
Top Bottom