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"; } } ?> 2011 December 31 | YEMblog

    Daily Archive

    December 31, 2011

    Reviews: 12/30 Recap [Phish.net]

    Reviews: Phish 12/30 – The Red Red Worm [Smooth Atonal Sound]

    Phish: 12/30/2011 Entire Show Playlist by HarpuaFSB [VQ: A, AQ: A+]

    Set 1: Punch You In the EyePrince Caspian[1]Backwards Down the Number LineNellie KaneDivided SkySandVulturesRiftJoyQuinn the Eskimo

    Set 2: WilsonAxillaPiperTwistJuliusGolgi ApparatusAlso Sprach Zarathustra,The HorseSilent in the MorningDavid Bowie[2]The Squirming Coil

    Encore: Boogie On Reggae WomanGood Times Bad Times

    [1] Unfinished.
    [2] Silent In the Morning teases.

    [Setlist via Phish.net]

    MSG3: Phish MSG Night Three – Setlist, The Skinny & Live Blog [Hidden Track]

    Reviews: Night 3 – If You Can Heal The Symptoms [OPT]

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

    Reviews: 12/30 – Not Much To Offer [Phish Thoughts]

    Phish: MKDevo’s 12/30/2011 Playlist [VQ: A, AQ: A+]

    Set 1: Punch You In the EyePrince Caspian[1]Backwards Down the Number LineNellie KaneDivided SkySandVulturesRiftJoyQuinn the Eskimo

    Set 2: WilsonAxillaPiperTwistJuliusGolgi ApparatusAlso Sprach Zarathustra,The HorseSilent in the MorningDavid Bowie[2]The Squirming Coil

    Encore: Boogie On Reggae WomanGood Times Bad Times

    [1] Unfinished.
    [2] Silent In the Morning teases.

    [via Phish.net]

    (Whole show uploading throughout the day, check back later if the track you want to see hasn’t been added)

    Phish: 12/30/2011 DAUD New York, NY

    Reviews: MSG3 Good Times, Bad Times [Coventry]

    Reviews: A Band Tradition, Both Carried On and Changed [NY Times]

    Reviews: 12/29 Madison Square Garden [Jambands.com]

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

    Tweezer McGrupp And The Watchful Hosemasters by HTBloggin

    • It was fun hanging out w/ you guise tonight. Thanks to @heyscottyb for letting me guest tweet #
    • Thanks to @alliedise for tweeting! Setlist and Live Blog http://t.co/BuvpkdPL #Phish #
    • Game over #end show #
    • Definitely not Trey's finest GTBT moment, but the Garden is going nuts over Page singing #
    • Good Times Bad Times! #
    • The crowd was clapping to Cactus! #
    • CACTUS!!!!! #
    • Gordo's bass is making my hair stand on end #
    • Boogie On!!! YEAH MIKE GORDON #
    • Encore will be… #
    • End set #
    • Insane energy in the Garden right now #
    • Page doing his thing #
    • Squirming Coil #
    • They're not done yet #
    • Kuroda is the real hero of this Bowie, but he's moving so fast I can't get a good shot off #
    • Gordo taking the lead in the jam #
    • Silent teases in Bowie #
    • Bowie #
    • The Garden goes nutty over Silent in the Morning #
    • Going for the "this exact thing happened to me just last year" effect. Can't say I blame them :-) #
    • Horse #
    • Holy 2001 #
    • I heard a teenie Drowned tease there #
    • There it is! #the $$shot http://t.co/P1BuqWFB #
    • Stop/start action in 2001 right now #
    • *from dancing & Gordo's bass #
    • Trying so hard to take a pic for you guise, but the floor is vibing too hard #
    • There is that 2001 I called a few minutes ago #
    • CK5 seems to love this new design http://t.co/PuN4WE1H #
    • Crowd is going nuts, but it's a little scrappy sounding #
    • A pic from Julius will be coming in during Golgi btw #slow #
    • Definitely #extramustard on this Julius http://t.co/Wm15kGkt #
    • Golgi Apparatus #
    • Crazy floor vibrations now. People LOVE Julius. The first song I ever air bassed to! #
    • Julius #
    • But watching Trey have so much fun makes it all worth it #
    • *wah #
    • ..back into the vocals #
    • Now Trey makes his move #
    • **and Page too #
    • I am very impressed w/ Trey's patience right now. He is letting Mike go to town #
    • Trey is eyeing the crowd. I want to see he & Gordo tee off #
    • TWIST!! Let's get down #
    • Very 2001 esque lights going on here. I wonder if that's coming. #
    • Very psychedelic #
    • Gordo just laid a MONSTER bass bomb. We all screamed #
    • The Garden is engulfed w/ CK's lights going about 100mph #
    • Ahhhhh. Here we go. Mike is taking the lead and sounds amazing #
    • The PH from Vermont #phish http://t.co/05EQg9wi #
    • Page & Mike stepping up bigtime #
    • Still a bit rushed, but slowing down a bit. Let's do this #
    • Heaven, courtesy of #CK5 http://t.co/L4QlQf42 #
    • Please please jam this out. Be patient, Phishy-san #
    • Very fast paced #
    • Ouchie. Trey sang a little early, but forgivable #
    • Game on, 12.30.11 #
    • PIPER!!!! #
    • Creepy intro. This song always reminds me of Bam Bam from the Flintstones on drums #
    • Axilla #
    • Crazy energy now! What's next? #
    • We like to sing Willis, in honor of our dog #
    • Wilson #
    • The 2nd set needs to trump the 1st set by 100000x #
    • Lights again #
    • By far, the highest energy in the Garden now #
    • *shocker #
    • Trey wankfest to close #
    • It's like I'm back at Buckeye Lake '94 all over again :-) #
    • Page going to town!!! #
    • Being a Deadhead & all, this song always has so much meaning to me when #phish plays it #
    • First singalong of the night #chills #
    • Wooooohoooooo!!! #
    • Mighty Quinn!!!! #
    • At least it's not Let Me Lie. Then I would have to pick on my friend @ohkeepahblog #
    • This song has kind of grown on me #
    • 20,000 people heading to the bathroom #
    • Joy #
    • A few missed notes by Trey at the end of the song, but fun #
    • *Dead shows #
    • There is a giant ring of glow necklaces being passed around. Kind of reminds me of the good ole days of wishing for Unbroken Chain @ Dea … #
    • Rift #blastoff #
    • #sexytown http://t.co/9vDZ7zj5 #
    • Vultures! Sexy song #
    • The floor is vibrating so hard, I can't get a pic off to save my life. Good stuff #
    • Mike Gordon is going to town. As he should be #
    • Damn – last text too long #ohwells #
    • to get their priorities straight #
    • Interesting vibe in the Garden right now. Reminds me of when they started Kill Devil Falls the other night and everyone ran to the bathr … #
    • Thank the good lord they are playing something w/ meat #
    • Sand!! #
    • *which isn't a bad thing of course #
    • Trey is having a blast though. This show is going to be a wankfest #
    • The lights are absolutely gorgeous from where we are standing. If only the music would match… #
    • The obligatory Divided Sky pic. Enjoy http://t.co/Y3G2vHAL #
    • Divided Sky. You guys don't mind if I go to the ladies room do you? #
    • Mike slapping away on the bass. Love that guy #
    • All of the Mike bluegrass songs sound the same to me ;) #
    • Damnit – Nellie Cane – sorry! #
    • Ginseng Sullivan #
    • #ALLMYFRIENDS #
    • Floor is starting to vibrate again. People are loosening up #
    • Btw – I have the loudest, most obnoxious singer & clapper behind me. The things I deal with to tweet to you guise #
    • Backwards Down the Number Line #
    • Or perhaps a little jammy jam? #
    • Slowish ending into…… #
    • Trey is wanking away. I'm chuckling #
    • OMG – someone has a multi-section Friday sign behind the stage. Really? #
    • *that's Prince Caspian for the newbs #
    • Fuckerpants! LOL #
    • #HEY http://t.co/YpfSLjtG #
    • Punch You in the Eye opener! Crowd goes batshit #
    • Lights #
    • I promise to post a few lights shots this eve :-) #
    • Sitting right behind Kuroda tonight, which will make for great sound & lights. Are we there yet? Are we there yet? #
    • Walking in to MSG now. Energy is manic as ever. Hoping so much for an epic 12.30 show! #
    • Meeting all sorts of fun people at the @phishtwibe gathering. It's neat to meet people IRL that you chat w/ online #
    • @alliedise GO ALLIE!! in reply to alliedise #
    • Looking forward to the @phishtwibe tweetup this afternoon! I'll post some fun shots of the gang #
    • Happy 12.30 day! @alliedise at the wheel today. Looking forward to a great show this eve #
    • @BarefootBob2 Not today. Will return next Friday in reply to BarefootBob2 #
    • More 12/29 Reviews: @smoothatonalsndhttp://t.co/LzI9xVDF @subtle_soundshttp://t.co/R9omHTlO #phish #
    • Videos: HarpuaFSB Playlist Is Now Complete http://t.co/9TzvDOwS @mkdevo Getting There http://t.co/oav5mKAF #
    • TONIGHT: @phish returns to @MSGnyc for their third of four NYE Run concerts. 12/30 should be a national holiday. @alliedise will guest tweet #
    • I always try to take a few minutes each 12/30 to think about the shows I've attended on this day. #wewillneverforget Happy 12/30!!! #
    • 12/29 Reviews: @mrminerhttp://t.co/Fd9IEDWL @taopauly for @CoventryMusichttp://t.co/8EvIbBl7 #phish #
    • YEMblog Facebook: Get Your Pick The Encore Entries in For Night Three http://t.co/xpOsuwoh #phish #
    • Another night of incredible videos currently on way to YouTube. @mkdevo http://t.co/qMjwnIb8 HarpuaFSB http://t.co/9qWk2HZD #phish #
    • #phish 12/29 Audio: @LivePhishhttp://t.co/Zf7eflmp Z-Man's DAUD – http://t.co/ORifxCd4 #phish #