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"; } } ?> I Do Not Know Why the L.A. County Employee Retirement Fund Owns A 5-Star Hotel in Hawaii. Do You? | Pluranomics.com

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

    I Do Not Know Why the L.A. County Employee Retirement Fund Owns A 5-Star Hotel in Hawaii. Do You?

    Do you know how long it takes the L.A. County Employee Retirement Association to save 100 Million Dollars, the minimum cost of such a hotel? Do you? Imagine how many court cases and clerk hours worked by the Employees to actually save 100 Million Dollars? So what in the world are these hard working L.A. County Employees doing owning the prestigious St. Regis Hotel on Kauai in Hawaii. First of all, Hawaii is nowhere near L.A. And second of all, Hawaii is nowhere near L.A.

    The story goes something like this. I must first tell you that I worked 10 years as an investment advisor in real estate for these large pension funds like L.A. County Employee Retirement Fund. So back to the story. An Investment Advisor (that was me), in this case from Connecticut, convinces the Pension Fund Investment Board that it would be a good idea that they buy a 5-Star Hotel in Hawaii. Why, I can not tell you. I could think of many reasons then, but now I honestly can not think of one good reason.

    The real reason is that the Investment Advisors for L.A. County Employees are making $100 Million annually (check annual report) on such unconscious, super-risky investments; like foreign currencies and swap agreements. Do you remember how many days or hours you thought the L.A. County Employees had to work to save $100M – well it goes right out the door…annually, to people that most of the L.A. County Employees have never met.

    These stories are happening all over America. And in the end, as we are learning, the retirement dollars are not going back into our own pockets. That is stupid. I am personally guilty of it in my own 401K account. These savings are completely disconnected from our economic reality. What I am trying to say is that in my opinion, The L.A. County Employees, as do I, have much more important business to conduct at home, like taking care of ourselves and our own economy with our hard-earned savings.

    There needs to be a conscious shift in the investments and assets that our pension funds, 401Ks, IRAs and good old-fashion savings, own in our economy. The simple reason: for the direct benefit of the hard working American – You! This shift will not only save a flailing economy, it will lead it towards unknown prosperity. Remember, these unconscious pension fund investment schemes have been going on since before the Great Depression!

    Imagine the possibilities. I envision that local investments lead by these pension funds and individual retirement accounts will create the next Economic Boom! The institutional investments will include local renewable energy, local real estate, and local entrepreneurs; three simple, secure and diversified investment allocations. Imagine 100 Million Dollars invested in L.A. County renewable energy, local entrepreneurs and its real estate; instead of 3,000 miles across the Pacific Ocean in a 5-Star Hotel in Hawaii. These local investments will immediately generate true currency back into the people’s hands that simply created it in the first place . Otherwise known as consciously investing in oneself and one’s economy.


    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. My guess is that the best case interpretation is that the LA county pension fund believes that investing in a hotel 3k miles away is a form of diversification. The worst case scenario is that someone on the investment advisory side likes to stay in nice hotels in far away places. If we assume the best case for a minute and look at all the reasons why not investing locally is better, earthquakes, fire, riots, etc… Then one could make a legitimate argument to get the retirement out of LA as quickly as possible. I would bet though that the quant jocks at u of c could prove pretty quickly that in this interconnected world there is no benefit to moving the money geographically far away, vs. Keeping it at home. I think the bigger threat to the utopian dream of keeping it home is the little green monster of corruption rearing its ugly head. We have all have witnessed people in power and in control that are easily corrupted by another who has self interest. The model of having independent advisors look at investments no matter where hey are I think helps detract this inevidible outcome. So…IMHO perhaps there is balance to be stricken where a % of the money is locally invested a % is influenced by the members and a % is controlled in the traditional model that we know of today. I think there is a really nice Radisson just down the street from the St Regis that was struggling to find Investors

    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