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

    Phish Thoughts RSS

    August 10, 2011

    Tahoe: Left In The Now, With A Wonderous Glow [Phish Thoughts]

    Phish continued their romp through the Wild West last night in Lake Tahoe with another standout second set, a solid first, and another psychedelic monstrosity for the record books. Following their opening night “Rock and Roll”—a musical journey of instant legend—Phish dove head first into another alternate reality last night in the centerpiece of the show—“Light.” Driven by Mike’s mind-bending bass leads, the band trekked far off the grid in a completely groundbreaking, next-generation piece of Phish. With plenty of other standout music to support this excursion into the unknown, the first night of Tahoe showcased the band’s creative edge, while it making four straight bangers out West for the hottest band on the planet.

    August 9, 2011

    Hollywood Bowl: Review – California Dreamin’ [Phish Thoughts]

    August 8, 2011

    Analysis: Gazing Into The Gorge [Phish Thoughts]

    August 7, 2011

    The Gorge: Review – Dancing On The Alter [Phish Thoughts]

    August 6, 2011

    The Gorge: Review – A Stunner to Start Off [Phish Thoughts]

    August 3, 2011

    Opinions: The Influence of Webcasts [Phish Thoughts]

    Phish announced yesterday that they will be webcasting their two sold-out shows from Lake Tahoe on Monday and Tuesday next week. Fans from across the nation—and the world—will be able to tune in for the twin bill for only $24.99, exponentially increasing the 7,000 person audience with a virtual cast of thousands. But is this a good thing for the integrity of the show? Does a show being webcasted alter the band’s performance? Does it change the way Trey arranges the setlist in his mind? Maybe so, maybe not.

    August 2, 2011

    Jam Styles: A Jamming Diversity [Phish Thoughts]

    August 1, 2011

    Previews: Getting Ready For The Gorge [Phish Thoughts]

    Wide-Open Improvisation—During June and Super Ball, Phish’s improvisational prowess truly defined their music for the first time this era. This summer has carried the feeling of an arrival; a culmination of the last two years. With the band finally able to visit enchanting music planes regularly, what better place to kick off leg two than the Gorge? A venue that is virtually synonymous with patient, open jamming, the Gorge has brought out the best in Phish throughout their career and will provide an engaging backdrop for the beginning of the summer’s final twelve shows. Ever since the band’s inaugural visit to George, Washington, in 1997, they have played exclusively top-notch shows amidst the amphitheatre’s stunning surroundings. And with Phish coming off a fire-filled festival that was littered with innovative jams, one can only expect Phish to continue pushing new musical frontiers.

    July 26, 2011

    Camden: Highlights – Combing Through Camden [Phish Thoughts]

    July 25, 2011

    Watkins Glen: A Spectacular Set [Phish Thoughts]

    July 22, 2011

    Clarkston: A Disease Supreme [Phish Thoughts]

    Highlights: Moments In A Box – Jams of June III [Phish Thoughts]

    July 20, 2011

    Highlights: Moments In A Box – June 2011 Pt. 2 [Phish Thoughts]

    July 19, 2011

    Mansfield Rock and Roll: Shakin’ It To That Fine Fine Music [Phish Thoughts]

    July 18, 2011

    Highlights: Moments In A Box – June 2011 [Phish Thoughts]

    July 13, 2011

    Watkins Glen: Review – The Storage Jam [Phish Thoughts]

    July 12, 2011

    Watkins Glen: Highlights – Parts of a Whole [Phish Thoughts]

    July 11, 2011

    Watkins Glen: Third Set Thunder [Phish Thoughts]

    Of all the stellar musical sequences that took place over Super Ball weekend, the opening segment of Saturday night’s third set—”Golden Age” > “Caspian” > “Piper” > “Tweezer”—represents one of the improvisational best. Combining four flowing and creative pieces, the band kicked off the nighttime festivities with a run of music that showcased a broad spectrum of their styles while blowing just about everyone out of the water.

    July 8, 2011

    Watkins Glen: Ballin’ From All Angles [Phish Thoughts]

    As Phish slayed everything in their path during Super Ball weekend, one of the most encouraging qualities to their playing was the diversity of musical directions that their jams encompassed. Proving to be masters of many domains, the band annihilated a variety of musical textures with abandon, illustrating their teeming creativity of the moment. Regardless of what musical style Phish navigated, the common denominator was overwhelming success. The band never got lost amidst their jams and always carried a strong sense of cohesion and intent behind their interplay. Bursting with creativity and confidence like never before in this era, Phish took a huge step forward with their playing at Super Ball. Drenched in diverse jamming, Phish’s ninth festival showcased the band’s  full spectrum of improvisational territory over the course of three days.

    Watkins Glen: Super Ball – An Instant Classic [Phish Thoughts]

    June 27, 2011

    Watkins Glen: A Small Ball? [Phish Thoughts]

    June 23, 2011

    Tour Recaps: The Dawn of a New Era [Phish Thoughts]

    June 20, 2011

    Portsmouth: Review – Equitable Exchanges [Phish Thoughts]

    Phish punctuated their opening leg of summer with a tour-closing show at nTelos Pavilion that displayed musical dominance from beginning to end. Everything the band touched turned to gold last night, as they greeted the intimate audience with a plethora of four-part conversations in a show whose improvisational creativity and quality song selection never stopped. Finishing tour with a stellar three-night finale, the band left everyone in Portsmouth, Virginia, with a night of top-level playing and outstanding exchanges in a show that flowed beautifully from start to finish.

    June 19, 2011

    Raleigh: No Flow But Good To Go [Phish Thoughts]

    June 18, 2011

    Charlotte: Review – And It Was Alright [Phish Thoughts]

    June 16, 2011

    Alpharetta: Review – Energy Without An Edge [Phish Thoughts]

    June 15, 2011

    Alpharetta: Review – Online in Atlanta [Phish Thoughts]

    June 13, 2011

    Columbia: Review – A Safe Sunday Smoker [Phish Thoughts]

    Columbia: Review – A Merriweather Massacre [Phish Thoughts]

    June 11, 2011

    Camden: An Odd Night In Jersey [Phish Thoughts]

    June 9, 2011

    Darien: Review – The Age of Miracles [Phish Thoughts]

    June 8, 2011

    Mansfield: A Rock and Roll Adventure [Phish Thoughts]

    June 6, 2011

    Cincinnati: Review – Crushing Cincinnati [Phish Thoughts]

    Powerhouse Phish shows come in the form of two outstanding sets—start to finish beasts that never let up for a moment. On Sunday night in Cincinnati, to close out their miniature Midwest swing, the band dropped a powerhouse Phish show. Composing their performance in halves and following the path of the summer sun, the band focused on lighter songs with uplifting jamming in the first set, while using darker-themed songs and improv to craft an intense second set journey upon nightfall. And both halves were phenomenal, with only one hiccup throughout, as Phish put on a Sunday night showcase at Riverbend Music Center.

    June 5, 2011

    Cuyahoga Falls: Review – Blowin Off Steam [Phish Thoughts]

    June 4, 2011

    Clarkston: Opening Another Door [Phish Thoughts]

    Honestly, Phish is now beginning to reach place I believed they could reach all along. That is why I’ve been at this blog, trying to capture the process of getting to now; to a place where Phish weaves magical journeys that sweep us away into alternate realities—regardless of any substances. Utterly overwhelming in every sense of the word, the fact that Phish is playing at this level at this stage of the game is why we all believed in them and supported them through the past couple years, and why, when tasting that elusive magic in spurts throughout ’09 and ’10, we kept coming back. Because we knew that one day we’d reach now. And, god damn, it gives me goosebumps to even write that.

    June 2, 2011

    Holmdel: Close The Door Put Out The Light [Phish Thoughts]

    June 1, 2011

    Holmdel: Back Into Deep Waters [Phish Thoughts]

    May 31, 2011

    Bethel: Basking In Bethel’s Blowout [Phish Thoughts]

    Phish had that invincible feeling again over the Bethel run; that sense that bullets would bounce off their musical armor like Lilliputians’ attacking Gulliver. And even though the third night’s affair strayed a bit towards the seemingly-fading song-based trend of this era, the show was still strewn with impressive musical conversations. Throw in a bit of staccato, plinko-funk jamming, and from every angle possible, Bethel was an overwhelming triumph for the band and their dedicated fan base.

    May 30, 2011

    Bethel: Safe On Sunday [Phish Thoughts]

    May 29, 2011

    Bethel: Review – A Total Transformation [Phish Thoughts]

    So let’s be serious here…what the fuck is going on? Where are we? What year is this? Because last night was as good as Phish has sounded in memory. Taking risks throughout both sets like a band we once knew—and have become staggeringly intimate with over the past two nights—Phish let us in on a secret: they are as good, if not better, than at any point in their career.

    May 28, 2011

    Bethel: Review – Whoa…A Serious Tour Opener [Phish Thoughts]

    May 19, 2011

    Contests: Live in Utica Giveaway – Past Venue Compilation [Phish Thoughts]

    May 16, 2011

    Previews: What Might Bethel Bring? [Phish Thoughts]

    May 11, 2011

    Previews: Where Is Phish Heading? [Phish Thoughts]

    So Phish can jam again. I think we call can agree on that, though the frequency of such excursions leaves something to be desired. But further than that, what I’d like to see develop this summer is a newstyle of jamming—a new context in which to take risks. Now that things are back to where they need to be, its high time the band hone in on a style and begin to explore it.

    May 4, 2011

    Songs: Many Sides of Simple [Phish Thoughts]

    Though the song, traditionally, provided a bridge within “Mike’s Groove” while also appearing as a standalone piece, its jam truly came-of-age in 1996, transforming “Simple” into a legitimate vehicle for improvisation. And throughout the band’s career, “Simple” jams have veered every sort of sonic pathways. From mellifluous to sinister and from rocking to ambient, “Simple” is a song that has spanned the band’s musical spectrum.

    May 3, 2011

    Live in Utica: A Utica Preview [Phish Thoughts]

    May 1, 2011

    Contenders For Best First Set Jam: First Set Fire [Phish Thoughts]

    April 26, 2011

    Songs: Pronouncing It In Several Ways – Twist [Phish Thoughts]

    Though Phish has many protean songs whose jams reach differing musical realms, few launchpads hold such diverse possibilities as “Twist” every time out. Since the song debuted in Dublin to kick off Summer ’97, “Twist” jams have never held a predestined path, while leading the band into many different musical pastures. Covering all ground, from groove to ambient soundscapes and rock and roll to avant-garde quasi-jazz escapades, “Twist” has always featured dips into the musical unknown. The versatility of the song is clearly illustrated when looking at some of the seminal (and obscure) versions.

    April 19, 2011

    Previews: One Crazy Summer [Phish Thoughts]

    April 13, 2011

    Streaming Highlights: UIC Jams [Phish Thoughts]

    April 12, 2011

    Tour Dates: Summer’s Swan Song? [Phish Thoughts]

    March 30, 2011

    Speculation: Dates, Please? [Phish Thoughts]

    March 24, 2011

    LivePhish: Phish For Japan [Phish Thoughts]

    March 17, 2011

    Merch: Introducing Phish Thoughts – The Book [Phish Thoughts]

    March 9, 2011

    Downloads: TAB Denver Downloads [Phish Thoughts]

    March 8, 2011

    Trey Anastasio: Finishing With Fire at the Fox [Phish Thoughts]

    February 23, 2011

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

    February 15, 2011

    Trey Anastasio: The Spark of Trey’s Solo Career [Phish Thoughts]

    February 10, 2011

    Rumors: Ten Random Rumors [Phish Thoughts]

    February 9, 2011

    Songs: Casualties of This Era [Phish Thoughts]

    Though Phish’s modern era has brought us new jam vehicles in “Light” and “Number Line,” it has also seen several fade away. Aside from the well-documented castration of “Mike’s Song,” three other crowd-favorites have completely lost their sense of adventure—”Halley’s Comet,” “Gumbo” and “Free.” The former two have returned to their pre-1997 form, while the latter has inexplicably shrunk into a Phish single. Because of its history, I think “Free” still has a chance to bust out, but, it feels like “Halley’s and “Gumbo” jams may be gone forever.