帝国CMS直接导入SQL文件代码方法介绍

$sqltxt=file_get_contents('area.sql');
$sqltxt=ClearAddsData($sqltxt);
$sqltxt=RepSqlTbpre($sqltxt);
DoRunQuery($sqltxt);
//运行SQL
function DoRunQuery($sql){
global $empire;
$sql=str_replace("/r","/n",$sql);
$ret=array();
$num=0;
foreach(explode(";/n",trim($sql)) as $query)
{
$queries=explode("/n",trim($query));
foreach($queries as $query)
{
$ret[$num].=$query[0]=='#'||$query[0].$query[1]=='--'?'':$query;
}
$num++;
}
unset($sql);
foreach($ret as $query)
{
$query=trim($query);
if($query)
{
$empire->query($query);
}
}
}