'; if (isset($_POST['restore'])){ if( $_POST['admin']==$ad_bs){ if($_FILES['restore_file']['type']!= "application/x-gzip"){ echo'

لابد أن يكون الملف بصيغة (sql.gz) عـــــودة

'; }else{ if (!is_uploaded_file($_FILES['restore_file']['tmp_name'])) { echo '

لم يتم رفع الملف عـــــودة

'; }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 '

تمت استعادة قاعدة البيانات بنجاح عـــــودة

'; } } }else{ echo'

كلمة السرغير صحيحة عـــــودة

'; } }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'

كلمة السرغير صحيحة عـــــودة

'; } }else{ echo '

النسخ الاحتياطي	الاستعادة (sql.gz)
سيتم نسخ قاعدة البيانات بصيغة (sql.gz) كلمة سر المدير	كلمة سر المدير

'; } //class download you can make it alone and include it /** @author Nguyen Quoc Bao @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 } } ?>