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

    Fenway Park RSS

    July 28, 2009

    Phish: 05/31/2009 Limb By Limb [VQ: B+, AQ: A]

    YouTube Preview Image

    July 10, 2009

    Fans: Yankee Phish Fan Gets His Due [Bostonist]

    Remember Ian Ferris? This Yankees-loving Vermonter earned a brief moment in the spotlight when he found a way to scatter the seed of the Evil Empire onto the fabled green grass of Fenway Park. While visiting Fenway for the May 31 Phish concert, Ferris’ feat was an effort to playfully plant – literally – a curse in the heart of Red Sox Nation.

    June 30, 2009

    Fenway: The First Moment of Tour [Phish Thoughts]

    June 28, 2009

    Phish: 05/31/2009 The Moma Dance [VQ: A-, AQ: ??]

    YouTube Preview Image

    June 12, 2009

    Reviews: I Phucking Love This Band [MIT’s The Tech]

    In front of me, someone’s taking an early pre-show hit from a marijuana pipe; behind me is third base. I’m shivering in the light drizzle of the 50-degree weather as thousands of people pour into Fenway Park. Everyone’s wondering the same thing: What song will they open with?

    June 9, 2009

    Fenway Park: Yankee Fan Gets Revenge at Fenway [Boston Herald]

    A sneaky Yankees fan, determined to avenge the indignity of a David Ortiz [stats] jersey that was embedded in the concrete at the new Yankee Stadium last year, says he’s engaged in his own subversive act.

    At last week’s Phish show at Fenway Park [map], while other concert-goers snuck in weed, lifelong Yankees fan Ian Ferris claimed he was carrying a commemorative sack of official Yankees grass seed that he threw on hallowed Red Sox [team stats] turf . . . like some kind of Evil Empire Johnny Grass-seed!

    June 8, 2009

    Baseball: Lars Anderson Wishes He Was at the Phish Show [NECN]

    June 6, 2009

    Phish: 05/31/2009 4-ch DAUD Boston, MA

    June 4, 2009

    Reviews: Phish – We’re Back On [Concord Monitor]

    Phish and I were supposed to be through. I said we were done, our relationship was over, and I was moving on. On the pages of this newspaper, I publicly called it quits. In the end I fell, weak to their draw. I tried to resist as long as I could, but Phish raised the bar and announced a show at Fenway Park, and I caved.

    Phish: 05/31/2009 Fenway Montage [VQ: B-, AQ: B-]

    YouTube Preview Image

    June 3, 2009

    Reviews: Phish @ Fenway [Travis & Staci]

    Reviews: Phish Rocks Fenway Park [AikenAction]

    Still, the interaction between performer and audience that makes a Phish show a Phish show were evident. Members of the audience knew every word to every song except for the very newest and sang along enthusiastically. And take, for example, a moment early in the show when the sun came out and a rainbow replaced the rain that had doused the crowd just moments before showtime.

    Phish: 05/31/2009 Neumann 140’s Wantagh, NY

    Phish: 05/31/2009 Stealing Time From The Faulty Plan [Video Quality: B+, Audio Quality: B]

    YouTube Preview Image

    Reviews: Phish @ Fenway Park [The Big Takeover]

    Reviews: There and Back Again Phish @ Fenway [Examiner]

    Phish: 05/31/2009 Stash [Video Quality: C, Audio Quality: C]

    YouTube Preview Image

    June 2, 2009

    Phish: 05/31/2009 Bathtub Gin [Video Quality: B-, Audio Quality: B]

    YouTube Preview Image

    Phish: 05/31/2009 Star Spangled Banner [Video Quality: A, Audio Quality: A]

    YouTube Preview Image

    Phish: 05/31/2009 Character Zero [Video Quality: B, Audio Quality: B]

    YouTube Preview Image

    Phish: 05/31/2009 Time Turns Elastic [Video Quality: B-, Audio Quality: B]

    YouTube Preview Image

    Reviews: Phish’s Phenway Phemenology [Hidden Track]

    Phish: 05/31/2009 Star Spangled Banner [Video Quality: B+, Audio Quality: A]

    YouTube Preview Image

    Reviews: Taking Care of Your Shoes [YNZnNYC]

    Phish: 05/31/2009 Chalk Dust Torture [Video Quality: B-, Audio Quality: A]

    YouTube Preview Image

    Phish: 05/31/2009 Poor Heart [Video Quality: B-, Audio Quality: A]

    YouTube Preview Image

    Phish: 05/31/2009 Stash [Video Quality: B-, Audio Quality: A]

    YouTube Preview Image

    Phish: 05/31/2009 Telefunken Boston, MA

    Phish: 05/31/2009 Destiny Unbound [Video Quality: B, Audio Quality: A]

    YouTube Preview Image

    Phish: 05/31/2009 Tweezer > Light [Video Quality: C+, Audio Quality: B-]

    YouTube Preview Image YouTube Preview Image

    Photos: Jason Bergman of RS’s Fenway Pics [Flickr]

    Phish: 05/31/2009 You Enjoy Myself [Video Quality: A, Audio Quality: A]

    YouTube Preview Image

    Reviews: Reflecting on Fenway [Phish Thoughts]

    Posters: Nate Duval’s Batch of Fenway Posters Onsale [OMG Posters]

    Phish marked their monumental Fenway show with a poster by a brand new artist (for them), Nate Duval.  Nate’s poster is an 18″ x 24″ screenprint with an edition of 1,000.  Nate will only have 50 for sale, the rest sold out at the show with the quickness.  His portion will go up today (Tuesday, June 2nd) at 12pm EST.  Visit Nate’s Etsy Shop.

    Phish: 05/31/2009 YEM Vocal Jam [Video Quality: B+, Audio Quality: A]

    YouTube Preview Image

    Drug Arrests: Police Arrest 12 During Phish Concerts [Boston Globe]

    Phish: 05/31/2009 David Bowie [Video Quality: B-, Audio Quality: B-]

    YouTube Preview Image

    June 1, 2009

    Phish: 05/31/2009 OFFICIAL RECORDING Boston, MA

    Phish: 05/31/2009 AKGc460b Boston, MA

    Photo Gallery: Dave Vann – Phish @ Fenway [Billboard]

    Phish: 05/31/2009 Schoeps MK-4 FLASCHNER Boston, MA

    Phish: 05/31/2009 Schoeps MK-4 Boston, MA

    Reviews: Phish @ Fenway Park [JamBase]

    Fenway Park. Home of Bucky Dent’s ghost, Ted Williams’ .406 average and finally, the place where an 80-plus year World Series-less curse ended. Fenway again saw some great moments Sunday night by a pinch hitter called Phish. Otherwise known as Coran Capshaw’s flipside to a Dave Matthews-laced, Red Light Management filled weekend (Matthews played Fenway Friday and Saturday for the northeastern, prepster masses).

    Reviews: Phish @ Fenway Park [BeatCrave]

    Phish: 05/31/2009 Ocelot [Video Quality: B+, Audio Quality: B+]

    YouTube Preview Image

    Reviews: Phish’s Fenway Destiny [Relix]

    Last night in Boston’s Kenmore Square, Phish delivered its debut performance at Fenway Park, just a few miles from the Paradise Rock Club where the group played one of its most important early gigs outside of Vermont, more than 20 years earlier.

    Phish: 05/31/2009 The Moma Dance [Video Quality: B-, Audio Quality: B+]

    YouTube Preview Image

    Reviews: Phish @ Fenway Park [College News]

    Reviews: Phish Dives Deep Into Catalog [Rolling Stone]

    The evening had something for everyone — from incredibly rare “bust-outs” like “Destiny Unbound,” a song that had only been played live once since 1991, to a scorching cover of Led Zeppelin’s “Good Times, Bad Times” during the encore. The biggest surprise, though, was the band’s first performance of Lynyrd Skynyrd’s “The Ballad of Curtis Loew [sic]” since 1993.

    Phish: 05/31/2009 Chalkdust Torture [Video Quality: B+, Video Quality: B+]

    YouTube Preview Image

    Phish: 05/31/2009 Free [Video Quality: A, Audio Quality: A-]

    YouTube Preview Image

    Reviews: Phish Back In Fine Form at Fenway [Boston Herald]

    Phish: 05/31/2009 Light [Video Quality: B+, Audio Quality: B]

    YouTube Preview Image

    Reviews: Phish Back In the Swim @ Fenway [Boston Globe]

    Phish Returns With Fenway Show [NECN]

    Live Blog: Phish @ Fenway Park [Live Music Blog]

    Drug Arrests: Cops Getting Toker-Ticket Happy @ Phish [Gawker]

    Phish: 05/31/2009  Cavern [Video Quality: C, Audio Quality: B-]

    YouTube Preview Image

    Phish: 05/31/2009 Destiny Unbound [Video Quality: B, Audio Quality: C+]

    YouTube Preview Image

    Reviews: Phish @ Fenway Park [RunawayJim]