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 September 05 | YEMblog

    Daily Archive

    September 5, 2011

    Phish: 09/04/2011 Come Together [VQ: B, AQ: B+, Angle: CK5]

    YouTube Preview Image

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

    Denver: Phish Dick’s Sporting Goods Park Night Three – Setlist, Recap and Skinny [Hidden Track]

    While we usually point you in the direction of certain songs/jams to hear in this recap, just listen to it all – especially the second set – as Phish put one hell of an exclamation point on this tour. Let’s hope a New Year’s run is in the works before the quartet embarks on a less active year in 2012.

    Denver: Say It Loud, Say It Proud – Phish Likes Dicks [Phish.net]

    Phish: 09/04/2011 FOB Denver, CO

    • End set #phish #
    • Giant beach ball up front #
    • Best webcasted show in a landslide btw. #phish #obviousIMO #
    • Upon return to ghost, trey sung "and if you ever want know who the ghost is… guy forget" #phish #awestruck #
    • Walls of the cave #phish #
    • -> ghost #phish #
    • Def not a tease or quote here! #phish #
    • #phish #dicks S2: Rock and Roll -> Come Together -> Twist -> Piper > Harry Hood > Roggae > Ghost -> Guy Forget bit.ly/oxscXn #
    • -> Guy forget! #phish #
    • Almost Mantecaesque for a moment there. I think we've moved past the 3:48 mark #phish #sighofrelief #
    • I hope this doesn't get UICed. #fingerscrossed #
    • > ghost #phish #
    • #phish #dicks S2: Rock and Roll -> Come Together -> Twist -> Piper > Harry Hood > Roggae bit.ly/oxscXn #
    • > roggae #phish #
    • There's a lot of stuff to go back and listen to this show for. #phish #
    • > hood #phish #
    • Page on theremin #phish #
    • Wow #
    • Couldn't make out what trey was saying/singing midjam. #phish #
    • Great segue into piper btw #phish #
    • Need to go back and listen, but i'd prob label that come together -> twist -> piper w/ song/show note re low rider #phish #
    • ->piper #phish #
    • #phish #dicks S2: Rock and Roll -> Come Together -> Twist -> Low Rider bit.ly/oxscXn #
    • -> low rider! #phish #
    • A few rough spots in Come Together but great to hear this, esp coming out of a jam like that. Never thought #phish would play that again #
    • -> twist #phish #
    • Hasn't been played since 1995 on john lennon's death #phish #
    • #phish #dicks S2: Rock and Roll -> Come Together (LTP – 12/08/1995) http://t.co/X3q46G0 #
    • -> Come together! #phish #
    • Broken down and funky #
    • Awesome groove repeated for a bit, then off in a new direction. high energy set opener and a great one at that #phish #
    • Maybe not… But I heard something (5 notes worth)… #
    • Chalk dust tease from trey #phish #
    • Have listened to the gorge rock and roll frequently in the past few wks, hoping this comes close to it. #phish #
    • Rock and roll #phish #
    • Lights #
    • "S" emphasis pre end of cdt #phish #
    • One Set Left For Summer '11. Here's a recap, the setlist and The Skinny for tonight's first set http://t.co/X3q46G0 #phish #
    • 87 min set, a lot of songs not in heavy rotation with gin and cdt being highlights. #phish #
    • End set. Weird end to cdt, thought there was a chance for one more song. #phish #
    • This cdt's packing more of a punch than your usual one. not type II, but great type I jamming. #
    • Nice jam in cdt #phish #
    • #phish #dicks I: Maze, BOTT > Rift > Gin, Way It Goes, HalfwayMoon, Gumbo, Halley's > Tube > Timber > Roses > CDT bit.ly/oxscXn #tourcloser #
    • > chalk dust #phish #
    • First charlie chan riff tease since japan 2000 #phish cc @phishnet #
    • #phish #dicks Set One: Maze, BOTT > Rift > Gin, Way It Goes, HalfwayMoon, Gumbo, Halley's > Tube > Timber bit.ly/oxscXn #tourcloser #
    • > timber #phish #
    • Charlie Chan tease from trey??? #phish #
    • Amusing to have halleys > tube as both are not even close to what they used to be jamwise as of late. #
    • > tube #phish #
    • Not getting my hopes up here… Wait for it… #
    • Excellent set so far, gin clear highlight. #phish #
    • #phish #dicks Set One: Maze, Back On The Train > Rift > Bathtub Gin, Way It Goes, HalfwayMoon, Gumbo, Halley's bit.ly/oxscXn #tourcloser #
    • Halleys #phish #
    • Saw gumbo and fee signs preshow #
    • Gumbo #phish #
    • The way it goes was also apparently sndchked preshow. thanks Scotty for the assist. #
    • #phish #dicks Set One: Maze, Back On The Train > Rift > Bathtub Gin, The Way It Goes, Halfway to the Moon bit.ly/oxscXn #tourcloser #
    • Halfway to the moon #phish #
    • Reception shot to hell as everyone's trying to ID this. Sigh #
    • "that's the way it goes" repeated. cover debut. #
    • #phish #dicks Set One: Maze, Back On The Train > Rift > Bathtub Gin, The Way It Goes (Gillian Welch) bit.ly/oxscXn #tourcloser #
    • New song… #phish #
    • This gin's a keeper. #phish #
    • Build = crowd cheers. #
    • Think we just entered type II. Funky #
    • Nice type I jam built off of riffs trey's been repeating. #
    • #phish #dicks Set One: Maze, Back On The Train > Rift > Bathtub Gin, bit.ly/oxscXn #tourcloser #
    • > bathtub gin #phish #
    • Possible > pre Rift, couldn't tell for sure #
    • Rift #phish #
    • Maze ending was super sloppy, but energy high from the opener #phish #
    • #phish #dicks Set One: Maze, Back On The Train http://t.co/X3q46G0 #tourcloser #
    • Back on the train #phish #
    • Last maze opener 12/9/95 i'm being told #phish #
    • GREAT opener choice btw #
    • Maze #phish #
    • Bowie's Man Who Sold The World on for preshow music right now. #nicechoice #
    • In the lots. weather has been perfect this weekend save for some pre fri raindrops. #
    • Dave Herrera of @westword_denver briefy addresses plagiarism in Fishman interview http://t.co/70pI7zt #phish #
    • Tonight's setlist possibilities. i love seeing the band reach back into their song list on 3 night runs #
    • I feel like a lot of commonly played songs came out last night. Can think of a bunch (cdt,#line,bag,gin to name a few), but excited for CONT #
    • A+ Feedback, Would Buy Again RT @nugsnet: watch a free stream of the Seven Below>Suzy>Scents from Friday night http://t.co/Q0z3VDw #
    • This is Scott Marks from @bizarchive. looking fwd to tweeting tonight's denver run #phish #
    • Yeah, thinking it's the part where Fish talks about Mimi (RIP) "My mother, she's out of control. We kept her locked at home with chains. " #
    • Found a cache'd version of the Fishman interview http://t.co/6VDsZ2M #phish If anyone knows why it was pulled, let us know #
    • Knew huge Tweezer fan @mrminer would be thrilled by last night's version and his write-up doesn't disappoint http://t.co/FzxJmi5 #phish #
    • Maybe Fish doesn't want to play more gigs after all #weird #
    • Remember that Jon Fishman interview @hidden_track mentioned? It's been pulled. Read editor's note here: http://t.co/70pI7zt Plot thickens! #
    • Thx @heyscottyb for having me & to y'all for putting up w my rants. Last thx to @apple this iPhone 4 battery is great. @jraras out #
    • Post show music was September (earth wind fire) #weddingsongs #
    • As suggested by many followers my friends went veggie for the lot grub – thx for the input #
    • Why are there no burritos on lot anymore? There is a discussion going on as to the safer lot meat: pork or chicken? Thoughts? #
    • Thanks so much to @jraras for tweeting tonight! Great work and always a pleasure to have him aboard. @bizarchive finishes us up tomorrow #
    • Night Two of #phish #dicks is in the books. Here's a complete recap as well as the setlist and The Skinny http://t.co/WKpnTob #
    • Tweeprise #
    • "we'd like to play a song that begins w the letter S" – sleeping monkey #
    • In jam segment not intro – less common place for the teasefest #expecttheunexpected #
    • Disease teases #
    • #phish #dicks N2 S2: DWD -> Tweezer > Golden Age > Limb By Limb, Kill Devil Falls > 2001 > Light > Julius > Cavern > Antelope bit.ly/pz66dU #
    • >'lope #
    • Cavern #