[smeti]

GeoIp Country filterscript. Joined message:


Example mysql verzion:

pawn Код:

public 
    OnPlayerConnect(playerid)
{
    new
        string[144],
        IP[16];
    GetPlayerIp(playerid, IP, sizeof IP);
    GetPlayerName(playerid, string, 24);
    format(string, sizeof string, "*** %s has joined the server | Country: %s |", string, GetIpCountry_mysql(IP));
    SendClientMessageToAll(0xC00000FF, string);
    return 1;
}

Credits:

• Base Script - Abhinav
• Database - software77.net
• sscanf and sscanf2 - ******
• Msyql plugin - G-sTyLeZzZ

Time test SQLite verzion:

Код:

[19:13:35]   Loading filter script 'IpToCountry.db.amx'...
[19:13:35] °°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°
[19:13:35] 	IpToCountry_db by Phento
[19:13:35] °°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°°
[19:13:35] Time test | random ip: 92.237.111.236 | COUNTRY: United Kingdom
[19:13:35] Time: 20ms
[19:13:35] Time test | random ip: 100.133.235.249 | COUNTRY: Unknown
[19:13:35] Time: 101ms
[19:13:35] Time test | random ip: 149.190.35.91 | COUNTRY: European Union
[19:13:35] Time: 30ms
[19:13:35] Time test | random ip: 42.13.26.61 | COUNTRY: Korea Republic of
[19:13:35] Time: 7ms
[19:13:35] Time test | random ip: 28.47.77.75 | COUNTRY: United States
[19:13:35] Time: 4ms
[19:13:35] Time test | random ip: 74.94.102.93 | COUNTRY: United States
[19:13:35] Time: 27ms
[19:13:35] Time test | random ip: 242.188.7.163 | COUNTRY: Reserved
[19:13:35] Time: 97ms
[19:13:35] Time test | random ip: 39.239.152.142 | COUNTRY: Unknown
[19:13:35] Time: 89ms
[19:13:35] Time test | random ip: 14.156.24.48 | COUNTRY: China
[19:13:35] Time: 4ms
[19:13:35] Time test | random ip: 115.20.122.117 | COUNTRY: Korea Republic of
[19:13:35] Time: 58ms

Download:


Mysql verzion:
http://www.solidfiles.com/d/a7ce/
SQLite verzion:
http://solidfiles.com/d/9069/