You are an unregistered user, you can register here
Navigation

Information

Site

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


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

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

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)

Last edited by plutosek : 2nd July, 2007 at 10:58 PM.
Reply With Quote
  #22  
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
Default

Quote:
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 http://ip-to-country.webhosting.info
Reply With Quote
  #23  
Unread 7th August, 2007, 09:30 PM
killereye killereye is offline
Dominating
 
Join Date: Sep 2006
Posts: 106
Default

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):

Code:
$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
  #24  
Unread 14th February, 2009, 11:14 AM
killereye killereye is offline
Dominating
 
Join Date: Sep 2006
Posts: 106
Default

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

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());
        }
    }
?>
__________________
It's not who I am underneath, but what I do that defines me.
http://inethub.olvi.net.ua/personal/
Reply With Quote
  #26  
Unread 21st February, 2013, 04:33 AM
zavateandu's Avatar
zavateandu zavateandu is offline
Dominating
 
Join Date: Nov 2010
Posts: 171
Default

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
  #27  
Unread 24th February, 2013, 03:26 PM
medor medor is offline
Holy Shit!!
 
Join Date: Nov 2006
Location: France
Posts: 1,845
Default

ave you
ServerPackages=CountryFlags2 and the utx file come with
__________________
UT99 files






Reply With Quote
Reply


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:39 AM.


 

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