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%'