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

    2009 RSS

    May 16, 2012

    One Week Only: Watch 85 Minutes Worth of Pro-Shot Footage From Bonnaroo ’09 [Hidden Track]

    March 24, 2012

    Phish: 06/09/2009 Nearly Entire Show [VQ: A, AQ: A, Multi-CAM]

    Set 1 –

    YouTube Preview Image

    Set 2 –

    YouTube Preview Image

    Set 1 : //Kill Devil Falls, The Moma Dance, Sample In A Jar, Stash, Dog Faced Boy, Gumbo, Tube, Lengthwise, The Divided Sky, When The Cactus Is In Bloom #, Bold As Love

    Set 2 : Backwards Down The Number Line, Ghost, Fast Enough For You, Halley’s Comet, Maze, Alaska #, Theme From The Bottom, Golgi Apparatus $, Possum $, //Loving Cup

    // No footage till 00:03:58, filled with graphics
    Mistake on screen says SBD, this is FOB Schoeps source listed above
    # 1st Time Played
    $ God Damn w00ks
    // No footage, filled with graphics

    March 8, 2012

    Phish: 03/07/2009 Mike’s Song / Weekapaug Groove [VQ: A-, AQ: A, CK5]

    YouTube Preview Image YouTube Preview Image

    December 11, 2011

    Phish: 08/01/2009 ENTIRE SHOW [VQ: A, AQ: A+, TH 2-CAM]
    Set 1: AC/DC Bag, The Curtain With, Mound, Gotta Jibboo, Guyute, Punch You In The Eye, Tube, Alaska, Run Like An Antelope
    YouTube Preview Image
    Set 2: Rock and Roll– Down With Disease– Free, Esther, Dirt, Harry Hood
    Encore: Sleeping Monkey, First Tube
    YouTube Preview Image

    December 9, 2011

    Phish: 07/31/2009 Entire Show [VQ: A, AQ: A+, 4-CAM]

    YouTube Preview Image YouTube Preview Image

    Set 1:  Runaway Jim, Chalk Dust, Bathtub, Time Turns Elastic, Lawn Boy, Water In The Sky, Stealing Time, Split

    Set 2: Drowned > Crosseyed > Joy, Tweezer > BDTNL, Fluffhead > Piper > ADITL

    Encore: Suzy > Reprise

    November 3, 2011

    Trey Anastasio: Trey w/ New York Philharmonic 09/12/2009 You Enjoy Myself [VQ: A-, AQ: A-]

    November 2, 2011

    Phish: 12/02/2009 Chalkdust Torture [VQ: A, AQ: A+, Angle: On-Stage]

    YouTube Preview Image

    September 29, 2011

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

    YouTube Preview Image

    Phish: 06/02/2009 Possum [VQ: B+, AQ: A]

    YouTube Preview Image

    March 8, 2011

    Phish: 03/08/2009 Down With Disease [VQ: A, AQ: A+, Remastered]

    YouTube Preview Image

    February 8, 2011

    Phish: w/ Bruce Springsteen 06/14/2009 Mustang Sally [VQ: B-, AQ: B+]

    YouTube Preview Image

    December 12, 2010

    Cactus: Mike Gordon 10/03/2009 DAUD Buffalo, NY

    November 16, 2010

    Cactus: Mike Gordon Band 09/22/2009 DAUD Nashville, TN

    September 7, 2010

    Phish: 06/09/2009 Ghost [VQ: A, AQ: A, Angle: CK5]

    YouTube Preview Image

    September 4, 2010

    Phish: 06/09/2009 When The Cactus Is In Bloom [VQ: A, AQ: A, Angle: CK5]

    YouTube Preview Image

    Phish: 08/07/2009 DAUD New Source George, WA

    Phish: 06/09/2009 Bold As Love [VQ: A, AQ: A, Angle: CK5]

    YouTube Preview Image

    Phish: 08/05/2009 DAUD Mountain View, CA

    September 2, 2010

    Phish: 06/09/2009 Tube [VQ: A, AQ: A-, Multi-CAM]

    YouTube Preview Image

    September 1, 2010

    Phish: 06/09/2009 Sample In A Jar [VQ: A, AQ: A-, Multi-CAM]

    YouTube Preview Image

    Phish: 06/09/2009 Stash [VQ: A, AQ: A-, Multi-CAM]

    YouTube Preview Image

    August 27, 2010

    Trey & Page: Allman Brothers  03/12/2009 I Know You Rider [VQ: A-, AQ: A-]

    YouTube Preview Image

    July 19, 2010

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

    YouTube Preview Image

    July 16, 2010

    Phish: 12/04/2009 Mike’s Song [VQ: B-, AQ: B-, CK5]

    YouTube Preview Image

    June 9, 2010

    Jams: Looking Back on ’09 [Dog Gone Blog]

    May 20, 2010

    Phish: 12/31/2009 Party Time > Auld Lang Syne [VQ: B+, AQ: B+]

    YouTube Preview Image

    May 14, 2010

    Remembrances: Backwards Down the 2009 [Wading in the Velvet C.]

    May 10, 2010

    Phish: 11/27/2009 Fire [VQ: A-, AQ: B+]

    YouTube Preview Image

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

    YouTube Preview Image

    May 7, 2010

    Lists: An Alternative Video List – Best Phish Jams [OhKeePahBlog]

    2. Merriweather  “46 Days”
    I’m one of the few that felt this show was a highlight of the summer. The band broke out a creative setlist for those of us who had been on the road for the last few shows. Busting out the first Sloth and Ha Ha Ha of Phish 3.0, and the world debut of Party Time. The 46 Days is absolute soul-wrenching guitar work. This jam brought me to tears that night, and it melts so smoothly into Oh Sweet Nothing.

    May 6, 2010

    Downloads: Light 2009 – 10-Disc Compilation [JiggsLot]

    April 29, 2010

    Lists: Six Defining Moments of ’09 [Phish Thoughts]

    April 28, 2010

    Lists: 10 Best of 2009 [Phish Thoughts]

    7. “Get Back on the Train” 12.30 II – Miami

    This ethereal exploration came as the centerpiece of December 30th’s second set. Passing through multiple sections of unique improv, this jam, literally, blossomed out of nowhere. Immediately vaulting to into the “best ever” position for the generally jam-less song, “Get Back On the Train” provided one of the most unlikely virtuoso highlights of the entire Miami run.

    April 27, 2010

    Mike Gordon: 10/03/2009 DAUD Buffalo, NY

    April 22, 2010

    Lists: 10 Phish Songs That Got Away in ’09 [Hidden Track]

    7/6. Izabella/Eliza [LTP: 7/31/1998 – 5/14/1992]

    Trey’s two daughters are named Eliza and Isabella, so you’d think he’d play the tunes in the Phish repertoire referencing their names but think again. Eliza – a quick instrumental found on Picture of Nectar – hasn’t made a setlist since 1992 while the Jimi Hendrix cover Izabella has been long lost since 1998. Izabella fit perfectly into the rotation in 1997 and we’d love to see Trey opt for it over Character Zero in the shred-fest slot this summer.

    April 20, 2010

    Phish 3D: 10/31/2009 Suzy Greenberg [VQ: A, AQ: A]

    YouTube Preview Image

    April 7, 2010

    Lists: The Fizzlers of 2009 [Phish Thoughts]

    “Runaway Jim”

    One of Phish’s classic songs, “Runaway Jim” grew from a once-contained show-opener into a legitimate launchpad, producing excursions of all types through the years. A song with too many special versions to begin listing, “Runaway Jim” never moved beyond its basic structure in 2009.

    March 24, 2010

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

    YouTube Preview Image

    March 23, 2010

    Phish: 03/08/2009 Tube [VQ: A, AQ: A]

    YouTube Preview Image

    March 21, 2010

    Phish: 03/08/2009 While My Guitar Gently Weeps [VQ: A, AQ: A-]

    YouTube Preview Image

    March 16, 2010

    Phish: 03/08/2009 The Horse > Silent In The Morning [VQ: A, AQ: A-]

    YouTube Preview Image

    March 14, 2010

    Phish: 03/08/2009 Seven Below [VQ: A-, AQ: A-]

    YouTube Preview Image

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

    YouTube Preview Image YouTube Preview Image YouTube Preview Image

    March 12, 2010

    Phish: 03/07/2009 A Day In The Life [VQ: A, AQ: A-]

    YouTube Preview Image

    March 9, 2010

    Phish: 06/07/2009 Fee [VQ: A-, AQ: B+]

    YouTube Preview Image

    March 8, 2010

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


    February 9, 2010

    Phish: Hampton 2009 Montage

    YouTube Preview Image

    February 7, 2010

    Phish: 12/29/09 Prince Caspian [VQ: A-, AQ: B+]

    YouTube Preview Image

    January 18, 2010

    Phish: 12/31/2009 Fluffhead [VQ: B+, AQ: B+]

    YouTube Preview Image

    January 13, 2010

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

    Downloads/Streaming: Best Jams of 2009 [drop.io]

    Miami: NYE Pt. 4 – Party In The City Where The Heat Is On [Dog Gone Blog]

    January 12, 2010

    Year in Review: 2009 – The Year That Was [Phish Thoughts]

    2009 Regular Season Awards:

    Type II Jam Vehicles – First Team: “Down With Disease,” “Piper,” “Rock and Roll,” “Tweezer,” “Stash”

    Type II Sixth Man of the Year: “Drowned”

    Type I Jam Vehicles – First Team: “Wolfman’s,” “Harry Hood,” “Jibboo,” “Bathtub Gin,” “Slave”

    Type I Sixth Man of the Year: “Reba”

    January 11, 2010

    Phish: 12/31/2009 Simple [VQ: A, AQ: B+]

    YouTube Preview Image

    January 10, 2010

    Phish: 12/30/2009 ALMOST ENTIRE SHOW PLAYLIST [VQ: A-, AQ: B+, Angle: CK5]


    2009 In Review: Phish in the Age of 3.0 [Great Scott!]

    Song choice played a much larger role for the group than it ever has, and the jamming, while still prevalent, became more concise. While many could contend that this marks the end of the Phish “we all know and love,” I would argue against that. The band is communicating in a new way while still using the same language, it just may take a more active listener to appreciate it.

    Phish Lot: Brilliant Comrades [Funny]

    YouTube Preview Image

    January 3, 2010

    Phish: 12/31/2009 McNasty Shasta ENTIRE SHOW PLAYLIST [VQ: B+, AQ: B+]


    January 2, 2010

    Phish: 12/31/2009 Demand [VQ: B+, AQ: B+]

    YouTube Preview Image

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