Show Thread Enhancements - Referrals in Postbit

Dear vBulletin users,

Yesterday I saw a thread about "how to show referrals in postbit" and I decided to do a favour to those people who want that.

HOW TO INSTALL

1) Please upload the "plugin" first.

2) Go to your postbit or postbit_legacy template and find:

$vbphrase[posts]: $post[posts]

Add after:

<br />Referrals: $referrals

That's all!

Congratulations! You have it working!

Do not forget to click install!

[Surviver]

This Hack adds 1 Query to echt post in showthread.php. That isnÄt good for the performace (You can get problems if your Server is slow).

[WhaLberg]

Originally Posted by Jay...

is there anyway to get the font of 'Referrals' in the postbit the same as the rest of the items in the postbit?

have a look at where it says referrals, you'll see what i mean

http://www.donkproject.net/forum/showthread.php?t=399

Originally Posted by Loco.M

nice hack, I agree .. I would want the font a little smaller to match

Change that

<br />Referrals: $refferals

to:

<br /><div class="smallfont">Referrals: $referrals</div>

This should work.

Originally Posted by Surviver

This Hack adds 1 Query to echt post in showthread.php. That isn?t good for the performace (You can get problems if your Server is slow).

A suggestion would be better.

Originally Posted by Ken Iovino

I would suggest using vBulletins database class to do this.

PHP Code:

$refcount = $db->query_first_slave("SELECT COUNT(*) AS count FROM " . TABLE_PREFIX . "user WHERE referrerid = $this->post[userid]");
$referrals = vb_number_format($refcount['count']); 


Would be more efficient.

I used that before but there were some errors so I changed it. Thanks for the information.

[Zerovb]

Thnaks Good Idea

But I Cant Find The Code In Postbit_Legacy

I Only Found It In Postbit

[Logikos]

Originally Posted by whalberg

I used that before but there were some errors so I changed it. Thanks for the information.

What were the errors? That code is also used in the default member.php file, so I don't see how there could have been errors.

[WhaLberg]

Originally Posted by Ken Iovino

What were the errors? That code is also used in the default member.php file, so I don't see how there could have been errors.

Yes, I know, that's why I tried it first.

It was about the variable. I'll check it later again.

[ChinniePaws]

*Installs*
Thanks - so far so good

[DieselMinded]

Thanks Worked Great !

DM

[krazycivik]

it comes up but i dont see the number of refferals :S

[WhaLberg]

Originally Posted by krazycivik

it comes up but i dont see the number of refferals :S

How come?

It works great for everyone?

[DieselMinded]

This has caused an uprise in referrals Members dont like seeing a Zero in there

Thanks Again

DM