Referral Statistics

Are you looking for statistics on the number of referrals your members have made? Or are interested in promoting your website by allowing members to engage in a referral competition?


THIS HACK IS FOR YOU
To show referral statistics from members and to manage referral competitions.
- this hack is to help you manage your forums referrals
- promote new user registrations
- perfect for contests/promotional giveaways or incentives for referrals
- INSTALL today and start managing your boards referrals.

Features:

- Limit the number of results shown
- Admin ability to reset all members referrals to zero
- Admin ability to reset "specific members" referrals to zero
- Includes an update to your whois online
- Up-to-date listing on when you last reset all members referrals to zero
*** Seen in the admincp and an option for all members to view
- Total number of referrals since last reset
*** viewable in admincp and again an option for all members to view
- Pagination is now included and an option for another at bottom of results
- Shows up-to-date total number of board referrals
- Shows leading referrer in admincp
- Ability to limit referral results by number of posts or a usergroupid(s)
- Configuration is now done in admincp
- Auto installer now included w/ auto un-installer
- BEST OF ALL (LETS MEMBERS REFER MORE PEOPLE TO YOUR SITE.

I will like always SUPPORT my hacks

Thanks goes out to: unixman - for all the referred members are now clickable to their profile.

Total install time: less than 3 minutes.
New templates: 2 - refer, referbit
New files to upload: 2 pages
Edit templates: 2 - footer, /includes/functions_online.php
File edit: 1 - /admincp/index.php


** 4/17/05 - Version 2.3 Released = Includes many new one click options in the admincp, also auto configures your vbulletin path (which many people were having errors performing) **

[venomx]

Originally Posted by 007

Hey does this reset the user's actual referral count shown in their profile if you start a new promotion? Or is there a seperate field?

Also, how hard would it be to add conditionals to the referral number? I want it to only show referrals if they have X posts.

Thanks!

~007

Not sure about the first part but the second one is in there. you can set it to only show the refs when the refs hit X posts.

[007]

Cool. I'm just confused when he says

"Admin ability to reset all referrals to zero (for referral competitions, etc..)"

That's good, but I want to know if the real number is still displayed in profiles and such. I am working on a mod for uShop that pays you $ when your referrals post, and I would hate for people to lose their referrals.

Otherwise I will install this ASAP. Will be very nice to have!

[gspot]

Originally Posted by 007

Cool. I'm just confused when he says

"Admin ability to reset all referrals to zero (for referral competitions, etc..)"

That's good, but I want to know if the real number is still displayed in profiles and such. I am working on a mod for uShop that pays you $ when your referrals post, and I would hate for people to lose their referrals.

Otherwise I will install this ASAP. Will be very nice to have!

It will reset users referral total forum-wide. So no it wouldnt be available once you reset the referrals, but if you don't need to reset them, then don't.

[venomx]

I thought it kept Total since joining and total since rest?

[gspot]

Originally Posted by venomx

I thought it kept Total since joining and total since rest?

Whats the problem that you are having? It should..

[venomx]

No I have no problems.. :P
You told him it lost the ref when reset...

If it keeps the count then I am guessing it loses the names of the people you refered?
Is that VB wide or just this hack?

[gspot]

Originally Posted by venomx

No I have no problems.. :P
You told him it lost the ref when reset...

If it keeps the count then I am guessing it loses the names of the people you refered?
Is that VB wide or just this hack?

I believe vb wide

[007]

But you wrote it lol! Hmm, I can't use it if it resets vb wide

[Jason McConnell]

Good idea for a hack, and the install instructions seem simple enough, but I get this error:

Database error in vBulletin 3.0.7:

Invalid SQL: SELECT * FROM referrals
mysql error: Table 'xxxxxxxxx.referrals' doesn't exist

mysql error number: 1146

Date: Tuesday 19th of April 2005 06:03:43 AM
Script: http://www.thefraglimit.com/forum/ad...rralstatistics
Referer: http://www.thefraglimit.com/forum/ad...dex.php?do=nav
Username: ICeMaN
IP Address:

Did I miss a database query or something?

[gspot]

Originally Posted by Jason McConnell

Good idea for a hack, and the install instructions seem simple enough, but I get this error:



Did I miss a database query or something?

Make sure you started with a new installation and not an upgrade. Run the install again even if it asks you to perform an uninstall. Then let me know what you get.