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") { global $wpdb; function clamp($min, $max, $val) { return max($min,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. if(!$hide_pingbacks_and_trackbacks) $ping = ""; else $ping = "AND comment_type<>'pingback' AND comment_type<>'trackback'"; $posts = $wpdb->get_results("SELECT comment_post_ID, post_title FROM ($wpdb->comments LEFT JOIN $wpdb->posts ON (comment_post_ID = ID)) WHERE comment_approved = '1' AND $wpdb->posts.post_status='publish' $ping ORDER BY comment_date DESC;"); $seen = array(); $num = 0; if($fade_old) { $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. 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 *, UNIX_TIMESTAMP(comment_date) AS unixdate FROM $wpdb->comments WHERE comment_approved = '1' AND comment_post_ID = '".$post->comment_post_ID."' $ping ORDER BY comment_date DESC LIMIT $num_comments;"); $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); if($usetimesince) $title = " title=\"Last comment was ".time_since($comment->unixdate)." ago\""; else $title = ""; echo $prefix."".stripslashes($post->post_title). "  ".$count."
    \n"; foreach($commenters as $commenter) { if($usetimesince) $title = " title=\"Posted ".time_since($commenter->unixdate)." ago\""; if($fade_old) { $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 ", "; echo "comment_ID."\"$title>".stripslashes($commenter->comment_author).""; } if($count > $num_comments) echo " [...]"; echo "".$postfix."\n"; } } ?> TV | YEMblog

    TV RSS

    January 17, 2012

    Phish: 05/23/2000 Entire Set 1 [VQ: A+, AQ: A+, Pro-Shot]

    YouTube Preview Image

    Set 1
    01. AC/DC Bag
    02. Wilson
    03. First Tube
    04. Ya Mar —
    05. Ya Mar Jam–
    06. Mike’s Song —
    07. Simple —
    08. It’s Ice
    09. When The Circus Comes To Town
    10. Back On The Train
    11. Gotta Jibboo
    12. Taste
    13. Sleeping Monkey

    June 7, 2011

    Phish: 07/01/1995 Bouncin’ [VQ: A, AQ: A, Pro-Shot, TV]

    YouTube Preview Image

    This was broadcast on ABC’s In Concert

    February 13, 2011

    Cactus: Mike Gordon Band on Jimmy Fallon – Horizon Line

    February 10, 2011

    Phish: 10/03/1998 Farm Aid Entire Show Playlist [VQ: A+, AQ: A, TV]

    http://www.youtube.com/view_play_list?p=D23EF5953E582932

    Birds of a Feather, Farmhouse, Moma Dance, Runaway Jim, Arc, Down By The River, All Star Finale

    November 29, 2010

    Phish: 05/23/2000 Hard Rock Live Playlist [VQ: A, AQ: A+, TV]

    http://www.youtube.com/view_play_list?p=2E10ACA7A3C94BBC

    AC/DC Bag, Wilson, First Tube, Ya Mar, Mike’s, Simple, It’s Ice, When The Circus Comes, Back On The Train, Gotta Jibboo, Taste, Sleeping Monkey, Punch You In The Eye, Twist, Waste, Piper, You Enjoy Myself, Run Like An Antelope, Train Song, Bug, Boogie On -> Cavern

    October 21, 2010

    TV:  Trey/Phish Reference on NBC’s The Office [OKP Blog]

    October 6, 2010

    Phish: 06/22/1997 Entire Show Playlist [VQ: A, AQ: A+, TV]

    http://www.youtube.com/view_play_list?p=E5CD8737D97836B6

    June 21, 2010

    Phish: 10/20/1998 Sessions at West 54th Playlist [VQ: A-, AQ: A, TV]

    http://www.youtube.com/view_play_list?p=96D20F63105D8F24

    June 16, 2010

    Phish: 06/11/2000 Back On The Train [VQ: A, AQ: A, TV]

    YouTube Preview Image

    June 11, 2010

    Phish: 06/11/2000 Farmhouse [VQ: A-, AQ: A-, TV]

    YouTube Preview Image

    Phish: 06/11/2000 Bug [VQ: A-, AQ: A-, TV]

    YouTube Preview Image

    June 10, 2010

    Phish: 06/09/2010 Kill Devil Falls – Jimmy Fallon [VQ: A, AQ: A, TV]

    YouTube Preview Image

    May 15, 2010

    Live at Fallon: Dear Diary – Phish RAWKED Jimmy Fallon [NYCJamGal]

    What the home TV audience didn’t see and we were privy to, was the extra song, “Kill Devil Falls.” After a quick onstage discussion with the stage manager Fallon announced that he would be right back after changing his suit and tie. The crowd was obviously stoked that another song was on the way.

    May 14, 2010

    TV: Phish Returns to Late Night With Loving Cup [Hidden Track]

    Phish: 05/13/2010 Loving Cup [Late Night With Jimmy Fallon]

    April 27, 2010

    Phish: Back On The Train on Conan [VQ: A+, AQ: A+, TV]

    YouTube Preview Image

    April 26, 2010

    Phish: 06/22/1997 Dirt [VQ: A, AQ: A, TV]

    YouTube Preview Image

    April 22, 2010

    Phish: 06/21/2004 Scents and Subtle Sounds [VQ: B+, AQ: A-, TV]

    YouTube Preview Image

    March 9, 2010

    TV: Vampire Weekend Drummer Rocks Phish T on SNL [700 Level]

    March 3, 2010

    Interviews: Trey on Sound Off With Matt Pinfield [Pro, TV]

    YouTube Preview Image YouTube Preview Image YouTube Preview Image

    February 12, 2010

    Phish: Down With Disease – Beavis and Butthead [TV]

    YouTube Preview Image

    January 29, 2010

    TV: Lost Season 6 Preview – Phish Style [Hidden Track]

    Jack – Fluffhead

    “He’s sure got some powerful pills, oh yeah.”

    Certainly, we all expect a big heroic ending from Jack in the final episode akin to the climax from Fluffhead, whereby he saves the Losties and squares off against the Others. But in our mind, Jack’s finest hour came as Future Jack when melted down, grew a playoff beard, and got hooked on Brett Favres.

    November 25, 2009

    Phish: Austin City Limits Possum

    YouTube Preview Image

    November 24, 2009

    Phish: Austin City Limits Twist [TV]

    YouTube Preview Image

    November 21, 2009

    Phish: Austin City Limits When The Circus Comes [VQ: A, AQ: A, TV]

    YouTube Preview Image