}
if (!isset($SetupDir['sql'])) {
$SetupDir['sql'] = "signup/sql/";
}
if (!isset($SetupDir['convert'])) {
$SetupDir['convert'] = null;
}
$_POST['DatabaseHost'] = $Settings['sqlhost'];
$_POST['DatabaseUserName'] = $Settings['sqluser'];
$_POST['DatabasePassword'] = $Settings['sqlpass'];
$_POST['DatabaseName'] = $Settings['sqldb'];
if (!isset($_POST['DefaultTheme'])) {
$_POST['DefaultTheme'] = "iDB";
}
if (isset($_POST['DefaultTheme'])) {
$_POST['DefaultTheme'] = chack_themes($_POST['DefaultTheme']);
}
if (!isset($_POST['SQLThemes'])) {
$_POST['SQLThemes'] = "off";
}
if ($_POST['SQLThemes'] != "on" && $_POST['SQLThemes'] != "off") {
$_POST['SQLThemes'] = "off";
}
if ($Settings['SeparateDatabase'] != "no" && $Settings['SeparateDatabase'] != "yes") {
$Settings['SeparateDatabase'] = "no";
}
//if($_POST['unlink']=="true") { $_POST['unlink'] = true; }
$disfunc = @ini_get("disable_functions");
$disfunc = @trim($disfunc);
$disfunc = @preg_replace("/([\\s+|\\t+|\\n+|\\r+|\\0+|\\x0B+])/i", "", $disfunc);
if ($disfunc != "ini_set") {
}
$_POST['YourOffSet'] = $_POST['YourOffSet'] . ":" . $_POST['MinOffSet'];
$_SESSION['UserTimeZone'] = $_POST['YourOffSet'];
$_SESSION['UserDST'] = $_POST['DST'];
if (!is_numeric($_POST['RepliesPerPage'])) {
$_POST['RepliesPerPage'] = "10";
}
if (!is_numeric($_POST['TopicsPerPage'])) {
$_POST['TopicsPerPage'] = "10";
}
if (!is_numeric($_POST['MessagesPerPage'])) {
$_POST['MessagesPerPage'] = "10";
}
$_POST['iDBTimeFormat'] = convert_strftime($_POST['iDBTimeFormat']);
$_POST['iDBDateFormat'] = convert_strftime($_POST['iDBDateFormat']);
$querynewskin = sql_pre_query("UPDATE \"" . $Settings['sqltable'] . "members\" SET \"UseTheme\"='%s',\"TimeZone\"='%s',\"DateFormat\"='%s',\"TimeFormat\"='%s',\"DST\"='%s',\"LastActive\"=%i,\"RepliesPerPage\"=%i,\"TopicsPerPage\"=%i,\"MessagesPerPage\"=%i,\"IP\"='%s' WHERE \"id\"=%i", array(chack_themes($_POST['skin']), $_POST['YourOffSet'], $_POST['iDBTimeFormat'], $_POST['iDBDateFormat'], $_POST['DST'], $NewDay, $_POST['RepliesPerPage'], $_POST['TopicsPerPage'], $_POST['MessagesPerPage'], $NewIP, $_SESSION['UserID']));
sql_query($querynewskin, $SQLStat);
}
}
}
if ($_GET['act'] == "profile") {
if ($_POST['update'] != "now") {
$query = sql_pre_query("SELECT * FROM \"" . $Settings['sqltable'] . "members\" WHERE \"id\"=%i LIMIT 1", array($_SESSION['UserID']));
$result = sql_query($query, $SQLStat);
$num = sql_num_rows($result);
$i = 0;
$YourID = sql_result($result, $i, "id");
$User1Interests = sql_result($result, $i, "Interests");
$User1Title = sql_result($result, $i, "Title");
$User1Website = sql_result($result, $i, "Website");
$User1Website = urlcheck($User1Website);
if ($_SESSION['UserGroup'] != $Settings['GuestGroup']) {
$NewDay = GMTimeStamp();
$qnewskin = sql_pre_query("UPDATE \"" . $Settings['sqltable'] . "members\" SET \"UseTheme\"='%s',\"LastActive\"='%s' WHERE \"id\"=%i", array($_GET['theme'], $NewDay, $_SESSION['UserID']));
sql_query($qnewskin, $SQLStat);
}
/* The file Theme Exists */
} else {
$_GET['theme'] = $Settings['DefaultTheme'];
$_SESSION['Theme'] = $Settings['DefaultTheme'];
/* The file Theme Dose Not Exists */
}
}
if ($_GET['theme'] == null) {
if ($_SESSION['Theme'] != null) {
$OldTheme = $_SESSION['Theme'];
$_SESSION['Theme'] = chack_themes($_SESSION['Theme']);
if ($_SESSION['UserGroup'] != $Settings['GuestGroup']) {
if ($OldTheme != $_SESSION['Theme']) {
$NewDay = GMTimeStamp();
$qnewskin = sql_pre_query("UPDATE \"" . $Settings['sqltable'] . "members\" SET \"UseTheme\"='%s',\"LastActive\"='%s' WHERE \"id\"=%i", array($_SESSION['Theme'], $NewDay, $_SESSION['UserID']));
sql_query($qnewskin, $SQLStat);
}
}
$_GET['theme'] = $_SESSION['Theme'];
}
if ($_SESSION['Theme'] == null) {
$_SESSION['Theme'] = $Settings['DefaultTheme'];
$_GET['theme'] = $Settings['DefaultTheme'];
}
}
$PreSkin['skindir1'] = $_SESSION['Theme'];
