[FilterScript] Country Detector

[MatheuS]

                                                          IP to Country (VCMP)

This can be useful for some people, things like countrybans(lol), language detectors, or just to admin purposes.

Download:
Click Here (MediaFire)

Installation:

Extract the files that are in the IPtoCountry folder in your server's root directory, add

Code Select Expand

function onScriptLoad()
{
   dofile( "IPtoCountry/IPtoCountry.nut" );
    secondarydb <- ConnectSQL( "IpToCountry.db" );
}

Code Select Expand

function onScriptUnload()
{
    DisconnectSQL( secondarydb );
}

Code Select Expand

function onPlayerJoin( player )
{
local country = IpToCountry( player.IP );
        Message( "[#F5FFFA]"+player.Name+" Country: [#06FA16]"+country+"[#F5FFFA]." );
}
Original scripts developed by Nexus
Link:Here

Translated by me for Vice City Multiplayer 0.4 (Some things, almost nothing)

[PsyChO_KiLLeR]

getting error here
db <- ConnectSQL( "IpToCountry.db" );

[jayant]

@MatheuS

Code Select Expand

function onScriptLoad()
{
   dofile( "IPtoCountry/IPtoCountry.nut" );
   secondarydb <- ConnectSQL( "IpToCountry.db" );
   Load_ITC( "IPtoCountry/" ); // Loading the detector
}
From the original topic.. ^^

[.]

getting error here
db <- ConnectSQL( "IpToCountry.db" );

Check that the database file "IpToCountry.db" exists and that it's accessible to the script or at least actually located where the script expects it to be.

Check the permissions on that database file if you're on a Unix system. Even if you're on windows you should still check them but Unix system are more sensitive bout that.

Finally if you still can't get it working then take a screenshot of the console output so that we can see what happens there.

[Thijn]

If you're actually getting an error then that probably means you haven't loaded the SQLite plugin.

[MacTavish]

The screenshot of the console error is needed to provide an proper solution Please Click Me Mr.Squirrel Master

[PsyChO_KiLLeR]

Now help

[.]

You're missing the SQLite database plugin.

[MacTavish]

Check have you loaded all plugins (execpt announce for localhost) in server.cfg

[PsyChO_KiLLeR]

what i have to add in server.cfg file?

[.]

what i have to add in server.cfg file?

Code Select Expand

plugins squirrel04rel32 sqlite04rel32
sqgamemode your_gamemode.nut
Please note that some of the plugin names might vary based on the platform you're on.

[PsyChO_KiLLeR]

i have add them but still error here
secondarydb <- ConnectSQL( "IpToCountry.db" );

[PsyChO_KiLLeR]

work fine now error was in some places there is db and in some places there is secondarydb i change all to db and then work fine
Thnx Slc and beztone

[Drake]

BUMP

I saw that the IP to Country DB is really outdated so I just managed to update it with the latest IPs and thought of sharing it here.
Hope it helps.

Link : IpToCountry
Virus Free : VirusTotal

Edit by Thijn: Replaced the VirusTotal link with an analysis of the actual file instead of mediafire. It's clean.

[Eva]

I get a txt msg in game "Playername Country: Unknown" while my country is in the db....