Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
Prev Previous Post   Next Post Next
  #3  
Old 02-01-2005, 04:38 AM
gspot's Avatar
gspot gspot is offline
 
Join Date: Mar 2003
Location: Nevada
Posts: 200
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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

Reply With Quote
 

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 08:25 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03607 seconds
  • Memory Usage 2,436KB
  • Queries Executed 12 (?)
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_php
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (3)post_thanks_box
  • (3)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (3)post_thanks_postbit_info
  • (3)postbit
  • (3)postbit_onlinestatus
  • (3)postbit_wrapper
  • (1)showthread_list
  • (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_threadedmode.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • 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_threaded
  • showthread_threaded_construct_link
  • 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
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete