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"; } } ?> Acoustic | YEMblog

    Acoustic RSS

    December 1, 2011

    Trey Anastasio: Trey Solo Acoustic – Video of Entire Set [VQ: A+, AQ: A+, Official]

    October 27, 2011

    Trey Anastasio: 03/02/2011 Acoustic Set [VQ: B-, AQ: B]

    YouTube Preview Image

    September 29, 2011

    Phish: 11/01/2009 Secret Smile [VQ: A, AQ: A+, Multi-CAM]

    YouTube Preview Image

    March 6, 2011

    Trey Anastasio: 03/04/2011 Hilarious Banter > Theme From The Bottom [VQ: A-, AQ: B+]

    YouTube Preview Image

    March 4, 2011

    Trey Anastasio: 03/02/2011 My Friend [VQ: A-, AQ: A-]

    YouTube Preview Image

    March 3, 2011

    Trey Anastasio: 03/01/2011 Wolfman’s Brother [VQ: B, AQ: B+]

    YouTube Preview Image

    March 2, 2011

    Trey Anastasio: 02/27/2011 Gumbo [VQ: B, AQ: B]

    YouTube Preview Image

    Trey Anastasio: 02/27/2011 The Wedge [VQ: B-, AQ: B]

    YouTube Preview Image

    March 1, 2011

    Downloads: Trey Anastasio Acoustic Mix – Stormy Mondays [Hidden Track]

    February 28, 2011

    Trey Anastasio: 02/26/2011 Harry Hood [VQ: B-, AQ: B]

    YouTube Preview Image YouTube Preview Image

    Trey Anastasio: 02/22/2011 Camel Walk [VQ: A, AQ: A+]

    YouTube Preview Image

    Trey Anastasio: 02/27/2011 Stealing Time [VQ: A-, AQ: A-]

    YouTube Preview Image

    February 25, 2011

    Trey Anastasio: 02/20/2011 Shine A Light [VQ: A-, AQ: A-]

    YouTube Preview Image

    Trey Anastasio: 02/20/2011 Lawn Boy [VQ: B+, AQ: A-]

    YouTube Preview Image

    February 23, 2011

    Trey Anastasio: 02/22/2011 Meatstick [VQ: A-, AQ: B+]

    YouTube Preview Image

    Trey Anastasio: 02/20/2011 It’s Ice [VQ: B+, AQ: B+]

    YouTube Preview Image

    February 18, 2011

    Lists: 10 Things You May Not Remember From TAB ’99 Tour [HT]

    6) Bug was a TAB song first

    We’ve been taking a trip down memory lane as we revisited all of the audio from the Trey ’99 tour and one constant I found was that while everyone knows that Sand, First Tube, Gotta Jibboo etc. came from this tour, a lot of people forget that there were two electric performances of Bug in ’99 before it hit the Phish stage. Hear the first one and Trey describing the songwriting experience with Tom.

    January 12, 2011

    Trey Anastasio: Trey Announces Electric/Acoustic Winter Tour [Hidden Track]

    Trey Anastasio announced today a two-week tour opening Friday February 18th at the newly re-opened State Theater in Portland, ME and closing 15 days later on Saturday March 5th at Oakland’s Fox Theater. The band lineup is identical to the band that toured last February and most recently played at the Hangout Festival in May of 2010: Tony Markellis on bass, Russ Lawton on drums and Ray Paczkowski on keyboards as well as a three-piece horn section featuring Jennifer Hartswick, Russ Remington and Natalie Cressman.

    December 12, 2010

    Cactus: Mike Gordon Band – Idea – Live From Studio M [A+]

    November 24, 2010

    Trey Anastasio: 11/18/2010 Stash [VQ: A, AQ: A]

    YouTube Preview Image

    November 22, 2010

    Trey Anastasio: 11/18/2010 Gone [VQ: B, AQ: B+]

    YouTube Preview Image

    Trey Anastasio: 11/18/2010 Brian and Robert [VQ: A-, AQ: A-]

    YouTube Preview Image

    Trey Anastasio: 11/18/2010 Strange Design w/ Tom Marshall [VQ: A, AQ: A]

    YouTube Preview Image

    Trey Anastasio: 11/18/2010 Wolfman’s Brother

    Straight-On Angle [VQ: A-, AQ: A-]

    YouTube Preview Image

    Extreme Trey Close-Up [VQ: A-, AQ: B]

    YouTube Preview Image

    November 19, 2010

    Trey Anastasio: 11/18/2010 Stash [VQ: B+, AQ: B+]

    YouTube Preview Image

    Trey Anastasio: 11/18/2010 Julie [VQ: A-, AQ: B+]

    YouTube Preview Image

    Trey Anastasio: 11/18/2010 Wolfman’s Brother [VQ: A-, AQ: B]

    YouTube Preview Image

    Trey Anastasio: Review – Trey Acoustic in Princeton [OPT]

    Trey Anastasio: 11/18/2010 Let Me Lie [VQ: A-, AQ: B]

    YouTube Preview Image

    Trey Anastasio: 11/18/2010 w/ Tom Marshall – Strange Design [VQ: B-, AQ: B+]

    YouTube Preview Image

    October 25, 2010

    Trey Anastasio: Trey Adds Hometown Acoustic Show [Hidden Track]

    March 1, 2010

    Trey Anastasio: 02/27/2010 Bathtub Gin [VQ: B+, AQ: B]

    YouTube Preview Image

    February 26, 2010

    Trey Anastasio: 02/23/2010 Wilson [VQ: B-, AQ: B-]

    YouTube Preview Image

    Trey Anastasio: 02/23/2010 Kill Devil Falls [VQ: B-, AQ: B]

    YouTube Preview Image

    February 24, 2010

    Trey Anastasio: 02/20/2010 Bathtub Gin [VQ: B-, AQ: B]

    YouTube Preview Image

    Trey Anastasio: 02/18/2010 Stealing Time [VQ: A-, AQ: A-]

    YouTube Preview Image

    February 22, 2010

    Trey Anastasio: 02/19/2010 Driver [VQ: B-, AQ: B-]

    YouTube Preview Image

    Trey Anastasio: 02/19/2010 Brian and Robert [VQ: B, AQ: B-]

    YouTube Preview Image

    Trey Anastasio: 02/16/2010 Strange Design [Multi-CAM]

    YouTube Preview Image

    Trey Anastasio: 02/19/2010 Sample In A Jar [VQ: B+, AQ: B-]

    YouTube Preview Image

    February 20, 2010

    Trey Anastasio: 02/16/2010 Brian and Robert [VQ: B, AQ: B+]

    YouTube Preview Image

    February 19, 2010

    Trey Anastasio: 02/18/2010 Stealing Time (Acoustic)

    YouTube Preview Image

    February 17, 2010

    Trey Anastasio: AHandman’s Terminal 5 Videos [VQ: A, AQ: A-]

    http://www.youtube.com/view_play_list?p=450B628633222EEE

    Magilla, Chalk Dust, Wilson, Sample In A Jar, Strange Design, Brian and Robert, Birdwatcher, Mozambique, Shine

    November 3, 2009

    Phish: 11/01/2009 Talk [VQ: A-, AQ: B+]

    YouTube Preview Image

    Phish: 11/01/2009 Driver [VQ: A-, AQ: B+]

    YouTube Preview Image

    Phish: 11/01/2009 Secret Smile [VQ: A-, AQ: B+]

    YouTube Preview Image

    Phish: 11/01/2009 Let Me Lie [VQ: B, AQ: B]

    YouTube Preview Image

    November 2, 2009

    Festival 8: Review – Phish Acoustic Set @ Festival 8 [Hidden Track]

    The set started with three songs that were staples of Anastasio’s solo acoustic performances -Water In The Sky, Back On The Train and Brian and Robert. Each sounded as if they were written to be played unplugged and early on it was clear the band had spent a considerable amount of time rehearsing. Invisible, a song off Phish bassist’s Mike Gordon Sixty Six Steps release with acoustic guitar legend Leo Kottke, followed with Mike taking the lead vocals as he does on the album.

    October 2, 2008

    Downloads: Trey Acoustic Time Turns Elastic [Coventry]

    September 29, 2008

    Trey Anastasio: 08/03/2008 Webcast Rip Newport, RI