You are an unregistered user, you can register here



If you wish to make a donation you can by clicking the image below.

BeyondUnreal News

Go Back   The Unreal Admins Page > Forums > Hosted Forums > UTStats > General Chat

Thread Tools Display Modes
Unread 12th June, 2007, 06:27 AM
plutosek plutosek is offline
Killing Spree
Join Date: Jun 2007
Posts: 15

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 ''

Now import: uts_ip2country all 9 file from: Ip2Country.sql
Download and instal:
Go to the Webadmin UTStats and pres: Recalculate Flag images

New Ip2Country is instaled here KLAN KAWA (kW)

Last edited by plutosek : 2nd July, 2007 at 10:58 PM.
Reply With Quote
Unread 14th June, 2007, 09:46 AM
[BSC]MasterJohnny [BSC]MasterJohnny is offline
Holy Shit!!
Join Date: Apr 2005
Location: Hajdúszoboszló, Hungary
Posts: 823

Originally Posted by plutosek View Post
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
Reply With Quote
Unread 7th August, 2007, 09:30 PM
killereye killereye is offline
Join Date: Sep 2006
Posts: 106

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
Reply With Quote
Unread 14th February, 2009, 11:14 AM
killereye killereye is offline
Join Date: Sep 2006
Posts: 106

A prefab .sql for the latest ip2country db (feb 2009) can be d/l'd here: .

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.
Reply With Quote
Unread 25th March, 2009, 04:19 PM
Enakin's Avatar
Enakin Enakin is offline
Join Date: Jan 2009
Location: Ukraine
Posts: 87

Last Countries DB (3 march 2009): - fastest import - slowest import
Page for fixing ALL, not only unset countries players:
PHP Code:

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

$sql_pids mysql_query("SELECT as pid, as country, uts_player.ip as ip FROM uts_pinfo, uts_player WHERE = GROUP BY;") or die(mysql_error());
$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;");
$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());
It's not who I am underneath, but what I do that defines me.
Reply With Quote
Unread 21st February, 2013, 04:33 AM
zavateandu's Avatar
zavateandu zavateandu is offline
Join Date: Nov 2010
Posts: 171

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?
Reply With Quote
Unread 24th February, 2013, 03:26 PM
medor medor is offline
Holy Shit!!
Join Date: Nov 2006
Location: France
Posts: 1,826

ave you
ServerPackages=CountryFlags2 and the utx file come with
Files for UT99 utfiles All new releases and updates are listed here All news
Most popular is UnrealTournament-V3 With over 14000 visits to date.It is an optimized UT99 to download.
Reply With Quote

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

All times are GMT +1. The time now is 09:34 PM.


All pages are copyright The Unreal Admins Page.
You may not copy any pages without our express permission.