Referrals In Postbit

[Developer]

Number Of Referrals In Postbit
Version 1.1.0
Description::.
This hack shows in postbit Number Of Referrals[Requested By cmiller1014 (https://vborg.vbsupport.ru/member.php?u=56624) ]
Hack Features::.
1-easy yo install
[See Screen Shot]
Installation::.
1-Import The product.
2-run this script admincp/misc.php?do=referrals to insert number of referrals into the new field
3-Edit Template postbit
Find:
<if condition="$post['joindate']"><div>$vbphrase[join_date]: $post[joindate]</div></if>

Add after it
<if condition="$vboptions['usereferrer']">
<div class="smallfont">
<strong>$vbphrase[referrals]</strong> $post[referrals]
</div>
</if>

2-Edit Template postbit_legacy
Find:

<if condition="$post['joindate']"><div>$vbphrase[join_date]: $post[joindate]</div></if>

Add after it

<if condition="$vboptions['usereferrer']">
<div class="smallfont">
<strong>$vbphrase[referrals]:</strong> $post[referrals]
</div>
</if>
History::.
1.0.0 On 21. Feb 2006 Initial Version.
1.1.1 On 26 Apr 2006 Fix Major BUG.
Hack Languages::.

English

Details::.
2 plugins, 3 phrases, 0 option, 0 query
Donation::.
Feel Free To https://vborg.vbsupport.ru/external/2010/09/1.gif (https://www.paypal.com/cgi-bin/webscr?cmd=_xclick&business=filmahosting%40gmail%2ecom&item_name=DEVELOPER&item_number=1&no_shipping=0&no_note=1&tax=0&currency_code=USD&bn=PP%2dDonationsBF&charset=UTF%2d8)
aT lAsT::.
IF YOu lIkE iT cLIcK INSTALL
vbulletin.orghttps://vborg.vbsupport.ru/ (https://vborg.vbsupport.ru/vborg_miscactions.php?do=installhack&threadid=108558)[/B]
Support Given For Who Clicked Install {ONLY}

[bashy]

Hi m8

Me again, tis sommat about your hacks :)
Anyway just installed this (im gonna have to stop this soon lol) and
i can see the number of refferrals but not the phrase...
I only see e.g. :4

I have edited both templates and imported the plugin :)

Sorry m8 lol....

[LadyJo]

same thing is happening to me. ON people who have no referrals its blank, no number, and all we see is :

[Mr Chad]

same thing is happening to me. ON people who have no referrals its blank, no number, and all we see is :

Add an if condition... If X > 0

[proxx]

Add an if condition... If X > 0


what do you mean? where to add and how?

I have teh same problem

[proxx]

I am getting this problem:


Database error in vBulletin 3.5.2:

Invalid SQL:
SELECT COUNT(*) AS count FROM user WHERE referrerid =;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Error Number : 1064
Date : Tuesday, February 21st 2006 @ 09:50:38 PM
Script : http://***/showthread.php?p=6720
Referrer :
IP Address : 65.54.111.69
Username : Unregistered
Classname : vb_database

[redspider]

Hi m8

Me again, tis sommat about your hacks :)
Anyway just installed this (im gonna have to stop this soon lol) and
i can see the number of refferrals but not the phrase...
I only see e.g. :4

I have edited both templates and imported the plugin :)

Sorry m8 lol....
Same issue here...

[redspider]

Here is the fix...


In postbit template
Find:
<if condition="$post['joindate']"><div>$vbphrase[join_date]: $post[joindate]</div></if>

Add after it
<if condition="$vboptions['usereferrer']">
<div class="smallfont">
Referrals<strong>$vbphrase[referrals]:</strong> $developerref
</div>
</if>

In postbit_legacy template
Find:
<if condition="$post['joindate']"><div>$vbphrase[join_date]: $post[joindate]</div></if>

Add after it
<if condition="$vboptions['usereferrer']">
<div class="smallfont">
Referrals<strong>$vbphrase[referrals]:</strong> $developerref
</div>
</if>

[bashy]

Cheers m8 working fine now!!

[Floris]

That looks cool! Nice to have :) Nice postbit too btw ;)

[proxx]

could someone tell me how to fix this error, i get many of these emailed to me:


Database error in vBulletin 3.5.2:

Invalid SQL:
SELECT COUNT(*) AS count FROM user WHERE referrerid =;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Error Number : 1064
Date : Tuesday, February 21st 2006 @ 09:50:38 PM
Script : http://***/showthread.php?p=6720
Referrer :
IP Address : 65.54.111.69
Username : Unregistered
Classname : vb_database

[Lea Verou]

Doesn't this add one query to EACH post? :confused:

[Scratz]

Just thought i would let the developer know that when I applied the plugin and edited the templates that it was calling for the referrals vbphrase when in my 3.5.4 forum the phrase was referrers..

Don't know if it was due some change I did but putting it out there anyway.

[trackpads]

I am having this same issue, The cause is from the post being by a guest or user 0. Since I have some USENET posts these have no userid and the plugin crashes the thread.

Any idea if we can get an update that eliminates the referall call on guest posts?

Thanks!

-Jason

[Developer]

i'll update this hack soon

[trackpads]

Thanks! It is a great hack!!

[trackpads]

Any luck?

[trackpads]

Ok, had some other folks here help me on this and here is the patch:

Go into your Admincp, plugins and edit the plugin: Number Of Referrals in postbit-by Developer

Replace this:

if ($vbulletin->options['usereferrer'])

With this:

if ($this->post['userid'])

And it will work with USENET and Guest posts!

(Thanks to tnguy3n, Hambil, gio~logist and Zachery!)

[Zachery]

Still, a problem with this hack is it runs an addtional query for each post.

It would much better to do an update for each user and log their total user referals. Then log new referals from then on out.

[Developer]

Fixing It now i'll add a plugin in update counters so you have to run something after installing the hack so it counts referrals and then insert it in a field in user's table using datamanger.

[Developer]

Version 1.1.0 Released fixs all bugs, added a new field in user table to add in it the total number of referrals to avoid using query for each post and you have first to uninstall the old plugin then install the new product and make sure overwrite set on no, after this u've to run this script admincp/misc.php?do=referrals to insert number of referrals into the new field, then do the new template edit

[Boofo]

Will you have to always manually update the referrals in the Admin CP or just the first time?

[Developer]

Nop, first time only
after that automatically in registration using datamanger it will add + 1 to the field in user's table.(look at the product)

[Boofo]

Great! I'll give it a shot then. ;)

[Boofo]

Nop, first time only
after that automatically in registration using datamanger it will add + 1 to the field in user's table.(look at the product)

I got to looking at the code and was wondering if there wasn't a way to have that query run on install and not show up in the Maintenace tools at all, if it isn't supposed to be run after the first time. Someone is gonna accidentally run that again, it's bound to happen. ;)

Or am I missing it altogether about that query and what it does?

[Zachery]

You could run it again, noting bad should happen. It basicly rebuilds the entire count and sets it even.

[Boofo]

You could run it again, noting bad should happen. It basicly rebuilds the entire count and sets it even.

What do you mean even?

[FunaGuy]

Installed!
Working Properly :)

[Zachery]

What do you mean even?
You could run the update counter all day long, it would be horrible for preformance but besides that it wouldn't do anything bad or destory the counts.

[The Chief]

works awesome, thanks!

/me clicks install

[Mr Chad]

This does not work in combo with Allow users to delete their account (https://vborg.vbsupport.ru/showthread.php?t=105181&page=2)

Show referal count in postbit.


Database error in vBulletin 3.5.4:

Invalid SQL:
SELECT COUNT(*) AS count FROM user WHERE referrerid =;

MySQL Error : You have an error in your SQL syntax. Check the manual
that corresponds to your MySQL server version for the right syntax to
use near '' at line 1
Error Number : 1064
Date : Sunday, May 21st 2006 @ 07:13:43 PM
Script : http://www.beasttoast.com/forum/showthread.php?t=2386
Referrer : http://www.beasttoast.com/forum/forumdisplay.php?f=8
IP Address : 69.86.105.84
Username : Girl
Classname : vb_database

Please help me out :)

[Mr Chad]

anyone?

[Zachery]

Make sure you are running the latest version.

[Mr Chad]

Make sure you are running the latest version.
I do have the latest version.

I only get this error if a member has deleted their account and had a post in the thread im trying to look @.

[Zachery]

But the latest version doesn't query the database.

[pbradish]

Works like a charm, thank you.

[Chicago_VLNU_4s]

thanks.. real nice code

[Ohiosweetheart]

does this one work in 3.6.x?

[acco]

Working fine in our testforum after the upgrade from 3.6.0 to 3.6.4

[Ohiosweetheart]

thanks acco!

[imk]

great hack thank sman

[Boosted Panda]

Wanted to bump this up. Working on 3.7.1 but you have to manually update the referrals for them to show up :(

[Ossedis]

Aww. I need one for 3.7.3