Re: can someone help me
<?php
include "globals.php";
$_GET['u'] = abs((int) $_GET['u']);
if(!$_GET['u'])
{
print "Invalid use of file";
}
else
{
$q=$db->query("SELECT u.*,us.*,c.*,h.*,g.*,f.* FROM users u LEFT JOIN userstats us ON u.userid=us.userid LEFT JOIN cities c ON u.location=c.cityid LEFT JOIN houses h ON u.maxwill=h.hWILL LEFT JOIN gangs g ON g.gangID=u.gang LEFT JOIN fedjail f ON f.fed_userid=u.userid WHERE u.userid={$_GET['u']}");
if($db->num_rows($q) == 0)
{
print "Sorry, we could not find a user with that ID, check your source.";
}
else
{
$r=$db->fetch_row($q);
if($r['user_level'] == 1) { $userl="Mobster"; } else if($r['user_level'] == 2) { $userl="Owner"; } else if ($r['user_level'] == 3) { $userl="Admin"; } else if($r['user_level'] == 0) { $userl="NPC"; } else {$userl="Moderator"; }
$lon=($r['laston'] > 0) ?date('F j',$r['laston']) : "Never";
$sup=date('j F',$r['signedup']);
$ts=$r['strength']+$r['agility']+$r['guard']+$r['labour']+$r['IQ'];
$d="";
if($r['laston'] > 0)
{
$la=time()-$r['laston'];
$unit="seconds";
if($la >= 60)
{
$la=(int) ($la/60);
$unit="minutes";
}
if($la >= 60)
{
$la=(int) ($la/60);
$unit="hours";
if($la >= 24)
{
$la=(int) ($la/24);
$unit="days";
}
}
$str="$la $unit ago";
}
else
{
$str="--";
}
if($r['last_login'] > 0)
{
$ll=time()-$r['last_login'];
$unit2="seconds";
if($ll >= 60)
{
$ll=(int) ($ll/60);
$unit2="minutes";
}
if($ll >= 60)
{
$ll=(int) ($ll/60);
$unit2="hours";
if($ll >= 24)
{
$ll=(int) ($ll/24);
$unit2="days";
}
}
$str2="$ll $unit2 ago";
}
else
{
$str2="--";
}
if($r['user_level'] >1){ $r['username'] = "<font color=red>{$r['username']}</font>";}
elseif($r['donatordays']) { $r['username'] = "<font color=yellow>{$r['username']}</font>";$d="[img=don.gif]"; }
if($r['laston'] >= time()-15*60) { $on="<font color=green>[b]Online[/b]</font>"; } else { $on="<font color=red>[b]Offline[/b]</font>"; }
if($r['display_pic'])
{
print "<center>[img={$r[]
</center>";
}
else
{
print "<center>[img=http://i38.tinypic.com/29bh8d5.jpg]</center>
";
}
print "<table width=85% cellpadding=3 class='table' border='0'><div align=center>
<tr><td>
[b]Name:[/b] {$r['username']} [{$r['userid']}] $d
</td>
<td>
[b]User Level:[/b] [url='stafflist.php']$userl[/url]
</td></tr>
<tr><td>
[b]Level:[/b] {$r['level']}
</td>
<td>
[b]Health:[/b] {$r['hp']}/{$r['maxhp']}
</td></tr>
<tr><td>
[b]Gender:[/b] {$r['gender']}
</td>
<td>
[b]Age:[/b] {$r['daysold']} Days
</td></tr>
<tr><td>
[b]Signed Up:[/b] $sup
</td>
<td>
[b]Last Active:[/b] $str
</td></tr>
<tr><td>
[b]Gang:[/b] ";
if($r['gang'])
{
print "[url='gangs.php?action=view&ID={$r[']{$r['gangNAME']}[/url]";
}
else
{
print "None";
}
print "
</td>
<td>
[b]Location:[/b] [url='airport.php']{$r['cityname']}[/url]
</td></tr>
<tr><td>
[b]Money:[/b] \${$r['money']}
</td>
<td>
Property: {$r['hNAME']}
$wo2=mysql_query("SELECT * From petowned WHERE userid={$_GET['u']}",$c);
$ow2=mysql_fetch_array($wo2);
$pe2=mysql_query("SELECT * FROM userpets WHERE userid={$_GET['u']}",$c) or die(mysql_error());
$pet2=mysql_fetch_array($pe2);
if ($ow2['petowned'] == 0) {
print "Pet Owned: <font color='red'>No</font>
";
} else {
print "Pet Owned: [url='petview.php?u={$pet2[']{$pet2['petname']}[/url]
";
}
</td></tr>";
$sh=($ir['user_level'] >1) ? "Staff Info" : " ";
print "</td></tr>";
if($r['fedjail'])
{
print "
[b]<font color=brown>This user is in federal jail for {$r['fed_days']} day(s).
{$r['fed_reason']}</font>";
}
if($r['hospital'])
{
print "
[b]<font color=red>This user is in hospital for {$r['hospital']} minutes.
{$r['hospreason']}</font>[/b]
";
}
if($r['jail'])
{
print "
[b]<font color=red>This user is in jail for {$r['jail']} minutes.
{$r['jail_reason']}</font>[/b]</td></tr><tr> <td>
";
}
print "</div></table><table width=85% bgcolor=#202020 cellpadding=3>
<tr><td>
[[url='mailbox.php?action=compose&ID={$r[']Send Mail[/url]]
</td><td>
[[url='sendcash.php?ID={$r[']Send Cash[/url]]
<td>
[[url='sendpoints.php?ID={$r[']Send Points[/url]]
</td><td>
[[url='sendbank.php?ID={$r[']Bank Xfer[/url]]
</td></tr><tr><tr></tr></tr><tr><td>
[[url='sendcyber.php?ID={$r[']CyberBank Xfer[/url]]
</td><td>
[[url='attack.php?ID={$r[']Attack[/url]]
</td><td>
[[url='mug.php?ID={$r[']Mug[/url]]
</td><td>
[[url='contactlist.php?action=add&ID={$r[']Add Contact[/url]]
</td></tr><tr>";
{
print "
</tr><tr></tr><tr><td>
[[url='friendslist.php?action=add&ID={$r[']Add Friends[/url]]
</td><td>
[[url='blacklist.php?action=add&ID={$r[']Add Enemies[/url]]
</td>";
print "";
}
if($ir['user_level'] == 2 || $ir['user_level'] == 3 || $ir['user_level'] == 5)
{
print "
<td>
[[url='jailuser.php?userid={$r[']Jail[/url]]
</td><td>
[[url='mailban.php?userid={$r[']MailBan[/url]]
</td></tr>";
}
if($ir['donatordays'] > 0)
print "</table>
";
print"</center>";
if($ir['user_level'] == 2 || $ir['user_level'] == 3 || $ir['user_level'] == 5)
{
$r['lastiph']=@gethostbyaddr($r['lastip']);
$r['lastiph']=checkblank($r['lastiph']);
$r['lastip_loginh']=@gethostbyaddr($r['lastip_login']);
$r['lastip_loginh']=checkblank($r['lastip_loginh']);
$r['lastip_signuph']=@gethostbyaddr($r['lastip_signup']);
$r['lastip_signuph']=checkblank($r['lastip_signuph']);
print "<center><h3>Internet Info</h3><table width='100%' border='0' cellspacing='1' class='table'>
<tr><td></td><td class='h'>IP</td><td class='h'>Hostname</td></tr>
<tr><td class='h'>Last Hit</td><td >$r[lastip]</td><td >$r[lastiph]</td></tr>
<tr><td class='h'>Last Login</td><td '>$r[lastip_login]</td><td >$r[lastip_loginh]</td></tr>
<tr><td class='h'>Signup</td><td >$r[lastip_signup]</td><td >$r[lastip_signuph]</td></tr>
[url='staff_punit.php?action=ipform']<u>IP search this user</u>[/url]
";
print "<form action='staffnotes.php' method='post'>
Staff Notes:
<textarea rows=7 cols=40 name='staffnotes'>{$r['staffnotes']}</textarea>
<input type='hidden' name='ID' value='{$_GET['u']}' />
<input type='submit' value='Change' /></form></center>";
}
else
{
print " ";
}
print "</tr></table>";
}
}
function checkblank($in)
{
if(!$in) { return "N/A"; }
return $in;
}
$h->endpage();
?>
