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

[Jason McConnell]

Originally Posted by gspot

Make sure you started with a new installation and not an upgrade. Run the install again even if it asks you to perform an uninstall. Then let me know what you get.

OK I went back thru, uninstalled and reinstalled, and now it works fine... just as long as I'm using my site's default style. Any other style loaded and I get a blank referrals.php page.

[BradM]

I am getting a DB crash on my forum. http://www.tgpelite.com/board/referrals.php
It worked fine, then randomly it crashed?

[BradM]

I get this error:

Database error in vBulletin 3.0.3:

Invalid SQL: SELECT COUNT(distinct referrerid) AS ttl FROM user
WHERE referrerid > 0 AND usergroupid NOT IN id:6
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 'id:6' at line 2

mysql error number: 1064

I apologise if I am an idiot. LOL

[gspot]

Originally Posted by BradM

I get this error:



Database error in vBulletin 3.0.3:

Invalid SQL: SELECT COUNT(distinct referrerid) AS ttl FROM user
WHERE referrerid > 0 AND usergroupid NOT IN id:6
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 'id:6' at line 2

mysql error number: 1064



I apologise if I am an idiot. LOL

on the referral statistics configuration in the admincp you dont type in (id:6) it would be just the (6) that will fix your problem.

[brianstevz]

Originally Posted by gspot

If you will wait for me one week, I will release the new version and that should fix your issue... It seems to me that the database fields never got updated in your sql. I havent had anyone with this issue besides u. Please wait..

Mine still doesn't work. Any ideas?

[gspot]

Originally Posted by brianstevz

Mine still doesn't work. Any ideas?

I can try to help you - can you post an image of whay your mysql table for referrals looks like? If not, then I need to gain access somehow or someway in order to see this structure.

[artonex]

just installed this over at my forums

[womensden]

I'm having a problem.

My referral page isn't showing most of my images. My background is missing, as well as other things. It seems anything that was in there without the entire link isn't showing properly. Even the links aren't going to the correct places.

http://www.womensden.com/forums/referrals.php/

[gspot]

Originally Posted by womensden

I'm having a problem.

My referral page isn't showing most of my images. My background is missing, as well as other things. It seems anything that was in there without the entire link isn't showing properly. Even the links aren't going to the correct places.

http://www.womensden.com/forums/referrals.php/

You are having this problem do to adding your own personal images not correctly in the navigation bar. Have you installed any other hacks? Also when you add your own images into the navbar make sure you type in their absolute paths example: http://www.test.com/header.gif

No one else has ever had this issue so I believe this is the reason and the problem that you are having.

[womensden]

so where can I edit those image paths?

Also, the links are screwed up. What would that have to do with the way my images are ?

[gspot]

Originally Posted by womensden

so where can I edit those image paths?

Also, the links are screwed up. What would that have to do with the way my images are ?

you need to edit your navbit template in the admincp and point your images to their absolute paths like i explained above. The links need to be updated in the footer template.

Also make sure that the referrals.php is grabing your global.php file correctly. To do this check the path in the referrals.php coding if you have moved the global.php file to a different location.

[gspot]

I know the number is changed yet to 2.4, but here is a preview of the next version to be released soon. If anyone has any other addons they would like included in this hack please let me know. WAITING TO HEAR FROM ALL OF YOU

[womensden]

ok, so I took out the "/" at the end of the link that I added to the bottom of my site and it worked. WTF? The first page was the only page that was screwed up.

I copied and pasted what was in the directions.

[gspot]

Originally Posted by womensden

ok, so I took out the "/" at the end of the link that I added to the bottom of my site and it worked. WTF? The first page was the only page that was screwed up.

I copied and pasted what was in the directions.

looking at your coding it seems that the header image for your website is trying to grab :

http://www.womensden.com/forums/refe...om/portal2.jpg

In which it should be getting:

http://www.womensden.com/forums/imag...om/portal2.jpg

This is why im lead to believe its not getting your global.php file or their is an error in your header & navbit templates.

[Sen]

Hmm, this is weird.

I've installed the hack following the instructions carefully. At first I got a blank page, so I skimmed through the thread and figured it was another problem. I switched to the default skin and lo and behold, the referrals page works. However, trying to view the page with any of the other skins installed, the page is blank.

I'm not sure what the problem is really =/ I always change the templates for all the skins at the same time when installing a hack.

http://www.darkfortears.com/ggf