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"; } } ?> @YEMblog Twitter Updates for 2013-06-10 | YEMblog
    Posted by on June 11, 2013 at 4:20 PM

    More News & Views

    No tags for this post.

    19 Comments so far      Post a Comment

    1. music online || August 8, 2013 at 9:56 pm | link

      Yesterday, while I was at work, my sister stole my apple ipad and tested to see if it can survive a 40
      foot drop, just so she can be a youtube sensation. My iPad is
      now destroyed and she has 83 views. I know this is entirely off topic but I had to share it with someone!

    2. Wizard101 Crown || September 9, 2013 at 3:46 am | link

      Hello there! I just wish to offer you a big thumbs up for your great
      information you have got here on this post. I am coming
      back to your blpg for more soon.

    3. www. || October 17, 2013 at 3:21 pm | link

      Take a look at some of the benefits of using a green system such as having a
      cleaner and healthier home is one very good reason to look into
      this. Now let’s also say that you regularly eat fast food or food that often contains a very high oil or grease amount.
      Here’s a partial list: pertsicides, chlorine,
      lead, bacteria, giardia, copper, chloroform, chloramines, gasoline products, and cryptosporidium.

    4. best exercise for || January 4, 2014 at 12:07 pm | link

      You are going to feel an excellent burn from
      this workout. Thus, one should choose to eat healthy
      and choose to be healthy. Turning the patient over could, however, affect the breathing
      and this may prove critical to his or her medical condition.

    5. buy old school new || June 2, 2014 at 1:04 am | link

      The load must be dispersed onto the skeletal structure in a balanced
      way, and should not produce forces on the body forward, aft, right, or left.

      Through this Rewards Plan one can begin earning money right away and
      start to build a lifetime of prosperity. The school currently boards 170 cadets, grades 7-12.

    6. phoenix sell jewelry || July 12, 2014 at 1:12 am | link

      Definitely believe that which you said. Your favorite
      reason seemed to be on the net the easiest thing to be aware of.
      I say to you, I certainly get irked while people think about
      worries that they plainly do not know about.
      You managed to hit the nail upon the top and defined out the whole thing without
      having side effect , people could take a signal. Will likely be back to get more.
      Thanks

    7. Oscar || July 26, 2014 at 10:43 am | link

      xbox 360 emulator bios download 1.7.1

    8. hack web camera || August 8, 2014 at 9:52 pm | link

      Excellent blog you have here but I was curious if you
      knew of any user discussion forums that cover the same topics discussed in this
      article? I’d really love to be a part of group where I can get advice from other experienced individuals that
      share the same interest. If you have any recommendations, please
      let me know. Appreciate it!

    9. Tout Les Jeu Gratuit || August 9, 2014 at 5:23 pm | link

      Everything is very open with a very clear clarification of the issues.
      It was really informative. Your site is useful. Many
      thanks for sharing!

    10. pest control || September 6, 2014 at 9:41 pm | link

      hello!,I love your writing so a lot! proportion we be in contact more about your
      article on AOL? I need an expert in this house to resolve my
      problem. Maybe that’s you! Looking forward to look you.

    11. sfsu || September 16, 2014 at 1:32 am | link

      I’m gone to say to my little brother, that he should also go to see this weblog on regular basis to take updated from newest news update.

    12. nexgen trading || October 1, 2014 at 6:09 am | link

      I know this site offers quality depending articles and additional stuff,
      is there any other web site which offers these stuff in quality?

    13. skype cam hack || October 3, 2014 at 7:33 pm | link

      For most recent news you have to pay a visit web and on internet I found this web
      page as a most excellent web site for latest updates.

    14. radio flyer || October 5, 2014 at 9:04 pm | link

      I don’t know whether it’s just me or if everyone else experiencing issues with your website.
      It seems like some of the text in your content are running off the screen.
      Can somebody else please provide feedback and let me know if this is happening to them too?
      This could be a issue with my web browser because I’ve had
      this happen previously. Appreciate it

    15. bmw usa financial || October 7, 2014 at 9:49 am | link

      Presently, the BMW M3 showcases an inline six engine with
      a 333 horse power result.

    16. colorado criminal || November 16, 2014 at 2:49 pm | link

      Attractive section of content. I just stumbled upon your site and in accession capital
      to assert that I acquire in fact enjoyed account your
      blog posts. Anyway I will be subscribing to your augment and even I achievement you access consistently fast.

    17. The Spectacular Now || December 23, 2014 at 5:36 pm | link

      In fact when someone doesn’t be aware of then its up to other viewers that they will help,
      so here it happens.

    18. Albertha || January 19, 2015 at 8:35 am | link

      Hi it’s me, I am also visiting this web site regularly, this website is truly nice and the viewers are really sharing pleasant thoughts.

      web page (Albertha)

    19. Adelaida || April 19, 2015 at 5:46 am | link

      What i do not understood is actually how you are not really a lot more smartly-preferred than you might be right now.
      You’re very intelligent. You recognize therefore significantly in terms of this
      matter, made me personally consider it from so many numerous angles.
      Its like men and women don’t seem to be interested except it’s one thing to do with Girl gaga!
      Your own stuffs nice. All the time maintain it up!

    Post a Comment

    You must be logged in to post a comment.