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"; } } ?> Open for Localism | Pluranomics.com

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

    Open for Localism

    Why is our ability to economically coexist together so dam complicated? If we are so smart, why is our economy so stupid? Future contracts, derivatives, insurance. Did we build this global economy house of cards, or did we inherit it? Either way, can we please take it down before it crumbles?

    With China raising interest rates twice in the past month; and oil, electricity and gold perpetually rising in US Dollar terms, the purchasing power of the US Dollar is nearing panic mode. A frenzy-like rise, if you will. Gold is trending like it may even be the next Google, or will it be oil? The continued rise in oil specifically, will have dramatic effects across the U.S. and Europe’s economy that will be felt for years to come. It is no help that our seemingly long time best bud, China, is now in control of world interest rate levels, and on their way to world economic dominance. In my opinion, such a rising interest rate environment will instantaneously crater what’s left of the fragile US housing market, bankrupt Wall Street (again), and take down our interest-tied, debt-ridden municipalities with it.

    Personally, I find myself at odds with the whole thing. Please let me explain. I saw and bought Gold at $400 per ounce in 2004 and hung tight with it as it tripled in price, right up until this moment. And in my opinion, as the U.S. and Europe are forced to borrow more and more to pay for increased borrowing costs (higher interest rates), and caught in a perpetual cycle; Gold is ripe to double or triple in price again from this point forward. However, I am at the point where I am fearful to root for Gold’s rise any longer. You see, I am betting my personal investment savings on Gold, and as Gold rises in price, the dollar is plummeting in relative terms; and although it seems like I am “winning” the financial poker game, I view myself truthfully shortsighted in my financial glory. I am very concerned that if Gold continues to rise further and further, the economic riches that find their way into the American economy will be gone for a long, long time; and potentially chaos may even pursue.

    I am fearful of such an outcome; the unknown of it all. But inside, I hope things will turn out different. I hope we won’t depend on bailout funds this time around, because the tens of trillions of dollars required won’t be there. I hope we consciously shift our intentions now, so there will be a new outcome, while the U.S. Dollar’s purchasing power is still trusted. I hope we become  aware of our economic reality, embrace a different financial strategy, and start saving some usable acorns like renewable energy just in case its a long, long winter.

    In my opinion, we have two choices: 1.) we can freeze-up and hoard our tremendous personal and institutional savings, which will only create more panic, more empty houses, more unused cars and higher unemployment, or  2.) we can invest it calmly and intelligently to our own benefit. You see, our weakness is also our strength. As I described above, the economic system is currently very weak, so a strategic attack or aggressive investment now would be both economically and financially advantageous. Makes sense, right?

    Attached is an outline of such a strategic attack called a Local Investment Fund, with a focus on renewable energy and real estate. As investors, our timing to acquire local assets at rock bottom prices, as well as create energy competition in the local markets, is impeccable. Remember, only a 5-10% allocation of our savings towards such a fund would dramatically shift the economic energy to the local economy. The local economy will soon prove to be the best place to protect our savings while improving our lifestyle and happiness. The Local Investment Fund will be invested locally, in front of our own eyes. Such a local investment strategy allows us to physically touch and feel the assets that comprise our savings, actually explain how our financial return is generated, and personally meet the team that is responsible to protect and grow our savings; all the while igniting local job growth and lowering cost of living.

    Happy New Year!


    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 ?> ", ""); ?>

    1 Comment so far      Post a Comment

    1. Greetings Doug, I’m co-creator of a plan for a non-profit farmer’s market. We’ve been considering investing in a property to build a structure for the market. Would creating an investment fund (separate from the market) designed to acquire the land and build the structure be a good idea? Thereafter we could rent the space to the non-profit market as our anchor tenant. What type of “localism” fund would you suggest we look into? How would it cost to set up?, how long would it take?, and who should I engage? Thanks. -ahug

    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)
    (optional)

    Subscribe to Comments