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

[jzewatsky]

I would like to thank you GSpot for all your effort in regard to this hack. What an amazing job you have done working out the kinks and providing everyone with such great support and such a wonderful hack!!

Since you seem to be the expert on this board when it comes to "Referal" type hacks, I was just wondering if there is any way that this hack could be adapted to meet this request from this thread?

Is there or can someone create a way for the following to happen?

A user(u1) refers two new users (u2)&(u3) to the site.
For every post that (u2) or (u3) makes, a tally(refered posts?) is given to (u1).

User (u2) refers user (u4).
For every post that user (u4) makes a tally is given to (u2) and (u1).

I would like this to be seperate from the users own post count.

The idea stems from a way to not only encourage users to refer new users, but refer quality users and continue to encourage them to be active members of the board. I see it like a pyramid scheme. User (u1) gets "points" for every post someone he refers makes. The tree continues down the line of referals. Damn, I wish I could explain it more clearly.

If possible, integration with a points system (uCash/uShop) would be great.

I think that it would be extremely useable and help a lot of forums out with gaining and retaining memberships and forum content.

If anyone has any ideas, I'd love to hear them. Please bear in mind I am not a programer or coder, just a guy with an idea. Feel free to tell me it's impossible.

Thanks in advance!!

P.S. When this wins hack of the month, please mention me in your acceptance speech. J/K

[Koby]

Installed, only problem I had was with a typo in the copy/paste peice during the editing of the footer link.

Otherwise, flawless.

[gspot]

Originally Posted by Koby

Installed, only problem I had was with a typo in the copy/paste peice during the editing of the footer link.

Otherwise, flawless.

Where is the typo? I can't find it..

[gspot]

Also, I have edited this hack and a new release will be coming soon... I have added some great features into this hack including:
1) admin ability to add a 2nd navigation to the bottom of the results (on/off)
2) admin ability to show total number of referrals for each member since joined (on/off)
3) No more inserting your forums path manually. (auto fix)
4) Less queries
5) Bug fixed in reset referrals by member (thx T3MEDIA )
6) admin ability to show last reset date (on/off)

** I know you all still want the limit results by referrers referrals, but trust me I'm working on it and its a pain in the a$$... Can't seem to get it to work without way to many queries.. Huge server load...

Let me know what u think guys

[gregwatson]

Originally Posted by gspot

Also, I have edited this hack and a new release will be coming soon... I have added some great features into this hack including:

Is there any way to get it to track referrals that become a part of a usergroup (i.e. follow through on a subscription)?

Greg

[T3MEDIA]

Originally Posted by gregwatson

Is there any way to get it to track referrals that become a part of a usergroup (i.e. follow through on a subscription)?

Greg

Ohhh GOOD one. Affiliates... Nice idea.

[deb0]

Any updates on the blank page when clicking referral statistics

[gspot]

debo - Im looking into it.

[gspot]

Originally Posted by gregwatson

Is there any way to get it to track referrals that become a part of a usergroup (i.e. follow through on a subscription)?

Greg

Actually this is already implemented guys all you need to do is insert in that usergroupid number that you want it to only track and boom there it is... ENJOY

[gregwatson]

Originally Posted by gspot

Actually this is already implemented guys all you need to do is insert in that usergroupid number that you want it to only track and boom there it is... ENJOY

Thanks ... I will work on that tonight ...

Thanks,
Greg

[gregwatson]

Fixed - See Edit at bottom of message
-------------------------------------------
Stats works wonderfully as long as I don't select any of the Limit By options.

When I select either the limit by posts or usergroup id's, I get the following database error (any recommendations on what to look for?):

Database error in vBulletin 3.0.6:

Invalid SQL: SELECT COUNT(referrerid) as getusers FROM user WHERE referrerid > 0 AND posts 9
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 '9' at line 1

mysql error number: 1064

Date: Wednesday 16th of March 2005 08:38:36 PM
Script: http://www.barrreport.com/forums/adm...rralstatistics
Referer: http://www.barrreport.com/forums/admincp/
Username: Admin
IP Address: 63.162.87.195

***********EDIT**************************
This error is created if you do not set a "conditional" in the field:

That is / are:

Set the conditional to Equals and all works well ...

Greg

[SVTBlackLight01]

Same problem here.

[gspot]

Originally Posted by SVTBlackLight01

Same problem here.

You need to define your problem, if it is the same as gregs, read his whole post you need to have all the conditions setup if not tell me the error..

[gregwatson]

Originally Posted by gspot

You need to define your problem, if it is the same as gregs, read his whole post you need to have all the conditions setup if not tell me the error..

He may not know how to edit his database to "fix" the problem ...

Once this error message is created, there is no way to fix it from the admincp without manually going into the database and editing limit1, limit2, and limit3 as necessary ...

There really *does* need to be an error trap coded to catch this "problem" ...

Greg

[gspot]

greg - I will have this fixed in the next release. Also please click install if you have installed my hack until then I will make a rollback file later tonight that you will need to run if you have this same problem.