User(+Forum?)Stats on a NON-VB Page!

[Jack28]

UserStats on a NON-VB Page!
and if possible ForumStats like:

Currently Active Users: 145 (47 members and 98 guests)
Threads: 37,933
Posts: 359,546
Members: 51,820
Newest member: YBnormal

can anyone make this mini-mod plz!

thnx,
JaCky

[Jack28]

bump

[Andreas]

[sql]
select * from datastore where title='userstats'
[/sql]

Unserialize this and you will have an array with entries numbermembers, newusername and newuserid.

[sql]
select * from datastore where title='forumcache'
[/sql]

Unserialize this which will give you an multi-dimensional associative array with all forum information. Loop through this array and accumulate threadcount and replycount.

'Who is online' is a bit more complicated. Take a look at index.php after

PHP Code:

// ### LOGGED IN USERS ################################################# 


to see how vBulletin does it.

[Jack28]

so? how will it be when i make just one single forumstats.php page?

do i need to use includes n stuff?

[mchaos]

I too am trying to put who is online on a non vb page, Have tryed many things, with little progress, how bout a hand...

[virtualraceday]

try this... it works for vb 3.5.x

PHP Code:

<?php
// Connecting to your database
mysql_connect(DB_HOST, DB_USER, DB_PASS)
OR die ("Cannot connect to your database");
mysql_select_db('dogforum') OR die("Cannot connect to your database");

$guests = mysql_query("SELECT COUNT(*) FROM session WHERE userid=0");
$row = mysql_fetch_row($guests);
$numberguest=$row[0];

$users = mysql_query("SELECT COUNT(*) FROM session WHERE userid<>0");
$row = mysql_fetch_row($users);
$numberusers=$row[0];

$total_online = $numberguest + $numberusers;

$query = mysql_query("select * from datastore");
$data = array();
while ($row = mysql_fetch_row($query)) {
    $data[$row[0]] = $row[1];
}

$maxonline = unserialize($data['maxloggedin']);
$userstats = unserialize($data['userstats']);
?>

Visitors Online: <strong><?=$total_online;?></strong><br>
Members: <strong><?=$numberusers;?></strong> <br>
Guests: <strong><?=$numberguest;?></strong><br>
Registered users:<strong><?=$userstats['numbermembers'];?></strong><br><br>
Most users online: <b><?=$maxonline['maxonline'];?></b><br>
on <?=date("M jS, Y G:i:s", $maxonline['maxonlinedate']);?>.<br>
Newest member, <b><?=$userstats['newusername'];?></b>

work fine for me... check it out http://www.thedogsite.com/ (top left box)