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

    Vermont RSS

    August 27, 2012

    Phish: 10/01/1989 Oh Kee Pa Ceremony > Tweezer Reprise [VQ: B-, AQ: A]

    YouTube Preview Image

    August 25, 2012

    Phish: 10/01/1989 Harry Hood [VQ: Varies From Rough to Pretty Good AQ: A]

    YouTube Preview Image

    May 20, 2012

    Jon Fishman: Hug Your Farmer 05/18/2012 DAUD S. Burlington, VT

    Trey Anastasio: Trey Anastasio Band 06/08/2003 Black Dog [VQ: A-, AQ: A-]

    YouTube Preview Image

    Jon Fishman: Videos, Setlist, Recap – Hug Your Farmer – A Tribute to Levon Helm [Hidden Track]

    Phish: 10/31/1989 Playlist [VQ: A, AQ: A+, Pro-Shot]

    Fee, Walk Away, Bathtub Gin, Possum

    March 31, 2012

    Phish: 10/31/1989 David Bowie [VQ: A, AQ: A, Pro-Shot]

    YouTube Preview Image

    March 29, 2012

    Phish: 10/31/1989 David Bowie [VQ: A-, AQ: A, Pro-Shot]

    YouTube Preview Image

    March 25, 2012

    Phish: 10/31/1989 Wilson [VQ: A-, AQ: A, Pro-Shot]

    YouTube Preview Image

    Cactus: Keller Williams Welcomes Mike Gordon at Higher Ground [Hidden Track]

    February 17, 2012

    Trey Anastasio: TAB 05/08/2004 UNCIRCULATED SBD Stowe, VT

    January 17, 2012

    Phish: 05/20/1987 Major Upgrade – Playlist [VQ: B+, AQ: B+]

    Wilson, Golgi Apparatus, Run Like An Antelope, Back Porch Boogie, Lushington, Possum, Harry Hood, You Enjoy Myself, Alumni Blues

    December 23, 2011

    Video: Footage of the Seventh Reba Phish Ever Played Surfaces [Hidden Track]

    Phish: 10/31/1989 Oh Kee Pa > Suzy Greenberg [VQ: A-, AQ: A-, Pro-Shot]

    YouTube Preview Image

    October 22, 2011

    Cactus: Mike Gordon w/ Marco Benevento Trio 10/21/2011 Green Onions, Twin Killers [VQ: A-, AQ: B]

    YouTube Preview Image

    October 5, 2011

    Trey Anastasio: TAB 10/01/2011 DAUD S. Burlington, VT

    October 4, 2011

    Trey Anastasio: TAB 10/01/2011 LivePhish SBD Burlington, VT [LivePhish]

    October 3, 2011

    Trey Anastasio: TAB 10/01/2011 Clint Eastwood [VQ: A-, AQ: A-]

    YouTube Preview Image

    Burlington: Trey Anastasio Band @ Higher Ground Setlist & Recap [Hidden Track]

    Trey Anastasio: TAB 10/01/2011 Playlist [VQ: Varies, AQ: Varies]

    Snake Head Thumb, Gotta Jibboo, Cayman Review, Drifting, Clint Eastwood, Show of Life,

    October 1, 2011

    Trey Anastasio: TAB 10/01/2011 Higher Ground Setlist [Phish.net]

    September 20, 2011

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

    September 16, 2011

    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

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

    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

    September 14, 2011

    Cactus: Mike Gordon w/ Warren Haynes Band 09/13/2011 On Your Way Down [VQ: B-, AQ: B-]

    YouTube Preview Image

    Cactus: Mike Gordon w/ Warren Haynes Band 09/13/2011 That’s What Love… [VQ: B, AQ: B]

    YouTube Preview Image

    Cactus: Mike Gordon at Honky Tonk Tuesdays Playlist [VQ: A-, AQ: A-]

    Walls of Time, Heaven’s Just A Sin Away, Home By The Sea

    September 13, 2011

    Vermont Flood Relief: Going The Extra Mile In Vermont [Phish.net]

    It goes without saying that with Phish’s benefit concert coming up on Wednesday in Essex Junction, all eyes in the Phish community will be squarely on the flood ravaged state. If you purchased a ticket to the show, pre-ordered the webcast or made a donation to The Waterwheel Foundation, take pride in the fact that you have indeed already helped the people affected by Hurricane Irene in Vermont. Only a mere two and a half weeks since Irene ran its path through central New England most Vermonters are still busy cleaning up. The funds raised by Phish will be massive and go a long way over the long haul finding its way into the hands of various Vermont organizations helping in relief efforts. Recovery from this storm will take months, not weeks. That being said the state is already showing signs of rebuilding with business and community resources coming together and getting people and places back on their feet.

    Essex Junction: Essex Prepares for Phish Concert Traffic [Burlington Free-Press]

    Chittenden County law enforcement officials said Monday they are taking steps to try to ensure traffic safety and minimal disruption on Wednesday in response to the Phish benefit concert for victims of Tropical Storm Irene.
    Acting Essex Police Chief Brad LaRose said he is expecting a large but peaceful crowd for the concert from 7 to 11 p.m. at the Champlain Valley Exposition on Pearl Street.

    September 8, 2011

    Retrospective: Phish’s Storied History of Generosity [Hidden Track]

    Phish has a long history of giving back to not only the communities that they play in, but also to causes that are near and dear to many a fan’s heart. Though full blown benefit shows are few and far between, Phish philanthropy is well known. While history dictates that you will have about as much success predicting winning lottery numbers as you will a Phish setlist, it is nonetheless interesting to look back at previous benefit shows. Regardless of what goes down next week at the Champlain Valley Exposition, it is clear that the fans are in for a treat and that the state will benefit extraordinarily from another Phish philanthropic effort.

    Local Coverage: Phish To Play Benefit Concert in Vermont [WPTZ]

    YouTube Preview Image

    September 6, 2011

    Flood-Aid: Phish @ Champlain Valley Expo – September 14 [Hidden Track]

    August 29, 2011

    Trey Anastasio: TAB 06/08/2003 Root Down [VQ: B+, AQ: B+]

    YouTube Preview Image

    August 22, 2011

    Trey Anastasio: John McEuen & Jimmy Ibbotson (w/ Trey) 9/9/2001 DSBD Winooski, VT

    Trey plays You Ain’t Goin’ Nowhere, Beauty of My Dreams and Ripple with two members of the Nitty Gritty Dirt Band at the Higher Ground just two days before 9/11.

    July 8, 2011

    Phish: 04/19/1985 UNCIRCULATED AUD Burlington, VT

    This tape belongs in an Archive. In this era of TS->InterWebstreaming and immediate MP3 post-show downloading, this tape is an historical artifact in the history of recorded live music. It is also one of those recordings that somehow managed to escape the tape collections of many of the most obsessive-compulsive Phish tape collectors in history. Of course, its failure to circulate widely in the previous 26 years may have resulted from its quality. (I’d have probably given it a “C-/D+” on my last tapelist, circa 2000.)

    Page McConnell: New Vida Blue Sources – 04/20/2002 + 04/24/2002 DAUD

    March 29, 2011

    Cactus: Mike Gordon Band 03/26/2011 DAUD S. Burlington, VT

    March 28, 2011

    Cactus: Locals Join Mike Gordon at Higher Ground [Jambands.com]

    March 21, 2011

    Phish: 04/15/1989 AUD? UNCIRCULATED Burlington, VT

    February 13, 2011

    Phish: 05/11/1991 II SBD UNCIRCULATED Burlington, VT

    Charlie Dirksen has helped unearth a rare soundboard from Phish’s penultimate show at The Front in Burlington. While Dirksen notes tape hiss and muddiness on this source, the rare addition of harmonica to YEM and crude version of BBFCFM makes it well worth a listen. – ScottyB

    February 6, 2011

    Benefits: 02/03/2011 Hug Your Farmer Benefit w/ Page and Fish SBD MATRIX S. Burlington, VT

    A soundboard matrix recording of last Thursday night’s Hug Your Farmer benefit has come into circulation and features Page McConnell and Jon Fishman sit-ins scattered throughout two sets of classic rock covers. – ScottyB

    January 28, 2011

    Phish: 01/27/1990 SBD Burlington, VT

    January 18, 2011

    Phish: 03/22/1988 ??? UNCIRCULATED Burlington, VT

    December 16, 2010

    Phish: 02/03/1988 AUD UNCIRCULATED Waitsfield, VT

    December 12, 2010

    Vermont: Trying to Explain Vermont’s Image [Free Press]

    December 3, 2010

    Cactus: Mike Gordon w/ Vassar & His Yankee Boys 5/3/2000 SBD UNCIRCULATED Middlebury, VT

    Phish: 02/04/1991 AUD UNCIRCULATED Burlington, VT

    December 2, 2010

    Cactus: Vassar & His Yankee Boys 05/03/2000 DAUD Middlebury, VT

    November 30, 2010

    Page McConnell: Anne’s Band 02/02/1994 UNCIRCULATED SBD Burlington, VT

    Page McConnell- Keyboards
    Dave Grippo – Alto Sax
    Sean Hartman – Bass
    Jeff Salisbury – Drums
    Screamin’ Dean – Harp
    George Abele and Steven Kemp – Percussion
    Joseph Somerville Jr. – Trumpet
    Zaphed Beeble Brox – Tenor Sax

    November 23, 2010

    Phish: 05/20/1987 Playlist [VQ: B, AQ: B]

    http://www.youtube.com/view_play_list?p=9F2FA922BBC248F7

    Wilson, Antelope, Golgi, Back Porch Boogie Blues, Possum, Lushington, Harry Hood, You Enjoy Myself, Alumni Blues

    September 12, 2010

    Phish: 12/08/1989 SBD UNCIRCULATED Poultney, VT

    The most complete copy of this show yet has come into circulation with the addition of six missing tracks from the first set. A fantastic early show, this is a worthy addition to any Phish fan’s collection. – SB

    September 9, 2010

    Phish: 11/18/1987 SBD New Source Burlington, VT

    August 22, 2010

    Phish: 06/16/1990 SBD Townshend, VT

    If you don’t have this fantastic, classic Phish show in your collection be sure to take advantage of this file set put together by our pal Parker. – ScottyB

    July 2, 2010

    Trey & Mike: Michael Ray & Cosmic Krewe 02/10/1995 Burlington, VT

    Check out this FOB of a Michael Ray and the Cosmic Krewe show from Burlington in 1995 that featured sit-ins from both Trey Anastasio and Mike Gordon.  – ScottyB

    July 1, 2010

    Trey Anastasio: Cosmic Krewe w/Trey 02/03/1995 SBD Johnson, VT

    Trey sat-in with pal Michael Ray’s band in Johnson, VT and this recording features all of Anastasio’s appearance. This version of the Krewe included longtime Phish friends Stacey Starkweather, Bob Gullotti and Dave “The Truth” Grippo. – ScottyB

    May 28, 2010

    Phish: 09/02/1987 SBD UNCIRCULATED Burlington, VT

    TaperWayne unleashes the latest uncirculated gem he’s transferred to the digital realm. While it’s listed as a soundboard, the engineer did seem to be testing equipment as he screws with the settings frequently. Regardless, this rare recording provides an interesting listen. – ScottyB