# Ministats by Kiin #

Source: http://board.michaelpark.net/viewtopic.php?p=124

Outside the b2-loop it echos (#) Posts and (#) Comments. That's all it does. I'm using it at my index page.
Make these two php files, upload them and call them in your template.

# b2countposts.php
  
[code]
<?php
$qual="SELECT * from $tableposts order by id desc";
$result=mysql_query($qual) or die
("Could not execute query: $qual." . mysql_error());

$how_many = mysql_num_rows($result);

echo "$how_many";
?>
[/code]


# b2countcomments.php
  
[code]
<?php
$quid="SELECT * from $tablecomments";
$ress=mysql_query($quid) or die
("Could not execute query: $quid." . mysql_error());

$comm_many = mysql_num_rows($ress);

echo "$comm_many";
?>
[/code]



Then you call them in your template (OUTSIDE the b2-loop!!) using include.

[code]
I have <?php include("b2countcposts.php"); ?> posts and <?php include("b2countcomments.php"); ?> comments.
[/code]

Will output:
"I have 800 posts and 690 comments."
For example.

That's it!

Source: http://board.michaelpark.net/viewtopic.php?p=124#124