/**
* @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>');
