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

[gspot]

Originally Posted by venomx

Sorry didnt try to install this yet just read the first few pages. How about a way to count how many new refs since last reset?

Ok people I have re-edited the whole layout of this hack... I think everyone will like it. Please check-out the new pictures and the new features that it has to offer. Many features where added from VENOMX's requests that I think all of us will find useful. Enjoy and post any comment or suggestions that you may have.

[venomx]

Cool
Ill install this in a few hours.. Was just heading to bed when the email came in saying you posted.. :P

[gspot]

Originally Posted by venomx

Cool
Ill install this in a few hours.. Was just heading to bed when the email came in saying you posted.. :P

No problem, had some free time this afternoon and now its bedtime for me as well. Hope you all like it.

[venomx]

Hey just had an idea.... What would be nice is for you/someone to make an addon for this and uShop.

Like an on/off switch for the "since reset" counter and when we turn it off it auto awards the top 3 members whatever amount of points we have set for the winners...
When its turned off it wouldnt show the since last reset text of the pages for the members... :P

[gspot]

Originally Posted by venomx

Hey just had an idea.... What would be nice is for you/someone to make an addon for this and uShop.

Like an on/off switch for the "since reset" counter and when we turn it off it auto awards the top 3 members whatever amount of points we have set for the winners...
When its turned off it wouldnt show the since last reset text of the pages for the members... :P

Remember to click Install. Yes, that is a whole different hack that I dont support. Sorry, but if someone else wants to make this an addon then please go ahead. Since everyone's referal competitions are probably going to be different. Some people will issue points, some will issues prizes and so forth. Sorry.

[etaslim]

How to add the new database table? Has to be done from PHPMyAdmin, is it? Can someone be kind enough to advice step by step procedure. Thanks alot!

[gspot]

Originally Posted by etaslim

How to add the new database table? Has to be done from PHPMyAdmin, is it? Can someone be kind enough to advice step by step procedure. Thanks alot!

In PHPMyAdmin run this query:

CREATE TABLE `referrals` (
`date` TEXT NOT NULL
);

Or for step by step:
1) create a new table named: "referrals"
2) create one new field named: "date"
3) Type: "text"
4) not null

Hope this helps

[SaN-DeeP]

Database error in vBulletin 3.0.3:

Invalid SQL: SELECT COUNT(*) AS referrals, user.username, user.userid FROM vb3_user AS users LEFT JOIN user AS user ON (users.referrerid = user.userid) 
				   WHERE user.userid > 0
				   GROUP BY users.referrerid 
				   ORDER BY referrals DESC 
				   LIMIT 10
mysql error: Table ******.user' doesn't exist

aNy fix for this ?

thnx

[gspot]

Originally Posted by SaN-DeeP

Database error in vBulletin 3.0.3:

Invalid SQL: SELECT COUNT(*) AS referrals, user.username, user.userid FROM vb3_user AS users LEFT JOIN user AS user ON (users.referrerid = user.userid) 
				   WHERE user.userid > 0
				   GROUP BY users.referrerid 
				   ORDER BY referrals DESC 
				   LIMIT 10
mysql error: Table ******.user' doesn't exist

aNy fix for this ?

thnx

SAn-deep

I think you need to try it again. If your using a database table prefix for vbulletin, it looks like the script is working then. Is your prefix "vb3" for your database tables? The script is trying to grab the table "vb3_user" - do you even have this table in your vbulletin database? If not, you need to not use a database prefix and it should be trying to use table "user". Many people have installed this hack with no problems.

-GSPOT-

[etaslim]

Originally Posted by gspot

In PHPMyAdmin run this query:
Hope this helps

Great! Thanks for the help, gspot. It runs perfectly now on my two forums.