Referrals in Postbit

This hack displays the number of users each user has referred (via the referral system) in the postbit.

[Corleone]

It worked! Thanks a lot. Your help on this has been greatly appreciated.

[Talisman]

It's fixed. Yay!! :banana:

[partang2]

Thanks m8!

*Clicks Install*

[Talisman]

I made a change to ours that someone else might like. For anyone using vbStats (or another hack like it) that shows your top referrers on a page, you could make this part in your postbit.... clickable.

That lets your members go check who all those people are that someone referred.

In the postbit template, instead of using "Referred: $post[ referredcount] users" ..... you would use:

Referred: <a href="/forum/vbstats.php?action=memberrefer" target="_blank">$post[ referredcount] users</a>

(Guess I'll also attach a screenshot to show how it looks on our posts.)

Cheers all,

Talis.

PS ~ We're using "member(s)" instead of "users."

PPS ~ Hellsatan is just kidding us about the <br /> :cross-eyed:

[Chris M]

No I am not

<br /> is what it should be

<br /> is what vBulletin should make vB3 templates...

<br /> is XHTML compliant...

Satan

[Talisman]

Hehehe.

(Men are so easy.)

[Alien]

So this adds 1 query to each postbit page?

[Erwin]

Wouldn't this add one query for EACH post in showthread? So if you have 20 posts, that is an additional 20 queries in showthread on top of whatever you have already? Plus since you are doing a count, this will slow down the loading of showthread. Not that there is any way around this without adding another column to store the number. But good work in making it work. Not sure if this can be optimized without adding another column to the user table.

[Boofo]

I thought it only added 2 queries to the showthread.

[Talisman]

Well, I wondered about that, too. So I disabled it by commenting out that line in the postbit and there was no difference. Same number of queries on the page (showing 5 posts) as when it was active.

That doesn't seem right though .... the queries don't run if the variable is commented out, do they?

Anyway, with everything else I've got going already, I figure my site's gonna blow up sometime next week ..... either way.