[ تمت الإجابة ]مشكلة في كود النسخ الأحتياطي

$dbhost = "localhost";
$db_name = "iman";
$dbuname = "root";
$dbpws = "root";
@mysql_connect("$dbhost", "$dbuname", "$dbpws");
@mysql_select_db("$db_name") or die ("Unable to select database");

$ad_bs="allah"; //admin password
echo '<html dir="rtl">
<head><title>النسخ الاحتياطي والاستعادة</title> <meta http-equiv="Content-Type" content="text/html; charset=windows-1256">
<style type="text/css">
table,td {
text-align: center;
font-weight:bold;
border: medium double #7BAE1C;
color: #1746C1;
background-color:#BFFFFF;
padding: 2% 2% 2% 2%;
}
th, .button, .h {
font-weight:bold;
font-family:carier;
border:medium double #00FF00;
color:#D559C8;
background-color:#FDECA6;
}
</style>
</head><body bgcolor=#DDD8C6>';
if (isset($_POST['restore'])){
if( $_POST['admin']==$ad_bs){
if($_FILES['restore_file']['type']!= "application/x-gzip"){
echo'<table align="center"><tr><td>لابد أن يكون الملف بصيغة (sql.gz)<br /><a href="'.$_SERVER['PHP_SELF'].'">عـــــودة</a></td></tr></table>';
}else{
if (!is_uploaded_file($_FILES['restore_file']['tmp_name'])) {
echo '<table align="center"><tr><td>لم يتم رفع الملف<br /><a href="'.$_SERVER['PHP_SELF'].'">عـــــودة</a></td></tr></table>';
}else{
$result = gzfile($_FILES['restore_file']['tmp_name']);
$results = preg_split("/;$/m", implode("",$result));
foreach ($results as $result){
@set_time_limit(1200);
@mysql_unbuffered_query($result);
}
echo '<table align="center"><tr><td>تمت استعادة قاعدة البيانات بنجاح <br /><a href="'.$_SERVER['PHP_SELF'].'">عـــــودة</a></td></tr></table>';
}
}
}else{
echo'<table align="center"><tr><td>كلمة السرغير صحيحة <br /><a href="'.$_SERVER['PHP_SELF'].'">عـــــودة</a></td></tr></table>';
}

}elseif(isset($_POST['backup'])){
if($_POST['admin']==$ad_bs){
$crlf = "\n";
ob_start();
@ob_implicit_flush(0);
mysql_query('SET SQL_QUOTE_SHOW_CREATE=1');
$result1 = mysql_query("SHOW tables");
while ($row1 = mysql_fetch_row($result1)) {
$table = $row1[0];
@set_time_limit(1200);
mysql_query("OPTIMIZE TABLE $table");
echo "DROP TABLE IF EXISTS `$table`;$crlf";
$row = mysql_fetch_row(mysql_query("SHOW CREATE TABLE $table"));
echo $row[1].";".$crlf;
$result = mysql_query("SELECT * FROM $table");
if ($result && @mysql_num_rows($result)) {
$column_list = "";
$num_fields= mysql_num_fields($result);
for ($i = 0; $i < $num_fields; $i++) {
$column_list .= (($column_list != "") ? ", " : "")."`".mysql_field_name($result, $i)."`";
}
}
$dump="INSERT INTO `$table` ($column_list) VALUES ";
while ($row = mysql_fetch_row($result)) {
$dump .= "(";
for ($i = 0; $i < $num_fields; $i++) {
$dump .= ($i > 0) ? ", " : "";
if (!isset($row[$i])) {
$dump .= "NULL";
} elseif ($row[$i] == "0" || $row[$i] != ""){
$type = mysql_field_type($result, $i);
if ($type == "tinyint" || $type == "smallint" || $type == "mediumint" || $type == "int" || $type == "bigint"|| $type == "timestamp") {
$dump .= $row[$i];
} else {
$search_array = array('\\', '\'', "\x00", "\x0a", "\x0d", "\x1a");
$replace_array = array('\\\\', '\\\'', '\0', '\n', '\r', '\Z');
$row[$i] = str_replace($search_array, $replace_array, $row[$i]);
$dump .= "'$row[$i]'";
}
} else {
$dump .= "''";
}
}
$dump .= "), ";
}
$dump.=';';
$dump=str_replace("INSERT INTO `$table` ($column_list) VALUES ;", "", $dump);
$dump=str_replace(", ;", ";", $dump);
echo $dump.$crlf;
}
$contents = ob_get_contents();
ob_end_clean();
$file = $db_name."_".date("Y-m-d_H-i-s").".sql";
$object = new httpdownload;
$object->use_resume = false;
$object->set_mime("application/x-gzip gz tgz");
$object->set_bydata(gzencode($contents, 9));
$object->set_filename($file.".gz");
$object->download();
exit;
}else{
echo'<table align="center"><tr><td>كلمة السرغير صحيحة <br /><a href="'.$_SERVER['PHP_SELF'].'">عـــــودة</a></td></tr></table>';
}

}else{
echo '<table align="center"><tr><th>النسخ الاحتياطي</th><th>الاستعادة (sql.gz)</th></tr><tr><td>
<form name="frmbackup" method="post" action="'.$_SERVER['PHP_SELF'].'">سيتم نسخ قاعدة البيانات بصيغة (sql.gz) <br />
كلمة سر المدير<input name="admin" type="password" value=""><br /><input type="submit" name="backup" class="button" value="نسخ احتياطي"></form></td>
<td>
<form name="frmrestore" method="post" action="'.$_SERVER['PHP_SELF'].'" enctype="multipart/form-data" >
<input type="file" name="restore_file" /><br />كلمة سر المدير<input name="admin" type="password" value=""><br /><input type="submit" name="restore" class="button" value="استعـــادة" /></form>
</td></tr><tr><td colspan="2" class="h"><a href="http://alostaz.coolpage.biz">برمجة الأستاذ / محمد صالح</a></td></tr></table>';
}

//class download you can make it alone and include it
/**
@author Nguyen Quoc Bao <quocbao.coder@gmail.com>
@version 1.3
@desc A simple object for processing download operation , support section downloading
Please send me an email if you find some bug or it doesn't work with download manager.
I've tested it with
- Reget
- FDM
- FlashGet
- GetRight
- DAP

@copyright It's free as long as you keep this header .
@example

1: File Download
$object = new downloader;
$object->set_byfile($filename); //Download from a file
$object->use_resume = true; //Enable Resume Mode
$object->download(); //Download File

2: Data Download
$object = new downloader;
$object->set_bydata($data); //Download from php data
$object->use_resume = true; //Enable Resume Mode
$object->set_filename($filename); //Set download name
$object->set_mime($mime); //File MIME (Default: application/otect-stream)
$object->download(); //Download File

3: Manual Download
$object = new downloader;
$object->set_filename($filename);
$object->download_ex($size);
//output your data here , remember to use $this->seek_start and $this->seek_end value :)

**/

class httpdownload {

var $data = null;
var $data_len = 0;
var $data_mod = 0;
var $data_type = 0;
var $data_section = 0; //section download
/**
* @var ObjectHandler
**/
var $handler = array('auth' => null);
var $use_resume = true;
var $use_autoexit = false;
var $use_auth = false;
var $filename = null;
var $mime = null;
var $bufsize = 2048;
var $seek_start = 0;
var $seek_end = -1;

/**
* Total bandwidth has been used for this download
* @var int
*/
var $bandwidth = 0;
/**
* Speed limit
* @var float
*/
var $speed = 0;

/*-------------------
| Download Function |
-------------------*/
/**
* Check authentication and get seek position
* @return bool
**/
function initialize() {
global $HTTP_SERVER_VARS;

if ($this->use_auth) //use authentication
{
if (!$this->_auth()) //no authentication
{
header('WWW-Authenticate: Basic realm="Please enter your username and password"');
header('HTTP/1.0 401 Unauthorized');
header('status: 401 Unauthorized');
if ($this->use_autoexit) exit();
return false;
}
}
if ($this->mime == null) $this->mime = "application/octet-stream"; //default mime

if (isset($_SERVER['HTTP_RANGE']) || isset($HTTP_SERVER_VARS['HTTP_RANGE']))
{

if (isset($HTTP_SERVER_VARS['HTTP_RANGE'])) $seek_range = substr($HTTP_SERVER_VARS['HTTP_RANGE'] , strlen('bytes='));
else $seek_range = substr($_SERVER['HTTP_RANGE'] , strlen('bytes='));

$range = explode('-',$seek_range);

if ($range[0] > 0)
{
$this->seek_start = intval($range[0]);
}

if ($range[1] > 0) $this->seek_end = intval($range[1]);
else $this->seek_end = -1;

if (!$this->use_resume)
{
$this->seek_start = 0;

//header("HTTP/1.0 404 Bad Request");
//header("Status: 400 Bad Request");

//exit;

//return false;
}
else
{
$this->data_section = 1;
}

}
else
{
$this->seek_start = 0;
$this->seek_end = -1;
}

return true;
}
/**
* Send download information header
**/
function header($size,$seek_start=null,$seek_end=null) {
header('Content-type: ' . $this->mime);
header('Content-Disposition: attachment; filename="' . $this->filename . '"');
header('Last-Modified: ' . date('D, d M Y H:i:s \G\M\T' , $this->data_mod));

if ($this->data_section && $this->use_resume)
{
header("HTTP/1.0 206 Partial Content");
header("Status: 206 Partial Content");
header('Accept-Ranges: bytes');
header("Content-Range: bytes $seek_start-$seek_end/$size");
header("Content-Length: " . ($seek_end - $seek_start + 1));
}
else
{
header("Content-Length: $size");
}
}

function download_ex($size)
{
if (!$this->initialize()) return false;
ignore_user_abort(true);
//Use seek end here
if ($this->seek_start > ($size - 1)) $this->seek_start = 0;
if ($this->seek_end <= 0) $this->seek_end = $size - 1;
$this->header($size,$seek,$this->seek_end);
$this->data_mod = time();
return true;
}

/**
* Start download
* @return bool
**/
function download() {
if (!$this->initialize()) return false;

$seek = $this->seek_start;
$speed = $this->speed;
$bufsize = $this->bufsize;
$packet = 1;

//do some clean up
@ob_end_clean();
$old_status = ignore_user_abort(true);
@set_time_limit(0);
$this->bandwidth = 0;

$size = $this->data_len;

if ($this->data_type == 0) //download from a file
{

$size = filesize($this->data);
if ($seek > ($size - 1)) $seek = 0;
if ($this->filename == null) $this->filename = basename($this->data);

$res = fopen($this->data,'rb');
if ($seek) fseek($res , $seek);
if ($this->seek_end < $seek) $this->seek_end = $size - 1;

$this->header($size,$seek,$this->seek_end); //always use the last seek
$size = $this->seek_end - $seek + 1;

while (!(connection_aborted() || connection_status() == 1) && $size > 0)
{
if ($size < $bufsize)
{
echo fread($res , $size);
$this->bandwidth += $size;
}
else
{
echo fread($res , $bufsize);
$this->bandwidth += $bufsize;
}

$size -= $bufsize;
flush();

if ($speed > 0 && ($this->bandwidth > $speed*$packet*1024))
{
sleep(1);
$packet++;
}
}
fclose($res);

}

elseif ($this->data_type == 1) //download from a string
{
if ($seek > ($size - 1)) $seek = 0;
if ($this->seek_end < $seek) $this->seek_end = $this->data_len - 1;
$this->data = substr($this->data , $seek , $this->seek_end - $seek + 1);
if ($this->filename == null) $this->filename = time();
$size = strlen($this->data);
$this->header($this->data_len,$seek,$this->seek_end);
while (!connection_aborted() && $size > 0) {
if ($size < $bufsize)
{
$this->bandwidth += $size;
}
else
{
$this->bandwidth += $bufsize;
}

echo substr($this->data , 0 , $bufsize);
$this->data = substr($this->data , $bufsize);

$size -= $bufsize;
flush();

if ($speed > 0 && ($this->bandwidth > $speed*$packet*1024))
{
sleep(1);
$packet++;
}
}
} else if ($this->data_type == 2) {
//just send a redirect header
header('location: ' . $this->data);
}

if ($this->use_autoexit) exit();

//restore old status
ignore_user_abort($old_status);
@set_time_limit(ini_get("max_execution_time"));

return true;
}

function set_byfile($dir) {
if (is_readable($dir) && is_file($dir)) {
$this->data_len = 0;
$this->data = $dir;
$this->data_type = 0;
$this->data_mod = filemtime($dir);
return true;
} else return false;
}

function set_bydata($data) {
if ($data == '') return false;
$this->data = $data;
$this->data_len = strlen($data);
$this->data_type = 1;
$this->data_mod = time();
return true;
}

function set_byurl($data) {
$this->data = $data;
$this->data_len = 0;
$this->data_type = 2;
return true;
}

function set_filename($filename) {
$this->filename = $filename;
}

function set_mime($mime) {
$this->mime = $mime;
}

function set_lastmodtime($time) {
$time = intval($time);
if ($time <= 0) $time = time();
$this->data_mod = $time;
}

/**
* Check authentication
* @return bool
**/
function _auth() {
if (!isset($_SERVER['PHP_AUTH_USER'])) return false;
if (isset($this->handler['auth']) && function_exists($this->handler['auth']))
{
return $this->handler['auth']('auth' , $_SERVER['PHP_AUTH_USER'],$_SERVER['PHP_AUTH_PW']);
}
else return true; //you must use a handler
}

}

?>

<?php