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

[Milktruck]

Thank you! Installed it perfectly.

*clicked Install*

[Jack28]

Help! i got the follow error:

Warning: array_merge() [function.array-merge]: Argument #2 is not an array in W:\www\includes\init.php on line 520

Warning: Invalid argument supplied for foreach() in W:\www\includes\sessions.php on line 270

Warning: array_merge() [function.array-merge]: Argument #2 is not an array in W:\www\includes\functions.php on line 3622

Warning: array_merge() [function.array-merge]: Argument #1 is not an array in W:\www\includes\functions.php on line 3622

Warning: array_merge() [function.array-merge]: Argument #2 is not an array in W:\www\includes\functions.php on line 3622

 

There seems to have been a slight problem with the database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.

How can i fix this?

[gspot]

Originally Posted by Jack28

Help! i got the follow error:

Warning: array_merge() [function.array-merge]: Argument #2 is not an array in W:\www\includes\init.php on line 520

Warning: Invalid argument supplied for foreach() in W:\www\includes\sessions.php on line 270

Warning: array_merge() [function.array-merge]: Argument #2 is not an array in W:\www\includes\functions.php on line 3622

Warning: array_merge() [function.array-merge]: Argument #1 is not an array in W:\www\includes\functions.php on line 3622

Warning: array_merge() [function.array-merge]: Argument #2 is not an array in W:\www\includes\functions.php on line 3622

 

There seems to have been a slight problem with the database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.

How can i fix this?

To me it sounds like your path to your vbulletin forums is not set correctly in my hack files. Please make sure it is. It looks like your path should be this: /www/

[etaslim]

Originally Posted by etaslim

Great! Thanks for the help, gspot. It runs perfectly now on my two forums.

Ups, appearently not all :ermm: In one of my forum, the total referrals are not shown. I've rechecked but couldn't found anything wrong. Any idea? Anyway, the address is http://forum.chip.co.id/referals.php

[SaN-DeeP]

i re-uploaded all the files, did all the edits once again,
but still getting this error :

 Database error in vBulletin 3.0.3:
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 'sanp_faS3.user' doesn't exist
mysql error number: 1146
Date: Friday 15th of October 2004 01:45:21 PM
Script: http://forums.tech-arena.com/referrals.php
Referer: 
Username: SaN-DeeP

[Boofo]

That's because you have a table prefix. You need to add . TABLE_PREFIX . before each table.

[SaN-DeeP]

Originally Posted by Boofo

That's because you have a table prefix. You need to add . TABLE_PREFIX . before each table.

I am confused boofo, Can you help fixing the table prefix in this code ?

  <?php
////////////////////////////////////////////////////////
//Referral Statistics// Created By: G-Spot//////////////
////////////////////////////////////////////////////////
///////////////www.gspotracing.com//////////////////////
////////////////////////////////////////////////////////
// INSTRUCTIONS:
// Change the $max variable to show how many results you want. 
////////////////// OPTIONAL REFERRAL RESULTS ///////////
// You can limit your referral results to certain usergroups,
// by adding the following under each query after the WHERE clause's:
// AND user.usergroupid=2 --> 
// this number will be different for different user groups. To find 
// the usergroup number login to your admincp and click on usergroup 
// manager and next to the usergroups you should see something close 
// to: edit usergroup(id:2) where the 2 is the usergroup number.
///////////////////////////////////////
//////////////////////////////////////////////
//////////////////////////////////////////////////////
// ####################### SET PHP ENVIRONMENT ########################### 
error_reporting(E_ALL & ~E_NOTICE); 
// #################### DEFINE IMPORTANT CONSTANTS ####################### 
define('NO_REGISTER_GLOBALS', 1);
define('THIS_SCRIPT', 'referrals');
// ################### PRE-CACHE TEMPLATES AND DATA ###################### 
$globaltemplates = array('refer','referbit','navbar');
// ######################### REQUIRE BACK-END ############################ 
chdir('/path/to/vbulletin/forums/');//edit path to your vbulletin directory
require('./global.php');
// ######################### NAVIGATION ############################ 
$navbits = array(); 
$navbits[$parent] = 'Referral Statistics';
$navbits = construct_navbits($navbits); 
eval('$navbar = "' . fetch_template('navbar') . '";');
// #####################################################
// #####################################################
// ######################### START MAIN SCRIPT #########
// #####################################################   
// START REFERRAL STATISTICS SCRIPT //
//GET TOTAL REFERALS//
$gettotal = $DB_site->query("SELECT COUNT(*) FROM " . TABLE_PREFIX . "user
					   WHERE referrerid > 0");
$total=mysql_fetch_row($gettotal);
// END TOTAL REFERALS //
// GET LAST DATE RESET //
$lastreferals=$DB_site->query("SELECT date FROM " . TABLE_PREFIX . "referrals");
$lastcount = mysql_fetch_row($lastreferals);
if ($lastcount == ''){
$lastcount[0]="(No Reset Record Found!)";
}
// END LAST DATE RESET //
$max=10; //This number decides how many results to display 
$referrers = $DB_site->query("SELECT COUNT(*) AS referrals, 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 referrals DESC 
				   LIMIT $max"); 
while ($referrer=$DB_site->fetch_array($referrers)) { 
  $referreds = $DB_site->query("SELECT username FROM " . TABLE_PREFIX . "user WHERE referrerid = '$referrer[userid]' AND referrerid > 0"); 
  while ($referred = $DB_site->fetch_array($referreds)){ 
	$enc_username = urlencode($referred[username]); 
	if ($referrerlist) { 
	  $referrerlist .= ", <A HREF=member.php?action=getinfo&username=$enc_username>$referred[username]</A>"; 
	} else { 
	  $referrerlist .= "<A HREF=member.php?action=getinfo&username=$enc_username>$referred[username]</A>"; 
	} 
  } 
  eval("\$referbits .= \"".fetch_template("referbit")."\";"); 
  $referrerlist=""; 
} 
eval('print_output("' . fetch_template('refer') . '");');
?>

Regards,

[gspot]

San-Deep

Do you see this line in my configuration file that you posted above:
chdir('/path/to/vbulletin/forums/');//edit path to your vbulletin directory

- You need to edit this path to reflect your forums directory and then try it.
- try this first.

[SaN-DeeP]

Originally Posted by gspot

San-Deep

Do you see this line in my configuration file that you posted above:
chdir('/path/to/vbulletin/forums/');//edit path to your vbulletin directory

- You need to edit this path to reflect your forums directory and then try it.
- try this first.

tried to change the path too, but dont work

[gspot]

Its trying to load this table from mysql: "sandeep_f1nalDbaS3.user" does this table even exist? Please check your table extension that your using against your database tables in your mysql.