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

    Daily Planet RSS

    August 11, 2010

    Telluride: Phans Boost Local Economy [Daily Planet]

    August 10, 2010

    Telluride: Hook, Line… – Tickets Situation [Daily Planet]

    Waterwheel: Enviro non-profits advocate at Phish shows [Daily Planet]

    August 8, 2010

    Telluride: What Phans Need to Know [Daily Planet]

    August 7, 2010

    Telluride: Few, The Proud – Those With Tickets [Daily Planet]

    August 4, 2010

    Telluride: Telluride Medical Center Prepares For Phish [Daily Planet]

    Law enforcement and emergency services in Telluride are preparing for next week’s two-night run of Phish shows by hiring extra officers calling in extra medical equipment.

    At the Telluride Medical Center, preparations are also under way for what is to expected to be a busy couple days. The medical center will be doubling the number of physicians and more than doubling the number of nurses, as well as adding extra staff to its on-call list during the concert dates. Its primary care department will also increase staffing, and won’t schedule any routine visits in order to devote more attention for minor injuries. TMC has also stocked up on medications and supplies in anticipation of the patterns of illness they are likely to see in the emergency department.

    May 7, 2010

    Telluride: Tickets For Locals Sell Out [Daily Planet]

    May 5, 2010

    Telluride: Tickets For Locals Still Available [Daily Planet]

    April 5, 2010

    Telluride: The Agony and Ecstasy of the Phish Line [DailyPlanet]

    March 26, 2010

    Telluride: Phish Tickets Q&A [Daily Planet]

    Q: Can I buy a ticket for my friend who lives somewhere else?

    A: No. Only locals get tickets.

    Q: Who is considered a local?

    A: Anybody who lives in San Miguel County.

    Q: What if I live near here, in Montrose, Ridgway, Rico, Nucla or Naturita?

    A: Not good enough. You must live in San Miguel County.

    March 16, 2010

    Telluride: If Phish Is Like The Grateful Dead [Daily Planet]

    March 10, 2010

    Telluride: Town Council Approves Potential Phish Shows [Daily Planet]

    March 4, 2010

    Telluride: Mark Your Calendars – Phish [Daily Planet]

    “There’s clearly an economic benefit to having them come,” said board member Dawn Ibis.
    Representatives from the Telluride Jazz Celebration attended. The Phish shows are on a Monday and Tuesday directly following the Jazz festival’s weekend. Jazz’s director Paul Machado is worried that Phish will crowd his festival and that Phish heads will snatch up all the rooms in town, leaving Jazz fans nowhere to go.

    But Terry Tice, president of the Jazz board of directors, said he hoped that the two events could work together and “it will end up being a win-win for both organizations, and the community as well.”

    February 25, 2010

    Telluride: Gone Phishing – Jamband Moves Closer to Coming [Daily Planet]

    It seems like Phish could happen. Yesterday in a special meeting, the Telluride Parks and Recreation Commission gave the nod to promoters hoping to use Town Park for two nights in August to host the iconic jam band, known for its decade-long songs and wandering legion of fans. As it stands right now, promoters would release 9,000 tickets a night on Aug. 9 and 10 and set the curfew at 11 p.m. for the foursome. No opening band is anticipated.

    But don’t start shouting opener requests just yet: Promoters still need to collect two more approvals, one from the Commission for Community Assistance, Arts and Special Events and another from the Telluride Town Council. The application will be in front of CCAASE next month.

    February 22, 2010

    Telluride: On The Summer Menu – Phish? [Daily Planet]

    In the history of good times, there have been a few announcements that sent shock waves of hope and excitement through their communities.

    New York, 1933: “Huzzah! Prohibition’s kaput!”

    L.A., 1966: “Any of you lovely birds up for Twister?”

    Telluride, 2010: “Dude! Phish!”