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

    Hampton RSS

    March 8, 2012

    Phish: 03/07/2009 Mike’s Song / Weekapaug Groove [VQ: A-, AQ: A, CK5]

    YouTube Preview Image YouTube Preview Image

    January 25, 2012

    Phish: 08/09/2004 Entire Show Hampton, VA [VQ: A-, AQ: A+]

    Set 1

    YouTube Preview Image

    Set 2

    YouTube Preview Image

    Set 1: Chalk Dust Torture, Bathtub Gin -> Runaway Jim, Walls of the Cave, Loving Cup
    Set 2: All of These Dreams, Limb By Limb, Lifeboy, Crowd Control, Seven Below[1], Stash -> NICU, Bug, Contact[2] > Character Zero
    Encore: David Bowie
    [1] Mary Had a Little Lamb tease.
    [2] Little Drummer Boy jam.
    Notes: All of These Dreams was preceded by a Fluffhead tease. After several glowsticks hit Trey’s rig at the end of Seven Below, Trey’s guitar tech, Brian Brown, had to come onstage to do some damage control, prompting Trey to say some word of thanks. Seven Below contained a Mary Had a Little Lamb tease from Trey. Contact culminated in a Little Drummer Boy jam.

    [Setlist via Phish.net]

    January 20, 2012

    Phish: 12/18/1999 Entire Show [VQ: B-/C, AQ: B+]

    Set 1

    YouTube Preview Image

    Set 2

    YouTube Preview Image

    Set 1: Harry Hood, Back at the Chicken Shack, Dog Log, Tube, Heavy Things, Back on the Train, First Tube, The Inlaw Josie Wales[1], You Enjoy Myself

    Set 2: Also Sprach Zarathustra[2] > Sand, The Horse > Silent in the Morning, Possum, Mike’s Song > Simple, Weekapaug Groove -> Buffalo Bill > Weekapaug Groove[3]
    Encore: Ya Mar, Sleeping Monkey

    [1] Trey on acoustic guitar.
    [2] Do You Feel Like We Do tease.
    [3] Norwegian Wood and Buffalo Bill teases.

    Notes: Dog Log was dedicated to Paul Languedoc. Afterwards, the band reprised the song for a few seconds after Trey remarked how much he liked it. Inlaw Josie Wales featured Trey on acoustic guitar. 2001 included Do You Feel Like We Do (Peter Frampton) teases; Trey also introduced Fishman as ‘Bob Mayonnaise’, likely a reference to Bob Mayo, who played keys on Frampton Comes Alive. Weekapaug included Norwegian Wood and Buffalo Bill teases.

    [Setlist via Phish.net]

    December 21, 2011

    Video Podcasts: Dinner and a Movie – Episode 2 – Hampton Halley’s

    November 22, 2011

    Video: Phish Shares Official Video of Halley’s Comet From Hampton ’97 [Hidden Track]

    Remembrances: A Look Back at Hampton – 11/22/97 [Phish.net]

    November 21, 2011

    Remembrances: Hampton ’97 – A Look Back, Part One [Phish.net]

    The opener in hindsight is a tremendous treat, the debut of The Rolling Stones “Emotional Rescue.” A song that only Mike could properly handle his shift between baritone and falsetto tones pays a nice homage to a legend like Jagger. It’s also a glimpse into the vocal range Mike has always possessed. In 1997 his vocals felt more like a goof than a talent, but fourteen years later you can hear the potential and see the connection to the extremely strong vocal presence he maintains now.

    November 9, 2011

    Contests: HT Giveaway – Win Phish Hampton / Winston-Salem ’97 [Hidden Track]

    Hidden Track is giving away three copies of Hampton / Winston-Salem ’97 and a Black-Eyed Katy bundle which includes a t-shirt and 2012 calendar. Read this post for full details.

    November 8, 2011

    Phish: Theme From The Bottom > Black-Eyed Katy from Hampton / Winston-Salem ’97

    Phish – Theme From The Bottom – Black Eyed Katy by yemblog

    October 31, 2011

    Hampton ’97: Stream/Download AC/DC Bag -> Slave to the Traffic Light from new release [HT]

    October 28, 2011

    Hampton/Winston-Salem ’97: Phish Release 7-CD Box Set of Historic Shows [Rolling Stone]

    October 27, 2011

    Audio: Sample Mike’s > Hydrogen > Weekapaug from Hampton / Winston-Salem ’97 [Hidden Track]

    October 24, 2011

    Phish: 11/21/1997 & 11/22/1997 New Sources DAUD Hampton, VA

    October 17, 2011

    Live Phish: Phish to Release Hampton / Winston-Salem ’97 [Hidden Track]

    When discussing the Holy Grail of Phish shows stuck inside the band’s vault, the Hampton ’97 performances and Big Cypress are usually towards the top of most fans’ lists. On December 6, Phish fans will finally get to hear the Hampton ’97 performances in all their Fred Kevorkian-mastered soundboard glory when JEMP Records puts out Hampton / Winston Salem ’97. The wonderful kicker is that the band has attached the severely underrated November 23, 1997 show to this seven-CD set that will also include never-before-heard soundchecks.

    October 14, 2011

    Remembrances: The Best Two-Set Show – 11/22/97 [Six Water Grog]

    September 2, 2011

    Columns: Video of the Week – 12/18/1999 Chicken Shack, Dog Log [Phish.net]

    July 15, 2011

    Downloads: A Show For Your Weekend – Hampton ’96 [OPT]

    July 9, 2011

    Lists: The 30 Best Live Versions of Songs [Consequence of Sound]

    There was no greater news to New England in the winter of 2009 than the word that Phish was getting back together for a three-night run at the Hampton Coliseum. What started out as three (very thorough) reunion shows turned into the next leg of the Vermont quartet’s career, and they kicked everything off with “Fluffhead”.

    May 18, 2011

    Phish: 11/21/1997 11/22/1997 11/23/1997 New Sources DAUD Winston-Salem/Hampton

    April 27, 2011

    Phish: 12/18/1999 New Source DAUD Hampton, VA

    March 8, 2011

    Phish: 03/08/2009 Down With Disease [VQ: A, AQ: A+, Remastered]

    YouTube Preview Image

    February 24, 2011

    Venues: Phish to Return to Portsmouth [Daily Press]

    Does this mean that Phish’s long, well-publicized love affair withHampton Coliseum is over?

    “Absolutely not,” said Joe Tsao, director of the Coliseum. He pointed out that a number of Phish shows in Hampton were special events, either part of a farewell or a welcome back set of concerts.

    “Now, they’re back to regular touring,” Tsao said. “Are they saving me for something special? I don’t know.”

    January 31, 2011

    Phish: 11/22/1997 New Source DAUD Hampton, VA

    January 12, 2011

    Rumors: Rumors of Watkins Glen & Hampton Becoming Strong [OPT]

    December 20, 2010

    Phish: 12/18/1999 Harry Hood [VQ: A-, AQ: A-]

    YouTube Preview Image

    Phish: 12/18/1999 Back at the Chicken Shack, Dog Log [VQ: A-, AQ: A-]

    YouTube Preview Image

    September 30, 2010

    Phish: 12/17/1999 DAUD New Source Hampton, VA

    September 24, 2010

    Phish: 11/22/1997 Bouncing, Tweezer Reprise [VQ: B, AQ: B]

    YouTube Preview Image

    September 22, 2010

    Phish: 11/22/1997 Piper [VQ: B, AQ: B]

    YouTube Preview Image

    Phish: 11/22/1997 Run Like An Antelope [VQ: B, AQ: B]

    YouTube Preview Image

    September 20, 2010

    Phish: 11/22/1997 Tweezer [VQ: B, AQ: B+]

    YouTube Preview Image

    Phish: 11/22/1997 Black-Eyed Katy [VQ: B, AQ: B+]

    YouTube Preview Image

    September 13, 2010

    Phish: 11/22/1997 Frankenstein [VQ: B, AQ: B]

    YouTube Preview Image

    Phish: 11/22/1997 Izabella [VQ: B, AQ: B+]

    YouTube Preview Image

    September 12, 2010

    Phish: 11/22/1997 Train Song [VQ: B, AQ: B]

    YouTube Preview Image

    Phish: 11/22/1997 Billy Breathes [VQ: B, AQ: B]

    YouTube Preview Image

    September 10, 2010

    Phish: 11/22/1997 Harry Hood [VQ: B, AQ: B+]

    YouTube Preview Image YouTube Preview Image

    September 8, 2010

    Phish: 11/22/1997 Mike’s Song [VQ: B, AQ: B+]

    YouTube Preview Image

    August 24, 2010

    Phish: 01/02/2003, 01/03/2003, 01/04/2003 New Source Hampton, VA

    August 2, 2010

    Phish: 01/03/2003 FOB UNCIRCULATED Hampton, VA

    March 24, 2010

    Phish: 03/08/2009 Slave to the Traffic Light [VQ: A-, AQ: A-]

    YouTube Preview Image

    March 23, 2010

    Phish: 03/08/2009 Tube [VQ: A, AQ: A]

    YouTube Preview Image

    March 21, 2010

    Phish: 03/08/2009 While My Guitar Gently Weeps [VQ: A, AQ: A-]

    YouTube Preview Image

    March 16, 2010

    Phish: 03/08/2009 The Horse > Silent In The Morning [VQ: A, AQ: A-]

    YouTube Preview Image

    March 14, 2010

    Phish: 03/08/2009 Seven Below [VQ: A-, AQ: A-]

    YouTube Preview Image

    Phish: 03/08/2009 Down With Disease [VQ: A-, AQ: A-]

    YouTube Preview Image YouTube Preview Image YouTube Preview Image

    March 12, 2010

    Phish: 03/07/2009 A Day In The Life [VQ: A, AQ: A-]

    YouTube Preview Image

    March 7, 2010

    Songs: Stories About Songs – Hampton Fluffhead [BeauColburn]

    This one moment—this one choice—didn’t just set the tone for that show, or that tour, but for the rest of the band’s career.  And to be honest, it set the tone for how I would feel about them moving forward.  This was the real deal. So this is how it’s gonna be huh? They were clearly serious and I would take them seriously.

    Of all the shows, in all the years, this one song—these few seconds as the waves of excitement expanded through the crowd—stand above anything else I’ve ever experienced. If you could bottle the feeling in that room at that moment you could solve a lot of problems. Pure, pure bundles of joy.

    Hampton Anniversary: Ace Cowboy’s Phish Hampton Review [HT]

    To accurately describe what it’s like having the popular rock band Phish back on the Hampton Coliseum stage, let me steal a quip from that lovable ol’ drunkard Arthur when he tells Linda about owning a yacht: “It doesn’t suck.”

    March 4, 2010

    Remembrances: Hampton ’09 – A Look Back [Phish Thoughts]

    Over the three-part dream, Phish played for nearly ten hours, running through no less than 84 songs of their notoriously vast catalog. From the very beginning of 2009, beginning with “Fluffhead,” and “Divided Sky,” one sensed things would be different this time around. Focused far more on composition and precision than jamming, the band got back to basics at Hampton, a trend that characterized the entire year for Phish. Without getting too crazy or improvisational, Hampton set up the rest of 2009, just as 2009 set up 2010; both periods representing building blocks towards high-level musical proficiency without too many risks.

    February 9, 2010

    Phish: Hampton 2009 Montage

    YouTube Preview Image

    December 21, 2009

    Phish: 11/21/1997 UNCIRCULATED Hampton, VA

    December 18, 2009

    Phish: 12/18/1999 DAUD Hampton, VA

    December 17, 2009

    Phish: 12/17/1999 FOB Hampton, VA

    July 6, 2009

    Phish: 03/07/2009 Mexican Cousin [VQ: A-, AQ: A]

    YouTube Preview Image

    July 3, 2009

    Rumors: Hampton and Indio Rumors Make The Paper [Hidden Track]

    Rumors: Will The Band Return to the Hampton Coliseum? [Daily Press]

    Whispers circulating locally and nationally suggest that jam band kings Phish may return to Hampton Coliseum before year’s end.

    A Hampton city government official, speaking on condition of anonymity, said Phish is definitely coming back this year — probably sometime in the fall.

    July 2, 2009

    Phish: 03/07/2009 Reba [VQ: A, AQ: A]

    YouTube Preview Image YouTube Preview Image

    June 30, 2009

    Phish: 03/07/2009 Gumbo [VQ: A-, AQ: A]

    YouTube Preview Image

    June 28, 2009

    Phish: 03/07/2009 Heavy Things [VQ: A-, AQ: A]

    YouTube Preview Image