vb.org Archive - Pull the # of members/guest online from database?

make a .php file "call it whatever" drop it in your /forum/ dir and
run it see what happens.

Code:

<?php



error_reporting(E_ALL & ~E_NOTICE);



    $specialtemplates = array(

        'maxloggedin',

    );

        

        require_once("global.php");

        require_once("includes/functions_forumlist.php");

        

        $getnewestusers=$DB_site->query_first("SELECT userid,username FROM user ORDER BY joindate DESC LIMIT 1");

        $newusername=$getnewestusers['username'];

        $newuserid=$getnewestusers['userid'];



        $datecut = time()-$vboptions['cookietimeout'];

        $regmembername = $DB_site->query("SELECT DISTINCT username,options FROM ".$tableprefix."user,".$tableprefix."session 

                WHERE ".$tableprefix."session.userid=".$tableprefix."user.userid AND ".$tableprefix."session.lastactivity>$datecut 

                ORDER BY username ASC") or exit("oops2");

                

        while($regmember = $DB_site->fetch_array($regmembername))

        {

                $regmember['options'] = intval($regmember['options']);

                

                foreach($_USEROPTIONS as $optionname => $optionval)

                {

                        $regmember["$optionname"] = iif($regmember['options'] & $optionval, 1, 0);

                }

                

                if ((($regmember['invisible'] == 0)) and $regmemberson or ($bbuserinfo['usergroupid'] == 6 and $regmember['invisible'] == 1))

                {

                        $regmemberson .= ", ";

                }

        

                $regmembercomma++;

                if ($regmember['invisible'] == 0 or $bbuserinfo['usergroupid'] == 6) {

                        if ($regmember['invisible'] == 1) {

                                $userinvisible = "*";

                        }

                                                

                        $regmemberson .= $regmember['username'].$userinvisible;

                        

                } else {

                        $regmembercomma++;

                }

        }

        

        if (!$regmemberson)

        {

                $regmemberson = "(none)";

        }

        

        $regmembers = $DB_site->query_first("SELECT COUNT(DISTINCT userid) AS membersonline FROM ".$tableprefix."session WHERE userid>0 AND ".$tableprefix."session.lastactivity>$datecut") or exit("oops3");

        $regmembersno = number_format($regmembers['membersonline']);



          $username=$bbuserinfo['username'];$guests = $DB_site->query_first("SELECT COUNT(userid) AS guestsonline FROM ".$tableprefix."session WHERE userid=0 AND ".$tableprefix."session.lastactivity>$datecut") or exit("oops4");

        $guestson = number_format($guests['guestsonline']);

        $totalonline = $regmembersno + $guestson;

        

            // ### MAX LOGGEDIN USERS ################################

    $maxusers = unserialize($datastore['maxloggedin']);

    $recordusers = $maxusers['maxonline'];

    $recorddate = vbdate($vboptions['dateformat'], $maxusers['maxonlinedate'], true);

    $recordtime = vbdate($vboptions['timeformat'], $maxusers['maxonlinedate']);



echo "<div style=\"font-family:Verdana; font-size:11;\"> Active users online: $totalonline ($regmembersno users and $guestson guests online.)</div>

<div style=\"font-family:Verdana; font-size:10;\"><a href=\"forum/member.php?s=&action=getinfo&userid=$userid\">$regmemberson</a></div>

<div style=\"font-family:Verdana; font-size:11;\">Most users ever online was $recordusers, $recorddate at $recordtime<br>

Welcome to our newest member: <a href=\"member.php?s=&action=getinfo&userid=$newuserid\">$newusername</a><div><br>";



?>

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.00962 seconds Memory Usage 1,717KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (3)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.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 printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: