Plugin Name: Brian's Latest Comments
Plugin URI: http://meidell.dk/archives/category/wordpress/latest-comments/
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 Michael Heilemann. If you have Dunstan's Time Since 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/
Version 1.5: Now works without LOCK TABLE and CREATE TEMPORARY TABLE priviledges.
Version 1.5.1: Can't remember what I did here
Version 1.5.2: Fixed count select statement to not include spammy comments
Version 1.5.3: Properly excludes track- and pingbacks
Version 1.5.4: Excludes posts that are not published, even if they have comments
Version 1.5.5: Fade old comments, fixed bug that wreaked havoc with Time Since
Version 1.5.6: Bugfix from Jonas Rabbe (http://www.jonas.rabbe.com/) pertaining to timesince
Version 1.5.7: Bugfix so old colors can be darker than new colors (stupid oversight), thanks to http://spiri.dk for spotting it.
Bugfix where single digit hex would cause invalid colors, thanks to http://www.wereldkeuken.be/ for the fix.
Version 1.5.8: Updated to work with WordPress 2.1 alpha by M. Heilemann.
function blc_latest_comments($num_posts = 5, $num_comments = 6, $hide_pingbacks_and_trackbacks = true, $prefix = "
", $postfix = "
", $fade_old = true, $range_in_days = 10, $new_col = "#444444", $old_col = "#cccccc")
function clamp($min, $max, $val)
$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.
$ping = "";
$ping = "AND comment_type<>'pingback' AND comment_type<>'trackback'";
$posts = $wpdb->get_results("SELECT
FROM ($wpdb->comments LEFT JOIN $wpdb->posts ON (comment_post_ID = ID))
WHERE comment_approved = '1'
ORDER BY comment_date DESC;");
$seen = array();
$num = 0;
$max_time = $range_in_days * 24 * 60 * 60 ;
$r_new = hexdec(substr($new_col, 1, 2));
$r_old = hexdec(substr($old_col, 1, 2));
//$r_min = min($min, $max);
//$r_max = max($min, $max);
$r_range = ($r_old-$r_new);
$g_new = hexdec(substr($new_col, 3, 2));
$g_old = hexdec(substr($old_col, 3, 2));
//$g_min = min($min, $max);
//$g_max = max($min, $max);
$g_range = ($g_old-$g_new);
$b_new = hexdec(substr($new_col, 5, 2));
$b_old = hexdec(substr($old_col, 5, 2));
//$b_min = min($min, $max);
//$b_max = max($min, $max);
$b_range = ($b_old-$b_new);
// print "ranges: $r_range, $g_range, $b_range ";
// print "r: ".(0.5*$r_range+$r_new)." ";
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.
$seen[$post->comment_post_ID] = true;
if($num++ > $num_posts)
$commenters = $wpdb->get_results("SELECT *, UNIX_TIMESTAMP(comment_date) AS unixdate FROM $wpdb->comments
WHERE comment_approved = '1'
AND comment_post_ID = '".$post->comment_post_ID."'
ORDER BY comment_date DESC
$count = $wpdb->get_var("SELECT COUNT(comment_ID) AS c FROM $wpdb->comments WHERE comment_post_ID = $post->comment_post_ID AND comment_approved = '1' ".$ping);
$i = 0;
$link = get_permalink($post->comment_post_ID);
$title = " title=\"Last comment was ".time_since($comment->unixdate)." ago\"";
$title = "";
echo $prefix."".stripslashes($post->post_title). "".$count." \n";
foreach($commenters as $commenter)
$title = " title=\"Posted ".time_since($commenter->unixdate)." ago\"";
$diff = time() - $commenter->unixdate;
$r = round($diff/$max_time*($r_range))+$r_new;
$r = clamp(min($r_new, $r_old), max($r_new, $r_old), $r);
$g = round($diff/$max_time*($g_range))+$g_new;
$g = clamp(min($g_new, $g_old), max($g_new, $g_old), $g);
$b = round($diff/$max_time*($b_range))+$b_new;
$b = clamp(min($b_new, $b_old), max($b_new, $b_old), $b);
$r_hex = str_pad(dechex($r), 2, '0', STR_PAD_LEFT);
$g_hex = str_pad(dechex($g), 2, '0', STR_PAD_LEFT);
$b_hex = str_pad(dechex($r), 2, '0', STR_PAD_LEFT);
$colstr = " style=\"color: #".$r_hex.$g_hex.$b_hex.";\"";
if($i++ > 0)
echo ", ";
if($count > $num_comments)
echo " [...]";
Burlington | YEMblog
Phish bassist Mike Gordon has been making the most of his time off from touring by sitting in with jam stalwarts the Spin Doctors, Jackie Greene and now old pal Marco Benevento within the past few weeks in his hometown of Burlington. Marco, along with bassist Dave Dreiwitz and drummer Andy Borger, is smack dab in the middle of a four-week residency at Burlington’s Radio Bean coffeehouse and invited Cactus out for the start of the second set. Gordon replaced Dreiwitz for a jazzy version of Green Onions (Booker T. and the MGs) and Benevento’s intense cover of Deerhoof’s Twin Killers that included teases of Rhapsody In Blue and Bathtub Gin.
Trey, normally a loquacious fellow, didn’t speak a whole lot during the show, but did note that he, Markellis and drummer Russ Lawton played the second-ever show at Higher Ground, in the old Winooski location 13 years ago. ”Our next song will be a 13-year-long jam,” Trey said, and the crowd cheered. Instead, he and the band launched into what he called a “world premiere,” a tune called “Snake Head Thumb,” which began with a bluesy guitar intro befitting a song with a name like that and the esoteric lyric “There’s a man I know with a snake head thumb/Just walk by and your body goes numb.”
Trey Anastasio has added two solo shows to his forthcoming fall tourincluding a Vermont Flood Recovery benefit. On October 1, Trey’s seven-piece will return to the Higher Ground in South Burlington, Vermont for a show in which proceeds will go towards The Waterwheel Foundation and The Vermont Community Foundation. Also, TAB will make their Baltimore debut on October 8 at Ram’s Head Live in the Inner Harbor.
This tape belongs in an Archive. In this era of TS->InterWebstreaming and immediate MP3 post-show downloading, this tape is an historical artifact in the history of recorded live music. It is also one of those recordings that somehow managed to escape the tape collections of many of the most obsessive-compulsive Phish tape collectors in history. Of course, its failure to circulate widely in the previous 26 years may have resulted from its quality. (I’d have probably given it a “C-/D+” on my last tapelist, circa 2000.)
Charlie Dirksen has helped unearth a rare soundboard from Phish’s penultimate show at The Front in Burlington. While Dirksen notes tape hiss and muddiness on this source, the rare addition of harmonica to YEM and crude version of BBFCFM makes it well worth a listen. – ScottyB
Page McConnell- Keyboards
Dave Grippo – Alto Sax
Sean Hartman – Bass
Jeff Salisbury – Drums
Screamin’ Dean – Harp
George Abele and Steven Kemp – Percussion
Joseph Somerville Jr. – Trumpet
Zaphed Beeble Brox – Tenor Sax
TaperWayne unleashes the latest uncirculated gem he’s transferred to the digital realm. While it’s listed as a soundboard, the engineer did seem to be testing equipment as he screws with the settings frequently. Regardless, this rare recording provides an interesting listen. – ScottyB
Phish opened their ’94 Spring Tour with a special show at the Flynn in Burlington that featured a version of the Giant Country Horns. This torrent features a SBD recording of the second set of that show – ScottyB
-Prior to Letter to Jimmy Page, Trey announced that per “Del’s” request, they were going to play Letter to Jimmy Page as a band, and then Fish would play it by himself (telling the crowd that Fish didn’t know it)
-YEM was dedicated to Del
-This show included the first known Phish performance of St. Thomas.
-La Grange was dedicated to Mike.
-Note that Trey refers to Tela as a debut at this show, though it actually debuted on 3/12/88.
-Note the jam in this Tela sounds an aweful lot like Split Open and Melt.
-Big Leg Emma was played for the first time since May 3, 1985 (100 shows).
– Source info is questionable. This is what was on the DAT.
– The show is riddled with cuts. I crossfaded most all of them. Some were left as-is.
– Set 3 is loaded with digital errors. I ran a couple of de-click and de-crackle plugins to lessen the harshness of the errors. This is by no means perfect, but here it is at long last.
This appears to have circulated online in low gen in the past, but without the Fee. I have no idea why. This is the complete show, and since it is nearly the 20th anniversary of the show, it is about time it gets circulated online in complete form.
The online Spreadsheet doesn’t have this show complete yet, though presumably it will use this version soon. I don’t believe that a higher quality (overall) version of this show circulates, but there are a few cuts and flaws here and there, like at the beginnings of Gin, Oh Kee Pa and In A Hole. There is also a cut after Divided and a fade out in the transition between Fee and Possum because of the tape flips. I could have cut this fade out, but I didn’t want to upset the “integrity” of the original copy, which kinda seems silly upon reflection. But whatever.