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/blog 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: Bugfix from Matthias Schutz regarding time_since. Version 1.5.9: Added function redefiniotion protection if people use the plugin in several places */ 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, $tablecomments, $tableposts; if(!function_exists('blc_clamp')) { function blc_clamp($min, $max, $val) { return max($min,min($max,$val)); } } function get_channel($col, $offset) { return hexdec(substr($col, $offset, 2)); } function channels($col) { $r = get_channel($col, 1); $g = get_channel($col, 3); $b = get_channel($col, 5); return array($r, $g, $b); } $max_time = $range_in_days * 24 * 60 * 60 ; function scale_channel($old, $new, $diff, $max_time) { $range = $old - $new; $c = round($diff/$max_time*($range))+$new; $c = blc_clamp(min($new, $old), max($new, $old), $c); $c_hex = str_pad(dechex($c), 2, '0', STR_PAD_LEFT); return $c_hex; } $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 ($tablecomments LEFT JOIN $tableposts ON (comment_post_ID = ID)) WHERE comment_approved = '1' AND $tableposts.post_status='publish' $ping ORDER BY comment_date DESC;"); $seen = array(); $num = 0; if($fade_old) { list($r_new, $g_new, $b_new) = channels($new_col); list($r_old, $g_old, $b_old) = channels($old_col); } 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 $tablecomments 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 $tablecomments 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($commenters[0]->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_hex = scale_channel($r_old, $r_new, $diff, $max_time); $g_hex = scale_channel($g_old, $g_new, $diff, $max_time); $b_hex = scale_channel($b_old, $b_new, $diff, $max_time); $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"; } } ?> 2005 April at Flopped the Nuts

    Archive for April, 2005

    Colorado Poker Raid

    1 Comment Published by Textbook 3 years, 2 months ago in In the News, Average Joes

    Two dozen arrests in small town gambling ring
    Authorities say the group was playing Texas Hold-em illegally. The card game is not illegal to play, but when you do it for money at a liquor establishment it is illegal. “There is a perception that these types of games may be legal. In fact they’re not,” says […]

    Doyle’s Room

    1 Comment Published by Textbook 3 years, 3 months ago in Online Poker

    A review of Doyle Brunson’s online poker site

    Peacock Poker

    0 Comments Published by Textbook 3 years, 3 months ago in On the Tube, Professionals

    In a curious development, the Poker Superstars Invitational, the bizarrely structured and infinitely long big-name-only poker tourney that has been a mainstay on Fox Sports for a while now, popped up on NBC this afternoon opposite the NFL draft.
    Despite the network weirdness, it was a decent show, with madman Gus Hansen taking out the entire […]

    Wil at the WPT

    2 Comments Published by Textbook 3 years, 3 months ago in Casino Play, Celebrities

    He hasn’t played a hand yet (and if he’s still alive come Wednesday, he plans to leave early), but Wil Wheaton already has two enjoyable posts reporting from the WPT finals.

    The Comeback Continues

    0 Comments Published by Textbook 3 years, 3 months ago in Online Poker

    No, not really. Considering I got down to $13 on Paradise from a high of $150 or so, this is still all red ink.
    At any rate, I bought into the $25 max NLHE ring game again. Ended up finishing over $40 after 50 hands (about an hour). Still doesn’t beat the day job, but it’s […]

    The Gods Must Be Crazy

    0 Comments Published by Textbook 3 years, 3 months ago in Administrivia, Online Poker

    It’s like Paradise knew I was playing on a $25 Max NLHE ring game with the last $13 in my account tonight.
    I was down to about $6 or so when I played K♠9♥ in late-middle position. (It’s a weakness I have: Starting hands that are both ends of a straight and include a face card. […]

    Search

    About

    You are currently browsing the Flopped the Nuts weblog archives for April, 2005.

    Longer entries are truncated. Click the headline of an entry to read it in its entirety.

    Latest

    RSS

    Archives

    Categories