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

[djjeffa]

I think I did everything right but heres what i get
Database error in vBulletin 3.0.3:

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

mysql error number: 1146

Date: Saturday 01st of January 2005 10:29:39 PM
Script: http://www.djjeffa.com/vb/referrals.php
Referer: http://www.djjeffa.com/vb/home.php

any ideals?

[PurpleCow]

Hi... Great Hack

/me Clicks Install

I would suggest something liek this for a referral promo..

Refer 5 friends and those five refer another 2 each and be eligible to win something as a Prize. We could probably have another few levels of referrals.
Besides...each referred person again can be eligible for the prizes based on referrals.
And similiarly on those lines.

Any help on this ... much Appreciated

Also, does this work with Erwin's refer a Friend ? or works as a stand alone hack ??

Thanks

[gspot]

djeffa - it was a problem in the referrals.php file. ITS BEEN FIXED.

[gspot]

PurpleCow - Someone else even recommended this addon for my hack, I will start looking into it, but however it may take me a few weaks to release it. Thanks for clicking install

[MajorFm.com]

I dont suppose u can help with this:

https://vborg.vbsupport.ru/showthrea...t=67407&page=3

[deb0]

nice mod, but directions need to be improved.

[djjeffa]

Originally Posted by gspot

djeffa - see this:

mysql error: Table 'djjeffa_djjeffaVB.user' doesn't exist

It's trying to find that table called: djeffa_djjeffaVB.user check your mysql and see if this table exists, if not then you have a problem in using the database prefix maybe even from a previous hack that was installed prior to this one. Someone else had the same problem, but however this is not from my hack. sorry.

the only part that i think i could have messed up was this
1) create a new database table
CREATE TABLE `referrals` (
`date` TEXT NOT NULL
);

cause i had a freind do that cause i didnt really understant it.
but i still cant figer it out.

[gspot]

djjeffa - basically all that says is create a new database table: the
CREATE TABLE `referrals` (`date TEXT NOT NULL ); is the command you would use in phpmyadmin to execute this new table named exactly like it says: referrals.

[djjeffa]

Originally Posted by gspot

djjeffa - basically all that says is create a new database table: the
CREATE TABLE `referrals` (`date TEXT NOT NULL ); is the command you would use in phpmyadmin to execute this new table named exactly like it says: referrals.

im really bad with this so if you can walk me throug lol
i get to this :
Create new table on database djjeffa_djjeffaVB:
Name:
Fields:

is that where i should be and what do I put for feilds? Name i guss would be referrals ?

[gspot]

Originally Posted by djjeffa

im really bad with this so if you can walk me throug lol
i get to this :
Create new table on database djjeffa_djjeffaVB:
Name:
Fields:

is that where i should be and what do I put for feilds? Name i guss would be referrals ?

djjeffa - yes thats where u need to be. This is pretty self explaining, but here i will try to explain it completely for you. NAME = referrals , Fields = date

This field date needs to have the following settings: TEXT, NOT NULL

Thats basically it. You should look into how to run a database query in phpmyadmin somewhere on google. Then all you would have to do is copy and paste the CREATE TABLE script above and click submit. Then it would create the new table and automatically set all the settings up for you. GOOD LUCK

[coloradok5]

Ability to limit referral counts based on usergroups. (good for limiting referral competitions for certain usergroups)

Hello, sorry if these questions have been anwsered allready, Does this work for secondary usergroups as well? What I mean is could I allow all usergroups to referr, but only the referrees that become paid subscribers that are in a secondary usergroup would count, kind of like an affiliate program?
Can you reset referrals by user only?

[gspot]

Originally Posted by coloradok5

Hello, sorry if these questions have been anwsered allready, Does this work for secondary usergroups as well? What I mean is could I allow all usergroups to referr, but only the referrees that become paid subscribers that are in a secondary usergroup would count, kind of like an affiliate program?
Can you reset referrals by user only?

Yes colorado you can limit the count to a specific usergroup which is explained in the referrals.php file. As far as resetting referrals by username, no not in this release, but will be available in the next. You can only reset all referrals in this version.

[GetGamer.com]

There something really unclear about the installation instructions for this MOD. I'm using a table prefix of "vb3_" for my forums. I want to maintain that structure for all forum-related tables, for obvious reasons. The instructions on do not explain how to handle prefixes so I created a "vb3_referrals" table rather than simply a "referrals" table.

Now when I load http://www.bigblueball.com/forums/referrals.php I get the following error:

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 'bbb.user' doesn't exist
 
 mysql error number: 1146

And yes, I edited line #28 of referrals.php to the correct path already (the readme.txt doesn't cover that either). As I understand this error message, it appears that the forum prefix is not being used for just part of the SQL command.

[gspot]

gamer - it was a problem in the referrals.php. IT HAS BEEN FIXED

[GetGamer.com]

Originally Posted by gspot

gamer - try it the way the instructions say...

Your problem is the following:
mysql error: Table 'bbb.user' doesn't exist

It's looking for a table with the prefix "bbb" is that what you are using for your vbulletin database tables? I dont know how or where it could be getting that prefix from unless you specified that somewhere within vb. Also there have been 2 or 3 other members that have had problems trying to install this hack, but out of 60 that have installed successfully they (the 3 of them including yourself) might have installed another hack that is somehow conflicting with this one. This hack is setup correctly. And yes the instructions do need to be revised, but that will occur in the next release. I'm sorry, but this is all I can help you with at this time. good luck

I have only a few Mods installed, and all of them work perfectly. bbb is the name of the database, not the prefix. My table prefix is "vb3_"