$User1Avatar = sql_result($reresult, $rei, "Avatar");
$User1AvatarSize = sql_result($reresult, $rei, "AvatarSize");
if ($User1Avatar == "http://" || $User1Avatar == null || strtolower($User1Avatar) == "noavatar") {
$User1Avatar = $ThemeSet['NoAvatar'];
$User1AvatarSize = $ThemeSet['NoAvatarSize'];
}
$AvatarSize1 = explode("x", $User1AvatarSize);
$AvatarSize1W = $AvatarSize1[0];
$AvatarSize1H = $AvatarSize1[1];
$User1Website = sql_result($reresult, $rei, "Website");
$BoardWWWChCk = parse_url($Settings['idburl']);
if ($User1Website == "http://") {
$User1Website = $Settings['idburl'];
}
$User1WWWChCk = parse_url($User1Website);
$User1Website = urlcheck($User1Website);
$opennew = " onclick=\"window.open(this.href);return false;\"";
if ($BoardWWWChCk['host'] == $User1WWWChCk['host']) {
$opennew = null;
}
$User1PostCount = sql_result($reresult, $rei, "PostCount");
$User1Karma = sql_result($reresult, $rei, "Karma");
$User1IP = sql_result($reresult, $rei, "IP");
sql_free_result($reresult);
if ($User1Name == "Guest") {
$User1Name = $GuestsName;
if ($User1Name == null) {
$User1Name = "Guest";
}
}
if (isset($GroupNamePrefix) && $GroupNamePrefix != null) {
}
if (!is_numeric($_POST['YourOffSet'])) {
$_POST['YourOffSet'] = "0";
}
if (!is_numeric($_POST['MinOffSet'])) {
$_POST['MinOffSet'] = "00";
}
if ($_POST['MinOffSet'] < 0) {
$_POST['MinOffSet'] = "00";
}
$_POST['YourOffSet'] = $_POST['YourOffSet'] . ":" . $_POST['MinOffSet'];
$_SESSION['UserTimeZone'] = $_POST['YourOffSet'];
$_SESSION['UserDST'] = $_POST['DST'];
$NewDay = GMTimeStamp();
$NewIP = $_SERVER['REMOTE_ADDR'];
$_POST['Website'] = urlcheck($_POST['Website']);
$_POST['iDBTimeFormat'] = convert_strftime($_POST['iDBTimeFormat']);
$_POST['iDBDateFormat'] = convert_strftime($_POST['iDBDateFormat']);
$querynewprofile = sql_pre_query("UPDATE \"" . $Settings['sqltable'] . "members\" SET \"Interests\"='%s',\"Title\"='%s',\"Website\"='%s',\"TimeZone\"='%s',\"DateFormat\"='%s',\"TimeFormat\"='%s',\"Gender\"='%s',\"DST\"='%s',\"LastActive\"=%i,\"BirthMonth\"=%i,\"BirthDay\"=%i,\"BirthYear\"=%i,\"RepliesPerPage\"=%i,\"TopicsPerPage\"=%i,\"MessagesPerPage\"=%i,\"IP\"='%s' WHERE \"id\"=%i", array($_POST['Interests'], $_POST['Title'], $_POST['Website'], $_POST['YourOffSet'], $_POST['iDBTimeFormat'], $_POST['iDBDateFormat'], $_POST['YourGender'], $_POST['DST'], $NewDay, $BirthMonth, $BirthDay, $BirthYear, $_POST['RepliesPerPage'], $_POST['TopicsPerPage'], $_POST['MessagesPerPage'], $NewIP, $_SESSION['UserID']));
sql_query($querynewprofile, $SQLStat);
}
}
}
if ($_GET['act'] == "userinfo") {
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");
$User1Email = sql_result($result, $i, "Email");
$ViewMem['AvatarSize'] = sql_result($result, $i, "AvatarSize");
$ViewMem['Email'] = sql_result($result, $i, "Email");
$ViewMem['GroupID'] = sql_result($result, $i, "GroupID");
$ViewMem['HiddenMember'] = sql_result($result, $i, "HiddenMember");
$ViewMem['WarnLevel'] = sql_result($result, $i, "WarnLevel");
$ViewMem['Interests'] = sql_result($result, $i, "Interests");
$ViewMem['Title'] = sql_result($result, $i, "Title");
$ViewMem['Joined'] = sql_result($result, $i, "Joined");
$ViewMem['Joined'] = GMTimeChange("M j Y, " . $_SESSION['iDBTimeFormat'], $ViewMem['Joined'], $_SESSION['UserTimeZone'], 0, $_SESSION['UserDST']);
$ViewMem['LastActive'] = sql_result($result, $i, "LastActive");
$ViewMem['LastActive'] = GMTimeChange("M j Y, " . $_SESSION['iDBTimeFormat'], $ViewMem['LastActive'], $_SESSION['UserTimeZone'], 0, $_SESSION['UserDST']);
$ViewMem['Website'] = sql_result($result, $i, "Website");
if ($ViewMem['Website'] == "http://") {
$ViewMem['Website'] = $Settings['idburl'];
}
$ViewMem['Website'] = urlcheck($ViewMem['Website']);
$BoardWWWChCk = parse_url($Settings['idburl']);
$MemsWWWChCk = parse_url($ViewMem['Website']);
$opennew = " onclick=\"window.open(this.href);return false;\"";
if ($BoardWWWChCk['host'] == $MemsWWWChCk['host']) {
$opennew = null;
}
$ViewMem['Gender'] = sql_result($result, $i, "Gender");
$ViewMem['PostCount'] = sql_result($result, $i, "PostCount");
$ViewMem['Karma'] = sql_result($result, $i, "Karma");
$ViewMem['TimeZone'] = sql_result($result, $i, "TimeZone");
$ViewMem['DST'] = sql_result($result, $i, "DST");
$ViewMem['IP'] = sql_result($result, $i, "IP");
$gquery = sql_pre_query("SELECT * FROM \"" . $Settings['sqltable'] . "groups\" WHERE \"id\"=%i LIMIT 1", array($ViewMem['GroupID']));
$gresult = sql_query($gquery, $SQLStat);
$ViewMem['Group'] = sql_result($gresult, 0, "Name");
