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

    Florida RSS

    February 21, 2012

    Phish: 02/25/1993 Playlist Miami, FL [VQ: A-, AQ: A-]

    Suzy Greenberg, It’s Ice, Sparkle, Wilson, You Enjoy Myself, Uncle Pen, Big Ball Jam, Fast Enough for You, Golgi Apparatus, Big Black Furry Creature from Mars, If I Only Had A Brain (w/ Mimi Fishman), Amazing Grace, Good Times Bad Times

    February 16, 2012

    Phish: 02/25/1993 Sparkle [VQ: A-, AQ: A-]

    YouTube Preview Image

    February 15, 2012

    Phish: 02/25/1993 You Enjoy Myself [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]

    December 6, 2011

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

    November 29, 2011

    Trey Anastasio: TAB 11/12/2011 Devil Went Down, STUDave, Small Axe [VQ: B+, AQ: B]

    YouTube Preview Image

    November 27, 2011

    Trey Anastasio: TAB 11/12/2011 Push On Till The Day [VQ: A+, AQ: A+, Pro-Shot]

    YouTube Preview Image

    November 21, 2011

    Trey Anastasio: TAB 11/12/2011 Mr. Completely [VQ: B+, AQ: B+]

    YouTube Preview Image

    Trey Anastasio: TAB 11/12/2011 Money Love and Change [VQ: B+, AQ: B+]

    YouTube Preview Image

    November 17, 2011

    Trey Anastasio: TAB 11/12/2011 Cayman Review [VQ: B+, AQ: B]

    YouTube Preview Image

    Trey Anastasio: TAB 11/12/2011 Push On Till The Day [VQ: B+, AQ: B]

    YouTube Preview Image

    November 16, 2011

    Trey Anastasio: TAB 11/12/2011 DAUD Live Oak, FL

    November 15, 2011

    Trey Anastasio: TAB 11/12/2011 Playlist [VQ: B+, AQ: B+]

    Clint Eastwood, Simple Twist Up Dave, Ooh Child, Sand, Heavy Things, Black Dog

    July 12, 2011

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

    YouTube Preview Image

    April 21, 2011

    Cactus: Mike Gordon Band w/ Oteil Burbridge 04/16/2011 Walls of Time [VQ: B+, AQ: B]

    YouTube Preview Image

    April 20, 2011

    Cactus: Mike Gordon Band w/ Oteil Burbridge 04/16/2011 – Walls of Time [VQ: A-, AQ: B+]

    YouTube Preview Image

    April 19, 2011

    Cactus: Mike Gordon Band 04/16/2011 Babylon Baby [VQ: A-, AQ: B+]

    YouTube Preview Image

    April 18, 2011

    Cactus: 04/16/2011 Mike Gordon Band @ Wanee Setlist [Phish.net]

    Cactus: Oteil Burbridge Sits In With Mike Gordon Band [Jambands.com]

    January 21, 2011

    Cactus: Wanee Festival 2011 – The Lineup [Hidden Track]

    Festival newcomers include the Steve Miller Band, Robert Plant and the Band of Joy as well as Ween, the Mike Gordon Band and Hot Tuna.

    January 10, 2011

    Phish: 10/21/1994 DAUD New Source Sunrise, FL

    November 17, 2010

    Phish: 08/02/1993 FOB Tampa, FL

    November 16, 2010

    Phish: 02/23/1993 UNCIRCULATED AUD Orlando, FL

    October 8, 2010

    Phish: 11/16/1995 ENTIRE SHOW PLAYLIST [VQ: B+, AQ: B+]

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

    September 16, 2010

    Phish: 11/02/1996 Stash [VQ: A+, AQ: A+, Official]

    September 8, 2010

    Phish: 11/02/1996 Run Like An Antelope [VQ: A+, AQ: A+, Official]

    September 7, 2010

    Phish: 11/02/1996 Julius [VQ: A+, AQ: A+, CK5]

    Phish: 11/02/1996 Harry Hood [VQ: A+, AQ: A+, Official]

    August 20, 2010

    New DVD: Phish to Release Coral Sky DVD [Hidden Track]

    It’s been quite some time since a new Phish DVD came out, so we we’re overjoyed to see that – according to a newly created page on Allmusic which includes a JEMP catalog number – the band will be releasing video of its November 2, 1996 performance at the Coral Sky Amphitheatre in West Palm Beach, FL titled Coral Sky. The show came just two days after the groundbreaking Remain In Light cover set in Atlanta and features a ridiculously good Crosseyed and Painless > Run Like An Antelope segment.

    June 6, 2010

    Phish:10/23/1994 DAUD Gainesville, FL

    June 3, 2010

    Phish: 10/22/1994 FOB Orlando, FL

    Phish: 10/21/1994 DAUD Sunrise, FL

    May 31, 2010

    Phish: 10/20/1994 FOB St. Petersburg, FL

    May 20, 2010

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

    YouTube Preview Image

    April 23, 2010

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

    YouTube Preview Image 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 25, 2010

    Phish: 04/30/1994 SBD Orlando, FL

    One of my all-time favorite recordings. Phish was on fire during this set dropping sick improv, all sorts of teases and a fun Lion Sleeps Tonight jam. If you haven’t heard this or don’t have it in your collection, download it now. – ScottyB

    February 15, 2010

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

    YouTube Preview Image

    February 8, 2010

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

    YouTube Preview Image YouTube Preview Image

    February 7, 2010

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

    YouTube Preview Image

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

    YouTube Preview Image

    February 4, 2010

    Phish: 01/01/2000 HYHU > Love You > HYHU [VQ: B, AQ: B+]

    YouTube Preview Image

    February 3, 2010

    Phish: 01/01/2000 Lawn Boy [VQ: B, AQ: B+]

    YouTube Preview Image

    February 2, 2010

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

    YouTube Preview Image

    February 1, 2010

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

    YouTube Preview Image YouTube Preview Image

    January 29, 2010

    Phish: 11/03/1996 DAUD Gainesville, FL

    January 28, 2010

    Phish: 01/01/2000 Drowned > After Midnight Reprise [VQ: B, AQ: B+]

    YouTube Preview Image YouTube Preview Image YouTube Preview Image

    January 27, 2010

    Phish: 01/01/2000 David Bowie [VQ: B, AQ: B+]

    YouTube Preview Image YouTube Preview Image

    January 26, 2010

    Phish: 01/01/2000 My Soul [VQ: B, AQ: B+]

    YouTube Preview Image

    January 24, 2010

    Phish: 01/01/2000 Axilla, Uncle Pen [VQ: B-, AQ: B+]

    YouTube Preview Image

    Phish: 04/28/1994 AUD West Palm Beach, FL

    January 22, 2010

    Phish: 01/01/2000 Albuquerque [VQ: B, AQ: A-]

    YouTube Preview Image

    Phish: 01/01/2000 Reba [VQ: B, AQ: A-]

    YouTube Preview Image YouTube Preview Image

    January 21, 2010

    Phish: 01/01/2000 Slave to the Traffic Light [VQ: B, AQ: A-]

    YouTube Preview Image YouTube Preview Image

    January 20, 2010

    Phish: 01/01/2000 Quadrophonic Toppling [VQ: B, AQ: A-]

    YouTube Preview Image

    January 18, 2010

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

    YouTube Preview Image YouTube Preview Image

    Phish: 01/01/2000 The Inlaw Josie Wales [VQ: B+, AQ: A]

    YouTube Preview Image

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

    YouTube Preview Image

    Phish: 01/01/2000 Crosseyed & Painless [VQ: B, AQ: A]

    YouTube Preview Image YouTube Preview Image