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

    Raleigh RSS

    November 8, 2011

    Phish: 06/18/2011 Run Like An Antelope [VQ: A-, AQ: B]

    YouTube Preview Image

    September 29, 2011

    Phish: 07/22/1997 DAUD New Source Raleigh, NC

    August 11, 2011

    Podcasts: Episode 29 – The Lost Episodes [Type II Cast]

    While everyone was waiting for the first night of Phish’s 2-night webcast from Lake Tahoe, the Type II crew got together to recover some missing territory. It’s been a busy summer and somehow we never got the chance to discuss the last five shows of Leg 1. The sticklers for detail that we are we thought it would be unjust to not at least cover our thoughts and favorite clips from Alpharetta, Charlotte, Raleigh and Portsmouth. Over the hour leading up to Tahoe we discussed our thoughts on webcasts, fan expectations and most of all some amazing musical moments. Here’s to a great tour and we’ll be back to cover the newest shows real soon.

    July 17, 2011

    Reviews: Southern Run 2011 – Charlotte, Raleigh and Portsmouth [I Live Music]

    June 24, 2011

    Phish: 06/18/2011 McNasty Shasta Playlist [VQ: B+, AQ: B+]

    Cars Trucks Buses, Peaches En Regalia, AC/DC Bag, Guyute, Possum, Halley’s Comet, 46 Days, Curtis Loew, Antelope, Been Caught Stealing

    June 21, 2011

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

    Photos: Picture Show – Phish in Raleigh [Hidden Track]

    [Photo by Brad Worsham]

    June 20, 2011

    Drug Arrests: 77 Face Charges from Drugs, Alcohol at Phish Concert [WXII]

    Raleigh: Phish Raleigh Recap [Phish.net]

    June 19, 2011

    Phish: 06/18/2011 Cars Trucks Buses [VQ: A+, AQ: A+, Pro-Shot]

    Raleigh: Phish Raleigh Setlist and The Skinny [Hidden Track]

    Phish: 06/18/2011 LivePhish SBD Raleigh, NC

    Raleigh: No Flow But Good To Go [Phish Thoughts]

    Phish: 06/18/2011 Been Caught Stealing [VQ: B-, AQ: B]

    YouTube Preview Image

    April 9, 2011

    Remembrances: What Happened at Walnut Creek 2003? [OPT]

    December 16, 2010

    Remembrances: Remembering Raleigh [Phish Thoughts]

    November 16, 2010

    Phish: 07/01/2010 Light [VQ: B, AQ: B+, CK5]

    YouTube Preview Image

    September 30, 2010

    Phish: 06/25/2000 Uncle Pen, Bold As Love [VQ: A-, AQ: B+]

    YouTube Preview Image

    September 26, 2010

    Phish: 05/24/1990 SBD Source Upgrade Raleigh, NC

    September 24, 2010

    Phish: 06/25/2000 What’s The Use? [VQ: B+, AQ: B+]

    YouTube Preview Image

    September 23, 2010

    Phish: 06/25/2000 Meat [VQ: B+, AQ: B+]

    YouTube Preview Image

    September 21, 2010

    Phish: 06/25/2000 Gotta Jibboo [VQ: B, AQ: B+]

    YouTube Preview Image

    September 16, 2010

    Phish: 06/25/2000 Heavy Things [VQ: B+, AQ: B+]

    YouTube Preview Image

    September 13, 2010

    Phish: 06/25/2000 Horn [VQ: B, AQ: B]

    YouTube Preview Image

    September 12, 2010

    Phish: 06/25/2000 Funky Bitch [VQ: B-, AQ: B]

    YouTube Preview Image

    September 9, 2010

    Phish: 06/25/2000 Punch You In The Eye [VQ: B+, AQ: B]

    YouTube Preview Image

    July 15, 2010

    Phish: 07/01/2010 Light Up or Leave Me Alone [VQ: A, AQ: A]

    YouTube Preview Image

    Phish: 07/01/2010 Time Loves a Hero [VQ: A, AQ: A]

    YouTube Preview Image

    July 5, 2010

    Reviews: Off and On in Carolina [OnlinePhishTour]

    July 3, 2010

    Phish: 07/01/2010 Assorted Raleigh Videos [VQ: C, AQ: B]


    July 2, 2010

    Phish: 07/01/2010 LivePhish SBD Raleigh, NC

    Raleigh: A Slow Start to the South [Phish Thoughts]

    Phish: 07/01/2010 DAUD Raleigh, NC

    July 1, 2010

    Raleigh: Phish @ Raleigh – Walnut Creek: Setlist & Recap [Hidden Track]

    Last year Phish set a record for most songs performed in one year from their vast repertoire with 248. It looks like the quartet is gunning for 2009’s record as they continue to mine their catalog for new gems to play with at each stop on this tour for a total of 161 tunes thus far in 2010. Tonight’s show at the Time Warner Cable Music Pavilion in Raleigh, NC featured five tour debuts including two covers that hadn’t been performed since 1999.

    March 25, 2010

    Phish: 12/16/1999 Back On The Train [VQ: A-, AQ: B+]

    YouTube Preview Image

    December 16, 2009

    Remembrances: 10 Years Ago – Best Wading and Raleigh Tweezer [Hidden Track]

    Next up was a moment I’ll never forget as Phish started up Wading. We all went nuts as if the band had busted out Destiny Unbound. Big hugs and high-fives were exchanged. Mrs. Read had the biggest smile on her face and was nearly in tears. I’ve never been so excited to see a Wading in my life.

    Phish: 12/16/1999 DAUD Raleigh, NC

    October 11, 2009

    Phish: 08/07/1998 DAUD Raleigh, NC

    September 23, 2009

    Mike Gordon: 09/14/2009 DAUD Raleigh, NC

    August 20, 2009

    Gordon, Russo, Anastasio, Benevento: 06/28/2006 DAUD Raleigh, NC

    August 6, 2009

    Phish: 06/25/2000 DAUD Raleigh, NC

    June 12, 2009

    Phish: 12/16/1999 DAUD Raleigh, NC

    February 18, 2009

    Phish: 12/16/1999 DAUD Raleigh, NC

    January 4, 2009

    Phish: 12/16/1999 DAUD Raleigh, NC

    December 16, 2008

    Remembrances: Twas The Night Before Hampton [Phish Thoughts]

    November 19, 2008

    Phish: 07/22/1997 DAUD Raleigh, NC

    November 3, 2008

    Phish: 05/24/1990 SBD Raleigh, NC