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"; } } ?> The Gods Must Be Crazy at Flopped the Nuts



    The Gods Must Be Crazy

    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. It’s stupid. I know this.)
    I am the last player of four to limp in to see the flop, which comes 8♦9♦9♣. Well, hot-skippy! I’ve got a set! The three ahead of me bet/raise/re-raise like it’s a limit game, so I go double the re-raiser. That chases everyone except the re-raiser.
    Turn comes 9♦ – the flush card. I smooth-call the smallish bet.
    River comes K♣, filling me up. UTG bets half of what I’ve got left, I go all-in and double through.

    Nice. I’m almost back to the $13 I started with…

    Two hands later:
    K♠9♥. Huh… Same hand. Better play it. (I have already admitted terminal stupidity.)
    Five limpers see the 9♣3♦A♠ flop. UTG bets minimum, everyone calls. I’m not feeling great about the middle pair with the ace out there, but a minimum bet isn’t enough to make me drop a made pair in this case.
    The turn brings 9♦, which makes me feel a lot better. I only bet double the big blind, but I get only one caller.
    The river is a J♥, and my trip nines are good for a little more than $5.

    I’m in the black for the first time tonight… Woo!

    Three hands after that:
    I get T♦9♥ under the gun. For some reason, I call the big blind and raise that drops after me.
    Flop: 5♦T♣A♦ – Once again, I have the middle pair with an ace on board. I bet out, and all of the other three players call.
    Turn: 9♣ – Two pair is good enough for me at this table. I bet 6BB and get two callers.
    River: 9♦ BINGO! I bet 8BB and get one caller, resulting in a $13+ pot.

    Suddenly, I have doubled my stake.
    On marginal hands.
    I wasn’t meant to bust tonight, I guess. ;)

    (This post is mostly a means to test-drive the card plugin I got for Wordpress. Thanks for indulging me.)



    No Responses to “The Gods Must Be Crazy”  

    1. No Comments

    Leave a Reply