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

    Live Phish RSS

    December 31, 2011

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

    From The Archives: Phish Announces New Archival Release – 12/31/1991 [Hidden Track]

    Tweezer McGrupp And The Watchful Hosemasters by HTBloggin

    December 30, 2011

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

    November 7, 2011

    Cactus: Free Download – Gordon, Murawski, Isler, Cleary, Myers Asheville  ’11 [LivePhish]

    October 20, 2011

    Trey Anastasio: TAB 10/13/2011 LivePhish SBD Silver Springs, MD

    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.

    September 15, 2011

    Phish: 09/14/2011 LivePhish SBD Essex, VT

    September 13, 2011

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

    September 5, 2011

    Phish: 09/04/2011 Live Phish SBD Denver, CO

    September 3, 2011

    Phish: 09/02/2011 LivePhish SBD Denver, CO

    August 26, 2011

    Free Downloads: Phish Live Bait Vol. 6 – Past Colorado Shows [LivePhish]

  • The Curtain > (1996-08-06 Red Rocks Amphitheatre – Morrison, CO)
  • Tweezer (1996-08-06 Red Rocks Amphitheatre – Morrison, CO)
  • Split Open And Melt (1994-06-11 Red Rocks Amphitheatre – Morrison, CO)
  • It’s Ice > (1993-08-20 Red Rocks Amphitheatre – Morrison, CO)
  • The Wedge (1993-08-20 Red Rocks Amphitheatre – Morrison, CO)
  • Mike’s Song > (1995-06-10 Red Rocks Amphitheatre – Morrison, CO)
  • I Am Hydrogen > (1995-06-10 Red Rocks Amphitheatre – Morrison, CO)
  • Weekapaug Groove (1995-06-10 Red Rocks Amphitheatre – Morrison, CO)
  • The Moma Dance > (2003-02-18 Pepsi Center – Denver, CO)
  • Limb By Limb (2003-02-18 Pepsi Center – Denver, CO)
  • McGrupp And The Watchful Hosemasters (Roma Bar – Telluride, CO – Colorado ’88)
  • Ghost (1997-11-17 McNichols Sports Arena – Denver, CO – LivePhish11)
  • David Bowie (1990-11-02 Glenn Miller Ballroom, University of Colorado – Boulder, CO)
  • Wilson > (1993-03-13 Balch Fieldhouse, University of Colorado – Boulder, CO)
  • Run Like An Antelope (1993-03-13 Balch Fieldhouse, University of Colorado – Boulder, CO)
  • August 18, 2011

    Phish: 08/17/2011 LivePhish SBD Chicago, IL

    August 16, 2011

    Phish: 08/15/2011 LivePhish SBD Chicago, IL

    August 15, 2011

    Phish: 08/12/2011 LivePhish SBD San Francisco, CA

    August 11, 2011

    Phish: 08/10/2011 LivePhish SBD Stateline, NV

    August 7, 2011

    Phish: 08/06/2011 LivePhish SBD George, WA

    August 6, 2011

    Phish: 08/05/2011 LivePhish SBD George, WA

    August 2, 2011

    Webcasts: Phish Lake Tahoe Webcasts – 8/9 & 8/10 [Hidden Track]

    July 5, 2011

    Phish: Super Ball IX LivePhish SBD – Day One, Day Two & Day Three Watkins Glen, NY

    June 20, 2011

    Phish: 06/19/2011 LivePhish SBD Portsmouth, VA

    June 19, 2011

    Phish: 06/18/2011 LivePhish SBD Raleigh, NC

    June 18, 2011

    Phish: 06/17/2011 LivePhish SBD Charlotte, NC

    June 16, 2011

    Phish: 06/15/2011 LivePhish SBD Alpharetta, GA

    June 15, 2011

    Phish Live From Alpharetta: Purchase Tonight’s Live Phish Webcast [Live Phish]

    Phish: 06/14/2011 LivePhish SBD Alpharetta, GA

    June 13, 2011

    Phish: 06/12/2011 LivePhish SBD Columbia, MD

    Phish: 06/11/2011 LivePhish SBD Columbia, MD

    June 11, 2011

    Phish: 06/10/2011 LivePhish SBD Camden, NJ

    June 9, 2011

    Phish: 06/08/2011 LivePhish SBD Darien, NY

    June 8, 2011

    Phish: 06/07/2011 LivePhish SBD Mansfield, MA

    June 6, 2011

    Phish: 06/05/2011 LivePhish SBD Cincinnati, OH

    June 5, 2011

    Phish: 06/04/2011 Live Phish SBD Cuyahoga Falls, OH

    June 4, 2011

    Phish: 06/03/2011 LivePhish SBD Clarkston, MI

    June 2, 2011

    Phish: 06/01/2011 LivePhish SBD Holmdel, NJ

    May 30, 2011

    Phish: 05/29/2011 LivePhish SBD Bethel, NY

    May 29, 2011

    Phish: 05/28/2011 LivePhish SBD Bethel, NY

    May 20, 2011

    Downloads: Phish Live Bait Vol. 4 – Four Hours of Free Tracks [LivePhish]

    Phish archivist Kevin Shapiro has put together this compilation of unreleased tracks from Phish’s past summer shows. Consider this must-download/stream material and check it out immediately – ScottyB

    April 9, 2011

    Giveaways: Win A Copy of 10/30/2010 LivePhish Remaster [OKPBlog]

    March 24, 2011

    LivePhish: Phish For Japan [Phish Thoughts]

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

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

    Trey Anastasio: TAB 03/04/2011 LivePhish SBD Hollywood, CA

    March 9, 2011

    Trey Anastasio: TAB 02/27/2011 LivePhish SBD Chicago, IL

    March 6, 2011

    Trey Anastasio: TAB 02/26/2011 LivePhish SBD Columbus, OH

    February 2, 2011

    Remasters: Live Phish Remasters – Part Two [Hidden Track]

    Our friends at JEMP have provided us some remastered tracks to share, so you can sample the quality of these releases. They also sent a few blurbs about each performance written by Phish archivist Kevin Shapiro to give a little background on these shows. READ ON for audio samples…

    January 18, 2011

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

    Remasters: Sample Each Live Phish Remaster [Hidden Track]

    December 29, 2010

    Phish: 12/28/2010 LivePhish SBD Worcester, MA

    December 28, 2010

    Phish: 12/27/2010 LivePhish SBD Worcester MA

    December 2, 2010

    Free Downloads: Live Bait Volume 3 (STREAM) [LivePhish]

    Countdown/Auld Lang Syne >
    (1993-12-31 Worcester Centrum – Worcester, MA)

    Down With Disease Jam >
    (1993-12-31 Worcester Centrum – Worcester, MA)

    Split Open And Melt
    (1993-12-31 Worcester Centrum – Worcester, MA)

    Runaway Jim
    (1997-11-29 Worcester Centrum – Worcester, MA)

    Llama
    (1991-12-31 Worcester Memorial Auditorium “The New Aud” – Worcester, MA)

    November 1, 2010

    Phish: 10/31/2010 Live Phish SBD Atlantic City, NJ

    Phish: 10/30/2010 LivePhish SBD Atlantic City, NJ

    October 30, 2010

    Phish:  10/31/2010 LivePhish SBD Atlantic City, NJ

    October 27, 2010

    Phish: 10/26/2010 LivePhish SBD Manchester, NH

    October 25, 2010

    Phish: 10/24/2010 LivePhish SBD Amherst, MA

    October 24, 2010

    Phish: 10/23/2010 LivePhish SBD Amherst, MA

    October 23, 2010

    Phish: 10/22/2010 LivePhish SBD Providence, RI

    October 21, 2010

    Phish: 10/20/2010 LivePhish SBD Utica, NY

    October 20, 2010

    Phish: 10/19/2010 LivePhish SBD Augusta, ME

    October 17, 2010

    Phish: 10/16/2010 LivePhish SBD N. Charleston, SC