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

    Joy RSS

    August 10, 2011

    Phish: 08/08/2011 Joy [VQ: A+, AQ: A+, Official Video]

    June 13, 2011

    Phish: 06/10/2011 MKDevo Entire Show Playlist [VQ: A, AQ: A+]

    Rocky Top, Mike’s Song, I Am Hydrogen, Weekapaug Groove, Stash, Tube, Guyute, Guelah Papyrus, Scent of a Mule, Cavern, The Sloth, The Curtain With, Down With Disease, Free, Possum, Big Black Furry Creatures From Mars, Swept Away, Steep, David Bowie, Julius, Fluffhead, Joy

    June 1, 2011

    Phish: Bethel Playlist by Nevaklass [VQ: B-, AQ: B]

    Poor Heart, Wolfman’s Brother, Bouncing, Bold As Love, Prince Caspian, Quinn The Eskimo, Makisupa Policeman, Cavern, A Day In The Life, AC/DC Bag, Oh Kee Pa > Suzy Greenberg, Curtis Loew, Simple, Meatstick, Joy, Tweezer Reprise,

    February 20, 2011

    Trey Anastasio: Trey Anastasio Band 02/19/2011 Video Playlist [VQ: A-, AQ: A-]

    http://www.youtube.com/view_play_list?p=87EE6AEF3328CBEB

    Free, The Wedge, Prince Caspian, BDTNL, Limb By Limb, Stealing Time, Buffalo Bill, Joy, Halley’s, Wading, Black, Valentine, Devil Went Down to Georgia, Money Love and Change, Done Done It, Clint Eastwood, Windora Bug, Birdwatcher, Sand, Drifting, The Way I Feel

    January 27, 2011

    Joy Tunes: Settling In Place [Phish Thoughts]

    October 20, 2010

    Phish: Charleston Video Playlist [VQ: A-, AQ: A+, CK5]

    http://www.youtube.com/view_play_list?p=0EB6F54FE12F24AC

    Fluffhead, Sneakin’ Sally, Uncle Pen, Kill Devil Falls, Dirt, PYITE, Possum, Mexican Cousin, Down With Disease, My Friend, Bill Bailey, Joy, Number Line

    May 11, 2010

    Looking Ahead: The Path of Joy [Phish Thoughts]

    Aside from Joy’s title track, a poignant ballad which works quite well as the landing point for jams, “Time Turns Elastic,” is the album’s only other piece that Phish infused into 2009 setlists with any regularity. Unfortunately, Trey’s meticulous orchestral composition bombed horribly as a rock song, chewing up valuable set time with anti-climactic, over-indulgent prog-rock.

    May 3, 2010

    Phish: 06/07/2009 Camden Set II Playlist (Sand, Tweezer, etc.) [VQ: B+, AQ: B+]

    http://www.youtube.com/view_play_list?p=54CF0205B088EF09

    December 2, 2009

    Reviews: Phish – Joy [Music Box]

    November 24, 2009

    Phish: 06/07/2009 Joy [VQ: A, AQ: A, PRO]

    YouTube Preview Image

    November 22, 2009

    Cute: Our Little Phishheads [Morgan Mothership]

    October 29, 2009

    Reviews: Phish – Joy [Here Comes The Flood]

    October 1, 2009

    Joy: Review – Phish’s Joy [Marquee]

    September 21, 2009

    Joy: Review – Phish Celebrates Happy Reunion [Toledo Blade]

    September 17, 2009

    Charts: Joy Debuts at #13 on the Top 200 Albums [Billboard]

    September 15, 2009

    Joy: New Phish Album Brings Joy to the World [The Justice]

    September 11, 2009

    Joy: Album Review – Phish’s Joy [Consequence of Sound]

    September 9, 2009

    Joy: Review – Phish Phans Jump For Joy [Newsday]

    September 8, 2009

    Joy: Review – Phish’s New Album [Washington Post]

    Joy: Phish Joy Review [Dog Gone Blog]

    Joy: Review – Phish Finds Joy [Row Knows]

    Joy: Review – Phish: Joy [JamBase]

    Joy: Review – Phish’s Joy [Los Angeles Times]

    Joy: Review – Phish’s Joy is Strong, Self-Assured [AP]

    September 4, 2009

    Features: Phish is Back with Joy [NPR]

    Hardcore Phish fans often say that you haven’t experienced Phish until you’ve seen the band live.

    “I have to agree with that statement,” Anastasio says, laughing. “Not that I’m trying to promote a record.

    “It’s interesting,” he adds, “because when we’re in the studio making a record, I already know that most of the fans aren’t really going to think much of it. I don’t necessarily worry that I’m going to please them, because what they want is the live show — they don’t really want this album. So many previous albums we’ve released have come out, and the hardcore fan base doesn’t really embrace it.”

    September 3, 2009

    Joy: Jamband Thank You Ma’am – Review [EW]

    Joy: A Review of Phish’s New Album [Burlington Free Press]

    September 1, 2009

    Contest: HT Giveaway – Win A Joy Box [Hidden Track]

    Joy: Jim DeRogatis Gives Phish’s New Album 2.5 Stars [Chicago Sun-Times]

    Joy: Review – A Glimpse of Joy [Phish Thoughts]

    August 28, 2009

    Phish: 08/13/2009 Joy [VQ: B-, AQ: A]

    YouTube Preview Image

    August 26, 2009

    Review: Phish Scores With Joy [Hidden Track]

    Whenever a renowned live act like Phish or the Grateful Dead or Widespread Panic record an album, there’s always talk of trying to replicate the band’s live sound in the studio. On most releases that doesn’t happen, but on Phish’s new album on JEMP Records – set to be released on September 8 – entitled Joy, producer Steve Lillywhite (Phish – Billy Breathes, DMB – Under The Table and Dreaming, U2 – October) has successfully captured the energy and spirit that has made the quartet one of the top touring acts of all time.

    August 12, 2009

    Joy: Details of Joy Box Revealed [Hidden Track]

    August 11, 2009

    Joy: Pre-Order Includes Special Joy Box Set [Dry Goods]

    In addition to the Joy CD, the Joy Box will include ten individual Limited Edition posters designed for each of the album’s 10 songs, a complete second album entitled Party Time, and a DVD capturing live performances from the first half of Phish’s summer 2009 tour – including footage from the Bonnaroo Music & Arts Festival and the tour’s opening date at Fenway Park in Boston.

    July 22, 2009

    Joy: Phish Release Album Art For New Album [Hidden Track]

    July 2, 2009

    Joy: A Live Preview of the New Album [The Examiner]

    June 25, 2009

    Joy: Phish Create Joy [Consequence of Sound]

    Joy: Tracklist Revealed For New Phish Album [Hidden Track]

    June 24, 2009

    Joy: Phish Capture Famous Live Vibe On New Album [Rolling Stone]

    Rolling Stone’s David Fricke recently spoke with the reunited Phish to get the story behind the Vermont quartet’s comeback album, which RS can exclusively report will be titled Joy.

    Phish: 06/20/2009 Joy [VQ: A-, AQ: C]

    YouTube Preview Image