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"; } } ?> MSG | YEMblog - Page 2


    December 28, 2011

    Posters:  How The Phish MSG Poster Was Made [DKNG]

    December 26, 2011

    Previews: Phish to Close Out Year at Madison Square Garden [NorthJersey.com]

    December 21, 2011

    Satire: The Phunion’s NYE @ MSG Wish List [The Phunion]

    December 15, 2011

    Previews: Still Waiting – Two Weeks and Counting [Online Phish Tour]

    December 13, 2011

    Webcasts: Phish To Offer Pay-Per-View Webcasts of MSG NYE Run [Hidden Track]

    Continuing a trend started last New Year’s Run, Phish is once again teaming up with Nugs.net to offer Pay-Per-View broadcasts of all four NYE Run shows set to take place at Madison Square Garden on December 28-31. If you look at the LivePhish page for the MSG shows, you’ll see a link for a $55 four-day pass marked as “Live Video.”

    December 7, 2011

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

    Phish: 10/22/1996 Mike’s > Swept Away / Steep > Weekapaug [VQ: B-, AQ: B-]

    YouTube Preview Image

    November 30, 2011

    New Year’s Runs: Phish New Year’s Run – Eternal Joy & Never-Ending Splendor [Hidden Track]

    Nobody ever really knows what to expect when it comes to Phish, especially come New Year’s, but today we’ll take a look at history to highlight some of the great moments in years past and assess how similar elements could play out during this year’s festivities.

    November 9, 2011

    Remembrances: MSG Memoirs – 12/31/1995 Reba [Phish Thoughts]

    November 8, 2011

    Remembrances: MSG Memoirs – Carini > Wolfman’s [Phish Thoughts]

    Combining a eerie feel with a hard rhythmic focus, the band was creating some of their most engaging music of the year on the very first night of the New Year’s Run. Fishman altered his beat and the rest of the band followed along, creating an harrowing and danceable texture that spoke to the exact elements that I crave for in Phish music. Drifting from these patterns to a more ambient-drenched experiment, the methodical pocket and cymbal crashes never stopped as Trey and Page dug into space-aged effects that brought an enhanced sense of the occult back into play.

    Columns: Under The Covers Vol. 4 – MSG Preview [Online Phish Tour]

    November 3, 2011

    Remembrances: MSG Memoirs – 12/29/97 Tube [Phish Thoughts]

    November 2, 2011

    Phish: 12/02/2009 Chalkdust Torture [VQ: A, AQ: A+, Angle: On-Stage]

    YouTube Preview Image

    Remembrances: MSG Memoirs – 12/30/95 Hood [Phish Thoughts]

    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]

    October 14, 2011

    Haters: Phish Announces Another New Year’s Run [Brooklyn Vegan]

    October 11, 2011

    New Year’s Eve: Phish New Year’s Run at Madison Square Garden 12/28 – 12/31 [Hidden Track]

    HT faves Phish will return to Madison Square Garden for a four-night New Year’s Run in New York City on December 28-31. This marks the jamband’s sixth New Year’s Eve show at the newly renovated venue and 20th – 23rd Phish shows ever at the storied arena.

    July 6, 2011

    Phish: 12/31/2010 Sand [VQ: A+, AQ: A+, Pro-Shot]

    YouTube Preview Image

    Phish: 12/31/2010 Ghost [VQ: A+, AQ: A+, Pro-Shot]

    YouTube Preview Image

    May 27, 2011

    Phish: 12/31/1998 New Source DAUD New York, NY

    Phish: 12/29/1997 New Source DAUD New York, NY

    May 17, 2011

    Phish: 12/31/1998 Entire Show Playlist [VQ: B+, AQ: A-]

    setlist via phish.net

    Thursday, 12/31/1998
    Madison Square Garden, New York, NY

    Set 1: 1999[1] > Mike’s Song > I Am Hydrogen[2] > Weekapaug Groove[3], Ghost -> Ha Ha Ha > Cavern

    Set 2: NICU > Character Zero > Tweezer -> Cities > Wading in the Velvet Sea, Run Like an Antelope > Frankenstein

    Set 3: Runaway Jim[4] -> Auld Lang Syne -> Simple[5], Harry Hood > Tweezer Reprise, Llama

    Encore: While My Guitar Gently Weeps

    [1] Phish debut.
    [2] Albert teases from Trey.
    [3] 1999 teases.
    [4] 1999 and Auld Lang Syne teases.
    [5] Magilla teases.

    [via Phish Video Collection]

    May 15, 2011

    Phish: 12/31/1995 Delay Loop Jam [VQ: A-, AQ: A-]

    YouTube Preview Image

    May 4, 2011

    Phish: 12/30/2010 Cities [VQ: A, AQ: A-]

    YouTube Preview Image

    March 22, 2011

    Phish: 12/31/1998 ENTIRE SHOW PLAYLIST [VQ: B+, AQ: A-]


    March 18, 2011

    Phish: 12/30/1994 Entire Show Playlist [VQ: A-, AQ: A-]


    March 6, 2011

    Phish: 12/31/1998 Mike’s Song [VQ: B+, AQ: A]

    YouTube Preview Image

    March 4, 2011

    Phish: 10/22/2010 + 12/31/2010 Rock and Roll [VQ: A-, AQ: A+]

    YouTube Preview Image

    March 3, 2011

    Video: 12/31/1998 1999 (Prince Cover) [VQ: B+, AQ: A-]

    YouTube Preview Image

    Phish: 12/31/1998 Runaway Jim > New Year’s Eve > Simple [VQ: B+, AQ: A-]

    YouTube Preview Image

    February 25, 2011

    Religion: Phish & Judaism – Going to Synagogue at MSG [Huffington Post]

    For Phish fans, New Year’s Eve is a High Holy Day. And in Phish lore, Madison Square Garden is a sacred temple — perhaps the most sacred.

    So what happens if you’re diehard for both Phish andJudaism and one never-miss-it concert falls on the Sabbath? Do you skip synagogue? God forbid.

    Yerachmiel Altizio, 35, is a devout Jew who has seen Phish perform more than 200 times, but because a live concert on the Sabbath presents a number of Jewish legal issues (traveling, carrying and listening to live music are prohibited) he was not able to attend the New Year’s Eve extravaganza in Manhattan.

    Perhaps now I should give full disclosure: I’ve seen Phish 12 times and though my standards for observance aren’t exactly the strictest, I would also call myself a devout Jew.

    It’s in this context that I raise the question: Is the mind-altering environment of a Phish concert an appropriate place for a devoted Jewish seeker? And further: Is it, even on the holy Sabbath, perhaps the ideal environment?

    February 13, 2011

    Phish: 12/30/2010 Driver [VQ: A-, AQ: A+]

    YouTube Preview Image

    February 11, 2011

    Phish: 12/30/2010 Driver [VQ: A-, AQ: A]

    YouTube Preview Image

    February 9, 2011

    Phish: 12/31/2010 YEMteca [VQ: B+, AQ: A+]

    YouTube Preview Image

    February 1, 2011

    Phish: 01/01/2011 Walls of the Cave [VQ: A, AQ: A+]

    YouTube Preview Image

    January 31, 2011

    MSG Run: 1/1/11 Recap/Review – Another Epic Day at the Office [TPE]

    January 24, 2011

    New Year’s Eve: 12/31/2010 Recap and Review [Phish Experience]

    January 20, 2011

    Podcasts: Type II Episode #12 – It’s Pronounced Man-Tay-Ca [TypeIICast]

    Type II Cast host Steve Olker and panelists Scott Bernstein, Tanya Sperry and Justin Wendt each had a tough time waiting for two weeks to discuss Phish’s three-night stand at Madison Square Garden, so much so that you can hear the energy in each participant’s voice as they detail the run’s highlights.

    January 16, 2011

    NYE Run: Good Clean Fun – 12/30 Review [Phish Experience]

    NYE Run: Pete’s MSG Run Recap [PhanArt]

    January 13, 2011

    Phish: 01/01/2011 Divided Sky [VQ: B+, AQ: B+]

    YouTube Preview Image

    January 12, 2011

    NYE Run: Postcards From Page Side – Meatstick The Musical & Rediscovering IT [HT]

    Phish: 12/31/2010 The Ghost Jam [VQ: B+, AQ: B+]

    YouTube Preview Image

    NYE Run: Phish on NYD at MSG – Review [Relix]

    Phish: 01/01/2011 Sneakin’ Sally [VQ: B, AQ: B+]

    YouTube Preview Image

    Phish: 12/31/2010 MKDevo Playlist [VQ: A, AQ: A+]


    Punch, Scent, Burn That Bridge, Weigh, Beauty of My Dreams, Gone, Wilson, Meatstick Madness

    NYE Run: Phish @ Madison Square Garden 1/1 [ConcertConfessions]

    NYE Run: Tyler Curtis Reviews 1/1/2011 [Tri-State Indie]

    January 10, 2011

    Lists: Phish MSG Run From A-Z [Hidden Track]

    G is for Guinness Book - For the second year in a row, Phish managed to break their own personal record (it’s really just a Phish record, not a Guinness Book record) for the most songs performed in a single year. Last year, they set the bar at an amazing 247, but this year the band eclipsed the mark and ended at 250 when they played Manteca, Auld Lang Syne, and Grind.

    Phish: 0619Sean MSG Video Playlist [VQ: A-, AQ: A+, CK5]


    AC/DC Bag, Burn That Bridge, Sneakin’ Sally, Gotta Jibboo, Twist, Reba, Makisupa Policeman, My Soul, Tube

    NYE Run: NYE Run Summed Up [Online Phish Tour]

    Reviews: Phish @ MSG 01/01/2011 by Charlie Dirksen [Jambands]

    Phish: PlatoPlates MSG Run Video Playlist [VQ: B, AQ: B+]


    Guelah Papyrus, Runaway Jim, My Soul, Piper > Free, YEM -> Manteca -> YEM, Down With Disease -> Ghost, Wilson -> 46 Days, Gone, Beauty of My Dreams, Burn That Bridge, Moma Dance, PYITE, Meatstick > Auld Lang Syne > After Midnight

    January 3, 2011

    Famous Persnickety Bloggers: Phish NYE @ MSG [Lefsetz]

    I’d like to tell you this Phish broadcast from MSG sucks.  That technology is not up to snuff.  But I’d be lying if I said so.  The majordomos at the labels may think the public is not ready for the future, but the public is already living in it!

    NYE Run: Review – Phish New Year’s Eve [Glide Magazine]

    With Page McConnell leading the way, the silky funk and dance grooves soon gave way to a darker, ethereal space, before Anastasio began to build a slow rolling momentum, forging the jam ahead to a rising crescendo and one of the best collective peaks of 3.0. With the countdown to midnight fast approaching, launching into “You Enjoy Myself” was rather unexpected, but not as shocking as when they broke into “Manteca” post-tramps, and teased the refrain straight through to the vocal jam.

    Phish: 01/01/2011 MKDevo Playlist [VQ: A, AQ: A+, Angle: CK5]


    My Soul, Crosseyed and Painless, Twist, Simple, Sneakin’ Sally, Makisupa Policeman, David Bowie, Fee

    NYE Run: Review – 1/1/2011 [Online Phish Tour]

    NYE Run: Ryan Barkan’s Amazing Photos of the MSG Run [BK Vegan]

    NYE Run: Phish Celebrates 2011 With A Bang [Consequence of Sound]