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

    Halloween RSS

    July 18, 2012

    Side Shows: Page McConnell to Team With George Porter Jr., Zigaboo Modeliste and Leo Nocentelli as The Metermen – Two Shows at B.B. King’s Blues Club in NYC

    March 25, 2012

    Phish: 10/31/1989 Wilson [VQ: A-, AQ: A, Pro-Shot]

    YouTube Preview Image

    December 23, 2011

    Video: Footage of the Seventh Reba Phish Ever Played Surfaces [Hidden Track]

    Phish: 10/31/1989 Oh Kee Pa > Suzy Greenberg [VQ: A-, AQ: A-, Pro-Shot]

    YouTube Preview Image

    December 5, 2011

    Phish: 10/31/1996 All of MTV’s Pro-Shot Footage of Remain In Light [VQ: A+, AQ: A+]

    YouTube Preview Image

    November 2, 2011

    Podcasts: Phish Are Molesting Laura – Halloween Special [Paris DJs]

    October 30, 2011

    Phish: 10/31/2010 Feats Don’t Fail Me Now [VQ: A, AQ: A+]

    YouTube Preview Image

    October 25, 2011

    Halloween: Under The Covers – The Musical Costume [Online Phish Tour]

    While some would argue that the musical costume isn’t really a stage antic, I would point to the band’s freedom to change the way people think about live shows and clever ways of toasting their influences as their own “antics”. Halloween proves that stage antics don’t have to be ridiculous or over the top, they just have to be uniquely Phish.

    September 29, 2011

    Influences: Phish Approached Peter Gabriel About Lamb Lies Down [RS]

    And then Phish – they do these projects where they take an old record and do it. I had a conversation about The Lamb Lies Down On Broadway with them at one point.

    Wow. They wanted you to sing it with them?
    Yeah. They were thinking about it. That didn’t go anywhere, but those were the only times I sort of thought about it.

    March 4, 2011

    Interviews: Beyondo – Phish and a Side Dish or Two [Dog Gone Blog]

    When did Phish first approach you about playing with them on Halloween? How early did you know which album you’d be covering?

    They approached us for the gig about a month and a half before the actual concert. They approached Antibalas management about getting us on there. We didn’t know what the record was going to be until maybe about a month before. We were kind of curious what we were going to play, because we knew there was a record [being covered]. So I got an e-mail from the management that they would be getting us the tracks soon and then we would go from there. So, yeah, it was kind of a surprise for us—to be waiting for this information in suspense.

    December 16, 2010

    Phish: 10/31/2010 Mercenary Territory [VQ: A, AQ: A+]

    YouTube Preview Image

    November 17, 2010

    Halloween: ZZYZX – Inverting Loaded [Jambands]

    November 16, 2010

    Halloween: Phish’s Musical Halloween Costume [4GBs]

    Even so, few classic albums – Exile, Blonde on Blonde, Pet Sounds, any Beatles album – that don’t have at least one song to skip over. Stylistically, Phish’s musical costume was a perfect fit, and maybe that’s the only thing that matters after all. But it wasn’t scary, funny, exotic, esoteric, playful or even popular enough, and unlike Remain in Light, it’s hard to imagine how Waiting For Columbus will push the band’s music forward. It was a rich, maroon-colored crayon of a costume, like dressing up as a Turnbull AC, the much feared, no-frills gang from the movie The Warriors, instead of as a flashier Baseball Fury.

    Halloween: Phish Photos 10/31/2010 [Glide Magazine]

    November 12, 2010

    Phish: 10/31/2010 Suzy Greenberg [VQ: B+, AQ: A+]

    YouTube Preview Image

    November 8, 2010

    Phish: 10/31/2010 Roses Are Free [VQ: A, AQ: A-]

    YouTube Preview Image

    November 5, 2010

    Phish: 10/31/2010 All That You Dream [VQ: A-, AQ: B+]

    YouTube Preview Image

    November 3, 2010

    Hey everyone, YEMblog editor/curator ScottyB here, and I want to tell you about the latest project I’m involved with – Type II Cast. Each week a rotating cast of “Phish Experts” dissect the band’s music with a fine tooth comb over the course of a 45-minute podcast. This week, we discussed the last week of Fall Tour 2010 including Halloween, Guyutica, Manchester and what the future holds. Check it out…

    Podcasts: Episode 4 – A New Hope [Type II Cast]

    Halloween: Examining The Little Feat Choice [Hidden Track]

    Most importantly however, was not the days and months that led up to the AC shows, but rather the previous 30-plus years of Phish listening, learning, ripping off ideas and overall living Little Feat. You see, what many of the younger fans might not realize is that while the name Little Feat might not steal as much thunder or light up as brightly as The Rolling Stones, The Who or The Beatles, they were every bit as important to American music – and Phish – as all of the others.

    Phish: 10/31/2010 HarpuaFSB Playlist [VQ: A, AQ: A+]

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

    Frankenstein, BBFCFM, Ghost -> Spooky,  Roses Are Free, Funky Bitch, Boogie On, Stash, Character Zero, Join The Band, Fatman In The Bathtub, All That You Dream, Oh Atlanta!, Old Folks Boogie, Time Loves A Hero -> Day or Night, Mercenary Territory, Spanish Moon, Dixie Chicken, Tripe Face Boogie, Rocket In My Pocket, Willin’, Don’t Bogart That Joint, Apolitical Blues, Sailin’ Shoes, Feats Don’t Fail Me Now

    Atlantic City: Review – The Rest of Halloween [Phish Thoughts]

    Atlantic City: Halloween Party Crashing [Word Sound & Power]

    November 2, 2010

    Atlantic City: Phish in AC 10/29 – 10/31 – Review [Intelligent Rectum]

    Halloween: PH-I-S-H Little Feat! Waiting For Columbus [OPT]

    Halloween: Review – Little Phish [Phish Thoughts]

    Phish: 10/31/2010 Dixie Chicken [VQ: B-, AQ: B+]

    YouTube Preview Image

    Halloween: Phish Trick or Treat w/ Little Feat & Led Zeppelin [Spin]

    November 1, 2010

    Phish: 10/31/2010 …Ghost > Spooky [VQ: B-, AQ: C+, Angle: CK5]

    YouTube Preview Image

    Halloween: Phish Covers Waiting For Columbus – Recap [Jambands]

    Halloween: Phish Covers Little Feat [Jambands]

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

    Halloween: Phish Celebrates Halloween by Covering Little Feat [Press of AC]

    Halloween: A History of Phish Halloween [Jambands]

    Phish: 10/31/2010 Intro > Fat Man In The Bathtub [VQ: A-, AQ: A-]

    YouTube Preview Image

    Recaps: Phish Covers Little Feat For Halloween [BeatCrave]

    Phish: 10/31/2010 Don’t Bogart That Joint [VQ: A, AQ: A-]

    YouTube Preview Image

    Halloween: Phish’s Halloween 2010 Mask? Little Feat [LA Times]

    October 28, 2010

    Halloween: Pinky Kravitz Sez Led Zep For Halloween [Press of AC]

    This time it was a magic mockingbird and it tells me Phish will cover an album of Led Zeppelin’s Sunday evening. It’ll be interesting to see if my bird is right or if I need a new bird. Personally, that’s what I’m pulling for … a little Zeppelin in Boardwalk Hall. They’ve flown helicopters in Boardwalk Hall, but never had Zeppelin in there.

    Interviews: Mike Gordon Thinks Halloween Will Be Best One Yet [Spinner]

    The characteristically tight-lipped band is keeping mum about their final selection for this year’s big event, but bassist Mike Gordon (pictured) does have some words to say about it. “This has the potential to be the best one yet,” Gordon tells Spinner. “I’m really excited about it, to the point where I’m calling some of my friends and I’m saying, ‘Well, I don’t even have any more room on my guest list, but you’ve got to come somehow, because this is going to be the one.’ It just really feels right to me.”

    October 25, 2010

    Halloween: Countdown to AC [Countdown to AC]

    October 21, 2010

    Atlantic City: Four Albums Phish May Play on 10/31 [Rolling Stone]

    October 15, 2010

    Halloween: Musical Costume Speculation [Dog Gone Blog]

    1. Genesis – The Lamb Lies Down on Broadway

    Many consider The Lamb to be the pinnacle of Genesis’ studio albums, and also one of the cornerstones of progressive rock. It’s a concept album, with lyrics mostly written by Peter Gabriel, telling the story of Rael – a Puerto Rican man living in New York – who is trying to rescue his brother from some from very bizarre circumstances. Phish has never covered their music in one of their own performances, but they did perform two of their songs at the Rock Hall of Fame induction ceremony earlier this year.

    October 13, 2010

    Interviews: Which Classic Album Will Phish Perform? [LA Times]

    Although Anastasio held fast against revealing which album gets the nod for Halloween 2010, he did offer a clue that might get fans chattering.

    “This year,” he said, “this one’s for me. The one we picked, I’m going to get more out of this as a musician than I ever have before. Three songs into it, I called everybody and told them, ‘None of the other ones — I wouldn’t think, hopefully — will have nearly the effect on my playing this one’s going to.’ ”

    September 29, 2010

    Atlantic City: What’s Up With Halloween? [Phish Thoughts]

    Atlantic City: A Different Halloween [Online Phish Tour]

    September 27, 2010

    Phish: Nearly all of 10/31/1994 – Best Copy Yet [VQ: A, AQ: B+]

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

    September 23, 2010

    Atlantic City: What Will The Halloween Album Be? [OPT]

    August 23, 2010

    Venues: Phish Halloween in AC Survival Guide [OPT]

    August 3, 2010

    Rumors: Halloween NOT at AC’s Boardwalk Hall [Online Phish Tour]

    Rumors: Halloween is NOT in Albany [Online Phish Tour]

    August 2, 2010

    Rumors: Trick or Treat or Double Down [Phish Thoughts]

    With the fan community sitting on the precipice of Summer Tour – Part Deux, the rumor mill exploded over the weekend with multiple sources all but confirming Phish in Atlantic City, New Jersey for Halloween 2010.

    May 6, 2010

    Phish: 10/31/1996 Seen and Not Seen [VQ: B+, AQ: B]

    YouTube Preview Image

    March 8, 2010

    Phish: 10/31/2009 Complete Exile On Main Street Set Playlist [VQ: A-, AQ: A-]

    http://www.youtube.com/view_play_list?p=69FB8F9757E87CEC

    February 8, 2010

    Phish: Halloween Phish in The Desert [Festival 8 Montage]

    December 20, 2009

    Phish: 10/31/2009 Ventilator Blues [VQ: A+, AQ: A, 4-cam]

    YouTube Preview Image

    Phish: 10/31/2009 I Just Want to See His Face [VQ: A+, AQ: A, 4-cam]

    YouTube Preview Image

    December 17, 2009

    Phish: 10/31/2009 Torn and Frayed [VQ: A, AQ: A, 4-cam]

    YouTube Preview Image

    November 30, 2009

    Phish: 10/31/2009 Stop Breaking Down [VQ: B-, AQ: A]

    YouTube Preview Image

    November 10, 2009

    Phish: 10/31/2009 YEM Spook [VQ: B+, AQ: B+]

    YouTube Preview Image

    November 9, 2009

    Phish: 10/31/1998 Who Loves The Sun? [VQ: B+, AQ: C]