/** * 功能:生成zip压缩文件,存放都 WEB_CACHE_PATH 中 * * @param $files array 需要压缩的文件 * @param $filename string 压缩后的zip文件名 包括zip后缀 * @param $path string 文件所在目录 * @param $outDir string 输出目录 * * @return array */ public static function zip($files, $filename, $outDir = WEB_CACHE_PATH, $path = DB_Backup_PATH) { $zip = new \ZipArchive(); File::makeDir($outDir); $res = $zip->open($outDir . "\\" . $filename, \ZipArchive::CREATE); if ($res == true) { foreach ($files as $file) { if (empty($file)) { continue; } if ($t = $zip->addFile($path . $file, str_replace('/', '', $file))) { $t = $zip->addFile($path . $file, str_replace('/', '', $file)); } } $zip->close(); return true; } else { return false; } }
/** * 备份数据库 * @param string $type * @param array $tables * @param string $path * @return array */ public function backupDB($type = "系统自动备份", $tables = array(), $path = DB_Backup_PATH) { $M = M(); function_exists('set_time_limit') && set_time_limit(0); //防止备份数据过程超时 /** * 如果备份文件夹不存在,则自动建立 */ if (!is_dir(DB_Backup_PATH)) { File::makeDir(DB_Backup_PATH, 0777); } G('Backup_start'); $pre = "# -----------------------------------------------------------\n" . "# " . get_opinion('title') . " database backup files\n" . "# URL: " . get_opinion('site_url') . "\n" . "# Type: {$type}\n"; $MySQLLogic = new \Common\Util\MySQLUtil(); $bdTable = $MySQLLogic->backupTable($tables); //取得表结构信息 $outPut = ""; $file_n = 1; $backedTable = array(); foreach ($tables as $table) { $backedTable[] = $table; $outPut .= "\n\n# 数据库表:{$table} 数据信息\n"; $tableInfo = $M->query("SHOW TABLE STATUS LIKE '{$table}'"); $page = ceil($tableInfo[0]['Rows'] / 10000) - 1; for ($i = 0; $i <= $page; $i++) { $query = $M->query("SELECT * FROM {$table} LIMIT " . $i * 10000 . ", 10000"); foreach ($query as $val) { $temSql = ""; $tn = 0; $temSql = ''; foreach ($val as $v) { $temSql .= $tn == 0 ? "" : ","; $temSql .= $v == '' ? "''" : "'{$v}'"; $tn++; } $temSql = "INSERT INTO `{$table}` VALUES ({$temSql});\n"; $sqlNo = "\n# Time: " . date("Y-m-d H:i:s") . "\n" . "# -----------------------------------------------------------\n" . "# 当前SQL卷标:#{$file_n}\n# -----------------------------------------------------------\n\n\n"; if ($file_n == 1) { $sqlNo = "# Description:当前SQL文件包含了表:" . implode("、", $tables) . "的结构信息,表:" . implode("、", $backedTable) . "的数据" . $sqlNo; } else { $sqlNo = "# Description:当前SQL文件包含了表:" . implode("、", $backedTable) . "的数据" . $sqlNo; } if (strlen($pre) + strlen($sqlNo) + strlen($bdTable) + strlen($outPut) + strlen($temSql) > get_opinion("sqlFileSize")) { $file_name = $path . "_" . $file_n . ".sql"; $outPut = $file_n == 1 ? $pre . $sqlNo . $bdTable . $outPut : $pre . $sqlNo . $outPut; //file_put_contents($file, $outPut, FILE_APPEND); //TODO file_put_contents-->> File::writeFile需要测试 File::writeFile($file_name, $outPut); $bdTable = $outPut = ""; $backedTable = array(); $backedTable[] = $table; $file_n++; } $outPut .= $temSql; } } } if (strlen($bdTable . $outPut) > 0) { $sqlNo = "\n# Time: " . date("Y-m-d H:i:s") . "\n" . "# -----------------------------------------------------------\n" . "# 当前SQL卷标:#{$file_n}\n# -----------------------------------------------------------\n\n\n"; if ($file_n == 1) { $sqlNo = "# Description:当前SQL文件包含了表:" . implode("、", $tables) . "的结构信息,表:" . implode("、", $backedTable) . "的数据" . $sqlNo; } else { $sqlNo = "# Description:当前SQL文件包含了表:" . implode("、", $backedTable) . "的数据" . $sqlNo; } $file_name = $path . "_" . $file_n . ".sql"; $outPut = $file_n == 1 ? $pre . $sqlNo . $bdTable . $outPut : $pre . $sqlNo . $outPut; // file_put_contents($file_name, $outPut, FILE_APPEND); File::writeFile($file_name, $outPut); $file_n++; } G('Backup_end'); $res = array("status" => 1, "info" => "成功备份所选数据库表结构和数据,本次备份共生成了" . ($file_n - 1) . "个SQL文件。耗时:" . G('Backup_start', 'Backup_end') . "秒", "url" => U('Admin/Data/restore')); return $res; }
/** * */ public function step4() { $time = date("Y-m-d H:m:s"); $db_host = $_POST["db_host"]; $db_port = $_POST["db_port"]; $db_user = $_POST["db_user"]; $db_password = $_POST["db_password"]; $db_name = $_POST["db_name"]; $db_prefix = $_POST["db_prefix"]; if ($_POST['admin_password'] != $_POST['admin_password2'] || trim($_POST['admin_password']) == '' || trim($_POST['admin_password2']) == '') { $this->error("两次输入的密码不一致,请重新设定!,或者密码为空"); } else { $admin_user = $_POST['admin_user']; $admin_password = encrypt($_POST['admin_password']); $admin_email = $_POST['admin_email']; $user_session = encrypt($admin_user . $admin_password . time()); } $title = $_POST['cfg_title']; $site_url = $_POST['cfg_basehost'] . $_POST['cfg_cmspath']; if (!test_db_connect($db_host . ":" . $db_port, $db_user, $db_password)) { $this->error("数据库服务器或登录密码无效,\n\n无法连接数据库,请重新设定!"); } $conn = mysql_connect($db_host . ":" . $db_port, $db_user, $db_password); mysql_query("CREATE DATABASE IF NOT EXISTS `" . $db_name . "`;", $conn); if (!mysql_select_db($db_name)) { $this->error("选择数据库失败,可能是你没权限,请预先创建一个数据库!"); } mysql_query("set character set 'utf8'"); mysql_query("set names 'utf8'"); $file = WEB_ROOT . 'Data/Install/db_config_sample.php'; if (!File::file_exists($file)) { $this->error('Data/Install/db_config_sample.php文件不存在,请检查'); } $content = File::readFile($file); $content = str_replace("~dbhost~", $db_host, $content); $content = str_replace("~dbport~", $db_port, $content); $content = str_replace("~dbname~", $db_name, $content); $content = str_replace("~dbuser~", $db_user, $content); $content = str_replace("~dbpwd~", $db_password, $content); $content = str_replace("~dbprefix~", $db_prefix, $content); if (!File::writeFile(WEB_ROOT . 'db_config.php', $content, 'w+')) { $this->error("数据库配置文件写入失败,请您手动根据Data/Install/db_config_sample.php文件在根目录创建文件"); } File::makeDir(WEB_ROOT . 'Data/Cache'); $sql_empty = File::readFile(WEB_ROOT . 'Data/Install/greencms_empty.sql'); $sql_query = str_replace('{$db_prefix}', $db_prefix, $sql_empty); $file = WEB_ROOT . 'Data/Cache/greencms_sample.sql'; File::writeFile($file, $sql_query, 'w+'); insertDB($file, $conn); File::delFile($file); $sql_empty = File::readFile(WEB_ROOT . 'Data/Install/greencms_init.sql'); $sql_query = str_replace('{$db_prefix}', $db_prefix, $sql_empty); $file2 = WEB_ROOT . 'Data/Cache/greencms_init_sample.sql'; File::writeFile($file2, $sql_query, 'w+'); insertDB($file2, $conn); File::delFile($file2); /** * 插入管理员数据&更新配置 */ $admin_query = "INSERT INTO `{$db_prefix}user` (`user_id`, `user_login`, `user_pass`, `user_nicename`, `user_email`,\n `user_url`, `user_registered`, `user_activation_key`, `user_status`, `user_intro`,\n `user_level`, `user_session`) VALUES(1, '{$admin_user}', '" . $admin_password . "', '管理员', '{$admin_email}',\n '', '{$time}', '', 1, '我是admin,欢迎使用', 2, '{$user_session}');"; if (!mysql_query($admin_query, $conn)) { $this->error(' 插入管理员数据出错'); } $cquery = "Update `{$db_prefix}options` set option_value='{$title}' where option_name='title';"; if (!mysql_query($cquery, $conn)) { $this->error(' 更新配置数据出错'); } $cquery = "Update `{$db_prefix}options` set option_value='{$site_url}' where option_name='site_url';"; if (!mysql_query($cquery, $conn)) { $this->error(' 更新配置数据出错'); } $software_version = GreenCMS_Version; $software_build = GreenCMS_Build; $cquery = "Update `{$db_prefix}options` set option_value='{$software_version}' where option_name='software_version';"; if (!mysql_query($cquery, $conn)) { $this->error(' 更新配置数据出错'); } $cquery = "Update `{$db_prefix}options` set option_value='{$software_build}' where option_name='software_build';"; if (!mysql_query($cquery, $conn)) { $this->error(' 更新配置数据出错'); } //TODO 写不下去了 $this->redirect('Install/Index/step5'); }