[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/

[Noredine]

Screenie please

[MinZ|Spark]

Nice one and thx

[Lejo]

Nice release, I suppose. It'll be useful for certain things.

[Brian_Furios]

thx very nice

[Fj0rtizFredde]

Nice I was just looking for something like this

[Calgon]

There are already plugins/includes for this, a trillion. But, nice work anyway.

[not]

doesn't work always say: Country File Not Found!

[Fj0rtizFredde]

Quote:

Originally Posted by not doesn't work always say: Country File Not Found!

Make a folder in your scriptfiles called CountriesIPs and put in the IPLIST file in there

[speedruntrainer]

w00t, that's nice, well done

[not]

Quote:

Originally Posted by Fj0rtizFredde Quote: Originally Posted by not doesn't work always say: Country File Not Found! Make a folder in your scriptfiles called CountriesIPs and put in the IPLIST file in there

=P thx works perfectly!!! ^.^

[smeti]

Quote:

Originally Posted by MinZ|Spark Nice one and thx

Quote:

Originally Posted by Shakur_ Nice release, I suppose. It'll be useful for certain things.

Quote:

Originally Posted by Brian_Furios thx very nice

Quote:

Originally Posted by Fj0rtizFredde Nice I was just looking for something like this

Quote:

Originally Posted by CalgonX There are already plugins/includes for this, a trillion. But, nice work anyway.

Quote:

Originally Posted by speedruntrainer w00t, that's nice, well done

Quote:

Originally Posted by not =P thx works perfectly!!! ^.^

Thank you very much.

[smeti]

Updated the [FS] GetIpCountry
I added MySQL version. (approximately ten times faster thanks to sql data storage) (****** translate)

[Aleluja]

NIce work

[royal_king]

Nice 10/10

[MrDeath537]

I prefer the plugin.

But nice work.

[[L3th4l]]

Great work!

[X35B]

Ill certainly be using this on my server?

[Davz*|*Criss]

well done u did best i was searching for this.

Thnx

[smeti]

Thanks.

Updated mysql verzion script.
Fixed cellmax limit problem and update countrydetected.sql database.