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

    Wantagh RSS

    September 29, 2011

    Phish: 06/02/2009 Possum [VQ: B+, AQ: A]

    YouTube Preview Image

    July 17, 2011

    Phish: 06/28/1995 Entire Show Playlist [VQ: B-, AQ: A-]

    Axilla, Foam, Fast Enough For You, Reba, Punch You In The Eye, Stash, Fluffhead, Chalkdust Torture, Sample In A Jar, Poor Heart, Tweezer, Dave’s Energy Guide, Gumbo, Suzy Greenberg, Harry Hood, Sweet Adeline, While My Guitar Gently Weeps

    September 14, 2010

    Jones Beach: Review – Phish @ Jones Beach [Jambands]

    August 27, 2010

    Phish: 08/18/2010 You Enjoy Myself [VQ: A, AQ: A+]

    YouTube Preview Image YouTube Preview Image

    August 26, 2010

    Phish: 08/18/2010 My Friend, My Friend [VQ: A-, AQ: A+]

    YouTube Preview Image

    August 25, 2010

    Phish: 08/18/2010 Destiny Unbound [VQ: A, AQ: A+]

    YouTube Preview Image

    August 24, 2010

    Phish: 08/18/2010 Tube [VQ: A, AQ: A+]

    YouTube Preview Image

    Phish: 08/18/2010 Guelah Papyrus [VQ: A, AQ: A+]

    YouTube Preview Image

    Jones Beach: Traffic, Rainbows & Jumpers…Oh My [Jambands]

    Phish: 08/18/2010 Down With Disease [VQ: A, AQ: A+]

    YouTube Preview Image

    August 23, 2010

    Phish: 08/17/2010 Walk Away [VQ: B+, AQ: B]

    YouTube Preview Image

    Jones Beach: Review – Phish Rocks Jones Beach [Examiner]

    August 22, 2010

    Phish: 08/18/2010 Complete Show Playlist [VQ: A, AQ: A+]

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

    Phish: 08/17/2010 MKDevo Most of Show Playlist [VQ: A, AQ: A+]

    http://www.youtube.com/view_play_list?p=85AD4B56426EF0DB

    August 20, 2010

    Phish: 08/17/2010 FULL SHOW PLAYLIST [VQ: A, AQ: A-]

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

    Jones Beach Jumper: Phish Fan OK After Leap [NY Post]

    Jones Beach: Final Step of Summer [Phish Thoughts]

    Jones Beach: Wrapping Up Tour With a Bang [AdamHandman]

    August 19, 2010

    Jones Beach: News Channel 12 Report on Jumper [News12]

    Phish: 08/17/2010 Wilson [VQ: A, AQ: A-]

    YouTube Preview Image

    Jones Beach: Jumper Update – Man in Stable Condition [Newsday]

    Phish: 08/17/2010 Funky Bitch [VQ: A, AQ: A-]

    YouTube Preview Image

    Phish: 08/17/2010 Cities [VQ: A, AQ: A-]

    YouTube Preview Image

    Jones Beach: The Predictable Finish [Online Phish Tour]

    Jones Beach: Show Review – Night Two [Coventry]

    Dr. Pauly’s Rules of Tripping:
    1. No one knows you are tripping until you actually tell them.
    2. It’s cold outside — bring a hoodie.
    3. No matter what you think, you CANNOT fly.

    Phish: 08/17/2010 Kill Devil Falls [VQ: A, AQ: A-]

    YouTube Preview Image

    Phish: 08/17/2010 Fluffhead [VQ: A, AQ: A-]

    YouTube Preview Image

    Jones Beach: Phish – Review Night One [Glide Magazine]

    Opening the show with “Fluffhead” certainly set the stage for the ‘anything goes tonight’ mentality, and as the sold-out venue began to frantically fill, it was rather apparent that this wasn’t going to be a random Tuesday filler show.  The anthemic climax brought the crowd to its first collective roar, and though the epic composition was far from perfect, it was free from those sectional train-wrecks Trey Anastasio can sometimes fall victim too.  “Kill Devil Falls,” debuted at last year’s run (by request no less), was a great example of the progress they’ve made since their last visit.  A new arena rocker that nudges at any vice you may be partial to, “KDF” is beginning to breathe, providing Trey another straight-forward, guitar-heavy outro that fits in pretty much any slot.  Compared to the ‘09 version, this was a well oiled machine.

    Jones Beach: Fan Suffers Head Trauma at Phish [Daily News]

    Phish: 08/18/2010 LivePhish SBD Wantagh, NY

    Phish: 08/18/2010 My Friend, My Friend [VQ: A-, AQ: B+]

    YouTube Preview Image

    Phish: 08/18/2010 DAUD Wantagh, NY

    August 18, 2010

    Phish: 08/17/2010 Wilson (w/ Toy Guitar) [VQ: A-, AQ: B+, Angle: CK5]

    YouTube Preview Image

    Phish: 08/17/2010 DAUD Wantagh, NY

    Phish: 08/17/2010 Weekapaug Groove [VQ: B, AQ: B]

    YouTube Preview Image

    Phish: 08/17/2010 LivePhish SBD Wantagh, NY

    Phish: 08/17/2010 Cities [VQ: B+, AQ: B+]

    YouTube Preview Image

    Phish: 08/17/2010 Lengthwise [VQ: C, AQ: C+]

    YouTube Preview Image

    August 10, 2010

    Phish: 06/29/1995 Strange Design [VQ: B+, AQ: B+]

    YouTube Preview Image

    August 8, 2010

    Phish: 06/29/1995 David Bowie [VQ: B+, AQ: B+]

    YouTube Preview Image YouTube Preview Image

    August 5, 2010

    Phish: 06/29/1995 Free [VQ: B+, AQ: A-]

    YouTube Preview Image

    August 4, 2010

    Phish: 06/29/1995 Carolina [VQ: B+, AQ: A-]

    YouTube Preview Image

    August 3, 2010

    Phish: 06/29/1995 Split Open and Melt [VQ: B+, AQ: A-]

    YouTube Preview Image

    August 1, 2010

    Phish: 06/29/1995 Cavern, Rift [VQ: B+, AQ: A-]

    YouTube Preview Image

    Phish: 06/29/1995 Simple [VQ: B, AQ: A-]

    YouTube Preview Image

    July 30, 2010

    Phish: 06/29/1995 Divided Sky [VQ: B+, AQ: A-]

    YouTube Preview Image YouTube Preview Image

    Phish: 06/29/1995 Horse > Silent [VQ: B+, AQ: A-]

    YouTube Preview Image

    July 28, 2010

    Phish: 06/29/1995 Taste [VQ: A-, AQ: B+]

    YouTube Preview Image

    July 27, 2010

    Phish: 06/29/1995 Runaway Jim [VQ: B+, AQ: A-]

    YouTube Preview Image

    May 15, 2010

    Phish: 07/15/1994 DAUD Wantagh, NY

    February 2, 2010

    Phish: 06/28, 29/1995 DAUD Wantagh, NY

    October 26, 2009

    Mike Gordon & Trey Anastasio: GRAB 07/07/2006 DAUD Wantagh, NY

    August 10, 2009

    Phish: 06/04/2009 Rock and Roll [VQ: B+, AQ: B+]

    YouTube Preview Image

    July 24, 2009

    Phish: 06/04/2009 Dirt [VQ: A, AQ: A]

    YouTube Preview Image

    Phish: 06/04/2009 NICU [VQ: A, AQ: A]

    YouTube Preview Image

    Phish: 06/04/2009 Birds of a Feather [VQ: A, AQ: A]

    YouTube Preview Image

    July 23, 2009

    Phish: 06/04/2009 The Squirming Coil [VQ: A-, AQ: A]

    YouTube Preview Image

    July 22, 2009

    Phish: 06/02/2009 Grind [VQ: A, AQ: A]

    YouTube Preview Image

    July 12, 2009

    Phish: 07/23/1993 FOB Wantagh, NY

    Phish: 07/12/1992 DAUD Wantagh, NY