Help !!!!

[Sebastian]

Hi.

I have this hack a long time ago, you will have to use only the parts you want.

this hack will display

1) total registered members using variable: $totalmembers
2) show total threads using variable: $totalthreads
3) show total post made today using variable : $totalpoststoday
4) show total post using variable: $totalposts
5) show TOTAL users online using variable: $totalon

If you want to show how many user and guest seperate then use: $regmemberson for members online, and $guestson for guests online.

all you have to do is copy the code into a file then include(); it and use the variables above to show what you want.

PHP Code:

<?php
$usernames = "off"; // this will show their names if they are registered
$path = "/forums/admin"; // path to forum/admin directory
$dbservertype='mysql';
$servername='localhost';
$dbusername='****';
$dbpassword='****';
$dbname='vbulletin'; // database name

$db=mysql_connect($servername,$dbusername,$dbpassword);
mysql_select_db($dbname);

if(isset($bbuserinfo["username"]) && ($bbuserinfo["username"] != "Unregistered")) { 
}
$username = $bbuserinfo["username"];

$cookievalue = mysql_query("SELECT value FROM setting WHERE varname = 'cookietimeout'") or die("Error");
$cookietimeout = mysql_result($cookievalue, 0, 0);
$datecut = time()-$cookietimeout;

$invisibleregmember = "0";

if ($usernames == "on") {
    $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") or die("Error");
    while($regmember = mysql_fetch_array($regmembers)):
        ++$regmembercomma;
        if ($regmember[invisible] == 0) {
            $regmemberson .= $regmember[username];
        } else {
            ++$regmembercomma;
        }
        if ($regmembercomma < mysql_num_rows($regmembers)):
            $regmemberson .= ", ";
        endif;
    endwhile;
} else {

  $regmemberson=0;
  $loggedins=mysql_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");
  while ($loggedin=mysql_fetch_array($loggedins)) {
    $regmemberson++;}
}

// get who is online
$guests = mysql_query("SELECT COUNT(userid) AS guestsonline FROM session WHERE userid=0 AND lastactivity>$datecut") or die("oops3");
while($guest = mysql_fetch_array($guests)):
    $guestson = number_format($guest[guestsonline]);
endwhile;
$totalon = $regmemberson+$guestson;

// get total posts
$countposts = mysql_query("SELECT COUNT(postid) AS posts FROM post");
while($countpost = mysql_fetch_array($countposts)):
    $totalposts = number_format($countpost[posts]);
endwhile;

$countthreads = mysql_query("SELECT COUNT(threadid) AS threads FROM thread");
while($countthread = mysql_fetch_array($countthreads)):
    $totalthreads = number_format($countthread[threads]);
endwhile;

// number of posts today
$datecut = mktime(0,0,0,date("m"), date("d"), date("y"));
$getpoststoday = mysql_query("SELECT count(postid) AS count FROM post WHERE dateline>='$datecut'");
while($getposttoday = mysql_fetch_array($getpoststoday)):
    $totalpoststoday = number_format($getposttoday[count]);
endwhile;

?>