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

    Trey Anastasio RSS

    October 18, 2012

    Interviews: Trey Confirms Phish to Enter The Studio “Pretty Soon”

    August 31, 2012

    Interviews: Audio – Trey Anastasio Talks Setlists, Phish Love and More w/ KBCO [Hidden Track]

    Interviews: Reel Time – Trey Anastsaio Talks Traveler [Relix]

    August 28, 2012

    Big Red: Trey Anastasio Traveler Tracklist Breakdown, Cover Art and Pre-Order

    August 22, 2012

    Big Red: Review – Trey Anastasio Hits A Home Run With Scabbard [Hidden Track]

    August 14, 2012

    Big Red: Trey Anastasio Fall Tour and New Album Announced

    August 7, 2012

    Big Red: Sample New Trey Anastasio Single Scabbard Due August 21

    May 29, 2012

    Big Red: Trey Anastasio’s Big Fall – Musical to Broadway / New Album [Hidden Track]

    May 20, 2012

    Trey Anastasio: Trey Anastasio Band 06/08/2003 Black Dog [VQ: A-, AQ: A-]

    YouTube Preview Image

    May 8, 2012

    Big Red: Trey Throws First Pitch in San Diego and ESPN Has Fun With It [Hidden Track]

    April 18, 2012

    Trey Anastasio: The Inspiration Behind Hands On A Hardbody

    YouTube Preview Image

    March 21, 2012

    Trey: Hands On a Hardbody Ticketing News [La Jolla Playhouse]

    Hands On A Hardbody, the new musical by Pulitzer Prize winner Doug Wright with music by Trey Anastasio and Amanda Green, will debut April 27, 2012 at La Jolla Playhouse in La Jolla, CA and run through June 17, 2012. Beginning now (and through the next 72 hours), tickets for the first two weekends of the run, April 29 and May 4-6, will be available at a special introductory price of $30 with code TRUCK2779. All other performance dates will receive a 20% discount through April 8 with code FAN5752.

    Symphonic Tour: LA Philharmonic Member Talks Trey [Relix]

    March 14, 2012

    Editorial: Mr Miner Ponders If Trey Still Has Reverence For Phish [Phish Thoughts]

    March 13, 2012

    Trey: Concert Recap – Trey Anastasio w/ L.A. Philharmonic [Live Music Blog]

    Trey: Philharmonic at the Phish Bowl [San Francisco Classical Voice]

    Interviews: Joe Alessi of New York Philharmonic on Trey [Phish.net]

    Trey: A Night In The Key of Trey [Phish Thoughts]

    Trey: Trey Anastasio Charms With L.A. Philharmonic [Neon Tommy]

    Rare Photo: Trey Anastasio – Seis De Mayo Outtake [Scott Lenhardt]

    March 11, 2012

    Trey: Trey Anastasio with Los Angeles Philharmonic Review [Hollywood Reporter]

    Trey: Review – Trey Anastasio & L.A. Philharmonic 03/10/12 [Concert Confessions]

    Trey: Review – Trey Anastasio & L.A. Philharmonic – 03/10 [L.A. Weekly]

    Trey Anastasio: Review – Trey Performs with Los Angeles Philharmonic [Rolling Stone]

    March 8, 2012

    Trey Anastasio: Hands On A Hardbody Update [U-T San Diego]

    March 5, 2012

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

    YouTube Preview Image

    March 3, 2012

    Trey Anastasio: Dave and Friends 02/05/2006 Entire Show [VQ: A, AQ: A-, 2-CAM]

    YouTube Preview Image

    Get on the Boat, Good Good Time, Up on Cripple Creek, Grey Blue Eyes, Eh Hee, Will It Go Round in Circles, Iko Iko, So Damn Lucky, Hey Bulldog, Rocky Mountain Way

    March 1, 2012

    Reviews: Trey Anastasio w/ Colorado Symphony Orchestra – 02/28 [Westword Denver]

    Reviews: Trey Anastasio w/ Colorado Symphony Orchestra [L4LM]

    February 24, 2012

    Trey Symphony Tour: Review – Trey and the PSO 2/14/12 [Sunken Treasures]

    February 21, 2012

    Interviews: Trey & Page 05/23/2000 Playlist Features Three Parts

    February 17, 2012

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

    February 15, 2012

    Reviews: Trey and the Steel City Symphony [Online Phish Tour]

    Reviews: Trey Anastasio & PSO Redefine Classical Rock [Post-Gazette]

    February 14, 2012

    Humor: Rules For Tonight’s Trey Orchestral Show Interpreted [Hidden Track]

    Tonight, Phish front man Trey Anastasio continues his first-ever symphonic tour at Heinz Hall in Pittsburgh, where he’ll be backed by the Pittsburgh Symphony Orchestra. PSO staff has been trying to prepare Phish fans by providing an email filled with information about what they can expect at the venue in hopes the crowd won’t be as raucous as those who hooted and hollered at last Thursday’s tour opener. The DJs for Pittsburgh radio station WDVE’s morning show had fun with the email and interpreted it for “hippies.”

    February 13, 2012

    Trey Anastasio: Trey w/ ASO 02/09/2012 Golden Slumbers > Carry That Weight > The End [VQ: A, AQ: A]

    February 10, 2012

    Trey Anastasio: Trey Kicks Off Symphonic Tour in Atlanta [Hidden Track]

    Trey Anastasio: Trey w/ ASO 02/09/2012 You Enjoy Myself [VQ: C-, AQ: B-]

    YouTube Preview Image

    Trey Anastasio: Trey + ASO 02/09/2012 Stash [VQ: A-, AQ: A-]

    YouTube Preview Image

    Symphony Tour: Trey Anastasio w/ Atlanta Symphony Orchestra – Setlist [Phish.net]

    Photos: Trey Anastasio w/ Atlanta Symphony Orchestra [Honest Tune]

    February 9, 2012

    The Past: Trey Anastasio Orchestra – A Brief History [Phish.net]

    Lists: 10 Songs Trey & Symphony Should Play [Hidden Track]

    February 3, 2012

    Trey Anastasio: Chamber Sextet yMusic Recorded With Trey [Hidden Track]

    February 1, 2012

    Trey Anastasio: 70 Volt Parade 08/10/2005 New Source Chicago, IL

    January 31, 2012

    Demos: Adam & Eve by Tom Marshall and Trey Anastasio [Soundcloud]

    We Are Everywhere: Trey Anastasio Featured As Part of Jeopardy “Question”

    YouTube Preview Image

    January 30, 2012

    Trey Anastasio: Trey as a Wedding Singer?

    YouTube Preview Image

    [via OPT Monday Morning Video Pick Me-Up]

    If you have any information on when and where this took place, please leave a comment. – SB

    Mike Gordon + Trey Anastasio: GRAB 06/18/2006 Webcast Footage [VQ: A+, AQ: A+, Pro-Shot]

    YouTube Preview Image

    January 29, 2012

    Songs: Trey Anastasio Tells The Story of Farmhouse [Tom Marshall Soundcloud]

    Trey Anastasio: Oysterhead 10/27/2001 HBO Reverb Footage [VQ: A+, AQ: A+, Pro-Shot]

    YouTube Preview Image

    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 19, 2011

    Photos: Trey Anastasio & Others Joined The National at Beacon [Brooklyn Vegan]

    December 18, 2011

    Trey: Video: The National w/ Trey Anastasio 12/16/2011 – Bloodbuzz Ohio, Murder Me Rachael, Terrible Love (w/ Richard Parry) and Vanderlyle Crybaby Geeks (w/ Richard Parry and My Brightest Diamond) [VQ: C+, AQ: B]

    December 17, 2011

    Trey Anastasio: Trey w/ The National Short Clips

    YouTube Preview Image YouTube Preview Image YouTube Preview Image

    Guest Spots: The National Welcomes Trey Anastasio To The Stage [Relix]

    December 13, 2011

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

    YouTube Preview Image

    December 10, 2011

    Trey Anastasio: Trey Album Update [Jambands.com]

    The members of The National also have deep roots in the Phish world. One of the band’s earliest predecessor, Equinox—which featured future National members Aaron Dessner (guitar), Bryce Dessner (guitar) and Bryan Devendorf (drums)—covered The Allman Brothers and the Grateful Dead and has a sound that saxophonist Kevin Seal described as “Sorta jammy and the product of listening to a lot of Phish and classic rock radio.” Bryan Devendorf and his brother Scott, who play bass and guitar in The National, also took National frontman Matt Berninger—the only non-jam fan in the group—to a Deer Creek Phish show once. As Aaron Dessner recalled on Jambands.com in 2009, “He listened to one song and then went and hid in the car. Matt can still not understand at all how any of us can stomach Phish but pretty much everyone else in the band grew up on their music.”

    December 9, 2011

    Trey Anastasio: Trey Quietly Working on Studio Album With Members of the National [SPIN]

    Since winding up his fall tour, the Phish guitarist has been making a daily commute from his New York City home to Bridgeport, Connecticut’s Tarquin Studios, recording with his band and members of the National and Mates of State for the last month. Peter Katis, who owns the suburban studio and has produced a string of indie rock albums there.