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"; } } ?> Contests: Win One of Six Copies of Phish’s Coral Sky from YEMblog | YEMblog

    Contests: Win One of Six Copies of Phish’s Coral Sky from YEMblog

    We’re giving away six copies of Phish’s Coral Sky 2-DVD set courtesy of Phish Inc. To enter leave a comment on this post or on our Facebook Page picking five songs you think Phish will play at Austin City Limits as well as the number of songs you think they’ll cram into their set for a tiebreaker. All entries must be left by 8PM ET on 10/08. Anyone found entering more than once will be disqualified.

    44 Comments so far      Post a Comment

    1. YEM
      Ocelot
      Down with Disease
      Suzy Greenberg
      Moma Dance

      14 songs total

    2. Chalkdust Torture
      Wilson
      Ocelot
      Tweezer
      Tweezer Reprise

      16 songs

    3. down with disease
      chalkdust torture
      back on the train
      golgi apparatus
      free

    4. DWD
      Poor Heart
      Possum
      Ocelot
      Golgi

      15 songs

    5. Wolfmans Brother
      Chalkdust Torture
      Wilson
      Backwards Down The Numberline
      Run LIke An Antelope

    6. YEM
      Wolfmans Brother
      Backwards Down the Number Line
      Possum
      Ocelot
      16 songs

    7. Wolfmans Brother
      Chalkdust Torture
      Wilson
      Backwards Down The Numberline
      Run LIke An Antelope

      17 Songs

    8. YEM
      Divided Sky
      AC/DC Bag
      Mike’s Song
      Weekapaug Groove
      Backwards Down the # Line

    9. Poor Heart
      Paul and Silas
      Divided Sky
      Back on Train
      Number Line

      14

    10. AC/DC Bag
      Possum
      Wolfman’s Brother
      Kill Devil Falls
      DWD

      15 songs

    11. YEM
      Chalkdust Torture
      number line
      possum
      Antelope

      19 songs

    12. Tweezer
      Stealing Time From the Faulty Plan
      Julius
      Run Like an Antelope
      Tweezer Reprise

      17 songs

    13. Chalkdust
      Backwards Down the Numberline
      Tweezer
      Tweezer Reprise
      Wilson

      14 songs

    14. ac/dc
      divided sky
      ocelot
      chalkdust
      BDTNL
      15 songs

    15. Backwards
      Quinn
      Curtis Lowe
      Paul and Silus
      Anletope

    16. Backwards Down the Number Line
      AC/DC Bag
      Chalkdust Torture
      Wilson
      Bouncing Around the Room

      Tiebreaker (16 in set + 2 encores = 18 total)

    17. Chalkdust Torture
      David Bowie
      Backwards Down the Numberline
      Ocelot
      Kill Devil Falls

    18. Ocelot
      Backwards Down the Number Line
      Tweezer
      Down with Disease
      Ginseng Sullivan

      14 songs

    19. Chalkdust
      Stash
      Ocelot
      Possum
      Suzie Greenburg

      Tiebreaker – 16 song set + 1 song encore =17 songs

    20. DWD
      Light
      Chalkdust
      Number Line
      YEM

      20 songs

    21. Stash
      Ocelot
      Bathtub Gin
      Possum
      Down With Disease

    22. Wolfmans Brother
      Ocelot
      YEM
      BDTNL
      David Bowie

      16 Songs total

    23. 5 Songs:
      Tweezer
      BDTNL
      Chalkdust
      Tweeprise
      2001

      Tiebreaker: 15 songs + 2 encore

    24. Chalkdust Torture
      2001
      Stealing Time from the Faulty Plan
      Tweezer
      Tweezer Reprise

      15 Songs

    25. Down With Disease
      Kill Devil Falls
      Loving Cup
      Moma Dance
      First Tube

      16 songs

    26. Kill Devil Falls
      Moma Dance
      Down With Disease
      Guyute
      First Tube

      14 songs

    27. Disregard my first post….didn’t think it went through…sorry

    28. Alaska
      Wolfman’s Brother
      ACDC Bag
      Stealing Time from the Faulty Plan
      llama

    29. 17 songs

    30. down with disease
      chalkdust torture
      kill devil falls
      stash
      sample in a jar
      *15 songs*

    31. 2001
      Light
      Tweezer
      Tweezer Reprise
      Harry Hood

      18

    32. Chalk Dust Torture
      Divided Sky
      Also Sprach Zarathustra
      Possum
      BDTNL

      18 songs

    33. Kill Devil Falls
      Down With Disease
      Possum
      Light
      Alaska

      17 songs

    34. Le grange!!
      Reba
      Hood
      Number Line
      ocelot

      18 songs total

    35. Bug
      Golgi
      Sample in a Jar
      Rock n Roll
      Number Line
      15 songs

    36. kill devil falls
      down with disease
      burn that bridge
      first tube
      backwards down then number line

      15 songs

    37. Wolfman’s Brother
      Alaska
      Kill Devil Falls
      Cavern
      Down With Disease

      16 songs

    38. YEM
      Kill Devil Falls
      Chalk Dust
      Joy
      Divided Sky

    39. whoops….17 songs

    40. ocelot
      hood
      guyute
      twist
      piper
      16

    41. YEM
      Ocelot
      Down With Disease
      Light
      Run Like an Antelope

      19 songs

    42. DWD
      Ocelot
      Sample
      Hood
      Possum

      17 songs

    43. Light
      Possum
      Ocelot
      Wolfmans
      Sample in Jar

      15 songs

    44. Instant Karma
      You Enjoy Myself
      Ocelot
      Kill Devil Falls
      Burn That Bridge

      15 songs

    Post a Comment

    You must be logged in to post a comment.