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"; } } ?> New Year’s Eve | YEMblog

    New Year’s Eve RSS

    October 2, 2012

    Tour Dates: Phish Announces Four-Night New Year’s Run at Madison Square Garden + A Look at Past Phish New Year’s Runs

    February 7, 2012

    Phish: 12/31/1996 Peaches En Regalia [VQ: A-, AQ: A-]

    YouTube Preview Image

    January 31, 2012

    The Steam Stunt: David Gallo Reveals How the NYE Gag Came Together [Live Design]

    With its latest stunt in what has become an annual tradition, Phish played Madison Square Garden in New York City for a sold-out four-day run that included New Year’s Eve. The final show featured a few visual and rigging tricks dreamed up by Tony Award-winning scenic designer David Gallo, working alongside the band members, with lighting by longtime Phish collaborating LD Chris Kuroda

    January 15, 2012

    Phish: 12/31/2011 Fluffhead [VQ: A+, AQ: A+, Official]

    January 7, 2012

    NYE Run Recaps: Couch Tour Review – Phish NYE [411Mania]

    January 2, 2012

    NYE: YEMSG4 – NYE Recap [Phish.net]

    The Gag: Your Soul Joins Mine [Phish Thoughts]

    NYE: I Think That This Exact Thing Happened To Me… [Smooth Atonal Sound]

    Phish: 12/31/2011 Steam > Auld Lang Syne > Down With Disease [VQ: A-, AQ: A+]

    YouTube Preview Image

    NYE: All In A Phish New Year’s Night [On The Phish Beat]

    NYE: Phish NYE Rocks The Baked Apple [Celebstoner]

    NYE: Phish Ring in New Year’s at MSG [American Songwriter]

    January 1, 2012

    New Year’s Eve: Phish New Year’s Eve Spectacle [Jambands.com]

    Phish: 12/31/2011 MKDevo Playlist [VQ: A, AQ: A+]

    Set One: AC/DC Bag > Wolfman’s Brother, Scent of a Mule, Stealing Time From the Faulty Plan, Lawn Boy, Gotta Jibboo, Farmhouse, Pebbles and Marbles, Ocelot, Fluffhead1

    Set Two: Party Time, Light > Golden Age, Theme From the Bottom, Heavy Things, Ghost, Sneakin’ Sally through the Alley, 46 Days, Suzy Greenberg

    Set Three: Cavern, Steam2 > Auld Lang Syne > Down with Disease3, The Wedge, Alaska, Wading in the Velvet Sea, First Tube

    Encore: Slave to the Traffic Light

    Notes:
    [1] Auld Lang Syne tease
    [2] with gag
    [3] gag reprise

    [Playlist Will Update Throughout The Day]

    Reviews: 12/31 – An Anticlimactic Ending [Phish Thoughts]

    Phish: 12/31/2011 Steam > Auld Lang Syne > Down With Disease [VQ: A, AQ: A+]

    YouTube Preview Image

    New Year’s Eve: Phish Madison Square Garden New Year’s Eve Live Blog, Setlist & The Skinny [HT]

    December 31, 2011

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

    Tweezer McGrupp And The Watchful Hosemasters by HTBloggin

    December 28, 2011

    Couch Tour: How To Rage With Phish on NYE [Broward New Times]

    December 15, 2011

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

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

    December 9, 2011

    Contests: Phish NYE Ticket Giveaway [Phish PDX]

    December 6, 2011

    Phish: 12/31/1999 – 01/01/2000 Most of Midnight to Sunrise Set [VQ: Varies, AQ: B+]

    October 11, 2011

    New Year’s Eve: Phish New Year’s Run at Madison Square Garden 12/28 – 12/31 [Hidden Track]

    HT faves Phish will return to Madison Square Garden for a four-night New Year’s Run in New York City on December 28-31. This marks the jamband’s sixth New Year’s Eve show at the newly renovated venue and 20th – 23rd Phish shows ever at the storied arena.

    July 12, 2011

    Phish: 01/01/2000 Bathtub Gin [VQ: B, AQ: B+]

    YouTube Preview Image

    July 6, 2011

    Phish: 12/31/2010 Sand [VQ: A+, AQ: A+, Pro-Shot]

    YouTube Preview Image

    Phish: 12/31/2010 Ghost [VQ: A+, AQ: A+, Pro-Shot]

    YouTube Preview Image

    May 27, 2011

    Phish: 12/31/1998 New Source DAUD New York, NY

    May 17, 2011

    Phish: 12/31/1998 Entire Show Playlist [VQ: B+, AQ: A-]

    setlist via phish.net

    Thursday, 12/31/1998
    Madison Square Garden, New York, NY

    Set 1: 1999[1] > Mike’s Song > I Am Hydrogen[2] > Weekapaug Groove[3], Ghost -> Ha Ha Ha > Cavern

    Set 2: NICU > Character Zero > Tweezer -> Cities > Wading in the Velvet Sea, Run Like an Antelope > Frankenstein

    Set 3: Runaway Jim[4] -> Auld Lang Syne -> Simple[5], Harry Hood > Tweezer Reprise, Llama

    Encore: While My Guitar Gently Weeps

    [1] Phish debut.
    [2] Albert teases from Trey.
    [3] 1999 teases.
    [4] 1999 and Auld Lang Syne teases.
    [5] Magilla teases.

    [via Phish Video Collection]

    May 15, 2011

    Phish: 12/31/1995 Delay Loop Jam [VQ: A-, AQ: A-]

    YouTube Preview Image

    March 22, 2011

    Phish: 12/31/1998 ENTIRE SHOW PLAYLIST [VQ: B+, AQ: A-]

    http://www.youtube.com/view_play_list?p=2C315130C31329CD

    March 6, 2011

    Phish: 12/31/1998 Mike’s Song [VQ: B+, AQ: A]

    YouTube Preview Image

    March 4, 2011

    Phish: 10/22/2010 + 12/31/2010 Rock and Roll [VQ: A-, AQ: A+]

    YouTube Preview Image

    March 3, 2011

    Video: 12/31/1998 1999 (Prince Cover) [VQ: B+, AQ: A-]

    YouTube Preview Image

    Phish: 12/31/1998 Runaway Jim > New Year’s Eve > Simple [VQ: B+, AQ: A-]

    YouTube Preview Image

    February 9, 2011

    Phish: 12/31/2010 YEMteca [VQ: B+, AQ: A+]

    YouTube Preview Image

    January 31, 2011

    Phish: 01/01/2000 Big Cypress Pro-Shot Compilation [VQ: A, AQ: A, PRO-SHOT]

    YouTube Preview Image

    Llama
    (fade in) Bathtub Gin – 3:42
    Heavy Things Intro – 16:30
    Heavy Things – 20:12
    Twist Around – 27:30
    Prine Caspian – 40:50
    Rock & Roll (fade out) – 49:47

    January 27, 2011

    Debates: Tales of Mental Tangle #3 – NYE Weekapaugs [Online Phish Tour]

    Weekapaug Groove has appeared in nine of Phish’s fifteen New Year’s Eve shows. Most of those versions have included Auld Lang Syne teases, and three either went into or came out of Auld Lang Syne. Many–and in particular, ’94 and ’03–have included other teases or jams of note. But two New Year’s Weekapaugs have stood out from the rest: 12/31/95 and 12/31/97. Those two will face off in this Tale of Mental Tangle to determine which stands tallest.

    January 24, 2011

    New Year’s Eve: 12/31/2010 Recap and Review [Phish Experience]

    January 16, 2011

    Audience Recordings: Comparison of 12/31/2010 Sources [ListeningRoom]

    January 12, 2011

    Phish: 12/31/2010 The Ghost Jam [VQ: B+, AQ: B+]

    YouTube Preview Image

    Phish: 12/31/2010 MKDevo Playlist [VQ: A, AQ: A+]

    http://www.youtube.com/view_play_list?p=58747E74B6D87532

    Punch, Scent, Burn That Bridge, Weigh, Beauty of My Dreams, Gone, Wilson, Meatstick Madness

    January 10, 2011

    NYE Stunts: Making Phish’s “Meatstick” Dance [Jambands]

    How did you get involved with the band and when did they first approach you about working with them on the NYE gag?

    About a month ago I got a call from a choreographer friend of mine who I’d met two years ago at the Stratford Shakespeare Festival. I hadn’t heard from her in about a year and a half and randomly I get an e-mail asking if I wanted to work with her on a gig, but I wasn’t allowed to know what it was until I signed a confidentiality agreement because they wanted to keep everything hush-hush. I really wanted to work with her so I said yes to whatever it was. And then the producers called me and had me go to their office and signed all of these confidentiality waivers. Then I flipped to the next page where it said “Phish New Years Eve Madison Square Garden,” which I was trying to get a ticket for anyway. So it was pretty crazy.

    NYE Stunts: David Gallo Goes Phishing [Live Design]

    January 3, 2011

    Famous Persnickety Bloggers: Phish NYE @ MSG [Lefsetz]

    I’d like to tell you this Phish broadcast from MSG sucks.  That technology is not up to snuff.  But I’d be lying if I said so.  The majordomos at the labels may think the public is not ready for the future, but the public is already living in it!

    NYE Run: Phish Celebrates 2011 With A Bang [Consequence of Sound]

    NYE Run: MSG 2010 => 2011 [Online Phish Tour]

    Phish: 12/31/2010 Meatstick [OFFICIAL VIDEO, VQ: A+, AQ: A+]

    Phish: 12/31/2010 ENTIRE SHOW HarpuaFSB Playlist [VQ: A, AQ: A+]

    http://www.youtube.com/view_play_list?p=CAA95294BEF32B89

    January 1, 2011

    NYE: Phish Revives New Year’s Stunt at MSG [Jambands]

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

    Phish: Meatstick -> Auld Lang Syne -> After Midnight [VQ: A+, AQ: A+]

    YouTube Preview Image YouTube Preview Image

    Phish: 12/31/2010 DAUD New York, NY

    NYE: Phish MSG 12/31/2010 Review [A Billion]

    December 23, 2010

    Humor: MSG at NYE – Jaded Vet Conversation

    YouTube Preview Image

    December 12, 2010

    Remembrances: Past NYE Runs [Kempepedia]

    October 8, 2010

    Phish: 12/31/1995 The Sloth [VQ: B+, AQ: B+]

    YouTube Preview Image

    September 23, 2010

    NYE Run: Phish Announces New Year’s Run – MSG and DCU [Hidden Track]

    As we gear up for the start of fall tour, Phish has just announced their plans for New Year’s. The band will play two shows at the DCU Center (formerly The Centrum) in Worcester on December 27 and 28 followed by three shows at Madison Square Garden on December 30, 31 and January 1. This marks the first time the band will perform on January 1, which falls on a Saturday this year.

    August 25, 2010

    New Year’s: Phish New Year’s at MSG? [Brooklyn Vegan]

    May 20, 2010

    Phish: 12/31/2009 Party Time > Auld Lang Syne [VQ: B+, AQ: B+]

    YouTube Preview Image