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

    Songs RSS

    March 29, 2012

    Songs: Index to Phish Lyrics by Subject [Phish.net]

    March 21, 2012

    Demos: Tom Marshall Shares Vultures Demo [Soundcloud]

    February 28, 2012

    Songs: Tom Marshall Shares The Demo and The Story Behind Bug [Soundcloud]

    February 16, 2012

    Songs: Shuffle and Splooge #2 Discovers True Meaning of PYITE [Vice]

    February 9, 2012

    Songs: Three Eras of Tube [Phish Thoughts]

    February 7, 2012

    Songs: Twisted Tuesday – Underrated Twists [Phish Thoughts]

    February 2, 2012

    Songs: Three Tweezers of Thursday [Phish Thoughts]

    January 29, 2012

    Songs: Trey Anastasio Tells The Story of Farmhouse [Tom Marshall Soundcloud]

    December 13, 2011

    Songs: Song History – Traveled Too Far [Phish.net]

    December 8, 2011

    Songs: Under The Covers Volume 6 [Online Phish Tour]

    November 30, 2011

    Songs: Is Mike’s Song Trapped In Time? [Online Phish Tour]

    My original intentions for this article were to compile my wishlist for the New Years Eve run at MSG. With “black Friday” in the rear-view mirror and Phish’s high holidays approaching, I thought I would discuss some things I hope we get during the upcoming four night stand. The problem is that atop my list is “Mike’s Song” – a staple in Phish’s catalog that has predominantly eluded fans during “3.0.” I have been craving a thick and evil “Mike’s Song” that would transcend the tune, but I continue to yearn. So my attention shifted from assembling a list of potential New Years gifts to examining “Mike’s Song;” a former improvisational champ that is now a shadow of itself. (I intend to put out a wishlist as we get closer to the mini run; however, let’s focus on “Mike’s Song.”)

    November 17, 2011

    Songs: Song History – Sweet Dreams Melinda [Phish.net]

    Songs: Song History – Mr. Completely (Revised) [Phish.net]

    November 3, 2011

    Songs: Phish’s Favorite Song Pairings [Online Phish Tour]

    October 27, 2011

    Podcasts: Episode 35 – The Reba Show [Type II Cast]

    October 22, 2011

    Songs: TAB Song History – Land of Nod [Phish.net]

    October 20, 2011

    Songs: TAB Song History- Chapeau Mauvais [Phish.net]

    October 14, 2011

    Songs: On The Wind and Underwater [Online Phish Tour]

    October 11, 2011

    Songs: Under The Covers – Whipping Post [Online Phish Tour]

    October 3, 2011

    Trey Anastasio: TAB Song Histories – Travelling Song and Peggy [Phish.net]

    September 29, 2011

    Songs: Under The Covers – Loving Cup [Online Phish Tour]

    TAB: Trey Song Histories – Every Story Ends In Stone & Valentine [Phish.net]

    September 8, 2011

    Songs: The Story of Reba – Finest In The Nation [Online Phish Tour]

    August 22, 2011

    Songs: Song History – Rocket Man (Elton John) [Phish.net]

    August 16, 2011

    Songs: Song History – Babylon Baby [Phish.net]

    August 9, 2011

    Songs: Song History – 50 Ways To Leave Your Lover [Phish.net]

    August 1, 2011

    Songs: Thoughts Out On The Page – Story of Steam [OPT]

    July 25, 2011

    Songs: Jamming Chart – Drowned [Phish.net]

    June 23, 2011

    Songs: Song History – No Quarter [Phish.net]

    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

    May 25, 2011

    Lists/Songs: Fifteen Favorite Harry Hoods [Hidden Track]

    Over the course of Hidden Track’s lifespan, we’ve taken a couple different stabs at making a list of favorite Hoods, and it felt like a good time for the next iteration. It will remain a perpetual work in progress as the band plays new renditions and old gems get discovered, but nevertheless, it’s coming along. This time, we have a meticulously organized, iPod-ready downloadfor your enjoyment as well as a stream at the bottom of the post. While these are mostly audience recordings or soundboards that are not part of official releases, but we tried to normalize the levels and made sure the volume is plenty loud. Without further ado, here is the list…

    May 10, 2011

    Songs: The Ghost of Nuremberg [Dog Gone Blog]

    The next time the song appeared was on 7.3 in Nuremberg. This was the first version that fully opened up, allowing the band to truly explore its musical offerings. Over the course of 30 minutes, you’ll hear the jam transition from a funk-laden groove to a melodic section of delectable psych rock. You can hear the band’s excitement as they stretch out their new tune and toy with various themes throughout.

    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.

    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.

    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]

    March 3, 2011

    Lyrics: Phish Is For The Ladies [Online Phish Tour]

    February 24, 2011

    Lists: If Phish Songs 3.0 Were a Ratings Scale [PhanArt]

    February 17, 2011

    Lists: Five… [Phish Thoughts]

    …2.0 Songs That Deserve More Play

    1. The Song I Heard the Ocean Sing

    2. Scents and Subtle Sounds

    3. Waves

    4. Round Room

    5. Discern

    February 16, 2011

    Songs: My Drivers Got a Mind of Its Own [OPT]

    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.

    February 3, 2011

    Songs: The Transformation of Sand [Phish Thoughts]

    A turning point for the song came in Telluride, when Mike broke form and began improvising bass leads while Trey tore into ferocious washes of sound and sustained, uncompressed phrases. Page stepped up and began playing along with Mike’s uncompromising leads before Trey drifted back into a more standard lead role. While Mike, Page and Trey engaged in a distinctly different conversation, Fishman still maintained a driving beat that kept the creativity framed in familiar style. Coming together in a crushing full-band peak, Phish capped the jam without returning to its final musical verse.

    February 2, 2011

    Songs: Thoughts Out on the Page – Thank You, Mr. Fordham [OPT]

    “46 Days”, for me, is a song about being at someone else’s mercy.  What do we know about this Leigh Fordham character? We know that he was the band’s lighting technician and that’s really about it.  However, I think this nugget of information is useful given the context of the song.  The Fordham in the song is somehow in control of what the narrator desperately needs: The coal.  In a lonely cabin in the woods, like the one pictured on the cover of Round Room, a bag of coal can be the difference between life and death, illumination and darkness.

    December 22, 2010

    Songs: What Is The Harry Hood X-Factor? [Hidden Track]

    In the 3.0 era of Phish, it’s no secret that Harry Hood is one song that has been a little slower to make its full return to grace. Upon coming off the shelf post-breakup in 2009, the band initially fumbled for a period of time in getting the composed parts down, but they quickly resolved that issue. Yet, to this day – save for a few exceptions  like the Greek Theater, Thompson Boling Arena, and MSG I – the jams haven’t quite reached that “lift off” level. You know the ones where you’re in your car and get lost in the song, only to look down at the speedometer and realize your driving 95 miles per hour and missed the exit five miles back?

    December 2, 2010

    Songs: Thoughts on Summer of ’89 [OPT]

    November 12, 2010

    Songs: The Rebirth of Carini [Phish Thoughts]

    November 11, 2010

    Songs: Two Songs to Build Off Of [Online Phish Tour]

    November 8, 2010

    Songs: Aftermath [Online Phish Tour]

    October 21, 2010

    Songs: Finally, A REAL David Bowie [Online Phish Tour]

    October 17, 2010

    Songs: The Severing of Scents & Subtle Sounds [Smooth Atonal Sound]

    October 14, 2010

    Songs: Making The Case – Summer of ’89 [Phishnet]

    Say what you will about Summer of ‘89 – it’s weak compositionally, it’s mushy and out of place at a Phish concert, its chordiness makes it musically unchallenging, it’s not manly enough, it’s unnecessarily sappy, it’s a too-intimate glance into private emotions… to me, those are all excuses. You don’t have to love the song, but to suggest that it’s bad because it’s different just seems disingenuous and uncharacteristic of Phish phans.

    October 4, 2010

    Remembrances: The Riverport Gin [Dog Gone Blog]

    September 8, 2010

    Songs: The Rebirth of “The Groove” [Phish Thoughts]

    September 3, 2010

    Songs: Telluride Piper – Sound of the Storm [Phish Thoughts]

    September 2, 2010

    Songs: Skyballs and Saxscrapers – Greek Simple [Phish Thoughts]

    September 1, 2010

    Songs: Let’s Take a Ride – BDTNL [Phish Thoughts]

    When Blossom’s “Number Line” transformed into one of June’s most impressive jaunts, 2010 seemed like the song’s coming-of-age year. But for the rest of the month and throughout August, Phish unveiled benign version after benign version – until Jones Beach.

    August 30, 2010

    Songs: 2010 Summer Mangoes [Online Phish Tour]

    August 2, 2010

    Songs: The Meatstick Dance, Summer ’99s Craze [PhanArt]

    Here we stand at the forefront of Summer Tour 2010, Leg 2, with a piece of Phish history slipping away to faded memories. Is this the future we want to bring up our children in? A Meatstick-less future? Can you sleep at night knowing you haven’t passed on the legacy that is The Meatstick to your friends and family? If not you, who? If not now, when? If not here, where? AT WHAT COST?!

    August 1, 2010

    Songs: I Want Mike’s Groove to Rage Again [Phish.net]

    You love Mike’s Groove.  The thought has nevertheless crossed your mind in the last year why versions of Mike’s Groove since Hampton haven’t been much, if any, better than “average-great.”