/** * @deprecated * @todo this function doesn't seemed to be used anymore; trying kill this off */ function run_upgrade_wizard_sql($script) { global $unzip_dir; global $sugar_config; $db_type = $sugar_config['dbconfig']['db_type']; $script = str_replace("%db_type%", $db_type, $script); if (!run_sql_file("{$unzip_dir}/{$script}")) { die("{$mod_strings['ERR_UW_RUN_SQL']} {$unzip_dir}/{$script}"); } }
function run_upgrade_wizard_sql($script) { global $unzip_dir; global $sugar_config; $db_type = $sugar_config['dbconfig']['db_type']; $script = str_replace("%db_type%", $db_type, $script); if (!run_sql_file("{$unzip_dir}/{$script}")) { die("Error running sql file: {$unzip_dir}/{$script}"); } }
// 本程序执行编码 // 显示填写mysql信息的表单 , 并停止 if (!isset($_POST['dbinfo'])) { include 'install_form.html'; exit; } // 提交表单后, 获得mysql账号信息 $db = array(); $data = $_POST['dbinfo']; $db['host'] = $data['dbhost']; $db['dbname'] = $data['dbname']; $db['user'] = $data['dbuser']; $db['pwd'] = $data['dbpw']; // 导入数据文件 $sql_file = dirname(__FILE__) . "/install.sql"; run_sql_file($sql_file, $db); // 生成已安装文件 file_put_contents('../install_lock', ''); // 安装完成 , 跳转回首页 echo "\n\n\r<pre>\n+-------------+-------------+-------------+\n 安装完成。... \n</pre>\n\n\r\n\n<meta http-equiv='refresh' content='2;url=../index.php' />\n"; /* 执行mysql数据文件. 参数: 数据文件 , 数据库账号信息 */ function run_sql_file($sql_file, $dbconfig) { $host = $dbconfig['host']; $dbname = $dbconfig['dbname']; $user = $dbconfig['user']; $pwd = $dbconfig['pwd']; // 连接mysql数据库 $conn = mysql_connect($host, $user, $pwd) or die('连接mysql错误:' . mysql_error()); // 删除旧的数据库 mysql_query("DROP database IF EXISTS {$dbname} ;") or die("重新建立新的数据库 操作失败,无法删除【旧】数据库, 请检查mysql操作权限。错误信息: \n" . mysql_error());
} } //convert to array $commands = explode(";", $commands); //run commands $total = $success = 0; foreach ($commands as $command) { if (trim($command)) { $success += @mysql_query($command) == false ? 0 : 1; $total += 1; } } //return number of successful queries and total number of queries found return array("success" => $success, "total" => $total); } // Here's a startsWith function function startsWith($haystack, $needle) { $length = strlen($needle); return substr($haystack, 0, $length) === $needle; } if (@$_POST['submit'] != "") { $host = @$_POST['host']; $login = @$_POST['login']; $pw = @$_POST['pw']; $db = @$_POST['db']; mysql_connect($host, $login, $pw) or die('<b>' . mysql_error() . '</b>'); mysql_select_db($db) or die('<b>' . mysql_error() . '</b>'); run_sql_file("system/nugging.sql"); echo "Sucess install <br/> <a href='./'>Go to home</a>"; }
function restore_db($db_obj, $Restore_Path) { $temp = ''; $db_name = mysql_current_db($db_obj); $sql_path = getcwd() . "\\config\\backup_restore\\" . $Restore_Path . "\\" . $db_name . ".sql"; $temp .= '$sql_path- ' . $sql_path . "\n"; $temp .= '$Restore_Path- ' . $Restore_Path . "\n"; if (!file_exists($sql_path)) { return false; } run_sql_file($sql_path, $db_obj); $Tables = _getTables($db_name, $db_obj); foreach ($Tables as $k => $tbl_name) { $file_path = getcwd() . '\\config\\backup_restore\\' . $Restore_Path . '\\' . $tbl_name . '.txt'; $file_contents = file_get_contents($file_path); $data = unserialize($file_contents); $sql = "TRUNCATE TABLE {$tbl_name}"; $db_obj->query($sql); foreach ($data as $tbl_data) { $db_obj->insert($tbl_name, $tbl_data); $temp .= '$tbl_data- ' . serialize($tbl_data) . "<br>"; } } $log_file_path = getcwd() . '\\config\\restore_log.txt'; // $file = @fopen($log_file_path,'w'); // @fwrite($file,$temp); // @fclose($file); return true; }
$s .= "\$auth_expire = 86400 * 365;\n"; $s .= "\n"; $s .= "\$captcha_key = \"{$captcha_key}\";\n"; $s .= "\n"; $s .= "date_default_timezone_set(\"UTC\");\n"; $s .= "\$https_enabled = true;\n"; $s .= "\$story_image_enabled = false;\n"; $sql_server = "mysql:host={$sql_server}"; $sql_open = false; open_database(); fs_slap("{$top_root}/conf.php", $s); if (!db_has_database($sql_database)) { run_sql("create database {$sql_database}"); run_sql("use {$sql_database}"); run_sql_file("{$top_root}/schema.sql"); run_sql_file("{$top_root}/default.sql"); $zid = "{$admin_username}@{$server_name}"; $salt = random_hash(); $pass = crypt_sha256("{$admin_password}{$salt}"); run_sql("insert into user_conf (zid, name, value) values (?, ?, ?)", array($zid, "admin", "1")); run_sql("insert into user_conf (zid, name, value) values (?, ?, ?)", array($zid, "editor", "1")); run_sql("insert into user_conf (zid, name, value) values (?, ?, ?)", array($zid, "password", $pass)); run_sql("insert into user_conf (zid, name, value) values (?, ?, ?)", array($zid, "salt", $salt)); } header("Location: /"); die; } writeln('<!DOCTYPE html>'); writeln('<html>'); writeln('<head>'); writeln('<title>Pipecode Setup</title>');