برای خودکار کردنش، فایل index.php رو حذف کنید و فایل import.php رو اینطوری تغییر بدین:
<!doctype html>
<html>
<head>
<title>AJAX Import</title>
<meta charset="utf-8"/>
<script src="jqmin.js" type="text/javascript"></script>
<script type="text/javascript">
$(document).ready(function() {
var size = $("#size").html().replace(/,/gi, "");
function read(file, pos) {
var fn = $("#fn").html();
var host = $("#host").html();
var user = $("#user").html();
var pass = $("#pass").html();
var db = $("#db").html();
$.ajax({
type: "post",
url: "action.php",
data: "fn="+fn+"&host="+host+"&user="+user+"&pass="+pass+"&db="+db+"&pos="+pos,
success: function(data) {
var newpos = parseFloat(data.substring(0, data.indexOf(" ")));
if(newpos > pos) {
var query = data.substring(data.indexOf(" ") + 1);
$("#current").html(newpos);
$("#query").html(query);
var elapsed_percent = Math.floor(newpos / size * 100);
var remained_percent = 100 - elapsed_percent;
var elapsed = "";
while(elapsed_percent > 0) {
elapsed += " ";
elapsed_percent--;
}
var remained = "";
while(remained_percent > 0) {
remained += " ";
remained_percent--;
}
$("#elapsed").html(elapsed);
$("#remained").html(remained);
read(fn, newpos);
}
}
});
};
read($("#fn").html(), $("#current").html());
});
</script>
<style type="text/css">
.info {
color: #0000ff;
}
#current {
color: #ff0000;
}
#elapsed {
background-color: #7fff7f;
}
#query {
border: solid thin #000000;
height: 300px;
padding: 5px;
overflow: scroll;
text-align: left;
white-space: pre;
width: 500px;
}
#remained {
background-color: #cdcdcd;
}
#size {
color: #00cd00;
}
</style>
</head>
<body>
<?php
$fn = 'travian.sql';
$host = 'localhost';
$user = 'root';
$pass = '';
$db = 'travian';
if(file_exists($fn)) {
if(preg_match('#(.gz)$#i', $_POST['fn'])) {
$zp = @gzopen($_POST['fn'], 'rb');
if ($zp) {
$size = 0;
while(!gzeof($zp)) {
$size += strlen(gzread($zp, 1024));
}
gzclose($zp);
}
}
else {
$size = filesize($_POST['fn']);
}
?>
<center>
<p><span id="elapsed"></span><span id="remained"><?php for($i = 0; $i < 100; $i++) { echo ' '; } ?></span></p>
<table>
<tr><td align="left">Filename:</td><th align="left"><span class="info" id="fn"><?php echo $_POST['fn']; ?></span></th></tr>
<tr><td align="left">Host:</td><th align="left"><span class="info" id="host"><?php echo $host; ?></span></th></tr>
<tr><td align="left">Username:</td><th align="left"><span class="info" id="user"><?php echo $user; ?></span></th></tr>
<tr><td align="left">Password:</td><th align="left"><span class="info" id="pass"><?php echo $pass; ?></span></th></tr>
<tr><td align="left">Database:</td><th align="left"><span class="info" id="db"><?php echo $db; ?></span></th></tr>
</table>
<p>Current position: <span id="current">0</span>; Total size: <span id="size"><?php echo number_format($size, 0, '.', ','); ?></span> byte(s)</p>
Current Query:<p id="query"></p>
</center>
<?php
}
else {
header('Location: index.php');
?>
Insufficient Data. <a href="index.php">Try Again</a><br/>
<?php
exit();
}
?>
</body>
</html><!doctype html>
<html>
<head>
<title>AJAX Import</title>
<meta charset="utf-8"/>
<script src="jqmin.js" type="text/javascript"></script>
<script type="text/javascript">
$(document).ready(function() {
var size = $("#size").html().replace(/,/gi, "");
function read(file, pos) {
var fn = $("#fn").html();
var host = $("#host").html();
var user = $("#user").html();
var pass = $("#pass").html();
var db = $("#db").html();
$.ajax({
type: "post",
url: "action.php",
data: "fn="+fn+"&host="+host+"&user="+user+"&pass="+pass+"&db="+db+"&pos="+pos,
success: function(data) {
var newpos = parseFloat(data.substring(0, data.indexOf(" ")));
if(newpos > pos) {
var query = data.substring(data.indexOf(" ") + 1);
$("#current").html(newpos);
$("#query").html(query);
var elapsed_percent = Math.floor(newpos / size * 100);
var remained_percent = 100 - elapsed_percent;
var elapsed = "";
while(elapsed_percent > 0) {
elapsed += " ";
elapsed_percent--;
}
var remained = "";
while(remained_percent > 0) {
remained += " ";
remained_percent--;
}
$("#elapsed").html(elapsed);
$("#remained").html(remained);
read(fn, newpos);
}
}
});
};
read($("#fn").html(), $("#current").html());
});
</script>
<style type="text/css">
.info {
color: #0000ff;
}
#current {
color: #ff0000;
}
#elapsed {
background-color: #7fff7f;
}
#query {
border: solid thin #000000;
height: 300px;
padding: 5px;
overflow: scroll;
text-align: left;
white-space: pre;
width: 500px;
}
#remained {
background-color: #cdcdcd;
}
#size {
color: #00cd00;
}
</style>
</head>
<body>
<?php
$fn = 'travian.sql';
$host = 'localhost';
$user = 'root';
$pass = '';
$db = 'travian';
if(file_exists($fn)) {
if(preg_match('#(.gz)$#i', $fn)) {
$zp = @gzopen($fn, 'rb');
if ($zp) {
$size = 0;
while(!gzeof($zp)) {
$size += strlen(gzread($zp, 1024));
}
gzclose($zp);
}
}
else {
$size = filesize($fn);
}
?>
<center>
<p><span id="elapsed"></span><span id="remained"><?php for($i = 0; $i < 100; $i++) { echo ' '; } ?></span></p>
<table>
<tr><td align="left">Filename:</td><th align="left"><span class="info" id="fn"><?php echo $fn; ?></span></th></tr>
<tr><td align="left">Host:</td><th align="left"><span class="info" id="host"><?php echo $host; ?></span></th></tr>
<tr><td align="left">Username:</td><th align="left"><span class="info" id="user"><?php echo $user; ?></span></th></tr>
<tr><td align="left">Password:</td><th align="left"><span class="info" id="pass"><?php echo $pass; ?></span></th></tr>
<tr><td align="left">Database:</td><th align="left"><span class="info" id="db"><?php echo $db; ?></span></th></tr>
</table>
<p>Current position: <span id="current">0</span>; Total size: <span id="size"><?php echo number_format($size, 0, '.', ','); ?></span> byte(s)</p>
Current Query:<p id="query"></p>
</center>
<?php
}
else {
header('Location: index.php');
?>
Insufficient Data. <a href="index.php">Try Again</a><br/>
<?php
exit();
}
?>
</body>
</html>
و فایل action.php رو دست نزنید. الآن تنها کاری که باقی مونده، اینه که یک لینک به فایل import.php بگذارین و به کاربر بگین صبر کنه تا import کامل بشه و بعد صفحه رو ببنده. مثال:
<a href="import.php" target="_blank">Import</a>
البته توی کدی که گفتم، بجای travian.sql اسم فایل Backup و بجای travian هم اسم دیتابیس خودتون رو بگذارین.
موفق باشید.