}
}
if (mysql_get_server_info() > '4.1') {
mysql_query("CREATE DATABASE IF NOT EXISTS `{$dbname}` DEFAULT CHARACTER SET " . DBCHARSET);
} else {
mysql_query("CREATE DATABASE IF NOT EXISTS `{$dbname}`");
}
if (mysql_errno()) {
show_msg('database_errno_1044', mysql_error(), 0);
}
mysql_close();
}
if (strpos($tablepre, '.') !== false || intval($tablepre[0])) {
show_msg('tablepre_invalid', $tablepre, 0);
}
config_edit();
require TIPASK_ROOT . './lib/db.class.php';
$db = new db($dbhost, $dbuser, $dbpw, $dbname, DBCHARSET);
$sql = file_get_contents($sqlfile);
$sql = str_replace("\r\n", "\n", $sql);
if (!VIEW_OFF) {
show_header();
show_install();
}
runquery($sql);
//add default user
$db->query("INSERT INTO `" . $tablepre . "user` SET `username`='" . $admininfo['ucadminname'] . "', `password`='" . md5(trim($admininfo['ucfounderpw'])) . "',`email`='" . $admininfo['ucadminemail'] . "',`groupid`=1,`credits`=200,`credit1`=100,`credit2`=100,`regip`='" . $_SERVER["REMOTE_ADDR"] . "'");
$db->query("INSERT INTO `" . $tablepre . "setting` SET `k`='auth_key',`v`='" . generate_key() . "'");
$db->query("INSERT INTO `" . $tablepre . "setting` SET `k`='admin_email',`v`='" . $admininfo['ucadminemail'] . "'");
$db->query("INSERT INTO `" . $tablepre . "setting` SET `k`='admin_email',`v`='" . $admininfo['ucadminemail'] . "'");
dir_clear(TIPASK_ROOT . './data/cache');
show_msg('database_errno_1044', mysql_error(), 0);
}
//mysql_close();
}
if (strpos($tablepre, '.') !== false) {
show_msg('tablepre_invalid', $tablepre, 0);
}
if ($username && $password) {
if (strlen($username) > 15 || preg_match("/^\$|^c:\\con\\con\$| |[,\"\\s\t\\<\\>&]|^游客|^Guest/is", $username)) {
show_msg('admin_username_invalid', $username, 0);
}
} else {
show_msg('admininfo_invalid', '', 0);
}
show_header();
$confstatus = config_edit();
if ($confstatus['status'] == 1) {
//入库
$db = new dbstuff();
$db->connect($dbhost . ":" . $dbport, $dbuser, $dbpw, $dbname, DBCHARSET);
$sqlfile = 'sql/data.sql';
$sql = file_get_contents($sqlfile);
$sql = str_replace("\r\n", "\n", $sql);
show_install();
runquery($sql);
$sqlfile = 'sql/other.sql';
$sql = file_get_contents($sqlfile);
$sql = str_replace("\r\n", "\n", $sql);
runquery($sql);
//系统设置中网站名称的修改
/**
//替换前缀
$sql = str_replace('`zfwx_', '`' . $dbpre, $sql);
$run = mysql_query($sql, $conn);
//获得表名
if (substr($sql, 0, 12) == 'CREATE TABLE') {
$table_name = $dbpre . preg_replace("/CREATE TABLE IF NOT EXISTS `" . $dbpre . "([a-z0-9_]+)` .*/is", "\\1", $sql);
echo $table_name . '创建成功...<br>';
}
//获得表名
if (substr($sql, 0, 11) == 'INSERT INTO') {
$table_name2 = $dbpre . preg_replace("/INSERT INTO `" . $dbpre . "([a-z0-9_]+)` .*/is", "\\1", $sql);
echo $table_name2 . '插入数据成功...<br>';
}
}
file_put_contents($root_path . 'data/update.log', $update_banben . ' ' . date('Y-m-d H:i:s') . "\r\n", FILE_APPEND);
config_edit($ver, $update_banben, $root_path);
echo "<br>执行更新完成，开始清除缓存！";
echo "<br>缓存路径：/data/runtime";
$delrunlog = delrun($root_path . 'data/runtime');
echo $delrunlog;
echo "<br>缓存清理完成！本次更新结束！！";
function _get_sql($sql_file)
{
$contents = file_get_contents($sql_file);
$contents = str_replace("\r\n", "\n", $contents);
$contents = trim(str_replace("\r", "\n", $contents));
$return_items = $items = array();
$items = explode(";\n", $contents);
foreach ($items as $item) {
$return_item = '';
$item = trim($item);
$configs['absolute_uri'] = $siteurl = $_POST['siteurl'];
if (empty($passwordkey)) {
$passwordkey = pb_radom(16);
}
if (empty($sitename)) {
$sitename = L("a_new_b2b_site", "tpl");
}
if (empty($sitetitle)) {
$sitetitle = L("a_new_b2b_title", "tpl");
}
$conn = mysql_connect($dbhost, $dbuser, $dbpasswd);
if ($conn) {
$version = mysql_get_server_info();
$set_names = "SET NAMES '{$dbcharset}'";
$set_modes = "SET sql_mode=''";
config_edit($configs);
if ($version > '4.1' && $charset) {
mysql_query($set_names, $conn);
}
if ($version > '5.0') {
mysql_query($set_modes, $conn);
}
if (!mysql_select_db($dbname)) {
if ($createdb == 1) {
if (mysql_get_server_info() > '4.1') {
mysql_query("CREATE DATABASE IF NOT EXISTS" . " {$dbname} DEFAULT CHARACTER SET {$dbcharset};");
} else {
mysql_query("CREATE DATABASE IF NOT EXISTS {$dbname};");
}
mysql_close();
} else {
if (mysql_get_server_info() > '4.1') {
mysql_query("CREATE DATABASE IF NOT EXISTS `{$dbname}` DEFAULT CHARACTER SET " . DBCHARSET);
} else {
mysql_query("CREATE DATABASE IF NOT EXISTS `{$dbname}`");
}
if (mysql_errno()) {
message($LAN['database_errno_1044'], mysql_error());
}
mysql_close();
}
if (empty($dbname) || empty($password)) {
message($LAN['dbname_invalid'], $LAN['dbnameempay']);
}
$password = md5($password);
$nowtime = time();
config_edit($postlist);
$db = new dbmysq();
$db->connect($dbhost, $dbuser, $dbpw, $dbname, DBCHARSET);
$sql = file_get_contents($sqlfile);
$sql .= file_get_contents($sqlfile_dbinstall);
if ($demodb) {
$sql .= file_get_contents($sqlfile_demodb);
}
foreach ($func_app as $key => $value) {
if ($value['isdel'] && in_array($value['appcode'], $apptype)) {
$sqlfilepath = admin_ROOT . './install/dbmysql/' . $value['sqlfile'];
$sql .= file_get_contents($sqlfilepath);
}
}
$sql = str_replace("\r\n", "\n", $sql);
$sql = str_replace("\r", "\n", str_replace("`" . ORIG_TABLEPRE, "`" . $tablepre, $sql));
break;
case 'keyword.cancel':
keyword_cancel($id, $option, $task);
break;
case 'keyword.delete':
keyword_delete($cid, $option, $task);
break;
case 'keyword':
case 'keyword.list':
keyword_list($option, $task);
break;
// ------------------------------------ Config
// ------------------------------------ Config
case 'config':
case 'config.edit':
config_edit($option);
break;
case 'config.save':
config_save($option);
break;
// ------------------------------------ Default / Home
// ------------------------------------ Default / Home
default:
case 'home':
case 'support':
home_display($option, $task);
break;
}
// Administrator Heading
/**
* TODO: Move to view
