mirror of
https://github.com/Xkeeper0/jul.git
synced 2025-05-19 00:30:21 -07:00
202 lines
10 KiB
PHP
202 lines
10 KiB
PHP
<?php
|
|
require 'lib/function.php';
|
|
$user=@mysql_fetch_array(mysql_query("SELECT * FROM users WHERE id=$id"));
|
|
$windowtitle="$boardname -- Profile for $user[name]";
|
|
require 'lib/layout.php';
|
|
|
|
if ($_GET['id'] == 1 && !$x_hacks['host'] && false) {
|
|
print "$header<br><center><img src='http://earthboundcentral.com/wp-content/uploads/2009/01/m3deletede.png'></center><br>$footer";
|
|
printtimedif($startingtime);
|
|
die();
|
|
}
|
|
|
|
if(!$user){
|
|
print "$header<br>$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=" | <a href=rateuser.php?id=$id>Rate user</a>";
|
|
$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($dateformat,$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 id, thread FROM posts WHERE user=$id AND date=$user[lastposttime]"));
|
|
if($threads=mysql_query("SELECT title,forum FROM threads WHERE id=$post[1]")){
|
|
$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 <a href=thread.php?pid=$post[0]#$post[0]>$thread[0]</a> (<a href=forum.php?id=$forum[id]>$forum[title]</a>)";
|
|
}
|
|
}
|
|
if($loguser){
|
|
$sendpmsg=" | <a href=sendprivate.php?userid=$id>Send private message</a>";
|
|
if($isadmin){
|
|
if($user[lastip]) $lastip=" <br>with IP: <a href=ipsearch.php?ip=$user[lastip]>$user[lastip]</a>";
|
|
$sneek="<tr>$tccell1s colspan=2><a href=private.php?id=$id>View private messages</a> |". (false ? " <a href=rateuser.php?action=viewvotes&id=$id>View votes</a> |" : "") ." <a href=edituser.php?id=$id>Edit user</a>";
|
|
}
|
|
}
|
|
$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]);
|
|
|
|
if($user[picture]) $picture="<img src=\"$user[picture]\">";
|
|
|
|
$icqicon="<a href=http://wwp.icq.com/$user[icq]#pager><img src=http://wwp.icq.com/scripts/online.dll?icq=$user[icq]&img=5 border=0></a>";
|
|
|
|
if(!$user[icq]){
|
|
$user[icq]="";
|
|
$icqicon="";
|
|
}
|
|
|
|
$tccellha="<td bgcolor=$tableheadbg";
|
|
$tccellhb="><center>$fonthead";
|
|
$namecolor=getnamecolor($user[sex],$user[powerlevel]);
|
|
$tzoffset=$user[timezone];
|
|
$tzoffrel=$tzoffset-$loguser[timezone];
|
|
$tzdate=date($dateformat,ctime()+$tzoffset*3600);
|
|
if($user[birthday]){
|
|
$birthday=date("l, F j, Y",$user[birthday]);
|
|
$age="(".floor((ctime()-$user[birthday])/86400/365.2425)." years ". ($id == 1 && !$x_hacks['host'] ? "<s>old</s> ago" : "old") .")";
|
|
}
|
|
$exp=calcexp($user[posts],(ctime()-$user[regdate])/86400);
|
|
$lvl=calclvl($exp);
|
|
$expleft=calcexpleft($exp);
|
|
$expstatus="Level: $lvl<br>EXP: $exp (for next level: $expleft)";
|
|
if($user[posts]) $expstatus.="<br>Gain: ".calcexpgainpost($user[posts],(ctime()-$user[regdate])/86400)." EXP per post, ".calcexpgaintime($user[posts],(ctime()-$user[regdate])/86400)." seconds to gain 1 EXP when idle";
|
|
$postavg=sprintf("%01.2f",$user[posts]/(ctime()-$user[regdate])*86400);
|
|
$totalwidth=116;
|
|
$barwidth=@floor(($user[posts]/$maxposts)*$totalwidth);
|
|
if($barwidth<0) $barwidth=0;
|
|
if($barwidth) $baron="<img src=images/$numdir"."bar-on.gif width=$barwidth height=8>";
|
|
if($barwidth<$totalwidth) $baroff="<img src=images/$numdir"."bar-off.gif width=".($totalwidth-$barwidth)." height=8>";
|
|
$bar="<img src=images/$numdir"."barleft.gif>$baron$baroff<img src=images/$numdir"."barright.gif><br>";
|
|
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<ctime()) $projdate="";
|
|
else $projdate=" -- Projected date for $topposts posts: ".date($dateformat,$projdate+$tzoff);
|
|
if($user[minipic]) $minipic="<img src=\"". htmlspecialchars($user[minipic]) ."\" width=16 height=16 align=absmiddle> ";
|
|
$homepagename=$user[homepageurl];
|
|
if($user[homepagename]) $homepagename="$user[homepagename]</a> - $user[homepageurl]";
|
|
if($user[postbg]) $postbg="<div style='background:url($user[postbg]);' height=100%>";
|
|
loadtlayout();
|
|
$user[headtext]=$user[postheader];
|
|
$user[signtext]=$user[signature];
|
|
$user[text] = "Sample text. [quote=fhqwhgads]A sample quote, with a <a href=about:blank>link</a>, for testing your layout.[/quote]This is how your post will appear.";
|
|
$user[uid] = $_GET['id'];
|
|
// so that layouts show up regardless of setting (for obvious reasons)
|
|
$loguser[viewsig] = 1;
|
|
|
|
// shop/rpg such
|
|
$shops=mysql_query('SELECT * FROM itemcateg ORDER BY corder');
|
|
$eq=mysql_fetch_array(mysql_query("SELECT * FROM users_rpg WHERE uid=$id"));
|
|
$eqitems=mysql_query("SELECT * FROM items WHERE id=$eq[eq1] OR id=$eq[eq2] OR id=$eq[eq3] OR id=$eq[eq4] OR id=$eq[eq5] OR id=$eq[eq6] OR id=$eq[eq7]");
|
|
while($item=mysql_fetch_array($eqitems)) $items[$item[id]]=$item;
|
|
while($shop=mysql_fetch_array($shops))
|
|
$shoplist.="
|
|
<tr>
|
|
$tccell1s>$shop[name]</td>
|
|
$tccell2s width=100%>".$items[$eq['eq'.$shop[id]]][name]." </td>";
|
|
|
|
$user['date'] = ctime();
|
|
|
|
/* extra munging for whatever reason */
|
|
$user[email] = urlencode($user[email]);
|
|
print "
|
|
$header
|
|
<div>$fonttag Profile for <b>$minipic<font $namecolor>$user[name]</font></div>
|
|
<table cellpadding=0 cellspacing=0 border=0>
|
|
<td width=100% valign=top>
|
|
$tblstart
|
|
$tccellh colspan=2><center>General information<tr>
|
|
<!-- $tccell1l width=150><b>Login name</td> $tccell2l>". $user['loginname'] ."<tr> -->
|
|
$tccell1l width=150><b>Total posts</td> $tccell2l>$user[posts] ($postavg per day) $projdate<br>$bar<tr>
|
|
$tccell1l width=150><b>Total threads</td> $tccell2l>$threadsposted<tr>
|
|
$tccell1l width=150><b>EXP</td> $tccell2l>$expstatus<tr>
|
|
". (false ? " $tccell1l width=150><b>User rating</td> $tccell2l>$ratingstatus<tr>" : "") ."
|
|
$tccell1l width=150><b>Registered on</td> $tccell2l>".@date($dateformat,$user[regdate]+$tzoff)." (".floor((ctime()-$user[regdate])/86400)." days ago)<tr>
|
|
$tccell1l width=150><b>Last post</td> $tccell2l>$lastpostdate$lastpostlink<tr>
|
|
$tccell1l width=150><b>Last activity</td> $tccell2l>".date($dateformat,$user[lastactivity]+$tzoff)."$lastip<tr>
|
|
$tblend
|
|
<br>$tblstart
|
|
$tccellh colspan=2><center>Contact information<tr>
|
|
$tccell1l width=150><b>Email address</td> $tccell2l><a href='mailto:$user[email]'>$user[email]</a> <tr>
|
|
$tccell1l width=150><b>Homepage</td> $tccell2l><a href='$user[homepageurl]'>$homepagename</a> <tr>
|
|
$tccell1l width=150><b>ICQ number</td> $tccell2l>$user[icq] $icqicon <tr>
|
|
$tccell1l width=150><b>AIM screen name</td> $tccell2l><a href='aim:goim?screenname=$aim'>$user[aim]</a> <tr>
|
|
$tblend
|
|
<br>$tblstart
|
|
$tccellh colspan=2><center>User settings<tr>
|
|
$tccell1l width=150><b>Timezone offset</td> $tccell2l>$tzoffset hours from the server, $tzoffrel hours from you (current time: $tzdate)<tr>
|
|
$tccell1l width=150><b>Items per page</td> $tccell2l>". $user['threadsperpage'] ." threads, ". $user['postsperpage'] ." posts<tr>
|
|
$tccell1l width=150><b>Color scheme</td> $tccell2l>".$schname."<tr>
|
|
$tblend
|
|
</td><td> </td><td valign=top>
|
|
$tblstart
|
|
$tccellh><center>RPG status<tr>
|
|
$tccell1l><img src='status.php?u=$id'>
|
|
$tblend
|
|
<br>$tblstart
|
|
$tccellh colspan=2><center>Equipped Items<tr>
|
|
$shoplist
|
|
$tblend
|
|
</td></table>
|
|
<br>$tblstart
|
|
$tccellh colspan=2><center>Personal information<tr>
|
|
$tccell1l width=150><b>Real name</td> $tccell2l>$user[realname] <tr>
|
|
$tccell1l width=150><b>Location</td> $tccell2l>$user[location] <tr>
|
|
$tccell1l width=150><b>Birthday</td> $tccell2l>$birthday $age <tr>
|
|
$tccell1l width=150><b>User bio</td> $tccell2l>". dofilters(doreplace2(doreplace($user['bio'], $user['posts'], (ctime()-$user['regdate'])/86400, $user['name']))) ." <tr>
|
|
$tblend
|
|
<br>$tblstart
|
|
$tccellh colspan=2><center>Sample post<tr>
|
|
". threadpost($user, 1) ."
|
|
$tblend
|
|
<br>$tblstart
|
|
$tccellhs colspan=2><center>Options<tr>
|
|
$tccell2s colspan=2>
|
|
<a href=thread.php?user=$id>Show posts</a> |
|
|
<a href=postsbyuser.php?id=$id>List posts by this user</a> |
|
|
<a href=forum.php?user=$id>View threads by this user</a>
|
|
$sendpmsg$ratelink<tr>
|
|
$tccell2s colspan=2>
|
|
<a href=postsbytime.php?id=$id>Posts by time of day</a> |
|
|
<a href=postsbythread.php?id=$id>Posts by thread</a> |
|
|
<a href=postsbyforum.php?id=$id>Posts by forum</td>$sneek
|
|
$tblend$footer
|
|
";
|
|
printtimedif($startingtime);
|
|
?>
|