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"; } } ?> @YEMblog Twitter Updates for 2010-06-14 | YEMblog
    • Phish @ Hershey – Setlist and Recap: http://j.mp/9lHVtz #phish #
    • End show #
    • Advantage me #
    • #phish axis #
    • Frankenstein teases #
    • Slayin it(in case there was any doubt) #
    • running low on bat. Assume yem will b awesome. Even a bad yem would b ground rule double in baseball #
    • Yem #
    • Yea i know it’s hear #
    • Yem or slave to end set? Tweet to here ur voice heard but band won’t look at them #
    • Seriously chocolate pieces in the ices, yes it’s still wading #
    • Sooo I highly recommend chocolate ices next time ur here. Insane #
    • Wading #
    • 1st time piper, twist, free were played in same set. #thingsmyfriendrickwouldsaythatarenttrue #
    • > free #
    • Would give left nut for piper ending to come back #bringbackpiperending #
    • Helmet on. I’ve got all the room in the world here #
    • DUCK #
    • Piper #
    • Funky breakdown. I love these guys #
    • Set 2 shit set 1 for breakfast #
    • Always think of Miami 2003 #
    • #phish >twist #
    • Sounds like they want to go into so ething #
    • So far smooth as a baby bottoms. Creepy to say if u r not a dad #
    • I will b tweetin last note of reprise on walk to car #
    • >tweezer #
    • Tweeze #
    • Lookin strong like bull similar talking head sounds like ghost the other night #
    • This is where the song either explodes or dies. #
    • I dare u to find a set starting w drowned that isn’t awesome #
    • Suck it bitches #
    • #phish drowned #
    • Lights out #
    • Melt would b highlight for me. Hopin they let loose 2nd set. Bar was set high last night. I like follow through #
    • End set #obvs #phish #
    • But Cleveland is still laughing #
    • Daddy like. #
    • Melt #
    • #phish Cleveland is laughing at me #
    • My wife still hasn’t seen sparkle in 50+. Thanks honey for being so great #
    • Sparkle #
    • Maybe tweezer? #
    • Hopin for kdf #
    • Feelin really strong closer #
    • Def roor tune #
    • #phish bouncin #
    • special shout out to ROOR #
    • Waits for PA #
    • #phish ice #
    • Not the tightness B likes for $60 #
    • 3:49 seconds time it #
    • #phish horn #
    • One of my fav lil Trey solos #
    • #phish nicu #
    • #phish likes where this is going #
    • scuse while I get ready 2 jump all silly #
    • #phish love the placement, never met I Jim I didn’t like #
    • #phish Jim #
    • #phish I eat this shit up, bitches are quite rare these days #
    • #phish bitch #
    • #phish making fluffhead onesie for Luke when I get home #
    • #phish I will not b tweeting every flub #
    • Fluff = always sickness #
    • C u n 18 min Ill review now…it’s fuckin fluffhead. No review needed #phish #
    • See u 18 #
    • #phish fluff #
    • #phish standard awesomeness #
    • Thus far: Gotta Jibboo, Chalk Dust Torture #phish #
    • #phish chakdudt #
    • #phish great song to loosen boys up right away. I’ve heard feeds are A + #
    • Kuroda 15 feet to my left #phish. Hangin w/ the kellys. #
    • Sorry for false start #
    • #phish gibio #
    • #phish Wilson #
    • $25 ticket! Game on #phish. #
    • It’s been a scorcher of a day. Clouds commin in. # phish time to find a ticket #
    • Nice work by the Plain-Dealer covering last night’s gig http://j.mp/bbTMGm Especially like the song-length graphic http://j.mp/a1crTE #phish #
    • Some Notes on the Debuts of Look Out, Cleveland and Instant Karma! http://bit.ly/aB1hoX #phish #
    • @youenjoyme Checking in from parking lot #phish I’ll b ur guide for the rest of day #
    Posted by on June 14, 2010 at 9:45 AM

    More News & Views

    Topics:

    Post a Comment

    You must be logged in to post a comment.