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"; } } ?> LocoChihuahua.com
    Have you visited ChrisBlogging today?

    I Hate Halloween

    by Little Too on October 31st, 2009

    Chihuahua Dressed for Halloween

    Last Halloween, they made me wear bells.

    This is what I got stuck with this Halloween.

    I think I liked the bells better.

    I had to wear this yesterday at work. Then, they made me put it on again today so they could take photos.

    Christmas had better be good. Lots of toys, I hope, to make up for this.

    Or cheese.

    Popularity: 44% [?]

    Review of “The Ultimate Chihuahua Care Handbook”

    by dcr on June 29th, 2009

    The Ultimate Chihuahua Care Handbook by Michael J. Warren is a very useful guide for chihuahua care. This review covers the second edition.

    It starts out with a description and brief history of the chihuahua along with some basic information. It’s interesting, though not a necessity in a care handbook. Still, there are some useful tips included in this section, such as the need to keep the dogs warm during the winter months (if you live in a cold climate).

    The next section covers the characteristics and temperament of the chihuahua which can be useful for understanding your dog’s behavior.

    In the following section, we get to the actual care of your chihuahua. This section is pretty thorough, covering bathing, exercising, feeding, grooming and nail care. As you would expect, these are written specifically for the chihuahua’s particular needs and temperament. It’s not just generic dog advice!

    And, yes, chihuahuas do love cheese!

    Next, is the health section. This is a very good section covering the particular health needs and problems of chihuahuas. Again, this isn’t generic dog advice presented as being for chihuahuas too! This is advice specifically for chihuahuas, covering everything from their trachea issues to knee problems.

    The next two sections cover review who may make a good owner of a chihuahua and the pros and cons of having a chihuahua. If you don’t have a chihuahua and are on the fence whether or not one is right for you, these sections can definitely assist you in making that decision.

    The next section covers housebreaking. Unlike other sections, this section seems like generic dog training advice. And, I’m not necessarily sure I agree with it. The crate training method never worked with either Little One or Little Too. It just turned out… badly. Paper training, which the handbook advised against, seemed to work better. Of course, the difference may be in using puppy pads rather than newspaper. The puppy pads are supposed to have a scent that make training easier. As such, it was easier to teach them to use the pads than any other method.

    There is also a short section on breeding, which may be useful if you are interested in breeding your chihuahua. It gives a good overview, but you would probably need a more extensive guide if this is something you’re really interested in doing.

    The remainder of the book gives some additional chihuahua facts and discusses some common myths about chihuahuas. There are also some chihuahua rescue resources.

    Overall, it’s an informative guide and a good deal. To learn more about The Ultimate Chihuahua Care Handbook, click here to visit their website.

    Popularity: 49% [?]

    Floppy Ears on a Chihuahua Puppy

    by Little Too on February 28th, 2009

    This is me last April. Wasn’t I adorable?

    I started out with two floppy ears, as you can see in my picture from the day I first came home in March.

    The month after I came home, my right ear straightened out, but my left ear stayed floppy.

    It was floppy for several weeks. I was so cute.

    I am still cute, though, even with both ears being straight. Sometimes, though, when I’m really tired and wake up in the morning, one or two of my ears might be floppy. But not for long!

    Why are chihuahua puppy ears floppy? It’s actually natural. It’s because when we’re young, our ears are still soft and not hardened. It’s the cartilage that’s still soft, I’m told. For most chihuahuas, the ears will gradually straighten. The time may vary by chihuahua, but most of us have our ears straightened out by the time we’re half a year old or so.

    But some chihuahuas might have floppy ears all their lives if it’s in their genes.

    I guess it’s perfectly fine that my ears straightened at different rates. I’d rather go through a half-floppy ear stage than pimples and stuff like people do.

    Popularity: 70% [?]

    Today is My Birthday

    by Little Too on January 15th, 2009

    Today is my birthday.

    This is me when I came home last March:

    I grew up a lot since then.

    I didn’t get a cake on my half-birthday. I hope I get one today?

    My sister got a cake on her birthday. Well, I guess she didn’t get cake last year, but this is my first birthday? Shouldn’t I get cake for that?

    They say I can’t have chocolate cake though, because chocolate not good for doggies. That makes me sad. They say it can make my heart beat too fast or something. I don’t understand it.

    Maybe I can have a cheese cake? I asked my friends on Twitter. Did you know I’m on Twitter? You can tweet me @Little_Too.

    How do you celebrate your dog’s birthday? Do you let her have cake?

    Popularity: 47% [?]

    My First Christmas

    by Little Too on December 25th, 2008

    At first, I didn’t really like Christmas.

    But then I found out about presents.

    First I got a chew rope toy. Multi-color. I liked it.

    Then I got this:

    It has a squeaky. That means it squeaks! I like squeaky toys.

    I started to chew it up too. But there’s no chocolate inside.

    Little One got some toys too. I stole one of them. Will probably take the other one later today.

    Merry Christmas!

    Popularity: 47% [?]