Jump to content
MakeWebGames

Viewuser help

lukeybabe

By lukeybabe
in Game Support

 Share

Recommended Posts

lukeybabe Newbie

lukeybabe

Posted
Posted

Hello i thought this view user file and i need a little help fixing if u can help fix it can u just post the fixed file here thanks.

<?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);
$m=$db->query("SELECT * FROM users WHERE userid={$r['married']}"); $par=$db->fetch_row($m); 
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['married'] != 0) { $partner= "[url='viewuser.php?u={$par[']<font color=green>{$par['username']}</font>[/url]"; } else { $partner= "<font color=red>N/A</font>"; }

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"[b]Name:[/b] {$r['username']} [{$r['userid']}] $d
";

print"[b]User Level:[/b] [url='stafflist.php']$userl[/url]
";

print"[b]Level:[/b] {$r['level']}
";

print"[b]Health:[/b] {$r['hp']}/{$r['maxhp']}
";

print"[b]Gender:[/b] {$r['gender']}


print"[b]Married:[/b] $partner


print"[b]Age:[/b] {$r['daysold']} Days
";

print"[b]Signed Up:[/b] $sup
";

print"[b]Last Active:[/b] $str
";

print"[b]Gang:[/b] ";

if($r['gang'])

{

print "[url='gangs.php?action=view&ID={$r[']{$r['gangNAME']}[/url]";

}

else

{

print "None";

}
print"[b]Location:[/b] [url='DCrail.php']{$r['cityname']}[/url]
";

print"[b]Money:[/b] \${$r['money']}
";

print"[b]Property:[/b] {$r['hNAME']}


$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>
";

}
echo"<hr>";
echo"<center>";
print"<h3>[b]<u>Actions</u>[/b]";
echo"<hr>";
echo"</center>";
print"[[url='mailbox.php?action=compose&ID={$r[']Send Mail[/url]]";
print"[[url='sendcash.php?ID={$r[']Send Cash[/url]]";
print"[[url='sendcrys.php?ID={$r[']Send crystals[/url]]";
print"[[url='sendbank.php?ID={$r[']Bank Xfer[/url]]";
print"[[url='sendcyber.php?ID={$r[']CyberBank Xfer[/url]]";
print"[[url='attack.php?ID={$r[']Attack[/url]]";
print"[[url='mug.php?ID={$r[']Mug[/url]]";
print"[[url='contactlist.php?action=add&ID={$r[']Add Contact[/url]]";
print"[[url='friendslist.php?action=add&ID={$r[']Add Friends[/url]]";
print"[[url='blacklist.php?action=add&ID={$r[']Add Enemies[/url]]";
}
if($ir['user_level'] == 2 || $ir['user_level'] == 3 || $ir['user_level'] == 5)
{
echo"<center><h3><u>[b]Staff actions</center></h3></u>[/b]";
print"[[url='jailuser.php?userid={$r[']Jail[/url]]";
print"[[url='forumban.php?userid={$r[']Forum Ban[/url]]";
print"[[url='mailban.php?userid={$r[']MailBan[/url]]";
}
if($ir['donatordays'] > 0)

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();

?>
Dayo Experienced

Dayo

Posted
Posted

EDIT

print"[b]Gender:[/b] {$r['gender']}


print"[b]Married:[/b] $partner

should be

print "[b]Gender:[/b] {$r['gender']}
";

print "[b]Married:[/b] $partner
";

also you need to change


print"[b]Property:[/b] {$r['hNAME']}

to 


print"[b]Property:[/b] {$r['hNAME']}
";
  • 1 month later...
JAMESOMIGHTY Newbie

JAMESOMIGHTY

Posted
Posted 
<?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);
$m=$db->query("SELECT * FROM users WHERE userid={$r['married']}"); $par=$db->fetch_row($m); 
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['married'] != 0) { $partner= "[url='viewuser.php?u={$par[']<font color=green>{$par['username']}</font>[/url]"; } else { $partner= "<font color=red>N/A</font>"; }

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"[b]Name:[/b] {$r['username']} [{$r['userid']}] $d
";

print"[b]User Level:[/b] [url='stafflist.php']$userl[/url]
";

print"[b]Level:[/b] {$r['level']}
";

print"[b]Health:[/b] {$r['hp']}/{$r['maxhp']}
";

print "[b]Gender:[/b] {$r['gender']}
";

print "[b]Married:[/b] $partner
";

print"[b]Age:[/b] {$r['daysold']} Days
";

print"[b]Signed Up:[/b] $sup
";

print"[b]Last Active:[/b] $str
";

print"[b]Gang:[/b] ";

if($r['gang'])

{

print "[url='gangs.php?action=view&ID={$r[']{$r['gangNAME']}[/url]";

}

else

{

print "None";

}
print"[b]Location:[/b] [url='DCrail.php']{$r['cityname']}[/url]
";

print"[b]Money:[/b] \${$r['money']}
";

print"[b]Property:[/b] {$r['hNAME']}
";

$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>
";

}
echo"<hr>";
echo"<center>";
print"<h3>[b]<u>Actions</u>[/b]";
echo"<hr>";
echo"</center>";
print"[[url='mailbox.php?action=compose&ID={$r[']Send Mail[/url]]";
print"[[url='sendcash.php?ID={$r[']Send Cash[/url]]";
print"[[url='sendcrys.php?ID={$r[']Send crystals[/url]]";
print"[[url='sendbank.php?ID={$r[']Bank Xfer[/url]]";
print"[[url='sendcyber.php?ID={$r[']CyberBank Xfer[/url]]";
print"[[url='attack.php?ID={$r[']Attack[/url]]";
print"[[url='mug.php?ID={$r[']Mug[/url]]";
print"[[url='contactlist.php?action=add&ID={$r[']Add Contact[/url]]";
print"[[url='friendslist.php?action=add&ID={$r[']Add Friends[/url]]";
print"[[url='blacklist.php?action=add&ID={$r[']Add Enemies[/url]]";
}
if($ir['user_level'] == 2 || $ir['user_level'] == 3 || $ir['user_level'] == 5)
{
echo"<center><h3><u>[b]Staff actions</center></h3></u>[/b]";
print"[[url='jailuser.php?userid={$r[']Jail[/url]]";
print"[[url='forumban.php?userid={$r[']Forum Ban[/url]]";
print"[[url='mailban.php?userid={$r[']MailBan[/url]]";
}
if($ir['donatordays'] > 0)

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();

?>

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...