Location: PHPKode > scripts > MySQL Backup Pro > mysql-backup-pro/libs/backup.class.php
<?php

define ('_CONNECTION_ERROR_',"DB Connection error, please <a href=\"?option=databaseAdmin&go=config\">configure</a> your application.");

/**
 * backup class : Backup class
 * 
 * @package 
 * @author Ben Yacoub Hatem <hide@address.com>
 * @website http://www.phptunisie.net/
 * @copyright Copyright (c) 2004
 * @version $Id$ - 10/03/2004 15:22:00 - backup.class.php
 * @access public
 **/
class backup extends db{


	var $backupdir = "backup";
	var $compression = "bz2";
	var $color1 = "#F57E1D";
	var $color2 = "#F5F6C4";
	var $color3 = "#FFFF40";
	var $mysqldump = true;
	var $default_sort_order = "DateDesc";
	var $file_mod = "0777";

	/**
     * Constructor
     * @access protected
     */
	function backup(){
		global $GonxAdmin;
		$this->compression = $GonxAdmin["compression_default"];
	}
	
	/**
	 * backup::version()	Return class version
	 * 
	 * @return 
	 **/
	function version(){
		return "1.0.8-PRE2";
	}

	
	/**
	 *
	 * @access public
	 * @return void 
	 **/
	function tables_menu(){
		global $GONX;
		
		$color3 = $this->color3;
		$color2 = $this->color2;
		$color1 = $this->color1;
		
		$res = "\n<form action='?go=backuptables' method='post'>
<table border=0 cellpadding=5>
<tr bgcolor=\"$color1\">
\t<th>Table</th>
\t<th>Rows</th>
\t<th>Create_time</th>
\t<th>Update_time</th>
\t<th>Check_time</th>
</tr>\n\n";

        $result =  $this->query('SHOW TABLE STATUS');
		$i = 0;		$bgcolor = $color3;
        while ($table = @$this->fetch_array($result)) {
			if ($table["Update_time"]!=$table["Create_time"]) {
			    $l1 = "<label for=\"tables$i\">";
				$l2 = "</label>";
			} else {
				$l1 = $l2 = "";
			};
			$res .= "<tr bgcolor=\"$bgcolor\">
\t<th align=left><input type='checkbox' id='tables$i' name='tables[]' value='".$table["Name"]."' /> ".$table["Name"]."</th>
\t<td>".$table["Rows"]."</td>
\t<td>$l1".$table["Create_time"]."$l2</td>
\t<td>$l1".$table["Update_time"]."$l2</td>
\t<td>".$table["Check_time"]."</td>
</tr>
";
			if ($bgcolor==$color3) {
			    $bgcolor = $color2;
			} else $bgcolor = $color3;
			$i++;
		}
		
		$res .= "</table>
<input type='checkbox' name='structonly' value='Yes'> ".$GONX["structonly"]."<br><br>
<input type='radio' name='chg' onclick='for(i=0;i<$i;i++){document.getElementById(\"tables\"+i).checked=true;}'> ".$GONX["checkall"]." &nbsp;&nbsp;
<input type='radio' name='chg' onclick='for(i=0;i<$i;i++){document.getElementById(\"tables\"+i).checked=false;}'> ".$GONX["uncheckall"]." &nbsp;&nbsp;
<p align=right><input type='submit' class='button'></p>
".$GONX["tablesmenuhelp"]."
</form>\n";
		return $res;
	}
	
	/**
	 *
	 * @access public
	 * @return void 
	 **/
	function tables_backup($tables,$structonly){
		global $GONX;
		foreach($tables as $v){
            $res = $this-> query("SHOW CREATE TABLE " . $this -> dbName . "." .$v);
            while ($resu[] = $this -> get_data()) {
            } 
		}

        foreach($resu as $key => $val) {
			$tbl_name_status = $this->valid_table_name($val[0]);
            if (trim($val[0]) !== "" and $tbl_name_status) {
                $Dx_Create_Tables .= "
# Drop table '" . $val[0] . "' if exist
<xquery>
DROP TABLE IF EXISTS " . $val[0] . ";
</xquery>
# create table '" . $val[0] . "'
<xquery>
" . $val[1] . " ;
</xquery>\r\n";
		if ($structonly!="Yes") {
                $query = "Insert into `$val[0]` (";
				$this -> query("LOCK TABLES $val[0] WRITE");
                $qresult = $this -> query("Select * from $val[0]");
                while ($line = $this -> fetch_array($qresult)) {
                    unset($fields, $values);
					$j = 0;
                    while (list($col_name, $col_value) = each($line)) {
                        if (!is_int($col_name)) {
                            $fields .= "`$col_name`,";
							$values .= "'" . $this->escape_string($col_value) . "',";
                        } 
                    } 

                    $fields = substr($fields, 0, strlen($fields)-1);
                    $values = substr($values, 0, strlen($values)-1);
                    $myquery = $query . $fields . ") values (" . $values . ");";
                    $Dx_Create_Tables .= "\r\n<xquery>
" . $myquery . "
</xquery>\r\n" ;
                } 
				$this -> query("UNLOCK TABLES;");		    
		}
            } elseif (!$tbl_name_status){
				$err_msg .= "<font color=red>".$GONX["ignoredtables"]." ".$val[0]." - ".$GONX["reservedwords"].".</font><br>\n";
			}
        } 
		
		if (!is_dir($this->backupdir)) {
		    @mkdir($this->backupdir,0755);
		}
		if (sizeof($tables)==1) {
		    $prefix = "[".$tables[0]."]";
		} else $prefix = "[".sizeof($tables)."tables]";
		switch($this->compression){
			case "bz2": 
				$fname = $this->dbName."-$prefix-".date("Y-m-d H-i-s").".bz2";
				touch($this->backupdir."/".$fname);
				$fp = bzopen($this->backupdir."/".$fname, "w");
				bzwrite($fp, $Dx_Create_Tables);
				bzclose($fp);
			break;
			
		    case "zlib": 
				$fname = $this->dbName."-$prefix-".date("Y-m-d H-i-s").".gz";
				touch($this->backupdir."/".$fname);
				$fp = gzopen($this->backupdir."/".$fname, "w");
				gzwrite($fp, $Dx_Create_Tables);
				gzclose($fp);
			break;
		
			default:
				$fname = $this->dbName."-$prefix-".date("Y-m-d H-i-s").".sql";
				touch($this->backupdir."/".$fname);
				$fp = fopen($this->backupdir."/".$fname, "w");
				fwrite($fp, $Dx_Create_Tables);
				fclose($fp);
			break;
		} // switch
        return "$err_msg<font color=green>".$GONX["backup"]." ".$this->dbName." ".$GONX["iscorrectcreat"]." : ".$this->backupdir."/$fname</font>";
	}
	
	
	/**
	 * backup::generate()		Create a backup file of the DB
	 * 
	 * @return 
	 **/
	function generate(){
		global $GONX;
        $result =  @$this->list_tables($this->dbName);
        while ($table = @$this->fetch_row($result)) {
            $res = $this-> query("SHOW CREATE TABLE " . $this -> dbName . "." . $table[0]);

            while ($resu[] = $this -> get_data()) {
            } 
        } 
        foreach($resu as $key => $val) {
			$tbl_name_status = $this->valid_table_name($val[0]);
            if (trim($val[0]) !== "" and $tbl_name_status) {
                $Dx_Create_Tables .= "
# Drop table '" . $val[0] . "' if exist
<xquery>
DROP TABLE IF EXISTS " . $val[0] . ";
</xquery>
# create table '" . $val[0] . "'
<xquery>
" . $val[1] . " ;
</xquery>\r\n";

                $query = "Insert into `$val[0]` (";
				$this -> query("LOCK TABLES $val[0] WRITE");
                $qresult = $this -> query("Select * from $val[0]");
                while ($line = $this -> fetch_array($qresult)) {
                    unset($fields, $values);
					$j = 0;
                    while (list($col_name, $col_value) = each($line)) {
                        if (!is_int($col_name)) {
                            $fields .= "`$col_name`,";
							$values .= "'" . $this->escape_string($col_value) . "',";
                        } 
                    } 

                    $fields = substr($fields, 0, strlen($fields)-1);
                    $values = substr($values, 0, strlen($values)-1);
                    $myquery = $query . $fields . ") values (" . $values . ");";
                    $Dx_Create_Tables .= "\r\n<xquery>
" . $myquery . "
</xquery>\r\n" ;
                } 
				$this -> query("UNLOCK TABLES;");
            }  elseif (!$tbl_name_status){
				$err_msg .= "<font color=red>Ignored table ".$val[0]." - Reserved SQL word.</font><br>\n";
			}
        } 
		
		if (!is_dir($this->backupdir)) {
		    @mkdir($this->backupdir,octdec($this->file_mod));
		}
		switch($this->compression){
			case "bz2": 
				$fname = $this->dbName."-".date("Y-m-d H-i-s").".bz2";
				touch($this->backupdir."/".$fname);
				$fp = bzopen($this->backupdir."/".$fname, "w");
				bzwrite($fp, $Dx_Create_Tables);
				bzclose($fp);
			break;
			
		    case "zlib": 
				$fname = $this->dbName."-".date("Y-m-d H-i-s").".gz";
				touch($this->backupdir."/".$fname);
				$fp = gzopen($this->backupdir."/".$fname, "w");
				gzwrite($fp, $Dx_Create_Tables);
				gzclose($fp);
			break;
		
			default:
				$fname = $this->dbName."-".date("Y-m-d H-i-s").".sql";
				touch($this->backupdir."/".$fname);
				$fp = fopen($this->backupdir."/".$fname, "w");
				fwrite($fp, $Dx_Create_Tables);
				fclose($fp);
			break;
		} // switch
        return "$err_msg<font color=green>".$GONX["backup"]." ".$this->dbName." ".$GONX["iscorrectcreat"]." : ".$this->backupdir."/$fname</font>";
	}

	/**
	 * backup::import()		Import a Backup file to DB
	 * 
	 * @param string $bfile
	 * @return 
	 **/
	function import($bfile = ""){
		global $GONX,$GonxAdmin;
		set_time_limit(0);

		if (isset($_GET["importdump"])) {
		    if (is_file($this->backupdir."/".$bfile)) {
				switch($GonxAdmin["compression_default"]){
					case "bz2": 
						$bz = bzopen($this->backupdir."/".$bfile, "r");
						while (!feof($bz)) {
	  						  $contents .= bzread($bz, 4096);
						}
	//					$contents = bzread($bz, filesize($this->backupdir."/".$bfile)*1000); // just a hack coz feof doesn't wrk for me
						bzclose($bz);
					break;
					
				    case "zlib": 
						$bz = gzopen($this->backupdir."/".$bfile, "r");
						$contents = gzread($bz, filesize($this->backupdir."/".$bfile)*1000); // just a hack coz feof doesn't wrk for me
						gzclose($bz);
					break;
				
					default:
						$bz = fopen($this->backupdir."/".$bfile, "r");
						$contents = fread($bz, filesize($this->backupdir."/".$bfile)*1000); // just a hack coz feof doesn't wrk for me
						fclose($bz);
					break;
				} // switch
				

				// Convert to mysql dump format
				$contents = str_replace("<xquery>", "", $contents);
				$contents = str_replace("</xquery>", "", $contents);

				// Create temporary file
				touch($this->backupdir."/temp.sql");
				$fp = fopen($this->backupdir."/temp.sql", "w");
				fwrite($fp, $contents);
				fclose($fp); unset($contents);

				// Execute MySQL Dump
				@shell_exec($GonxAdmin["mysqldump"]." --host ".$GonxAdmin["dbhost"]." --user=".$GonxAdmin["dbuser"]." --pass=".$GonxAdmin["dbpass"]." --databases ".$GonxAdmin["dbname"]." < ".$this->backupdir."/temp.sql");

				// Remove the temporary file.
				@unlink($this->backupdir."/temp.sql");
				return "<font color=green> $bfile ".$GONX["iscorrectimport"]." </font>";
			} else return FALSE;
		}

		if (is_file($this->backupdir."/".$bfile)) { // File existe, import it
			switch($GonxAdmin["compression_default"]){
				case "bz2": 
					$bz = bzopen($this->backupdir."/".$bfile, "r");
					while (!feof($bz)) {
  						  $contents .= bzread($bz, 4096);
					}
//					$contents = bzread($bz, filesize($this->backupdir."/".$bfile)*1000); // just a hack coz feof doesn't wrk for me
					bzclose($bz);
				break;
				
			    case "zlib": 
					$bz = gzopen($this->backupdir."/".$bfile, "r");
					$contents = gzread($bz, filesize($this->backupdir."/".$bfile)*1000); // just a hack coz feof doesn't wrk for me
					gzclose($bz);
				break;
			
				default:
					$bz = fopen($this->backupdir."/".$bfile, "r");
					$contents = fread($bz, filesize($this->backupdir."/".$bfile)*1000); // just a hack coz feof doesn't wrk for me
					fclose($bz);
				break;
			} // switch

            preg_match_all("'<xquery[?>]*?>(.*?)</xquery>'si" , $contents, $requetes);
            //<?
			unset($contents);
            foreach($requetes[1] as $key => $val) {
                $this -> query(trim($val));
            }
			return "<font color=green> $bfile ".$GONX["iscorrectimport"]." </font>";
		} else {	// Erronous file, read dir, and list available backup file.
			return false;
		}
	}
	
	/**
	 * backup::importfromfile()		Download and Import a Backup file to DB
	 * 
	 * @param string $bfile
	 * @return 
	 **/
	function importfromfile(){
		global $GONX,$HTTP_POST_FILES;
		@set_time_limit(0);

		
		$bfile = $HTTP_POST_FILES["backupfile"];
		$pathinfo = pathinfo($bfile["name"]);
		$compression = $pathinfo["extension"];
				
		if ($bfile["error"]==0) { // File existe, import it
			switch($compression){
				case "bz2": 
					$bz = bzopen($bfile["tmp_name"], "r");
					$contents = bzread($bz, $bfile["size"]); // just a hack coz feof doesn't wrk for me
					bzclose($bz);
				break;
				
			    case "gz": 
					$gz = gzopen($bfile["tmp_name"], "r");
					$contents = gzread($gz, $bfile["size"]); // just a hack coz feof doesn't wrk for me
					bzclose($gz);
				break;
			
				default:
					$f = fopen($bfile["tmp_name"], "r");
					$contents = fread($f, $bfile["size"]); // just a hack coz feof doesn't wrk for me
					fclose($f);
				break;
			} // switch
			

            preg_match_all("'<xquery[?>]*?>(.*?)</xquery>'si" , $contents, $requetes);
            //<?
            foreach($requetes[1] as $key => $val) {
                $this -> query(trim($val));
            }
			return "<font color=green> ".$bfile["name"]." ".$GONX["iscorrectimport"]." </font>";
		} else {	// Erronous file, read dir, and list available backup file.
			return $this->listbackups();
		}
	}
	
	/**
	 * backup::listbackups()		List available backup
	 * 
	 * @return 
	 **/
	function listbackups(){
		global $GONX,$GonxAdmin,$page,$orderby;
		$pagesize = $GonxAdmin["pagedisplay"];
		$GonxOrder = array("DateAsc","NameAsc","NameDesc","SizeAsc","SizeDesc","DateDesc");
		if ($orderby=="" or !in_array($orderby,$GonxOrder )) {
		    $orderby = $this->default_sort_order;
		}
		
		if( !isset( $page ) or ($page<=0) ){

			$page = 1;

			$from = $page-1;

			$to = ($pagesize*$page);

		} elseif ($page ==1){

			$from = 0;

			$to = ($pagesize*($page+1)-$pagesize);

		} else {

			$from = $pagesize * ($page-1);

			$to = ($pagesize*($page+1)-$page *$pagesize);

		}
		$res = "
<script language=\"JavaScript\" type=\"text/javascript\">
<!--
//author Philippe BENVENISTE  <hide@address.com>
//copyright Pommef - IdŽes et Changements (c) 2004

function IECColor1(el) {	
	IEC_obj2.IECColor(el);
	IEC_obj1.IECColor(el);
}


function IECColor2(el){

	IEC_obj1.IECColor(el);
	IEC_obj2.IECColor(el);
	
	if(ConfirmDelete()){
	
		return true;
		
	} else {
	
		document.getElementById(el).style.background = IEC_obj1.BG2;
		document.forms[\"bform\"].reset();
		
		return false;
	}					
}

function IECColorClass(BG1, BG2){

	this.gvar = 10000;
	this.BG1 = BG1;
	this.BG2 = BG2;
	this.IECColor=IECColor;
}

function IECColor(el) {	

	document.getElementById(el).style.background = this.BG1;

	if(this.gvar < 9000 && this.gvar != el)
		document.getElementById(this.gvar).style.background = this.BG2;	
	
	this.gvar = el;
}

IEC_obj1 = new IECColorClass('khaki','#F6F6F6'); 
IEC_obj2 = new IECColorClass('#CF2B5A','#F6F6F6');


//-->
</script>
<form method=get action=\"?\" name=bform><b>".$GONX["selectbackupfile"]." :</b><br/><br/>\n";
		if (!is_dir($this->backupdir)) {
		    @mkdir($this->backupdir,octdec($this->file_mod));
		}
		$d = dir($this->backupdir);
		$i = $BackupSize = 0;
		while (false !== ($entry = $d->read())) {
			if ($entry!="." and $entry!=".." and (ereg(".bz2$",$entry) or ereg(".gz$",$entry) or ereg(".sql$",$entry))) {
				$mtime = date ("F d Y H:i:s.", filemtime($this->backupdir."/".$entry));
				$time = filemtime($this->backupdir."/".$entry);
				$size = filesize($this->backupdir."/".$entry);
				$fsize = round($size/1024);
				
				$GonxBackups[$i]["fname"] = $entry;
				$GonxBackups[$i]["mtime"] = $mtime;
				$GonxBackups[$i]["time"] = $time;
				$GonxBackups[$i]["fsize"] = $fsize;
				$GonxBackups[$i]["size"] = $size;			
				$BackupSize += $fsize;
				$i++;
			}
		}
		if ($i==0) {
		    $res .= "<ul><li>".$GONX["nobckupfile"]."</li></ul>";
		} else {
			/**
			* Pagination
			*/
			$allpages = round(sizeof($GonxBackups)/$pagesize); 

			$all_rest = $allpages - $allpages*$pagesize;

			if ($all_rest > 0) {$allpages++; }

			if ($page<$allpages)
			{
				$next = "<a href=\"?option=databaseAdmin&go=list&amp;page=".($page+1)."&orderby=$orderby\" class=tab-s>".$GONX["next"]."</a>";
			} else $next="";
			if ($page>1)
			{
				$prev = "<a href=\"?option=databaseAdmin&go=list&amp;page=".($page-1)."&orderby=$orderby\" class=tab-s>".$GONX["prev"]."</a>";
			} else $prev ="";
			$links = "";
			for ($i=0; $i<$allpages; $i++)
			{
				if (($i+1) == $page)
				{
					$links .= "<span class=tab-s> ".($i+1)." </span>";
				} else {
					$links .= "<a href=\"?option=databaseAdmin&go=list&amp;page=".($i+1)."&orderby=$orderby\" class=tab-g> ".($i+1)." </a>";
				}
			}
			/**
			* Order by
			*/
			$OrderMenu = "<select class=button OnChange=\"location.href='?option=databaseAdmin&go=list&page=$page&orderby='+ChgOrder.options[selectedIndex].value\" name=\"ChgOrder\">\n";
			foreach($GonxOrder as $v){
				if ($v==$orderby) {
				    $sel = " selected";
				} else $sel ="";
				$OrderMenu .= "<option$sel value=\"$v\">$v</option>\n";
			}
			$OrderMenu .= "</select>\n";
			switch($orderby){
				case "DateAsc": 
					usort($GonxBackups, array("backup","DateSortAsc"));
				break;
				
			    case "NameAsc": 
					usort($GonxBackups, array("backup","NameSortAsc"));
				break;

			    case "NameDesc": 
					usort($GonxBackups, array("backup","NameSortDesc"));
				break;
				
			    case "SizeAsc": 
					usort($GonxBackups, array("backup","SizeSortAsc"));
				break;
				
			    case "SizeDesc": 
					usort($GonxBackups, array("backup","SizeSortDesc"));
				break;
			
				default:
					usort($GonxBackups, array("backup","DateSortDesc"));
				break;
			} // switch
			
			if (is_array($GonxBackups)) {
			    $GonxBackups = array_slice($GonxBackups, $from,$to);
			}
			$res .= "\n<table align=\"center\" width=90%>
			<tr>
			<td width=10%>$prev</td>
			<td width=80% align=\"center\"> $links</td>
			<td width=10% align=\"right\">$next</td>
			</tr></table>\n<br/>
			<table align=\"center\" width=100% cellspacing=0>
\t<tr>
			<th></th>
			<th>DB</th>
			<th>Download</th>
			<th>Size</th>
			<th>Date</th>
			<th>Delete<th>
</tr>\n";


			foreach($GonxBackups as $k=>$v){
				$db = explode("-",$v['fname'] );
				$db = $db[0];
				$res .= "\t<tr id=$k>
			<td><input type=\"radio\" name=\"bfile\" value=\"".$v['fname']."\" onclick=\"IECColor1($k);\"></td>
			<th>$db</th>
			<td align=center><font size=2px> <a href=\"?option=databaseAdmin&go=getbackup&bfile=".urlencode($v['fname'])."\" target=\"_new\" title=\"Download ".$v['fname']."\">".$v['fname']."</a></td>
			<td align=center><em>size ".$v['fsize']." Ko</em></td>
			<td align=center>".$v['mtime']."</td>
			<td align=center><a href=\"?option=databaseAdmin&go=delete&fname=".$v['fname']."\" title=\"".$GONX["delete"]." ".$v['fname']."\" onclick=\"return IECColor2($k);\"><img src=\"image.php?img=delete_gif\" border=0></a></font><td>
</tr>\n\n";

			}
		$BackupSize = number_format(($BackupSize/1024),3  );
		$res .= "</table><br/><br/><em>".$GONX["totalbackupsize"]." : $BackupSize Mo</em> - ".$GONX["chgdisplayorder"]." : $OrderMenu
		<br/><br/><input type=hidden name=go value=import>
		<p align=right>";
		
		if($this->mysqldump)
			$res .="<input type=submit name=importdump value=\"".$GONX["importbackupdump"]."\" class=button>";
		
		$res .="  <input type=submit name=import value=\"".$GONX["importbackup"]."\" class=button></p></form>\n";
		$res .= "<form method=post action=\"?\" enctype=\"multipart/form-data\"><b>".$GONX["importbackupfile"]." :</b><br/><br/>
		<input type=file name=backupfile class=button>
		<br/><br/><input type=hidden name=go value=importfromfile>
		<p align=right><input type=submit name=import value=\"".$GONX["importbackup"]."\" class=button></p></form>\n";	
		}
		

		$d->close();
		return $res;
	}
	

	/**
	 * backup::NameSortAsc()
	 * 
	 * @param $a
	 * @param $b
	 * @return 
	 **/
	function NameSortAsc($a, $b) {
	
	    return strcmp($a["fname"], $b["fname"]);
	
	}
	
	/**
	 * backup::NameSortDesc()
	 * 
	 * @param $a
	 * @param $b
	 * @return 
	 **/
	function NameSortDesc($a, $b) {
	
	    return !strcmp($a["fname"], $b["fname"]);
	
	}
	
	/**
	 * backup::SizeSortAsc()
	 * 
	 * @param $a
	 * @param $b
	 * @return 
	 **/
	function SizeSortAsc($a, $b) {
	
		return ($a["size"]>$b["size"])?1:-1;
	
	}
	
	/**
	 * backup::SizeSortDesc()
	 * 
	 * @param $a
	 * @param $b
	 * @return 
	 **/
	function SizeSortDesc($a, $b) {
	
		return ($a["size"]<$b["size"])?1:-1;
	
	}
	
	/**
	 * backup::DateSortAsc()
	 * 
	 * @param $a
	 * @param $b
	 * @return 
	 **/
	function DateSortAsc($a, $b) {
	
		return ($a["time"]>$b["time"])?1:-1;
	
	}
	
	/**
	 * backup::DateSortDesc()
	 * 
	 * @param $a
	 * @param $b
	 * @return 
	 **/
	function DateSortDesc($a, $b) {

		return ($a["time"]<$b["time"])?1:-1;
	
	}
	
	/**
	 * backup::delete()	delete a backup file based on its name
	 * 
	 * @param $_fname
	 * @return 
	 **/
	function delete($_fname){
		if (is_file($this->backupdir."/".$_fname)) {
			unlink($this->backupdir."/".$_fname);
			return "<font color=green> Backup file $_fname is correctly removed </font>";
		} else return "<font color=red> Error while removing backup file $_fname</font>";
	}
	
	/**
	 * backup::keep()		Keep backup files for a limited period of days and remove all others
	 * 
	 * @param integer $days
	 * @return 
	 **/
	function keep($days = 4){
		if (is_dir($this->backupdir)) {
			$d = dir($this->backupdir);
			while (false !== ($entry = $d->read())) {
				if ($entry!="." and $entry!=".." and (ereg(".bz2$",$entry) or ereg(".gz$",$entry) or ereg(".sql$",$entry))) {
					if ((filemtime($this->backupdir."/".$entry)) < (strtotime('-'.$days.' days'))) {
						$this->delete($entry);
					}
				}
			}
		}
	}
	
	/**
	 * method optimize : execute an operation in all db table
	 * 
	 * @param	$operation	operation to execute on DB
	 * 
	 * @access public
	 * @return void 
	 **/
	function optimize($operation = "OPTIMIZE"){
		global $GonxAdmin;
		if ($GonxAdmin["dbtype"]!="mysql") {
		    return "Sorry this feature is available for only MySQL Databases.";
		}
		if ($operation!= "OPTIMIZE" or $operation!= "ANALYZE" or $operation!= "REPAIR") {
		    $operation = "OPTIMIZE";
		}
	$color3 = $this->color3;
		$color2 = $this->color2;
		$color1 = $this->color1;
		
		$Tables = $this->get_db_tables();
		$query = "$operation TABLE ";
		foreach($Tables as $k=>$v){
			$query .= " `$v`,";
		}
		$query = substr($query,0,strlen($query)-1);
		$result = $this->query($query);
		$res = "<table border=\"0\" cellpadding=\"5\" align=center>\n";
		$res .= "<tr>
<th bgcolor=\"$color1\">Table</font></th>
<th bgcolor=\"$color1\">Op</font></th>
<th bgcolor=\"$color1\">Msg_type</font></th>
<th bgcolor=\"$color1\">Msg_text</font></th>
</tr>";
		$bgcolor = $color3;
		while ($line = $this->fetch_array($result)) {
	        $res .= "\t<tr>\n";
	        foreach ($line as $k=>$col_value) {
				if (!is_numeric($k)) {
					if ($col_value == "OK") {
					    $optimize = " <a href=\"?option=databaseAdmin&go=optimize&op=OPTIMIZE\" class=tab-s>Optimize DB</a>";
					} else $optimize="";
		            $res .= "\t\t<td valign=\"top\"  bgcolor=\"$bgcolor\">$col_value $optimize</td>\n";   
				}
	        }
	        $res .= "\t</tr>\n";
			if ($bgcolor==$color3) {
			    $bgcolor = $color2;
			} else $bgcolor = $color3;
	    }
		$res .= "</table>\n";			
		return $res;
	}
	
	/**
	 * backup::configure()	Configuration menu for the application
	 * 
	 * @return 
	 **/
	function configure(){
		global $GONX;
		$filename = "init.php";
//		$perms = fileperms ($filename);
		$contents = implode('',file($filename));
		preg_match_all("|(.*)=(.*);|U",$contents ,$matches );
$initform = "<form action=\"?\" method=post>
<table class=config cellspacing=0 cellpadding=4>
  <tr><td colspan=2><b>".$GONX["configureapp"]."</b></td></tr>\n\n
  <tr align=center><th width=50%><i>Variable</i></th><th width=50%><i>Value</i></th></tr>\n\n";
foreach($matches[1] as $k=>$v){
	if (ereg("<?php",$v)) {
	    $v = str_replace("<?php","" , $v);
	}
	$v = trim($v);
	$value = trim(htmlentities($matches[2][$k]));
	$initform .= "  <tr><td>$v</td><td><input type=text size=40 name=vars[$k] value=\"$value\"></td></tr>\n\n";
}
$initform .= " 
</table>
<p align=right><input type=submit  style=\"width:200\"  class=button></p>
<input type=hidden name=go value=saveconfig>
</form>\n\n";
		return $initform ;
	}
	
	/**
	 * backup::saveconfig()		Save configuration to init.php
	 * 
	 * @return 
	 **/
	function saveconfig(){
		global $vars;
		$filename = "init.php";
		$contents = implode('',file($filename));
		preg_match_all("|(.*)=(.*);|U",$contents ,$matches );
		foreach($matches[1] as $k=>$v){
			$contents = str_replace($matches[1][$k]."=".$matches[2][$k].";",$matches[1][$k]."= ".stripcslashes($vars[$k]).";", $contents);
		}
		// Assurons nous que le fichier est accessible en Žcriture
		if (is_writable($filename)) {
		
		    // Dans notre exemple, nous ouvrons le fichier $filename en mode d'ajout
		    // Le pointeur de fichier est placŽ ˆ la fin du fichier
		    // c'est lˆ que $somecontent sera placŽ
		    if (!$handle = fopen($filename, 'w')) {
		         echo "Impossible d'ouvrir le fichier ($filename)";
		         exit;
		    }
		
		    // Ecrivons quelque chose dans notre fichier.
		    if (fwrite($handle, $contents) === FALSE) {
		       echo "Impossible d'Žcrire dans le fichier ($filename)";
		       exit;
		    }		    
		    fclose($handle);
		    return TRUE;
		} else {
		    return FALSE;
		}
	}
	
	/**
	 * backup::monitor()		Return tables status
	 * 
	 * @return 
	 **/
	function monitor(){
	
		$color3 = $this->color3;
		$color2 = $this->color2;
		$color1 = $this->color1;
		
		
		$res = '<table border=0 cellpadding=5>';
        $result =  $this->query('SHOW TABLE STATUS');
		$i = 0;		$bgcolor = $color3; $l1 = $l2 = "";
        while ($table = @$this->fetch_array($result)) {
			foreach($table as $k=>$v){
				if (!is_integer($k)) {
					$l1 .= "<th bgcolor=\"$color1\"><font size=1>$k</font></th>\n";
					$l2 .= "<td bgcolor=\"$bgcolor\"><font size=1>$v</font></td>\n"; 
				}
			}
			if ($i==0) {
			    $res .= "<tr>\n$l1</tr>\n";
			}
			$res .= "<tr>\n$l2</tr>\n";
			if ($bgcolor==$color3) {
			    $bgcolor = $color2;
			} else $bgcolor = $color3;
			$l1 = $l2 = "";
			$i++;
        }
		$res .= '</table>';
		return $res;
	}
	
	
	/**
	 * backup::getbackup()
	 * 
	 * @return 
	 **/
	function getbackup($bfile){

		if (is_file($this->backupdir."/".$bfile) and !ereg("../",$bfile)) {
			
			header("Pragma: public");
			header("Expires: 0");
			header("Cache-Control: must-revalidate, post-check=0, pre-check=0"); 			
			header("Content-Type: application/force-download");
			header("Content-Disposition: attachment; filename=".basename($this->backupdir."/".$bfile));
			header("Content-Description: File Transfer");
			@readfile($this->backupdir."/".$bfile);
			exit;
		}
	}
	
	
}

?>
Return current item: MySQL Backup Pro