vb.org Archive
Page 8 of 8 « First 67 8
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   Who's online on non-vB page (with usernames, same rules as Who's Online on forumhome) (https://vborg.vbsupport.ru/showthread.php?t=60019)

dstjohn 08-12-2006 03:52 AM
Forgot to mention you need to run through the entire script
and do a search and replace.

search for all instances of $tableprefix

and replace with
$config['Database']['tableprefix']

dstjohn 08-12-2006 03:57 AM
PHP Code:
<?php

//VARS, edit to your vb environment
$path = "./forums/";             // path to your forums folder, normally /forum/
$showusernames = 0;         // valid settings TRUE = yes show usernames FALSE = dont show usernames
//stop vars

chdir($path);
require_once("./includes/config.php");

function iif($expression, $returntrue, $returnfalse = '') {
    return ($expression ? $returntrue : $returnfalse);
}

mysql_connect($config['MasterServer']['servername'],$config['MasterServer']['username'],$config['MasterServer']['password']);
mysql_select_db($config['Database']['dbname']);



$settings = mysql_query("SELECT * FROM ".$config['Database']['tableprefix']."setting WHERE varname = 'cookietimeout'");
$settings = mysql_fetch_array($settings);

$datecut = time()-$settings['value'];

if ($showusernames == 1)
{
    $regmembers = mysql_query("SELECT DISTINCT username,options FROM ".$config['Database']['tableprefix']."user,".$config['Database']['tableprefix']."session 
        WHERE ".$config['Database']['tableprefix']."session.userid=".$config['Database']['tableprefix']."user.userid AND ".$config['Database']['tableprefix']."session.lastactivity>$datecut 
        ORDER BY username ASC") or exit("oops2");
        
    while($regmember = mysql_fetch_array($regmembers))
    {
        $regmember['options'] = intval($regmember['options']);
        
        foreach($regmember 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)";
    }
        
} else {
    $regmembers = mysql_query("SELECT COUNT(DISTINCT userid) AS membersonline FROM ".$config['Database']['tableprefix']."session WHERE userid>0 AND ".$config['Database']['tableprefix']."session.lastactivity>$datecut") or exit("oops3");
    $regmembers = mysql_fetch_array($regmembers);
    
    $regmemberson = number_format($regmembers['membersonline']);
}

$howmany = substr_count($regmemberson,",");

if (($showusernames == 1 and $howmany >= 1) or ($showusernames == 0 and $regmemberson > 1))
{
    $memberstext = 'Members';
}
else
{
    $memberstext = 'Member';
}

$guests = mysql_query("SELECT COUNT(userid) AS guestsonline FROM ".$config['Database']['tableprefix']."session WHERE userid=0 AND ".$config['Database']['tableprefix']."session.lastactivity>$datecut") or exit("oops4");
$guests = mysql_fetch_array($guests);

if ($guests['guestsonline'] > 1)
{
    $gueststext = 'Guests';
}
else
{
    $gueststext = 'Guest';
}
$guestson = number_format($guests['guestsonline']);

$show = $memberstext.' online: '.$regmemberson.'. '.$gueststext.' online: '.$guestson.'.';

print $show;

?>

vol_freak 08-21-2006 02:02 PM
Quote:
Originally Posted by dstjohn
PHP Code:
<?php

//VARS, edit to your vb environment
$path = "./forums/";             // path to your forums folder, normally /forum/
$showusernames = 0;         // valid settings TRUE = yes show usernames FALSE = dont show usernames
//stop vars

chdir($path);
require_once("./includes/config.php");

function iif($expression, $returntrue, $returnfalse = '') {
    return ($expression ? $returntrue : $returnfalse);
}

mysql_connect($config['MasterServer']['servername'],$config['MasterServer']['username'],$config['MasterServer']['password']);
mysql_select_db($config['Database']['dbname']);



$settings = mysql_query("SELECT * FROM ".$config['Database']['tableprefix']."setting WHERE varname = 'cookietimeout'");
$settings = mysql_fetch_array($settings);

$datecut = time()-$settings['value'];

if ($showusernames == 1)
{
    $regmembers = mysql_query("SELECT DISTINCT username,options FROM ".$config['Database']['tableprefix']."user,".$config['Database']['tableprefix']."session 
        WHERE ".$config['Database']['tableprefix']."session.userid=".$config['Database']['tableprefix']."user.userid AND ".$config['Database']['tableprefix']."session.lastactivity>$datecut 
        ORDER BY username ASC") or exit("oops2");
        
    while($regmember = mysql_fetch_array($regmembers))
    {
        $regmember['options'] = intval($regmember['options']);
        
        foreach($regmember 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)";
    }
        
} else {
    $regmembers = mysql_query("SELECT COUNT(DISTINCT userid) AS membersonline FROM ".$config['Database']['tableprefix']."session WHERE userid>0 AND ".$config['Database']['tableprefix']."session.lastactivity>$datecut") or exit("oops3");
    $regmembers = mysql_fetch_array($regmembers);
    
    $regmemberson = number_format($regmembers['membersonline']);
}

$howmany = substr_count($regmemberson,",");

if (($showusernames == 1 and $howmany >= 1) or ($showusernames == 0 and $regmemberson > 1))
{
    $memberstext = 'Members';
}
else
{
    $memberstext = 'Member';
}

$guests = mysql_query("SELECT COUNT(userid) AS guestsonline FROM ".$config['Database']['tableprefix']."session WHERE userid=0 AND ".$config['Database']['tableprefix']."session.lastactivity>$datecut") or exit("oops4");
$guests = mysql_fetch_array($guests);

if ($guests['guestsonline'] > 1)
{
    $gueststext = 'Guests';
}
else
{
    $gueststext = 'Guest';
}
$guestson = number_format($guests['guestsonline']);

$show = $memberstext.' online: '.$regmemberson.'. '.$gueststext.' online: '.$guestson.'.';

print $show;

?>

Anyone know how to get this to work with 3.6? It will display the number of members and guests online but I cannot get it to list the member names.

Any help would be greatly appreciated.

shortbus1662 08-25-2006 03:09 AM
is there any way to get this to work on a non .php page, like asp for instance?

If anyone can do this I'd love to speak with you.

danward 02-20-2007 02:18 PM
Great update dstjohn!! Would be great to get the usernames to work on 3.6 aswell!!

davidallsop 04-25-2007 11:04 AM
Is there anyway of getting the members online to display in the latest version of vBulletin? as Im looking for something a bit more than just the members online count.

zaraz 11-14-2007 08:31 PM
Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING in /home/c/..................../forum/online_external.php on line 19

:confused:

Andy92 01-08-2008 06:30 PM
This wont work in 3.7.

??

Paul M 01-08-2008 06:47 PM
Not a chance, this was written for vb 3.0.

Andy92 01-13-2008 07:01 PM
Can anyone help me work out how i can display this on a non vbulletin page, with vbulletin 3.7 ??


All times are GMT. The time now is 11:09 AM.
Page 8 of 8 « First 67 8
Show 40 post(s) from this thread on one page

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.01267 seconds
  • Memory Usage 1,844KB
  • 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
  • (2)bbcode_php_printable
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete