Plugin Name: Brian's Latest Comments
Plugin URI: http://meidell.dk/archives/category/wordpress/latest-comments/
Description: This shows an overview of the recently active articles and the last people to comment on them. Original idea and code fixes contributed by 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")
function clamp($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.
$ping = "";
$ping = "AND comment_type<>'pingback' AND comment_type<>'trackback'";
$posts = $wpdb->get_results("SELECT
FROM ($wpdb->comments LEFT JOIN $wpdb->posts ON (comment_post_ID = ID))
WHERE comment_approved = '1'
ORDER BY comment_date DESC;");
$seen = array();
$num = 0;
$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.
$seen[$post->comment_post_ID] = true;
if($num++ > $num_posts)
$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."'
ORDER BY comment_date DESC
$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);
$title = " title=\"Last comment was ".time_since($comment->unixdate)." ago\"";
$title = "";
echo $prefix."".stripslashes($post->post_title). "".$count." \n";
foreach($commenters as $commenter)
$title = " title=\"Posted ".time_since($commenter->unixdate)." ago\"";
$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 ", ";
if($count > $num_comments)
echo " [...]";
Lists | YEMblog
Since the scene at Zuccotti got busted up, Occupy protesters have been in need of a place to converge, play drums, mingle, eat vegan food and make cardboard signs. They are going to love Phish a lot! In contrast to Occupy encampments, drugs and alcohol are not prohibited on Phish lot — regardless of what “the man” says — so it’ll be a great chance for the 99 percent to really get down together, which may be a healthy thing for the movement.
6) Digital Cameras: The gag with Brad Sands intentionally cutting the heads off of fans seeking photos with the band members would never fly in the binary world. Since Bittersweet Motel, not only have we lived through the popularization of digital cameras, but now the majority of concertgoers have one on their phone.
7/19-21/1998 (Audio in compilation: 7/19 Ghost, Limb, YEM; 7/20 Gin, Drowned, Makisupa, Halley’s; 7/21 Ghost, She Caught the Katy)
Summer ‘98 is often brushed off by vets that claim it’s the year of gimmicky covers and ambient jams. However, I argue that July of ‘98 is one of the best months of Phish ever. They take the funk from ‘97, only now it’s cleaned up and mature.
Everyone already knows about the crazy Gorge ‘98 shows (and the recordings are not bad), so let’s go to the following nights that have been overshadowed, starting with 7/19 at Shoreline and finishing with 7/21 at Desert Sky.
Most tunes written at the beginning of Phish’s career were penned by Anastasio, so when bassist Mike Gordon brought a song to the band they simply called it “Mike Wrote That” or “Microdot.” Trey announced this original title from stage on October 17, 1985 and at some point shortly after that the title morphed to Mike’s Song. The rest, as they say, is history.
Leading up to the first leg, we were perplexed by the lack of 2.0 opuses in the setlists since Hampton. One of the biggest tragedies of Phish breaking up when they did is that we never got to see A Song I Heard The Ocean Sing, Scents and Subtle Sounds and Waves develop. Thankfully, all three tunes were brought back during the first leg and we have high hopes that they will find their way into setlists this month.
1. There are plenty of ways to avoid Phish.
Doubtless, some of you will be seeking to actually catch Phish (ha!) — and to you, well, godspeed. But those of us who require a minimum 200-yard distance from any jam bands are well served by Friday’s schedule, which offers such enticements as Big Boi, Erykah Badu, Best Coast, the Shins, and Big Audio Dynamite, all while Phish noodles on the main stage for more than three hours.
There was no greater news to New England in the winter of 2009 than the word that Phish was getting back together for a three-night run at the Hampton Coliseum. What started out as three (very thorough) reunion shows turned into the next leg of the Vermont quartet’s career, and they kicked everything off with “Fluffhead”.
Vultures – 6/11 Merriweather Post – This song has never gotten its due. Overshadowed by the rest of the tunes that would make up The Story of the Ghost, there have been moments where I felt this song was geared to make a big comeback… but it’s just never cracked the rotation. I’m not sure why that it is. This song has everything a Phish song should, strange rhythms, bizarre lyrics, and some peaks that will make you pump your fist. Here’s hoping Vultures gets better setlist treatment in the future. Unfortunately, if it hasn’t happened yet… it’s probably not happening.
K is for Keep Halfway to the Moon Around – Outside of Show of Life Phish has ignored all of the originals they debuted in 2010 so far this summer until Sunday when they finally played Page’s Halfway to the Moon again. Let’s hope we don’t have to wait another 23 shows for the next one.
2. Twelve Minute Kill Devil Falls, Anyone?: What if I told you that Fluffhead and Weekapaug would be two of the worst played tunes of the weekend, that there would be no YEM, Reba, Ghost or Divided Sky…but the shows would still contain some of the best jamming of 3.0? KDF, BOTT, BDTNL and, of course, a resurgent Halley’s were just a few songs that were stretched way past the norm. The band has apparently put some conscious effort into revitalizing their communication and creativity on stage, and the result is that now anything can truly happen in any song. Considering this is a trend that has carried over from the end of last tour, don’t expect if to go anywhere soon.
Over the course of Hidden Track’s lifespan, we’ve taken a couple different stabs at making a list of favorite Hoods, and it felt like a good time for the next iteration. It will remain a perpetual work in progress as the band plays new renditions and old gems get discovered, but nevertheless, it’s coming along. This time, we have a meticulously organized, iPod-ready downloadfor your enjoyment as well as a stream at the bottom of the post. While these are mostly audience recordings or soundboards that are not part of official releases, but we tried to normalize the levels and made sure the volume is plenty loud. Without further ado, here is the list…
We’ve been taking a trip down memory lane as we revisited all of the audio from the Trey ’99 tour and one constant I found was that while everyone knows that Sand, First Tube, Gotta Jibboo etc. came from this tour, a lot of people forget that there were two electric performances of Bug in ’99 before it hit the Phish stage. Hear the first one and Trey describing the songwriting experience with Tom.
Given this context, I set out to compile a list of shows (and multi-night stands) that roughly document the various stages of Phish, their sound and their emergence as a cultural phenomenon. It should be noted that the list is not intended to be a “best of.” Rather, it’s a guide for those that love the band and want to revisit key moments in Phistory.
Merriweather’s second show represented the peak of Phish’s most impressive weekend of Leg I. Completing a four-night stand that started in Camden, the band punctuated their Mid-Atlantic run with a thematic second set. Responding to a sign for “Saw It Again,” Trey chopped into the song amidst the liquid funk of “Meatstick,” and initiated a wild second set in which the band wove lyrical teases of “Saw It Again” in each subsequent song, capping the night with the the unforgettable—”Boy. Man. I Saw It Again!” And smack dab in the middle of this musical trickery was a centerpiece of “Piper,” one of the outstanding excursions of June. Throw in a rocking jaunt of “Ghost > Jumping Jack Flash” and solid first set, and you’ve got yourself a nice little Phish show.
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.
5. Phish, Aug. 5 (first night of 3), Greek Theatre, UC Berkeley: Phans, the Phish equivalent to the Deadheads, will be talking about the band’s three-night Berkeley run for years to come (at least those who could get in — tickets for all three nights sold out in a heartbeat). Phish has no problem selling out 20,000-plus-seat amphitheaters, so part of the appeal was to see them in a comparatively intimate 8,500-capacity building. The group, led by guitar god Trey Anastasio, was in top form throughout the stand, but opening night delivered the most oomph.
There wasn’t much in the way of audio-only archival releases from Phish in 2010, but the group did put out the magnificent Fall Tour ’92 opener from St. Mike’s to help raise money for Haitian Earthquake Victims. This performance featured the first-ever versions of Axilla, I Walk The Line (Johnny Cash cover), Big Ball Jam, Fast Enough For You and Lengthwise. Longtime Phish friend Gordon Stone joined the band on pedal steel for Poor Heart, Fast Enough For You and Llama and the release also includes fantastic versions of Divided Sky and Mike’s Song.