fetchq("SELECT * FROM `users` WHERE `id`='$id'"); if (!$_POST['action']) { // Generate layout + options $check1[$user['powerlevel']] = "selected='selected'"; $check2[$user['sex']] = "checked='1'"; $check3[$user['useranks']] = "checked='1'"; $check4[$user['profile_locked']] = "checked='1'"; $check5[$user['editing_locked']] = "checked='1'"; $checked2[$user['viewsig']] = "checked='1'"; $checked3[$user['posttool']] = "checked='1'"; // Why are these in reverse order, anyway $plocking = " $radio=profile_locked id='plock1' value='1' $check4[1]>Locked $radio=profile_locked id='plock0' value='0' $check4[0]>Unlocked "; $elocking = " $radio=editing_locked id='elock1' value='1' $check5[1]>Locked $radio=editing_locked id='elock0' value='0' $check5[0]>Unlocked "; $levellist = " Banned Normal Normal + Moderator Administrator Administrator (invisible) "; $sexlist = " $radio='sex' id='sex0' value='0' $check2[0]>Male $radio='sex' id='sex1' value='1' $check2[1]>Female $radio='sex' id='sex2' value='2' $check2[2]>N/A $radio='sex' id='sexr' value='-378'>Raw value: $inpt='sexn' value=$user[sex]> "; $vsig = " $radio='viewsig' id='viewsig0' value=0 $checked2[0]>Disabled $radio='viewsig' id='viewsig1' value=1 $checked2[1]>Enabled $radio='viewsig' id='viewsig2' value=2 $checked2[2]>Auto-updating "; $vtool = " $radio='posttool' id='posttool1' value='0' $checked3[0]>Disabled    $radio='posttool' id='posttool1' value='1' $checked3[1]>Enabled "; if ($user['birthday']) { $birthday = getdate($user['birthday']); $month = $birthday['mon']; $day = $birthday['mday']; $year = $birthday['year']; } else { $month = ""; $day = ""; $year = ""; } # TODO: Combine this whole thing into one query with the magic of GROUP BY $schemes = $sql -> query("SELECT `id`, `name` FROM `schemes` ORDER BY `ord`"); while ($sch = $sql -> fetch($schemes)) { $sel = ($sch['id'] == $user['scheme']) ? "selected='selected'" : ""; $used = $sql -> resultq("SELECT COUNT(`id`) cnt FROM `users` WHERE `scheme` = '$sch[id]'"); $schlist .= " $sch[name] ($used) "; } $schlist = " $schlist "; $tlayouts = $sql -> query("SELECT `id`, `name` FROM `tlayouts` ORDER BY `ord`"); while ($lay = $sql -> fetch($tlayouts)) { $sel = ($lay['id'] == $user['layout']) ? "selected='selected'" : ""; $used = $sql -> resultq("SELECT COUNT(`id`) FROM `users` WHERE `layout` = '$lay[id]'"); $laylist .= " $lay[name] ($used) "; } $laylist = " $laylist "; $rsets = $sql -> query("SELECT `id`, `name` FROM `ranksets` ORDER BY `id`"); while ($set = $sql -> fetch($rsets)) { $sel = ($set['id'] == $user['useranks']) ? "selected='selected'" : ""; $used = $sql -> resultq("SELECT COUNT(*) FROM `users` WHERE `useranks` = '$set[id]'"); $rsetlist .= " $set[name] ($used) "; } $rsetlist = " $rsetlist "; $lft = "$tccell1>"; $rgt = ":$tccell2l>"; $hlft = "$tccellh>"; $hrgt = "$tccellh> "; squot(0,$user['name']); squot(0,$user['title']); squot(0,$user['realname']); squot(0,$user['location']); squot(0,$user['homepagename']); sbr(1, $user['bio']); sbr(1, $user['signature']); sbr(1, $user['postheader']); print "

$tblstart $hlft Login information $hrgt $lft User name $rgt $inpt=username value=\"$user[name]\" size=25 maxlength=25> $lft Password $rgt $inpp=password value=\"\" size=13 maxlength=32> $hlft Administrative bells and whistles $hrgt $lft Power level $rgt $levellist $lft Custom title $rgt $inpt=usertitle value=\"$user[title]\" size=60 maxlength=255> $lft Rank set $rgt $rsetlist $lft Number of posts $rgt $inpt=numposts size=5 maxlength=10 value=$user[posts]> $lft Registration time:$smallfont
(seconds since ".date($dateformat,$tzoff).")$tccell2l>$inpt=regtime size=10 maxlength=15 value=$user[regdate]> $lft Lock Profile $rgt $plocking $lft Restrict Editing $rgt $elocking $hlft Appearance $hrgt $lft Mini picture $rgt $inpt=minipic value=\"$user[minipic]\" size=60 maxlength=100> $lft User picture $rgt $inpt=picture value=\"$user[picture]\" size=60 maxlength=100> $lft Mood avatar $rgt $inpt=moodurl value=\"$user[moodurl]\" size=60 maxlength=100> $lft Post background $rgt $inpt=postbg value=\"$user[postbg]\" size=60 maxlength=100> $lft Post header $rgt $txta=postheader rows=5 cols=60>". htmlspecialchars($user[postheader]) ." $lft Signature $rgt $txta=signature rows=5 cols=60>". htmlspecialchars($user[signature]) ." $hlft Personal information $hrgt $lft Sex $rgt $sexlist $lft Real name $rgt $inpt=realname value=\"$user[realname]\" size=40 maxlength=60> $lft Location $rgt $inpt=location value=\"$user[location]\" size=40 maxlength=60> $lft Birthday $rgt Month: $inpt=bmonth size=2 maxlength=2 value=$month>   Day: $inpt=bday size=2 maxlength=2 value=$day>   Year: $inpt=byear size=4 maxlength=4 value=$year> $lft Bio $rgt $txta=bio rows=5 cols=60>". htmlspecialchars($user[bio]) ." $hlft Online services $hrgt $lft Email address $rgt $inpt=email value=\"$user[email]\" size=60 maxlength=60> $lft AIM screen name $rgt $inpt=aim value=\"$user[aim]\" size=30 maxlength=30> $lft ICQ number $rgt $inpt=icq size=10 maxlength=10 value=$user[icq]> $lft Homepage title $rgt $inpt=pagename value=\"$user[homepagename]\" size=60 maxlength=80> $lft Homepage URL $rgt $inpt=homepage value=\"$user[homepageurl]\" size=60 maxlength=80> $hlft Options $hrgt $lft Timezone offset $rgt $inpt=timezone size=5 maxlength=5 value=$user[timezone]> $lft Date format $rgt $inpt=dateformat value=\"". $dateformat ."\" size=16 maxlength=32> $lft Short date format $rgt $inpt=dateshort value=\"". $dateformat ."\" size=8 maxlength=32> $lft Posts per page $rgt $inpt=postsperpage size=5 maxlength=5 value=$user[postsperpage]> $lft Threads per page $rgt $inpt=threadsperpage size=4 maxlength=4 value=$user[threadsperpage]> $lft Use post toolbar $rgt $vtool $lft View post layouts $rgt $vsig $lft Thread layout $rgt $laylist $lft Color scheme $rgt $schlist $lft   $tccell2l> $inph=action value='saveprofile'> $inph=userid value='$id'> $inps=submit value='Edit profile'> $tblend

"; } elseif ($_POST['action'] == "saveprofile") { sbr(0, $signature); sbr(0, $bio); sbr(0, $postheader); $minipic = htmlspecialchars($minipic); $avatar = htmlspecialchars($avatar); if (!$bmonth || !$bday || !$byear) { $birthday = 0; } else { $birthday = mktime(0, 0, 0, $bmonth, $bday, $byear); } if ($password) { $passedit="`password` = '".md5($password)."', "; } if ($sex == -378) { $sex = $sexn; } $insdateformat = ($_POST['dateformat'] == $defaultdateformat) ? "" : $_POST['dateformat']; $insdateshort = ($_POST['dateshort'] == $defaultdateshort) ? "" : $_POST['dateshort']; $sql -> query(" UPDATE `users` SET `posts` = '$numposts', `regdate` = '$regtime', `name` = '$username', $passedit `picture` = '$picture', `signature` = '$signature', `bio` = '$bio', `powerlevel` = '$powerlevel', `title` = '$usertitle', `email` = '$email', `icq` = '$icq', `aim` = '$aim', `sex` = '$sex', `homepageurl` = '$homepage', `timezone` = '$timezone', `dateformat` = '$insdateformat', `dateshort` = '$insdateshort', `postsperpage` = '$postsperpage', `realname` = '$realname', `location` = '$location', `postbg` = '$postbg', `postheader` = '$postheader', `useranks` = '$useranks', `birthday` = '$birthday', `minipic` = '$minipic', `homepagename` = '$pagename', `scheme` = '$sscheme', `threadsperpage` = '$threadsperpage', `viewsig` = '$viewsig', `layout` = '$tlayout', `posttool` = '$posttool', `moodurl` = '$moodurl', `profile_locked` = '$profile_locked', `editing_locked` = '$editing_locked' WHERE `id` = '$userid' ") or print mysql_error(); print " $tblstart $tccell1>$user[name]'s profile has been edited.
". redirect("profile.php?id=$userid", "the user's profile", 0) ." $tblend"; } print $footer; printtimedif($startingtime);