Exemple #1
0
function DB_t_stru($table, $strufour = false)
{
    $dumpsql .= "DB_D(\"DROP TABLE IF EXISTS `" . $table . "`;\");\r\n";
    //设置引号
    M()->query("SET SQL_QUOTE_SHOW_CREATE=1;");
    //数据表结构
    $r = M()->query("SHOW CREATE TABLE `{$table}`;");
    $create = str_replace("\"", "\\\"", $r[0]['Create Table']);
    //转为4.0格式
    if ($strufour) {
        $create = Ebak_ToMysqlFour($create);
    }
    $dumpsql .= "DB_C(\"" . $create . "\");\r\n";
    return $dumpsql;
}
Exemple #2
0
function Ebak_AddDbchar($sql){
	global $phome_db_ver,$phome_db_char,$b_dbchar;
	//加编码
	if($phome_db_ver>='4.1'&&!strstr($sql,'ENGINE=')&&($phome_db_char||$b_dbchar)&&$b_dbchar!='auto')
	{
		$dbcharset=$b_dbchar?$b_dbchar:$phome_db_char;
		$sql=Ebak_DoCreateTable($sql,$phome_db_ver,$dbcharset);
	}
	elseif($phome_db_ver=='4.0'&&strstr($sql,'ENGINE='))
	{
		$sql=Ebak_ToMysqlFour($sql);
	}
	//去除字段中的编码
	$sql=Ebak_ReplaceFieldChar($sql);
	return $sql;
}
Exemple #3
0
function Ebak_AddDbchar($sql){
	global $ecms_config,$b_dbchar;
	//加编码
	if($ecms_config['db']['dbver']>='4.1'&&!strstr($sql,'ENGINE=')&&($ecms_config['db']['setchar']||$b_dbchar)&&$b_dbchar!='auto')
	{
		$dbcharset=$b_dbchar?$b_dbchar:$ecms_config['db']['setchar'];
		$sql=Ebak_DoCreateTable($sql,$ecms_config['db']['dbver'],$dbcharset);
	}
	elseif($ecms_config['db']['dbver']=='4.0'&&strstr($sql,'ENGINE='))
	{
		$sql=Ebak_ToMysqlFour($sql);
	}
	//去除字段中的编码
	$sql=Ebak_ReplaceFieldChar($sql);
	return $sql;
}