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

    Remembrances RSS

    April 15, 2012

    Remembrances: Eighteen Years Ago Today – Phish at the Beacon [Hidden Track]

    March 5, 2012

    Remembrances: The Coach House – San Juan Capistrano – 08/17/1992 [Back In My Day]

    February 14, 2012

    Remembrances: Looking Back at 2/14/91 – Ithaca, NY [Backinmydaydotnet]

    February 2, 2012

    Remembrances: The First Phish Show I Ever Saw [PhishPDX]

    January 25, 2012

    Remembrances: The Time I Attempted To Drive to a Phish Concert [Angry Penguins]

    December 15, 2011

    Remembrances: 12/31/1990 – World Trade Center, Boston MA [Back In My Day]

    December 13, 2011

    Remembrances: Albany – Twelve-Thirteen [Phish Thoughts]

    December 9, 2011

    Remembrances: Best Jam Ever? Albany YEM [Hidden Track]

    December 7, 2011

    Remembrances: The Rebirth of Tube [Phish Thoughts]

    December 1, 2011

    Remembrances: Have You Seen IT? [UMPI.edu]

    November 22, 2011

    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 14, 2011

    Remembrances: The First Four-Song Set of Fall ’97 [Phish Thoughts]

    November 10, 2011

    Remembrances: MSG Memoirs – The “2001” of 1998 [Phish Thoughts]

    November 9, 2011

    Remembrances: MSG Memoirs – 12/31/1995 Reba [Phish Thoughts]

    November 8, 2011

    Remembrances: MSG Memoirs – Carini > Wolfman’s [Phish Thoughts]

    Combining a eerie feel with a hard rhythmic focus, the band was creating some of their most engaging music of the year on the very first night of the New Year’s Run. Fishman altered his beat and the rest of the band followed along, creating an harrowing and danceable texture that spoke to the exact elements that I crave for in Phish music. Drifting from these patterns to a more ambient-drenched experiment, the methodical pocket and cymbal crashes never stopped as Trey and Page dug into space-aged effects that brought an enhanced sense of the occult back into play.

    November 3, 2011

    Remembrances: MSG Memoirs – 12/29/97 Tube [Phish Thoughts]

    November 2, 2011

    Remembrances: MSG Memoirs – 12/30/95 Hood [Phish Thoughts]

    Remembrances: Colgate U – 04/23/1993 [Back In My Day]

    October 14, 2011

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

    October 12, 2011

    Remembrances: Phish’s Spectacular 1994 Blowout at Kent State [Patch.com]

    I went after Phish not too long after that survey went out, and on Sept. 16, 1994 we made them a formal offer of $37,500 plus 85 percent of net profits to play in the MAC Center on Saturday, Nov. 12, 1994 and Phish was cool with it and by Oct. 6 we had a signed contract between Phish and Kent State University. We also got 20 percent of the money from all of the merchandise sold at the show which is big, so it had the potential to generate more money for the University than anything I’d ever seen.

    September 30, 2011

    Remembrances: Phish Fri – Bathtub Gin > Simple 12/07/1999 [Dog Gone Blog]

    September 12, 2011

    Remembrances: S is for Scottie [Phish Thoughts]

    August 31, 2011

    Remembrances: Tahoe Revisited [Phish Thoughts]

    August 15, 2011

    Remembrances: Rethinking Coventry [Phish.net]

    August 3, 2011

    Remembrances: Amy’s Farm 20 Years Later [Phish.net]

    Twenty years ago today, in the cozy confines of Larrabee Farm in Auburn, Maine, Phish wrapped up their touring for the Summer of 1991. The entire run, barring Amy’s Farm, consisted of the well receivedHorn Tour. Commencing with the home-town show at Battery Park in Burlington, VT on July 11th and winding down the East Coast and culminating at the potent one set blowout at the Variety Playhouse in Atlanta, GA, the Horn Tour was 15 shows that became etched into the collective memory of the fan-base. However, as fun as the Horn Tour was, and as good as the shows were, the definitive show that paints the picture of where Phish was at that time, and portended signs of things to come, was Saturday, August 3rd at Amy’s Farm.

    TAB: A Flame From A Spark – TAB Hits Columbia ’01 [icculus4u]

    Remembrances: 8/3/91 Amy’s Farm [backinmydaydotnet]

    July 12, 2011

    Remembrances: TAB at the Greek 2001 [Summer 2001 Road Trip]

    July 6, 2011

    Remembrances: A History of Phish’s Summer Festivals [Jambands.com]

    Superball IX is part of a noble Phish tradition: the summer festival. Tracing the rise of the band and then their sudden collapse, these events are defining moments, each a document of its era. They may not have been the best shows, but they always were the most memorable event of the year. Between the art and the surprise sets and the random encounters that happen when thousands of people camp together, the Phish festivals transcended the concept of being a concert. Phish had a chance to create their own events and in doing so redefined what an event could be.

    June 29, 2011

    Phish Festivals: Postcards From Page Side – When The Circus Comes To Town [Hidden Track]

    From the Clifford Ball’s artwork, Ball Square (which again will return this year), and the fact that things were taking place on a decommissioned airforce base (a theme that would continue in latter years and festivals), the sheer scope and ambition that went into the first festival was unprecedented and never seen before. Ending a short, but ferocious Summer ’96 U.S. Tour, the band arrived just across the river from their Burlington base at the time ready to deliver, and boy did they. From the often praised “best set ever” of 8.17 II, which included a Slave to the Traffic Light that is many fans’ favorite version, the band was razor sharp. But, Phish had more in store, including what would become another staple of their festivals: playing a secret set at a random time during the weekend.

    Remembrances: Top Phish Festival Moments – Tower Jam [Unplugged Musings]

    June 28, 2011

    Remembrances: Nedstalgia – 20 Years Ago (In Praise of Tastemakers) [@neddyo]

    I don’t know the exact date, but sometime during the last week of June in 1991, 20 years ago today roughly, I had a life changing experience. Now I’ve had plenty of life changing experiences – you could argue every experience you have changes your life in one way or the other. But I can look back at this specific one and say for sure that it laid the path for a lot of where the next 20 years of my life would take me. It was the first time I heard the music of Phish.

    June 13, 2011

    Remembrances: Phish Used to Get Funky [Funk It]

    May 4, 2011

    Remembrances: Essential Phish – 11/04/1990 Ft. Ram [Dog Gone Blog]

    It has been touched on before, but especially these days it’s important to bring attention to certain shows that act like building blocks for the band’s career. With the age of downloading upon us, many of the once-essential analog tapes have gone the way of the wind. Surely, those who were active in the tape-trading years will know this one. But for those who don’t, add the show from November 4, 1990 at Fort Ram, Fort Collins, CO the your list of essential, must-hear shows.

    April 20, 2011

    Remembrances: Standout Shows – Phil Lesh w/ Trey & Page [ShakedownBlog]

    April 15, 2011

    Remembrances: 04/15/1994 Beacon Theatre – First Show [Hidden Track]

    April 9, 2011

    Remembrances: What Happened at Walnut Creek 2003? [OPT]

    April 5, 2011

    Remembrances: Island Tour Memories [Online Phish Tour]

    March 6, 2011

    Remembrances: Brothers and the McNichols Tweezer [The Loop]

    February 16, 2011

    Remembrances: Trey Tour – Winter 2001 [Phish Thoughts]

    January 24, 2011

    Remembrances: Bad Moments in Phishtory [Phish.net]

    There has been such extensive discussion about Phish’s high points that there are common suggestions for best performances (esp.12/31/95), strangest setlists (esp. 2/20/93), and most cosmic experiences (esp. 1/1/00). Much less attention is paid to the “bad moments” in Phishtory – you can find it (and anything else) in excess in some places on the Internet, but it’s taboo in some circles. Many fans wear rose-colored blinders, or even nay-say about the possibility of mishaps, following the neo-hippie mantra that “it’s all good”. But it isn’t, even with Phish, and discussing that is a necessary responsibility in comprehensively covering their history and music.

    December 29, 2010

    Venues: Phish History @ “Magical” Square Garden [Hidden Track]

    As much as the current MSG is home to Patrick Ewing, Mark Messier’s Stanley Cup Miracle in ’94, Ali/Frazier’s legendary prizefight in ’71 and Larry Johnson’s 4-point play, it has also become quite the home for Phish, since first playing there in 1994.  (Much like this venue was for The Grateful Dead). I figured that on today’s off-day of their five-night, New Year’s Run, including their first-ever show on New Year’s Day, that this would be a great opportunity to not only glance at MSG’s history as a whole, but specifically focus on the Phishtory The Garden has witnessed throughout the years.

    December 28, 2010

    Remembrances: NYE Runs Past w/ ZZYZX, Pt. 2 [Jambands]

    Today Jambands.com concludes its two-part look at Phish’s New Year’s Run past with David Steinberg, the original unofficial Phish statistician (aka Timer). The quartet opens its five-night New Year’s Run tonight at Worcester’s Centrum, now known as theDCU Center. The itinerary includes three nights at Madison Square Garden, featuring their first New Year’s Eve at the venue since their return from their first hiatus on December 31, 2002. TheMockingbird Foundation board member (a charitable organization setup by fans to distribute funds generated from the Phish community) was at the first Phish New Year’s Eve event (12/31/89), and has been back ever since.

    December 16, 2010

    Remembrances: Jams of December – 12/16 [Dog Gone Blog]

    Remembrances: Phish With a Side of Fun – 12/31/03 [Posterous]

    Remembrances: Remembering Raleigh [Phish Thoughts]

    December 14, 2010

    Remembrances: December Dark Horses [Phish Thoughts]

    December 13, 2010

    Remembrances: Thirteenth Throwdowns [Phish Thoughts]

    December 12, 2010

    Remembrances: Past NYE Runs [Kempepedia]

    December 9, 2010

    Remembrances: Number 9…Number 9 [Phish Thoughts]

    Remembrances: Jams of December  – 12/9 [Dog Gone Blog]

    December 8, 2010

    Remembrances: Exploring The Eighth [Phish Thoughts]

    December 7, 2010

    Remembrances: And On The Seventh Day [Phish Thoughts]

    December 1, 2010

    Remembrances: 11/30/1997 – Worcester Centrum [Dog Gone Blog]

    November 29, 2010

    Remembrances: A Look Back at Phish’s 20th Anniversary Run [HT]

    Remembrances: A Glimpse at Past New Year’s Runs [OPT]

    October 4, 2010

    Remembrances: The Riverport Gin [Dog Gone Blog]

    October 1, 2010

    Remembrances: A Show For The Weekend – The Crown ’98 [OPT]

    September 30, 2010

    Remembrances: 10th Anniversary of Vegas 2000 [Joy’s Jam]