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

    LivePhish RSS

    August 6, 2012

    Couch Tour: LivePhish.com Will Webcast All Three San Francisco Phish Shows

    June 14, 2012

    Webcasts: Phish to Offer Pay-Per-View Webcasts of Next Week’s Portsmouth Shows

    June 10, 2012

    New Vault Release: Phish – Chicago ’94 Box Set Due This July [Hidden Track]

    May 23, 2012

    Free Downloads: Live Bait Volume 7 [LivePhish.com]

    December 29, 2011

    Phish: 12/28/2011 LivePhish SBD New York, NY

    December 15, 2011

    Apps: LivePhish App Is Worth Fans’ Money, Despite Bugs [Evolver.FM]

    December 13, 2011

    Webcasts: Phish To Offer Pay-Per-View Webcasts of MSG NYE Run [Hidden Track]

    Continuing a trend started last New Year’s Run, Phish is once again teaming up with Nugs.net to offer Pay-Per-View broadcasts of all four NYE Run shows set to take place at Madison Square Garden on December 28-31. If you look at the LivePhish page for the MSG shows, you’ll see a link for a $55 four-day pass marked as “Live Video.”

    October 17, 2011

    Live Phish: Phish to Release Hampton / Winston-Salem ’97 [Hidden Track]

    When discussing the Holy Grail of Phish shows stuck inside the band’s vault, the Hampton ’97 performances and Big Cypress are usually towards the top of most fans’ lists. On December 6, Phish fans will finally get to hear the Hampton ’97 performances in all their Fred Kevorkian-mastered soundboard glory when JEMP Records puts out Hampton / Winston Salem ’97. The wonderful kicker is that the band has attached the severely underrated November 23, 1997 show to this seven-CD set that will also include never-before-heard soundchecks.

    October 16, 2011

    Trey Anastasio: TAB 10/12/2011 LivePhish SBD Montclair, NJ

    October 12, 2011

    Trey Anastasio: TAB 10/07/2011 LivePhish SBD Myrtle Beach, SC

    October 4, 2011

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

    September 13, 2011

    Apps: Live Phish App Now Available For Android [Hidden Track]

    August 10, 2011

    Phish: 08/09/2011 LivePhish SBD Lake Tahoe, NV

    August 9, 2011

    Phish: 08/08/2011 LivePhish SBD Hollywood, CA

    June 1, 2011

    Phish: 05/31/2011 LivePhish SBD Holmdel, NJ

    May 28, 2011

    Phish: 05/27/2011 LivePhish Official Recording Bethel, NY

    March 23, 2011

    New Live Phish: Phish Releases July 31, 1999 Show For Charity [Hidden Track]

    Phish’s first-ever shows in Japan took place during the Summer of 1999, when the band traveled across the Pacific to perform at the Fuji Rock Festival. A new Live Phish release titled Japan Relief looks at the July 31, 1999 show from Fuji Rock to benefit Peace Winds America with proceeds going to help the disaster relief efforts following the earthquake and subsequent tsunami that wreaked havoc on Japan.

    March 15, 2011

    Trey Anastasio: TAB 03/05/2011 LivePhish SBD Oakland, CA

    March 10, 2011

    Trey Anastasio: TAB 03/01/2011 LivePhish SBD Denver, CO

    March 4, 2011

    Downloads:  Free Mike Gordon Band Download 11/16/2010 SBD [LivePhish]

    Back on November 16, Mike Gordon and the Mike Gordon Band took the stage at the Fine Line Music Cafe in Minneapolis, Minn. for a rollicking performance that HT’s Joe Ringus felt opened with a sizzling Can’t Stand Still and “never let up.” With the MGB about to kick off its first tour of 2011 tomorrow night in Eugene, Oreg.; the Phish bassist has shared a free MP3 soundboard download of the group’s show at the Fine Line Music Cafe. [via HT]

    March 1, 2011

    Trey Anastasio: TAB 02/20/2011 LivePhish Official SBD Boston, MA

    February 23, 2011

    Trey Anastasio: TAB Albany – Live Phish & Photos by Andy Hill [Hidden Track]

    This past Saturday night, the Trey Anastasio Band delivered its best performance of the tour thus far at the Palace Theater in Albany, NY. While official recordings from last year’s shows were not made available through LivePhish.com outside of the TAB at the TAB release, we’re glad to see that Big Red has opted to make the Albany sets available forpurchase and download.

    January 27, 2011

    Remasters: Phish Confirms Additional LivePhish CD Releases [Jambands]

    January 18, 2011

    Purchase Live Phish Remasters on Amazon.com: 06/27, 07/03 & 07/04

    January 3, 2011

    Phish: 01/01/2011 LivePhish SBD New York, NY

    January 1, 2011

    Phish: 12/31/2010 LivePhish SBD New York, NY

    December 31, 2010

    Phish: 12/30/2010 LivePhish SBD New York, NY

    December 21, 2010

    Free Downloads: Xmas Present From Trey [Hidden Track]

    Trey Anastasio: 11/18/2010 Official Release, Free Princeton, NJ

    • Free MP3 download from Trey Anastasio
    • Recorded 11/18/10 at Richardson Auditorium, Princeton University, Princeton, NJ
    • Trey Anastasio – vocals, acoustic guitar, piano
    • Gregor Kitzis – violin
    • Maxim Moston – violin
    • Martha Mooke – viola
    • Leah Coloff – cello
    • Kris Saebo – bass

    October 9, 2010

    Phish: 10/08/2010 LivePhish SBD Austin, TX

    October 5, 2010

    Free Downloads: How the LP Free Downloads Will Work [PhishNet]

    Apps: Live Phish Clinches Best Touring App Award [Billboard.biz]

    Brad Serling, CEO of Live Phish builder Nugs.net said more than 10,000 fans of the touring jam band downloaded the app during its first week, and 17% of those downloaders went on to purchase concert audio as well as Phish back catalog items through the app.

    August 19, 2010

    Phish: 08/18/2010 LivePhish SBD Wantagh, NY

    August 18, 2010

    Phish: 08/17/2010 LivePhish SBD Wantagh, NY

    August 16, 2010

    Phish: 08/15/2010 LivePhish SBD East Troy, WI

    Phish: 08/14/2010 LivePhish SBD East Troy, WI

    August 13, 2010

    Phish: 08/12/2010 LivePhish SBD Noblesville, IN

    August 12, 2010

    Phish: 08/10/2010 LivePhish SBD Telluride, CO

    August 10, 2010

    Phish: 08/09/2010 LivePhish SBD Telluride, CO

    August 8, 2010

    Phish: 08/07/2010 LivePhish SBD Berkeley, CA

    July 5, 2010

    Phish: 07/04/2010 LivePhish SBD Alpharetta, GA

    July 2, 2010

    Phish: 07/01/2010 LivePhish SBD Raleigh, NC

    June 30, 2010

    Phish: 06/29/2010 LivePhish SBD Canandaigua, NY

    June 28, 2010

    Phish: 06/27/2010 LivePhish SBD Columbia, MD

    Phish: 06/26/2010 LivePhish SBD Columbia, MD

    June 26, 2010

    Phish: 06/25/2010 LivePhish SBD Camden, NJ

    June 23, 2010

    Phish: 06/22/2010 LivePhish SBD Mansfield, MA

    June 20, 2010

    Phish: 06/19/2010 LivePhish SBD Saratoga Springs, NY

    June 17, 2010

    Apps: Phish App an iHit [AntiMusic]

    June 16, 2010

    Phish: 06/15/2010 LivePhish SBD Portsmouth, VA

    June 15, 2010

    Apps: Band App Done Right – Live Phish [ZDNet]

    There are a ton of band apps on the App Store, but Phish’s offering shows some ingenuity in how a touring band can take advantage of the platform and provide something really useful to its fans.

    June 13, 2010

    Phish: 06/12/2010 LivePhish SBD Cuyahoga Falls, OH

    Apps: LivePhish iPhone App [Here Comes The Flood]

    June 12, 2010

    Official Recordings: 06/11/2010 LivePhish SBD Chicago, IL [LivePhish]

    February 23, 2010

    Contests: Giveaway – New Mike Gordon Band Live Album [Hidden Track]

    As Mike Gordon’s solo band prepares to take the road for an eight-show tour next week starting at Revolution Hall in Troy, NY; the bassist has announced the release of a blockbuster show from his last tour with the five-piece band, 10/03/2009 from the Town Ballroom in Buffalo, on CD and as a download (in both MP3 and FLAC formats) at LivePhish.com.

    February 1, 2010

    Reviews: LivePhish 11/19/1992 St. Michael’s [Jambands]

    January 27, 2010

    Official Releases: New Live Phish – St. Mike’s ’92 [Hidden Track]

    Nearly 11 months after the release of the Clifford Ball DVDs, the LivePhish archive has finally opened again with the release of a show from November 19, 1992 at St. Mike’s College in Colchester, VT. Phish archivist Kevin Shapiro hinted at this show’s release when he played the epic Divided Sky from 11/19/92 during one of his From The Archives radio shows at Festival 8.

    Phish: 11/19/1992 LivePhish SBD Colchester, VT

    January 2, 2010

    Phish: 12/31/2009 LivePhish SBD Miami, FL

    December 31, 2009

    Phish: 12/30/2009 LivePhish SBD Miami, FL