boardom

[GamerZ]

[GamerZ]

To Cyber: Here is the code

[php:1:0141613c00]
<?
/* b2stats.php
* An addon to B2 which diplays b2 stats
* Demo of this file @ http://www.orientek.net/kore/gamerz/b2stats.php
* Created By Lester "GamerZ" Chan - http:/www.gamerz.per.sg
* Copyright © 2002 Lester "GamerZ" Chan. All Rights Reserved.
*
* B2 Created By Michel V - http://www.cafelog.com/
*
* You may modify this file to suit your owns needs, but please keep the copyright in tag. Thanks
* Any problems, email me @ [email protected] or post it in the B2 forums @ http://tidakada.com/board/
*/

// Start Connect To MYSQL
require("b2config.php");
include("$b2inc/b2vars.php");
include("$b2inc/b2functions.php");

dbconnect();
// Queries
$tp = "SELECT COUNT(DISTINCT ID) FROM $tableposts";
$tc = "SELECT COUNT(DISTINCT comment_ID) FROM $tablecomments";
$cp = "SELECT COUNT(DISTINCT comment_author) FROM $tablecomments";
$lbe = "SELECT ID, post_title FROM $tableposts ORDER BY post_date DESC LIMIT 5";
$lc = "SELECT ID, post_title, comment_author, comment_date FROM $tableposts, $tablecomments WHERE $tableposts.ID=$tablecomments.comment_post_ID ORDER BY $tablecomments.comment_date DESC LIMIT 5";
$mcb = "SELECT ID, post_title, COUNT($tablecomments.comment_post_ID) AS 'commentstotal' FROM $tableposts, $tablecomments WHERE $tableposts.ID=$tablecomments.comment_post_ID GROUP BY $tablecomments.comment_post_ID ORDER BY commentstotal DESC LIMIT 5";

// Basic MYSQL Quries
$a = mysql_query($tp) or die(mysql_error());
$totalposts = mysql_result($a, 0);

$b = mysql_query($tc) or die(mysql_error());
$totalcomments = mysql_result($b, 0);

$c = mysql_query($cp) or die(mysql_error());
$commentsposters = mysql_result($c, 0);

// Output General Stats
echo "<table width=\"100%\" cellspacing=\"0\" cellpadding=\"0\">\n";
echo "<tr>\n";
echo "<td>\n";
echo "<b>» Generals Stats</b><br>\n";
echo "<b>".$totalposts."</b> Posts<br>\n";
echo "<b>".$totalcomments."</b> Comments<br>\n";
echo "<b>".$commentsposters."</b> Different Nicks Were Represented In The Comments\n";
echo "<br><br>";
echo "<b>\n";
echo "</td>\n</tr>\n</table><br><br>";


// Latest 5 Blog Entries
echo "<table width=\"100%\" cellspacing=\"0\" cellpadding=\"0\">\n";
echo "<tr>\n<td>\n";
echo "<b>» Latest 5 Blog Entries</b><br>\n";
$result = mysql_query($lbe);
while ($data = mysql_fetch_row($result)) {
echo "<b>+</b> <a href=\"$siteurl/$blogfilename?p=$data[0]\">$data[1]</a><br>\n";
}
echo "</td>\n</tr>\n</table><br><br>";

// Latest 5 Comments
echo "<table width=\"100%\" cellspacing=\"0\" cellpadding=\"0\">\n";
echo "<tr>\n<td>\n";
echo "<b>» Latest 5 Comments</b><br>\n";
$result = mysql_query($lc);
while ($data = mysql_fetch_row($result)) {
echo "<b>+</b> $data[3] - $data[2] (<a href=\"$siteurl/$blogfilename?p=$data[0]\">$data[1]</a>)<br>\n";
}
echo "</td>\n</tr>\n</table><br><br>";

// Top 5 Most Commented Blog
echo "<table width=\"100%\" cellspacing=\"0\" cellpadding=\"0\">\n";
echo "<tr>\n<td>\n";
echo "<b>» 5 Most Commented Blogs</b><br>\n";
$result = mysql_query($mcb);
while ($data = mysql_fetch_row($result)) {
echo "<b>+</b> <a href=\"$siteurl/$blogfilename?p=$data[0]\">$data[1]</a> ($data[2] Comments)<br>\n";
}
echo "</td>\n</tr>\n</table><br><br>";

?>
[/php:1:0141613c00]
_________________

++ GamerZ.Per.Sg - Complex Simplicity

[cyber]

Thank you so much, GamerZ

cyber

[GamerZ]

[dille]

Hi,

Just a quick note to thank GamerZ for the l33t scriptag3 =]

View the results on my blog here.

Keep up the good work!
_________________
Shameless self-plug: visit my blog (it's Dutch)

[GamerZ]

[mikelittle]

Hey GamerZ,
I've modifed your hack a bit to make it more possible to use only some
bits of it.

Basically, I've turned all the non-user-specific stats (the first half of the
page's output) into individual functions.

I've added a couple of bits of extra functionality too; like being able to
specify top5 or top 10. I've also excluded the trackbacks and pingbacks
from the comments stuff.

All the functions have been commented. You should be able to rip these
functions out into an include file.

I've not changed the second half of the file at all so I've not quoted it here.

Updated 00:20 GMT+1 Fixed a bug and added a parameter.

File is here:
[php:1:104564d9ed]<?
/* b2stats.php
* An addon to B2 which diplays b2 stats
* Demo of this file @ http://www.orientek.net/kore/gamerz/b2stats.php
* Created By Lester "GamerZ" Chan - http:/www.gamerz.per.sg
* Copyright ® 2002 Lester "GamerZ" Chan. All Rights Reserved.
*
* B2 Created By Michel V - http://www.cafelog.com/
*
* You may modify this file to suit your owns needs, but please keep the copyright intact. Thanks
* Any problems, email me @ [email protected] or post it in the B2 forums @ http://tidakada.com/board/
*/

// Start Connect To MYSQL
require("b2config.php");
include("$b2inc/b2vars.php");
include("$b2inc/b2functions.php");

dbconnect();

/** Get Total Number of posts
** Params: None
** Returns: number of posts
*/
function stats_get_totalposts() {
global $tableposts;
$sql = "SELECT COUNT(ID) FROM $tableposts";
$result = mysql_query($sql) or die(mysql_error());
return mysql_result($result, 0);
}

/** Get Total Number of comments
** Params: None
** Returns: number of comments
*/
function stats_get_totalcomments() {
global $tablecomments;
$sql = "SELECT COUNT(DISTINCT comment_ID) FROM $tablecomments";
$result = mysql_query($sql) or die(mysql_error());
return mysql_result($result, 0);
}

/** Get Total Number of unique (by comment_author) commenters
** It excludes trackbacks and pingback
** Params: None
** Returns: number of commenters
*/
function stats_get_totalcommentposters() {
global $tablecomments;
$sql = "SELECT COUNT(DISTINCT comment_author) FROM $tablecomments" .
" WHERE substring(comment_content,1,12) <> '" .mysql_escape_string('<pingback />')."' " .
" AND substring(comment_content,1,13) <> '" . mysql_escape_string('<trackback />')."' " ;
$result = mysql_query($sql) or die(mysql_error());
return mysql_result($result, 0);
}

/** Get n latest posts
** outputs the results directly into the page it's called from.
** Params: num (default 5) - Number of posts to get
** before (default '') - text/html to output before each item
** after (default "<br />\n") - text/html to output after each item
*/
function stats_get_lastestposts($num = 5, $before='', $after="<br />\n") {
global $siteurl, $blogfilename, $tableposts;
$sql = "SELECT ID, post_title FROM $tableposts ORDER BY post_date DESC LIMIT $num";
$result = mysql_query($sql) or die(mysql_error());
while ($row = mysql_fetch_row($result)) {
echo $before."<a href=\"$siteurl/$blogfilename?p=$row[0]\">$row[1]</a>".$after;
}
}

/** Get n latest comments
** outputs the results directly into the page it's called from.
** It excludes trackbacks and pingback
** Params: num (default 5) - Number of comments to get
** before (default '') - text/html to output before each item
** after (default "<br />\n") - text/html to output after each item
*/
function stats_get_lastestcomments($num = 5, $before='', $after="<br />\n") {
global $siteurl, $blogfilename, $tableposts, $tablecomments;
$sql =
"SELECT ID, post_title, comment_author, comment_date " .
" FROM $tableposts LEFT JOIN $tablecomments ON $tableposts.ID=$tablecomments.comment_post_ID " .
" WHERE substring(comment_content,1,12) <> '" .mysql_escape_string('<pingback />')."' " .
" AND substring(comment_content,1,13) <> '" . mysql_escape_string('<trackback />')."' " .
" ORDER BY $tablecomments.comment_date DESC LIMIT $num";
$result = mysql_query($sql) or die(mysql_error());
while ($row = mysql_fetch_row($result)) {
echo $before." $row[3] - $row[2] (<a href=\"$siteurl/$blogfilename?p=$row[0]\">$row[1]</a>)".$after;
}
}

/** Get n most commented posts
** outputs the results directly into the page it's called from.
** It excludes trackbacks and pingback
** Params: num (default 5) - Number of posts to get
** before (default '') - text/html to output before each item
** after (default "<br />\n") - text/html to output after each item
*/
function stats_get_mostcommented($num = 5, $before='', $after="<br />\n") {
global $siteurl, $blogfilename, $tableposts, $tablecomments;
$sql =
"SELECT ID, post_title, COUNT($tablecomments.comment_post_ID) AS 'commentstotal' " .
" FROM $tableposts LEFT JOIN $tablecomments ON $tableposts.ID=$tablecomments.comment_post_ID " .
" WHERE substring(comment_content,1,12) <> '" .mysql_escape_string('<pingback />')."' " .
" AND substring(comment_content,1,13) <> '" . mysql_escape_string('<trackback />')."' " .
" GROUP BY $tablecomments.comment_post_ID ORDER BY commentstotal DESC LIMIT $num";
$result = mysql_query($sql) or die(mysql_error());
while ($row = mysql_fetch_row($result)) {
echo $before."<a href=\"$siteurl/$blogfilename?p=$row[0]\">$row[1]</a> ($row[2] Comments)".$after;
}
}

/** Get n most prolific commenters
** outputs the results directly into the page it's called from.
** It excludes trackbacks and pingback
** Params: num (default -1) - Number of commenters to get. -1 means get all of them
** include_pos (default true) - whether to include position
** author_link (default true) - whether to make the author's name into a link back to this page
** before (default '') - text/html to output before each item
** middle1 (default ' - ') - text/html to output after position before comment_author
** (only used if include_position is true
** middle2 (default ' - ') - text/html to output after comment_author before total
** after (default "<br />\n") - text/html to output after each item
*/
function stats_get_membercommentstats($num = -1, $include_pos=true, $author_link=true, $before='', $middle1=' - ',
$middle2=' - ', $after="<br />\n") {

global $siteurl, $blogfilename, $tableposts, $tablecomments;

$sql =
"SELECT comment_author, COUNT(*) AS 'total' FROM $tablecomments " .
" WHERE substring(comment_content,1,12) <> '" .mysql_escape_string('<pingback />')."' " .
" AND substring(comment_content,1,13) <> '" . mysql_escape_string('<trackback />')."' " .
" GROUP BY comment_author ORDER BY total DESC";
if (($num != -1) && ($num > 0)) {
$sql .= " LIMIT $num";
}
$result = mysql_query($sql) or die(mysql_error()."<br/>\n".$sql);
$i = 1;
while ($row = mysql_fetch_row($result)) {
echo $before;
if ($include_pos) {
echo $i. $middle1;
}
if ($author_link) {
echo "<a href=\"$siteurl/b2stats.php?user=".$row[0]."\">";
}
echo $row[0];
if ($author_link) {
echo '</a>';
}
echo $middle2; // holds the name
echo $row[1].$after; // holds the number of comments
$i++;
}
}

/** Get category stats
** outputs the results directly into the page it's called from.
** Params: order (default 'T') - Order results by reverse total (most first).
** Other values, 'A' alphabetical, and 'N' category_id order
** before (default '') - text/html to output before each item
** between (default ' - ') - text/html to output after category name before total
** after (default "<br />\n") - text/html to output after each item
*/
function stats_get_categorystats($order='T', $before='', $between=' - ', $after="<br />\n") {
global $siteurl, $blogfilename, $tableposts, $tablecategories;
$sql =
"SELECT cat_name , COUNT(*) AS 'total' " .
" FROM $tableposts LEFT JOIN $tablecategories ON $tableposts.post_category = $tablecategories.cat_ID " .
" GROUP BY $tableposts.post_category ";
if ($order == 'T') {
$sql .= " ORDER BY total DESC";
}
else if ($order == 'A') {
$sql .= " ORDER BY $tablecategories.cat_name ASC";
}
else if ($order == 'N') {
$sql .= " ORDER BY $tablecategories.cat_ID ASC";
}

$result = mysql_query($sql) or die(mysql_error()."<br/>\n".$sql);
while ($row = mysql_fetch_row($result)) {
echo $before.$row[0].$between.$row[1].$after;
}
}


// Check $user isset
if(!isset($user) || $user == "") {

// Output General Stats
echo "<table width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\">\n";
echo "<tr>\n";
echo "<td>\n";
echo "<b>* Generals Stats</b><br>\n";
echo "<b>".stats_get_totalposts()."</b> Posts<br>\n";
echo "<b>".stats_get_totalcomments()."</b> Comments<br>\n";
echo "<b>".stats_get_totalcommentposters()."</b> Different Nicks Were Represented In The Comments\n";
echo "<br><br>";
echo "<b>\n";
echo "</td>\n</tr>\n</table><br><br>";


// Latest 5 Blog Entries
echo "<table width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\">\n";
echo "<tr>\n<td>\n";
echo "<b>* Latest 5 Blog Entries</b><br>\n";
stats_get_lastestposts(5, '<b>+</b> ', "<br />\n");
echo "</td>\n</tr>\n</table><br><br>";

// Latest 5 Comments
echo "<table width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\">\n";
echo "<tr>\n<td>\n";
echo "<b>* Latest 5 Comments</b><br>\n";
stats_get_lastestcomments(5, '<b>+</b> ', "<br />\n");
echo "</td>\n</tr>\n</table><br><br>";

// Top 5 Most Commented Blog
echo "<table width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\">\n";
echo "<tr>\n<td>\n";
echo "<b>* 5 Most Commented Blogs</b><br>\n";
stats_get_mostcommented(5, '<b>+</b> ', "<br />\n");
echo "</td>\n</tr>\n</table><br><br>";

// Comments' Members Stats
echo "<b>* Comments' Members Stats</b><br>\n";
echo "<table border=\"1\" width=\"20%\" cellspacing=\"2\" cellpadding=\"0\">\n";
echo "<tr>\n";
echo "<th>No.</th>\n";
echo "<th>Members' Nickname</th>\n";
echo "<th>Members' Posts</th>\n";
echo "</tr>\n";
stats_get_membercommentstats(-1, true, true, "<tr>\n<td>", "</td>\n<td>", "</td>\n<td>", "</td>\n</tr>\n");
echo "</table>\n";
echo "</td>\n</tr>\n</table><br><br>";


// Categories Stats
echo "<b>* Categories Stats</b><br>";
echo "<table border=\"1\" width=\"20%\" cellspacing=\"2\" cellpadding=\"0\">\n";
echo "<tr>";
echo "<th>Category Name</th>";
echo "<th>Posts In Category</th>";
echo "</tr>";
stats_get_categorystats('T', "<tr>\n<td>", "</td>\n<td>", "</td>\n</tr>\n");
echo "</table>\n";

}
else {
// ------------ If $user set ------------ //

// SNIP... Same as previous version

} // end else user set
?>[/php:1:104564d9ed]

Hope this is useful to someone.

Mike

[mikelittle]

I've now got this updated version live on my site.
Having the functions split into a seperate file has made it easy to incroprate just the statistics I want within my standard templates.

See Journalized statistics

Mike

[GamerZ]

nice one
_________________

++ GamerZ.Per.Sg - Complex Simplicity

[Gadget Girl]

Gamerz, thank you for the wonderful hack.

I have done 2 of them, one on my blog with a partial stat output, last 5 comments, last 5 posts, last 5 most commented on. You can see that here if you are interested: www.simplysara.com/blog/ click under the blog stats, on the sidebar. I have also done a full version here: www.simplysara.com/blog/b2stats.php

I would love to have the categories that are listed, linked, is there a way to do this? Thanks in advance!

You are making me learn, isn't that a cool thing?

Sara

[GamerZ]

[Gadget Girl]

Hi,

I tried that, gave me an error on line 118. Oh well, thanks for the great stats!

Sara

[mikelittle]

Good one Gamerz,
I've added the category-name-as-link to my version.

I'm not going to post it here, but are you interested in incorporating my changed version (split into functions) into yours?

Let me know and I'll send you the file.

Mike

[GamerZ]

[GamerZ]