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

    Soundcheck RSS

    July 25, 2011

    Watkins Glen: Soundcheck Jam at Watkins Glen [Dog Gone Blog]

    Channeling the energy from the Dead’s soundcheck “jam,” Phish patiently brought us into their world showing that nothing is missing from the band in this day and age. No lack of drugs, no lack of intent, no lack of ideas. Comparable to previous festival soundchecks, albeit different, this was a section of music that—and I hate to call it this—was purely 3.0.

    June 30, 2011

    Watkins Glen: Phish Super Ball IX Soundcheck Setlist and Recap [Hidden Track]

    June 21, 2011

    Phish: 06/18/2011 Raleigh Soundcheck and Peaches Videos

    June 20, 2011

    Phish: 06/17/2011 Charlotte Soundcheck Clips

    November 19, 2010

    Contests: Want to Attend Mike Gordon’s Soundcheck? [MG Facebook]

    October 8, 2010

    Phish: 10/07/2010 Burn That Bridge Soundcheck [VQ: N/A, AQ: B]

    YouTube Preview Image

    ACL: Phish Tries Out a New Song at Soundcheck [Jambands]

    September 2, 2010

    Phish: 07/06/1997 Complete Soundcheck [VQ: B+, AQ: B+]

    http://www.youtube.com/view_play_list?p=5BD6A7F262A7F256

    Samson Variation, Oblivious Fool, Beauty of My Dreams, You Shook Me All Night Long, MmmBop, And It Stoned Me, Only Shallow, Day-O

    May 24, 2010

    Phish: 05/23/2000 SBD / MATRIX / SOUNDCHECK New York, NY

    March 15, 2010

    Hall of Fame: Phish Hits Stage For Soundcheck [Fuseblog]

    December 6, 2009

    Phish: 12/05/2009 SOUNDCHECK Old Home Place [VQ: F, AQ: B]

    YouTube Preview Image

    November 26, 2009

    Phish: 10/29/2009 Liquid Time [VQ: B+, AQ: B]

    YouTube Preview Image

    October 30, 2009

    Festival 8: Festival 8 Soundcheck Setlist, Review & Audio [Hidden Track]

    The quartet originally took the stage in the early afternoon for an acoustic soundcheck that included Back On The Train and Let Me Lie that wasn’t broadcast, but around 9:45 The Bunny came alive with the sounds of Phish.

    After starting this “electric soundcheck” with an intense jam the group moved onto a typically funky version of the title track from 2004’s Undermind. Trey picked up on the similarities between Undermind and Mitch Rydell’s Devil With A Blue Dress and the rest of the band followed him for a quick run through the chorus and a half a verse of so.

    July 14, 2009

    Phish: 08/15/1996 DAUD SOUNDCHECK Plattsburgh, NY

    July 1, 2009

    Phish: 08/24/1993 SNDCHK SBD Vancouver, BC

    May 20, 2009

    Phish: 07/15/1993 AUD Soundcheck Weedsport, NY

    March 26, 2009

    Phish: 11/27/1998 SOUNDCHECK SBD Worcester, MA

    December 28, 2008

    Phish: 10/06/1990 SBD Soundcheck Port Chester, NY

    November 29, 2008

    Phish: 11/27/1998 Soundcheck MATRIX Worcester, MA

    November 1, 2008

    Phish: 03/01/1997 Soundcheck SBD Hamburg, GER