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"; } } ?> The Flea Market | Pluranomics.com

    Small silhouette of Doug Wolkon WELCOME TO PLURANOMICS, THE ECONOMICS OF MANY.

    The Flea Market

    A developer once told me that if you do a deal with someone that has fleas, your bound to get fleas. For example, Bear Stearns and AIG have fleas. I understand the fear-based argument for getting fleas, “We have no choice”. But borrowing more money to participate in the Flea Market can’t be our only choice. What if the “Free Markets” posed another choice? What if there was a much better way than borrowing more time and money just to get fleas (and these are big and scary fleas)?

    At first, this proposed $700 Billion fund to bailout Wall Street and the housing market and the insurance industry and the automobile industry (are there any other industries left? Oh, I forgot FOOD, and so did they!) was only $500 billion, and before that, it was only Fannie and Freddie, and before that, it was only Bear Strearns, and before that, Paulson was the CEO of Goldman Sachs, one of the masterminds behind the creation of this monster credit mess. Do you think Paulson’s next move will be to ask Goldman Sachs to advise him on a Federal Reserve IPO? He could have AIG insure the bonds and Bear Stearns could sell them. All for “the interest of taxpayers.”

    The U.S. government is now the largest debtor of houses in America (thanks to Fannie and Freddie), the largest employer in America (thanks to a growing Socialist government and armed forces), as well as the owner of the largest Insurance company in the world (thanks to AIG). They say we are not in a “Depression”, but this certainly make me feel depressed.

    So what’s the strategy for the $700B or is the U.S. still just sitting at the blackjack table borrowing more money from the “house”? Please assure me that you didn’t just come up with this idea yesterday. Oh yeah, you did. So would we even consider a new equitable idea or are we so accustomed to going to bed indebted that we lost our impulse to get up from the table and just walk away?

     We are using taxpayer money to eat highly leveraged financial poison. The poison will kill its acquirer; and a $700 Billion (borrowed) Fund to acquire Wall Street’s “Bad” assets will get squashed. It will take tens of Trillions of Dollars that we don’t have. So by sponsoring this most unstrategic ponzi scheme that simply steals from Peter to pay Paul, we will inflate the dollar (soon to be confused with the peso) to no end. 

    “An indiscriminate and general increase in credit facilities means simply inflation, just as does a regime of goverment paper money…and burdens the economic system with the unadapted and with those firms which are unfit to live.” – Joseph Schumpeter, The Theory of Economic Development, P. 254

    So does this country really need/want more debt? Inflation is in the air (as is asthma), so what we need is a strategic plan to get ahold of some clean oxygen to fend it off at the (energy) source.

    BREAKING NEWS: Retirement Savings and Social Security strategically evolve into Sovereign Wealth Funds:  Long-Term Strategy is to Acquire Renewable Energy Assets. Renewable Utilities expected to create stable dividends for retirees and huge, sustainable economic growth engine for troubled U.S. Economy.

    These newly formed Mini-Stockmarkets by our vast retirement savings funds will be designed to finance solar panels, windmills, and other utility producing renewable energy assets in a similar fashion to the way Wall Street used to finance houses (can you say “renewable energy mortgages”). That way, the construction industry would get back to work installing renewable technologies, and the automobile industry and steel factories would follow suite as new (sustainable) JOBS spread across America. Detroit would naturally become the leading renewable energy manufacturing city in the world. Wall Street would sell CDO’s on secure renewable energy assets and Silicon Valley would naturally lead the innovation of our renewable energy revolution. Now that’s a happy ending if I ever heard one, or maybe its just the beginning.

    Other capital savings would follow suit to compete to own their own energy. Energy costs would perpetually deflate. More competitive and sustainable, decentralized, local economies would naturally result with access to such positive energy. Our lenders (i.e. Social Security is currently our largest lender by far, talk about drinking your own blood) would certainly be happy as the economy would quickly move closer to sustainability; and with it an ability to repay our debts.

    Is it possible to fight inflation at the energy source? Yes, and its the only true way. They built our utility grid across the U.S. in the early 1900’s. Our challenge certainly pales in comparison to the journeymens’ of those early years as they couldn’t even utilize the grid when constructing it. The goal of our retirement savings funds would be to produce enough renewable energy/dividends to fully power the utility grid in 10 years time, while throwing off enough cash dividends from our utility bills to “securely” make our retirement and Social Security payments.

    Could our retirement savings become the leaders of the Free Market? I don’t know, but sounds like a strategic economic plan; unless of course you had your heart set on the Flea Market.

    Related Posts

    comment_status) && ('open' == $post->ping_status)) : // Comments and trackbacks open ?> comment_status) && ('open' == $post->ping_status)) : // Only trackbacks open ?> comment_status) && !('open' == $post->ping_status)) : // Only comments open ?> comment_status) && !('open' == $post->ping_status)) : // Comments and trackbacks closed ?> ", ""); ?>

    Post a Comment

    Your email is never published nor shared.
    All comments are held for approval and will not appear immediately.
    Links and paragraphs are formatted automatically.
    Some HTML is allowed… <a>, <strong>

    (will not be published)

    Subscribe to Comments