Referral Hall Of Fame?

[Macintrash]

I just got done with a bunch of updates, and a referral hall of fame was last on my list. I got everything done, i was so happy. Now im stuck on the hall of fame :(

See, normally the hall of fame uses a code like this:

function hof_level()

{

global $ir,$c,$userid;

print "Showing the 40 users with the highest levels

<table width=75%><tr style='background:gray'> <th>Pos</th> <th>User</th> <th>Level</th> </tr>";

$q=mysql_query("SELECT u.*,g.* FROM users u LEFT JOIN gangs g ON g.gangID=u.gang WHERE u.user_level != 7 && u.user_level != 10 && u.user_level != 0 && u.user_level != 2 ORDER BY level DESC,userid ASC LIMIT 40", $c);

$p=0;

while($r=mysql_fetch_array($q))

{

$p++;

if($r['userid'] == $userid) { $t="";$et=""; } else { $t="";$et=""; }

print "<tr> <td>$t$p$et</td> <td>$t{$r['gangPREF']} {$r['username']} [{$r['userid']}]$et</td> <td>$t{$r['level']}$et</td> </tr>";

}

That ones for "level"

But getting a number of the amount of referrals you have involves a code like this:

$rr=mysql_query("SELECT * FROM referals WHERE refREFER={$r['userid']}",$c);

I was thinking of adding that in there, and changing the order by level to order by $rr, but i get errors

Anyone know whats wrong? Im completely baffled, please help!

[wolfe]

Re: Referral Hall Of Fame?

Search feature is your friend...

http://criminalexistence.com/ceforums/h ... 60#p133360

[Macintrash]

Re: Referral Hall Of Fame?

That one gives me an error :(

Fatal error: Call to a member function on a non-object in /home/unive21/public_html/halloffame.php on line 155

[wolfe]

Re: Referral Hall Of Fame?

Well we could guess what lines are around 155...

[Macintrash]

Re: Referral Hall Of Fame?

Yeah i fixed it

[fbiss]

Re: Referral Hall Of Fame?

Once again.. Game Modifications category is not for requesting mods or help fixing errors

***Topic moved***