Recalculate Flags After New iptocountry Import?

[plutosek]

Hi all, (my english is sux so sry)

Here you have a new Ip2Country.sql (9 files - 7799 line = all 77025 line)

Create date 12/06/2007 06:30 AM

How to use (phpMyAdmin):

Delete on utstats detabase: uts_ip2country Table
Type this on SQL:

CREATE TABLE IF NOT EXISTS `uts_ip2country` (
`ip_from` int(10) unsigned NOT NULL default '0',
`ip_to` int(10) unsigned NOT NULL default '0',
`country` char(2) NOT NULL default ''
) TYPE=MyISAM;

Now import: uts_ip2country all 9 file from: Ip2Country.sql
Download and instal: utstats=php-flags-admin001.zip
Go to the Webadmin UTStats and pres: Recalculate Flag images

New Ip2Country is instaled here KLAN KAWA (kW)

[[BSC]MasterJohnny]

Originally Posted by plutosek

Here you have a new Ip2Country.sql (9 files - 7799 line = all 77025 line)

Create date 12/06/2007 06:30 AM

Your sql file contains the same data as the latest IP-to-Country Database (Last updated on March 05 2007) at http://ip-to-country.webhosting.info

[killereye]

gj for the updater script!

I downloaded the csv file from that IP-to-Country Database (Last updated on July 30 2007) and just imported it in a emptied copy of the ip2country table. I ran this updater to make the countries all lower case (not sure if it makes a difference tho):

$flag_result = mysql_query("SELECT DISTINCT(country) FROM uts_ip2country");
while($flag_db = mysql_fetch_array($flag_result)) {
	$country = $flag_db['country'];
	$country_fixed = strtolower($country);
    mysql_query("UPDATE uts_ip2country SET country = '$country_fixed' WHERE country = '$country'");
    echo $country." to ".$country_fixed."<br>";
}

gonna work on the player merger thing soon btw, finally got vacation

[killereye]

A prefab .sql for the latest ip2country db (feb 2009) can be d/l'd here: http://cwlserver.net/redirect.php?id=186 .

I ran the script for every player on my relativly small database for my clan's utstats, because for example players from norway got recognized as .pt players. Simply remove the "country = 'xx' AND" part from the query to do this, altho this will probably give problems on large installs.

[Enakin]

Last Countries DB (3 march 2009):
http://rapidshare.de/files/46250716/DBUtStats.rar.html - fastest import
http://rapidshare.de/files/46251668/...untry.rar.html - slowest import
Page for fixing ALL, not only unset countries players:
http://rapidshare.de/files/46254564/fix.rar.html
source:

PHP Code:

<?

include ("includes/config.php");
include ("includes/functions.php");

    $sql_pids = mysql_query("SELECT uts_pinfo.id as pid, uts_pinfo.country as country, uts_player.ip as ip FROM uts_pinfo, uts_player WHERE uts_pinfo.id = uts_player.pid GROUP BY uts_player.pid;") or die(mysql_error());
    while($sql_pid = mysql_fetch_array($sql_pids)) {
        // Map the IP to a country
        $q_playercountry = small_query("SELECT country FROM uts_ip2country WHERE ".$sql_pid['ip']." BETWEEN ip_from AND ip_to;");
        IF($q_playercountry) {
            $playercountry = strtolower($q_playercountry[country]);
        } else {
            $playercountry = "xx";
        }
    
        if ($playercountry != $sql_pid['country'] ) {
            mysql_query("UPDATE uts_pinfo SET country = '$playercountry' WHERE id = '".$sql_pid['pid']."'") or die(mysql_error());
        }
    }
?>

[zavateandu]

hi folks
i install recently for a friend of mine utstats and nexgen stats viewer for his server and i saw that all flags for countries are shown corect on utstats website but in game on nexgen stats viewer are missing and is a empty place on their names.

does anyone know where could be the problem?

[medor]

ave you
ServerPackages=CountryFlags2 and the utx file come with