Meaning What Am I Doing Wrong? Here is part of my script:
PHP Code:
// ######################## SET PHP ENVIRONMENT ###########################
error_reporting(E_ALL & ~E_NOTICE);
// ##################### DEFINE IMPORTANT CONSTANTS #######################
define('CVS_REVISION', '$RCSfile: referralstats.php,v $ - $Revision: 2.1 $');
define('NO_REGISTER_GLOBALS', 1);
// #################### PRE-CACHE TEMPLATES AND DATA ######################
$phrasegroups = array('cpuser', 'forum', 'timezone', 'user');
$specialtemplates = array();
// ########################## REQUIRE BACK-END ############################
require_once('./global.php');
require_once('./includes/adminfunctions_user.php');
// ######################## CHECK ADMIN PERMISSIONS #######################
if (!can_administer('canadminusers'))
{
print_cp_no_permission();
}
// ############################# LOG ACTION ###############################
log_admin_action(iif($_REQUEST['userid'] != 0, 'user id = ' . $_REQUEST['userid']));
// ########################################################################
// ######################### START MAIN SCRIPT ############################
// ########################################################################
// ############################# start reset referrals ########################
// Define date stamp //
$todaysdate = date("F d, Y");
// End date stamp //
//////////////////
//////////////////
//Require Backend//
$backendinfo=$DB_site->query_first("SELECT * FROM " . TABLE_PREFIX . "referrals");
///////////////////
if ($backendinfo['limit1'] != ''){
$limit2 = "AND " . $backendinfo['limit1'] . " " . $backendinfo['limit2'] . " " . $backendinfo['limit3'] . "";
$limit3 = "AND users." . $backendinfo['limit1'] . " " . $backendinfo['limit2'] . " " . $backendinfo['limit3'] . "";
}
///////////////////////
//GET BOARD REFERRALS//
///////////////////////
$getboardtotal = $DB_site->query_first("SELECT SUM(totalreferrals) AS total FROM " . TABLE_PREFIX . "user WHERE totalreferrals > 0");
$getusertotal = $DB_site->query_first("SELECT COUNT(referrerid) as getusers FROM " . TABLE_PREFIX . "user WHERE referrerid > 0 $limit2");
$totalreferralstodate = $getboardtotal['total'] + $getusertotal['getusers'];
///////////////////////
$getuserinfo = $DB_site->query("SELECT COUNT(*) AS info, user.username, user.userid FROM " . TABLE_PREFIX ."user AS users INNER JOIN " . TABLE_PREFIX . "user AS user ON(users.referrerid = user.userid)
WHERE users.referrerid > 0
$limit3
GROUP BY users.referrerid
ORDER BY info DESC");
$users = $DB_site->query_first("SELECT COUNT(*) AS count, user.username, user.userid FROM " . TABLE_PREFIX . "user AS users INNER JOIN " . TABLE_PREFIX . "user AS user ON(users.referrerid = user.userid)
WHERE users.referrerid > 0
$limit3
GROUP BY users.referrerid
ORDER BY count DESC");
$referralcount=$DB_site->query("SELECT COUNT(*) FROM " . TABLE_PREFIX . "user
WHERE referrerid > 0 $limit2");
$referralcounts = mysql_fetch_row($referralcount);
$lastreferrals=$DB_site->query("SELECT date FROM " . TABLE_PREFIX . "referrals");
$lastcount = mysql_fetch_row($lastreferrals);
if (!$lastcount){
$lastcount[0]="N/A"; // No Reset Record Found
}
///////////////////////////////////////////////
if ($_REQUEST['do'] == 'referralstatistics')
{
if ($users['username'] == ''){
$users['username'] = 'N/A';
$users['count'] = 'N/A';
$viewlink = 'N/A';
}
$error = '';
if ($backendinfo['vbpath'] == '') {
$error = '<b>ERROR: You must set your vbulletin path!</b><br><br>';
}
print_cp_header("Referral Statistics Version 2.1");
print_form_header('referralstats','config');
print_table_header("Referral Statistics - Settings");
print_description_row("$error
<u>Click on 'Configure Referral Statistics' to perform one of the following:</u>
<li> Set-up Referral Statistics</li>
<li> Configure how many referral results per page</li>");
print_submit_row("Configure Referral Statistics", 0);
print_form_header('referralstatsshow','');
print_cells_row(array($vbphrase['referrals_since_last_reset'], $vbphrase['referrals_last_reset_was_on'], $vbphrase['referrals_total_to_date']), 1);
print_cells_row(array("<b>$referralcounts[0]</b>", "<b>$lastcount[0]</b>", "<b>$totalreferralstodate</b>"));
print_cells_row(array($vbphrase['referrals_leader'], $vbphrase['referrals_leading_with'], $vbphrase['referrals_leader_members_view']), 1);
if ($users['username'] != 'N/A'){
$viewlink="<a href=usertools.php?do=showreferrals&referrerid=$users[userid]>View Members</a>";
}
print_cells_row(array("<b>$users[username]</b>", "<b>$users[count]</b>", "<b>$viewlink</b>"));
print_table_footer();
print_form_header('referralstats','reset');
print_table_header("Referral Statistics - Reset");
print_description_row("<u>Click on 'Reset Statistics' to perform one of the following:</u>
<li>Reset all board referrals</li>
<li>Reset referrals by member</li>");
print_submit_row("Reset Statistics", 0);
print_cp_footer();
}