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

    TAB RSS

    August 14, 2012

    Big Red: Trey Anastasio Fall Tour and New Album Announced

    March 23, 2012

    TAB: Help Fund Natalie Cressman’s Fantastic New Album [Kickstarter]

    March 5, 2012

    Trey Anastasio: TAB 10/12/2011 Liquid Time [VQ: A, AQ: A]

    YouTube Preview Image

    February 17, 2012

    Trey Anastasio: TAB 05/08/2004 UNCIRCULATED SBD Stowe, VT

    January 29, 2012

    Trey Anastasio: TAB 08/05/2001 New Source Saratoga Springs, NY

    January 26, 2012

    Trey Anastasio: TAB 06/23/2002 Playlist [VQ: A, AQ: A+, Pro-Shot]

    Sand (Pt. 1 and Pt. 2), Last Tube (Pt. 1 and Pt. 2), MLC, Drifting, Cayman Review, Mozambique, Alive Again, Speech, Wilson, Bathtub Gin, Mr. Completely (Pt. 1 and Pt. 2), Night Speaks To A Woman (Pt. 1, Pt. 2 and Pt. 3)

    December 13, 2011

    Trey Anastasio: TAB 11/11/2011 First Tube, Black Dog [VQ: B, AQ: A+]

    YouTube Preview Image

    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

    November 12, 2011

    Trey Anastasio: TAB 11/11/2011 DAUD Atlanta, GA

    Trey Anastasio: TAB 11/11/2011 Devil Went Down to Georgia [VQ: B-, AQ: C+]

    YouTube Preview Image

    Trey Anastasio: TAB 11/11/2011 Setlist – Atlanta, GA [Phish.net]

    Trey Anastasio: TAB 11/11/2011 Burn The Bridge [VQ: B+, AQ: B+]

    YouTube Preview Image

    November 9, 2011

    Trey Anastasio: TAB 10/13/2011 3-Source AUD Matrix Silver Spring, MD

    November 8, 2011

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

    YouTube Preview Image

    TAB: Jennifer Hartswick Is In Studio with Trey Anastasio, Too [Jambands.com]

    October 27, 2011

    Trey Anastasio: TAB 10/12/2011 Ocelot [VQ: A, AQ: A+]

    YouTube Preview Image

    October 22, 2011

    Songs: TAB Song History – Land of Nod [Phish.net]

    October 21, 2011

    Trey Anastasio: TAB 10/12/2011 Magilla [VQ: A, AQ: A+]

    YouTube Preview Image

    October 20, 2011

    Trey Anastasio: TAB 10/12/2011 Pigtail [VQ: A, AQ: A+]

    YouTube Preview Image

    Editorials: Pop The TAB and Drink It Up [Hidden Track]

    Funny how often the best things in the world of Phish and the Trey Anastasio Band, affectionately known as TAB, simply go unnoticed. In chatting this past weekend with Hidden Track Editor extraordinaire, Scott Bernstein, about HT’s 5th Anniversary and the 1st of Postcards From Page Side, we were both scratching our heads on the lack of TAB coverage from this mini-tour that just wrapped up, making this week’s column a no-brainer as to what to cover. I caught one TAB show this tour, on the eve of my 31st Birthday, with a large crew of friends at Montclair, New Jersey’s Wellmont Theatre.

    Trey Anastasio: TAB 10/13/2011 LivePhish SBD Silver Springs, MD

    Songs: TAB Song History – Dragonfly [Phish.net]

    Songs: TAB Song History- Chapeau Mauvais [Phish.net]

    October 18, 2011

    Trey Anastasio: TAB 10/12/2011 Plasma [VQ: A, AQ: A+]

    YouTube Preview Image

    October 17, 2011

    Trey Anastasio: TAB 10/12/2011 Shine [VQ: A, AQ: A+]

    YouTube Preview Image

    Trey Anastasio: TAB 10/12/2011 Small Axe [VQ: A, AQ: A+]

    YouTube Preview Image

    October 16, 2011

    Trey Anastasio: TAB 10/15/2011 Charlottesville Setlist [Phish.net]

    Trey Anastasio: TAB 10/15/2011 Sand [VQ: B-, AQ: B]

    YouTube Preview Image

    Trey Anastasio: TAB 10/15/2011 FOB Charlottesville, VA

    Trey Anastasio: TAB 10/12/2011 LivePhish SBD Montclair, NJ

    Trey Anastasio: TAB 10/13/2011 Playlist [VQ: Varies, AQ: B-]

    Devil Went Down to Georgia, Black Dog, Valentine, Pigtail, First Tube, Sultans of Swing, Heavy Things

    Trey Anastasio: TAB 10/14/2011 Money Love and Change [VQ: B, AQ: B]

    YouTube Preview Image

    Trey Anastasio: TAB 10/14/2011 DAUD Charlotte, NC

    Trey Anastasio: TAB 10/14/2011 Let Me Lie [VQ: B-, AQ: C+]

    YouTube Preview Image

    Trey Anastasio: TAB 10/14/2011 Charlotte Setlist [Phish.net]

    Trey Anastasio: TAB 10/13/2011 Mookiesk8ter Playlist [VQ: B+, AQ: B]

    Push On Till The Day, Liquid Time, First Tube

    October 14, 2011

    Trey Anastasio: TAB 10/13/2011 Silver Springs, MD Setlist [Phish.net]

    Trey Anastasio: TAB 10/12/2011 Ooh Child [VQ: A, AQ: B-]

    YouTube Preview Image

    In memory of Ricky Bell

    Trey Anastasio: TAB 10/12/2011 Small Axe [VQ: A-, AQ: B+]

    YouTube Preview Image

    Trey Anastasio: TAB 10/12/2011 Sultans of Swing [VQ: B+, AQ: B]

    YouTube Preview Image

    Trey Anastasio: TAB 10/12/2011 Black Dog [VQ: C+, AQ: C+]

    YouTube Preview Image

    Trey Anastasio: TAB 10/12/2011 First Tube [VQ: C, AQ: C+]

    YouTube Preview Image

    Trey Anastasio: TAB 10/12/2011 Setlist – Montclair, NJ [Phish.net]

    October 12, 2011

    Trey Anastasio: TAB 10/07/2011 LivePhish SBD Myrtle Beach, SC

    October 11, 2011

    Trey Anastasio: Trey’s New Songs [Phish Thoughts]

    Trey Anastasio: TAB 10/07/2011 Pigtail [VQ: A-, AQ: A-]

    YouTube Preview Image

    Trey Anastasio: TAB 10/07/2011 Black Dog [VQ: B+, AQ: B]

    YouTube Preview Image

    October 10, 2011

    Trey Anastasio: TAB 10/08/2011 Playlist [VQ: A-, AQ: B+]

    Clint Eastwood, Devil Went Down to Georgia, Money Love and Change, Sand, Magilla, Land of Nod

    October 9, 2011

    Trey Anastasio: TAB 10/08/2011 Baltimore Setlist [Phish.net]

    Trey Anastasio: TAB 10/08/2011 Land of Nod [VQ: A, AQ: B+]

    YouTube Preview Image

    Trey Anastasio: TAB 10/08/2011 DAUD Baltimore, MD

    Trey Anastasio: TAB 10/07/2011 Push On Til The Day [VQ: B, AQ: C]

    YouTube Preview Image

    Trey Anastasio: TAB 10/06/2011 Frost [VQ: C+, AQ: B+]

    YouTube Preview Image