combakfun.php

EmpireBak是一款开源免费、专门为MYSQL大数据的备份与导入而设计的稳定高效软件,系统采用分卷备份与导入,理论上可备份任何大小的数据库

<?php
//------------------------------参数设置
function Ebak_SetDb($add){
	global $phome_db_password,$set_password,$phome_db_dbname;
	if(empty($add['outtime']))
	{
		$add['outtime']=60;
	}
	//修改密码
	if(empty($add['dbpassword']))
	{
		$add['dbpassword']=$phome_db_password;
    }
	elseif($add['dbpassword']=='null')
	{
		$add['dbpassword']='';
	}
	$dblocalhost=$add['dbhost'];
	//端口
	if($add['dbport'])
	{
		$dblocalhost.=":".$add['dbport'];
    }
	$link=@mysql_connect($dblocalhost,$add['dbusername'],$add['dbpassword']);
	if(empty($link))
	{
		printerror("FailDbuser","history.go(-1)");
	}
	//默认数据库
	if($add['dbname'])
	{
		if($add['dbname']!=$phome_db_dbname)
		{
			$usedb=@mysql_query("use `".$add['dbname']."`");
			if(!$usedb)
			{
				printerror("NotDb","history.go(-1)");
			}
		}
	}
	//修改密码
	if($add['adminpassword'])
	{
		$add['adminpassword']=md5($add['adminpassword']);
		$a="\$set_password=\"".addslashes($add['adminpassword'])."\";\r\n";
	}
	else
	{
		$add['adminpassword']=$set_password;
	}
	//目录
	if(empty($add['sbakpath']))
	{
		$add['sbakpath']="bdata";
	}
	if(!file_exists(RepPathStr($add['sbakpath'])))
	{
		printerror("NotBakpath","history.go(-1)");
	}
	if(empty($add['sbakzippath']))
	{
		$add['sbakzippath']="zip";
	}
	if(!file_exists(RepPathStr($add['sbakzippath'])))
	{
		printerror("NotZippath","history.go(-1)");
	}
	if(empty($add['sebaklang']))
	{
		$add['sebaklang']='gb,gbk';
	}
	$langr=explode(',',$add['sebaklang']);
	$string="<?php
//Database
\$phome_db_ver=\"".addslashes($add['mysqlver'])."\";
\$phome_db_server=\"".addslashes($add['dbhost'])."\";
\$phome_db_port=\"".addslashes($add['dbport'])."\";
\$phome_db_username=\"".addslashes($add['dbusername'])."\";
\$phome_db_password=\"".addslashes($add['dbpassword'])."\";
\$phome_db_dbname=\"".addslashes($add['dbname'])."\";
\$baktbpre=\"".addslashes($add['sbaktbpre'])."\";
\$phome_db_char=\"".addslashes($add['dbchar'])."\";

//USER
\$set_username=\"".addslashes($add['adminusername'])."\";
\$set_password=\"".addslashes($add['adminpassword'])."\";
\$set_outtime=\"".addslashes($add['outtime'])."\";
\$set_loginkey=\"".addslashes($add['loginkey'])."\";

//COOKIE
\$phome_cookiedomain=\"".addslashes($add['ckdomain'])."\";
\$phome_cookiepath=\"".addslashes($add['ckpath'])."\";
\$phome_cookievarpre=\"".addslashes($add['ckvarpre'])."\";

//LANGUAGE
\$langr=@ReturnUseEbakLang();
\$ebaklang=\$langr['lang'];
\$ebaklangchar=\$langr['langchar'];

//BAK
\$bakpath=\"".addslashes($add['sbakpath'])."\";
\$bakzippath=\"".addslashes($add['sbakzippath'])."\";
\$filechmod=\"".addslashes($add['sfilechmod'])."\";
\$phpsafemod=\"".addslashes($add['sphpsafemod'])."\";
\$php_outtime=\"".addslashes($add['sphp_outtime'])."\";
\$limittype=\"".addslashes($add['slimittype'])."\";
\$canlistdb=\"".addslashes($add['scanlistdb'])."\";

//------------ SYSTEM ------------
@HeaderIeChar();
?>";
	$filename="class/config.php";
	WriteFiletext_n($filename,$string);
	printerror("SetDbSuccess","SetDb.php");
}

//--------------------------修复表
function Ebak_Rep($tablename,$dbname){
	global $empire;
	$dbname=RepPostVar($dbname);
	$empire->query("use `$dbname`");
	$count=count($tablename);
	if(empty($count))
	{
		printerror("EmptyChangeTb","history.go(-1)");
	}
	for($i=0;$i<$count;$i++)
	{
		$sql1=$empire->query("REPAIR TABLE `$tablename[$i]`;");
    }
	printerror("RepairTbSuccess","ChangeTable.php?mydbname=$dbname");
}

//--------------------------忧化表
function Ebak_Opi($tablename,$dbname){
	global $empire;
	$dbname=RepPostVar($dbname);
	$empire->query("use `$dbname`");
	$count=count($tablename);
	if(empty($count))
	{
		printerror("EmptyChangeTb","history.go(-1)");
	}
	for($i=0;$i<$count;$i++)
	{
		$sql1=$empire->query("OPTIMIZE TABLE `$tablename[$i]`;");
    }
	printerror("OptimizeTbSuccess","ChangeTable.php?mydbname=$dbname");
}

//---------------------------删除数据表
function Ebak_Drop($tablename,$dbname){
	global $empire;
	$dbname=RepPostVar($dbname);
	$empire->query("use `$dbname`");
	$count=count($tablename);
	if(empty($count))
	{printerror("EmptyChangeDelTb","history.go(-1)");}
	$a="";
	$first=1;
	for($i=0;$i<$count;$i++)
	{
		if(empty($first))
		{
			$a.=",";
	    }
		else
		{
			$first=0;
		}
		$a.="`".$tablename[$i]."`";
    }
	$sql1=$empire->query("DROP TABLE IF EXISTS ".$a.";");
	printerror("DelTbSuccess","ChangeTable.php?mydbname=$dbname");
}

//--------------------------删除数据库
function Ebak_DropDb($dbname){
	global $empire;
	$dbname=RepPostVar($dbname);
	if(empty($dbname))
	{
		printerror("NotChangeDelDb","history.go(-1)");
	}
	$sql=$empire->query("DROP DATABASE `$dbname`");
	if($sql)
	{
		printerror("DelDbSuccess","ChangeDb.php");
	}
	else
	{printerror("DbError","history.go(-1)");}
}

//--------------------------建立数据库
function Ebak_CreatDb($dbname,$dbchar=''){
	global $empire,$phome_db_ver;
	$dbname=RepPostVar($dbname);
	if(!trim($dbname))
	{
		printerror("EmptyDbname","history.go(-1)");
	}
	$a="";
	if($dbchar&&$phome_db_ver>='4.1')
	{
		$a=" DEFAULT CHARACTER SET ".$dbchar;
	}
	$sql=$empire->query("CREATE DATABASE IF NOT EXISTS `$dbname`".$a);
	if($sql)
	{
		printerror("CreateDbSuccess","ChangeDb.php");
	}
	else
	{printerror("DbError","history.go(-1)");}
}

//--------------------------清空表
function Ebak_EmptyTable($tablename,$dbname){
	global $empire;
	$dbname=RepPostVar($dbname);
	$empire->query("use `$dbname`");
	$count=count($tablename);
	if(empty($count))
	{printerror("EmptyChangeTb","history.go(-1)");}
	for($i=0;$i<$count;$i++)
	{
		$sql1=$empire->query("TRUNCATE `".$tablename[$i]."`;");
    }
	printerror("TruncateTbSuccess","ChangeTable.php?mydbname=$dbname");
}

//---------------------------保存设置
function Ebak_SaveSeting($add){
	$savename=$add['savename'];
	if(strstr($savename,'.')||strstr($savename,'/')||strstr($savename,"\\"))
	{
		printerror("FailSetSavename","history.go(-1)");
	}
	$baktype=(int)$add['baktype'];
	$filesize=(int)$add['filesize'];
	$bakline=(int)$add['bakline'];
	$autoauf=(int)$add['autoauf'];
	$bakstru=(int)$add['bakstru'];
	$bakstrufour=(int)$add['bakstrufour'];
	$beover=(int)$add['beover'];
	$add['waitbaktime']=(int)$add['waitbaktime'];
	//表列表
	$tblist="";
	$tablename=$add['tablename'];
	$count=count($tablename);
	if($count)
	{
		for($i=0;$i<$count;$i++)
		{
			$tblist.=$tablename[$i].",";
		}
		$tblist=",".$tblist;
	}
	$str="<?php
\$dbaktype=".$baktype.";
\$dfilesize=".$filesize.";
\$dbakline=".$bakline.";
\$dautoauf=".$autoauf.";
\$dbakstru=".$bakstru.";
\$dbakstrufour=".$bakstrufour.";
\$ddbchar='".addslashes($add['dbchar'])."';
\$dmypath='".addslashes($add['mypath'])."';
\$dreadme=\"".addslashes(stripSlashes($add['readme']))."\";
\$dautofield='".addslashes($add['autofield'])."';
\$dtblist='".addslashes($tblist)."';
\$dbeover=".$beover.";
\$dinsertf='".addslashes($add['insertf'])."';
\$dmydbname='".addslashes($add['mydbname'])."';
\$dkeyboard='".addslashes($add['keyboard'])."';
\$dwaitbaktime='".$add['waitbaktime']."';
?>";
	$file="setsave/".$savename;
	WriteFiletext_n($file,$str);
	printerror("SetSaveSuccess","history.go(-1)");
}

//---------------------------删除设置
function Ebak_DelSeting($add){
	$savename=$add['savename'];
	if(strstr($savename,'.')||strstr($savename,'/')||strstr($savename,"\\"))
	{
		printerror("FailSetSavename","history.go(-1)");
	}
	$file="setsave/".$savename;
	DelFiletext($file);
	printerror("DelSaveSetSuccess","ListSetbak.php?mydbname=$add[mydbname]&change=$add[change]");
}

//----------------删除备份目录
function Ebak_DelBakpath($path){
	global $bakpath;
	if(strstr($path,".."))
	{printerror("NotChangeDelPath","history.go(-1)");}
	if(!trim($path))
	{printerror("NotChangeDelPath","history.go(-1)");}
	$delpath=$bakpath."/".$path;
	if(!file_exists($delpath))
	{
		printerror("DelPathNotExists","history.go(-1)");
    }
	$delpath=DelPath($delpath);
	printerror("DelPathSuccess","ChangePath.php?change=".$_GET['change']);
}

//---------------------------------删除压缩包
function Ebak_DelZip($file){
	global $bakzippath;
	if(strstr($file,".."))
	{printerror("FileNotExists","history.go(-1)",9);}
	if(empty($file))
	{
		printerror("FileNotExists","history.go(-1)",9);
    }
	$filename=$bakzippath."/".$file;
	if(!file_exists($filename))
	{
		printerror("FileNotExists","history.go(-1)",9);
	}
	DelFiletext($filename);
	printerror("DelZipSuccess","history.go(-1)",9);
}

//---------------------------------执行SQL语句
function Ebak_DoExecSql($add){
	global $empire,$phome_db_dbname,$phome_db_ver,$phome_db_char;
	$query=$add['query'];
	if(!$query)
	{
		printerror("EmptyRunSql","history.go(-1)");
    }
	//数据库
	if($add['mydbname'])
	{
		$empire->query("use `".$add['mydbname']."`");
	}
	//编码
	if($add['mydbchar'])
	{
		DoSetDbChar($add['mydbchar']);
	}
	$query=Ebak_ClearAddsData($query);
	Ebak_DoRunQuery($query,$add['mydbchar'],$phome_db_ver);
	printerror("RunSqlSuccess","DoSql.php");
}

//-------------------------------------上传执行SQL
function Ebak_DoTranExecSql($file,$file_name,$file_type,$file_size,$add){
	global $empire,$phome_db_dbname,$phome_db_ver,$phome_db_char;
	if(!$file_name||!$file_size)
	{
		printerror("NotChangeSQLFile","history.go(-1)");
	}
	$filetype=GetFiletype($file_name);//取得扩展名
	if($filetype!=".sql")
	{
		printerror("NotTranSQLFile","history.go(-1)");
	}
	//上传文件
	$newfile='tmp/uploadsql'.time().'.sql';
	$cp=Ebak_DoTranFile($file,$newfile);
	if(empty($cp))
	{
		printerror("TranSQLFileFail","history.go(-1)");
	}
	$query=ReadFiletext($newfile);
	DelFiletext($newfile);
	if(!$query)
	{
		printerror("EmptyRunSql","history.go(-1)");
    }
	//数据库
	if($add['mydbname'])
	{
		$empire->query("use `".$add['mydbname']."`");
	}
	//编码
	if($add['mydbchar'])
	{
		DoSetDbChar($add['mydbchar']);
	}
	Ebak_DoRunQuery($query,$add['mydbchar'],$phome_db_ver);
	printerror("RunSqlSuccess","DoSql.php");
}

//-------------------------------------替换文件内容
function Ebak_RepPathFiletext($add){
	global $bakpath;
	$mypath=trim($add['mypath']);
	$oldword=Ebak_ClearAddsData($add['oldword']);
	$newword=Ebak_ClearAddsData($add['newword']);
	$dozz=(int)$add['dozz'];
	if(empty($oldword)||empty($mypath))
	{
		printerror("EmptyRepPathFiletext","history.go(-1)");
	}
	if(strstr($mypath,".."))
	{
		printerror("NotChangeRepPathFiletext","history.go(-1)");
	}
	$path=$bakpath."/".$mypath;
	if(!file_exists($path))
	{
		printerror("PathNotExists","history.go(-1)");
    }
	$hand=@opendir($path);
	while($file=@readdir($hand))
	{
		$filename=$path."/".$file;
  		if($file!="."&&$file!=".."&&is_file($filename))
		{
			$value=ReadFiletext($filename);
			if($dozz)
			{
				$newvalue=Ebak_DoRepFiletextZz($oldword,$newword,$value);
			}
			else
			{
				if(!stristr($value,$oldword))
				{
					continue;
				}
				$newvalue=str_replace($oldword,$newword,$value);
			}
			WriteFiletext_n($filename,$newvalue);
		}
	}
	printerror("RepPathFiletextSuccess","RepFiletext.php");
}
?>