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

    Classic TAB RSS

    February 19, 2010

    Photos: Picture Show – Trey in Milwaukee [Hidden Track]

    Festivals: Trey Anastasio and Classic TAB Added to the Hangout [Jambands]

    Trey Anastasio and TAB, Ben Harper and Relentless7, Ray LaMontagne, The Funky Meters and The Flaming Lips are among the latest additions to the 2010 Hangout Beach, Music and Arts Festival. These artists join a lineup that already features Zac Brown Band, John Legend, The Black Crowes, Alison Krauss and Union Station Featuring Jerry Douglas, Gov’t Mule, Girl Talk, Guster, Brett Dennen and Keller Williams. As previously reported, the “first ever large-scale music festival on the beach” will take place in Gulf Shores, AL from May 14-16.

    February 18, 2010

    Trey Anastasio: Trey Anastasio & Classic TAB Setlist – Milwaukee 02/18 [Hidden Track]

    Reviews: Trey Anastasio @ Terminal 5 [Earvolution]

    Trey Anastasio: 02/16/2010 Ether Sunday [VQ: A-, AQ: A-]

    YouTube Preview Image YouTube Preview Image

    TAB: Anastasio’s Solo Show to Have Some Surprises [St. Louis Today]

    Reviews: Wrapping Up Trey Anastasio’s Northeast Run [Hidden Track]

    As Trey Anastasio and Classic TAB move on from the Northeast leg of their tour onto the Midwest and South, they have left a trail of happy faces in their path. The “anything can happen at anytime” M.O. that Phish lives and dies with is nowhere to be found on TAB Tour, alleviating all the pressure that comes with Phish shows for Trey Anastasio. Big Red and his bandmates are clearly having fun and the happiness is contagious.

    Trey Anastasio: 02/16/2010 Black Dog [VQ: A, AQ: A-]

    YouTube Preview Image

    Trey Anastasio: 02/16/2010 Mozambique [VQ: B, AQ: B]

    YouTube Preview Image

    Trey Anastasio: 02/16/2010 Liquid Time [VQ: B+, AQ: B+]

    YouTube Preview Image

    February 17, 2010

    Trey Anastasio: Trey and Classic TAB @ Terminal 5 Setlist [Hidden Track]

    Reviews: Trey and TAB Light Up NYC [Whatever You Do]

    Trey Anastasio: 02/12/2010 Sand [VQ: B, AQ: A]

    YouTube Preview Image YouTube Preview Image

    Trey Anastasio: 02/16/2010 Magilla [VQ: B+, AQ: B]

    YouTube Preview Image

    Trey Anastasio: 02/12/2010 FOB Boston, MA

    Trey Anastasio: 02/12/2010 Gotta Jibboo [VQ: B, AQ: B]

    YouTube Preview Image

    Trey Anastasio: 02/14/2010 Sultan’s of Swing [VQ: A-, AQ: A-]

    YouTube Preview Image

    February 16, 2010

    Trey Anastasio: 02/12/2010 Valentine [VQ: A, AQ: A-]

    YouTube Preview Image

    Photos: Trey Anastasio @ the Electric Factory [Glide Magazine]

    [Photo by Eva Nowakowski]

    Trey Anastasio: 02/14/2010 Sand [VQ: B, AQ: B]

    YouTube Preview Image

    Trey Anastasio: 02/14/2010 Drifting [VQ: B+, AQ: B]

    YouTube Preview Image

    Trey Anastasio: 02/14/2010 Sweet and Dandy [VQ: B, AQ: B]

    YouTube Preview Image

    Trey Anastasio: 02/14/2010 Push On [VQ: B, AQ: B]

    YouTube Preview Image

    February 15, 2010

    Trey Anastasio: 02/14/2010 Gotta Jibboo [VQ: A-, AQ: B+]

    YouTube Preview Image

    Trey Anastasio: 02/14/2010 DAUD Red Bank, NJ

    Reviews: Classic Trey Anastasio Band Re-Energized at Oakdale [Hartford Courant]

    What a delightful difference the addition of a horn section can make to a band. The Classic Trey Anastasio Band (TAB), a side project for the Phish guitarist, returned to the Oakdale Theatre in Wallingford Saturday night. When the quartet — sans the horns — last performed at the venue in October 2008, it was an uninspired, mellow affair. As a septet, the performance was rhythmic, funky and full of energy.

    Trey Anastasio: 02/12/2010 The Birdwatcher [VQ: B-, AQ: B]

    YouTube Preview Image

    Trey Anastasio: 02/13/2010 FOB Wallingford, CT

    Trey Anastasio: 02/14/2010 First Tube [VQ: A-, AQ: B+]

    YouTube Preview Image

    Reviews: Trey Anastasio w/ Classic TAB [My Fox Boston]

    Trey Anastasio: 02/12/2010 FOB Boston, MA

    Trey Anastasio: 02/11/2010 Push On Till The Day [VQ: B+, AQ: B+]

    YouTube Preview Image

    February 14, 2010

    Follow @YEMblog For Live Reports and the Setlist From Trey in Red Bank

    Reviews: Trey and Classic TAB in Boston [Hidden Track]

    Just across the street from Fenway Park, where Trey and Phish kicked off a long-anticipated summer tour last year, Trey and Classic TAB got down to business at Boston’s House of Blues. Coming on a little after 8:30 PM, Trey and company kicked off with the newly-arranged Shine. The brass intro foreshadowed what would be the defining element of the night, TAB’s featured three-piece horn section. The lighting went perfectly with the lyrics, with blazing yellows and whites flooding the room as Trey and the audience echoed the chorus. A bouncy and funky Cayman Review followed, with Trey bouncing up and jumping around, pointing to various fans in the audience.

    Trey Anastasio: Trey and Classic TAB in Wallingford Setlist [Hidden Track]

    February 12, 2010

    Trey Anastasio: 02/12/2009 Boston Classic TAB Setlist [Hidden Track]

    Trey Anastasio: 02/08/2010 Show of Live [VQ: A, AQ: A-]

    YouTube Preview Image

    Previews: Trey and Classic TAB Come to the Pabst [OnMilwaukee]

    February 11, 2010

    Trey Anastasio: Trey Anastasio and Classic TAB @ Philadelphia – Setlist [Hidden Track]

    Trey Anastasio: 02/08/2010 Birdwatcher [VQ: A, AQ: A-]

    YouTube Preview Image

    Trey Anastasio: The Horns of Trey 2010 [Phish Thoughts]

    These horn players have often laid back at the beginning of groovier songs (e.g. “Sand,”and “Jibboo”), allowing the four-piece to chug away, while Trey leads the troops out with his six-string wizardry. Gradually they have oozed into these jams, first providing sonic backdrops, and then engaging Trey and Ray in more earnest improvisation.

    Trey Anastasio: 02/09/2010 Burlap Sack and Pumps [VQ: B+, AQ: B]

    YouTube Preview Image

    Trey Anastasio: 02/09/2010 Tube Top Flop [VQ: B+, AQ: B+]

    YouTube Preview Image

    Trey Anastasio: 02/09/2010 Money Love & Change [VQ: B+, AQ: B+]

    YouTube Preview Image

    Trey Anastasio: 02/09/2010 Gotta Jibboo [Watch CK5 Work]

    YouTube Preview Image

    February 10, 2010

    Reviews: Trey and Classic TAB @ the Jefferson [The Butter Room]

    Overall, it was clear the band had put in a lot of practice for the opener. It was also evident that they were having a good time. I’m not sure I would have enjoyed the show as much if it wasn’t for the small venue. The last time I saw TAB was in a basketball arena with the horns and it just didn’t have the same vibe. I hope he can continue to play small clubs and theaters so all fans can experience the band up close. If you have a chance to see TAB on this tour, I encourage you to check it out. You won’t be disappointed.

    Trey Anastasio: 02/09/2010 Words to Wanda [VQ: B+, AQ: B+]

    YouTube Preview Image

    Trey Anastasio: 02/08/2010 First Tube [VQ: A-, AQ: B+]

    YouTube Preview Image

    Trey Anastasio: 02/09/2010 DAUD Washington, D.C.

    Trey Anastasio: 02/09/2010 The Way I Feel [VQ: A-, AQ: B+]

    YouTube Preview Image

    Songs: Trey’s Newest Songs [Phish Thoughts]

    “Show of Life“

    The second song that Trey and The Dude wrote over sushi blossomed in the encore as a gorgeous piece that virtually oozes the soul of Phish. With stunning melodies, vocal harmonies, and an overall transcendent feel, “Show of Life” will be an amazing addition to the Phish catalog, and I’d be shocked if it wound up anywhere else. In this version, Trey’s dripping solo blends with a warm canvas of horns, providing a cathartic preview of what could be a summertime anthem. With the embellishment of Phish, this song could become modern classic.

    Songs: Listen to the Four New Classic TAB Tunes [Hidden Track]

    February 9, 2010

    Trey Anastasio: Classic TAB @ 9:30 Club Setlist [Hidden Track]

    Trey Anastasio: All That Almost Was [VQ: A, AQ: A]

    YouTube Preview Image

    Trey Anastasio: 02/08/2010 Drifting [VQ: A-, AQ: B+]

    YouTube Preview Image

    Photos: Trey Anastasio & Classic TAB in Charlottesville [Hidden Track]

    Trey Anastasio: Multiple Debuts, Five Song Encore [Jambands]

    Trey Anastasio: 02/08/2010 DAUD Charlottesville, VA

    February 8, 2010

    Trey Anastasio: Trey and Classic TAB @ Charlottesville – Setlist [Hidden Track]

    Previews: Trey Anastasio & Classic TAB Tour Preview [WelcomeToNow]