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

    Polls RSS

    March 13, 2012

    Polls: Have You Used Social Media at Phish Shows? [PhanArt]

    October 29, 2011

    MSG Tickets: Poll – How Did You Do? Did You Score Phish Tickets? [Hidden Track]

    October 14, 2011

    Polls: Help Determine How Phish Fans Compare to DMB Fans or Dead Fans [Headcount.org]

    Before anyone asks for your vote, they should ask what you think. So with the Presidential election a year away, HeadCount has put together the first poll that specifically asks music fans what they think about the world around them.
    It will reveal our political and musical DNA.

    We’ll then share the results with artists and publish them online, comparing how fans of different bands answered each question.

    July 13, 2011

    Watkins Glen: Postcards From Page Side – Super Ball IX [Hidden Track]

    June 29, 2011

    Polls: Leg 1 Survey Results Matched With My Opinion [OPT]

    Polls: Final Thoughts From Leg One Survey [Hidden Track]

    June 28, 2011

    Polls: Phish Summer Tour 2011 Leg One Survey Results [Hidden Track]

    Phish Summer 2011 Summer Tour Leg One is now nothing but a memory. Super Ball IX, which will undoubtedly create unbelievable memories for the fans that are there and also those listening at home, is knocking on the door. But what about the memories of Leg One? What did everyone think? Well over 1,000 fans took the time to fill out our survey and shared their thoughts on the venues, the songs, the jamming, the ticket prices and even the band’s legendary ‘Fleezer.’

    May 19, 2011

    Polls: The State of the Phish [Online Phish Tour]

    November 11, 2010

    Polls: Phish Fall Tour 2010 Survey Results [Hidden Track]

    November 9, 2010

    Surveys: Phish Fall Tour 2010 Survey [Google Doc]

    September 7, 2010

    Polls: Did You Score Phish Tickets? [Hidden Track]

    August 30, 2010

    Polls: Phish Summer Tour Survey – Results [Hidden Track]

    Interestingly, Leg 1 and Leg 2 were like distant cousins rather than soul brothers. They could not have been more different and we thought it would be interesting to re-survey the masses to get their opinions on the second leg, the overall tour and some other assorted questions.

    August 19, 2010

    Surveys: Poll – Grading Leg 2 of Phish Tour [Hidden Track]

    July 7, 2010

    Surveys: Phish Summer Tour 2010 – Survey Results [Hidden Track]

    Our pal Parker Harrington – aka @TMWSIY – put together a wide-ranging survey about Phish Summer Tour 2010 and received nearly 1,000 responses. Parker has kindly permitted us to share the results with our readers…

    July 5, 2010

    Surveys: First Leg Summer Tour 2010 [@TMWSIY]

    Let us know what you thought of the first 18 shows of Summer Tour 2010 by clicking the link above and filling out the survey. – ScottyB

    June 25, 2010

    Polls: Grading The First Two Weeks of Phish Tour [Hidden Track]

    June 17, 2010

    Polls: Grading The Start of Phish Tour [Hidden Track]

    November 18, 2009

    Polls: Vote Phish as the Best Concert @ MSG in the ’90s [MSG.com]

    October 23, 2009

    Survey: Fall Tour 2009 Phish Tickets Poll [Hidden Track]

    Polls: Phish Public Onsale Survey [Hidden Track]

    Visit Hidden Track to fill out our survey on whether you scored tickets through today’s public on sales.

    October 21, 2009

    Polls: Tell HT How You Did on Your Phish Fall Tour Ticket Orders [Hidden Track]

    August 17, 2009

    Polls: Who Is The Summer Tour MVP? [Coventry]

    March 31, 2009

    Polls: Cover Wars – March Madness Final Four [Hidden Track]

    October 31, 2008

    Polls: What Album Should Phish Cover Next Year? [Relix]