require dirname(__FILE__) . "/../data/config.php";
echo '<meta http-equiv="Content-Type" content="text / html;charset=UTF-8" />';
$install = @file_get_contents(saestor("saestor_" . $_SERVER['HTTP_APPVERSION'] . "/data/install.lock"));
if ($install == "1") {
echo "<h1>警告</h1>";
echo "<h3>版本" . $_SERVER['HTTP_APPVERSION'] . "已完成安装!请删除/install/目录！</h3>";
echo "<h3>如果重新安装请先删除storage内的 saestor_" . $_SERVER['HTTP_APPVERSION'] . "/data/install.lock 文件</h3>";
} else {
// 判断是否已经初始化了storage,mc,mysql
if (is_storage() && is_mc() && is_mysql()) {
$fp = @fopen(dirname(__FILE__) . "/ecshop4sae.sql", "r") or die("不能打开SQL文件 {$file_name}");
//打开文件
if ($fp) {
$mysql = new SaeMysql();
echo "正在执行导入操作:";
while ($SQL = GetNextSQL()) {
$SQL = str_replace("`ecs_", "`" . TABLE_PREFIX, $SQL);
// echo $SQL."<BR/>";
if (!$mysql->runSql($SQL)) {
echo "执行出错：" . $mysql->errmsg() . "";
echo "SQL语句为：" . $SQL . "";
exit;
}
}
echo "导入完成<br/>";
echo "<h1>安装成功</h1>";
echo "点击<a href='/admin'>/admin</a> 进入后台，管理员帐号为admin 密码为123<br/><br/><h2>注意</h2>为确保安全请登入后台后修改密码！并使用svn删除/install目录！";
@fclose($fp);
$s = new SaeStorage();
$s->write(SAESTOR_NAME, "saestor_" . $_SERVER['HTTP_APPVERSION'] . "/data/install.lock", '1');
} else {
function dosql()
{
global $conf;
//global $app_tmppath;
$sv = $_SESSION['setup_conf']['sql'];
$db_conf = $_SESSION['setup_conf']['conf'];
//创建配置文件
$set['DB_TYPE'] = 'mysql';
$set['DB_HOST'] = $db_conf['mysql_host'];
$set['DB_NAME'] = $db_conf['db_name'];
$set['DB_USER'] = $db_conf['mysql_user'];
$set['DB_PWD'] = $db_conf['mysql_pwd'];
$set['DB_PORT'] = $db_conf['mysql_port'];
$set['DB_PREFIX'] = $db_conf['db_pre'];
$set['FILE_UPLOAD_MAXSIZE'] = '1024000000';
$set['FILE_UPLOAD_ALLOWEXTS'] = 'jpg,gif,png,bmp';
$set['DEFAULT_CURRENCIES_SYMBOL'] = 'USD';
$arr = "<?php\n return " . var_export($set, "true") . ";\n?>";
$fp = fopen("../config.php", "w");
fwrite($fp, $arr);
fclose($fp);
$dbserver = $db_conf['mysql_host'] . (isset($db_conf['mysql_port']) ? ":" . $db_conf['mysql_port'] : '');
$conn = @mysql_connect($dbserver, $db_conf['mysql_user'], $db_conf['mysql_pwd']);
//连接到MySQL Server
if ($conn) {
if ($db_conf['db_isdrop'] != '') {
@mysql_query("DROP DATABASE IF EXISTS `" . $db_conf['db_name'] . "` ;") or die(ErrorInfo());
//按条件删除原DB
msg("创建数据库 ...<br />");
}
@mysql_query("CREATE DATABASE IF NOT EXISTS `" . $db_conf['db_name'] . "` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;") or die(ErrorInfo());
//创建DB
msg("创建数据库" . $db_conf['db_name'] . ",OK!");
@mysql_select_db($db_conf['db_name'], $conn) or die(ErrorInfo());
//打开数据库
msg("正在创建数据表...");
}
if (count($sv) > 0) {
@mysql_query("set names utf8");
foreach ($sv as $s) {
$files = $s['SQL_FILE'];
if (file_exists($files)) {
msg('<font color="green">正在处理文件:' . $files . '</font>', 0);
$fp = fopen($files, 'r');
while ($SQL = GetNextSQL($fp)) {
$SQL = str_replace('{key}', $db_conf['db_pre'], $SQL);
if (@mysql_query($SQL)) {
$SQL = str_replace("\r", '<br>', $SQL);
msg('<br><font color="green">处理SQL成功:</font><br>' . $SQL);
} else {
msg('<br>处理SQL失败:</font><br>' . $SQL, 0);
}
}
/*$sqlcontent=file_get_contents($files);
$sqlcontent=str_replace('{key}',$db_conf['db_pre'],$sqlcontent);
$sqlcontent=explode(';',$sqlcontent);
foreach ($sqlcontent as $sql){
if(trim($sql)!=''){
if(@mysql_query($sql)){
//$sql=str_replace("\r",'<br>',$sql);
msg('<br><font color="green">处理SQL成功:</font><br>'.$sql);
}else{
msg('<br>处理SQL失败:</font><br>'.$sql,0);
}
}
}
*/
} else {
msg('处理文件:' . $files . '失败!', 0);
}
}
}
remark_setup(1);
echo "<script language='JavaScript'>top.godourl(5);</script>";
}
