VeiwUser.php error

[Monkey644]

When i got to veiw a users page with the veiwuser.php page, it show my username and not the persons that i go to see.

 

Can anyone help me at all?

 

My veiwuser.php code can be found below.

 

 

<?php
include "globals.php";
$_GET['u'] = abs((float) $_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="Member"; } else if($r['user_level'] == 2) { $userl="Admin"; } else if ($r['user_level'] == 3) { $userl="Secretary"; } else if($r['user_level'] == 0) { $userl="NPC"; } else if ($r['user_level'] == 4) { $userl="Fed Jail Warden"; } else if ($r['user_level'] == 5) {$userl="Assistant"; } else if ($r['user_level'] == 6) {$userl="Forum Moderator"; }
$lon=($r['laston'] > 0) ?date('F j, Y g:i:s a',$r['laston']) : "Never";
$sup=date('F j, Y g:i:s a',$r['signedup']);
$ts=$r['strength']+$r['agility']+$r['guard']+$r['labour']+$r['IQ'];
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>"; 
}
$zom=$db->query("SELECT * FROM hvzstats");
$hvz=$db->fetch_row($zom);
if($ir['user_level'] > 1)
{
if($hvz['hvz'] ==1)
{
if($r['humanorzombie'] == 1) { $zomb="<font color='red'>Zombie</font>";$kills= "Kills: <font color='red'> {$ir['zombiekills']}</font>
";}
if($r['humanorzombie'] == 0) { $zomb="<font color='#33CC33'>Human</font>"; }
$ztext= "Status: $zomb
$kills";
}
}
if($r['donatordays']) { $r['username'] = "<font color=green>{$ir['username']} </font> [img=donator.gif]"; }
if($r['laston'] >= time()-15*60) { $on="<font color=green>[b]Online[/b]</font>"; } else { $on="<font color=red>[b]Offline[/b]</font>"; }
print "<h3>Profile for {$r['username']}</h3>
<table width=100% cellspacing=1 class='table'><tr style='background:gray'><th>General Info</th><th>Financial Info</th> <th>Display Pic</th></tr>
<tr><td>Name: {$r['username']}

$ztext
User Level: $userl

Duties: {$r['duties']}

Gender: {$r['gender']}

Married: $partner

Signed Up: $sup

Last Active: $lon

Last Action: $str

Last Login: $str2

Online: $on

Days Old: {$r['daysold']}

Location: {$r['cityname']}[url='travelto.php?to={$r['][Travel to Location][/url]</td><td>
Money: \${$r['money']}

Diamonds: {$r['diamonds']}

Points: {$r['points']}
";
if($r['married'])
{
$sql2 = sprintf("SELECT * FROM houses WHERE hID={$r['shared']}",$c);
$ho = $db->query($sql2);
$hs = $db->fetch_row($ho);
$sql3 = sprintf("SELECT * FROM users WHERE userid={$r['married']}");
$ma = $db->query($sql3);
$mr = $db->fetch_row($ma);
print "Property: {$hs['hNAME']} [With: [url='viewuser.php?u={$mr[']{$mr['username']}[/url]]";
}
else
{
print "Property: {$r['hNAME']}";
}
print "

Referals: ";
$rr=$db->query("SELECT * FROM referals WHERE refREFER={$r['userid']}");
print $db->num_rows($rr);
print "

Friends: {$r['friend_count']}

Enemies: {$r['enemy_count']}

</td> <td>";
if($r['display_pic'])
{
print "[img={$r[]";
}
else
{
print "This user has no display pic!";
}
$sh=($ir['user_level'] >1) ? "Staff Info" : "";
print "</td></tr>
<tr style='background:gray'><th>Physical Info</th><th>Links</th><th>$sh</th></tr>
<tr><td>Level: {$r['level']}

Health: {$r['hp']}/{$r['maxhp']}

Forum Posts: {$r['posts']}

Forum Credits: {$r['fcredits']}

Gang: ";
if($r['gang'])
{
print "[url='gangs.php?action=view&ID={$r[']{$r['gangNAME']}[/url]";
}
else
{
print "N/A";
}
if($r['fedjail'])
{
print "
[b]<font color=red>In federal jail for {$r['fed_days']} day(s).

{$r['fed_reason']}</font>";
}
if($r['hospital'])
{
print "
[b]<font color=red>In hospital for {$r['hospital']} minutes.
{$r['hospreason']}</font>[/b]";
}
if($r['jail'])
{
print "
[b]<font color=red>In jail for {$r['jail']} minutes.
{$r['jail_reason']}</font>[/b]";
}
print "</td><td>[[url='mailbox.php?action=compose&ID={$r[']Send Mail[/url]]


[[url='sendcash.php?ID={$r[']Send Cash[/url]]


[[url='sendpoints.php?ID={$r[']Send Points[/url]]

";
if($set['sendcrys_on'])
{
print "[[url='senddias.php?ID={$r[']Send Diamonds[/url]]

";
}
if($set['sendbank_on'])
{
if($ir['bankmoney'] >= 0 && $r['bankmoney'] >= 0)
{
print "[[url='sendbank.php?ID={$r[']Bank Xfer[/url]]

";
}
if($ir['cybermoney'] >= 0 && $r['cybermoney'] >= 0)
{
print "[[url='sendcyber.php?ID={$r[']CyberBank Xfer[/url]]

";
}
}
print "
[[url='assassin.php?ID={$r[']Assassinate[/url]]


[[url='attack.php?ID={$r[']Attack[/url]]


[[url='contactlist.php?action=add&ID={$r[']Add Contact[/url]]";
if($ir['user_level'] == 2 || $ir['user_level'] == 3 || $ir['user_level'] == 5)
{
print "


[[url='jailuser.php?userid={$r[']Jail[/url]]


[[url='mailban.php?userid={$r[']MailBan[/url]]";
}
if($ir['donatordays'] > 0)
{
print "


[[url='friendslist.php?action=add&ID={$r[']Add Friends[/url]]


[[url='blacklist.php?action=add&ID={$r[']Add Enemies[/url]]
";
}
print "</td><td>";
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 "<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></table>";
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>";
}
else
{
print "";
}
print "</tr></table>";
}
}
function checkblank($in)
{
 if(!$in) { return "N/A"; }
 return $in;
}
$h->endpage();
?>

[Equinox]

Is the person you're trying to look at a donator?

[Dominion]

line 86 your using $ir thats your user data. the data for the profile your viewing is $r

 

 $r['username'] = "<font color=green>{$r['username']} </font> [img=donator.gif]";

[Equinox]

line 86 your using $ir thats your user data. the data for the profile your viewing is $r

 

 $r['username'] = "<font color=green>{$r['username']} </font> [img=donator.gif]";

'tis why I asked if they were a donator, then for sure that is the problem >.<

[Monkey644]

I'll try this and see if it works. Cheers :D

[Monkey644]

STARS!!!!!!!!!!! Absolutly Love all of MWG

[Dominion]

'tis why I asked if they were a donator, then for sure that is the problem >.<

well the issue asked about or not does not really matter, its an issue so fixing it to stop more posts may help in the long run ;)