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"; } } ?> VQA | YEMblog - Page 2

    VQA RSS

    January 1, 2012

    Phish: 12/31/2011 Steam > Auld Lang Syne > Down With Disease [VQ: A, AQ: A+]

    YouTube Preview Image

    December 30, 2011

    Phish: 12/29/2011 MKDevo Playlist [VQ: A, AQ: A+]

    Set 1: The Sloth, You Enjoy Myself, Back on the Train, The Moma Dance, Funky Bitch, Maze, Roses Are Free, Halley’s Comet > Run Like an Antelope

    Set 2: Crosseyed and Painless > Simple > Lifeboy, Guyute, Mike’s Song > Chalk Dust Torture[1] -> I Am Hydrogen > Weekapaug Groove, Show of Life > Character Zero

    Encore: Loving Cup

    Phish: 12/29/2011 HarpuaFSB Playlist [VQ: A, AQ: A+]

    Set 1: The Sloth, You Enjoy Myself, Back on the Train, The Moma Dance, Funky Bitch, Maze, Roses Are Free, Halley’s Comet > Run Like an Antelope
    Set 2: Crosseyed and Painless > Simple > Lifeboy, Guyute, Mike’s Song > Chalk Dust Torture[1] -> I Am Hydrogen > Weekapaug Groove, Show of Life > Character Zero
    Encore: Loving Cup

    December 29, 2011

    Phish: 12/28/2011 HarpuaFSB Playlist [VQ: A, AQ: A+]

    Free, Glide, Cities, Curtis Loew, Stash, Contact, Sample, Kill Devil Falls, Bathtub Gin, Birds, Carini, Tweezer, My Friend, Rock and Roll, NICU, Bouncing, Harry Hood, Bug, Tube, Rocky Top, Tweezer Reprise

    December 28, 2011

    Phish: 11/24/1998 Tweezer [VQ: A-, AQ: B+]

    YouTube Preview Image YouTube Preview Image

    Phish: 02/22/2003 The Sloth, Dogs Stole Things [VQ: A-, AQ: A+]

    YouTube Preview Image

    December 26, 2011

    Phish: 10/04/1999 Playlist [VQ: A-, AQ: A-]

    Funky Bitch, Vultures, Runaway Jim, Jesus Just Left Chicago, Runaway Jim, Limb By Limb, Wilson, Down With Disease

    December 23, 2011

    Phish: 10/31/1989 Oh Kee Pa > Suzy Greenberg [VQ: A-, AQ: A-, Pro-Shot]

    YouTube Preview Image

    Phish: 05/31/2011 After Midnight [VQ: A, AQ: A+]

    YouTube Preview Image

    December 19, 2011

    Phish: 11/16/1996 Playlist [VQ: A-, AQ: A-]

    embed

    Runaway Jim, The Vibration of Life w/ Kung and Catapult, Guyute, Gumbo, Rift, Free, The Old Home Place, David Bowie, Lawnboy, Sparkle, Frankenstein

    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

    Phish: 10/30/2010 Entire Show [VQ: A, AQ: A+]

    Set 1: Kill Devil Falls, Cavern, Foam, Guelah Papyrus, Chalk Dust Torture, Whole Lotta Love, Chalk Dust Torture, Ha Ha Ha, Walk Away, Wolfman’s Brother, Undermind , Bathtub Gin, The Squirming Coil

    YouTube Preview Image

    Set 2: Tube, Possum, Tweezer, Heartbreaker, Tweezer, Ramble On, Thank You, Tweezer, Stairway To Heaven, Halley’s Comet, Also Sprach Zarathustra, David Bowie, Show of Life, Backwards Down the Numberline, Good Times Bad Times

    Encore: Sleeping Monkey, Tweezer Reprise

    YouTube Preview Image

    December 10, 2011

    Phish: 10/29/2010 Entire Show Atlantic City, NJ [VQ: A, AQ: A+]

    Set 1: The Star Spangled Banner, My Soul, AC/DC Bag, Ocelot, Sample In a Jar, Light Up Or Leave Me Alone, Sugar Shack, Timber (Jerry), Bouncing Around the Room, Axilla, Rift, The Moma Dance, Cities, 46 Days

    YouTube Preview Image

    Set 2: Punch You In The Eye, Sand, Carini, Prince Caspian, Corinna, Piper, Theme From the Bottom, Golgi Apparatus, Slave To The Traffic Light, Fluffhead

    Encore: Loving Cup

    YouTube Preview Image

    [Setlist via Phish.net]

    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

    December 5, 2011

    Phish: 10/31/1996 All of MTV’s Pro-Shot Footage of Remain In Light [VQ: A+, AQ: A+]

    YouTube Preview Image

    December 1, 2011

    Trey Anastasio: Trey Solo Acoustic – Video of Entire Set [VQ: A+, AQ: A+, Official]

    November 30, 2011

    Phish: 08/15/2011 Dirt [VQ: A, AQ: A+]

    YouTube Preview Image

    November 27, 2011

    Trey Anastasio: TAB 11/12/2011 Push On Till The Day [VQ: A+, AQ: A+, Pro-Shot]

    YouTube Preview Image

    November 22, 2011

    Video: Phish Shares Official Video of Halley’s Comet From Hampton ’97 [Hidden Track]

    November 15, 2011

    Cactus: Mike Gordon 11/13/2011 Funky Bitch, Won’t Get Fooled Again [VQ: A-, AQ: A-]

    YouTube Preview Image

    November 8, 2011

    Trey Anastasio: TAB 10/12/2011 Push On Till The Day [VQ: A, AQ: A+]

    YouTube Preview Image

    Phish: 06/18/2011 Run Like An Antelope [VQ: A-, AQ: B]

    YouTube Preview Image

    November 7, 2011

    Phish: 08/16/2011 Foam [VQ: A, AQ: A+, 6-cam]

    YouTube Preview Image

    November 3, 2011

    Trey Anastasio: Trey w/ New York Philharmonic 09/12/2009 You Enjoy Myself [VQ: A-, AQ: A-]

    Covers: Scorchio Quintet 10/17/2011 Stash [VQ: A, AQ: A]

    YouTube Preview Image

    November 2, 2011

    Phish: 12/02/2009 Chalkdust Torture [VQ: A, AQ: A+, Angle: On-Stage]

    YouTube Preview Image

    October 30, 2011

    Phish: 10/31/2010 Feats Don’t Fail Me Now [VQ: A, AQ: A+]

    YouTube Preview Image

    October 27, 2011

    Trey Anastasio: TAB 10/12/2011 Ocelot [VQ: A, AQ: A+]

    YouTube Preview Image

    October 25, 2011

    Phish: 08/15/2011 Guelah Papyrus [VQ: A, AQ: A+]

    YouTube Preview Image

    October 22, 2011

    Cactus: Mike Gordon w/ Marco Benevento Trio 10/21/2011 Green Onions, Twin Killers [VQ: A-, AQ: B]

    YouTube Preview Image

    October 21, 2011

    Trey Anastasio: TAB 10/12/2011 Magilla [VQ: A, AQ: A+]

    YouTube Preview Image

    October 20, 2011

    Trey Anastasio: TAB 10/12/2011 Pigtail [VQ: A, AQ: A+]

    YouTube Preview Image

    October 18, 2011

    Trey Anastasio: TAB 10/12/2011 Plasma [VQ: A, AQ: A+]

    YouTube Preview Image

    Page McConnell: Page /w moe. 09/03/2006 Blue Jeans Pizza [VQ: A+, AQ: A+]

    YouTube Preview Image

    October 17, 2011

    Trey Anastasio: TAB 10/12/2011 Shine [VQ: A, AQ: A+]

    YouTube Preview Image

    Trey Anastasio: TAB 10/12/2011 Small Axe [VQ: A, AQ: A+]

    YouTube Preview Image

    October 14, 2011

    Trey Anastasio: TAB 10/12/2011 Ooh Child [VQ: A, AQ: B-]

    YouTube Preview Image

    In memory of Ricky Bell

    Trey Anastasio: TAB 10/12/2011 Small Axe [VQ: A-, AQ: B+]

    YouTube Preview Image

    October 11, 2011

    Trey Anastasio: TAB 10/07/2011 Pigtail [VQ: A-, AQ: A-]

    YouTube Preview Image

    Phish: 09/14/1999 Set Two [VQ: A-, AQ: A-, Two-Cam]

    YouTube Preview Image

    Peaches en Regalia > AC/DC Bag  > Gumbo > Down With Disease, Frankenstein

    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

    October 9, 2011

    Trey Anastasio: TAB 10/08/2011 Land of Nod [VQ: A, AQ: B+]

    YouTube Preview Image

    Phish: 07/06/1998 Ghost [VQ: A, AQ: A+]

    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 30, 2011

    Phish: 08/15/2011 Trey Talks Curfew / Camel Walk [VQ: A, AQ: A+]

    YouTube Preview Image

    Phish: 11/30/1991 Partial Show [VQ: A, AQ: A-]

    YouTube Preview Image

    Harry Hood [1], It’s Ice – Bouncing Around the Room, My Sweet One – Horn, I Didn’t Know [2]

    [1] DEG and Bewitched Bothered and Bewildered teases from Trey.
    [2] Fishman on trombone mouthpiece.

    Trey Anastasio: Oysterhead 06/16/2006 Entire Show Playlist [VQ: A, AQ: A, DVD-RIP]

    September 29, 2011

    Phish: 11/01/2009 Secret Smile [VQ: A, AQ: A+, Multi-CAM]

    YouTube Preview Image

    September 27, 2011

    Trey Anastasio: Oysterhead 11/18/2001 Entire Show Playlist [VQ: A-, AQ: A]

    Owner of the World, Polka Dot Rose, Oz Is Ever Floating, Shadow of a Man, Army’s On Ecstasy,  Wield The Spade, Birthday Boys, Pseudo Suicide, Little Faces, Rubberneck Lions, Mr. Oysterhead, Immigrant Song

    September 21, 2011

    Phish: 06/17/2011 Stealing Time From The Faulty Plan [VQ: A+, AQ: A+, Pro-Shot]

    YouTube Preview Image

    Phish: 05/28/2011 Cities [VQ: A, AQ: A]

    YouTube Preview Image

    September 20, 2011

    Phish: 09/14/2011 Carini [VQ: A+, AQ: A+, Pro-Shot]

    September 19, 2011

    Phish: 08/15/2011 Steam [VQ: A, AQ: A+]

    YouTube Preview Image

    September 16, 2011

    Phish: 09/14/2011 MKDevo Playlist [VQ: A, AQ: A+]

    ENTIRE SHOW

    PLEASE SUPPORT THE VERMONT FLOOD RELIEF EFFORT BY PURCHASING LIVEPHISH AUDIO

    September 10, 2011

    Phish: 10/19/2010 Weekapaug Groove [VQ: A, AQ: A+]

    YouTube Preview Image

    September 9, 2011

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

    September 4, 2011

    Phish: 09/03/2011 Tweezer [VQ: A+, AQ: A+, Pro-Shot]

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

    September 3, 2011

    Phish: 08/17/2011 Makisupa > Sleep > Buffalo Bill [VQ: A+, AQ: A+, Pro-Shot]