Assuming you are using in your 'htdocs' a /forum folder:
PHP Code:
<?php
require_once('./forum/global.php');
$memberscount = $DB_site->query_first("
SELECT COUNT(*) AS total,MAX(userid) AS max FROM user
");
$memberstotal = number_format($memberscount['total']);
$threadscount = $DB_site->query_first("
SELECT COUNT(*) AS total FROM thread
");
$threadstotal = number_format($threadscount['total']);
$postscount = $DB_site->query_first("
SELECT COUNT(*) AS total FROM post
");
$poststotal = number_format($postscount['total']);
if ($displayloggedin)
{
$datecut = $ourtimenow - $cookietimeout;
$loggedins = $DB_site->query_first("
SELECT COUNT(*) AS sessions
FROM session
WHERE userid=0
AND lastactivity>$datecut
");
$numberguest = $loggedins['sessions'];
$numberregistered = 0;
$loggedins = $DB_site->query("
SELECT DISTINCT session.userid,username,invisible,usergroupid
FROM session
LEFT JOIN user ON (user.userid=session.userid)
WHERE session.userid>0
AND session.lastactivity>$datecut
ORDER BY invisible ASC, username ASC
");
if ($loggedin = $DB_site->fetch_array($loggedins))
{
$numberregistered++;
while ($loggedin = $DB_site->fetch_array($loggedins))
{
$numberregistered++;
}
}
$DB_site->free_result($loggedins);
$onlinetotal = $numberregistered + $numberguest;
}
$totalposts = number_format($countposts['posts']);
print_r('Members: ' . $memberstotal . '<br />');
print_r('Threads: ' . $threadstotal . '<br />');
print_r('Posts: ' . $poststotal . '<br />');
print_r('Online Users: ' . $onlinetotal);
?>