vb.org Archive - phrase question

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();

}

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01125 seconds Memory Usage 1,774KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (3)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.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 printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: