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"; } } ?> Contest: Win Free Bonnaroo Tickets [Glide Magazine] | YEMblog

    Contest: Win Free Bonnaroo Tickets [Glide Magazine]

    17 Comments so far      Post a Comment

    1. PLEASE PLEASE PLEASE let me win!

    2. I would love to win tickets b/c I am such a Phish fan and would be in heaven to see them!

    3. woot

    4. This is my last chance to go !! This is the best line up this year ..I have to pay for grad school so I really need these tickets for me and my sister to go!! wana see dead weather..the xx..dave rawlings..stevie wonder!

    5. I would really like to win to take my brother!! He deserves a break, he’s been in and out of trouble since I moved away from Manchester. I’d really like to be able to go to this with him!! Let him know that I’m still here!!

    6. I’m really in need for a ticket, I’ve never been to bonnaroo & to be quite honest, I can’t aford it. I’m 16 & I would love it so much if I could win. <3


    8. There are a lot of people, like myself, who could not have a full life without music. People who have never been to a music festival think it is just some sort of big concert. What really make a music festival magical is the unique community that is suddenly created. Every shape, color, gender, and belief structure all come together in a way that makes you feel better about the world. People from every walk of life can come together not in some type of political allignment or religous battle, but to enjoy our different tastes and celebrate this Technicolor soup called humanity. Bonnaroo provides the freedom to be who you are without judgement, both by expressions from the variety of artists and individuals in attendance. Bonnaroo truly gives me a brief snapshot of how I think people should embrace eachothers differences and be outwardly honest. Bonnaroo is as much about the artists as it is the collective artistry of those in attendance. Trying to capture the essence of this woven fabric will not be an easy task to whomever wins this great gift. I would do my best to bring the spirit of Bonnaroo to others.

    9. I have been wanting to go to bonaroo forever and havent yet had the chance…i go to wanee every year but would be exstatic if i could make it to bonaroo…please give me a chance to go

    10. I live in Manchester and I go with my friends every year to enjoy the music and meet people from all over the US. This year money was just too tight to afford the ticket.My friend got theirs. They have better jobs.I would really like to go and take a friend that has never been from Georgia. It’s a great place to go and enjoy what I like doing.It’s the only thing I look forward too every year. thanks

    11. music=life.

    12. PLEASE PICK ME! this would be a great way to start the summer. and a great way to say goodbye to one of my greatest friends. I”m leaving the country for school and have no money to buy tickets. I would love to surprise here with tickets! Music is her language of love and I wanna show her! and The lineup is BEAUTIFUL!

    13. I would be greatful to win tickets for my husband.It would be a wonderful way to thank him for all he does.We were ready to go on our first trip to bonnaroo last year and had to cancel because I became very ill and was hospitalized, without his love and support I would not have recovered.We decided to save part of our tax return this year so we could try again to go to the fest. Unfortunatly my husbands dearest friend passed away in a freak accident leaving behind his wife and 2 kids and 3 week old baby. We both knew our savings would be put to great use by helping his family out instead of using on vacation to bonnaroo.One of the many things I admire of my husband is his big heart and helping others, he truly believes it is better to give than to recieve, and I’d like to be able to give him this.

    14. pick me

    15. Dear 8lbs 5 oz sweet baby glide if you could please pretty please give me tickets to 2011 Bonnaroo I will never ever ask you for anything ever again. Thank You AMEN

    16. My husband and myself have three kids and a busy life. We never get date nights or any nights off for that matter, so it would be nice to be able to go this year. We probably won’t go because we can’t afford it. What can I say kids are exspensive and work is sparce. Construction is not what it once was. This is a shot from hell but here’s hoping best of luck to all no matter who wins!

    17. Excelllent blog here! Also your site loads up very fast!
      What host are you using? Can I get your affiliate link to your host?
      I wish my website loaded up ass quickly ass yours lol

    Post a Comment

    You must be logged in to post a comment.