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

None of my vbphrases are showing up, what is wrong here they were all entered into the admincp phrases under global. here is 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();

ANY IDEAS???
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 11:32 AM.


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.08579 seconds
  • Memory Usage 2,501KB
  • 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
  • (6)post_thanks_box
  • (6)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (6)post_thanks_postbit_info
  • (6)postbit
  • (6)postbit_onlinestatus
  • (6)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