Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
  #1  
Old 09-02-2001, 08:02 PM
Dave# Dave# is offline
 
Join Date: Nov 2001
Posts: 82
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

So very nearly there. I have managed to get the online users on a non VB page thing working well, heres what it looks like

However the code doesn't show the total online users figure $totalonline Can anyone help me with that code?

Heres the code sofar

PHP Code:
<?
 {
  require("/home/admin/www/forums/admin/config.php");

  $db=mysql_connect($servername,$dbusername,$dbpassword) or die("Can't open connection to MySQL");
  mysql_select_db($dbname) or die("Can't select database");
  
    $cookievalue = mysql_query("SELECT value 
                                FROM setting 
                                                            WHERE varname = 'cookietimeout'");
  $cookietimeout = mysql_result($cookievalue, 0, 0);
  $datecut = time()-$cookietimeout;
  $invisibleregmember = "0";
  $regmembers = mysql_query("SELECT DISTINCT username,invisible 
                               FROM user,session 
                                                         WHERE session.userid=user.userid AND session.lastactivity>$datecut AND invisible='0' 
                                                         ORDER BY username ASC");

  while($regmember = mysql_fetch_array($regmembers)):
    ++$regmemberbr;
    if ($regmember[invisible] == 0) {
      $regmemberson .= "$regmember[username]";
    } else {
      ++$regmemberbr;
    }
    if ($regmemberbr < mysql_num_rows($regmembers)):
      $regmemberson .= ", ";
    endif;
  endwhile;

  $guests = mysql_query("SELECT COUNT(userid) AS guestsonline FROM session WHERE userid=0 AND session.lastactivity>$datecut") or die("oops3");

  while($guest = mysql_fetch_array($guests)):
    $guestson = number_format($guest[guestsonline]);
  endwhile;

  if ($regmemberson == "") {
    $onlinemembers = "<p>No Registered Members</p>";
  } else {
    $onlinemembers = "Members Online: $regmemberson";
  }

  if ($guestson == "0") {
    $onlineguests = "No Guests";
  } else {
    $onlineguests = " and $guestson guests: ";
  }

  print "<font size=\"1\">$onlinemembers $onlineguests</font>";

}
?>
Reply With Quote
Reply

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 02:32 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.05241 seconds
  • Memory Usage 2,204KB
  • 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)bbcode_php
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)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)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_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