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

    2003 RSS

    May 20, 2012

    Trey Anastasio: Trey Anastasio Band 06/08/2003 Black Dog [VQ: A-, AQ: A-]

    YouTube Preview Image

    March 8, 2012

    Phish: 07/26/2003 Wolfman’s Brother [VQ: B-, AQ: A+]

    YouTube Preview Image

    February 24, 2012

    Phish: 02/22/2003 Bathtub Gin [VQ: A- (Cuts to Other Footage at 10 Min Mark), AQ: A]

    YouTube Preview Image

    February 22, 2012

    Phish: 02/22/2003 Tube [VQ: A-, AQ: A]

    YouTube Preview Image

    January 26, 2012

    Phish: 12/29/2003 Entire Show [VQ: B+, AQ: A+]

    Set 1

    YouTube Preview Image

    Set 2

    YouTube Preview Image

    Set 1: Piper, Foam, Anything But Me, Limb By Limb, Wolfman’s Brother, Poor Heart, Cavern
    Set 2: Rock and Roll -> Twist -> Boogie On Reggae Woman -> Ghost -> Free[1], Divided Sky, Good Times Bad Times
    Encore: Waste
    Encore 2: The Squirming Coil
    [1] Guitar and bass duet jam.
    Notes: Piper was preceded by Jibboo and On Broadway teases. Free included a guitar and bass duet jam. A lengthy audience ovation followed Free.

    [Setlist via Phish.net]

    Phish: 08/02/2003 Tower Jam [VQ: B-, AQ: A]

    YouTube Preview Image

    January 22, 2012

    Phish: 12/02/2003 Entire Show [VQ: A-, AQ: B+]

    Set 1 –

    YouTube Preview Image

    Set 2 –

    YouTube Preview Image

    Set 1: Harry Hood, Cavern, Birds of a Feather, Ya Mar[1], Horn, Piper, Anything But Me, Water in the Sky, Down with Disease
    Set 2: Rock and Roll -> Weekapaug Groove[2] -> Tweezer Reprise[3] > Frankenstein -> Kung -> Frankenstein, All of These Dreams, The Wedge, Boogie On Reggae Woman > Cities > Maze, Waste
    Encore: Bug
    [1] The Tra La La Song (One Banana, Two Banana) teases.
    [2] Unfinished.
    [3] Lyrics (sung by Trey) from Mike’s Song.
    Notes: This gig commemorated the 20th anniversary of the first Phish show. In the audience, a section of seats were roped off to make way for a music stand. The music stand held a three-ring binder that contained lyrics from the Phish canon, but it did not play an active role in the performance. Ya Mar contained teases of The Tra La La Song (One Banana, Two Banana). At the end of Disease, a video screen descended behind the stage. As the house lights remained down, a 25+ minute video was played featuring retrospective highlights from throughout Phish’s career. Before the second set, Mike brought out a tray of desserts and shared them with fans in front of the stage. Weekapaug was unfinished. Tweezer Reprise included lyrics (sung by Trey) from Mike’s Song. Appropriately, the post-show house music was the Beatles’ song Sgt. Pepper’s Lonely Heart’s Club Band (which begins with the lyric, “It was twenty years ago today…”).

    [Setlist via Phish.net]

    January 6, 2012

    Phish: 02/16/2003 ENTIRE SHOW Playlist [VQ: A, AQ: A+]

    Set 1:
    David Bowie –Catapult –David Bowie, Horn, Guyute, Round Room, Golden Lady (1), Poor Heart, Pebbles & Marbles

    YouTube Preview Image

    Set 2:
    Down With Disease — Seven Below –Down With Disease, Anything But Me, Piper — Down With Disease –Makisupa Policeman, Character Zero, E: Friday

    Comment: (1) Stevie Wonder cover, last played 10/20/94
    setlist courtesy of setlist.com

    YouTube Preview Image

    December 28, 2011

    Phish: 02/22/2003 The Sloth, Dogs Stole Things [VQ: A-, AQ: A+]

    YouTube Preview Image

    December 3, 2011

    Demos: Hear The Original 2003 Version of Stealing Time [@TomMarshall111]

    Stealing Time from the Faulty Plan by ThunderBurn

    August 29, 2011

    Trey Anastasio: TAB 06/08/2003 Root Down [VQ: B+, AQ: B+]

    YouTube Preview Image

    April 9, 2011

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

    March 8, 2011

    Phish: 07/19/2003 Playlist [VQ: A, AQ: A, Pro-Shot]

    http://www.youtube.com/view_play_list?p=86E0F9212E10DB9D

    Sample In A Jar, Reba, Wilson, Scents & Subtle Sounds, Maze, Driver, NICU, Ya Mar, Rocky Top, Lawn Boy, Julius, Piper, Rock and Roll, Seven Below, Prince Caspian, You Enjoy Myself, Wading In The Velvet Sea

    March 4, 2011

    Phish: 07/31/2003 Partial Show Playlist [VQ: A, AQ: A+]

    http://www.youtube.com/view_play_list?p=9297AADE7C2E5FD3

    Piper, Mike’s Song > I Am Hydrogen > Weekapaug Groove, Free, Harry Hood

    February 18, 2011

    Trey Anastasio: Jennifer Hartswick Band w/ Trey 11/07/2003 DAUD UNCIRCULATED NYC, NY

    Taper Scott Bernstein shares his crispy recording of a JHa show at the Lion’s Den in which Trey stopped by to guest for powerhouse versions of Night Speaks and Mr. Completely. – ScottyB

    January 28, 2011

    Phish: 02/15/2003 Harry Hood [VQ: A-, AQ: A]

    YouTube Preview Image YouTube Preview Image

    January 27, 2011

    Phish: 02/15/2003 Bug [VQ: A-, AQ: A+]

    YouTube Preview Image

    Phish: 02/15/2003 Waves [VQ: A-, AQ: A+]

    YouTube Preview Image

    December 16, 2010

    Remembrances: Phish With a Side of Fun – 12/31/03 [Posterous]

    December 2, 2010

    Phish: 03/01/2003 Entire Show Playlist [VQ: A, AQ: A]

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

    Chalk Dust Torture, The Moma Dance, Foam, Lawn Boy, Character Zero > The Divided Sky, Mountains in the Mist, Waves, Sample in a Jar

    Rock and Roll, Wilson > Piper, Also Sprach Zarathustra > Wolfman’s Brother -> Boogie On Reggae Woman, Wading in the Velvet Sea, Run Like an Antelope, Carolina
    Encore: First Tube > You Enjoy Myself -> Proud Mary

    November 29, 2010

    Remembrances: A Look Back at Phish’s 20th Anniversary Run [HT]

    September 27, 2010

    Mike Gordon: 10/05/2003 DAUD UNCIRCULATED San Francisco, CA

    August 24, 2010

    Phish: 01/02/2003, 01/03/2003, 01/04/2003 New Source Hampton, VA

    August 5, 2010

    Phish: 07/13/2003 DAUD East Troy, WI

    August 4, 2010

    Phish: 07/21/2003 DAUD Noblesville, IN

    August 2, 2010

    Phish: 01/03/2003 FOB UNCIRCULATED Hampton, VA

    May 10, 2010

    Phish: 07/17/2003 DAUD UNCIRCULATED Bonner Springs, KS

    April 28, 2010

    Phish: 08/02/2003 Tower Jam [VQ: A, AQ: A]

    YouTube Preview Image

    April 23, 2010

    Phish: 12/29/2003 Ghost [VQ: B+, AQ: A-]

    YouTube Preview Image YouTube Preview Image

    February 12, 2010

    Trey Anastasio: 12/20/2003 Dave and Friends w/ Emmylou Harris – Oh Sister

    YouTube Preview Image

    Songs: Jimmy’s Mid-life Crisis [Me and Harpua]

    February 7, 2010

    Mike Gordon: 10/13/2003 DAUD Philadelphia, PA

    December 28, 2009

    Remembrances: Fun In The Sun – The Finale [Phish Thoughts]

    Phish: 12/28/2003 Sleeping Monkey [VQ: A, AQ: A]

    YouTube Preview Image

    Phish: 12/28/2003 Loving Cup [VQ: A, AQ: A]

    YouTube Preview Image

    December 26, 2009

    Phish: 12/28/2003 Theme From The Bottom [VQ: A, AQ: A]

    YouTube Preview Image

    Phish: 12/28/2003 Water In The Sky [VQ: A, AQ: A]

    YouTube Preview Image

    Phish: 12/28/2003 Friday [VQ: A, AQ: A]

    YouTube Preview Image

    December 24, 2009

    Phish: 12/28/2003 Suzy Greenberg [VQ: A, AQ: A]

    YouTube Preview Image YouTube Preview Image

    December 23, 2009

    Phish: 12/28/2003 Gotta Jibboo [VQ: A, AQ: A]

    YouTube Preview Image YouTube Preview Image

    Remembrances: Fun In The Sun Pt. 2 – Miami 2003 [Phish Thoughts]

    Phish: 12/28/2003 HYHU > Love You > HYHU [VQ: A, AQ: A]

    YouTube Preview Image

    December 22, 2009

    Phish: 12/28/2003 Llama [VQ: A, AQ: A]

    YouTube Preview Image

    Remembrances: Fun In The Sun – Miami ’03 [Phish Thoughts]

    12.28

    When entering American Airlines Arena on the 28th, everyone found the basketball-only arena more intimate than expected. With a shorter floor, and seats that went up more than out, everyone seemed to be on top of the stage. Notoriously laid back security ran the show for all four nights, as the community took reign over the south Florida venue.

    Phish: 12/28/2003 Frankie Says [VQ: A, AQ: A]

    YouTube Preview Image

    December 21, 2009

    Phish: 12/28/2003 AC/DC Bag [VQ: A-, AQ: A-]

    YouTube Preview Image

    December 20, 2009

    Phish: 12/28/2003 Tweezer [VQ: B+, AQ: A]

    YouTube Preview Image YouTube Preview Image

    December 8, 2009

    Phish: 12/31/2003 Jungle Boogie [VQ: B-, AQ: B]

    YouTube Preview Image

    September 30, 2009

    Phish: National Anthem @ Nets Game

    YouTube Preview Image

    September 8, 2009

    Phish: It Festival Teaser [VQ: A, AQ: A]

    July 27, 2009

    Phish: 07/12/2003 FOB UNCIRCULATED George, WA

    July 21, 2009

    Phish: 02/14/2003 Loving Cup [VQ: A, AQ: A]

    YouTube Preview Image

    July 20, 2009

    Phish: 02/14/2003 Oh Kee Pa > AC/DC Bag [VQ: A, AQ: A]

    YouTube Preview Image

    July 16, 2009

    Phish: 02/14/2003 Possum – Walls of the Cave [VQ: A, AQ: A]

    YouTube Preview Image

    July 15, 2009

    Phish: 02/14/2003 Possum [VQ: A-, AQ: A]

    YouTube Preview Image

    July 14, 2009

    Phish: 02/14/2003 Heavy Things [VQ: A, AQ: A]

    YouTube Preview Image

    Phish: 02/14/2003 Golgi Apparatus [VQ: A-, AQ: A]

    YouTube Preview Image

    July 12, 2009

    Phish: 02/14/2003 Bathtub Gin [VQ: A, AQ: A+]

    YouTube Preview Image YouTube Preview Image

    July 10, 2009

    Phish: 02/14/2003 Taste [VQ: A, AQ: A]

    YouTube Preview Image YouTube Preview Image

    July 8, 2009

    Phish: 02/14/2003 Chalk Dust Torture [VQ: A, AQ: A]

    YouTube Preview Image