$tblstart$tccell1>The specified user doesn't exist.$tblend$footer";
printtimedif($startingtime);
die();
}
$maxposts=mysql_fetch_array(mysql_query("SELECT posts FROM users ORDER BY posts DESC LIMIT 1"));
$maxposts=$maxposts[posts];
$users1=mysql_query("SELECT id,posts,regdate FROM users");
while($u=mysql_fetch_array($users1)){
$u[level]=calclvl(calcexp($u[posts],(ctime()-$u[regdate])/86400));
if ($u[posts]<0 or $u[regdate]>ctime()) $u[level]=1;
$users[$u[id]]=$u;
}
$ratescore=0;
$ratetotal=0;
$ratings=mysql_query("SELECT userfrom,rating FROM userratings WHERE userrated=$id");
while($rating=@mysql_fetch_array($ratings)){
$ratescore+=$rating[rating]*$users[$rating[userfrom]][level];
$ratetotal+=$users[$rating[userfrom]][level];
}
$ratetotal*=10;
$numvotes=mysql_num_rows($ratings);
if($ratetotal) $ratingstatus=(floor($ratescore*1000/$ratetotal)/100)." ($ratescore/$ratetotal, $numvotes votes)";
else $ratingstatus="None";
if($loguserid and $logpwenc and $loguserid!=$id) $ratelink=" | Rate user";
$userrank=getrank($user[useranks],$user[title],$user[posts],$user[powerlevel]);
$threadsposted=mysql_result(mysql_query("SELECT count(id) AS cnt FROM threads WHERE user=$id"),0,"cnt");
$i=0;
$lastpostdate="None";
if($user[posts]) $lastpostdate=date("m-d-y h:i A",$user[lastposttime]+$tzoff);
// $postsfound=mysql_result(mysql_query("SELECT count(id) AS cnt FROM posts WHERE user=$id"),0,"cnt");
$post=@mysql_fetch_array(mysql_query("SELECT thread FROM posts WHERE user=$id AND date=$user[lastposttime]"));
if($threads=mysql_query("SELECT title,forum FROM threads WHERE id=$post[0]")){
$thread=mysql_fetch_array($threads);
$forum=mysql_fetch_array(mysql_query("SELECT id,title,minpower FROM forums WHERE id=$thread[forum]"));
$thread[0]=str_replace("<","<",$thread[0]);
if($forum[minpower]>$loguser[powerlevel] and $forum[minpower]) $lastpostlink=", in a restricted forum";
else $lastpostlink=", in $thread[0] ($forum[title])";
}
if($loguser){
$sendpmsg=" | Send private message";
if($isadmin){
$edit=" | Edit user";
if($user[lastip]) $lastip=" (with IP: $user[lastip])";
$sneek="$tccell2s colspan=2>View private messages | View votes";
}
}
$aim=str_replace(" ","+",$user[aim]);
$schname=mysql_fetch_array(mysql_query("SELECT name FROM schemes WHERE id=$user[scheme]"));
$schname=$schname[name];
$numdays=(ctime()-$user[regdate])/86400;
$user[signature]=doreplace($user[signature],$user[posts],$numdays,$user[name]);
$user[signature]=doreplace2($user[signature],$user[posts],$numdays,$user[name]);
$user[postheader]=doreplace($user[postheader],$user[posts],$numdays,$user[name]);
$user[postheader]=doreplace2($user[postheader],$user[posts],$numdays,$user[name]);
$user[picture]=str_replace(">","%3E",$user[picture]);
if($user[picture]) $picture="![](\"$user[picture]\")
";
$icqicon="
";
if(!$user[icq]){
$user[icq]="";
$icqicon="";
}
$tccellha="";
if($barwidth<$totalwidth) $baroff="![](images/$numdir"."bar-off.gif) ";
$bar="![](images/$numdir"."barleft.gif) $baron$baroff![](images/$numdir"."barright.gif)
";
if(!$topposts) $topposts=5000;
if($user[posts]) $projdate=ctime()+(ctime()-$user[regdate])*($topposts-$user[posts])/($user[posts]);
if(!$user[posts] or $user[posts]>=$topposts or $projdate>2000000000 or $projdate$tblstart
$tccellh colspan=2>$fonttag Profile for $user[name]
$tccell2l>Username $tccell2l>$minipic$user[name]
$tccell1l>Title $tccell1l>$smallfont$userrank
$tccell2l>User picture $tccell2l>$picture
$tccell1l>Total posts $tccell1l>$user[posts] ($postavg per day) $projdate
$bar
$tccell2l>Threads posted $tccell2l>$threadsposted
$tccell1l>EXP status $tccell1l>$expstatus
$tccell2l>User rating $tccell2l>$ratingstatus
$tccell1l>Registered on $tccell1l>".@date($dateformat,$user[regdate]+$tzoff)." (".floor((ctime()-$user[regdate])/86400)." days ago)
$tccell2l>Last post $tccell2l>$lastpostdate$lastpostlink
$tccell1l>Last activity $tccell1l>".date($dateformat,$user[lastactivity]+$tzoff)."$lastip
$tccell2l>Real name $tccell2l>$user[realname]
$tccell1l>Location $tccell1l>$user[location]
$tccell2l>Email address $tccell2l>$user[email]
$tccell1l>Homepage $tccell1l>$homepagename
$tccell2l>ICQ number $tccell2l>$user[icq] $icqicon
$tccell1l>AIM screen name $tccell1l>$user[aim]
$tccell2l>Timezone offset $tccell2l>$tzoffset hours from the server, $tzoffrel hours from you (current time: $tzdate)
$tccell1l>User bio $tccell1l>$user[bio]
$tccell2l>Birthday $tccell2l>$birthday $age
$tccell1l>Sample post $tccell1l>$postbg$user[postheader](sample text)".$sep[$loguser[signsep]]."$user[signature]
$tccell2s colspan=2>
Show posts |
List posts by this user |
View threads by this user
$sendpmsg$ratelink$edit
$tccell2s colspan=2>
Posts by time of day |
Posts by thread |
Posts by forum$sneek
$tblend$footer
";
printtimedif($startingtime);
?> |