Has anybody done a VB stats hack?

[Kevlar]

Alright, I'm new here... and I tried looking around but couldn't find anything like this yet.

Has anybody done like a VB stats hack? I mean to get some cool information like this?

http://www.bimmerforums.com/stats.php ?

I got most of it working, I just can't get the "most users online" feature to work. It always says the most users online is current user count.

Any ideas?

FYI... this is my first time coding PHP so if I overlooked something simple... give me a break, I'm still learning.

[Bane]

I believe there are currently two people working on vb stats currently.

Znaper is working on one at http://www.german-community.de/statistik.php

And I am working on one as well.

As far as the record users, I can try playing with that a bit and try to figure something out.

[JoshFink]

Bane, have you had any luck oin the stats code? I'm just trying to figure out if I should start my own or wait for others.

Thanks,

Josh

[Kevlar]

Good... at least I don't feel alone in my quest for putting the board stats up.

[Bane]

Well, what Im working on is a little more in depth.. A bit more statistics than any others I saw so far..

My niece just led me through a half hour tirade of why that witch from little mermaid is a really horrible person so I havent even looked at the record users bit.

As far as starting your own, if you are any good you can probably do much better than I will anyway. If you do figure out the code let us all know.

[TheProfessor]

Well, here it is, the statistics hack:

Create a file named stats.php. insert the following lines:

PHP Code:

<?php
// Boardstatistics scripted by Znaper (e-mail: [email]webmaster@znapers-board.de[/email])

require('./global.php');

// get total members
$numbersmembers=$DB_site->query_first('SELECT COUNT(*) AS users,MAX(userid) AS max FROM user');
$numbermembers=$numbersmembers['users'];

// get active members
$snonposters=$DB_site->query_first('SELECT COUNT(*) AS users,MAX(userid) AS max FROM user WHERE posts=0');
$nonposters=$snonposters['users'];
$activemembers=$numbermembers-$nonposters;
$activityrate=sprintf("%.2f",(100*$activemembers/$numbermembers));

// get total posts
$countposts=$DB_site->query_first('SELECT COUNT(*) AS posts FROM post');
$totalposts=$countposts['posts'];

// get total threads
$countthreads=$DB_site->query_first('SELECT COUNT(*) AS threads FROM thread');
$totalthreads=$countthreads['threads'];

// get total thread views
$boardviews = $DB_site->query_first("SELECT SUM(views) AS threadviews FROM thread");
$totalviews = $boardviews[threadviews];

// get total pms
$totalpms = $DB_site->query_first("SELECT count(*) as pmcount FROM privatemessage"); 
$totalpm = $totalpms[pmcount];

// thanks to AA for the following lines:
// get Top 10 Posters of the last 30 days
if (isset($days)==0 and $days==0) { $days=30; }

$datecut=time()-($days*86400);

$posts=$DB_site->query("SELECT DISTINCT(userid),COUNT(postid) AS posts
                          FROM post
                         WHERE userid > 0 AND post.dateline>=$datecut
                      GROUP BY userid
                      ORDER BY posts DESC
                         LIMIT 10");

while ($user=$DB_site->fetch_array($posts)) {

$result=$DB_site->query_first("SELECT username
                                   FROM user
                                  WHERE userid=$user[userid]");
                                  $topposters.="<tr><td><a href=\"member.php?action=getinfo&userid=$user[userid]\">$result[username]</a></td><td>$user[posts]</td></tr>";
                                  }
                                  
// thanks to AA for the following lines:
// get Top 10 Posters of the last 24 hours
if (isset($days2)==0 and $days2==0) { $days2=1; }

$datecut2=time()-($days2*86400);

$posts2=$DB_site->query("SELECT DISTINCT(userid),COUNT(postid) AS posts
                          FROM post
                         WHERE userid > 0 AND post.dateline>=$datecut2
                      GROUP BY userid
                      ORDER BY posts DESC
                         LIMIT 10");

while ($user2=$DB_site->fetch_array($posts2)) {

$result2=$DB_site->query_first("SELECT username
                                   FROM user
                                  WHERE userid=$user2[userid]");
                                  $toplastposters.="<tr><td><a href=\"member.php?action=getinfo&userid=$user2[userid]\">$result2[username]</a></td><td>$user2[posts]</td></tr>";
                                  }
                                  

$co="Statistics-Hack ? 2001 by <a href=\"mailto:webmaster@znapers-board.de\">Znaper</a>, thanks to AA";
$templatesused = "";
// Only one template is used so load it when called
eval("dooutput(\"".gettemplate("boardstatistics")."\");");

// free used memory
unset($user);
$DB_site->free_result($posts);
unset($user2);
$DB_site->free_result($posts2);

?>

Save this file the root directory of your board.

Next create a template namend boardstatistics. Insert the following lines into the template:

PHP Code:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
  
<title>$bbtitle Boardstatistics</title>
  $headinclude
</head>
<body>

$header
<br>

<table cellpadding="0" cellspacing="0" border="1" width="100%" align="center">
<tr><td bgcolor="#00496C" align="center"><font face="verdana, arial, helvetica" size="2"  color="Silver"><b>BOARDSTATISTIK</b></td></tr>
<tr><td bgcolor="#000333">
<normalfont>
  <b>?</b> Registered Members: <b>$numbermembers</b><br>
  <b>?</b> 0-Posters: <b>$nonposters</b><br>
  <b>?</b> Active Members: <b>$activemembers</b><br>
  <b>?</b> Active rate of all Members: <b>$activityrate %</b><br>
  <b>?</b> Total Threads: <b>$totalthreads</b> threads<br>
  <b>?</b> Total Posts: <b>$totalposts</b> posts<br>
  <b>?</b> Total Views: <b>$totalviews</b> views<br>
<br>
  <b>?</b> <b>$totalpm</b> Private Messages are stored in our Mailboxes!
<br><br><center>
<table><tr><td valign="top">

<table cellpadding="2" align="center" bordercolor="#000040" border="-1">
<tr bgcolor="#00496C"><td colspan=2 align=center><b>Top10 Poster of the last 30 days</b></td></tr>
<tr bgcolor="#00496C"><td>Username</td><td>posts</td></tr>
$topposters</table>
</td><td valign="top">

<table cellpadding="2" align="center" bordercolor="#000040" border="-1">
<tr bgcolor="#00496C"><td colspan=2 align=center><b>Top Poster of the last 24 hours</b></td></tr>
<tr bgcolor="#00496C"><td>Username</td><td>Posts</td></tr>
$toplastposters</table>
</td></tr></table>
<br><br></center>
</font></normalfont>
</td></tr></table>

$footer
<center>$co</center>
</body>
</html> 


Now just call stats.php. Furthermore place a link in on of your templates so members can view the stats. I suggest forumhome ...

Greetings, The Professor!

[JamesUS]

There is also another vBStats hack that does something slightly different. If you want to take a look, search for 'vbstats' in the Hacks forum.

Very nice TheProfessor,
I'll suggest to built that into our forums,
Lian

[TheProfessor]

Yeah, but please remeber that all credits go to Znaper and AA ...

[Kevlar]

Random users are getting this error

Warning: Cannot add header information - headers already sent by (output started at /home/bimmer/www/main.php:7) in /home/bimmer/www/forum/admin/functions.php on line 1459

Only random users. I don't get it, but other users are telling me the error exists.

any ideas?