//Test in seperat db connection requires php > 4.3.0!
/*
require("config.php");
define("CLIENT_LOCAL_FILES", "128");
$connection = mysql_connect($dbhost, $dbuname, $dbpass, '', 'CLIENT_LOCAL_FILES') or die("Can't connect to $dbname" . mysql_error());
$fix = mysql_query("SET GLOBAL local_infile=1") or die (mysql_error());
@mysql_select_db($dbname);
$result = mysql_query('LOAD DATA LOCAL INFILE \'' . $original . '\' REPLACE INTO TABLE nuke_blocked_iptoc FIELDS TERMINATED BY \',\' ENCLOSED BY \'"\' LINES TERMINATED BY \'\\r\\n\'');
*/
Logged In: YES
user_id=2178441
Originator: YES
Here the new Code for the File pro_iptoc.php:
<?php
global $admin_file, $use_ftp;
if (!stristr($_SERVER['SCRIPT_NAME'], "".$admin_file.".php")) {
die ("You can't access this file directly...");
}
if (IS_GOD == 'God') {
global $admin, $prefix, $aid, $db, $admin_file;
$result = $db -> sql_query("SELECT count(*) FROM ".$prefix."_blocked_iptoc");
list($c_now) = $db -> sql_fetchrow($result);
OpenTable();
echo "<p>";
echo "<center><strong>"._PS_IP2C_MANAGMENT."</strong> <a href=\"javascript:void(0)\"ONCLICK=\"open('".$admin_file.".php?op=PS_Info&info_value=6','miniwin','toolbar=0,location=0,directories=0,status=0,menubar=0,scrollbars=1,resizable=0,width=400,height=300')\"><img src=images/blocked/".$img_color."/ano.gif border=0></a>";
echo "<p>"._PS_IP2C_COVER." ".$c_now." "._PS_IP2C_CTABLES."<p>";
$file = 'http://ip-to-country.webhosting.info/node/view/6';
echo ""._PS_IP2C_NOTE." <br />";
echo "<a href=".$file." target=_blank>ip-to-country.webhosting</a><br />";
$handle = fopen("$file", "r");
while (!feof($handle)) {
$buffer = fgets($handle, 4096);
if(eregi(""._PS_IP2C_LASTUPDATE." ",$buffer)) {
echo "<strong>"._PS_IP2C_DATE_IP2C.": $buffer</strong>";
}
}
fclose($handle);
echo "<p>"._PS_IP2C_NOTE_UPLOAD."<p><form><div align=\"center\">"
. "<input type=\"button\" value=\""._PS_IP2C_UPLOAD."\" onClick="
. "\"open('".$admin_file.".php?op=pro_upload','miniwin','toolbar=0,"
. "location=0,directories=0,status=0,menubar=0,screenX=200,scrollbars=1,"
. "resizable=0,width=400,height=300')\"></form></div>"
. "<form action=\"".$admin_file.".php?op=Fusion&page_value=pro_iptoc\" method=\"post\">"
. "<br />"._PS_IP2C_NOTE_FTP." \""._PS_IP2C_USE_FTP."\"<br />"
. "<input type=hidden name=\"use_ftp\" value=\"1\">"
. "<p><p><input type=\"submit\" value=\""._PS_IP2C_USE_FTP."\"></form>";
if($use_ftp == 1) {
OpenTable();
echo "<center><strong>"._PS_IP2C_INFO."</strong><p>";
$uploaddir = $_SERVER['DOCUMENT_ROOT']."/includes/ps_upload/";
$csvfile = $uploaddir . "ip-to-country.csv";
if(!file_exists($csvfile)) {
echo "<p><strong>"._PS_IP2C_ERROR_NO_FILE."<br><strong><p>";
} else {
//HERE WE READ THE DATA AND INSERT IT!
//Test in seperat db connection requires php > 4.3.0!
/*
require("config.php");
define("CLIENT_LOCAL_FILES", "128");
$connection = mysql_connect($dbhost, $dbuname, $dbpass, '', 'CLIENT_LOCAL_FILES') or die("Can't connect to $dbname" . mysql_error());
$fix = mysql_query("SET GLOBAL local_infile=1") or die (mysql_error());
@mysql_select_db($dbname);
$result = mysql_query('LOAD DATA LOCAL INFILE \'' . $original . '\' REPLACE INTO TABLE nuke_blocked_iptoc FIELDS TERMINATED BY \',\' ENCLOSED BY \'"\' LINES TERMINATED BY \'\\r\\n\'');
*/
//Test in nuke db connection!
echo "<P>"._PS_IP2C_TABLE_REMOVE." ".$prefix."_blocked_iptoc! <p>";
$db->sql_query( "TRUNCATE TABLE ".$prefix."_blocked_iptoc" );
$sql = 'LOAD DATA LOCAL INFILE \'' . $csvfile . '\' INTO TABLE ' . $prefix . '_blocked_iptoc FIELDS TERMINATED BY \',\' ENCLOSED BY \'"\' LINES TERMINATED BY \'\\r\\n\'';
$result = $db -> sql_query($sql);
if($result) {
$result = $db -> sql_query("SELECT count(*) FROM ".$prefix."_blocked_iptoc");
list($c_after) = $db -> sql_fetchrow($result);
//$inserted = $c_after - $c_now;
echo ""._PS_IP2C_TABLE." ".$prefix."_blocked_iptoc "._PS_IP2C_SUCCESS." ".$c_after." "._PS_IP2C_DATA_INSERT."";
} else {
echo ""._PS_IP2C_ERROR_UPDATE." " . mysql_error();
$choice = 0;
echo "<br />"._PS_IP2C_ALTERNATIV."";
}
if($choice == 0) {
echo "<p>"._PS_IP2C_GRABBING."<p>";
$handle = fopen("$csvfile", "r");
$i = 0;
set_time_limit ( 900 ) ;
$time_start = time();
while ($data = fgetcsv($handle, 4096, ",")) {
$i++;
$num = count($data);
$data[4] = preg_quote($data[4], "'");
$query = "INSERT INTO ".$prefix."_blocked_iptoc values('$data[0]', '$data[1]', '$data[2]', '$data[3]', '$data[4]')";
$result2 = $db -> sql_query($query);
if(!$result2) {
echo "<strong>"._PS_IP2C_ERROR."</strong><br />"._PS_IP2C_VALUE." $data[0]', '$data[1]', '$data[2]', '$data[3]', '$data[4] @ row $i "._PS_IP2C_ERROR_DATA_INSERT." <br /> \n". mysql_error(); echo "<br />"; die();
}
}
fclose ($handle);
$time_end = time();
$tot = $time_end - $time_start;
if($result2) {
echo " "._PS_IP2C_ALTERNATIV_WORK." ".$tot." "._PS_IP2C_SEC_AND." ".$i." "._PS_IP2C_DATA_INSERT.".";
} else {
echo ""._PS_IP2C_ERROR_UPDATE2." " . mysql_error(); }
}
echo "</center>";
CloseTable();
}
@unlink($csvfile);
// @mysql_close($connection);
}
CloseTable();
echo "<p>";
OpenTable();
echo "<center><strong>"._PS_IP2C_IP2C_CONTROL."</strong><p>";
echo "<form action=".$admin_file.".php?op=Fusion&page_value=pro_iptoc method=post>";
echo "<input type=text name=\"ipt\">";
echo "<input type=hidden name=\"what\" value=\"controll\">";
echo "<p><p><input type=submit value="._PS_IP2C_CHECK."></form><p>";
if($what == 'controll') {
checkipaddress($ipt);
echo "<br />"._PS_IP2C_IP_BELONG."<br />";
ip2flag($ipt,'');
}
CloseTable();
echo "<p>";
} else {
echo "<center><h1>Access Denied You are Not A God Admin!!</h1></center>";
}
?>