SA-MP Forums Archive
List all the accounts of an IP? - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: List all the accounts of an IP? (/showthread.php?tid=659192)



List all the accounts of an IP? - Score - 26.09.2018

Hello, how you all doing? I hope u doing good..

I was wondering, and i actually am in need of something like this:

Is there any way i can list all accounts from only 2 IP texts, for example:

If i check the ip 192.168

It will show me like this:

Score_Score (IP:192.168.0.100)
Score_Erosc (IP: 192.168.1.100)

So i will only check the IP 192.168 and it will show me all accounts starting with that IP.. I'm using MySQL R40+


Re: List all the accounts of an IP? - sakhary - 26.09.2018

https://www.w3schools.com/sql/sql_like.asp


Re: List all the accounts of an IP? - DAKYSKYE - 02.10.2018

Sorry that I'm not using MySQL. Due to this, I will give you example how to get results, then you have to see mysql r40 wiki on wiki.sa-mp.com and complete my "example".
PHP код:
SELECT FROM Players WHERE ipaddres LIKE '192.168%'