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

    Tickets RSS

    May 20, 2012

    Mimi Fishman Foundation and Waterwheel Foundation: Late Summer Tour Packages

    March 21, 2012

    Trey: Hands On a Hardbody Ticketing News [La Jolla Playhouse]

    Hands On A Hardbody, the new musical by Pulitzer Prize winner Doug Wright with music by Trey Anastasio and Amanda Green, will debut April 27, 2012 at La Jolla Playhouse in La Jolla, CA and run through June 17, 2012. Beginning now (and through the next 72 hours), tickets for the first two weekends of the run, April 29 and May 4-6, will be available at a special introductory price of $30 with code TRUCK2779. All other performance dates will receive a 20% discount through April 8 with code FAN5752.

    December 7, 2011

    Tickets: Phish Announced MSG Re-Release Minutes Before It Happened [HT]

    December 4, 2011

    Editorials: Scalping Everywhere by ZZYZX [Jambands.com]

    October 29, 2011

    MSG Tickets: Poll – How Did You Do? Did You Score Phish Tickets? [Hidden Track]

    October 26, 2011

    How Did You Do?: Survey and Open Thread – Phish MSG NYE Tickets [Hidden Track]

    September 10, 2011

    Essex Junction: Phish Fans Finally Score Tickets After Waiting Overnight [Burlington Free Press]

    September 9, 2011

    Vermont Flood Benefit: Full Ticketing Information for Flynn Sales [Phish.com]

    Vermont Flood Benefit: Phish Fans Ignore Request, Start Lining Up For Tickets [Burlington Free Press]

    September 8, 2011

    Vermont Flood Benefit: Waterwheel Ticket Auctions for Essex Jct. [Mimi Fishman Foundation]

    September 6, 2011

    Flood-Aid: Phish @ Champlain Valley Expo – September 14 [Hidden Track]

    June 17, 2011

    Tickets: Top Venues to See Phish Play This Summer [Seat Geek]

    May 27, 2011

    Bethel: Phish Sells Out All Three Shows [RecordOnline]

    May 15, 2011

    Mail Order Tickets: Summer Ticket Designs Released [Online Phish Tour]

    April 15, 2011

    Auctions: Mimi Fishman and WaterWheel Summer Ticket Packages [MimiFishmanFoundation]

    April 1, 2011

    Contests: Win a Pair of Camden Pavilion Tickets [Hidden Track]

    March 11, 2011

    Discussion: Do You Score Phish Tickets Today? [Hidden Track]

    March 7, 2011

    Mail Order: A Survey of Phish Tickets By Mail Results [Hidden Track]

    February 4, 2011

    Contests: Win Trey/Mike Tickets [CashOrTrade.org]

    December 22, 2010

    Tickets: Phish Returns to MSG – Price Evaluation [SeatGeek]

    November 24, 2010

    Charities: Auction For Phish NYE Tickets + More [Mimi Fishman]

    October 9, 2010

    Tickets: Open Thread – Did You Score Phish Tickets [Hidden Track]

    October 5, 2010

    Tickets: Open Thread – Did You Score Phish Tickets [Hidden Track]

    September 29, 2010

    Fourmile Benefit: Fourmile Benefit Tickets up to $300 on eBay [Daily Camera]

    September 15, 2010

    Broomfield: Paperless Tickets Follow Up [Phish.net]

    September 10, 2010

    Utica: Phish Concert Sells Out in 18 Minutes [UticaOD]

    Tickets for the highly-anticipated Phish show coming to the Utica Memorial Auditorium Oct. 20, sold out in 18 minutes Friday, Aud officials said.

    About 75 dedicated Phish fans lined up in front of the auditorium Friday. A handful of those fans camped overnight in front of the venue.

    Twenty-eight-year-old Brandon Shorey, of Clinton, refused to miss his opportunity of purchasing tickets. He planted himself in front of the Aud’s entrance at 2 p.m. Thursday.

    August 30, 2010

    Tickets: I Can’t Describe The Feeling When… [JiggsLot]

    August 10, 2010

    Telluride: Hook, Line… – Tickets Situation [Daily Planet]

    July 30, 2010

    Tickets: CashOrTrade.org Reaches 10,000 Trades [CashOrTrade]

    CashorTrade.org has reached over 10,000 trades, 5500 members, 1000 facebook friends, and now a growing community on Twitter. CashorTrade.org is a ticket trading website that helps fans obtain tickets at Face Value for cash or trade.  Since the company’s inception in February 2009, shortly after the band Phish made its come back after a 5 year hiatus, CashorTrade has been the leading ticket trading website  supporting the face value buying, selling and trading of tickets. Creators Dusty and Brando would like to say THANK YOU to all who EMBRACE THE FACE!

    June 2, 2010

    Tickets: Phish Tour Starts Soon, Mailorders Arriving [Live Music Blog]

    May 31, 2010

    Tickets: Time to Revisit PTBM Shipping Policies [PhishNet]

    May 7, 2010

    Telluride: Tickets For Locals Sell Out [Daily Planet]

    May 5, 2010

    Telluride: Tickets For Locals Still Available [Daily Planet]

    April 28, 2010

    Tickets: 16 Phish Dates Still Not Sold Out [OnlinePhishTour]

    It is clear ticket sales are slowly dwindling for Phish.  Last summer Phish sold out all their venues, including both nights at the massive Alpine Valley within hours if not minutes.  The only venue that didn’t sell out the same day was Toyota Park–which eventually did sell out.

    The fact that the northeastern venues are not sold out yet is an eye opening fact.  If they can’t sell out in the northeast, where can they anymore?  CMAC, both a special and very cool venue in NY, couldn’t sell out, along with the Phish summer staple, Walnut Creek.  Deer Creek, a must hit stop for any serious Phish fan on a summer tour, didn’t sell out either.  This is all shocking, I’m not sure what to make of it.

    April 16, 2010

    Want to Buy, Sell or Trade Tickets With Other Phans? Head to CashOrTrade.org

    April 9, 2010

    Lists: 10 Toughest Phish Tickets Ever [Hidden Track]

    9. Providence ‘98 [4/4-5/98] – With Phish coming out of hibernation to play four shows known as the “Island Tour” in April ‘98 demand was intense. The shows were all within striking distance of most Northeast-based Phish fans and everybody wanted to see all four. While I had a few friends who found Nassau tickets, it seemed that tickets to the Providence shows were much harder to score. It was a sad scene in the parking garage on the 5th as hundreds of fans did laps with their fingers in the air.

    Buy, Sell or Trade Phish Tickets Within The Community at CashOrTrade.org

    April 6, 2010

    Tickets: Tickets to Portsmouth Show Snatched Quickly [DailyPress]

    April 5, 2010

    Telluride: The Agony and Ecstasy of the Phish Line [DailyPlanet]

    Opinions: Phish Ticket Time (The Entitlements of None) [Phish&theDead]

    Telluride: Party Breaks Out Waiting For Phish Tickets [TelluridePhotography]

    April 1, 2010

    Public Onsale Information For Summer Tour

    Saturday (April 3):

    10AM (EDT): HersheyRaleigh, Noblesville1, Noblesville2,
    11AM (EDT): Alpine1, Alpine2, Charlotte,
    1PM (EDT): Cuyahoga Falls, Alpharetta1, Alpharetta2,

    Note: Clicking on the links to Ticketmaster above credits YEMblog with a commission at no cost to the purchaser. If you appreciate what we do and want to support the sites, please use the links above to get to Ticketmaster.

    March 30, 2010

    Tickets: The Ticket Lottery [Phish Thoughts]

    March 26, 2010

    Telluride: Phish Tickets Q&A [Daily Planet]

    Q: Can I buy a ticket for my friend who lives somewhere else?

    A: No. Only locals get tickets.

    Q: Who is considered a local?

    A: Anybody who lives in San Miguel County.

    Q: What if I live near here, in Montrose, Ridgway, Rico, Nucla or Naturita?

    A: Not good enough. You must live in San Miguel County.

    March 24, 2010

    Tickets: Phish Tickets By Mail vs. Public Onsales [OnlinePhishTour]

    March 23, 2010

    Tickets: Tickets to Telluride [Phish Thoughts]

    March 18, 2010

    Tickets: Phish Maintains Zero Tolerance Policy Towards Scalpers [TN]

    March 16, 2010

    Summer Tour: Tickets, Dates, Info [Jamtopia]

    The 18 show early Summer leg finds Phish at 13 venues in the Midwest, East Coast, and South East including Blossom Music Center (141 shows), Hersheypark Stadium (143 shows), nTelos Wireless Pavilion in Portsmouth, VA (first-time), Finger Lakes Performing Arts Center (551 shows) and Walnut Creek (90 shows). The leg culminates on July 3rd & 4th at Verizon Wireless Amphitheatre at Encore Park in Alpharetta, GA (first-time).

    The 11 show late Summer leg goes from coast-to-coast at 5 different venues — starting off at the Greek Theatre in Berkely (696 shows) and ending at Jones Beach. This leg also includes two nights at the afore mentioned Town Park in Telluride as well as Deer Creek and Alpine Valley.

    December 15, 2009

    Tickets: Designing Phish’s Fall Tour 2009 Tickets [Adam+Company]

    December 10, 2009

    Tickets: 2009 StubHub Concert Report [NewsBlaze]

    Head to the YEMblog Facebook Page (are you a fan of YEMblog yet?!?!) for ScottyB’s analysis of StubHub’s report.

    October 27, 2009

    Tickets: Phish Scores Fastest Sell Out in Portland History [Maine News]

    It was the fastest sell-out in the civic center’s history, according to the facility’s general manager, Steve Crane.

    More than 500 fans arrived at the civic center shortly after dawn Saturday, in the rain, waiting for the ticket office to open at 9 a.m. The show will be the first Portland appearance by Phish since 1999.

    October 25, 2009

    Tickets: Phish Quickly Selling Out Fall Tour [Spinner]

    October 23, 2009

    Survey: Fall Tour 2009 Phish Tickets Poll [Hidden Track]

    Polls: Phish Public Onsale Survey [Hidden Track]

    Visit Hidden Track to fill out our survey on whether you scored tickets through today’s public on sales.

    Syracuse: Loyal Fans Lineup Early to Go Phishing [Syracuse.com]

    October 21, 2009

    Polls: Tell HT How You Did on Your Phish Fall Tour Ticket Orders [Hidden Track]

    May 30, 2009

    Tickets: Mailorder Art Revealed [Live Music Blog]

    May 18, 2009

    Tickets: Suit – Something Phish-y Goin’ On [Boston Herald]

    A Massachusetts man has filed a proposed class-action lawsuit accusing Ticketmaster of fraud for allegedly redirecting him and others in search of concert tickets to its higher-priced resale site.

    May 12, 2009

    Tickets: Phish Ticket Bubble Report [Coventry]

    Editorial: A Word On Tickets [Angry Head]