show user names that someones has referered to the site?

[jamie]

Is it possible to show the user names of users that someone has referered to the site in their profile?


thanks :)

$referrers = DB_site->query("SELECT username,userid FROM user WHERE referrerid='X'");
echo("$bbuserinfo[username] has referred these users: ");
while ($referrer = mysql_fetch_array($referrers)) {
++$i
echo("<a href=\"member.php?s=$session[sessionhash]&action=getinfo&userid=$referrers[userid]\">$referrers[username]</a>");
if ($i < mysql_num_rows($referrers)) {
echo(", ");
}
}
echo(".");

hey thanks http://mbnforum.com/smi/cheers.gif


now i'll have fun trying to implement it!

Sorry. :) Wasn't thinking.
In member.php, find
if ($userinfo[yahoo]!="") {
eval("\$userinfo[yahooicon] = \"".gettemplate("yahoo")."\";");
} else {
$userinfo[yahoo]="&nbsp;";
}
Right under it add
$referrers = DB_site->query("SELECT username,userid FROM user WHERE referrerid='X'");
$userreferrals = "$bbuserinfo[username] has referred these users: ");
while ($referrer = mysql_fetch_array($referrers)) {
++$i
$userreferrals .= "<a href=\"member.php?s=$session[sessionhash]&action=getinfo&userid=$referrers[userid]\">$referrers[username]</a>";
if ($i < mysql_num_rows($referrers)) {
$userreferrals .= ", ";
}
}
$userreferrals .= ".";
Then in the getinfo template, use $userreferrals whereever you want the list to appear.