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

    Colorado RSS

    September 1, 2012

    Summer Tour: Phish Dick’s Denver Recap, Setlist and The Skinny – Night Two

    August 22, 2012

    Charities: Phish Colorado Food Drive [Conscious Alliance]

    March 14, 2012

    Phish: 11/17/1997 DAUD New Source Denver, CO

    March 1, 2012

    Phish: 06/10/1995 DAUD New Source Morrison, CO

    Phish: 08/07/1996 DAUD New Source Morrison, CO

    December 11, 2011

    Phish: 08/01/2009 ENTIRE SHOW [VQ: A, AQ: A+, TH 2-CAM]
    Set 1: AC/DC Bag, The Curtain With, Mound, Gotta Jibboo, Guyute, Punch You In The Eye, Tube, Alaska, Run Like An Antelope
    YouTube Preview Image
    Set 2: Rock and Roll– Down With Disease– Free, Esther, Dirt, Harry Hood
    Encore: Sleeping Monkey, First Tube
    YouTube Preview Image

    December 9, 2011

    Phish: 07/31/2009 Entire Show [VQ: A, AQ: A+, 4-CAM]

    YouTube Preview Image YouTube Preview Image

    Set 1:  Runaway Jim, Chalk Dust, Bathtub, Time Turns Elastic, Lawn Boy, Water In The Sky, Stealing Time, Split

    Set 2: Drowned > Crosseyed > Joy, Tweezer > BDTNL, Fluffhead > Piper > ADITL

    Encore: Suzy > Reprise

    October 27, 2011

    Trey Anastasio: 03/02/2011 Acoustic Set [VQ: B-, AQ: B]

    YouTube Preview Image

    October 6, 2011

    Phish: 09/02/2011 Soul Shakedown Party [VQ: A-, AQ: A-]

    YouTube Preview Image

    October 5, 2011

    Phish: 09/02/2011 Suzy Greenberg | Scents and Subtle Sounds [VQ: A-, AQ: A-]

    YouTube Preview Image

    September 14, 2011

    Phish: 09/04/2011 Halfway To The Moon [VQ: B, AQ: B]

    YouTube Preview Image

    September 13, 2011

    Phish: 09/03/2011 Golden Age [VQ: B-, AQ: B]

    YouTube Preview Image

    September 9, 2011

    Phish: 09/04/2011 Bathtub Gin [VQ: A+, AQ: A+, Pro-Shot]

    Denver: On Cloud 9 in Colorado [Phish Thoughts]

    September 7, 2011

    Phish: Dick’s Denver Playlist by McNasty Shasta [VQ: Varies (Mostly B), AQ: B]

    Sand > Simple, Steam > Soul Shakedown Party, Seven Below, Scents and Subtle Sounds > Slave to the Traffic Light, Silent In The Morning > Sanity, Sweet Adeline, Sabotage, Possum, Moma Dance > Wedge, Ocelot > Divided Sky…, …Divided Sky, Funky Bitch, Axilla > Llama > Fast Enough For You, Wolfman’s Brother, Down With Disease > Tweezer, Golden Age > Limb By Limb, Kill Devil Falls > 2001 > Light, Julius > Cavern, Run Like An Antelope, Sleeping Monkey > Tweezer Reprise, Maze, Harry Hood, Twist > Piper, Rock and Roll > Come Together, Timber (Jerry) > Roses Are Free > Chalk Dust Torture, Gumbo > Halley’s Comet > Tube, Halfway To The Moon, The Way It Goes, Back On The Train > Rift > Bathtub Gin, Roggae > Ghost > Guy Forget > Ghost,

    September 6, 2011

    Phish: 09/04/2011 Twist, Piper [VQ: B-, AQ: B]

    YouTube Preview Image

    Phish: 09/04/2011 Maze [VQ: B+, AQ: B]

    YouTube Preview Image

    Phish: 09/02/2011 Sweet Virginia [VQ: B, AQ: B]

    YouTube Preview Image

    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

    Phish: 09/04/2011 FOB Denver, CO

    September 4, 2011

    Phish: 09/02/2011 Seven Below > Suzy > Scents [VQ: A+, AQ: A+, Pro-Shot]

    September 3, 2011

    Denver: Phish Denver Dick’s Sporting Goods Park Night Two – Setlist, Recap and The Skinny [HT]

    Phish: 09/02/2011 Sabotage [VQ: B, AQ: B]

    YouTube Preview Image

    Phish: 09/02/2011 Grateful Web’s Denver Night One Playlist [VQ: B+, AQ: B+]

    Sample, Sparkle, Sloth, Sneakin’ Sally, Sparks, Scent of a Mule, Split Open and Melt, Squirming Coil, Setbreak

    Phish: 09/02/2011 LivePhish SBD Denver, CO

    Phish: 09/02/2011 FOB Denver, CO

    August 26, 2011

    Free Downloads: Phish Live Bait Vol. 6 – Past Colorado Shows [LivePhish]

  • The Curtain > (1996-08-06 Red Rocks Amphitheatre – Morrison, CO)
  • Tweezer (1996-08-06 Red Rocks Amphitheatre – Morrison, CO)
  • Split Open And Melt (1994-06-11 Red Rocks Amphitheatre – Morrison, CO)
  • It’s Ice > (1993-08-20 Red Rocks Amphitheatre – Morrison, CO)
  • The Wedge (1993-08-20 Red Rocks Amphitheatre – Morrison, CO)
  • Mike’s Song > (1995-06-10 Red Rocks Amphitheatre – Morrison, CO)
  • I Am Hydrogen > (1995-06-10 Red Rocks Amphitheatre – Morrison, CO)
  • Weekapaug Groove (1995-06-10 Red Rocks Amphitheatre – Morrison, CO)
  • The Moma Dance > (2003-02-18 Pepsi Center – Denver, CO)
  • Limb By Limb (2003-02-18 Pepsi Center – Denver, CO)
  • McGrupp And The Watchful Hosemasters (Roma Bar – Telluride, CO – Colorado ’88)
  • Ghost (1997-11-17 McNichols Sports Arena – Denver, CO – LivePhish11)
  • David Bowie (1990-11-02 Glenn Miller Ballroom, University of Colorado – Boulder, CO)
  • Wilson > (1993-03-13 Balch Fieldhouse, University of Colorado – Boulder, CO)
  • Run Like An Antelope (1993-03-13 Balch Fieldhouse, University of Colorado – Boulder, CO)
  • May 11, 2011

    Dick’s Sporting Goods Park: Phish to Close Tour Near Denver [Hidden Track]

    Phish has just announced a three-night run at Dick’s Sporting Goods Park in Commerce City, CO to take place over Labor Day Weekend – September 2 – 4. The shows will be the final ones of summer and fall for the band, who kick off their tour on May 27 at Bethel Woods in Bethel, NY.

    April 25, 2011

    Old Shows: Random Show Review – 08/20/1993 [The Phish Experience]

    April 21, 2011

    Phish: 04/21/1990 SBD Fort Collins, CO

    March 20, 2011

    Cactus: Mike Gordon Band w/ Vic Wooten 03/13/2011 Sailin’ Shoes [VQ: A-, AQ: A-]

    YouTube Preview Image

    Cactus: Mike Gordon Band 03/12/2011 Meat [VQ: B-, AQ: C+]

    YouTube Preview Image

    March 17, 2011

    Cactus: Mike Gordon Band 03/14/2011 Dumpstaphunk Jam [VQ: A-, AQ: B+]

    YouTube Preview Image

    March 16, 2011

    Cactus: Mike Gordon Band 03/14/2011 Mound [VQ: A-, AQ: A-]

    YouTube Preview Image

    Cactus: Mike Gordon Band 03/14/2011 Black Tambourine [VQ: C, AQ: B-]

    YouTube Preview Image

    Phish: 04/07/1990 II SBD UNCIRCULATED Crested Butte, CO

    March 15, 2011

    Cactus: Mike Gordon Band w/ Dumpstaphunk 03/14/2011 Jaded [VQ: B+, AQ: B+]

    YouTube Preview Image

    Cactus: Mike Gordon Band 03/14/2011 Mound [VQ: B+, AQ: B+]

    YouTube Preview Image

    Cactus: Mike Gordon Band 03/14/2011 DAUD Denver, CO

    Reviews: Mike Gordon at the Ogden 3/14 [Westword]

    Cactus: Mike Gordon Band 03/14/2011 Denver Setlist [Mike-Gordon.com]

    March 14, 2011

    Cactus: Vic Wooten Sits In With The Mike Gordon Band [Hidden Track]

    Two of our favorite bassists joined forces last night at the Belly Up in Aspen, where Vic Wooten of The Flecktones sat in with the Mike Gordon Bandfor the Phish original Meat, a cover of Sailin’ Shoes by Little Feat and the Tom Cleary-written Crumblin’ Bones. Wooten has a long history with Gordon, having first guested with Phish for most of the second set in Salt Lake City, Utah on August 21, 1993 and then again on July 9, 1997 in Lyon, France.

    Cactus: Mike Gordon Band 03/13/2011 Aspen Setlist [Phish.net]

    March 12, 2011

    Trey Anastasio: TAB 03/02/2011 LivePhish SBD Denver, CO

    March 10, 2011

    Trey Anastasio: TAB 03/01/2011 LivePhish SBD Denver, CO

    March 4, 2011

    Trey Anastasio: TAB 03/02/2011 Black Dog [VQ: A, AQ: A-]

    YouTube Preview Image

    Trey Anastasio: 03/02/2011 My Friend [VQ: A-, AQ: A-]

    YouTube Preview Image

    March 3, 2011

    Setlists: Trey Anastasio Band – Denver – 03/02/2011 [OhKeePah Blog]

    Trey Anastasio: 03/01/2011 Wolfman’s Brother [VQ: B, AQ: B+]

    YouTube Preview Image

    March 2, 2011

    Trey Anastasio: TAB 03/01/2011 Denver Setlist [OhKeePahBlog]

    January 10, 2011

    Phish: 11/01/1991 DAUD New Source Denver, CO

    December 13, 2010

    Phish: 08/09/2010 Shine a Light [VQ: A+, AQ: A+, 4-CAM]

    YouTube Preview Image

    December 10, 2010

    Phish: 08/05/1996 I DAUD New Source Morrison, CO

    December 7, 2010

    Phish: 04/07/1990 SBD UNCIRCULATED Crested Butte, CO

    November 24, 2010

    Remasters: 03/13/1993 – Boulder, CO [Ghetto-Fab]

    November 16, 2010

    Cactus: Mike Gordon Band 11/13/2010 DAUD Boulder, CO

    November 15, 2010

    Cactus: Review – Mike Gordon Band @ the Fox [Hidden Track]

    Cactus: Review – Mike Gordon at the Fox Theatre [Reverb]

    October 16, 2010

    Phish: 10/12/2010 On Your Way Down [VQ: A-, AQ: A-]

    YouTube Preview Image