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"; } } ?> Mike Gordon Band | YEMblog - Page 2

    mike gordon band RSS

    March 14, 2011

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

    March 12, 2011

    Interviews: Talkin’ Moss With a Jam Band Icon [Aspen Daily News]

    “I would like to transcend my influences and Phish is my biggest influence,” Gordon told me on a tour stop in sunny San Diego. “So as time goes on I would like to go in a direction so when people come see my band it will be an experience they can’t get anywhere else, including with Phish, and it’s starting to happen.”

    Cactus: Mike Gordon Band 03/11/2011 DAUD Flagstaff, AZ

    March 11, 2011

    Cactus: Mike Gordon Band 03/09/2011 Playlist [VQ: B+, AQ: B+]

    http://www.youtube.com/view_play_list?p=121B29B28401031A

    Idea, Cities, Meat, Mound, Traveled Too Far, La La, Nobody’s Home

    Interviews: Phish bassist Mike Gordon in Aspen [Aspen Times]

    March 10, 2011

    Contests: HT Giveaway – Win Tickets to See Mike Gordon [Hidden Track]

    Cactus: Mike Gordon Band 03/09/2011 San Diego – Setlist [Phish.net]

    Cactus: Mike Gordon Band 03/08/2011 DAUD Santa Cruz, CA

    March 9, 2011

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

    Cactus: Mike Gordon Band 03/06/2011 Takin’ It To The Streets [VQ: B, AQ: B]

    YouTube Preview Image

    March 8, 2011

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

    Cactus: Mike Gordon Band 03/06/2011 FOB Arcata, CA

    March 7, 2011

    Cactus: Mike Gordon Band 03/06/2011 Arcata, CA – SETLIST [Mike-Gordon.com]

    Cactus: Mike Gordon Band 03/05/2011 Willow Tree [VQ: B-, AQ: B]

    YouTube Preview Image

    Cactus: Mike Gordon Band 03/05/2011 Sailin’ Shoes [VQ: B-, AQ: B]

    YouTube Preview Image

    Cactus: Mike Gordon Band 03/05/2011 Babylon Baby [VQ: B+, AQ: A-]

    YouTube Preview Image

    March 6, 2011

    Interviews: HT Interview – Mike Gordon Talks Shop [Hidden Track]

    The problem is that there just isn’t enough time to play everywhere that we’d like to play and that people would like us to play. I end up going to a lot of places where I haven’t played in a while, because Phish played there in the early ’90s. On my last tour, I did that over and over again, and the places would say, “Why don’t you tell the Phish guys to play here,” and the answer usually is, “Well Phish is not going to play here, that’s why I am.” [laughs] Phish is looking for places that can fit as many people as would like to come, and that’s often certain ones in certain places. In the meantime, it’s really fun for me to get to visit some of these places I wouldn’t normally see.

    Cactus: Recap and Videos from Mike Gordon Band’s Tour Opener [Concert Confessions]

    Cactus: Phish.net Launches Mike Gordon Band Section of /Sideshows [Phish.net]

    Cactus: Mike Gordon Band 03/05/2011 She Said, She Said [VQ: B, AQ: B]

    YouTube Preview Image

    Cactus: Mike Gordon Band 03/05/2011 Dig Further Down [VQ: B, AQ: B+]

    YouTube Preview Image

    Cactus: Mike’s Own Mound [Jambands.com]

    Cactus: Mike Gordon Band Extends Mound in Eugene [Hidden Track]

    Bassist Mike Gordon and the Mike Gordon Band set off on a 17-date tour yesterday at the McDonald Theatre in Eugene, Oreg. and Cactus wasn’t kidding when he mentioned an extended version of the Rift nugget Mound in the video that announced the run. The MGB’s encore was indeed Mound and did indeed feature an extended intro and outro.

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

    YouTube Preview Image

    Cactus: Mike Gordon Band 03/05/2011 FOB Eugene, OR

    March 4, 2011

    Downloads:  Free Mike Gordon Band Download 11/16/2010 SBD [LivePhish]

    Back on November 16, Mike Gordon and the Mike Gordon Band took the stage at the Fine Line Music Cafe in Minneapolis, Minn. for a rollicking performance that HT’s Joe Ringus felt opened with a sizzling Can’t Stand Still and “never let up.” With the MGB about to kick off its first tour of 2011 tomorrow night in Eugene, Oreg.; the Phish bassist has shared a free MP3 soundboard download of the group’s show at the Fine Line Music Cafe. [via HT]

    March 3, 2011

    Previews: Mike Gordon and Crew to Play The McDonald [OregonMusicNews]

    March 1, 2011

    Contests: Win a Pair of Tickets to a Mike Gordon Band Concert [Phish.net]

    February 13, 2011

    Cactus: Mike Gordon Band on Jimmy Fallon – Horizon Line

    January 21, 2011

    Cactus: Wanee Festival 2011 – The Lineup [Hidden Track]

    Festival newcomers include the Steve Miller Band, Robert Plant and the Band of Joy as well as Ween, the Mike Gordon Band and Hot Tuna.

    January 19, 2011

    Cactus: Mike Still a Fan-Favorite For Good Reason [OPT]

    Mike is the one that has been cruising the pre-show lot scene in a golf cart for years.  Mike is the guy that answered fan mail sent to Phish via the Doniac Schvice.  Mike is the guy that set up the fan hotline.  Mike is the guy that invited fans on stage to jam with him (including our very own Guy Forget) for nearly four hours.  Mike is the guy that signed all pre-ordered copies of his new album, Moss. Mike is the guy that wrote all the silly sentences for the fans streaming the NYE shows during setbreak.  Now, Mike is the guy that’s starting a tour that starts in Oregon, goes all the way down through southern California, and through southern states before ending in the Northeast.  Almost the exact opposite of Trey’s tour completely messed up tour.

    January 18, 2011

    Cactus: Mike Gordon Announces Three-Week Tour [Hidden Track]

    Phish bassist Mike Gordon returns to the road once again with his solo band for a three-week tour that crosses the country. The MGB’s run starts on March 5th at the McDonald Theatre in Eugene, OR and wraps up at the Higher Ground near Mike’s current hometown of Burlington on March 26th.

    December 12, 2010

    Cactus: Mike Gordon 10/03/2009 DAUD Buffalo, NY

    Cactus: Mike Gordon Band – Idea – Live From Studio M [A+]

    December 10, 2010

    Cactus: Mike Gordon Band 11/27/2010 Sailin’ Shoes [VQ: A-, AQ: B+]

    YouTube Preview Image

    Mike Gordon: Mike Gordon Band 11/27/2010 One Hand In My Pocket [VQ: A-, AQ: B+]

    YouTube Preview Image

    December 3, 2010

    Cactus: MGB w/ Jon Fishman 11/26/2010 Sound [VQ: A-, AQ: A-]

    YouTube Preview Image

    November 30, 2010

    Cactus: Mike Gordon Band w/ Fishman Makisupa > Suskind [VQ: B-, AQ: B+]

    YouTube Preview Image

    Cactus: Mike Gordon Closes Fall Tour With Guests [Jambands]

    Cactus: Mike Gordon in Syracuse Photos [Ithaca Post]

    November 29, 2010

    Cactus: MGB w/ Jon Fishman 11/26/2010 Alphabet Street [VQ: B-, AQ: B-]

    YouTube Preview Image

    Cactus: Jon Fishman Sits In With Mike Gordon Band [Jambands]

    Cactus: MGB w/ Jon Fishman 11/26/2010 DAUD Portland, ME

    Cactus: MGB w/ Jon Fishman 11/26/2010 Sugar Shack [VQ: B, AQ: B]

    YouTube Preview Image

    Cactus: Mike Gordon Band 11/22/2010 DAUD Cleveland, OH

    Cactus: Mike Gordon Band 11/27/2010 DAUD Boston, MA

    Cactus: Mike Gordon Band 11/27/2010 Down to the Nightclub [VQ: B, AQ: B]

    YouTube Preview Image

    November 24, 2010

    Cactus: Mike Gordon Band 11/22/2010 Meat [VQ: B, AQ: C+]

    YouTube Preview Image

    November 19, 2010

    Contests: Want to Attend Mike Gordon’s Soundcheck? [MG Facebook]

    Contests: Win Tickets to a Mike Gordon Show [OhKeePah Blog]

    Cactus: Mike Gordon Band 11/18/2010 “The Dance-Off”

    YouTube Preview Image

    Cactus: Mike Gordon Band 11/18/2010 Funky Bitch [VQ: C, AQ: B+]

    YouTube Preview Image

    Cactus: Interview – Mike Gordon to Perform @ Bluebird [Indiana Daily Student]

    November 18, 2010

    Cactus: Picture Show – Mike Gordon Band @ Fine Line Music Cafe [HT]

    [Photo by Joe Ringus]

    Cactus: Mike Gordon Band 11/14/2010 Sailin’ Shoes [VQ: C+, AQ: B]

    YouTube Preview Image

    Cactus: Mike Gordon Band 11/14/2010 Takin’ It To The Streets [VQ: B-, AQ: B-]

    YouTube Preview Image

    Cactus: Mike Gordon at the Fine Line Recap [MNLiveMusicBlog]

    Cactus: Mike Gordon Band 11/16/2010 N’Goni > Jones [VQ: C, AQ: B]

    YouTube Preview Image

    November 17, 2010

    Cactus: Mike Gordon Tour Update [Online Phish Tour]

    Cactus: Photos – Mike Gordon Band in SLC [GonzoShots]