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"; } } ?> NYC | YEMblog - Page 2

    NYC RSS

    March 6, 2011

    Phish: 12/31/1998 Mike’s Song [VQ: B+, AQ: A]

    YouTube Preview Image

    March 4, 2011

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

    YouTube Preview Image

    March 3, 2011

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

    YouTube Preview Image

    Phish: 12/31/1998 Runaway Jim > New Year’s Eve > Simple [VQ: B+, AQ: A-]

    YouTube Preview Image

    February 28, 2011

    Trey Anastasio: 02/22/2011 Camel Walk [VQ: A, AQ: A+]

    YouTube Preview Image

    February 27, 2011

    Trey Anastasio: 02/22/2011 Burn That Bridge [VQ: A, AQ: A+]

    YouTube Preview Image

    February 24, 2011

    Trey Anastasio: TAB 02/22/2011 Sultans of Swing [VQ: A-, AQ: A-]

    YouTube Preview Image

    Trey Anastasio: TAB 02/22/2011 Ocelot [VQ: A, AQ: A-]

    YouTube Preview Image

    Trey Anastasio: Terminal 5 Recap and Video Playlist [AdamHandman]

    Trey Anastasio: TAB 02/22/2011 Clint Eastwood [VQ: A, AQ: A-]

    YouTube Preview Image

    Trey Anastasio: 02/22/2011 DAUD New York, NY

    Trey Anastasio: 02/22/2011 Gotta Jibboo [VQ: A-, AQ: A-]

    YouTube Preview Image

    February 23, 2011

    Trey Anastasio: TAB 02/22/2011 Empire State of Mind [VQ: A-, AQ: B+]

    YouTube Preview Image

    Trey Anastasio: 02/22/2011 Meatstick [VQ: A-, AQ: B+]

    YouTube Preview Image

    Trey Anastasio: TAB 02/22/2011 Peggy [VQ: B, AQ: B-]

    YouTube Preview Image

    Trey Anastasio: TAB @ Terminal 5 Review [Dog Gone Blog]

    February 18, 2011

    Trey Anastasio: Jennifer Hartswick Band w/ Trey 11/07/2003 DAUD UNCIRCULATED NYC, NY

    Taper Scott Bernstein shares his crispy recording of a JHa show at the Lion’s Den in which Trey stopped by to guest for powerhouse versions of Night Speaks and Mr. Completely. – ScottyB

    February 13, 2011

    Phish: 12/30/2010 Driver [VQ: A-, AQ: A+]

    YouTube Preview Image

    February 11, 2011

    Phish: 12/30/2010 Driver [VQ: A-, AQ: A]

    YouTube Preview Image

    February 1, 2011

    Phish: 01/01/2011 Walls of the Cave [VQ: A, AQ: A+]

    YouTube Preview Image

    January 13, 2011

    Phish: 01/01/2011 Divided Sky [VQ: B+, AQ: B+]

    YouTube Preview Image

    January 12, 2011

    Phish: 12/31/2010 The Ghost Jam [VQ: B+, AQ: B+]

    YouTube Preview Image

    Phish: 01/01/2011 Sneakin’ Sally [VQ: B, AQ: B+]

    YouTube Preview Image

    Phish: 12/31/2010 MKDevo Playlist [VQ: A, AQ: A+]

    http://www.youtube.com/view_play_list?p=58747E74B6D87532

    Punch, Scent, Burn That Bridge, Weigh, Beauty of My Dreams, Gone, Wilson, Meatstick Madness

    NYE Run: Tyler Curtis Reviews 1/1/2011 [Tri-State Indie]

    January 10, 2011

    Phish: 0619Sean MSG Video Playlist [VQ: A-, AQ: A+, CK5]

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

    AC/DC Bag, Burn That Bridge, Sneakin’ Sally, Gotta Jibboo, Twist, Reba, Makisupa Policeman, My Soul, Tube

    NYE Run: NYE Run Summed Up [Online Phish Tour]

    Reviews: Phish @ MSG 01/01/2011 by Charlie Dirksen [Jambands]

    Phish: PlatoPlates MSG Run Video Playlist [VQ: B, AQ: B+]

    http://www.youtube.com/view_play_list?p=8AC40A2F766B1240

    Guelah Papyrus, Runaway Jim, My Soul, Piper > Free, YEM -> Manteca -> YEM, Down With Disease -> Ghost, Wilson -> 46 Days, Gone, Beauty of My Dreams, Burn That Bridge, Moma Dance, PYITE, Meatstick > Auld Lang Syne > After Midnight

    January 3, 2011

    Phish: 01/01/2011 MKDevo Playlist [VQ: A, AQ: A+, Angle: CK5]

    http://www.youtube.com/view_play_list?p=25A44158DA163CB2

    My Soul, Crosseyed and Painless, Twist, Simple, Sneakin’ Sally, Makisupa Policeman, David Bowie, Fee

    NYE Run: Phish Celebrates 2011 With A Bang [Consequence of Sound]

    Phish: 12/31/2010 Meatstick [OFFICIAL VIDEO, VQ: A+, AQ: A+]

    Phish: 01/01/2011 LivePhish SBD New York, NY

    Phish: 01/01/2011 First Set and Some of Second Set Playlist – HarpuaFSB [VQ: A, AQ: A+]

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

    Phish: 12/31/2010 ENTIRE SHOW HarpuaFSB Playlist [VQ: A, AQ: A+]

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

    Phish: 01/01/2011 DAUD New York, NY

    Phish: 12/30/2010  HarpuaFSB ENTIRE SHOW Playlist [VQ: A, AQ: A+]

    http://www.youtube.com/view_play_list?p=1CA00BB2ACE160A2

    January 1, 2011

    NYE: Phish Revives New Year’s Stunt at MSG [Jambands]

    Phish: 12/31/2010 LivePhish SBD New York, NY

    Phish: 12/31/2010 DAUD New York, NY

    December 31, 2010

    Phish: 12/30/2010 LivePhish SBD New York, NY

    MSG1: Energy Cranked to 11 [OPT]

    Phish: 12/30/2010 Fat Man In The Bathtub [VQ: A-, AQ: B+]

    YouTube Preview Image

    MSG1: Opening Night For Phish @ MSG [Jambands]

    Phish: 12/30/2010 Camel Walk [VQ: A-, AQ: A-]

    YouTube Preview Image

    Phish: 12/30/2010 DAUD New York, NY

    MSG1: Webcast Review [Concert Confessions]

    December 27, 2010

    Phish: 12/29/1998 Boogie On Reggae Woman [VQ: B, AQ: B]

    YouTube Preview Image

    December 22, 2010

    Phish: 12/29/1997 DAUD New Source NYC, NY

    November 29, 2010

    Phish: 05/23/2000 Hard Rock Live Playlist [VQ: A, AQ: A+, TV]

    http://www.youtube.com/view_play_list?p=2E10ACA7A3C94BBC

    AC/DC Bag, Wilson, First Tube, Ya Mar, Mike’s, Simple, It’s Ice, When The Circus Comes, Back On The Train, Gotta Jibboo, Taste, Sleeping Monkey, Punch You In The Eye, Twist, Waste, Piper, You Enjoy Myself, Run Like An Antelope, Train Song, Bug, Boogie On -> Cavern

    November 16, 2010

    Cactus: Mike Gordon Mossery Event 10/18/2010 DAUD NYC, NY

    October 19, 2010

    Mike Gordon: Various Videos From The Mossery

    YouTube Preview Image YouTube Preview Image YouTube Preview Image YouTube Preview Image

    October 8, 2010

    Phish: 12/31/1995 The Sloth [VQ: B+, AQ: B+]

    YouTube Preview Image

    October 3, 2010

    Page, Trey and Fish: Dude of Life 02/05/1994 DAUD UNCIRCULATED New York, NY

    Taper Scott Bernstein shares an uncirculated recording of the Dude of Life at the Wetlands in 1994. At this show the Dude was joined by Trey on guitar, Fish on drums and even Page for a few songs on keys. As with all of Scott’s recordings, this sounds great. – ScottyB

    August 27, 2010

    Trey & Page: Allman Brothers  03/12/2009 I Know You Rider [VQ: A-, AQ: A-]

    YouTube Preview Image

    August 16, 2010

    Phish: 12/30/1995 DAUD NEW SOURCE NYC, NY

    July 16, 2010

    Phish: 12/04/2009 Mike’s Song [VQ: B-, AQ: B-, CK5]

    YouTube Preview Image

    July 2, 2010

    Phish: 10/22/1996 DAUD UNCIRCULATED New York, NY

    June 2, 2010

    Phish: 05/23/2000 First Tube [VQ: B-, AQ: B+]

    YouTube Preview Image

    May 24, 2010

    Phish: 05/23/2000 SBD / MATRIX / SOUNDCHECK New York, NY