referrerid='$usersid'

should be

referrerid='$userid'

oh. Isnt it supposed to be $usersid since in the first line it says :
$usersid=$this->post['userid'];

I'm not a php coder at all but I thought that line assigns the userid to $usersid ?
Please feel free to correct me. I'm sure to learn something new here.

BTW, setting it to referrerid='$userid' in the where clause didint work either. :(

My bad. I didn't look close enough, I guess.

Look at the other queries in the mod. The should give you an idea of how to run it.

Try changing your hook location for your query to the postbit_display_complete.

Thanks! that did the trick! It works now. :D

For anyone interested Here's the plugin : (Admin CP -> Plugins & Products -> Plugin Manager -> Add New Plugin )
Product : Vbulletin
Hook Location : postbit_display_complete
Titile : Referrals in Postbit
Execution Order : 5
Plugin PHP code :

Code:

---

$usersid = $this->post['userid'];
        $refcount = mysql_query("SELECT username FROM " . TABLE_PREFIX . "user WHERE referrerid='$usersid'");
        $referrals = mysql_num_rows($refcount);
        $template_hook['postbit_userinfo_right_after_posts'] .= '<dt>Referrals</dt><dd> '.  $referrals.'</dd>';

---

Plugin is Active : yes

Like Boofo said, this adds a query for every post.

Nice mod - thanks!

Thank you. *installed*

The link to the Profile AboutMe Tab in the UserCP Box does not work for me.
Just a note ;)

hey i just noticed that every profile have my referral id...i mean they all have admin referral id not theirs why is that so and that additional.css where can i find that...and if i have to add then where should i add...

also please help me for this referral link...they all have same referral link which is ending up with my id number....

try to help me asap...

regards

sorry to bother you but its working now...

regards

It will only work if there is at least one referreral name to link to.