View Single Post
  #137  
Old 09-02-2002, 04:44 PM
Boofo's Avatar
Boofo Boofo is offline
 
Join Date: Mar 2002
Location: Des Moines, IA (USA)
Posts: 15,776
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

g-force2k2, do these 2 pieces of code look right to you? They work the way they are but I'm not sure if they will interfere with anything else. This also includes the code you gave me to NOT display users with zero time in the list. I would also like to be able to NOT display the Total Online Time in the posts for users who have zero time or Admins. Any way to do that?

Code:
 if($bbuserinfo[usergroupid] != 6) {
  $totalusers = $DB_site->query_first("
    SELECT COUNT(*) AS users
    FROM user
    WHERE usergroupid != 6 AND timeonline > 0");
    } else {
    $totalusers = $DB_site->query_first("
    SELECT COUNT(*) AS users
    FROM user
    WHERE timeonline > 0");
    }
And:

Code:
if($bbuserinfo[usergroupid] != 6) {
    $leadtime = $DB_site->query("
        SELECT userid, username, joindate, timeonline, posts 
        FROM user 
        WHERE timeonline > 0
        ORDER by timeonline DESC LIMIT $startat,$perpage");
              } else {
    $leadtime = $DB_site->query("
        SELECT userid, username, joindate, timeonline, posts 
        FROM user
        WHERE usergroupid != 6 AND timeonline > 0
        ORDER by timeonline DESC LIMIT $startat,$perpage");
               }
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01113 seconds
  • Memory Usage 1,766KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • 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
  • showpost_complete