Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #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
  #2  
Old 02-01-2005, 02:22 PM
Dean C's Avatar
Dean C Dean C is offline
 
Join Date: Jan 2002
Location: England
Posts: 9,071
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

You sure you added them into one of these phrasegroups: array('cpuser', 'forum', 'timezone', 'user')
Reply With Quote
  #3  
Old 02-01-2005, 10:13 PM
gspot's Avatar
gspot gspot is offline
 
Join Date: Mar 2003
Location: Nevada
Posts: 200
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Actually im not sure, they were just added to the global setting. Is this wrong then?
Reply With Quote
  #4  
Old 02-01-2005, 11:27 PM
Dean C's Avatar
Dean C Dean C is offline
 
Join Date: Jan 2002
Location: England
Posts: 9,071
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I think so, try moving them to the relevant phrase group and see if that helps I'm not a fan of the language system in vB3 and hence I'm not 100% sure how it works
Reply With Quote
  #5  
Old 02-01-2005, 11:54 PM
gspot's Avatar
gspot gspot is offline
 
Join Date: Mar 2003
Location: Nevada
Posts: 200
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

what would the relevant phase group be?? I dont know how it works?
Reply With Quote
  #6  
Old 02-04-2005, 03:36 PM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Any group can be relevant, whatever you want. Just make sure you load them into the $phrasegroups array.
Reply With Quote
Reply


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 10:03 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.05981 seconds
  • Memory Usage 2,261KB
  • Queries Executed 11 (?)
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)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (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)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_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • 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