session_start();
ob_start();
include "config.php";
include "header.php";
if (isset($_GET['limit'])) $limit = intval($_GET['limit']);
else $limit = 10;
$statnum = $_GET['statnum'] ? intval($_GET['statnum']) : 1;
echo "
";
// if ($_SESSION['admin_login'] != "Admin" || $_SESSION['admin_password'] != "zandagoyevic") exit;
if(empty($_GET['ip']))
{
$i=1;
$stats_q = mysql_query("SELECT `ip` FROM `stats_".$statnum."` WHERE `op`='' AND `ip` NOT LIKE '%:%' AND `ip` NOT LIKE '10.%' AND `ip`!='unknown' ORDER BY RAND() LIMIT ".$limit );
while($stats_a = mysql_fetch_array($stats_q))
{
$ipm = explode(".",$stats_a['ip']);
$ip1 = $ipm[0].".".$ipm[1].".".$ipm[2];
if($ipm[0] != 10 && mysql_num_rows(mysql_query("SELECT `id` FROM `country` WHERE `ip`='".$ip1."' "))==0)
{
$xml = simplexml_load_file('http://ip-api.com/xml/'.$stats_a['ip']);
$cc = $xml->countryCode;
$cn = $xml->country;
$op = $xml->isp;
$cn = str_replace("'","",$cn);
$op = str_replace("'","",$op);
$insert= mysql_query("INSERT INTO `country` (`ip`,`country_code`,`country_name`,`op`)
VALUES (
'".$ip1."',
'".$cc."',
'".$cn."',
'".$op."'
)");
$update = mysql_query("UPDATE `stats_".$statnum."` SET `country_code`='".$cc."', `country_name`='".$cn."', `op`='".$op."' WHERE `ip` LIKE '".$ip1."%' ");
if (!is_file("country_icon/".$cc.".png"))
{
copy("http://ip2country.sourceforge.net/flags/".strtolower($cc).".png","country_icon/".$cc.".png");
}
print $i.') '.$stats_a['ip']." - (".$cc." -
".$cn." - ".$op.")
";
$i++;
}
// else
// {
// print $i.') '.$stats_a['ip']." - Bazada var
";
// }
usleep(300000);
}
}
else
{
$ip = $_GET['ip'];
$back = mysql_real_escape_string($_GET['back']);
$ipm = explode(".",$ip);
$ip1 = $ipm[0].".".$ipm[1].".".$ipm[2];
if(mysql_num_rows(mysql_query("SELECT `id` FROM `country` WHERE `ip`='".$ip1."' "))==0)
{
$xml = simplexml_load_file('http://ip-api.com/xml/'.$ip);
$cc = $xml->countryCode;
$cn = $xml->country;
$op = $xml->isp;
$insert= mysql_query("INSERT INTO `country` (`ip`,`country_code`,`country_name`,`op`)
VALUES (
'".$ip1."',
'".$cc."',
'".$cn."',
'".$op."'
)");
$update = mysql_query("UPDATE `stats_".$statnum."` SET `country_code`='".$cc."', `country_name`='".$cn."', `op`='".$op."' WHERE `ip` LIKE '".$ip1."%' ");
if (!is_file("country_icon/".$cc.".png"))
{
copy("http://ip2country.sourceforge.net/flags/".strtolower($cc).".png","country_icon/".$cc.".png");
}
}
header("location: ".$back);
}
include "footer.php";
?>