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

    1990 RSS

    March 1, 2012

    Phish: 02/17/1990 UMASS ’90 DVD [The Trader’s Den (Reg. Required)]

    February 25, 2012

    Phish: 02/17/1990 UPGRADE Nearly Entire Show [VQ: A, AQ: A+]

    YouTube Preview Image

    00:00:00 Possum (cut)
    00:02:08 Bathtub Gin
    00:09:29 Divided Sky >
    00:21:19 The Sloth
    00:26:09 Bouncing Around the Room
    00:29:55 You Enjoy Myself
    00:45:53 Golgi Apparatus
    00:50:48 Reba
    01:03:35 The Oh Kee Pa Ceremony >
    01:05:17 AC/DC Bag
    01:12:09 The Squirming Coil
    01:18:03 Harry Hood
    01:30:27 Carolina
    01:33:36 Mike’s Song >
    01:40:53 I Am Hydrogen
    01:42:29 Credits

    [via Cleantones]

    February 19, 2012

    Rare Video: 22 Year Old Phish Video Footage Surfaces on YouTube – UMASS ’90 [HT]

    YouTube Preview Image

    December 15, 2011

    Remembrances: 12/31/1990 – World Trade Center, Boston MA [Back In My Day]

    September 9, 2011

    Columns: Video of the Week – 09/28/1990 [Phish.net]

    August 26, 2011

    Columns: Video of the Week – 11/02/1990 David Bowie [Phish.net]

    May 26, 2011

    Phish: 05/19/1990 UNCIRCULATED SBD Concord, NH

    New, complete source of Phish’s performance at a New Hampshire prep school has surfaced thanks to one of the students in attendance that night as well as Chad Fagin, Adam Scheinberg, Charlie Dirksen and Brian Costigan. Well worth the addition to your Phish collection. – ScottyB

    May 4, 2011

    Remembrances: Essential Phish – 11/04/1990 Ft. Ram [Dog Gone Blog]

    It has been touched on before, but especially these days it’s important to bring attention to certain shows that act like building blocks for the band’s career. With the age of downloading upon us, many of the once-essential analog tapes have gone the way of the wind. Surely, those who were active in the tape-trading years will know this one. But for those who don’t, add the show from November 4, 1990 at Fort Ram, Fort Collins, CO the your list of essential, must-hear shows.

    April 21, 2011

    Phish: 04/21/1990 SBD Fort Collins, CO

    April 11, 2011

    Phish: 02/01/1990 Mike’s Song [VQ: B+, AQ: B+]

    YouTube Preview Image

    April 9, 2011

    Phish: 02/01/1990 Possum > Fee [VQ: A-, AQ: B+]

    YouTube Preview Image

    April 5, 2011

    Phish: 02/01/1990 Divided Sky [VQ: A-, AQ: A-]

    YouTube Preview Image

    April 4, 2011

    Phish: 02/01/1990 Caravan [VQ: A, AQ: A-]

    YouTube Preview Image

    April 1, 2011

    Phish: 02/01/1990 Walk Away, Oh Kee Pa > Suzy [VQ: A-, AQ: B+]

    YouTube Preview Image

    March 16, 2011

    Phish: 04/07/1990 II SBD UNCIRCULATED Crested Butte, CO

    March 9, 2011

    Phish: 05/07/1990 I AUD UNCIRCULATED Ithaca, NY

    March 3, 2011

    Phish: 09/16/1990 DAUD New Source Wesleyan, CT

    March 2, 2011

    Phish: 03/01/1990 SBD New Source New Haven, CT

    January 28, 2011

    Phish: 01/27/1990 SBD Burlington, VT

    December 7, 2010

    Phish: 04/07/1990 SBD UNCIRCULATED Crested Butte, CO

    October 5, 2010

    Phish: 04/29/1990 Entire Show Playlist [VQ: A, AQ: A, Pro]

    http://www.youtube.com/view_play_list?p=947E0706D09CED29

    October 3, 2010

    Phish: 11/02/1990 David Bowie [VQ: A-, AQ: A-]

    YouTube Preview Image

    September 26, 2010

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

    September 23, 2010

    Phish: 03/08/1990 SBD Upgraded Source Saratoga Springs, NY

    September 15, 2010

    Phish: 12/08/1990 II AUD Uncirculated Poughkeepsie, NY

    September 14, 2010

    Phish: 12/29/1990 II AUD Uncirculated Providence, RI

    September 3, 2010

    Phish: 04/06/1990 II Uncirculated AUD Crested Butte, CO

    August 22, 2010

    Phish: 06/16/1990 SBD Townshend, VT

    If you don’t have this fantastic, classic Phish show in your collection be sure to take advantage of this file set put together by our pal Parker. – ScottyB

    July 19, 2010

    Phish: 05/15/1990 II UNCIRCULATED AUD Clinton, NY

    July 1, 2010

    Phish: 05/19/1990 SBD UNCIRCULATED Concord, NH

    Back in the days when Phish regularly played at colleges and boarding schools, they stopped by St. Paul’s in Concord, NH. This SBD features only about half of the show, but we’ll take what we can get. – ScottyB

    June 8, 2010

    Covers: Conjunction Junction – Circa 1990 (!!!) – You Enjoy Myself

    http://www.youtube.com/view_play_list?p=46E012A8FCB18FD8

    April 26, 2010

    Phish: 04/29/1990 Fluffhead [VQ: A-, AQ: B+]

    YouTube Preview Image YouTube Preview Image

    Phish: 04/29/1990 Walk Away [VQ: A-, AQ: B+]

    YouTube Preview Image

    February 8, 2010

    Phish: 10/30/1990 II SBD Crested Butte, CO

    February 5, 2010

    Phish: 09/28/1990 Oh Kee Pa > Suzy Greenberg [VQ: B, AQ: B-]

    YouTube Preview Image

    February 2, 2010

    Phish: 09/28/1990 Jam, Paul & Silas [VQ: B+, AQ: B]

    YouTube Preview Image

    January 20, 2010

    Remembrances: 20 Years Later – Webster Hall [Dog Gone Blog]

    January 13, 2010

    Phish: 09/17/1990 UNKNOWN UNCIRCULATED Burlington, VT

    Source: Cass3>Sony Music Machine>Cdr>.Wav (Windows Media Player lossless)>flac (Traders Little Helper level8)

    1. //Run Like an Antelope * > Lawn Boy (4:59) 2. Funky Bitch (4:57) 3. Cavern > (4:47) 4. HYHU > (1:44) 5. Terrapin > (4:58) 6. HYHU ** (3:16) 7. Mike’s Song > (6:54) 8. Hydrogen > (3:11) 9. Weekapaug Groove *** (6:32)

    Encore: 10. MY Sweet One **** (5:40) 11. Paul and Silas **** (4:00) 12. La Grange > Rocky Top **** (7:30)

    * Trey quotes ‘Fixin to Die’ lyrics
    ** ‘Mindy is leaving…’, band intros
    *** Groove is in the Heart jams
    **** w/ Russell Flanagan on fiddle

    December 15, 2009

    Phish: 06/08/1990 SBD Philadelphia, PA

    October 30, 2009

    Phish: 02/24/1990 SBD UNCIRCULATED Washington, DC

    Disc #1

    01.//Carolina
    02. You Enjoy Myself
    03. Golgi Apparatus
    04. Divided Sky
    05. Esther >
    06. Po//ssum
    07. I Didn’t Know
    08. Run Like An Antelope
    09. Take The A Train

    Disc #2

    01. The Sloth
    02. Oh Kee Pah Ceremony >
    03. AC/DC Bag
    04. Fee
    05. The Squirming Coil >
    06. La Grange
    07. Bathtub Gin
    08. Lawn Boy
    09. Co//ntact
    10. The Lizards
    11. Caravan

    August 18, 2009

    Phish: 06/02/1990 UNCIRCULATED ??? Columbia, SC

    May 5, 2009

    Phish: 01/28/1990 SBD Burlington, VT

    March 2, 2009

    Phish: 03/01/1990 SBD Athens, GA

    January 12, 2009

    Phish: 06/08/1990 SBD Philadelphia, PA

    January 6, 2009

    Phish: 01/29/1990 II AUD Ithaca, NY

    December 29, 2008

    Phish: 12/30/1990 AUD Boston, MA

    Phish: 12/29/1990 SBD Providence, RI

    December 28, 2008

    Phish: 12/28/1990 SBD New York, NY

    Phish: 10/06/1990 SBD Soundcheck Port Chester, NY

    December 24, 2008

    Phish: 11/17/1990 AUD Somerville, MA

    December 23, 2008

    Phish: 11/15/1990 AUD Orono, ME

    Phish: 11/16/1990 SBD Providence, RI

    December 22, 2008

    Phish: 11/08/1990 SBD Madison, WI

    Phish: 11/10/1990 SBD Richmond, IN

    December 17, 2008

    Phish: 11/04/1990 SBD Ft. Collins, CO

    December 16, 2008

    Phish: 11/03/1990 SBD Boulder, CO

    December 15, 2008

    Phish: 11/02/1990 SBD Boulder, CO

    December 10, 2008

    Phish: 10/12/1990 AUD Chapel Hill, NC

    December 8, 2008

    Phish: 10/07/1990 SBD South Amboy, NJ

    Phish: 10/08/1990 AUD Washington, DC