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!

[zendiver]

I'm a bit confused why this 'plug-in' is needed. Isn't this actually already part of vBulletin. Can't you just use the following without having to install another plug-in? Just make a new phrase variable as referrals and make it vBulletin Global.

<if condition="$vboptions['usereferrer']">$vbphrase[referrals]: <strong>$referrals</strong></if>

Well, I guess not, but I find this exact code in the MEMBERINFO template. Not sure why it will not work in the postbit(_legacy)

UPDATE: I found the plug-in already installed in vBulletin ("Number of Referrals") for the hook_location "usercp_complete". Took the exact information and duplicated for the hook_location "postbit_display_start" then everything is as it is suppose to be. Sorry for the rant and thread hi-jack.

[grant.hayman]

Was wondering if it is possible to to show referrers from this month only...

I want to run a monthly competition for referrels and this would show users where they stand.

Is there somwhere i can edit the query?

Also I am looking for some type of leader board anyone know of any or where is best to start to create one. would love to add to this hack as it looks like this would help increase membership to any forum.

Thanks

[grant.hayman]

Managed to sort out the this month bit...

altered the code to this: (hope this is ok to alter code, if not please remove this post and except my appologies :erm

$usersid = $this->post['userid'];
	$refcount = mysql_query("SELECT username FROM " . TABLE_PREFIX . "user WHERE referrerid='$usersid' AND MONTH(FROM_UNIXTIME(`joindate`))=MONTH(now())
 ");
	$referrals = mysql_num_rows($refcount);

Baisicly added the AND clause on the end and it seems to work great.

I was also wondering if I only want certain user groups for this to work on (usergroup of the poster not viewer) and I put an conditional statement in my posbit will the queries still run but wont show or do they not run at all.

Thanks again for a great hack

[DieselMinded]

Originally Posted by hornstar1337

Looking forward to this update. How is the progress coming?

Im Game

[WhaLberg]

The new release is coming soon. I will update all of my released products together.

[Gharibe]

Thanks ,
it was what i requested

works fine

[CrashPush]

Great hack that works with 3.7.0 B5 just fine.

[Alfa1]

Does this fix in vb 3.7 RC1 resolve the problem of this hack with large table scans:
http://www.vbulletin.com/forum/proje...?issueid=24856
It was causing my forum to drastically slow down.

[figu120]

Gracais lo ensayare a ver pues se ve algo interesante

[Boofo]

There has been numerous promises of updates and fixes and nothing seems to have happened so far. Are you even supporting this hack any more? Shouldn't make promises you don't intend to keep.