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

    Indio RSS

    September 29, 2011

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

    YouTube Preview Image

    July 19, 2010

    Phish: 10/31/2009 Sweet Black Angel [VQ: B-, AQ: B]

    YouTube Preview Image

    May 25, 2010

    Indio: No Phish Fest at Empire Polo Club [Desert Sun]

    Despite statements to the contrary by Phish phans, Goldenvoice says there won’t be a Phish festival this October at the Empire Polo Club.

    Promoter Paul Tollett said he won’t produce any more festivals in Indio in 2010. Polo club owner Alex Haagen III is still talking about having a fall jazz, blues and rock ‘n’ roll festival and says he may hire another promoter. But he said, “We don’t have anything lined up yet.”

    March 8, 2010

    Phish: 10/31/2009 Complete Exile On Main Street Set Playlist [VQ: A-, AQ: A-]

    http://www.youtube.com/view_play_list?p=69FB8F9757E87CEC

    Phish: 11/01/2009 Entire Acoustic Set Playlist [VQ: A-, AQ: A-]

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

    February 8, 2010

    Phish: Halloween Phish in The Desert [Festival 8 Montage]

    January 13, 2010

    Video: Festival 8 Acoustic Set [VQ: A+, AQ: A+]

    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

    November 30, 2009

    Phish: 10/31/2009 Stop Breaking Down [VQ: B-, AQ: A]

    YouTube Preview Image

    November 26, 2009

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

    YouTube Preview Image

    November 21, 2009

    Phish: Festival 8 Time-Lapse Photography Video [VQ: A, AQ: A, Must-See]

    November 20, 2009

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

    YouTube Preview Image YouTube Preview Image

    November 15, 2009

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

    YouTube Preview Image

    November 11, 2009

    Phish: 10/30/2009 Character Zero [VQ: B+, AQ: A-]

    YouTube Preview Image

    Festival 8: Indio in Pics [Brooklyn Vegan]

    November 10, 2009

    Phish: 10/30/2009 Piper [VQ: A-, AQ: A]

    YouTube Preview Image

    Phish: 10/31/2009 YEM Spook [VQ: B+, AQ: B+]

    YouTube Preview Image

    November 9, 2009

    Phish: 81 Great Videos From Festival 8 [VQ: B+, AQ: B+]

    Phish: 11/01/2009 Slave to the Traffic Light [VQ: A-, AQ: A]

    YouTube Preview Image

    November 5, 2009

    Phish: Exile on Main Street Playlist [VQ: B, AQ: B]

    Phish: 10/31/2009 Suzy Greenberg [VQ: A-, AQ: B+]

    YouTube Preview Image

    Phish: 11/01/2009 The Curtain With [VQ: A-, AQ: A]

    YouTube Preview Image YouTube Preview Image

    Phish: Festival 8 Audio

    FOB Schoeps

    FOB Neumann KM140

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

    YouTube Preview Image

    November 4, 2009

    Phish: 10/31/2009 Torn and Frayed [VQ: B-, AQ: B+]

    YouTube Preview Image

    Phish: 10/31/2009 Sign Language to Fluffhead

    YouTube Preview Image

    Phish: 11/01/2009 Sugar Shack [VQ: B+, AQ: B+]

    YouTube Preview Image

    Phish: 11/01/2009 Sleep Again [VQ: B-, AQ: B]

    YouTube Preview Image

    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 Heavy Things [VQ: B+, AQ: B+]

    YouTube Preview Image

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

    YouTube Preview Image

    Phish: 11/01/2009 The Wedge [VQ: B+, AQ: B+]

    YouTube Preview Image

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

    YouTube Preview Image

    Phish: 10/31/2009 Sweet Virginia [VQ: A-, AQ: B+]

    YouTube Preview Image

    Phish: 10/31/2009 Rocks Off, Rip This Joint [VQ: B-, AQ: B+]

    YouTube Preview Image

    Phish: 10/31/2009 Casino Boogie [VQ: B, AQ: B+]

    YouTube Preview Image

    Phish: 10/31/2009 Tumbling Dice [VQ: B, AQ: B+]

    YouTube Preview Image

    Phish: 10/31/2009 Sweet Virginia [VQ: B, AQ: B+]

    YouTube Preview Image

    Phish: 10/31/2009 Happy [VQ: B, AQ: B+]

    YouTube Preview Image

    Phish: Festival 8 Montage

    YouTube Preview Image

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

    YouTube Preview Image

    November 2, 2009

    Festival 8: Phish @ Festival 8 Coverage Summary [Hidden Track]

    Festival 8: The Setlists From All Eight Phish Festival 8 Sets [Hidden Track]

    Phish: 10/31/2009 Most of the Acoustic Set [VQ: B, AQ: B+]

    Phish: 11/01/2009 LivePhish SBD Indio, CA

    Phish: 10/31/2009 Shake Your Hips [VQ: B, AQ: B+]

    YouTube Preview Image

    Phish: 10/31/2009 Loving Cup [VQ: A-, AQ: B+]

    YouTube Preview Image

    Phish: 10/31/2009 Suzy Greenberg [VQ: B-, AQ: B+]

    YouTube Preview Image

    Phish: 10/31/2009 Turd On The Run [VQ: B+, AQ: B+]

    YouTube Preview Image

    Phish: 11/01/2009 Schoeps CCM4v’s Indio, CA

    Phish: 10/31/2009 Loving Cup [VQ: B-, AQ: B-]

    YouTube Preview Image

    Phish: 10/31/2009 Shine A Light [VQ: B, AQ: B+]

    YouTube Preview Image

    Phish: 10/31/2009 Soul Survivor [VQ: B, AQ: B+]

    YouTube Preview Image

    Phish: 10/31/2009 Loving Cup [VQ: B, AQ: B]

    YouTube Preview Image

    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.

    November 1, 2009

    Festival 8: Night Two Setlist [Hidden Track]

    Phish: 10/30/2009 Moma Dance [VQ: B-, AQ: B]

    YouTube Preview Image

    Phish: 10/30/2009 I Didn’t Know [VQ: B, AQ: B+]

    YouTube Preview Image