The Arcive of Official vBulletin Modifications Site.

Referral Statistics · **Released**: 04-27-2004

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

Viks · #**182** 01-14-2005, 04:58 AM

nice utility for users and admins. I have installed it. works p-e-r-f-e-c-t-l-y.

thanks <clicking install>

Viks · #**183** 01-14-2005, 07:19 PM

hey, i think i spoke too soon hehe...
im getting the following error when i click "referal statistics" link from FORUMSHOME page -
Warning: chdir() [function.chdir]: No such file or directory (errno 2) in /hsphere/local/home/vikram/thalforum.com/forums/referrals.php on line 28

and following error when no user is logged in.

Warning: chdir() [function.chdir]: No such file or directory (errno 2) in /hsphere/local/home/vikram/thalforum.com/forums/referrals.php on line 28

Unable to add cookies, header already sent.
File: N/A
Line: 0

=-=-=-=-=-=

AND when i click the link from CMPS home I get page cannot be displayed because it is trying to hit the refferal.php in the root directory instead from /forums/refferal.php.

any suggestions gspot? others?

V

gspot · #**184** 01-14-2005, 10:17 PM

Quote:

Originally Posted by Viks

hey, i think i spoke too soon hehe...
im getting the following error when i click "referal statistics" link from FORUMSHOME page -
Warning: chdir() [function.chdir]: No such file or directory (errno 2) in /hsphere/local/home/vikram/thalforum.com/forums/referrals.php on line 28

and following error when no user is logged in.

Warning: chdir() [function.chdir]: No such file or directory (errno 2) in /hsphere/local/home/vikram/thalforum.com/forums/referrals.php on line 28

Unable to add cookies, header already sent.
File: N/A
Line: 0

=-=-=-=-=-=

AND when i click the link from CMPS home I get page cannot be displayed because it is trying to hit the refferal.php in the root directory instead from /forums/refferal.php.

any suggestions gspot? others?

V

viks - on line 28 in referrals.php file you need to have the following:

chdir('/hsphere/local/home/vikram/thalforum.com/forums/');

TRY THAT - it should fix your problem. It seems that you didnt have the path setup correctly. Save the file and reupload once you edit it. Then let me know if it works.

Viks · #**185** 01-15-2005, 12:14 AM

thanks gspot.

yeah, i had missed that part. now the URL work perfectly from forumshome and inside the forum.

but I stil cud not get it to work from the CMPS footer. has anyone here with CMPS got this working on CMPS main page?? if yes, then please share the info.

thanks

gspot · #**186** 01-15-2005, 08:10 AM

ATTENTION EVERYONE:

The new version of this hack 2.0 will be released by the end of this weekend. It includes the following:

1) Pagination - yes its finally here
2) The ability to delete referrals by a specific member
3) Updated instructions for install - I might even build an installer

will see...
4) Any wants? Let me know...

lasto · #**187** 01-15-2005, 10:46 AM

will wait for new version

Viks · #**188** 01-15-2005, 04:06 PM

Quote:

Originally Posted by gspot

ATTENTION EVERYONE:

4) Any wants? Let me know...

1. Who has used Referral system (wud be nice addon)
2. Email addresses to which referrals have been sent (wud be a nice addon)
3. How many refferal sent by individual. :ermm:
4 . :ermm: Refferal this year/month/week

howzzat?

gspot · #**189** 01-16-2005, 12:57 AM

EVERYONE THE NEW RELEASE IS HERE..

LET ME KNOW WHAT YOU THINK

Viks · #**190** 01-16-2005, 05:26 AM

Quote:

Originally Posted by gspot

EVERYONE THE NEW RELEASE IS HERE..

LET ME KNOW WHAT YOU THINK

COOL. thx dude.
I will try it. can i run the install on top of my old version of refferal stats or do i have to uninstall first.

gspot · #**191** 01-16-2005, 06:18 AM

Quote:

Originally Posted by Viks

COOL. thx dude.
I will try it. can i run the install on top of my old version of refferal stats or do i have to uninstall first.

Should be fine over the top of it.

MajorFm.com · #**192** 01-16-2005, 11:58 AM

Got the following error on the auto installation on step 2...

Code:

Database error in vBulletin 3.0.3:

Invalid SQL: 
    	CREATE TABLE referrals (
  		`date` text NOT NULL 
		) TYPE=MyISAM
mysql error: Table 'referrals' already exists

mysql error number: 1050

Date: Sunday 16th of January 2005 08:55:51 AM
Script: http://www.majorfm.com/forum/admincp/install_referrals.php
Referer: http://www.majorfm.com/forum/admincp/install_referrals.php
Username: *****
IP Address: 80.42.131.***

I have masked the username and part of the IP

Please advise...

gspot · #**193** 01-16-2005, 04:54 PM

Major - please re-download the package and re-upload all the files again for the upgrade process. I have created an upgrade script in the auto installer. This should take care of your problem. Good Luck.

Megareus Rex · #**194** 01-16-2005, 09:33 PM

Ok, problem. I use table prefixes at my forum. The original version didn't have them, so I added em in manually, but I see this version does. However....there's a problem with one bit of coding in it.

Its this block

PHP Code:


			
$result = $DB_site->query_first("SELECT COUNT(*) as ttl, user.username, user.userid FROM " . TABLE_PREFIX . "user AS users LEFT JOIN user AS user ON (users.referrerid = user.userid) 

                   WHERE user.userid > 0

                   GROUP BY users.referrerid 

                   ORDER BY ttl DESC");

I have to add the table prefix to every single instance of 'user' in the entire block, or else it gives me errors such as "Unknown table 'user' in field" and stuff. And when I add the prefix to all instances of it, for some reason it acts like there's no prefix on ANY of it! So I can't get it to work at all.

Any help?

T3MEDIA · #**195** 01-16-2005, 09:50 PM

Quote:

Originally Posted by gspot

EVERYONE THE NEW RELEASE IS HERE..

LET ME KNOW WHAT YOU THINK

I dont know if you remember I was asking for the referal hack to check for a pertiular setup.

each user has to refer 5 users. Those five have to refer 5 as well and the orignal user gets paid.

can this baby do that yet?

its like free ipods for members kinda thing.

gspot · #**196** 01-16-2005, 09:56 PM

REX - It was an error in the referrals.php page. IT HAS BEEN FIXED.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.06176 seconds Memory Usage 2,380KB Queries Executed 30 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)bbcode_code (1)bbcode_php (5)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (2)pagenav_pagelinkrel (16)post_thanks_box (16)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (16)post_thanks_postbit_info (15)postbit (16)postbit_onlinestatus (16)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!