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

    09142011 RSS

    November 14, 2011

    VT Flood Benefit: First Round of Grants from 9/14 Concert Announced [Phish.com]

    September 29, 2011

    Reviews: Phish @ Champlain Valley Expo – 09/14/11 [Glide Magazine]

    September 20, 2011

    Phish: 09/14/2011 Carini [VQ: A+, AQ: A+, Pro-Shot]

    September 19, 2011

    Essex: Reflections on Phish – “I Forgot For a While I Was On Assignment” [Burlington Free-Press]

    A few songs into the first set, a funny thing happened: My pad stayed in my pocket for longer stretches. I put my phone away and stopped sending messages to the newsroom. Deadlines and leads slipped from my mind. I forgot, for a time, I was on assignment. That’s a very unusual thing and a better way to listen to music — and there was some good stuff to hear Wednesday night at the fairgrounds.

    Essex: Picture Show – A Phish Homecoming [Hidden Track]

    Essex: Review – Bonus Phish [Phish Thoughts]

    Essex: Oh, What a Beautiful Buzz – Phish Returns To VT [Rutland Herald]

    September 16, 2011

    Essex: Phish Raises Over $1.2 Million For Vermont [Hidden Track]

    Phish has just posted a note on their official website thanking the dozens of companies that helped them throw Wednesday’s benefit for Vermont Flood Relief Efforts and also mentioned that the show in Essex Junction raised in excess of $1.2 million (!!) for the cause.

    Phish: 09/14/2011 MKDevo Playlist [VQ: A, AQ: A+]

    ENTIRE SHOW

    PLEASE SUPPORT THE VERMONT FLOOD RELIEF EFFORT BY PURCHASING LIVEPHISH AUDIO

    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]

    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

    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]

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

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

    September 9, 2011

    Vermont Flood Benefit: Phish Fans Ignore Request, Start Lining Up For Tickets [Burlington Free Press]

    Couch Tour: Vermont Flood Benefit To Be Webcast [Hidden Track]

    September 8, 2011

    Vermont Flood Benefit: Waterwheel Ticket Auctions for Essex Jct. [Mimi Fishman Foundation]