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"; } } ?> Festival 8 | YEMblog - Page 2

    Festival 8 RSS

    November 5, 2009

    Phish: 10/31/2009 Torn and Frayed [VQ: A-, AQ: B+]

    YouTube Preview Image

    November 4, 2009

    Phish: 10/31/2009 Torn and Frayed [VQ: B-, AQ: B+]

    YouTube Preview Image

    Phish: 10/31/2009 Sign Language to Fluffhead

    YouTube Preview Image

    Phish: 11/01/2009 Sugar Shack [VQ: B+, AQ: B+]

    YouTube Preview Image

    Festival 8: An Open Letter to Phish [The View From Here]

    Phish: Festival 8 From The Archives #3

    Phish: 11/01/2009 Sleep Again [VQ: B-, AQ: B]

    YouTube Preview Image

    November 3, 2009

    Festival 8: Phish Rock Rolling Stones Halloween Costume [LAist]

    hey’ll never top it, and this number in particular found frontman Trey Anastasio’s voice in peak form, hitting notes that had sometimes been beyond his reach in past years. Bassist Mike Gordon and keyboardist Page McConnell shared vocal duty too, but even Sharon Jones was upstaged by drummer Jon Fishman’s earnest so-weird-it’s-good singing on “Sweet Virginia.”

    Festival 8: Phish Pick Fans Up at 8 [LAist]

    In contrast to the sober 40-something guys on stage, the 40,000 revelers here aren’t exactly adhering to a straight-edge lifestyle, but, then again, they’re not the ones getting paid. Phish is back at work, and earning it. Check back Sunday for more on today’s Halloween madness.

    Phish: Festival 8 Slideshow

    YouTube Preview Image

    Festival 8: A Look at Festival 8 [Creative Loafing]

    A concert parable: A Phish fan enters the venue and security guards search him. They find a small bag of marijuana and take it. Bummed, the fan enters the grounds, finds his friend and tells him what happened. His friend produces a California medical marijuana prescription card, walks back to the guard and retrieves the confiscated weed.

    Festival 8: Phish Day 2 Set 3 [Festival Crashers]

    Festival 8: Indio Concert Latest in Phish Legacy [Desert Sun]

    Phish drew between 35,000 and 40,000 people a day to its first solo festival west of the Mississippi. That’s less than the 85,000 people a day who came to its Big Cypress festival in south Florida in 1999, or the 60,000 who attended the It fest in Maine in 2003. But that’s because Phish is an East Coast band.

    And Phish fans are the kind of people this desert should want to have back.

    Phish: 11/01/2009 Talk [VQ: A-, AQ: B+]

    YouTube Preview Image

    Festival 8: 11/01/2009 Review and Photos [JamBase]

    Phish: 11/01/2009 Driver [VQ: A-, AQ: B+]

    YouTube Preview Image

    Phish: 11/01/2009 Heavy Things [VQ: B+, AQ: B+]

    YouTube Preview Image

    Phish: 11/01/2009 Secret Smile [VQ: A-, AQ: B+]

    YouTube Preview Image

    Phish: 11/01/2009 The Wedge [VQ: B+, AQ: B+]

    YouTube Preview Image

    Phish: 11/01/2009 Undermind [VQ: A-, AQ: B+]

    YouTube Preview Image

    Phish: 10/31/2009 Sweet Virginia [VQ: A-, AQ: B+]

    YouTube Preview Image

    Phish: 10/31/2009 Rocks Off, Rip This Joint [VQ: B-, AQ: B+]

    YouTube Preview Image

    Phish: 10/31/2009 Casino Boogie [VQ: B, AQ: B+]

    YouTube Preview Image

    Phish: 10/31/2009 Tumbling Dice [VQ: B, AQ: B+]

    YouTube Preview Image

    Phish: 10/31/2009 Sweet Virginia [VQ: B, AQ: B+]

    YouTube Preview Image

    Phish: 10/31/2009 Happy [VQ: B, AQ: B+]

    YouTube Preview Image

    Phish: Festival 8 Montage

    YouTube Preview Image

    Phish: 11/01/2009 Let Me Lie [VQ: B, AQ: B]

    YouTube Preview Image

    November 2, 2009

    Festival 8: Phish @ Festival 8 Coverage Summary [Hidden Track]

    Festival 8: The Setlists From All Eight Phish Festival 8 Sets [Hidden Track]

    Phish: 10/31/2009 Most of the Acoustic Set [VQ: B, AQ: B+]

    Festival 8: Phish Follow Halloween Show With First Acoustic Set [Rolling Stone]

    Phish: 11/01/2009 LivePhish SBD Indio, CA

    Festival 8: Review – Phish @ Empire Polo Club [Los Angeles Times]

    Indeed, the band’s first night rarely disappointed, with the 26-year veteran delving into its back catalog to render favorites such as “Prince Caspian,” “Wolfman’s Brother,” and “Down With Disease,” with a rubbery danceability — the Polo Field at times looking like a fluorescent wave of bobbing heads, twirling glow sticks and flailing limbs.

    The following afternoon, the band ripped through cuts from its ’90s songbook (typically considered its studio zenith), a thank-you of sorts to longtime fans willing to weather the vicissitudes of a storied saga filled with acrimony, addiction and sundry inconsistencies.

    Phish: 10/31/2009 Shake Your Hips [VQ: B, AQ: B+]

    YouTube Preview Image

    Festival 8: Photos From Phish Festival [New Times]

    Phish: 10/31/2009 Loving Cup [VQ: A-, AQ: B+]

    YouTube Preview Image

    Phish: 10/31/2009 Suzy Greenberg [VQ: B-, AQ: B+]

    YouTube Preview Image

    Festival 8: Phunky Females Go Phishin [Desert Sun]

    Phish: 10/31/2009 Turd On The Run [VQ: B+, AQ: B+]

    YouTube Preview Image

    Phish: 11/01/2009 Schoeps CCM4v’s Indio, CA

    Phish: 10/31/2009 Loving Cup [VQ: B-, AQ: B-]

    YouTube Preview Image

    Festival 8: Best Tweets of the Weekend [Google Spreadsheet]

    Phish: 10/31/2009 Shine A Light [VQ: B, AQ: B+]

    YouTube Preview Image

    Festival 8: Acoustic Set Hooks Phans [Desert Sun]

    On a hot fall afternoon, Phish warmed their fans’ hearts with a mellow set of music and a side of doughnuts.

    The band performed its first acoustic set at any of its eight solo music festivals during the past two decades. And that was one of several firsts for the Vermont jam band.

    Phish: 10/31/2009 Soul Survivor [VQ: B, AQ: B+]

    YouTube Preview Image

    Festival 8: Band Hopes to Do It Again [Desert Sun]

    Before the band’s last encore of the festival, lead singer/guitarist Trey Anastasio made sure to thank the crowd for a “wonderful weekend.” He even had a list of shout-outs.

    “I just wanted to make a point that it takes a whole mountain of people to make something like this happen,” Anastasio said. “I hope we can do it again.”

    And though Deitrich and many others were sad to see Festival 8 come to an end — with an encore of “Tweezer Reprise,” they seemed all content with simply having the memories .

    At least until the next concert.

    Phish: 10/31/2009 Loving Cup [VQ: B, AQ: B]

    YouTube Preview Image

    Festival 8: Review – Phish Acoustic Set @ Festival 8 [Hidden Track]

    The set started with three songs that were staples of Anastasio’s solo acoustic performances -Water In The Sky, Back On The Train and Brian and Robert. Each sounded as if they were written to be played unplugged and early on it was clear the band had spent a considerable amount of time rehearsing. Invisible, a song off Phish bassist’s Mike Gordon Sixty Six Steps release with acoustic guitar legend Leo Kottke, followed with Mike taking the lead vocals as he does on the album.

    Festival 8: Shine A Light – Night Two Review [Jambands]

    So it is fitting that Phish decided to cover the Rolling Stones’ famed double LP Exile on Main Street,a classic rock opus built from a Phishy DNA of blues riffs, country honky-tonk, funky soul and guitar-heavy rock and roll, at a time when the band is actively revisiting and its own canon and reevaluating its legacy.

    Festival 8: Phish Covers Stones’ Exile [UPI]

    Festival 8: Phish Plays First Acoustic Set, Covers Exile [Spinner]

    November 1, 2009

    Festival 8: Official Phish From The Road Photos [Flickr]

    [Photo by C. Taylor Crothers]

    Festival 8: Phish Covers Exile On Main Street [Hidden Track]

    Admittedly, I am not the biggest fan of The Rolling Stones. Certainly don’t hate them, but they’re not at the top of any lists for me. None of that matter when it became clear just a few tunes into set two, Phish’s full performance of Exile On Main Street, that this would be the most tightly performed Phish set in recent history.

    Festival 8: Night Two Setlist [Hidden Track]

    Phish: 10/30/2009 Moma Dance [VQ: B-, AQ: B]

    YouTube Preview Image

    Festival 8: Three Videos of Sign Language Interpreters @ F8 [Hidden Track]

    Phish: 10/30/2009 I Didn’t Know [VQ: B, AQ: B+]

    YouTube Preview Image

    Festival 8: 10/31/2009 Photos [Hidden Track]

    Phish: 10/30/2009 NICU [VQ: B+, AQ: B+]

    YouTube Preview Image