PHP Formatında çalıştırabilirsiniz. Yüksek boyutlu veri tabanlarını en sağlıklı şekilde import etme yöntemi
Kod:
<?php
error_reporting(E_ALL);
$db_server = 'localhost';
$db_name = '';
$db_username = '';
$db_password = '';
$db_connection_charset = 'utf8';
// OPTIONAL SETTINGS
$filename = '';
$ajax = true;
$linespersession = 3000;
$delaypersession = 0;
$csv_insert_table = '';
$csv_preempty_table = false;
$csv_delimiter = ',';
$csv_add_quotes = true;
$csv_add_slashes = true;
$comment[]='#';
$comment[]='-- ';
$comment[]='DELIMITER';
$comment[]='/*!';
$delimiter = ';';
$string_quotes = '\'';
$max_query_lines = 300;
$upload_dir = dirname(__FILE__);
if ($ajax)
ob_start();
define ('VERSION','0.37b');
define ('DATA_CHUNK_LENGTH',16384);
define ('TESTMODE',false);
define ('BIGDUMP_DIR',dirname(__FILE__));
define ('PLUGIN_DIR',BIGDUMP_DIR.'/plugins/');
header("Expires: Mon, 1 Dec 2003 01:00:00 GMT");
header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
header("Cache-Control: no-store, no-cache, must-revalidate");
header("Cache-Control: post-check=0, pre-check=0", false);
header("Pragma: no-cache");
@ini_set('auto_detect_line_endings', true);
@set_time_limit(0);
if (function_exists("date_default_timezone_set") && function_exists("date_default_timezone_get"))
@date_default_timezone_set(@date_default_timezone_get());
foreach ($_REQUEST as $key => $val)
{
$val = preg_replace("/[^_A-Za-z0-9-\.&= ;\$]/i",'', $val);
$_REQUEST[$key] = $val;
}
do_action('header');
?>
<html>
<head>
<title>BigDump ver. <?php echo (VERSION); ?></title>
<meta http-equiv="CONTENT-LANGUAGE" content="EN"/>
<meta http-equiv="Cache-Control" content="no-cache/"/>
<meta http-equiv="Pragma" content="no-cache"/>
<meta http-equiv="Expires" content="-1"/>
<meta name="robots" content="noindex, nofollow">
<?php do_action('head_meta'); ?>
<style type="text/css">
<!--
body
{ background-color:#FFFFF0;
}
h1
{ font-size:20px;
line-height:24px;
font-family:Arial,Helvetica,sans-serif;
margin-top:5px;
margin-bottom:5px;
}
p,td,th
{ font-size:14px;
line-height:18px;
font-family:Arial,Helvetica,sans-serif;
margin-top:5px;
margin-bottom:5px;
text-align:justify;
vertical-align:top;
}
p.centr
{
text-align:center;
}
p.smlcentr
{ font-size:10px;
line-height:14px;
text-align:center;
}
p.error
{ color:#FF0000;
font-weight:bold;
}
p.success
{ color:#00DD00;
font-weight:bold;
}
p.successcentr
{ color:#00DD00;
background-color:#DDDDFF;
font-weight:bold;
text-align:center;
}
td
{ background-color:#F8F8F8;
text-align:left;
}
td.transparent
{ background-color:#FFFFF0;
}
th
{ font-weight:bold;
color:#FFFFFF;
background-color:#AAAAEE;
text-align:left;
}
td.right
{ text-align:right;
}
form
{ margin-top:5px;
margin-bottom:5px;
}
div.skin1
{
border-color:#3333EE;
border-width:5px;
border-style:solid;
background-color:#AAAAEE;
text-align:center;
vertical-align:middle;
padding:3px;
margin:1px;
}
td.bg3
{ background-color:#EEEE99;
text-align:left;
vertical-align:top;
width:20%;
}
th.bg4
{ background-color:#EEAA55;
text-align:left;
vertical-align:top;
width:20%;
}
td.bgpctbar
{ background-color:#EEEEAA;
text-align:left;
vertical-align:middle;
width:80%;
}
<?php do_action('head_style'); ?>
-->
</style>
</head>
<body>
<center>
<table width="780" cellspacing="0" cellpadding="0">
<tr><td class="transparent">
<!-- <h1>BigDump: Staggered MySQL Dump Importer ver. <?php echo (VERSION); ?></h1> -->
<?php
function skin_open()
{
echo ('<div class="skin1">');
}
function skin_close()
{
echo ('</div>');
}
skin_open();
echo ('<h1>BigDump: Staggered MySQL Dump Importer v'.VERSION.'</h1>');
skin_close();
do_action('after_headline');
$error = false;
$file = false;
if (!$error && !function_exists('version_compare'))
{ echo ("<p class=\"error\">PHP version 4.1.0 is required for BigDump to proceed. You have PHP ".phpversion()." installed. Sorry!</p>\n");
$error=true;
}
if (!$error && !function_exists('mysqli_connect'))
{ echo ("<p class=\"error\">There is no mySQLi extension found in your PHP installation. You can use an older Bigdump version if your PHP supports mySQL extension.</p>\n");
$error=true;
}
if (!$error)
{ $upload_max_filesize=ini_get("upload_max_filesize");
if (preg_match("/([0-9]+)K/i",$upload_max_filesize,$tempregs)) $upload_max_filesize=$tempregs[1]*1024;
if (preg_match("/([0-9]+)M/i",$upload_max_filesize,$tempregs)) $upload_max_filesize=$tempregs[1]*1024*1024;
if (preg_match("/([0-9]+)G/i",$upload_max_filesize,$tempregs)) $upload_max_filesize=$tempregs[1]*1024*1024*1024;
}
do_action ('script_runs');
if (!$error && isset($_REQUEST["uploadbutton"]))
{ if (is_uploaded_file($_FILES["dumpfile"]["tmp_name"]) && ($_FILES["dumpfile"]["error"])==0)
{
$uploaded_filename=str_replace(" ","_",$_FILES["dumpfile"]["name"]);
$uploaded_filename=preg_replace("/[^_A-Za-z0-9-\.]/i",'',$uploaded_filename);
$uploaded_filepath=str_replace("\\","/",$upload_dir."/".$uploaded_filename);
do_action('file_uploaded');
if (file_exists($uploaded_filename))
{ echo ("<p class=\"error\">File $uploaded_filename already exist! Delete and upload again!</p>\n");
}
else if (!preg_match("/(\.(sql|gz|csv))$/i",$uploaded_filename))
{ echo ("<p class=\"error\">You may only upload .sql .gz or .csv files.</p>\n");
}
else if (!@move_uploaded_file($_FILES["dumpfile"]["tmp_name"],$uploaded_filepath))
{ echo ("<p class=\"error\">Error moving uploaded file ".$_FILES["dumpfile"]["tmp_name"]." to the $uploaded_filepath</p>\n");
echo ("<p>Check the directory permissions for $upload_dir (must be 777)!</p>\n");
}
else
{ echo ("<p class=\"success\">Uploaded file saved as $uploaded_filename</p>\n");
}
}
else
{ echo ("<p class=\"error\">Error uploading file ".$_FILES["dumpfile"]["name"]."</p>\n");
}
}
if (!$error && isset($_REQUEST["delete"]) && $_REQUEST["delete"]!=basename($_SERVER["SCRIPT_FILENAME"]))
{ if (preg_match("/(\.(sql|gz|csv))$/i",$_REQUEST["delete"]) && @unlink($upload_dir.'/'.$_REQUEST["delete"]))
echo ("<p class=\"success\">".$_REQUEST["delete"]." was removed successfully</p>\n");
else
echo ("<p class=\"error\">Can't remove ".$_REQUEST["delete"]."</p>\n");
}
if (!$error && !TESTMODE)
{ $mysqli = new mysqli($db_server, $db_username, $db_password, $db_name);
if (mysqli_connect_error())
{ echo ("<p class=\"error\">Database connection failed due to ".mysqli_connect_error()."</p>\n");
echo ("<p>Edit the database settings in BigDump configuration, or contact your database provider.</p>\n");
$error=true;
}
if (!$error && $db_connection_charset!=='')
$mysqli->query("SET NAMES $db_connection_charset");
if (!$error)
mysqli_report(MYSQLI_REPORT_OFF);
if (!$error && isset ($pre_query) && sizeof ($pre_query)>0)
{ reset($pre_query);
foreach ($pre_query as $pre_query_value)
{ if (!$mysqli->query($pre_query_value))
{ echo ("<p class=\"error\">Error with pre-query.</p>\n");
echo ("<p>Query: ".trim(nl2br(htmlentities($pre_query_value)))."</p>\n");
echo ("<p>MySQL: ".$mysqli->error."</p>\n");
$error=true;
break;
}
}
}
}
else
{ $dbconnection = false;
}
do_action('database_connected');
if (!$error && !isset($_REQUEST["fn"]) && $filename=="")
{ if ($dirhandle = opendir($upload_dir))
{
$files=array();
while (false !== ($files[] = readdir($dirhandle)));
closedir($dirhandle);
$dirhead=false;
if (sizeof($files)>0)
{
sort($files);
foreach ($files as $dirfile)
{
if ($dirfile != "." && $dirfile != ".." && $dirfile!=basename($_SERVER["SCRIPT_FILENAME"]) && preg_match("/\.(sql|gz|csv)$/i",$dirfile))
{ if (!$dirhead)
{ echo ("<table width=\"100%\" cellspacing=\"2\" cellpadding=\"2\">\n");
echo ("<tr><th>Filename</th><th>Size</th><th>Date&Time</th><th>Type</th><th> </th><th> </th>\n");
$dirhead=true;
}
echo ("<tr><td>$dirfile</td><td class=\"right\">".filesize($upload_dir.'/'.$dirfile)."</td><td>".date ("Y-m-d H:i:s", filemtime($upload_dir.'/'.$dirfile))."</td>");
if (preg_match("/\.sql$/i",$dirfile))
echo ("<td>SQL</td>");
elseif (preg_match("/\.gz$/i",$dirfile))
echo ("<td>GZip</td>");
elseif (preg_match("/\.csv$/i",$dirfile))
echo ("<td>CSV</td>");
else
echo ("<td>Misc</td>");
if ((preg_match("/\.gz$/i",$dirfile) && function_exists("gzopen")) || preg_match("/\.sql$/i",$dirfile) || preg_match("/\.csv$/i",$dirfile))
echo ("<td><a href=\"".$_SERVER["PHP_SELF"]."?start=1&fn=".urlencode($dirfile)."&foffset=0&totalqueries=0&delimiter=".urlencode($delimiter)."\">Start Import</a> into $db_name at $db_server</td>\n <td><a href=\"".$_SERVER["PHP_SELF"]."?delete=".urlencode($dirfile)."\">Delete file</a></td></tr>\n");
else
echo ("<td> </td>\n <td> </td></tr>\n");
}
}
}
if ($dirhead)
echo ("</table>\n");
else
echo ("<p>No uploaded SQL, GZ or CSV files found in the working directory</p>\n");
}
else
{ echo ("<p class=\"error\">Error listing directory $upload_dir</p>\n");
$error=true;
}
}
if (!$error && !isset ($_REQUEST["fn"]) && $filename!="")
{ echo ("<p><a href=\"".$_SERVER["PHP_SELF"]."?start=1&fn=".urlencode($filename)."&foffset=0&totalqueries=0\">Start Import</a> from $filename into $db_name at $db_server</p>\n");
}
if (!$error && !isset($_REQUEST["fn"]) && $filename=="")
{
do { $tempfilename=$upload_dir.'/'.time().".tmp"; } while (file_exists($tempfilename));
if (!($tempfile=@fopen($tempfilename,"w")))
{ echo ("<p>Upload form disabled. Permissions for the working directory <i>$upload_dir</i> <b>must be set writable for the webserver</b> in order ");
echo ("to upload files here. Or you can upload your dump files via FTP.</p>\n");
}
else
{ fclose($tempfile);
unlink ($tempfilename);
echo ("<p>You can now upload your dump file up to $upload_max_filesize bytes (".round ($upload_max_filesize/1024/1024)." Mbytes) ");
echo ("directly from your browser to the server. Alternatively you can upload your dump files of any size via FTP.</p>\n");
?>
<form method="POST" action="<?php echo ($_SERVER["PHP_SELF"]); ?>" enctype="multipart/form-data">
<input type="hidden" name="MAX_FILE_SIZE" value="$upload_max_filesize">
<p>Dump file: <input type="file" name="dumpfile" accept="*/*" size="60"></p>
<?php
}
}
if (!$error && !TESTMODE && !isset($_REQUEST["fn"]))
{
$result = $mysqli->query("SHOW VARIABLES LIKE 'character_set_connection';");
if ($result)
{ $row = $result->fetch_assoc();
if ($row)
{ $charset = $row['Value'];
echo ("<p>Note: The current mySQL connection charset is <i>$charset</i>. Your dump file must be encoded in <i>$charset</i> in order to avoid problems with non-latin characters. You can change the connection charset using the \$db_connection_charset variable in bigdump.php</p>\n");
}
$result->free();
}
}
if (!$error && isset($_REQUEST["start"]))
{
if ($filename!="")
$curfilename=$filename;
else if (isset($_REQUEST["fn"]))
$curfilename=urldecode($_REQUEST["fn"]);
else
$curfilename="";
if (preg_match("/\.gz$/i",$curfilename))
$gzipmode=true;
else
$gzipmode=false;
if ((!$gzipmode && !$file=@fopen($upload_dir.'/'.$curfilename,"r")) || ($gzipmode && !$file=@gzopen($upload_dir.'/'.$curfilename,"r")))
{ echo ("<p class=\"error\">Can't open ".$curfilename." for import</p>\n");
echo ("<p>Please, check that your dump file name contains only alphanumerical characters, and rename it accordingly, for example: $curfilename.".
"<br>Or, specify \$filename in bigdump.php with the full filename. ".
"<br>Or, you have to upload the $curfilename to the server first.</p>\n");
$error=true;
}
else if ((!$gzipmode && @fseek($file, 0, SEEK_END)==0) || ($gzipmode && @gzseek($file, 0)==0))
{ if (!$gzipmode) $filesize = ftell($file);
else $filesize = gztell($file);
}
else
{ echo ("<p class=\"error\">I can't seek into $curfilename</p>\n");
$error=true;
}
if (!$error && ($csv_insert_table == "") && (preg_match("/(\.csv)$/i",$curfilename)))
{ echo ("<p class=\"error\">You have to specify \$csv_insert_table when using a CSV file. </p>\n");
$error=true;
}
}
if (!$error && isset($_REQUEST["start"]) && isset($_REQUEST["foffset"]) && preg_match("/(\.(sql|gz|csv))$/i",$curfilename))
{
do_action('session_start');
if (!is_numeric($_REQUEST["start"]) || !is_numeric($_REQUEST["foffset"]))
{ echo ("<p class=\"error\">UNEXPECTED: Non-numeric values for start and foffset</p>\n");
$error=true;
}
else
{ $_REQUEST["start"] = floor($_REQUEST["start"]);
$_REQUEST["foffset"] = floor($_REQUEST["foffset"]);
}
if (isset($_REQUEST["delimiter"]))
$delimiter = $_REQUEST["delimiter"];
if (!$error && $_REQUEST["start"]==1 && $csv_insert_table != "" && $csv_preempty_table)
{
$query = "DELETE FROM `$csv_insert_table`";
if (!TESTMODE && !$mysqli->query(trim($query)))
{ echo ("<p class=\"error\">Error when deleting entries from $csv_insert_table.</p>\n");
echo ("<p>Query: ".trim(nl2br(htmlentities($query)))."</p>\n");
echo ("<p>MySQL: ".$mysqli->error."</p>\n");
$error=true;
}
}
if (!$error)
{ skin_open();
if (TESTMODE)
echo ("<p class=\"centr\">TEST MODE ENABLED</p>\n");
echo ("<p class=\"centr\">Processing file: <b>".$curfilename."</b></p>\n");
echo ("<p class=\"smlcentr\">Starting from line: ".$_REQUEST["start"]."</p>\n");
skin_close();
}
if (!$error && !$gzipmode && $_REQUEST["foffset"]>$filesize)
{ echo ("<p class=\"error\">UNEXPECTED: Can't set file pointer behind the end of file</p>\n");
$error=true;
}
if (!$error && ((!$gzipmode && fseek($file, $_REQUEST["foffset"])!=0) || ($gzipmode && gzseek($file, $_REQUEST["foffset"])!=0)))
{ echo ("<p class=\"error\">UNEXPECTED: Can't set file pointer to offset: ".$_REQUEST["foffset"]."</p>\n");
$error=true;
}
if (!$error)
{ $query="";
$queries=0;
$totalqueries=$_REQUEST["totalqueries"];
$linenumber=$_REQUEST["start"];
$querylines=0;
$inparents=false;
while ($linenumber<$_REQUEST["start"]+$linespersession || $query!="")
{
$dumpline = "";
while (!feof($file) && substr ($dumpline, -1) != "\n" && substr ($dumpline, -1) != "\r")
{ if (!$gzipmode)
$dumpline .= fgets($file, DATA_CHUNK_LENGTH);
else
$dumpline .= gzgets($file, DATA_CHUNK_LENGTH);
}
if ($dumpline==="") break;
if ($_REQUEST["foffset"]==0)
$dumpline=preg_replace('|^\xEF\xBB\xBF|','',$dumpline);
if (($csv_insert_table != "") && (preg_match("/(\.csv)$/i",$curfilename)))
{
if ($csv_add_slashes)
$dumpline = addslashes($dumpline);
$dumpline = explode($csv_delimiter,$dumpline);
if ($csv_add_quotes)
$dumpline = "'".implode("','",$dumpline)."'";
else
$dumpline = implode(",",$dumpline);
$dumpline = 'INSERT INTO '.$csv_insert_table.' VALUES ('.$dumpline.');';
}
$dumpline=str_replace("\r\n", "\n", $dumpline);
$dumpline=str_replace("\r", "\n", $dumpline);
if (!$inparents && strpos ($dumpline, "DELIMITER ") === 0)
$delimiter = str_replace ("DELIMITER ","",trim($dumpline));
if (!$inparents)
{ $skipline=false;
reset($comment);
foreach ($comment as $comment_value)
{
if (trim($dumpline)=="" || strpos (trim($dumpline), $comment_value) === 0)
{ $skipline=true;
break;
}
}
if ($skipline)
{ $linenumber++;
continue;
}
}
$dumpline_deslashed = str_replace ("\\\\","",$dumpline);
$parents=substr_count ($dumpline_deslashed, $string_quotes)-substr_count ($dumpline_deslashed, "\\$string_quotes");
if ($parents % 2 != 0)
$inparents=!$inparents;
// Add the line to query
$query .= $dumpline;
if (!$inparents)
$querylines++;
if ($querylines>$max_query_lines)
{
echo ("<p class=\"error\">Stopped at the line $linenumber. </p>");
echo ("<p>At this place the current query includes more than ".$max_query_lines." dump lines. That can happen if your dump file was ");
echo ("created by some tool which doesn't place a semicolon followed by a linebreak at the end of each query, or if your dump contains ");
echo ("extended inserts or very long procedure definitions. Please read the <a href=\"http://www.ozerov.de/bigdump/usage/\">BigDump usage notes</a> ");
echo ("for more infos. Ask for our support services ");
echo ("in order to handle dump files containing extended inserts.</p>\n");
$error=true;
break;
}
if ((preg_match('/'.preg_quote($delimiter,'/').'$/',trim($dumpline)) || $delimiter=='') && !$inparents)
{
$query = substr(trim($query),0,-1*strlen($delimiter));
if (!TESTMODE && !$mysqli->query($query))
{ echo ("<p class=\"error\">Error at the line $linenumber: ". trim($dumpline)."</p>\n");
echo ("<p>Query: ".trim(nl2br(htmlentities($query)))."</p>\n");
echo ("<p>MySQL: ".$mysqli->error."</p>\n");
$error=true;
break;
}
$totalqueries++;
$queries++;
$query="";
$querylines=0;
}
$linenumber++;
}
}
if (!$error)
{ if (!$gzipmode)
$foffset = ftell($file);
else
$foffset = gztell($file);
if (!$foffset)
{ echo ("<p class=\"error\">UNEXPECTED: Can't read the file pointer offset</p>\n");
$error=true;
}
}
skin_open();
if (!$error)
{
$lines_this = $linenumber-$_REQUEST["start"];
$lines_done = $linenumber-1;
$lines_togo = ' ? ';
$lines_tota = ' ? ';
$queries_this = $queries;
$queries_done = $totalqueries;
$queries_togo = ' ? ';
$queries_tota = ' ? ';
$bytes_this = $foffset-$_REQUEST["foffset"];
$bytes_done = $foffset;
$kbytes_this = round($bytes_this/1024,2);
$kbytes_done = round($bytes_done/1024,2);
$mbytes_this = round($kbytes_this/1024,2);
$mbytes_done = round($kbytes_done/1024,2);
if (!$gzipmode)
{
$bytes_togo = $filesize-$foffset;
$bytes_tota = $filesize;
$kbytes_togo = round($bytes_togo/1024,2);
$kbytes_tota = round($bytes_tota/1024,2);
$mbytes_togo = round($kbytes_togo/1024,2);
$mbytes_tota = round($kbytes_tota/1024,2);
$pct_this = ceil($bytes_this/$filesize*100);
$pct_done = ceil($foffset/$filesize*100);
$pct_togo = 100 - $pct_done;
$pct_tota = 100;
if ($bytes_togo==0)
{ $lines_togo = '0';
$lines_tota = $linenumber-1;
$queries_togo = '0';
$queries_tota = $totalqueries;
}
$pct_bar = "<div style=\"height:15px;width:$pct_done%;background-color:#000080;margin:0px;\"></div>";
}
else
{
$bytes_togo = ' ? ';
$bytes_tota = ' ? ';
$kbytes_togo = ' ? ';
$kbytes_tota = ' ? ';
$mbytes_togo = ' ? ';
$mbytes_tota = ' ? ';
$pct_this = ' ? ';
$pct_done = ' ? ';
$pct_togo = ' ? ';
$pct_tota = 100;
$pct_bar = str_replace(' ',' ','<tt>[ Not available for gzipped files ]</tt>');
}
echo ("
<center>
<table width=\"520\" border=\"0\" cellpadding=\"3\" cellspacing=\"1\">
<tr><th class=\"bg4\"> </th><th class=\"bg4\">Session</th><th class=\"bg4\">Done</th><th class=\"bg4\">To go</th><th class=\"bg4\">Total</th></tr>
<tr><th class=\"bg4\">Lines</th><td class=\"bg3\">$lines_this</td><td class=\"bg3\">$lines_done</td><td class=\"bg3\">$lines_togo</td><td class=\"bg3\">$lines_tota</td></tr>
<tr><th class=\"bg4\">Queries</th><td class=\"bg3\">$queries_this</td><td class=\"bg3\">$queries_done</td><td class=\"bg3\">$queries_togo</td><td class=\"bg3\">$queries_tota</td></tr>
<tr><th class=\"bg4\">Bytes</th><td class=\"bg3\">$bytes_this</td><td class=\"bg3\">$bytes_done</td><td class=\"bg3\">$bytes_togo</td><td class=\"bg3\">$bytes_tota</td></tr>
<tr><th class=\"bg4\">KB</th><td class=\"bg3\">$kbytes_this</td><td class=\"bg3\">$kbytes_done</td><td class=\"bg3\">$kbytes_togo</td><td class=\"bg3\">$kbytes_tota</td></tr>
<tr><th class=\"bg4\">MB</th><td class=\"bg3\">$mbytes_this</td><td class=\"bg3\">$mbytes_done</td><td class=\"bg3\">$mbytes_togo</td><td class=\"bg3\">$mbytes_tota</td></tr>
<tr><th class=\"bg4\">%</th><td class=\"bg3\">$pct_this</td><td class=\"bg3\">$pct_done</td><td class=\"bg3\">$pct_togo</td><td class=\"bg3\">$pct_tota</td></tr>
<tr><th class=\"bg4\">% bar</th><td class=\"bgpctbar\" colspan=\"4\">$pct_bar</td></tr>
</table>
</center>
\n");
// Finish message and restart the script
if ($linenumber<$_REQUEST["start"]+$linespersession)
{ echo ("<p class=\"successcentr\">Congratulations: End of file reached, assuming OK</p>\n");
echo ("<p class=\"successcentr\">IMPORTANT: REMOVE YOUR DUMP FILE and BIGDUMP SCRIPT FROM SERVER NOW!</p>\n");
echo ("<p class=\"centr\">Thank you for using this tool! Please rate <a href=\"http://www.hotscripts.com/listing/bigdump/?RID=403\" target=\"_blank\">Bigdump at Hotscripts.com</a></p>\n");
echo ("<p class=\"centr\">You can send me some bucks or euros as appreciation via PayPal. Thank you!</p>\n");
?>
<?php
do_action('script_finished');
$error=true; // This is a semi-error telling the script is finished
}
else
{ if ($delaypersession!=0)
echo ("<p class=\"centr\">Now I'm <b>waiting $delaypersession milliseconds</b> before starting next session...</p>\n");
if (!$ajax)
echo ("<script language=\"JavaScript\" type=\"text/javascript\">window.setTimeout('location.href=\"".$_SERVER["PHP_SELF"]."?start=$linenumber&fn=".urlencode($curfilename)."&foffset=$foffset&totalqueries=$totalqueries&delimiter=".urlencode($delimiter)."\";',500+$delaypersession);</script>\n");
echo ("<noscript>\n");
echo ("<p class=\"centr\"><a href=\"".$_SERVER["PHP_SELF"]."?start=$linenumber&fn=".urlencode($curfilename)."&foffset=$foffset&totalqueries=$totalqueries&delimiter=".urlencode($delimiter)."\">Continue from the line $linenumber</a> (Enable JavaScript to do it automatically)</p>\n");
echo ("</noscript>\n");
echo ("<p class=\"centr\">Press <b><a href=\"".$_SERVER["PHP_SELF"]."\">STOP</a></b> to abort the import <b>OR WAIT!</b></p>\n");
}
}
else
echo ("<p class=\"error\">Stopped on error</p>\n");
skin_close();
}
if ($error)
echo ("<p class=\"centr\"><a href=\"".$_SERVER["PHP_SELF"]."\">Start from the beginning</a> (DROP the old tables before restarting)</p>\n");
if ($mysqli) $mysqli->close();
if ($file && !$gzipmode) fclose($file);
else if ($file && $gzipmode) gzclose($file);
?>
<p class="centr">© 2003-2015 <a href="mailto:[email protected]">Alexey Ozerov</a></p>
</td></tr></table>
</center>
<?php do_action('end_of_body'); ?>
</body>
</html>
<?php
// If error or finished put out the whole output from above and stop
if ($error)
{
$out1 = ob_get_contents();
ob_end_clean();
echo $out1;
die;
}
// If Ajax enabled and in import progress creates responses (XML response or script for the initial page)
if ($ajax && isset($_REQUEST['start']))
{
if (isset($_REQUEST['ajaxrequest']))
{ ob_end_clean();
create_xml_response();
die;
}
else
create_ajax_script();
}
// Anyway put out the output from above
ob_flush();
// THE MAIN SCRIPT ENDS HERE
// *******************************************************************************************
// Plugin handling (EXPERIMENTAL)
// *******************************************************************************************
function do_action($tag)
{ global $plugin_actions;
if (isset($plugin_actions[$tag]))
{ reset ($plugin_actions[$tag]);
foreach ($plugin_actions[$tag] as $action)
call_user_func_array($action, array());
}
}
function add_action($tag, $function)
{
global $plugin_actions;
$plugin_actions[$tag][] = $function;
}
// *******************************************************************************************
// AJAX utilities
// *******************************************************************************************
function create_xml_response()
{
global $linenumber, $foffset, $totalqueries, $curfilename, $delimiter,
$lines_this, $lines_done, $lines_togo, $lines_tota,
$queries_this, $queries_done, $queries_togo, $queries_tota,
$bytes_this, $bytes_done, $bytes_togo, $bytes_tota,
$kbytes_this, $kbytes_done, $kbytes_togo, $kbytes_tota,
$mbytes_this, $mbytes_done, $mbytes_togo, $mbytes_tota,
$pct_this, $pct_done, $pct_togo, $pct_tota,$pct_bar;
header('Content-Type: application/xml');
header('Cache-Control: no-cache');
echo '<?xml version="1.0" encoding="ISO-8859-1"?>';
echo "<root>";
// data - for calculations
echo "<linenumber>$linenumber</linenumber>";
echo "<foffset>$foffset</foffset>";
echo "<fn>$curfilename</fn>";
echo "<totalqueries>$totalqueries</totalqueries>";
echo "<delimiter>$delimiter</delimiter>";
// results - for page update
echo "<elem1>$lines_this</elem1>";
echo "<elem2>$lines_done</elem2>";
echo "<elem3>$lines_togo</elem3>";
echo "<elem4>$lines_tota</elem4>";
echo "<elem5>$queries_this</elem5>";
echo "<elem6>$queries_done</elem6>";
echo "<elem7>$queries_togo</elem7>";
echo "<elem8>$queries_tota</elem8>";
echo "<elem9>$bytes_this</elem9>";
echo "<elem10>$bytes_done</elem10>";
echo "<elem11>$bytes_togo</elem11>";
echo "<elem12>$bytes_tota</elem12>";
echo "<elem13>$kbytes_this</elem13>";
echo "<elem14>$kbytes_done</elem14>";
echo "<elem15>$kbytes_togo</elem15>";
echo "<elem16>$kbytes_tota</elem16>";
echo "<elem17>$mbytes_this</elem17>";
echo "<elem18>$mbytes_done</elem18>";
echo "<elem19>$mbytes_togo</elem19>";
echo "<elem20>$mbytes_tota</elem20>";
echo "<elem21>$pct_this</elem21>";
echo "<elem22>$pct_done</elem22>";
echo "<elem23>$pct_togo</elem23>";
echo "<elem24>$pct_tota</elem24>";
echo "<elem_bar>".htmlentities($pct_bar)."</elem_bar>";
echo "</root>";
}
function create_ajax_script()
{
global $linenumber, $foffset, $totalqueries, $delaypersession, $curfilename, $delimiter;
?>
<script type="text/javascript" language="javascript">
// creates next action url (upload page, or XML response)
function get_url(linenumber,fn,foffset,totalqueries,delimiter) {
return "<?php echo $_SERVER['PHP_SELF'] ?>?start="+linenumber+"&fn="+fn+"&foffset="+foffset+"&totalqueries="+totalqueries+"&delimiter="+delimiter+"&ajaxrequest=true";
}
// extracts text from XML element (itemname must be unique)
function get_xml_data(itemname,xmld) {
return xmld.getElementsByTagName(itemname).item(0).firstChild.data;
}
function makeRequest(url) {
http_request = false;
if (window.XMLHttpRequest) {
// Mozilla etc.
http_request = new XMLHttpRequest();
if (http_request.overrideMimeType) {
http_request.overrideMimeType("text/xml");
}
} else if (window.ActiveXObject) {
// IE
try {
http_request = new ActiveXObject("Msxml2.XMLHTTP");
} catch(e) {
try {
http_request = new ActiveXObject("Microsoft.XMLHTTP");
} catch(e) {}
}
}
if (!http_request) {
alert("Cannot create an XMLHTTP instance");
return false;
}
http_request.onreadystatechange = server_response;
http_request.open("GET", url, true);
http_request.send(null);
}
function server_response()
{
// waiting for correct response
if (http_request.readyState != 4)
return;
if (http_request.status != 200)
{
alert("Page unavailable, or wrong url!")
return;
}
// r = xml response
var r = http_request.responseXML;
//if received not XML but HTML with new page to show
if (!r || r.getElementsByTagName('root').length == 0)
{ var text = http_request.responseText;
document.open();
document.write(text);
document.close();
return;
}
// update "Starting from line: "
document.getElementsByTagName('p').item(1).innerHTML =
"Starting from line: " +
r.getElementsByTagName('linenumber').item(0).firstChild.nodeValue;
// update table with new values
for(i = 1; i <= 24; i++)
document.getElementsByTagName('td').item(i).firstChild.data = get_xml_data('elem'+i,r);
// update color bar
document.getElementsByTagName('td').item(25).innerHTML =
r.getElementsByTagName('elem_bar').item(0).firstChild.nodeValue;
// action url (XML response)
url_request = get_url(
get_xml_data('linenumber',r),
get_xml_data('fn',r),
get_xml_data('foffset',r),
get_xml_data('totalqueries',r),
get_xml_data('delimiter',r));
// ask for XML response
window.setTimeout("makeRequest(url_request)",500+<?php echo $delaypersession; ?>);
}
// First Ajax request from initial page
var http_request = false;
var url_request = get_url(<?php echo ($linenumber.',"'.urlencode($curfilename).'",'.$foffset.','.$totalqueries.',"'.urlencode($delimiter).'"') ;?>);
window.setTimeout("makeRequest(url_request)",500+<?php echo $delaypersession; ?>);
</script>
<?php
}
?>
