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

    Summer Tour RSS

    August 19, 2012

    Summer Tour: Phish San Francisco Setlist and The Skinny – Night Three

    June 7, 2012

    Summer Tour: Phish Worcester Setlist and The Skinny – Night One [Hidden Track]

    April 10, 2012

    Venues: Phish Summer Tour 2012 – Leg Two – A Look at the Venues [Hidden Track]

    February 29, 2012

    Tour Dates: Phish Summer Tour 2012 – A Detailed Look at the Venues Phish Will Play [HT]

    September 21, 2011

    Tour Recaps: Phish Summer Tour 2011 Recap – Graph and Stupid Facts [TBP]

    June 27, 2011

    Tour Recaps: Summer Tour So Far – Highlights and Not-So-Highlights [Phish.net]

    In sum? The tour has been pretty good so far. “Phish 3.0” continues. I respectfully disagree with those who think Phish’s music has changed in any meaningful way this year. (Please re-listen to the mid-to-late October 2010 shows, and the NYE run, especially the 1/1/11 MSG show, for perspective.) Trey may be using the Digitech whammy less often, and the sound and light shows may be better, but I don’t hear anything dramatically different, show to show, than what we’ve heard from Phish in the last year. There have not been many debuts, nor have the newer songs (from the album Joy, or otherwise) been played much if at all. But what this tour has arguably lacked in novelty, it has made up for with improvisations like the Bethel2 “GoldenGinTeca,” and the Pine Knob (Clarkston) “Down with Disease,” as well as entertaining setlist calls — many of them thanks to fans bearing signs — including “Daniel Saw the Stone,” “Instant Karma,” “Buried Alive,” “Lonesome Cowboy Bill,” “Icculus,” and “Bike.” The “Bathtub Gins” and “Rebas” from this tour also have been consistently marvelous, and all are worth a listen.

    June 25, 2011

    Surveys: Summer 2011  – Early Summer Tour Thoughts [Google Doc]

    Please take this survey, created after each tour since 2009 by Parker Harrington, so that we can get a good sample size to judge the fanbase’s take on the venues Phish played, the sets the band performed and much more.

    June 8, 2011

    Auctions: Mimi Fishman Foundation Late Summer Phish Auctions [MFF]

    May 27, 2011

    Previews: Summer Is Here – A Personal Account [OPT]

    Previews: Summer Tour Leg One – Preview [Phish Experience]

    May 26, 2011

    Previews: Hidden Track staff Makes Summer Tour Predictions [Hidden Track]

    We wanted to give our staff and our readers a chance to get their predictions for what the tour will bring down “on paper” and then once the tour wraps up on June 19 we’ll see how everybody did. So take a look at our calls and be sure to leave your own predictions in the comments section.

    May 20, 2011

    Previews: 2011 Summer Tour Leg One Preview [Gone Phishin’]

    May 15, 2011

    Mail Order Tickets: Summer Ticket Designs Released [Online Phish Tour]

    May 10, 2011

    Previews: Summer Tour – What Lies Ahead [Online Phish Tour]

    May 3, 2011

    Previews: Phinally, Phish Plays This Month [OPT]

    April 19, 2011

    Previews: One Crazy Summer [Phish Thoughts]

    April 12, 2011

    Tour Dates: Summer Tour & Stages of Grief [Online Phish Tour]

    March 2, 2011

    Previews: Ready For Phish Summer Tour [OPT]

    February 23, 2011

    Summer Tour: Mr. Miner’s Take on Phish’s Summer Tour [Phish Thoughts]

    Summer Tour: Some Thoughts on Summer Tour [OPT]

    September 14, 2010

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

    September 13, 2010

    Downloads: Miner’s Picks – Summer Leg II [Phish Thoughts]

    August 31, 2010

    Interviews: Trey Anastasio Reflects on Summer Tour [Relix]

    You know, we pulled into Merriweather Post Pavilion and we suddenly remembered that there was a song called Walfredo that has a line in it about Merriweather Post Pavilion because we had played with Santana at Merriweather Post Pavilion in like 1991. We’re like “oh, we should learn it.” We get the recording and we learn it backstage and off we go. And that’s a lot of fun, so maybe we do it again.

    August 30, 2010

    Tour Recaps: A Wonderous Glow [Phish Thoughts]

    August 26, 2010

    Lists: Phish Summer Tour – Leg 2: From A to Z [Hidden Track]

    W is for Walls of the Cave – Though it may have taken those in attendance a few moments after Page hit the isolated notes on his baby grand before recognizing this Round Room song, the first performance by 3.0 was warmly welcomed once the band got into it and rocked this out with little signs of rust.

    Summer Tour: Leg II’s Best Jams and Highlights [OPT]

    8/7 Suzy Greenberg, Jam – Whenever Trey starts the Suzy jam back up after playing the song, you know you’re in for a treat.  Last time happening with the epic version from Festival 8 and only happening twice before that (1996, 2000), this version was a bit shorter but wasn’t short on fun–while F8’s stopped completely before launching into the jam, this one had Trey strumming out of the end.  When Fish realized what was up he bust back into the jam.  It’s always refreshing when Trey wants to go for it nowadays.

    August 23, 2010

    Tour Recap: Leg Two – First Impressions [Phish Thoughts]

    Gelling on another level during Alpine’s opening night, and carrying this momentum through the end of tour, Phish proved they are a “force of nature” once again; a musical tsunami that can crush you at any time. With proficiency no longer a hindrance to creativity, Phish’s unbridled enthusiasm and success over the past two weeks point to another peak era on the horizon.

    August 22, 2010

    Summer Tour: The Best of Summer – In Your Words [Live Music Blog]

    Tour Recap: What a Long Strange Tour It’s Been [Online Phish Tour]

    August 5, 2010

    Previews: Wade’s World – Open Door to Classic Tour [Hidden Track]

    The stage is set. The time is now. After an amazing first leg full of as much surprise as there was predictability, The Phish have left the door wide open for a classic second leg which is the same amount of shows as Summer Tour ‘96. The venues alone tell a story worth listening to and they haven’t played a note yet.

    August 3, 2010

    Haikus: Ten Haikus For Leg Two [Phish Thoughts]

    Type two, where are you?

    Once, a nightly ritual

    Now we must chase you.

    July 30, 2010

    Previews: Phish Summer Tour 2010 – Leg 2 [Hidden Track]

    If Phish comes out and continues to kill it, playing their standards with extra awesomeness and sprinkling in well-played bust outs and new covers, they will fill arenas this fall/winter and sheds again next summer. If they come out and resort back to their “standard” approach to shows, they could again see a quick and steady dropoff in interest and ticket sales.

    July 26, 2010

    Downloads: Miner’s Picks – Summer Tour Leg One [Phish Thoughts]

    July 22, 2010

    Requests: Signs, Signs, Everywhere There’s Signs [Phish Thoughts]

    July 21, 2010

    Songs: The Four Tweezers of Tour [Phish Thoughts]

    July 20, 2010

    Lists: The Overall Experience [Phish Thoughts]

    July 14, 2010

    Summer Tour Recap: Phish Summer Tour – In Review [Jambands]

    In fact, Phish’s Summer tour, which is presently on a brief hiatus before it continues in August with three shows at Berkeley’s Greek Theater, has already covered all of the bases that fans have come to expect from Phish on every tour. While no show has been a start-to-finish, hear-at-all-costs shredapulooza, almost every show had something noteworthy. There were huge bust outs, blistering jams, goofy gimmicks, and now-legendary encores.

    July 13, 2010

    Summer Tour: Phanart Recap of Leg One [PhanArt]

    Summer Tour Recap: Thoughts & Moments You’ve Enjoyed [DogGoneBlog]

    As the dust from tour settles, and we prepare for the next run of shows, we have a chance to look back on the highlights from the first leg. While some shows indicated a hesitance to explore extended jams there were many exploratory jaunts that brought us to that place. These moments not only foreshadowed the great possibilities for August, but left us with memories that will stand out in our minds for many years.

    Summer Tour Recap: Cover Flow [Phish Thoughts]

    In a clear effort to freshen up summer setlists, Phish unveiled no less than 10 one-time covers over the 18 shows the season’s opening leg. Placing some innocently within first sets, and others more dramatically within the depths of second halves, the effects of these songs varied from case to case.

    July 12, 2010

    Previews: What Can We Expect After Tour Break? [OnlinePhishTour]

    While Telluride and Greek are sure to be amazing and beautiful shows, both playing to a select core of serious fans, Deer Creek and Alpine Valley are sure to be explosive all-out party shows.  No matter how amazing the Greek > Telluride shows are, I have NO DOUBT that the four DC/Alpine shows are going to be highlights for years.

    Recap: Boy. Man. I Saw It Again [Phish Thoughts]

    July 8, 2010

    Analysis: Phish and the Whale [Phish Thoughts]

    As Phish rebuilt their foundation throughout 2009, their playing retained a sound rooted in the past, without truly pushing  into original territory. By the end of the year, a compact style of jamming emerged in which the band assaulted their audiences with a plethora of musical themes in a short amount of time – in short, musical density. But as we waited through the first six months of 2010, the question lingered of how this style would be applied, or rather, “When would Phish discover a new sound?” Never known for resting on their laurels, Summer 2010′s opening leg seemed ripe for the band to put one foot forward, and sure enough, that’s exactly what they did.

    July 7, 2010

    Analysis: A Look Back – A Macro View [Phish Thoughts]

    July 6, 2010

    Summer Tour 2010: Setlists, Posters, Videos, Audio & Much More [Hidden Track]

    The first leg of Phish Summer Tour 2010 came to a close on Sunday night at the Verizon Wireless Amphitheatre in Alpharetta, GA. We’ll have plenty of recaps of all sorts over the next week, but for now we wanted to present “just the facts.” We’ve put together a list of every setlist (via Phish.net) and have detailed our favorite audio sources, videos, reviews and photo galleries from each of the 18 shows Phish has performed thus far in 2010.

    July 5, 2010

    Surveys: First Leg Summer Tour 2010 [@TMWSIY]

    Let us know what you thought of the first 18 shows of Summer Tour 2010 by clicking the link above and filling out the survey. – ScottyB

    June 25, 2010

    Polls: Grading The First Two Weeks of Phish Tour [Hidden Track]

    June 24, 2010

    Posters: Drymount – Phish Summer Tour Posters [Live Music Blog]

    Summer Tour: Top Places to Watch Phish [SeatGeek]

    June 17, 2010

    Analysis: Come Waste Your Time With Trey [Phish & the Dead]

    So whether it’s just Trey being so excited to be touring with his friends again,  I cant wait to see if this teetotaler, will continue to lead with his mean guitar licks and whale calls…If you listen closely the harmonies they are making are as much vocal as they are musical.  Any night can be anyone’s but up to this point Big Red is back with a vengeance, one that feels 1998 to me.

    Polls: Grading The Start of Phish Tour [Hidden Track]

    June 11, 2010

    Chicago: Phish @ Toyota Park, Chicago – Setlist & Recap [Hidden Track]

    Previews: After Calling It Quits, Phish Regroups [Plain Dealer]

    While the jury is still out on Phish 3.0, the band in its current state is “a lot cleaner” than the previous versions, said Phish expert Ellis Godard, who has seen the group in concert more than 100 times.

    “The music doesn’t get to the edge as much,” said Godard, executive director of the Mockingbird Foundation (a charitable organization of Phish fans), executive editor of “The Phish Companion” and keeper of the FAQ at Phish.net.

    Previews: Today in Not Yesterday (And Will Never Be) [PhishNet]

    Let’s look at Time Turns Elastic. I’ve advocated for Time Turns Elastic before, but let me just highlight some of that here. Those noobs who makes smarmy jokes suggesting TTE is only for pee breaks annoy me. Time Turns Elastic is a musician’s wet dream: I dare you to try to count it out. It’s got definitive sections, much like Fluffhead. It’s got a happy ending jam a segment, like The Arrival. It’s got some fun, warm sections, like Reba. And some tough-to-figure-out, intricate composed sections a la Divided Sky. But for whatever reason, there is a large group that simply doesn’t like this masterpiece.

    June 10, 2010

    Previews: Get Schooled in Phish [Ohio.com]

    Previews: Get Phired Up For Phish in Portsmouth [PilotOnline]

    June 9, 2010

    Lists: 20 Questions For June [Phish Thoughts]

    Visit PhishTwit For Real-Time Reports From Phish Summer Tour

    June 7, 2010

    Previews: Hershey Reels In The Phish [York Daily Record]

    Previews: The Final Countdown [Phish Thoughts]