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"; } } ?> 2011 September 15 | YEMblog

    Daily Archive

    September 15, 2011

    Essex: Phish Returns to Green Mountain State [Hidden Track]

    [Photo by Parker Harrington]

    In an extraordinarily low-key pre-show parking lot scene that was more akin to a family picnic than a rock show or typical Phish event, warm embraces and friendly conversation prevailed. Seemingly, most of the 8,000 tickets sold in Vermont stayed with Green Mountain Staters. The fairgrounds certainly felt like the local hometown show that it was. At the sole entrance to the venue, security and ticket takers greeted many of the incoming attendees by name. Regardless if they knew you or not, they were certainly more intent on welcoming you, smiling at you, and treating you to true Yankee hospitality than they were to bother with checking anything other than your ticket.

    Essex: Tales From A Reluctant Phishhead [Seven Days]

    Well, guess what? It was a lot of fun.

    (Before we move on, if I could chat privately with the hardcore Fi-hadist nitwits for a second. Dudes, what follows will be a mostly positive review of my experience at the show last night. However, I’m a music critic. I don’t believe anyone, even a sacred sea cow, is above criticism. I’m gonna write a few things you probably won’t agree with or like. So let me save you some time and trouble:

    – Yes, this is the worst piece of journalism in history. And I am the worst journalist ever.

    – You’re right, I probably should be/will be/have been fired for this.

    – It’s true. I am so jealous that your band is bigger than my li’l hipster indie bands. By the way, have you heard the new Vampire Grizzly Beach album? Really skinnies up my jeans.)

    NO Drug Arrests: Police Say The Phish Crowd Was Easy to Manage [Burlington Free Press]

    “It ran extremely well,” said Brad LaRose, acting chief of the Essex Police Department. “I was very pleased and very appreciative for the cooperation of the crowd. They were very pleasant to deal with. I’ve been in the business for 33 years, and I can’t ever remember dealing with a crowd of that size that was so pleasant to deal with.”

    Local Coverage: Various Videos About Phish @ CVE [WCAX]

    Essex: Wake of the Flood Returns to Vermont [Coventry]

    Phish is a tremendous source of inspiration. The friends that I met through the band give me hope for humanity. Trey is a personal hero because I also struggle with some of the same (pharmaceutical) demons that he dealt with over the last decade or so. It’s not easy being Trey, and it’s even a thousand times tougher to walk the line of sobriety while feeding the creative beast within you and trying to entertain and show everyone a good time without being redundant. Despite the deviant obstacles, Trey and the rest of the band continue to share their collaborative musical talents with whomever is bold and crazy enough to follow them along for the ride. Phish was born in Vermont in the mid-80s when a bunch of geeky college students decided to form a band. It took 240 attempts, but I’m fortunate that I got to finally see a good show near their birthplace.

    Coventry’s demons have finally been exorcised.

    Essex: Essexy Evening at Home w/ Phish [Online Phish Tour]

    Essex: Review – Back In The Zone w/ Phish [VTDigger]

    Vermont Flood Relief: How To Get Involved [Hidden Track]

    Essex: Phish Benefit Floods Essex Junction With Phans [WCAX]

    Essex Junction: Phish Vermont Flood Benefit – Essex Junction Setlist, Recap and The Skinny [Hidden Track]

    Overall, this evening’s concert was a huge success and raised plenty of money for relief efforts. Musically, this was more in line with Outside Lands than Chicago or Denver.

    Phish: 09/14/2011 Various Pro-Shot Footage From WPTZ

    YouTube Preview Image

    Editorial: Lazy Writers Beware – Phish Fans Attack [On The Phish Beat]

    When scribes from the outside world – bloggers, journalists, etc. – write terribly inaccurate pieces about our beloved band, we react swiftly and in droves, like a swarm of angry bees or a pack of hungry lions.

    Phish: 09/14/2011 LivePhish SBD Essex, VT

    Essex: Phish Jams For Flood Relief in Vermont [Burlington Free Press]

    Mike Gordon, the bassist, took the stage to great cheers at about 7:15. With few words, he acknowledged the magnitude of the moment — Phish, which formed in this state in 1983, home for a concert to help a state and people in need.

    Phish: 09/14/2011 FOB Essex, VT

    Essex: Essex VT Recap by Chris Bertolet [Phish.net]

    Trey Anastasio: TAB Project 2002 Mega-torrent

    Essex: Phish’s Vermont Homecoming [Jambands.com]

    Influence’d: How Bon Iver Get Megafaun Into Phish [Jambands.com]

    Actually, the first time I heard Phish was at Justin’s house in high school. He played Hoist for me. He liked them but he never actually went to a show with us. Before that I was listening to Nirvana, and I had a Germs record. I was either going to go the jazz route or the punk route, and the punk thing didn’t work out for me. After Justin played me Hoist, I bought it and I just couldn’t stop listening to it.

    Venues: Vermont’s Jamband Incubator Takes Note [Burlington Free-Press]

    “When Nectar left the place, he didn’t realize how much history was here,” Walsh says. “There are old calendars in the basement with Phish dates scribbled in, and handwritten notes from Trey to Nectar.” Trey Anastasio is Phish’s guitarist and frontman.

    Despite being a must-see site for any Phish fan, Nectar’s isn’t full of memorabilia, and doesn’t sell Phish merchandise. “People come in and ask where all the Phish stuff is — I tell them, ‘you’re standing in it!’” Walsh said.

    Essex: Phish Plays Flood Benefit in Vermont [Associated Press]