<?php
function getCOUNTRY($ip) {
	$ipnum	= sprintf("%u", ip2long($ip));
    $result = mysql_query("SELECT cc FROM geoip_db WHERE start <= ".$ipnum." AND end >= ".$ipnum." LIMIT 1");
        if($result) {
			$row = mysql_fetch_array($result);
			if($row) {
				$cc = $row[cc];
			} else {
				$cc = "no";
			}
		} else {
			$cc = "no";
		}

return $cc;
}

function getCITY($ip) {
	$row = mysql_fetch_array(mysql_query("SELECT `city` FROM `geocity` WHERE `ip_start` <= INET_ATON('".$ip."') ORDER BY `ip_start` DESC LIMIT 1"));
	$city = $row['city'];
return $city;
}

function getCITYcode($ip) {
	$row = mysql_fetch_array(mysql_query("SELECT `region_code` FROM `geocity` WHERE `ip_start` <= INET_ATON('".$ip."') ORDER BY `ip_start` DESC LIMIT 1"));
	$city = $row['region_code'];
return $city;
}

function getCITYnum($city) {
	$row = mysql_fetch_array(mysql_query("SELECT `city` FROM `geocity` WHERE `region_code` = '".$city."' ORDER BY `ip_start` DESC LIMIT 1"));
	$city = $row['city'];
return $city;
}
?>