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"; } } ?> Desert Sun | YEMblog

    Desert Sun RSS

    May 25, 2010

    Indio: No Phish Fest at Empire Polo Club [Desert Sun]

    Despite statements to the contrary by Phish phans, Goldenvoice says there won’t be a Phish festival this October at the Empire Polo Club.

    Promoter Paul Tollett said he won’t produce any more festivals in Indio in 2010. Polo club owner Alex Haagen III is still talking about having a fall jazz, blues and rock ‘n’ roll festival and says he may hire another promoter. But he said, “We don’t have anything lined up yet.”

    May 4, 2010

    Phish 3D: Phans Take to Film Like Phish to Water [Desert Sun]

    November 3, 2009

    Festival 8: Indio Concert Latest in Phish Legacy [Desert Sun]

    Phish drew between 35,000 and 40,000 people a day to its first solo festival west of the Mississippi. That’s less than the 85,000 people a day who came to its Big Cypress festival in south Florida in 1999, or the 60,000 who attended the It fest in Maine in 2003. But that’s because Phish is an East Coast band.

    And Phish fans are the kind of people this desert should want to have back.

    November 2, 2009

    Festival 8: Phunky Females Go Phishin [Desert Sun]

    Festival 8: Acoustic Set Hooks Phans [Desert Sun]

    On a hot fall afternoon, Phish warmed their fans’ hearts with a mellow set of music and a side of doughnuts.

    The band performed its first acoustic set at any of its eight solo music festivals during the past two decades. And that was one of several firsts for the Vermont jam band.

    Festival 8: Band Hopes to Do It Again [Desert Sun]

    Before the band’s last encore of the festival, lead singer/guitarist Trey Anastasio made sure to thank the crowd for a “wonderful weekend.” He even had a list of shout-outs.

    “I just wanted to make a point that it takes a whole mountain of people to make something like this happen,” Anastasio said. “I hope we can do it again.”

    And though Deitrich and many others were sad to see Festival 8 come to an end — with an encore of “Tweezer Reprise,” they seemed all content with simply having the memories .

    At least until the next concert.

    November 1, 2009

    Festival 8: Phish Plays Halloween Set to 40,000 + [Desert Sun]

    The band’s publicist Erin Cooney said at least 40,000 people attended the event at the Empire Polo Club in Indio and a large percentage of them showed up in costumes as elaborate as a team mascot or as simple as a box over shoulders.

    The Vermont-based quartet celebrated the holiday with “a musical costume,” teasing Phish fans with the opening strains of Michael Jackson’s “Thriller” before segueing into a video remix of the 99 albums it had hinted at performing on its Web site. They then launched into the Rolling Stones’ classic 1972 double album, “Exile On Main St.,” supplemented by a horn section.

    Many of the young Phish fans hadn’t heard of “Exile” before the 7:30 p.m. set.

    Festival 8: Foodies Delight in Festival’s Varied Fare [Desert Sun]

    “Phish is isn’t like your typical band,” Parker Roe said. “They like to nourish their fans. And the food is amazing — huge, big, delicious. I’m thinking of a traditional gyro.”

    Roe was right. While the usual suspects line the three food areas, almost all offer a vegetarian or vegan option.

    Jackalope Ranch of Indio has a Phish taco on its menu; mahi-mahi with shredded cabbage, tomatillo and red salsa.

    Festival 8: Phans – Anything Goes on Halloween [Desert Sun]

    Festival 8: Notebook Day 2 [Desert Sun]

    Costume crisis

    On Friday night someone stole Sierra Buck’s backpack with her costume in it. Sierra is 4-years-old and was planning to be a “disco baby” to her mothers “disco diva.”

    Everyone knows that kids love to dress up, so to steal a backpack with a kid’s costume in it is pretty much unforgivable.

    Luckily, the vendors came to the rescue. After being told what happened, one vendor gave the Bucks a discount on a new costume for Sierra and painted her young face for free.

    October 31, 2009

    Festival 8: Art, Ferris Wheel and — Waffles [Desert Sun]

    Festival 8: More Than Just Music, F8 is a Feast For The Eyes [Desert Sun]

    Festival 8: Phish Fans Sing Praises of Indio Site [Desert Sun]

    The creatively lit palm trees and installation art throughout the vast expanse of green grass had fans from all over North America in awe of the eye-popping setting in Indio. The pleasant weather and relatively easy access to the polo club had concert-goers who had attended many or all of the previous seven Phish festivals east of the Mississippi gushing about “Phish Fest West.”“This is the most beautiful place that they could have hosted this event,” said Jay Young of Las Vegas, whose hometown was Indio’s main rival for this eighth festival in 13 years. “Having been to all of them but (the 2003 It festival at the Loring Air Force Base in Maine), this place feels like this is what they were going for the past seven times.”

    Festival 8: Phish Aims to Set Standard For Green Concerts [Desert Sun]

    Charities: Schools Benefit From Phish Fans [Desert Sun]

    Festival 8: Day One Review – Phish Offers Tasty Treat [Desert Sun]

    To this novice Phish phan, Friday’s opening set showed how polished they’ve become. They played three songs from their new album, “Joy,” which many critics have called their best album ever, including “Time Turns Elastic,” which some critics have called Phish’s equivalent of the Dead’s “Terrapin Station.” It has so many unique components, like “Terrapin,” it’s almost a suite. That makes it a difficult song to expand upon in a jam because its growth is built into its structure. But, it was a treat to hear them perform the song expertly even if it didn’t improve significantly on the recording.

    October 30, 2009

    Festival 8: Tips For Surviving The Phish Festival [Desert Sun]

    Festival 8: Talk the Phish Talk, Walk The Phish Walk [Desert Sun]

    Festival 8: A Guide to Phish-Speak [Desert Sun]

    October 29, 2009

    Festival 8: Area Hotels Hook Phish Fans [Desert Sun]

    Festival 8: What You Need to Know [Desert Sun]