function insert_file($file,$replace=''){
global $Charset;
$readfiles=read_file($file);
if($replace){
$readfiles=str_replace('$timestamp',"$timestamp",$readfiles);
}
$detail=explode("n",$readfiles);
$count=count($detail);
for($j=0;$j<$count;$j++){
$ck=substr($detail[$j],0,4);
if( ereg("#",$ck)||ereg("--",$ck) ){
continue;
}
$array[]=$detail[$j];
}
$read=implode("n",$array);
$sql=str_replace("r",'',$read);
$detail=explode(";n",$sql);
$count=count($detail);
for($i=0;$i<$count;$i++){
$sql=str_replace("r",'',$detail[$i]);
$sql=str_replace("n",'',$sql);
$sql=trim($sql);
if($sql){
if(eregi("CREATE TABLE",$sql)){
$mysqlV=mysql_get_server_info();
$sql=preg_replace("/DEFAULT CHARSET=([a-z0-9]+)/is","",$sql);
$sql=preg_replace("/TYPE=MyISAM/is","ENGINE=MyISAM",$sql);
if($mysqlV>'4.1'){
$sql=str_replace("ENGINE=MyISAM"," ENGINE=MyISAM DEFAULT CHARSET=$Charset ",$sql);
}
}
$query=mysql_query($sql);
if (!$query) die("數據庫出錯:$sql");
$check++;
}
}
return $check;
}
function read_file($filename,$method="rb"){
if($handle=@fopen($filename,$method)){
@flock($handle,LOCK_SH);
$filedata=@fread($handle,@filesize($filename));
@fclose($handle);
}
return $filedata;
}