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

[Boofo]

Originally Posted by armani1072

Database error in vBulletin 3.0.1:

Invalid SQL: SELECT username FROM precisi_forums.user WHERE referrerid = '1' AND referrerid > 0
mysql error: Table 'precisi_forums.user' doesn't exist

mysql error number: 1146



sorry to keep bugging. changed code in referals.php and this is the new error i got. at least it is different

Can you post the fulll error code on that?

[armani1072]

Originally Posted by Boofo

Can you post the fulll error code on that?

Database error in vBulletin 3.0.1:

Invalid SQL: SELECT username FROM precisi_forums.user WHERE referrerid = '1' AND referrerid > 0
mysql error: Table 'precisi_forums.user' doesn't exist

mysql error number: 1146

Date: Friday 21st of May 2004 12:27:15 AM
Script: http://www.precisionmuscle.org/testv...s/referals.php
Referer: http://www.precisionmuscle.org/testvb/forums/index.php?
Username: armani1072
IP Address: 205.201.132.83

[gspot]

Originally Posted by armani1072

Database error in vBulletin 3.0.1:

Invalid SQL: SELECT username FROM precisi_forums.user WHERE referrerid = '1' AND referrerid > 0
mysql error: Table 'precisi_forums.user' doesn't exist

mysql error number: 1146

Date: Friday 21st of May 2004 12:27:15 AM
Script: http://www.precisionmuscle.org/testv...s/referals.php
Referer: http://www.precisionmuscle.org/testvb/forums/index.php?
Username: armani1072
IP Address: 205.201.132.83

Try this - If u used vb3 as the prefix, put in either:

SELECT username FROM vb3.user WHERE referrerid = '1' AND referrerid > 0

or

SELECT username FROM precisi_forums.vb3.user WHERE referrerid = '1' AND referrerid > 0

Because we got past the first query, so now it's only hanging up on the last query... BOOFO if you have any suggestions, please post them...

[Boofo]

What is the actual table_prefix in the config.php?

[armani1072]

Originally Posted by Boofo

What is the actual table_prefix in the config.php?

// ****** DATABASE NAME ******
// This is the name of the database where your vBulletin will be located.
// This must be created by your webhost.
$dbname = 'precisi_forums';



// Prefix that your vBulletin tables have in the database.
// For example: $tableprefix = 'vb3_';
$tableprefix = 'vB3';

[Boofo]

Originally Posted by armani1072

// ****** DATABASE NAME ******
// This is the name of the database where your vBulletin will be located.
// This must be created by your webhost.
$dbname = 'precisi_forums';



// Prefix that your vBulletin tables have in the database.
// For example: $tableprefix = 'vb3_';
$tableprefix = 'vB3';

Try chnage the user table name in the query to this:

vb3user

and see if it runs that way.

[armani1072]

Originally Posted by Boofo

Try chnage the user table name in the query to this:

vb3user

and see if it runs that way.

if were to change in config.php to not have a prefix and upload it will that update everything? this is too much trouble i should have never put a prefix.

[gspot]

Originally Posted by armani1072

if were to change in config.php to not have a prefix and upload it will that update everything? this is too much trouble i should have never put a prefix.

NO that wouldn't change everything. Since you installed vbulletin with a prefix, you would have to completely reinstall it with no prefix to never use one again. But try like BOOFO said it is really easy.

Try vB3.user for the table in the query
or try vb3.user depending on the cap locks if you used them or not
or last try vb3user in that last query...

That should make it work

[etaslim]

Originally Posted by Big Kahuna

I modified includes/functions_online.php and uploaded it

I created the two templates (in one of my 12 styles to test) in my 64 Imperial style

I added the path to the referals.php and put it in my main forum directory

I added the call in the footer of the style with the templates http://www.moparstyle.net/forums/index.php?styleid=36

But I get a white screen.

I got the same problem, white screen. I've redo everything but still get the empty screen. I'm using vb 3.0.3. Please help...

[gspot]

Originally Posted by etaslim

I got the same problem, white screen. I've redo everything but still get the empty screen. I'm using vb 3.0.3. Please help...

ETASLIM,

Please re-download the zip file, I have updated the coding to work with people who are using databases with prefix's. Try this, if it still doesn't work please let me know. Sorry I have been out of town for the past few days...

Thanks,
GSPOT