**************************************************
Stuff to add to index
(Latest is just a container div to keep it all neat)
**************************************************
<div id="latest">
<?php blc_latest_comments(12, 10, TRUE); ?>
</div>

**************************************************
Stuff to add to your normal wordpress stylesheet
**************************************************
#latest {
	padding-top:5px;
	font: bold 11px/13px Verdana,  sans-serif;
	padding-left:1px;
	padding-right:1px;
	
	
.latcomment {

border-left: solid 0px #ff0000;
border-right: solid 0px #ff0000;
border-top: solid 0px #ff0000;
border-bottom: solid 0px #E8E8E2;
padding:2px;
background-color: #F9F9F7;

}


.activityentry {
	font-weight:bold;
	font-size:12px;
	background-color:#EFEFE9;
	padding:2px;

}

**************************************************
Replacement brianslatestcomments.php follows below (Backup first!!)
(To be honest I can't remember if I did change this much.)
**************************************************

<?
/*
Plugin Name: Brian's Latest Comments
Plugin URI: http://meidell/latestcomments/
Version: 1.5.1
Description: This shows an overview of the recently active articles and the last people to comment on them. Original idea and code fixes contributed by <a href="http://binarybonsai.com">Michael Heilemann</a>.<br />If you have <a href="http://binarybonsai.com/archives/2004/08/17/time-since-plugin/">Dunstan's Time Since</a> installed, this plugin uses it for the title="" attributes on the comments and posts. (For WordPress 1.5)
Author: Brian Meidell
Author URI: http://meidell.dk/blog

Version 1.5: Now works without LOCK TABLE and CREATE TEMPORARY TABLE priviledges.

*/

function blc_latest_comments($num_posts = 5, $num_comments = 6, $hide_pingbacks_and_trackbacks = true, $prefix = "", $postfix = "<br/>")
{
	global $wpdb, $tablecomments, $tableposts;

	$usetimesince = function_exists('time_since'); // Work nicely with Dunstan's Time Since plugin (adapted by Michael Heilemann)

	// This is compensating for the lack of subqueries in mysql 3.x
	// The approach used in previous versions needed the user to
	// have database lock and create tmp table priviledges.
	// This uses more queries and manual DISTINCT code, but it works with just select privs.
	if(!$hide_pingbacks_and_trackbacks)
		$ping = "";
	else
		$ping = "AND comment_type NOT LIKE '%pingback%' AND comment_type NOT LIKE '%trackback%'";
	$posts = $wpdb->get_results("SELECT
		comment_post_ID, post_title
		FROM ($tablecomments LEFT JOIN $tableposts ON (comment_post_ID = ID))
		WHERE comment_approved = '1'
		$ping
		ORDER BY comment_date DESC;");

	$seen = array();
	$num = 0;
	foreach($posts as $post)
	{
		// The following 5 lines is a manual DISTINCT and LIMIT,
		// since mysql 3.x doesn't allow you to control which way a DISTINCT
		// select merges multiple entries.
		if(array_key_exists($post->comment_post_ID, $seen))
			continue;
		$seen[$post->comment_post_ID] = true;
		if($num++ > $num_posts)
			break;

		$commenters = $wpdb->get_results("SELECT * FROM $tablecomments
	       			WHERE comment_approved = '1'
				AND comment_post_ID = '".$post->comment_post_ID."'
				ORDER BY comment_date DESC
				LIMIT $num_comments;");

		$count = $wpdb->get_var("SELECT COUNT(comment_ID) AS c FROM $tablecomments WHERE comment_post_ID = $post->comment_post_ID");
		$i = 0;
		$link = get_permalink($post->comment_post_ID);
		echo $prefix."<div class=\"latcomment\"><div class=\"activityentry\"><a href=\"".$link ."\">".stripslashes($post->post_title). "</a></div>\n<small>";
		if($usetimesince)
			$title = " title=\"Last comment was ".time_since($comment->unixdate)." ago\"";
		foreach($commenters as $commenter)
		{
			if($usetimesince)
				$title = " title=\"Posted ".time_since($commenter->unixdate)." ago\"";

			if($i++ > 0)
				echo ", ";

			echo "<a href=\"".$link . "#comment-" . $commenter->comment_ID."\"$title>".stripslashes($commenter->comment_author)."</a>";
		}
		if($count > $num_comments)
			echo " <a href=\"$link#comments\" title=\"Go to the comments of this entry\">[...]</a>";
		echo "</small><br/>".$postfix."</div>\n";

	}
}

?>