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) **

[Gastongr]

Does vB 3.0.1 support this hack?

[Lea Verou]

Instead of asking this in every hack why don't you upgrade your board? What are you wating for? A hacking attempt?

[Gastongr]

Instead of asking this in every hack why don't you upgrade your board? What are you wating for? A hacking attempt?

It's the second time i ask :surprised:
My membership has expired, i can't download updates. And 30 dollars is a lot of money for me, i'm not in the best position.
I guess i'll have to try installing this.

[MorrisMcD]

Originally Posted by Gastongr

It's the second time i ask :surprised:
My membership has expired, i can't download updates. And 30 dollars is a lot of money for me, i'm not in the best position.
I guess i'll have to try installing this.

I wouldnt suggest trying to install anything designed for 3.5 on your board... And ignore rude people.. This is a forum and its for asking questions.. Yer in the right to ask

[adonfun]

Great hack.. but not sure if it works with 3.6.2. Doe you or anyone else know that?

Any chance to get it 3.6.2 compatible one day?

[dominick32]

This hack is excellent. Although I cant seem to get it configured, and I cant get the actual referrals.php page to show up. This is the error I get in the AdminCP Statistics configuration:

Database error in vBulletin 3.0.3:

Invalid SQL: UPDATE referrals SET resultnumber='20', limit1='', limit2='', limit3='', limit4='1', limit5='0', limit6='1'
mysql error: Unknown column 'resultnumber' in 'field list'

mysql error number: 1054

Date: Monday 16th of October 2006 08:42:24 AM
Script: http://www.svtsnake.com/forum/admincp/referralstats.php
Referer: http://www.svtsnake.com/forum/admincp/referralstats.php

And I get this error in the referral.php:

Database error in vBulletin 3.0.3:

Invalid SQL: SELECT COUNT(*) AS referrals, user.username, user.userid, user.totalreferrals FROM user AS users INNER JOIN user AS user ON (users.referrerid = user.userid) 
                   WHERE users.referrerid > 0
                   
                   GROUP BY users.referrerid 
                   ORDER BY referrals DESC 
                   LIMIT 0, 
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 6

mysql error number: 1064

Date: Monday 16th of October 2006 08:43:55 AM
Script: http://www.svtsnake.com/forum/referrals.php

Any help would be greatly appreciated as I really want this to get added to my forum. My website is www.svtsnake.com/forum/

Thanks in advance.