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

[mcyates]

I get this error when clicking on "save settings" in the Configure Referral Statistics on the Admincp


Database error in vBulletin 3.0.7:

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

mysql error number: 1054

Date: Thursday 02nd of June 2005 09:33:28 AM
Script: http://www.myfootballforum.com/admin...erralstats.php
Referer: http://www.myfootballforum.com/admin...erralstats.php
Username: boro_boy
IP Address: 62.254.64.19

[Marco van Herwaarden]

Did you run the installer?

[mcyates]

Yes, it obviously didn't add a table or something.

[artonex]

im gettin this error, how can i fix ?

Database error in vBulletin 3.0.7:

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

mysql error number: 1064

Date: Sunday 05th of June 2005 05:33:06 AM
Script: http://talkweed.com/forums/admincp/r...rralstatistics
Referer: http://talkweed.com/forums/admincp/index.php?do=nav
Username: dexstar
IP Address: xx.xx.xx.xx

[artonex]

anyone???

[bobang]

Everything's working well, but is there any way to replace the list of referrals with Homepage URL? I tried $userinfo[homepage] but it's not working.

Can anyone help me out here? Thanks.

[MorrisMcD]

Works great for me.. Thx

[MrTchMan]

When I am looking at the Referral statistics page and try to go to my AdminCP from the footer It goes to this
http://www.justsprint.com/forum/refe...ncp/index.php?

It puts the referrals.php in there

Any ideas

Sorry I am new to this

[gspot]

yes, you edited your footer incorrectly, check the instructions again and follow them step by step for editing your footer template.

[MrTchMan]

Originally Posted by gspot

yes, you edited your footer incorrectly, check the instructions again and follow them step by step for editing your footer template.

For some reason it works now...Who knows