[Boofo]

Here's how I used it in my User CP Referrer hack to get the referrer name in the profile, it this helps at all:

PHP Code:

global $show;
 
if ($this->registry->options['usereferrer'])
{
 $referral = $this->registry->db->query_first_slave("
  SELECT userid, username FROM " . TABLE_PREFIX . "user
  WHERE userid = " . $this->userinfo['referrerid'] . "
 ");
 $this->prepared['referralsname'] = $referral['username'];
 $this->prepared['referralsuserid'] = $referral['userid'];
 
 if ($this->prepared['referralsuserid'] > 0)
 {
  $show['referrer'] = true;
 }
 else
 {
  $show['referrer'] = false;
 }
} 


I used it in the userprofile_create hook.