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

    Rhode Island RSS

    December 10, 2011

    Cactus: Mike Gordon 12/09/2011 Cities [VQ: B+, AQ: A-]

    YouTube Preview Image

    Cactus: Mike Gordon 12/09/2011 The Void [VQ: B-, AQ: B]

    YouTube Preview Image

    Cactus: Mike Gordon 12/09/2011 I Sure Miss My Mind [VQ: B, AQ: B]

    YouTube Preview Image

    Cactus: Mike Gordon 12/09/2011 DAUD Pawtucket, RI

    Cactus: Mike Gordon 12/09/2011 Clone [VQ: B-, AQ: B+]

    YouTube Preview Image

    Cactus: Mike Gordon @ The Met in Pawtucket – Setlist & Recap [Hidden Track]

    December 1, 2011

    Trey Anastasio: Trey Solo Acoustic – Video of Entire Set [VQ: A+, AQ: A+, Official]

    Trey Anastasio: Trey 08/02/2008 Official Audio Newport, RI

    One of the most surprising names to appear on the 2008 Newport Folk Festival roster was Phish’s guitarist and primary songwriter, Trey Anastasio. Within the context of Phish, Anastasio concentrated on his electric guitar technique, drawing on rock, funk, country and jazz influences within a highly improvisational context. Following the 1995 death of one of Anastasio’s primary influences, Jerry Garcia, and the subsequent demise of the Grateful Dead, Phish experienced a huge surge in their following. Within a brief time, Phish found themselves the new torchbearers of the jamband scene, with legions of devoted fans following their every move. The increasingly complicated logistics of touring that inevitably followed would eventually take its toll, leading to a two-year hiatus between 2000 and 2002, and finally to the announcement of their breakup in 2004.

    April 5, 2011

    Phish: 04/05/1998 ENTIRE SHOW PLAYLIST [VQ: B+, AQ: A]

    http://www.youtube.com/view_play_list?p=43293501466F24E9

    The Oh Kee Pa Ceremony, You Enjoy Myself, Theme From The Bottom, McGrupp, Bathtub Gin, Cities, Sparkle, Split Open and Melt, Down With Disease, Ya Mar, Prince Caspian, Maze, Possum, Cavern, Bold As Love

    Videos: Playlists of the Complete Island Tour [Hidden Track]

    Phish: 04/04/1998 ENTIRE SHOW PLAYLIST [VQ: B+, AQ: A]

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

    Tweezer, Taste, Bouncing Around The Room, Funky Bitch, Ginseng Sullivan, Bouncing Around The Room, Funky Bitch, Ginseng Sullivan, Limb By Limb, Lawn Boy, Character Zero, Birds of a Feather, Also Sprach Zarathrustra, Brother, Brother (radio edit), Ghost, The Lizards, David Bowie, Harry Hood

    March 18, 2011

    Phish: 12/29/1994 DAUD New Source Providence, RI

    March 4, 2011

    Phish: 10/22/2010 + 12/31/2010 Rock and Roll [VQ: A-, AQ: A+]

    YouTube Preview Image

    December 23, 2010

    Phish: 10/22/2010 Rock and Roll – Carini [VQ: B+, AQ: B+]

    YouTube Preview Image

    Phish: 10/22/2010 My Problem Right There [VQ: A-, AQ: B+]

    YouTube Preview Image

    December 16, 2010

    Phish: 10/22/2010 Roses Are Free, Rift [VQ: B+, AQ: B+]

    YouTube Preview Image

    December 10, 2010

    Phish: 10/22/2010 Funky Bitch [VQ: C+, AQ: B-]

    YouTube Preview Image

    November 15, 2010

    Phish: 10/22/2010 Ocelot, NICU [VQ: B+, AQ: A+, CK5]

    YouTube Preview Image

    October 27, 2010

    Phish: 10/22/2010 First Tube [VQ: A-, AQ: B+]

    YouTube Preview Image

    October 25, 2010

    Phish: 10/22/2010 MKDevo Playlist [VQ: A, AQ: A+]

    http://www.youtube.com/view_play_list?p=4E7EED7FFE79FEA4

    Down With Disease, Funky Bitch, Fluffhead, Roses Are Free, Rift, The Moma Dance, Ocelot, NICU, Sample In A Jar, Julius, Rock and Roll, Carini, My Problem Right There, Mikes > Sanity > Weekapaug, Suzy, …Light, 2001, Loving Cup

    October 23, 2010

    Phish: 10/22/2010 LivePhish SBD Providence, RI

    Phish: 10/22/2010 DAUD Providence, RI

    Phish: 10/22/2010 NICU [VQ: A-, AQ: B+]

    YouTube Preview Image

    Phish: 10/22/2010 Down With Disease [VQ: B+, AQ: B]

    YouTube Preview Image

    Phish: 10/22/2010 …Suzy > Light [VQ: B, AQ: B]

    YouTube Preview Image

    September 14, 2010

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

    August 24, 2010

    Fall Tour: Phish Fall Tour 2010 Official [Hidden Track]

    After two scintillating legs of summer touring, Phish has just announced the schedule for Fall Tour 2010. The 15-show tour starts with a headlining set at Austin City Limits and brings them to a number of venues they haven’t played before including the new 1st Bank Center in Broomfield, CO; the Augusta Civic Center in Augusta, ME; the Utica Memorial Auditorium in Utica, NY; the Verizon Wireless Arena in Manchester, NH and Boardwalk Hall in Atlantic City.

    April 23, 2010

    Phish: 05/17/1991 DAUD Providence, RI

    June 10, 2009

    Phish: 12/13/1999 FOB Providence, RI

    February 27, 2009

    Phish: 03/13/1992 SBD Providence, RI

    February 11, 2009

    Phish: 02/04/1993 FOB Providence, RI

    February 1, 2009

    Phish: 02/01/1991 SBD Providence, RI

    January 30, 2009

    Phish: 04/05/1998 FOB UNCIRCULATED Providence, RI

    January 20, 2009

    Phish: 04/04/1998 DAUD Providence, RI

    Phish: 04/05/1998 DAUD Providence, RI

    December 29, 2008

    Phish: 12/29/1990 SBD Providence, RI

    Mike Gordon Band: 12/27/2008 DAUD Providence, RI

    December 23, 2008

    Phish: 11/16/1990 SBD Providence, RI

    December 21, 2008

    Phish: 12/13/1999 DAUD Providence, RI

    November 25, 2008

    Phish: 09/14/1990 AUD Providence, RI

    October 30, 2008

    Trey Anastasio: 10/21/2008 First Tube > Jam

    YouTube Preview Image

    October 27, 2008

    Trey Anastasio: 10/21/2008 Ooh Child

    YouTube Preview Image

    October 25, 2008

    Trey Anastasio: 10/21/2008 DAUD 24K Providence, RI

    Trey Anastasio: 10/21/2008 DAUD Providence, RI

    October 23, 2008

    Trey Anastasio: 10/21/2008 DAUD Providence, RI

    Trey Anastasio: 10/21/2008 First Tube Jam

    YouTube Preview Image

    October 22, 2008

    Trey Anastasio: 10/21/2008 DAUD Providence, RI

    Trey Anastasio: 10/21/2008 DAUD 24K Providence, RI

    Review: Classic TAB @ Lupo’s [Coventry]

    Trey Anastasio: 10/21/2008 First Tube Jam

    YouTube Preview Image

    October 4, 2008

    Page w/ PBS: 09/25/2008 OFFICIAL Providence, RI

    Page w/ PBS: 09/25/2008 DAUD Providence, RI

    September 29, 2008

    Phish: 02/15/1990 SBD Providence, RI

    September 26, 2008

    Page w/ PBS: 09/25/2008 w/ Carl Gerhard

    YouTube Preview Image