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

    Providence RSS

    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

    Providence: In Defense of Mediocrity [Phish.net]

    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 24, 2010

    Providence: Phish Delivers a 3-Hour Jam-Band Extravaganza [ProJo]

    October 23, 2010

    Providence: Review – No Looking Back [Phish Thoughts]

    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

    October 22, 2010

    Providence: Phish Providence Setlist and Recap [Hidden Track]

    September 21, 2010

    Venues: Something In The Air – Providence CC [Dog Gone Blog]

    With fall tour rapidly approaching, it seems appropriate to start looking at some of the venues Phish will be visiting along the way. As soon as fall tour rumors began to spread, the October 22 show at the Dunkin Donuts Center (formerly the Providence Civic Center) in Rhode Island quickly caught the eye of many fans.

    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 6, 2009

    Remembrances: The Island Tour – Providence [Phish Thoughts]

    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: Trey w/ Billy, Scott and Oteil [Hidden Track]

    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