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

    Fall Tour RSS

    August 14, 2012

    Big Red: Trey Anastasio Fall Tour and New Album Announced

    September 29, 2011

    Cactus: Mike Gordon Band Tour Dates – Five Fall Shows [Hidden Track]

    August 17, 2011

    TAB: Trey Anastasio Adds Two Dates to Fall Tour [Hidden Track]

    July 26, 2011

    Tour Dates: Trey Anastasio Announces Fall Tour [Hidden Track]

    As Phish gears up to hit the road early next month for the second leg of their summer tour, Trey Anastasio is looking to the fall when he will tour with his Trey Anastasio Band septet. The group will perform at a pair of festivals down in Florida (Langerado and Bear Creek) along with five shows on the East Coast that were announced this morning.

    February 18, 2011

    Remasters: Phish Announces Latest Batch of Remasters [OhKeePah Blog]

    February 8, 2011

    Auctions: Signed Fall Tour Phish Posters [MimiFishmanFoundation]

    December 13, 2010

    Tour Recaps: Phish October Tour In Review [Jambands]

    November 29, 2010

    Fall Tour Jams: Creativity Cometh [Phish Thoughts]

    November 24, 2010

    Highlights: Three More From Fall [Phish Thoughts]

    November 18, 2010

    Tour Highlights: Features of Fall [Phish Thoughts]

    Recordings: The Best Audience Sources For Fall Tour [ListeningRoom]

    November 11, 2010

    Polls: Phish Fall Tour 2010 Survey Results [Hidden Track]

    November 9, 2010

    Tour In Review: The Comeback Has Ended [Phish Thoughts]

    Mixes: You Enjoy My Phall Mix [PhiLEO-Phish]

    October 28, 2010

    Analysis: State of the Fall Tour [Online Phish Tour]

    October 21, 2010

    Podcasts: Type II Cast Episode 2 – Start of Fall Tour [TypeIICast]

    In Episode 2, Steve, Scotty, Justin and Tanya briefly discuss Phish’s sets from Austin City Limits and 4 Mile Canyon Revival before jumping into the first 5 shows of fall tour. We cover The 3 shows in Broomfield, CO and the 2 in Charleston, SC.

    October 18, 2010

    State of the Tour: Fall Tour Update [Online Phish Tour]

    October 15, 2010

    Broomfield: Fall Tour Report – 3 Nights in Colorado [DGB]

    October 7, 2010

    Previews: Phish – Legends of the Fall [Hidden Track]

    Phish kicks off its Fall Tour on October 10 with three gigs at the 1st Bank Center in Broomfield, Colorado and I have to admit I am not quite sure what to expect on several fronts. And there’s something sort of exciting about that. There also something extra special about Phish in the Fall as they have proven throughout the years, including 2009 when they tore apart the Northeast in late-November after a glorious performance of the Rolling Stones’ Exile on Main Street at Festival 8 in Indio, CA.

    Vlogs: WCAX Phish Blogger Talks Fall Tour [WCAX]

    October 4, 2010

    Previews: Fall Tour Forecast [Phish Thoughts]

    September 17, 2010

    Broomfield: Members of Phish to Perform at Boulder Fire Benefit [Hidden Track]

    Phish Fall Tour 2010 just got a little bigger with the announcement that the band members will perform at the 1st Bank Center in Broomfield, CO on October 9. The show is a benefit for the Boulder Mountain Fire Relief Fund with all proceeds going towards that charity. The boys will be joined on the bill by Colorado bands The String Cheese Incident, Big Head Todd & The Monsters, Yonder Mountain String Band and Vince Herman & Drew Emmitt.

    September 14, 2010

    Previews: How Will Fall Tour Compare to Summer Tour? [OPT]

    August 25, 2010

    Analysis: Map of ’09-’10 Tour Dates and Who Gets Fucked [OPT]

    Analysis: Retro Tour – Fall 2010 [Phish Thoughts]

    Broomfield: Phish Expected to Make Big Splash [Daily Camera]

    August 24, 2010

    Fall Tour: Phish Fall Tour 2010 Official [Hidden Track]

    After two scintillating legs of summer touring, Phish has just announced the schedule for Fall Tour 2010. The 15-show tour starts with a headlining set at Austin City Limits and brings them to a number of venues they haven’t played before including the new 1st Bank Center in Broomfield, CO; the Augusta Civic Center in Augusta, ME; the Utica Memorial Auditorium in Utica, NY; the Verizon Wireless Arena in Manchester, NH and Boardwalk Hall in Atlantic City.

    Rumors: Rumors – Fall Tour Dates [Live Music Blog]

    August 22, 2010

    Phish Fall Tour: Phish Books Three October Dates [Denver Post]

    Internet message boards have been busy with rumors of the band’s quick return to the Rockies. Sure enough, Phish is scheduled to play three shows at the 1stBank Center in Broomfield on Oct. 10-12, a source told The Denver Post.

    August 5, 2010

    Rumors: Is Phish Playing Sprint Center in October? [The Pitch]

    August 2, 2010

    Rumors: Trick or Treat or Double Down [Phish Thoughts]

    With the fan community sitting on the precipice of Summer Tour – Part Deux, the rumor mill exploded over the weekend with multiple sources all but confirming Phish in Atlantic City, New Jersey for Halloween 2010.

    August 1, 2010

    Rumors: Phish Fall Tour Dates Rumors [Online Phish Tour]

    July 28, 2010

    Rumors: Phish Fall Tour Rumors [Live Music Blog]

    May 12, 2010

    Rumors: Fall Forecast – Vegas Baby [Phish Thoughts]

    December 21, 2009

    Fall Tour: Miner’s Picks – Fall Tour [Phish Thoughts]

    December 20, 2009

    Weekend Nuggets: An Autumn Assortment [Phish Thoughts]

    December 18, 2009

    Fall Tour: Moments In A Box: Four More From Fall [Phish Thoughts]

    December 17, 2009

    Fall Tour: My Phish 2009 Fall Tour [East Coast Ramblings]

    December 16, 2009

    Fall Tour: Moments in a Box – Fall Tour First Sets [Phish Thoughts]

    December 15, 2009

    Tickets: Designing Phish’s Fall Tour 2009 Tickets [Adam+Company]

    December 11, 2009

    Fall Tour: Dustin’ Them Off – The Bustouts [Phish Thoughts]

    December 9, 2009

    Fall Tour Stats: The Number Line – The Covers [Hidden Track]

    Each day this week we’ll share a new installment of our geekiest column, The Number Line, where we analyze the setlists from Phish’s recently completed Fall Tour. On Monday we examined the Fall Tour one-timers and yesterday we looked at the songs played on the tour by studio album. Today, we’ll look at the covers the quartet performed on the 13-show run.

    December 8, 2009

    Fall Tour: Phish Revisit Exile Moments [Relix]

    December 7, 2009

    Fall Tour Stats: The Number Line – One-Timers [Hidden Track]

    Syracuse: 6 (Beauty Of A Broken heart, Drowned, BBFCM, Tube, Theme From The Bottom, GTBT)
    Philly 1: 6 (Bathtub Gin, Camel Walk, The Curtain With, Twenty Years Later, The Mango Song, Simple)
    Philly 2: 7 (Sugar Shack, Sleep Again, Train Song, Birds Of A Feather, Farmhouse, Esther, Oh! Sweet Nuthin’)

    READ ON for the rest of the Fall Tour one-timers list…

    Fall Tour: Coventry’s Phish Fall Tour Review [Coventry]

    December 6, 2009

    Fall Tour: Phish Fall Tour Wrap Up [Phish&TheDead]

    November 25, 2009

    Fall Tour Recap: Whatever’s In The Water, Keep Drinking It [Phish & the Dead]

    November 19, 2009

    Detroit: Phish Fall Tour Opener Review and Photos [Hidden Track]

    November 18, 2009

    Detroit: 11/18/2009 Phish Fall Tour Opener Setlist [Hidden Track]

    November 17, 2009

    Follow @YEMblog For Live Updates From Every Fall Tour Show

    October 25, 2009

    Tickets: Phish Quickly Selling Out Fall Tour [Spinner]

    October 23, 2009

    Survey: Fall Tour 2009 Phish Tickets Poll [Hidden Track]

    October 9, 2009

    Tour Dates: Phish Fall Tour – Advantage Northeast [Hidden Track]

    11/18/09 – Cobo Arena – Detroit, Michigan
    11/20/09 – US Bank Arena – Cincinnati, Ohio
    11/21/09 – US Bank Arena – Cincinnati, Ohio
    11/22/09 – Onondaga War Memorial, Syracuse, NY
    11/24/09 – Wachovia Center – Philadelphia, PA
    11/25/09 – Wachovia Center – Philadelphia, PA
    11/27/09 – Times Union Center – Albany, NY
    11/28/09 – Times Union Center – Albany, NY
    11/29/09 – Cumberland County Civic Center, Portland, ME
    12/2/09 – Madison Square Garden – New York, NY
    12/3/09 – Madison Square Garden – New York, NY
    12/4/09 – Madison Square Garden – New York, NY
    12/5/09 – John Paul Jones Arena – Charlottesville, VA

    Phish: Fall Tour Announcement

    October 5, 2009

    Rumors: Phish in Albany – Get A Room Close [PhanArt]

    October 4, 2009

    Rumors: More Clues For Phish at Albany on Thanksgiving [Monsterfresh]

    A full list of supposed Fall dates have been circulating around for a while and, although nothing has been officially confirmed with any of them, at least 2 of the dates seem legit.  The screenshot above was taken from the Jillians of Albany website and was discovered by, Phantasytour.com forum member, xPHISHx and pointed out by them in a thread on the site.

    September 23, 2009

    Rumors: Fall Tour Dates [Coventry]

    September 22, 2009

    Rumors: Fall Tour [Phish Thoughts]

    August 23, 2009

    Rumors: Phish Fall Tour and NYE 2009 [Welcome To Now]

    July 12, 2009

    Downloads: Weekend Nuggets – Fall Tour 1995 [Phish Thoughts]