[GospodinX]

Hi guys

I'm creating Anti MultiAccount in MySQL.I have big problems with MultiAccounts on my server so I need strong security.

Now I'm make that every connection on my server log in mysql.With information about ip and time login.
Every time when player connect on my server I use this.

Код:

format(eQuery, sizeof(eQuery), "INSERT INTO MULTI(IP, Name,Country,date) VALUES ('%s', '%s' , '%s' ,UNIX_TIMESTAMP())", ip, GetName(playerid),country);
mysql_tquery(g_SQL, eQuery);

Now I don't know how that Admins can see possible multiaccounts so I need:

1) How to get all player IP from MULTI table but without repetition same IP's
2) How to get all connected players but without repetition

For example:

Quote:

A player is login with IP adress 127.0.0.1 B player is also login with 127.0.0.1 IP adress

So A and B player are conncted!They are possible multiaccounts,how to get them(But without repetition of course)


Admins will check this on Admin Panel,not in sa-mp server,so i need just help about mysql query!