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"; } } ?> 2009 | YEMblog - Page 2

    2009 RSS

    January 2, 2010

    Phish: 12/31/2009 Rock and Roll [VQ: B-, AQ: B]

    YouTube Preview Image

    Phish: 12/31/2009 Schoeps MK41 Miami, FL

    January 1, 2010

    Miami: One Last Phishy Blowout for ’09 [Hidden Track]

    Last night in Miami we reached the conclusion of an important year in the history of Phish. The quartet worked up their skills and dug deep through their repertoire all year long. Quite often the band was successful at satiating their notoriously hard-to-please fanbase while aiming to stay clear of the dreaded “nostalgia act” tag. For the fourth show of four at the American Airlines Arena, Phish didn’t disappoint offering the typical NYE fare of a few hearty jams, plenty of classics, a few bust outs and the “gimmick” which this year revolved around a little known female drummer named Sarah.

    Phish: 12/31/2009 Official Countdown Video

    YouTube Preview Image

    December 31, 2009

    Phish: 12/30/2009 Schoeps MK41 Miami, FL

    Phish: 12/30/2009 LivePhish SBD Miami, FL

    December 30, 2009

    Phish: 12/29/2009 Tweezer [VQ: B-, AQ: B]

    YouTube Preview Image

    Phish: 12/29/2009 Ocelot [VQ: B, AQ: B]

    YouTube Preview Image

    Phish: 12/29/2009 The Connection [VQ: B, AQ: B]

    YouTube Preview Image

    Phish: 12/29/2009 Gotta Jibboo [VQ: B, AQ: B]

    YouTube Preview Image

    Phish: 12/29/2009 Sleeping Monkey, Tweezer Reprise [VQ: B, AQ: B+]

    YouTube Preview Image

    Phish: 12/29/2009 LivePhish SBD Miami, FL

    Phish: 12/29/2009 Wilson [VQ: B+, AQ: B]

    YouTube Preview Image

    Phish: 12/29/2009 Golgi Apparatus [VQ: B, AQ: B-]

    YouTube Preview Image

    Phish: 12/29/2009 Driver [VQ: B, AQ: B-]

    YouTube Preview Image

    Phish: 12/29/2009 Schoeps MK41 Miami, FL

    Phish: 12/28/2009 Makisupa Policeman [VQ: B-, AQ: B]

    YouTube Preview Image

    Phish: 12/28/2009 Roggae [VQ: B, AQ: B+]

    YouTube Preview Image

    Phish: 12/28/2009 Undermind [VQ: B, AQ: B+]

    YouTube Preview Image

    December 29, 2009

    Phish: 12/28/2009 LivePhish SBD Miami, FL

    Phish: 12/28/2009 NICU [VQ: B+, AQ: B+]

    YouTube Preview Image

    Phish: 12/28/2009 Bouncing Around The Room [VQ: B+, AQ: B+]

    YouTube Preview Image

    Phish: 12/28/2009 Schoeps MK41 Miami, FL

    Phish: 12/28/2009 Sample In A Jar [VQ: A-, AQ: B+]

    YouTube Preview Image

    December 22, 2009

    Year in Review: Phish 2009 in Review [Wax Banks]

    Are the members of Phish playing and improvising authentically right now? Do they surrender themselves – their ‘selves’ – for a shot at something like grace? Maybe. I think so. I hope so. I find hoping graceful in its way. And it’s not a plan, which is – after all – kind of the point.

    December 20, 2009

    Phish: 10/31/2009 Ventilator Blues [VQ: A+, AQ: A, 4-cam]

    YouTube Preview Image

    Phish: 10/31/2009 I Just Want to See His Face [VQ: A+, AQ: A, 4-cam]

    YouTube Preview Image

    December 18, 2009

    Phish: 12/03/2009 Punch You In The Eye [VQ: B+, AQ: A]

    YouTube Preview Image

    December 17, 2009

    Phish: 12/03/2009 Punch You In The Eye [VQ: A-, AQ: A]

    YouTube Preview Image

    Phish: 12/03/2009 Down With Disease [VQ: A-, AQ: A]

    YouTube Preview Image YouTube Preview Image

    Phish: 10/31/2009 Torn and Frayed [VQ: A, AQ: A, 4-cam]

    YouTube Preview Image

    December 16, 2009

    Phish: 12/03/2009 Character Zero [VQ: A-, AQ: A]

    YouTube Preview Image

    December 13, 2009

    Phish: 12/04/2009 ENTIRE SHOW PLAYLIST [VQ: A, AQ: A]

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

    Phish: 06/10/2009 David Bowie [VQ: A-, AQ: A]

    YouTube Preview Image

    December 11, 2009

    Phish: 12/04/2009 Reba [VQ: A, AQ: A]

    YouTube Preview Image

    Phish: 12/04/2009 Bouncing Around The Room [VQ: A, AQ: A]

    YouTube Preview Image

    December 10, 2009

    Phish: 12/05/2009 Sneakin’ Sally [VQ: B-, AQ: B+]

    YouTube Preview Image

    December 9, 2009

    Phish: 12/05/2009 AC/DC Bag [VQ: B-, AQ: B]

    YouTube Preview Image

    Phish: 11/27/2009 Golden Age [VQ: B, AQ: A]

    YouTube Preview Image

    December 8, 2009

    Phish: 12/05/2009 The Naked Guy Montage [VQ: A-, AQ: A]

    YouTube Preview Image

    Phish: 11/27/2009 Almost Entire Show Playlist [VQ: B+, AQ: A]

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

    AC/DC Bag, Maze, Driver, My Mind’s Got a Mind of its Own, Gumbo, Bouncing Around the Room > It’s Ice,  Timber (Jerry) > Limb By Limb, Cavern, My Friend, My Friend On Your Way Down, Fluffhead, Tomorrow’s Song, The Squirming Coil, I Been Around

    Phish: 12/04/2009 Wilson [VQ: A, AQ: A]

    YouTube Preview Image

    Phish: 12/04/2009 Glide [VQ: A, AQ: A]

    YouTube Preview Image

    Phish: 2009 Tour Highlights DAUD Pt. 1, Pt. 2

    Phish: 12/04/2009 46 Days [VQ: A, AQ: A]

    YouTube Preview Image

    December 7, 2009

    Fall Tour Stats: The Number Line – One-Timers [Hidden Track]

    Syracuse: 6 (Beauty Of A Broken heart, Drowned, BBFCM, Tube, Theme From The Bottom, GTBT)
    Philly 1: 6 (Bathtub Gin, Camel Walk, The Curtain With, Twenty Years Later, The Mango Song, Simple)
    Philly 2: 7 (Sugar Shack, Sleep Again, Train Song, Birds Of A Feather, Farmhouse, Esther, Oh! Sweet Nuthin’)

    READ ON for the rest of the Fall Tour one-timers list…

    Phish: 12/05/2009 Stealing Time [VQ: B, AQ: B]

    YouTube Preview Image

    Phish: 11/28/2009 Albany II ENTIRE SHOW Playlist [VQ: B+, AQ: A]

    http://www.youtube.com/view_play_list?p=97AB113DDD4DF477

    December 6, 2009

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

    YouTube Preview Image

    Phish: 12/04/2009 Heavy Things [VQ: A-, AQ: A]

    YouTube Preview Image

    MSG: Phish @ MSG Video Playlists [Hidden Track]

    Phish: 12/03/2009 MSG Night Two ENTIRE SHOW Playlist [VQ: B-, AQ: A]

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

    Phish: 12/05/2009 FOB Neumann Charlottesville, VA

    Phish: 12/05/2009 Bold As Love [VQ: B-, AQ: B-]

    YouTube Preview Image

    Phish: 12/05/2009 Ya Mar w/ Naked Guy Running On Stage

    YouTube Preview Image

    Phish: 12/05/2009 LivePhish SBD Charlottesville, VA

    Phish: 12/04/2009 ENTIRE SHOW Playlist [VQ: A, AQ: A]

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

    Phish: 06/06/2009 Fluffhead [VQ: A, AQ: A]

    YouTube Preview Image

    Phish: 12/04/2009 First Tube [VQ: A-, AQ: A, Angle: CK5]

    YouTube Preview Image

    Phish: 11/27/2009 I Been Around [VQ: B, AQ: A]