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

    Lists RSS

    August 27, 2012

    Lists: Five Quick Things Noticed at Charlotte Phish Show [Creative Loafing]

    February 26, 2012

    Lists: Best Shows of 3.0 So Far [Some Other Place, The Right Place]

    February 16, 2012

    Lists: Stage Setlist Porn (inc. Phish Song List) [Hidden Track]

    February 13, 2012

    Lists: Top 20 Worst Bands of All-Time [LA Weekly]

    February 9, 2012

    Lists: 10 Songs Trey & Symphony Should Play [Hidden Track]

    January 25, 2012

    Lists: Mr. Miner’s Wish List for 2012 [Phish Thoughts]

    January 15, 2012

    Lists: Hall of Fame Embarrassing Songs & Performances [Grantland]

    January 6, 2012

    Lists: The Top 10 Jams of 2011 [Phish Thoughts]

    December 28, 2011

    Lists: Why Has Phish Forsaken Us? [Broward New-Times]

    1) #OccupyShakedownStreet makes too much sense.
    Since the scene at Zuccotti got busted up, Occupy protesters have been in need of a place to converge, play drums, mingle, eat vegan food and make cardboard signs. They are going to love Phish a lot! In contrast to Occupy encampments, drugs and alcohol are not prohibited on Phish lot — regardless of what “the man” says — so it’ll be a great chance for the 99 percent to really get down together, which may be a healthy thing for the movement.

    Lists: The Year in Vermont Music [Seven Days]

    December 26, 2011

    Lists: Top Headlines of 2011 – #6: “Phish Rages The Glen [Corning Leader]

    December 21, 2011

    Lists: A Look at the Songs Phish Has Played After Auld Lang Syne [OPT]

    December 19, 2011

    Lists: Jam_ON’s Top 50 Phish Songs [Oliver Jam Review]

    December 10, 2011

    Lists: Really Nice Tour Rider Demands [MTV Hive]

    December 8, 2011

    Lists: 10 Best Archival Releases of 2011 [Hidden Track]

    November 17, 2011

    Lists: 10 Notable Changes in the World of Phish Since Bittersweet Motel [Hidden Track]

    6) Digital Cameras: The gag with Brad Sands intentionally cutting the heads off of fans seeking photos with the band members would never fly in the binary world. Since Bittersweet Motel, not only have we lived through the popularization of digital cameras, but now the majority of concertgoers have one on their phone.

    Lists: Box This – OPT’s Archival Release Wish List [Online Phish Tour]

    7/19-21/1998 (Audio in compilation: 7/19 Ghost, Limb, YEM; 7/20 Gin, Drowned, Makisupa, Halley’s; 7/21 Ghost, She Caught the Katy)
    Summer ‘98 is often brushed off by vets that claim it’s the year of gimmicky covers and ambient jams. However, I argue that July of ‘98 is one of the best months of Phish ever. They take the funk from ‘97, only now it’s cleaned up and mature.

    Everyone already knows about the crazy Gorge ‘98 shows (and the recordings are not bad), so let’s go to the following nights that have been overshadowed, starting with 7/19 at Shoreline and finishing with 7/21 at Desert Sky.

    November 15, 2011

    Lists: Seven Significant Musical Hiatuses [Relix]

    October 22, 2011

    Lists: 6 Scariest Music Fanbases [MTV.com]

    October 6, 2011

    Lists: The B List – Nine Phish Song Title Swaps [Hidden Track]

    4. Microdot -> Mike’s Song

    Most tunes written at the beginning of Phish’s career were penned by Anastasio, so when bassist Mike Gordon brought a song to the band they simply called it “Mike Wrote That” or “Microdot.” Trey announced this original title from stage on October 17, 1985 and at some point shortly after that the title morphed to Mike’s Song. The rest, as they say, is history.

    August 4, 2011

    Lists: Eight Reasons To Get Excited For Phish Tour [Hidden Track]

    The Return of 2.0 Epics

    Leading up to the first leg, we were perplexed by the lack of 2.0 opuses in the setlists since Hampton. One of the biggest tragedies of Phish breaking up when they did is that we never got to see A Song I Heard The Ocean Sing, Scents and Subtle Sounds and Waves develop. Thankfully, all three tunes were brought back during the first leg and we have high hopes that they will find their way into setlists this month.

    August 3, 2011

    Haters: 5 Things to Like About OSL Schedule [SF Weekly]

    1. There are plenty of ways to avoid Phish.
    Doubtless, some of you will be seeking to actually catch Phish (ha!) — and to you, well, godspeed. But those of us who require a minimum 200-yard distance from any jam bands are well served by Friday’s schedule, which offers such enticements as Big Boi, Erykah Badu, Best Coast, the Shins, and Big Audio Dynamite, all while Phish noodles on the main stage for more than three hours.

    July 13, 2011

    Lists: Top 50 Worldwide Tours (Phish = #50) [Pollstar]

    July 12, 2011

    Lists: 20 Minute Jam Chart [Phish.net]

    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”.

    June 28, 2011

    Lists: Ten Things We Learned on Leg One [Unplugged Musings]

    Lists: @bizarchive’s Spreadsheet of 20 Minute Phish Jams [Google Doc]

    June 23, 2011

    Tour Recaps: In Not-So-Heavy-Rotation – The One-Offs [Online Phish Tour]

    Vultures – 6/11 Merriweather Post – This song has never gotten its due.  Overshadowed by the rest of the tunes that would make up The Story of the Ghost, there have been moments where I felt this song was geared to make a big comeback… but it’s just never cracked the rotation.  I’m not sure why that it is.  This song has everything a Phish song should, strange rhythms, bizarre lyrics, and some peaks that will make you pump your fist.  Here’s hoping Vultures gets better setlist treatment in the future.  Unfortunately, if it hasn’t happened yet… it’s probably not happening.

    June 14, 2011

    Lists: Phish Merriweather Post Pavilion – A to Z [Hidden Track]

    K is for Keep Halfway to the Moon Around – Outside of Show of Life Phish has ignored all of the originals they debuted in 2010 so far this summer until Sunday when they finally played Page’s Halfway to the Moon again. Let’s hope we don’t have to wait another 23 shows for the next one.

    June 7, 2011

    Lists: Five Great Tidbits From Lars Fisk/Trey Anastasio Interview [Hidden Track]

    May 31, 2011

    Lists: 10 Developments From Bethel [Online Phish Tour]

    2. Twelve Minute Kill Devil Falls, Anyone?: What if I told you that Fluffhead and Weekapaug would be two of the worst played tunes of the weekend, that there would be no YEM, Reba, Ghost or Divided Sky…but the shows would still contain some of the best jamming of 3.0? KDF, BOTT, BDTNL and, of course, a resurgent Halley’s were just a few songs that were stretched way past the norm.  The band has apparently put some conscious effort into revitalizing their communication and creativity on stage, and the result is that now anything can truly happen in any song.  Considering this is a trend that has carried over from the end of last tour, don’t expect if to go anywhere soon.

    May 25, 2011

    Lists/Songs: Fifteen Favorite Harry Hoods [Hidden Track]

    Over the course of Hidden Track’s lifespan, we’ve taken a couple different stabs at making a list of favorite Hoods, and it felt like a good time for the next iteration. It will remain a perpetual work in progress as the band plays new renditions and old gems get discovered, but nevertheless, it’s coming along. This time, we have a meticulously organized, iPod-ready downloadfor your enjoyment as well as a stream at the bottom of the post. While these are mostly audience recordings or soundboards that are not part of official releases, but we tried to normalize the levels and made sure the volume is plenty loud. Without further ado, here is the list…

    May 3, 2011

    Lists: The Elusive Ones [Online Phish Tour]

    April 12, 2011

    Lists: Five Guitarists Who Can Tango With Trey [Dog Gone Blog]

    April 11, 2011

    Lists: Ten Worst Rock Bands of All-Time [MadeMen]

    March 30, 2011

    Lists: 10 Underrated Moments of Phish 3.0 [Dog Gone Blog]

    March 23, 2011

    Lists: Top Phish Jams of 2010 [Louisville Jams]

    March 22, 2011

    Lists: Five Songs For Spring [Online Phish Tour]

    February 24, 2011

    Lists: If Phish Songs 3.0 Were a Ratings Scale [PhanArt]

    February 20, 2011

    Lists: Top 10 Phish Jams of 2010 [The Phish Experience]

    February 18, 2011

    Lists: 10 Things You May Not Remember From TAB ’99 Tour [HT]

    6) Bug was a TAB song first

    We’ve been taking a trip down memory lane as we revisited all of the audio from the Trey ’99 tour and one constant I found was that while everyone knows that Sand, First Tube, Gotta Jibboo etc. came from this tour, a lot of people forget that there were two electric performances of Bug in ’99 before it hit the Phish stage. Hear the first one and Trey describing the songwriting experience with Tom.

    February 17, 2011

    Lists: Five… [Phish Thoughts]

    …2.0 Songs That Deserve More Play

    1. The Song I Heard the Ocean Sing

    2. Scents and Subtle Sounds

    3. Waves

    4. Round Room

    5. Discern

    February 16, 2011

    Lists: Music’s Top 40 Money Makers of 2011 [Billboard]

    February 10, 2011

    Lists: Do The Evolution – 200 Essential Phish Shows [Hidden Track]

    Given this context, I set out to compile a list of shows (and multi-night stands) that roughly document the various stages of Phish, their sound and their emergence as a cultural phenomenon. It should be noted that the list is not intended to be a “best of.” Rather, it’s a guide for those that love the band and want to revisit key moments in Phistory.

    Best Jams of 2010: Behind the Best Jams List [TypeIICast]

    February 8, 2011

    Remasters: While They’re At It… [Phish Thoughts]

    January 18, 2011

    Lists: The Top Ten of 2010, Pt. 1 [Phish Thoughts]

    9. 06/27/2010

    Merriweather’s second show represented the peak of Phish’s most impressive weekend of Leg I. Completing a four-night stand that started in Camden, the band punctuated their Mid-Atlantic run with a thematic second set. Responding to a sign for “Saw It Again,” Trey chopped into the song amidst the liquid funk of “Meatstick,” and initiated a wild second set in which the band wove lyrical teases of “Saw It Again” in each subsequent song, capping the night with the the unforgettable—”Boy. Man. I Saw It Again!” And smack dab in the middle of this musical trickery was a centerpiece of “Piper,” one of the outstanding excursions of June. Throw in a rocking jaunt of “Ghost > Jumping Jack Flash” and solid first set, and you’ve got yourself a nice little Phish show.

    January 10, 2011

    Lists: Phish MSG Run From A-Z [Hidden Track]

    G is for Guinness Book - For the second year in a row, Phish managed to break their own personal record (it’s really just a Phish record, not a Guinness Book record) for the most songs performed in a single year. Last year, they set the bar at an amazing 247, but this year the band eclipsed the mark and ended at 250 when they played Manteca, Auld Lang Syne, and Grind.

    Lists: Best Phish Cover Songs [UGO]

    December 21, 2010

    Lists: Jim Harrington’s Best Live Shows of 2010 [Oakland Tribune]

    5. Phish, Aug. 5 (first night of 3), Greek Theatre, UC Berkeley: Phans, the Phish equivalent to the Deadheads, will be talking about the band’s three-night Berkeley run for years to come (at least those who could get in — tickets for all three nights sold out in a heartbeat). Phish has no problem selling out 20,000-plus-seat amphitheaters, so part of the appeal was to see them in a comparatively intimate 8,500-capacity building. The group, led by guitar god Trey Anastasio, was in top form throughout the stand, but opening night delivered the most oomph.

    December 20, 2010

    Lists: The 15 Most Eco-Friendly Rockers [Rolling Stone]

    December 17, 2010

    Lists: Rock Tees in Movies [Hollywood Reporter]

    Lists: Magical Moments @ MSG [Phish Thoughts]

    December 14, 2010

    Lists: 20 Bands That Inspire Fans to Tattoo [Westworld]

    December 10, 2010

    Lists: 10 Best Archival Releases of 2010 [Hidden Track]

    5. Phish – 11/19/1992 For Haiti

    There wasn’t much in the way of audio-only archival releases from Phish in 2010, but the group did put out the magnificent Fall Tour ’92 opener from St. Mike’s to help raise money for Haitian Earthquake Victims. This performance  featured the first-ever versions of Axilla, I Walk The Line (Johnny Cash cover), Big Ball Jam, Fast Enough For You and Lengthwise. Longtime Phish friend Gordon Stone joined the band on pedal steel for Poor Heart, Fast Enough For You and Llama and the release also includes fantastic versions of Divided Sky and Mike’s Song.

    Lists: Ten Tunes For Worcester [Phish Thoughts]

    December 9, 2010

    Lists: Top 25 Grossing Tours of 2010 [Billboard]

    Total Gross: $33,240,962        Number of Shows: 43
    Total Attendance: 658,243  Number of Sell-Outs: 21

    December 3, 2010

    Lists: Best Concert DVDs of 2010 [Hidden Track]

    Lists: Bands That Have to be Seen Live [AV Club]

    November 12, 2010

    Lists: Asheville’s Biggest Shows [Citizen-Times]