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.