[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,