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


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]=" ";
  }

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.