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

    Chicago RSS

    June 21, 2012

    New Archival Release: Phish Officially Announces Chicago ’94 Box Set [Hidden Track]

    March 1, 2012

    Phish: 11/09/1998 I Get A Kick Out of You [VQ: B+, AQ: A-]

    YouTube Preview Image

    February 26, 2012

    Phish: 11/09/1998 Freebird [VQ: A, AQ: A-]

    YouTube Preview Image

    “What Song Is It You Want To Hear?”

    February 24, 2012

    Phish: 11/09/1998 Bathtub Gin [VQ: B, AQ: A-]

    YouTube Preview Image

    February 1, 2012

    Trey Anastasio: 70 Volt Parade 08/10/2005 New Source Chicago, IL

    January 29, 2012

    Phish: 08/17/2011 No Quarter [VQ: A-, AQ: A+, Black & White]

    YouTube Preview Image

    December 8, 2011

    Phish: Entire UIC Pavilion Run [VQ: B+, AQ: A+]

    8/15/2011 Set 1

    YouTube Preview Image

    8/15/2011 Set 2

    YouTube Preview Image

    8/16/2011 Set 1

    YouTube Preview Image

    8/16/2011 Set 2

    YouTube Preview Image

    8/17/2011 Set 1

    YouTube Preview Image

    8/17/2011 Set 2

    YouTube Preview Image

    November 30, 2011

    Phish: 08/15/2011 Dirt [VQ: A, AQ: A+]

    YouTube Preview Image

    November 7, 2011

    Phish: 08/16/2011 Foam [VQ: A, AQ: A+, 6-cam]

    YouTube Preview Image

    October 25, 2011

    Phish: 08/15/2011 Guelah Papyrus [VQ: A, AQ: A+]

    YouTube Preview Image

    September 30, 2011

    Phish: 08/15/2011 Trey Talks Curfew / Camel Walk [VQ: A, AQ: A+]

    YouTube Preview Image

    September 19, 2011

    Phish: 08/15/2011 Steam [VQ: A, AQ: A+]

    YouTube Preview Image

    September 8, 2011

    Podcasts: Episode 32 – UIC [Type II Cast]

    This episode finds [host Steve Olker] joined by type II cast regular, Eric Wyman, and guest host, Adam Brotherhood from Online Phish Tour. Both were in attendance and assert that a good time was had by all at the last 3 shows of Leg 2. With plenty of clips to choose from this week, a few were left on the studio floor. It should be no surprise to anyone listening that this run is a contender for one of the best in 2011, and perhaps 3.0. As usual, we are here to give our analysis and insight,  wrapped in colorful commentary, baked in a pastry. Grab a glass Merlot, block off the next hour, and enjoy.

    September 3, 2011

    Phish: 08/17/2011 Makisupa > Sleep > Buffalo Bill [VQ: A+, AQ: A+, Pro-Shot]

    Phish: 08/16/2011 You Enjoy Myself [VQ: A+, AQ: A+, Pro-Shot]

    September 2, 2011

    Phish: 08/16/2011 Twist [VQ: A, AQ: A+]

    YouTube Preview Image

    August 30, 2011

    Phish: 08/17/2011 Buffalo Bill [VQ: A, AQ: A+]

    YouTube Preview Image

    August 26, 2011

    Phish: 08/17/2011 Colonel Forbin’s > Fly Famous Mockingbird [VQ: A, AQ: A+]

    YouTube Preview Image

    Phish: 08/15/2011 Babylon Baby [VQ: A, AQ: A+]

    YouTube Preview Image

    Phish: 08/15/2011 Jesus Just Left Chicago [VQ: A, AQ: A+]

    YouTube Preview Image

    August 24, 2011

    UIC Recap: UIC Run Was The Best Phish We’ve Seen This Era [OPT]

    UIC Recap: A Triumphant Trifecta [Phish Thoughts]

    August 22, 2011

    Phish: 08/15-17/2011 The Quinnski UIC Playlist [VQ: A, AQ: B]

    Light, Dirt, Steam, Alumni Blues, Let It Loose, I Didn’t Know, You Enjoy Myself, Chalk Dust Torture, Ha Ha Ha, Walls of the Cave, Runaway Jim, Dinner and a Movie

    Phish: 08/15-17/2011 LazyLightning55’s UIC Playlist [VQ: A, AQ: A+]

    Rift, Alumni Blues, Waves, Dinner and a Movie, The Wedge, Slave To The Traffic Light, Maze

    Chicago: Jason K’s Photos of Phish at UIC Pavilion [Jason Kaczorowski Photography]

    August 18, 2011

    Chicago: TaoPauly’s UIC Recaps – Night One, Night Two, Night Three [Coventry]

    Phish: 08/15/2011 DAUD Chicago, IL

    Phish: 08/17/2011 Makisupa Policeman [VQ: C, AQ: B-]

    YouTube Preview Image

    Phish: 08/17/2011 Crosseyed and Painless [VQ: B, AQ: B]

    YouTube Preview Image

    Chicago: Phish Dominates Three Nights at UIC [SNS Post]

    Phish: 08/17/2011 DAUD Chicago, IL

    Chicago: Short on Improvisation, Long on Fun [OPT]

    Chicago: Phish UIC3 Recap [Phish.net]

    Phish: 08/17/2011 LivePhish SBD Chicago, IL

    Chicago: UIC3 Review – A Sudden Shift To Songs [Phish Thoughts]

    Following two shows that showcased jams of all shapes and sizes, Phish played an odd tour finale in which they rarely let an improvisational root take hold. Still crafting an engaging opening half of the second set the band carried legitimate momentum, albeit with short jam segments, as they segued smoothly from the show’s improvisational high point—“Piper”— into “Ghost.” But Trey decided to supplant any semblance of a “Ghost” jam with “Makisupa,” a move which wound up diffusing the entire set and sparking an innocuous run of made-far-radio Phish, leaving their leg two finale as the weakest of the Chicago’s three nights—by far.

    Phish: UIC3 Playlist by TheQuinnski [VQ: A, AQ: B]

    Colonel Forbin’s Ascent > Fly Famous Mockingbird, Weigh, Divided Sky

    Chicago: Phish UIC Pavilion Setlist & Skinny – Night Three [Hidden Track]

    August 17, 2011

    Chicago: Phish UIC Pavilion Night Two – Recap, Setlist and Skinny [Hidden Track]

    Phish: 08/16/2011 Let It Loose [VQ: A, AQ: B-]

    YouTube Preview Image

    Chicago: UIC2 Recap by Eric Wyman [Phish.net]

    Chicago: Review – Extra Mustard – UIC Night Two [Online Phish Tour]

    Phish: Two Quickies From UIC2

    Trey & Mike Show off Otis Redding Shirts

    YouTube Preview Image

    Trey Gets Loose During YEM Bass & Drum

    YouTube Preview Image

    Chicago: Review – Riding Out The Ripples [Phish Thoughts]

    August 16, 2011

    Chicago: Phish Blows Fire On The Windy City [Online Phish Tour]

    Chicago: Photos of Phish at UIC by Justin Ward [Live Music Blog]

    Chicago: Review – The Elements of Phish [Phish Thoughts]

    Starting with the sinister swank of “Sand” the band showcased their one-minded playing with a heroic dose of Phish groove. The band took the song far beyond rhythmic gymnastics however, as they moved right past the song’s conclusion into a hard-edged ambiance. Amidst this context Mike and Trey had an eerie, one-on-one conversation that gradually brought the band towards “Light.” And after a small time off from being the band’s central portal into the center of the cosmos, “Light’s” two versions of tour have been exactly that. Taking last night’s piece into the heart of modern Phish experimentation, Mike stood at the center of an intergalactic jam. As the band pushed eclectic and alien boundaries, the wide-open style of play that defined the jam would soon come to define the entire set.

    Chicago: Review – Opening Night Done Right [Unplugged Musings]

    Phish: 08/15/2011 LivePhish SBD Chicago, IL

    Phish: 08/15/2011 Light > Dirt [VQ: A, AQ: A]

    YouTube Preview Image

    Chicago: UIC1 Recap [Phish.net]

    Phish: 08/15/2011 Back On The Train [VQ: B-, AQ: B]

    YouTube Preview Image

    August 15, 2011

    Chicago: Phish UIC Pavilion Recap, Setlist and The Skinny [Hidden Track]

    Local Guide: Phish @ UIC Pavilion – A Chicago’s Visitor Guide [The Barn Presents]

    Previews: Phish at UIC Pavilion [Chicago Tribune]

    Phish: The quartet, decade-long rulers of the jam-band universe created by the Grateful Dead, tour relentlessly, but they always seem to be at their best whenever they play the UIC Pavilion, their multi-night stands inevitably inspiring a level of revelation that they don’t routinely achieve elsewhere, 7:30 p.m. Monday-Wednesday at UIC Pavilion, 525 S. Racine, $58; ticketmaster.com.

    March 12, 2011

    Phish: 06/18/1994 DAUD New Source Chicago, IL

    March 10, 2011

    Photos: Trey Anastasio – Chicago – 02/27 [JamBase]

    March 9, 2011

    Trey Anastasio: TAB 02/27/2011 LivePhish SBD Chicago, IL

    March 6, 2011

    Trey Anastasio: Review – Uncle Trey’s Singalong [Kaufmak’s Lazy Blog]

    March 3, 2011

    Trey Anastasio: Review – TAB- 02/27/2011 [Jambands.com]

    March 2, 2011

    Trey Anastasio: 02/27/2011 Gumbo [VQ: B, AQ: B]

    YouTube Preview Image