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

    Sand RSS

    November 15, 2011

    Trey Anastasio: TAB 11/12/2011 Playlist [VQ: B+, AQ: B+]

    Clint Eastwood, Simple Twist Up Dave, Ooh Child, Sand, Heavy Things, Black Dog

    November 7, 2011

    Covers: Yonder Mountain String Band Covers Sand – Audio / Video [Hidden Track]

    October 16, 2011

    Trey Anastasio: TAB 10/15/2011 Sand [VQ: B-, AQ: B]

    YouTube Preview Image

    October 10, 2011

    Trey Anastasio: TAB 10/08/2011 Playlist [VQ: A-, AQ: B+]

    Clint Eastwood, Devil Went Down to Georgia, Money Love and Change, Sand, Magilla, Land of Nod

    July 6, 2011

    Phish: 12/31/2010 Sand [VQ: A+, AQ: A+, Pro-Shot]

    YouTube Preview Image

    Phish: Super Ball IX Videos by PlatoPlates Playlist [VQ: B+, AQ: B]

    Star Spangled Banner, First Tube, Crosseyed and Painless, Sand, The Wedge

    June 13, 2011

    Phish: 06/11/2011 Wilson > Sand [VQ: A+, AQ: A+, Pro-Shot]

    June 4, 2011

    Phish: 05/31/2011 MKDevo’s Videos – A Playlist [VQ: A, AQ: A+]

    Chalk Dust Torture, Roggae, Punch You In The Eye, Moma Dance, Rock and Roll, Sand, Tube, Divided Sky, Character Zero, After Midnight, Possum, Drowned, Maze, Dirt, Alaska, YEM

    June 1, 2011

    Phish: 05/31/2011 LinusJ Playlist [VQ: A, AQ: A-]

    Rock and Roll, PYITE, Divided Sky, Drowned Jam, Sand Jam, Tube, Dirt

    May 20, 2011

    Phish: Live in Utica Sand > Theme From The Bottom [VQ: A+, AQ: A+, PRO]

    February 25, 2011

    Trey Anastasio: TAB 02/23/2011 Sand [VQ: A-, AQ: B+]

    YouTube Preview Image

    February 3, 2011

    Songs: The Transformation of Sand [Phish Thoughts]

    A turning point for the song came in Telluride, when Mike broke form and began improvising bass leads while Trey tore into ferocious washes of sound and sustained, uncompressed phrases. Page stepped up and began playing along with Mike’s uncompromising leads before Trey drifted back into a more standard lead role. While Mike, Page and Trey engaged in a distinctly different conversation, Fishman still maintained a driving beat that kept the creativity framed in familiar style. Coming together in a crushing full-band peak, Phish capped the jam without returning to its final musical verse.

    January 12, 2011

    NYE Run: Sand, Manteca and The Holy Ghost [Phish Thoughts]

    November 2, 2010

    Phish: 10/29/2010 HarpuaFSB Playlist [VQ: A, AQ: A+]


    Star Spangled Banner, My Soul, AC/DC Bag, Ocelot, Sample In a Jar, Light Up or Leave Me Alone, Sugar Shack, Timber, Bouncing, Axilla, Rift, Moma Dance, Cities, 46 Days, Punch You In The Eye, Sand, Carini, Prince Caspian, Corrina, Piper, Theme From The Bottom, Golgi Apparatus, Slave, Fluffhead, Loving Cup,

    Phish: 10/29/2010 MKDevo’s Playlist [VQ: A, AQ: A+]


    Star Spangled Banner, My Soul, AC/DC Bag, Ocelot, Sample In a Jar, Light Up or Leave Me Alone, Sugar Shack, Timber, Bouncing, Axilla, Rift, Moma Dance, Cities, 46 Days, Punch You In The Eye, Sand, Carini, Prince Caspian, Corrina, Piper, Theme From The Bottom, Golgi Apparatus

    October 19, 2010

    Phish: 10/16/2010 Sand [VQ: B+, AQ: B]

    YouTube Preview Image

    May 3, 2010

    Phish: 06/07/2009 Camden Set II Playlist (Sand, Tweezer, etc.) [VQ: B+, AQ: B+]


    February 16, 2010

    Trey Anastasio: 02/14/2010 Sand [VQ: B, AQ: B]

    YouTube Preview Image

    January 18, 2010

    Phish: 01/01/2000 Sand [VQ: B, AQ: B+]

    YouTube Preview Image YouTube Preview Image

    October 26, 2009

    Phish: 06/07/2009 Sand [VQ: A, AQ: A]

    YouTube Preview Image YouTube Preview Image YouTube Preview Image

    June 10, 2009

    Phish: 06/07/2009 Limb By Limb, Sand [VQ: B+, AQ: C-]

    YouTube Preview Image

    June 9, 2009

    Phish: 06/07/2009 Sand Jam [VQ: B+, AQ: B+]

    YouTube Preview Image

    February 9, 2009

    Phish: 01/01/2000 Sand

    YouTube Preview Image YouTube Preview Image

    October 24, 2008

    Trey Anastasio: 10/23/2008 Sand

    YouTube Preview Image

    October 23, 2008

    Trey Anastasio: 10/18/2008 Sand Jam

    YouTube Preview Image

    October 19, 2008

    Trey Anastasio: 10/17/2008 Sand

    YouTube Preview Image

    October 9, 2008

    Phish: 09/09/2000 Sand

    YouTube Preview Image