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

[Big Kahuna]

I changed $referbits to $referbit in the refer template -- but that didn't change anything.

This hack is to show statistics on referrals that have been made. For instance, if you referred 5 people, it will show the 5 people you referred as well as a count of referrals for you which would be 5 and your username as the referrer. This is just for statistics.

What I don't understand is what is the link between the referrer and the referred? I tried a throwdown registration -- and I was not asked who referred me. No where in the instructions did I do anything to perform a database modification.

These were the instructions from the hack I downloaded earlier today.

Installation Instructions:
I have edited this code from vb version 2.x.x to work with vb 3.0.1.
follow the instructions below to install, and feel free to make any
modifications to the code as you wish. I made some options for this
hack to limit results such as referrals by usergroups. More instructions
on implementing the results limiter is in the referals.php

Thanks to unixman - all the referred members are now clickable to their profile.

Open /includes/functions_online.php
/////////////////////////////////////
/////////////////////////////////////

Search for:
/////////////////////////////////////
case 'modcplogin':
$userinfo['action'] = $vbphrase['moderator_control_panel_login'];
break;
/////////////////////////////////////

After add:
/////////////////////////////////////
case 'referrals':
$userinfo['action'] = 'Viewing Referral Statistics';
break;
/////////////////////////////////////

Search for:
/////////////////////////////////////
case '/robots.txt':
$userinfo['activity'] = 'spider';
break;
/////////////////////////////////////

After add:
/////////////////////////////////////

case 'referals.php':
$userinfo['activity'] = 'referrals';
break;
/////////////////////////////////////

Close functions_online.php and upload to server.

/////////////////////////////////////



Open refer.txt attached to this hack and add a new template
named: refer copy and paste all into this template.

Open referbit.txt attached to this hack and add a new template
named: referbit copy and paste all into this template.


//////////////////////////////////////
//////////////////////////////////////

Open your footer template and find:
//////////////////////////////////////
<a href="$vboptions[homeurl]">$vboptions[hometitle]</a> -
//////////////////////////////////////

Before it add:
//////////////////////////////////////
<a href="referals.php">Referral Statistics</a> -
//////////////////////////////////////


END ENJOY.... HAVE FUN WITH IT.......

I've gone over the steps outline above, plus the path to my forum in the referal.php, and put that in my forum's directory. I've had a long day and it is possible that I'm missing something obvious -- but I've gone over the instructions many times and can't see it.

I might also suggest that it may help alieviate a little confusion if your above instructions indicate what directory to upload the referal.php file to -- and a little clarity on the directory change you need to make to the file first.

[gspot]

In your admincp panel make sure that under vbulletin options - user registration options - you have selected to use the "user referrer". This will give a credit towards each referrer in which the referred member has signed up from them. Automatically adding a field in the user registration for this to work, once you have this feature enabled.

[Big Kahuna]

Ok -- I misunderstood how this worked. Instead of referral by a link -- I thought it was a question asked in New User Registration "Who Referred You?"

Thanx

[gspot]

Originally Posted by Big Kahuna

Ok -- I misunderstood how this worked. Instead of referral by a link -- I thought it was a question asked in New User Registration "Who Referred You?"

Thanx

Actually it's by both.. No matter if you follow a link with the referrers information or if you type in the referrers name during registration. It will work the same.. But you wont see any statistics until someone has referred someone else. No matter in the past or in the future..

[Big Kahuna]

OK -- I'm back to confused again since I tried a throwdown registration and didn't see anywhere the referrer's name was asked in a new registration.

Was something suppose to be modified in the database (because I didn't see it happen) to add a field for the name of the person that referred a member?

[gspot]

YES, you do have a referrer spot in your new user registration. Please see the attachment.. You will only get statistics if someone has referred someone else. But, they have to either type in the members name in this field during new registration, or they have to follow the link sent to them by the use of your other hack refer friends..

If you still can't get it, I would be more than happy to check out your settings myself, if you want to give me access. Else, I would recommend you to seek some assistance by a website designer. Many people have installed this hack with no problems. Just read the instructions word for word and everything should work properly. GOOD LUCK.

[armani1072]

got this database error when i click on the "refer stats" link any ideas???

Database error in vBulletin 3.0.1:

Invalid SQL: SELECT COUNT(*) AS referrals, user.username, user.userid FROM user AS users
LEFT JOIN user ON (users.referrerid = user.userid)
WHERE user.userid > 0
GROUP BY users.referrerid
ORDER BY referrals DESC
LIMIT 10

[gspot]

Did you use a table prefix while installing vbulletin? If so you will need to edit that query to fit your tables database prefix...

There should have been more to that error as well, if you can please post it all.

[armani1072]

Originally Posted by gspot

Did you use a table prefix while installing vbulletin? If so you will need to edit that query to fit your tables database prefix...

There should have been more to that error as well, if you can please post it all.

here is the rest of the error message. Yeah it looks like that table does not exist. Umm if you could point me in the right direction that would be swell



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

mysql error number: 1146

[gspot]

Originally Posted by armani1072

here is the rest of the error message. Yeah it looks like that table does not exist. Umm if you could point me in the right direction that would be swell



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

mysql error number: 1146

Looks to me that u need to change all instances for the mysql querys that have "FROM user" to "FROM precisi_forums.user" since you used a table prefix when installing vbulletin. So edit the referals.php file to meet your needs.. Let me know. I hope this helps.

[armani1072]

Samething. does the table have to be created in the database? thanks for all your help by the way


Database error in vBulletin 3.0.1:

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

mysql error number: 1146

[Boofo]

Originally Posted by armani1072

Samething. does the table have to be created in the database? thanks for all your help by the way


Database error in vBulletin 3.0.1:

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

mysql error number: 1146

Very simple fix. In the referals.php file

Find:

PHP Code:

$referrers = $DB_site->query("SELECT COUNT(*) AS referrals, user.username, user.userid FROM user AS users 
                   LEFT JOIN user ON (users.referrerid = user.userid) 
                   WHERE user.userid > 0
                   GROUP BY users.referrerid 
                   ORDER BY referrals DESC 
                   LIMIT $max"); 


REPLACE it with:

PHP Code:

$referrers = $DB_site->query("SELECT COUNT(*) AS referrals, user.username, user.userid FROM 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 $max"); 


[armani1072]

Umm you want me to replace the code i find with the same code? still got the error. sorry to be a bother.

Database error in vBulletin 3.0.1:

Invalid SQL: SELECT COUNT(*) AS referrals, user.username, user.userid FROM 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 'precisi_forums.user' doesn't exist

mysql error number: 1146

[Boofo]

Originally Posted by armani1072

Umm you want me to replace the code i find with the same code? still got the error. sorry to be a bother.



Database error in vBulletin 3.0.1:

Invalid SQL: SELECT COUNT(*) AS referrals, user.username, user.userid FROM 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 'precisi_forums.user' doesn't exist

mysql error number: 1146

I changed the second line in the query to user AS user ON. Anytime there is a table prefix being used, all tables must must delared like that in a query if you are accessing more than one table in the query.

[armani1072]

same error message as post #73