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

    1999 RSS

    April 29, 2012

    Documentaries: A Trip to Oswego

    YouTube Preview Image

    February 21, 2012

    Interviews: Phish on CNN’s Worldbeat 1999

    YouTube Preview Image

    February 2, 2012

    Phish: 07/24/1999 Set II + Encore [VQ: B, AQ: A-]

    YouTube Preview Image

    January 20, 2012

    Phish: 12/18/1999 Entire Show [VQ: B-/C, AQ: B+]

    Set 1

    YouTube Preview Image

    Set 2

    YouTube Preview Image

    Set 1: Harry Hood, Back at the Chicken Shack, Dog Log, Tube, Heavy Things, Back on the Train, First Tube, The Inlaw Josie Wales[1], You Enjoy Myself

    Set 2: Also Sprach Zarathustra[2] > Sand, The Horse > Silent in the Morning, Possum, Mike’s Song > Simple, Weekapaug Groove -> Buffalo Bill > Weekapaug Groove[3]
    Encore: Ya Mar, Sleeping Monkey

    [1] Trey on acoustic guitar.
    [2] Do You Feel Like We Do tease.
    [3] Norwegian Wood and Buffalo Bill teases.

    Notes: Dog Log was dedicated to Paul Languedoc. Afterwards, the band reprised the song for a few seconds after Trey remarked how much he liked it. Inlaw Josie Wales featured Trey on acoustic guitar. 2001 included Do You Feel Like We Do (Peter Frampton) teases; Trey also introduced Fishman as ‘Bob Mayonnaise’, likely a reference to Bob Mayo, who played keys on Frampton Comes Alive. Weekapaug included Norwegian Wood and Buffalo Bill teases.

    [Setlist via Phish.net]

    January 15, 2012

    Phish: 10/04/1999 Entire Set 1 [VQ: B+, AQ: A-]

    YouTube Preview Image

    Set 1: Uncle Pen, Funky Bitch, Vultures, Runaway Jim, Jesus Just Left Chicago, Limb By Limb, Wilson , Down with Disease

    December 26, 2011

    Phish: 10/04/1999 Playlist [VQ: A-, AQ: A-]

    Funky Bitch, Vultures, Runaway Jim, Jesus Just Left Chicago, Runaway Jim, Limb By Limb, Wilson, Down With Disease

    December 21, 2011

    Phish: 12/07/1999 Simple [VQ: B, AQ: B+]

    YouTube Preview Image

    Phish: 12/07/1999 Free [VQ: B, AQ: B+]

    YouTube Preview Image

    December 19, 2011

    Phish: 12/07/1999 Wolfman’s Brother [VQ: B, AQ: B+]

    YouTube Preview Image

    December 6, 2011

    Phish: 12/31/1999 – 01/01/2000 Most of Midnight to Sunrise Set [VQ: Varies, AQ: B+]

    December 1, 2011

    Phish: 07/17/1999 + 07/18/1999 DAUD New Source Oswego, NY

    November 29, 2011

    Phish: 09/18/1999 DAUD New Source Chula Vista, CA

    October 11, 2011

    Phish: 09/14/1999 Set Two [VQ: A-, AQ: A-, Two-Cam]

    YouTube Preview Image

    Peaches en Regalia > AC/DC Bag  > Gumbo > Down With Disease, Frankenstein

    September 30, 2011

    Remembrances: Phish Fri – Bathtub Gin > Simple 12/07/1999 [Dog Gone Blog]

    September 19, 2011

    Phish: 09/11/1999 DAUD New Source George, WA

    September 2, 2011

    Columns: Video of the Week – 12/18/1999 Chicken Shack, Dog Log [Phish.net]

    July 12, 2011

    Phish: 01/01/2000 Bathtub Gin [VQ: B, AQ: B+]

    YouTube Preview Image

    June 24, 2011

    Downloads: A Show For Your Weekend – Independence Day ’99 [OPT]

    May 27, 2011

    Trey Anastasio: TAB Trio 05/07/1999 New Source DAUD St. Louis, MO

    May 9, 2011

    Fish: Jazz Mandolin Project 02/13/1999 New Source Washington, D.C.

    April 28, 2011

    Remembrances: Flowing Back to Hartford ’99 [Dog Gone Blog]

    April 27, 2011

    Phish: 12/18/1999 New Source DAUD Hampton, VA

    April 25, 2011

    Old Shows: Charlie Dirksen Listens to Bonner Springs ’99 [Phish.net]

    March 23, 2011

    New Live Phish: Phish Releases July 31, 1999 Show For Charity [Hidden Track]

    Phish’s first-ever shows in Japan took place during the Summer of 1999, when the band traveled across the Pacific to perform at the Fuji Rock Festival. A new Live Phish release titled Japan Relief looks at the July 31, 1999 show from Fuji Rock to benefit Peace Winds America with proceeds going to help the disaster relief efforts following the earthquake and subsequent tsunami that wreaked havoc on Japan.

    March 20, 2011

    Phish: 09/28/1999 FOB New Source Pelham, AL

    March 6, 2011

    Phish: 07/24/1999 Playlist [VQ: B, AQ: A-]

    http://www.youtube.com/view_play_list?p=859E5F07DD599E47

    Tweezer > Catapult > The Mango Song > Happy Whip and Dung Song, Waste, Chalk Dust, Glide, Camel Walk, Alumni Blues, Tweezer Reprise

    March 3, 2011

    Video: 12/31/1998 1999 (Prince Cover) [VQ: B+, AQ: A-]

    YouTube Preview Image

    February 25, 2011

    Phish: 12/04/1999 FOB New Source Cincinnati, OH

    February 18, 2011

    Lists: 10 Things You May Not Remember From TAB ’99 Tour [HT]

    6) Bug was a TAB song first

    We’ve been taking a trip down memory lane as we revisited all of the audio from the Trey ’99 tour and one constant I found was that while everyone knows that Sand, First Tube, Gotta Jibboo etc. came from this tour, a lot of people forget that there were two electric performances of Bug in ’99 before it hit the Phish stage. Hear the first one and Trey describing the songwriting experience with Tom.

    February 16, 2011

    Phish: 10/04/1999 DAUD New Source Normal, IL

    February 13, 2011

    Phish: 07/13/1999 DAUD NEW SOURCE Mansfield, MA

    January 28, 2011

    Phish: 09/14/1999 New Source DAUD Boise, ID

    December 20, 2010

    Phish: 12/18/1999 Harry Hood [VQ: A-, AQ: A-]

    YouTube Preview Image

    Phish: 12/18/1999 Back at the Chicken Shack, Dog Log [VQ: A-, AQ: A-]

    YouTube Preview Image

    December 16, 2010

    Remembrances: Remembering Raleigh [Phish Thoughts]

    December 10, 2010

    Downloads: A Show For The Weekend – 07/25/99 [OPT]

    November 17, 2010

    Phish: 09/14/1999 Peaches En Regalia [VQ: B, AQ: A-]

    YouTube Preview Image

    September 30, 2010

    Phish: 12/17/1999 DAUD New Source Hampton, VA

    September 29, 2010

    Phish: 09/18/1999 DAUD New Source Chula Vista, CA

    September 10, 2010

    Phish: 07/23/1999 DAUD New Source Columbus, OH

    September 2, 2010

    Phish: 07/12/1999 DAUD New Source Mansfield, MA

    August 31, 2010

    Phish: 07/09/1999 DAUD New Source Columbia, MD

    August 2, 2010

    Songs: The Meatstick Dance, Summer ’99s Craze [PhanArt]

    Here we stand at the forefront of Summer Tour 2010, Leg 2, with a piece of Phish history slipping away to faded memories. Is this the future we want to bring up our children in? A Meatstick-less future? Can you sleep at night knowing you haven’t passed on the legacy that is The Meatstick to your friends and family? If not you, who? If not now, when? If not here, where? AT WHAT COST?!

    July 21, 2010

    The Scene: 07/30/1999 Fuji Rock Festival

    YouTube Preview Image

    July 11, 2010

    Phish: 09/17/1999 DAUD UNCIRCULATED Mountain View, CA

    May 6, 2010

    Trey and Page: Phil and Phriends – 04/15/1999 Viola Lee, Big RxR Blues, Row Jimmy, Shakedown Street, The Wheel, Not Fade Away, Mr. Tambourine Man [VQ: B+, AQ: B+]

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

    May 5, 2010

    Downloads: 09/14/1999 Boise Remaster [Ghetto-Fab Remasters]

    April 14, 2010

    Phish: 12/05/1999 Frankenstein [VQ: B+, AQ: B+]

    YouTube Preview Image

    March 25, 2010

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

    YouTube Preview Image

    March 24, 2010

    Remembrances: 07/25/1999 Deer Creek [OhKeePah]

    March 23, 2010

    Phish: 10/01/1999 Axis: Bold As Love [VQ: B+, AQ: B+]

    YouTube Preview Image

    March 21, 2010

    Phish: 12/30/1999 FOB Big Cypress, FL

    March 16, 2010

    Phish: 12/31/1999 UNCIRCULATED FOB Big Cypress, FL

    February 17, 2010

    Remasters: 09/21/1999 Tucson, AZ [Ghetto-FAB Remasters]

    OK folks, I think you will be very happy with the result here. First off, I know I usually try not to comment on the music itself much, but I can’t help it in this case: I love this show. Perhaps my favorite of the tour, and there aren’t even any real mind-bending type II excursions. It’s just so well played, and they sound so…liquid in this show. I mean, a killer SOAM + Drowned as the third and fourth songs of the first set? Please. A beautiful Theme with some absolutely soaring guitar work from Big Red. And you Vultures fans who haven’t heard this version yet…just make sure you have a pair of fresh drawers for after you listen to this one. Top it off with a sick, long Antelope and an encore of REBA + Bold As Love?!? I quit.

    February 3, 2010

    Trey Anastasio: Spring Tour 1999 DAUD Various

    Yesterday, Duanebase and Jason Sobel seeded the best available source of each Trey Anastasio Spring Tour 1999 show on bt.etree.org. This tour featured Trey solo for the first set and backed by Tony and Russ for the second set. If you’re only going to download a few shows, I’d recommend Albany and St. Louis. – ScottyB

    January 10, 2010

    Phish: 07/21/1999 DAUD UNCIRCULATED Burgettstown, PA

    December 18, 2009

    Phish: 12/18/1999 DAUD Hampton, VA

    December 17, 2009

    Phish: 12/17/1999 FOB Hampton, VA

    December 16, 2009

    Phish: 12/16/1999 DAUD Raleigh, NC

    December 15, 2009

    Phish: 07/24/1999 DAUD UNCIRCULATED E. Troy, WI