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"; } } ?> Online Phish Tour | YEMblog - Page 2

    Online Phish Tour RSS

    June 23, 2011

    Tour Recaps: In Not-So-Heavy-Rotation – The One-Offs [Online Phish Tour]

    Vultures – 6/11 Merriweather Post – This song has never gotten its due.  Overshadowed by the rest of the tunes that would make up The Story of the Ghost, there have been moments where I felt this song was geared to make a big comeback… but it’s just never cracked the rotation.  I’m not sure why that it is.  This song has everything a Phish song should, strange rhythms, bizarre lyrics, and some peaks that will make you pump your fist.  Here’s hoping Vultures gets better setlist treatment in the future.  Unfortunately, if it hasn’t happened yet… it’s probably not happening.

    June 22, 2011

    Tour Recaps: Leg 1 – I Loved It, How About You? [Online Phish Tour]

    June 21, 2011

    Tour Recaps: In Heavy Rotation [Online Phish Tour]

    Backwards Down the Number Line – 7 appearances in 18 shows (38%)

    Check Out: 5/28 – Bethel Woods, Bethel, NY – Summer tour kicked off with a bang in Bethel, and this 3.0 staple got its biggest workout of the whole summer.  As the tour wore on, BDTNL was used more for the tune’s sing-a-long qualities than its ability to break mold, which is what makes Bethel’s version so refreshing.  Sandwiched between Free and the Makisupa that gave us the “house” meme, this version stretches its legs and proves to be an exercise in improvisation and risk taking, instead of an emergency landing spot for a jam gone awry.  Complete with a Dave’s Energy Guide tease, this version, the first of the summer, becomes the go to version for 2011.

    Also appeared at: 6/1 – Holmdel, 6/5 – Cincinnati, 6/8 – Darien Lake, 6/12 – Merriweather Post, 6/17 – Charlotte, 6/19 – Portsmouth

    June 20, 2011

    Portsmouth: Review – All Good Things Come to An End [Online Phish Tour]

    June 16, 2011

    Alpharetta: All Hits, No Substance – Only Up From Here [OPT]

    June 15, 2011

    Alpharetta: Review – Made-For-TV Phish [Online Phish Tour]

    June 13, 2011

    Columbia: Review – Top Heavy In Maryland [Online Phish Tour]

    Merriweather: Review – Pure Heat [Online Phish Tour]

    Camden: Review – Camden Was a Turd With a Few Raisins [Online Phish Tour]

    June 10, 2011

    Tour Recap: The Feeling I Forgot – “It” Is Back [Online Phish Tour]

    I have gone through the past two years enjoying Phish shows; I was happy they were back and made the best of what I could get.  Now, I am trying to pick my jaw back off the ground; I am hopelessly in love again.

    June 9, 2011

    Darien: Review – Riding The Roller Coaster w/ Phish [OPT]

    The amusement park at Darien Lake Performing Arts Center captures what Phish is all about right now: fun.  You don’t know what’s around the corner.  It could be a 25-minutes Down with Disease or a Smoke on the Water tease at the end of Character Zero.  It could be a jammed-out show, or it could be a relatively jamless show with tons of songs.  Last night’s show was the latter, but as long as Trey keeps playing like this, I’m going to love it.

    Last night’s show was balls-to-the-wall energy with fantastic guitar–the only downside to the show is that there was probably the least amount of flow a concert could possibly have–especially the first set.

    June 8, 2011

    Mansfield: Review – Best of Both Worlds [Online Phish Tour]

    June 6, 2011

    Cincinnati: Phish Goes Heavy On Rock, Light On Jams in Cincinnati [OPT]

    Cuyahoga Falls: High Times in Ohio [Online Phish Tour]

    June 5, 2011

    Cuyahoga Falls: Phish Brings The Steam to Cleveland [Online Phish Tour]

    June 4, 2011

    Clarkston: Phish’s Mojo Returns in Detroit [Online Phish Tour]

    In last night’s Down with Disease, the band picked up where they left off last Saturday night in Bethel, and over the following 25 minutes–which exceeded the length of Wednesday’s Piper, Twist and Ghost combined–they carved out a piece of improvisational history. Coupled with their successes in Bethel last weekend, it is undeniably true that Phish is again a band worth traveling for.

    June 2, 2011

    Holmdel: Holmdel 2 – No Quarter, No Patience [Online Phish Tour]

    June 1, 2011

    Holmdel: Review – Smokin’ Thru Holmdel [Online Phish Tour]

    Bethel: Wookstock ’11 – Three Days of Peace (?) and Music [OPT]

    May 31, 2011

    Lists: 10 Developments From Bethel [Online Phish Tour]

    2. Twelve Minute Kill Devil Falls, Anyone?: What if I told you that Fluffhead and Weekapaug would be two of the worst played tunes of the weekend, that there would be no YEM, Reba, Ghost or Divided Sky…but the shows would still contain some of the best jamming of 3.0? KDF, BOTT, BDTNL and, of course, a resurgent Halley’s were just a few songs that were stretched way past the norm.  The band has apparently put some conscious effort into revitalizing their communication and creativity on stage, and the result is that now anything can truly happen in any song.  Considering this is a trend that has carried over from the end of last tour, don’t expect if to go anywhere soon.

    Bethel: What To Take From The Bethel Run [Online Phish Tour]

    May 30, 2011

    Bethel: That’s A Wrap – Night Three Recap [Online Phish Tour]

    May 29, 2011

    Bethel: Review – Phish’s House [Online Phish Tour]

    May 28, 2011

    Bethel: Recap – Putting The Roots Down [OPT]

    May 27, 2011

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

    May 26, 2011

    Humor / Satire: Coran Capshaw and Wook #17 Debate The State of Phish [OPT]

    May 25, 2011

    Jams: The Key to the Best Jams – Patterns and Themes [Online Phish Tour]

    May 24, 2011

    Previews: State of Phish – The Phans [Online Phish Tour]

    May 20, 2011

    Downloads: Summer Rage Sauce – Texas Heat ’98 [OPT]

    May 19, 2011

    Polls: The State of the Phish [Online Phish Tour]

    May 17, 2011

    Downloads: Show I’ve Never Heard – 11/27/1996 [OPT]

    Giveaways: Live in Utica Contest [Online Phish Tour]

    May 16, 2011

    Sports: Setlist Lineups – Giants (Reprise) [Online Phish Tour]

    May 15, 2011

    Reviews: Review – Live in Utica DVD Box Set [Online Phish Tour]

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

    May 13, 2011

    Downloads: Summer Rage Sauce – Big Cat 2000 [OPT]

    May 10, 2011

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

    May 8, 2011

    Downloads: Summer Rage Sauce – First Night of the Palace ’93 [OPT]

    May 5, 2011

    Lyrics: Shoot You In The Eye [Online Phish Tour]

    May 4, 2011

    Sports: Setlist Lineups – Milwaukee Brewers [Online Phish Tour]

    May 3, 2011

    Previews: Phinally, Phish Plays This Month [OPT]

    Lists: The Elusive Ones [Online Phish Tour]

    May 1, 2011

    Featured Shows: Feel Good, Good About Pierre! [Online Phish Tour]

    April 27, 2011

    Phish & Sports: Setlist Lineups – San Francisco Giants [Online Phish Tour]

    April 26, 2011

    Festivals: Relentless Communicator – My Dirty Little Secret [OPT]

    April 21, 2011

    Sports: Setlist Lineups – Philadelphia Phillies [Online Phish Tour]

    Poster recently had the idea to create what we’re calling a “setlist lineup” to celebrate the beginning of the baseball season. The idea is simple: you take your favorite team’s lineup, and to each player you assign one version of a Phish song played in or near your team’s city that represents that player.

    April 15, 2011

    Editorial: Swim To The Light – Phish and Their Fans [Online Phish Tour]

    April 12, 2011

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

    April 11, 2011

    Tour Dates: Analysis – Additional Dates Finally Released [Online Phish Tour]

    April 9, 2011

    Remembrances: What Happened at Walnut Creek 2003? [OPT]

    April 5, 2011

    Remembrances: Island Tour Memories [Online Phish Tour]

    April 1, 2011

    Debates: August ’93 vs. November 1994 [Online Phish Tour]

    Following a recent twitter conversation about Phish’s peak era – which I’d link to if twitter’s search functionality were, um, existent – Poster Nutbag and I got to talking about which month represented the band’s creative apex. We both agreed that it’s silly to talk about a single peak of their career because, like a camel or many a Fall ’94 Hood, they’ve got multiple peaks. But for the purposes of this Tangle, we each chose to write about a month that stands among the greats.

    Satire: Watkins To End Summer Touring [Online Phish Tour]

    Downloads: Summer Rage Sauce – Va Beach ’98 [OPT]

    March 30, 2011

    Opinions: You and Me and Trey [Online Phish Tour]

    March 26, 2011

    Downloads: A Get Down For The Melt Down [OPT]

    March 24, 2011

    Debates: Is Trey The Weak Link? [Online Phish Tour]

    March 23, 2011

    Songs: Embrace The Dark Side [Online Phish Tour]

    March 22, 2011

    Lists: Five Songs For Spring [Online Phish Tour]

    March 18, 2011

    Lyrical Analysis: It’s Not My Fault [Online Phish Tour]