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"; } } ?> Anime Desho Desho?
    It's raining seifuku in ADD~
    97 Comments Read

    30th
    MAY

    The Great Singapore Figurine Clearance Sale

    Posted by tsubaki | Filed under Figurine

    Hi people, I bring great news to you all. To keep the long weepy story short, all my figurines must get out of my house or I have to get out of the house. So, yeah. Selling them off at very very cheap prices. All prices are in SG dollars, and SG buyers are generally preferred. I can do meetups at the usual otaku haunts.

    Here is my list: Download the XLS or PDF of my collection, and please help give these ladies a new warm home! For those who need pictures, there are some figurine shoot I did in the past which you can find here.

    Please buy everything off me! I promise you it’s dirt cheap clearance. BETTER THE GREAT SINGAPORE SALE. Kindly spread the word, thank you very much!

    ——

    Attention all bidders and potential bidders, please take note of the follow details:
    - Last bid will end promptly at 1am, 1st June Sunday 2008.
    - If your have won, kindly SMS me your number if you have not done so yet.
    - Collection of figures will be at Sunshine Plaza (most likely outside KKnM) at 2-3pm, 1st June 2008.
    - If possible, please bring exact change.
    - I will also be bringing unsold figurines (so be smart and bring more cash, lolz).

    If there are any real physical defects I will tell you beforehand, otherwise all figures are in good condition to display. Pointing smalls defects just to get discounts = epic ban hammer, fur realz. Some figurines are a little dusty, and I’ve taken the liberty to briefly wipe them with a dry tissue. Do not expect them to be in perfect dust-free condition. Who are we kidding, our rooms are always dusty.

    ——

    AUCTION IS NOW CLOSED

    Auction winners:
    Nanoha – mistayoh c/o $75 OUTBID misakichii [BID CLOSED. PRIVATE SETTLEMENT]
    Ignis – Yukarin c/o $82 OUTBID winsonkoh ($71)
    Black Saber – engima c/o $70 OUTBID dusk ($68)
    Melon Pan eating Shana – eltboy c/o $45 OUTBID zenical ($38)
    Hikaru Death God Version – Leefe c/o $42 OUTBID Eisen (SnooSnoo) ($40)
    Asuka and Rei Duo – Kokanaden c/o $40 OUTBID tragic comedy
    Tohsaka Rin – Cain c/o $40
    Yakumo – Rynwk c/o $30
    Mai Hime v2.5 Trading Figure – bipi c/o $30
    Rindou Rina – Leefe c/o $28 OUTBID Rynwk ($27)
    Al Azif – MR_X c/o $22 OUTBID Shane
    Mai Tokiha – Shaun Sng c/o $20
    Mai Otome Collection Figure – Shaun Sng c/o $20
    Natsuki – bipu c/o $20

    Figures that are still available:
    Hobby Japan Limited Edition Rider Swimsuit
    Natsuki Kruger Action Figure
    Moe Tan Trading Figures (HIGHLY DETAILED)
    Dengeki Daioh! Shana series (Sept, Aug, Oct) + FREE: Dengeki Daiohs that comes with it
    Keroro Commando Mission 1 (HIGHLY DETAILED)
    Mecha Musume Trading Figures Volume 1 and 2 (HIGHLY DETAILED)
    Utawarerumono Trading Figures
    Mai Otome Figure Set 1 and 2 Gashapon

    38 Comments Read

    3rd
    MAY

    I’m on teh newspapers!

    Posted by tsubaki | Filed under Personal

    Hi people, this is perhaps the only reason why I can explain why Anime Desho Desho is dead. I’ve been grinding and levelling up in the real_world.exe as a Level 20 Kid under the apprenticeship of the famous Lvl 99 Director Eric Khoo, and this newspaper article is my report card of my labour. Tjhan has nicely announced this on RIUVA together with some artist bashing shit and I figured out it’s better to the actual article to everyone else out there who’s interested to read about it.

    May I present, my real e-penis:

    Yes I know, I look damn retarded and ugly here. The photographer, took like a million over pictures of me, decided to use this. He told me to do some hand gestures while I talk to an imaginary person, and this came out. I swear the next time someone tells me that, I’ll just look straight at the camera and not do anything.

    At the moment, the only anime that I still religiously follow is Code Geass R2. Don’t think the community needs another CG reviewer, so I’m not writing anything about it. Also, I’m seriously considering to pull the plug on ADD and maybe join another animeblog or something as a guest writer, but ah wells. I dunno.

    7 Comments Read

    19th
    MAR

    Extras Needed!

    Posted by tsubaki | Filed under Personal

    Hello all! I am shooting my Graduation film on the last week of March and I require extras for a particular scene. If you are free on that day, please come down to lend support. It’s a photo exhibition scene held at a gallery, and it needs to be brimming full, just like how an exhibition would be like on its first day. Please bring as many people as you know, old, young, parents with strollers, people in coffins, whatever.

    Here are the details:

    Date: 28th March 2008
    Location: LASALLE COLLEGE OF THE ARTS CAMPUS, Earl Lu Gallery Basement 1
    Map: http://www.streetdirectory.com/asia_travel/travel/travel_id_33399/travel_site_143347/
    Call time for extras: 12.15pm
    Estimated endtime: 4 to 5pm
    Attire: Semi-formal ie; Tee + Blazers, Shirts, etc

    We will provide food and beverages. If you have any questions, I can be contacted at 97386097 or you can email me at written.by.nic [at] gmail [dot] com

    13 Comments Read

    17th
    MAR

    Evangelion 0.1: You Are (Not) Alone

    Posted by tsubaki | Filed under Anime, Movie

    rebuild-of-eva-poster.jpg

    I know this blog is as dusty and dead as hell, but if you’re still reading, here’s finally a post. I watched Evangelion 0.1 today and was mighty blown away. Now before I start talking about the film, let me talk about the crowd there. For a Monday 7.15pm show, the theater was rather packed. I occupied the best seats (B8) so I didn’t have to worry about people standing up during a Rei scene (I hear it’s becoming a meme). Most of the people I observed were either:

    3 Comments Read

    3rd
    FEB

    Hello from space!

    Posted by tsubaki | Filed under Administration

    hellofromspace.jpg

    Hello, it’s been while. I do realized there’s so much dust on this site it’s enough to suffocate a kid. I do apologize for the lack of update(s). If you noticed, there are ads on ADD now because even though this site is somewhat stagnant, the amount of traffic that ADD get is enough to break Maestro’s back, so upon his request, we have ads now.

    The boys over at RIUVA also roped me in as a guest contributer for Kokanaden’s Otaku Helpline thingy thing which everyone should read about.

    I’m currently working on another film project, a short film that I will be directing sometime in March. I’m currently writing the 6th draft of the script and once I’ve gotten some stuff in I’ll let you guys know. There’s probably going to be a chance for you guys to cameo in my film, so stay tuned ya? Hah.

    Meanwhile, merry belated xmas, new year, whatever to everyone. My bad. Really.

    Oh and for no bloody reason, I’m banned again from 4chan. Like what the fuck? Someone in Singapore, who is sharing the same IP string as me needs to stop fucking uploading CP. Bastard.

    27 Comments Read

    14th
    DEC

    Greetings from a film shoot

    Posted by tsubaki | Filed under Film, Personal

    day1shoot8.jpg
    Me, totally T.T-ing

    I finally can breath for a bit. Hi! How is everyone? I see DarkMirage has made a new site, tj han’s still making lame nyoro comics, LianYL’s BRstick still going strong, bj0rn still hopeless in love with a girl that doesn’t know he like her and some of you people got so excited over giving roses to the girls at cosafe. If I miss anything out, that’s probably because I haven’t read your blog. Pimp the links on the comment if you want to. Oh and yesterday I got k-lined from Rizon, so I can’t get on #sganimebloggers now. Fucking netsec banned me for 4319 mins. God knows how long that is.

    I’m currently now on Day 6 of my film shoot, and it’s been a crazy madcap shoot so far. Sometimes I wonder why I chose to leave my cosy computer chair where I can either watch anime all day long instead of doing anything productive, but I guess I want to make something out of this boring life we’re all given. So instead of escaping to a fantasy world, I’m creating one, albeit in a language I don’t understand.

    I promised pictures from the shoot, but I only have pictures from Day 1. The past few days have been moving so fast and they are all lined up back to back with 12 hour shoots, I’ve been having as little as 0 to 3 hours worth of sleep in order to prepare for the next day’s shoot. Being the AD (Assistant Director) is difficult, especially when you are new to the industry.

    14 Comments Read

    10th
    DEC

    Sinema Old School

    Posted by tsubaki | Filed under Film

    Filming started yesterday and it’s crazy due to the mad down pour. Fricking unfriendly weather, but fortunately for us it worked for the scenes we were shooting. I’ve got some pictures, but I don’t have time to upload them.

    Before I make a run for my shoot now, I thought I should share with everyone about Sinema Old School. If you’re a film buff, I suggest signing up for this. I’m really excited about the prospect of a indie cinema that showcases local films and I’ve been to the the theater as well and it’s blood awesome. Free seating theater ftw.

    Sinema Old School is the first sofa-styled, free-seating independent cinema for Singapore films located within the ultra hip Old School at 11 Mount Sophia. It will open its doors officially on the 12th December in conjunction with Eric Khoo’s 12 Storeys 10th anniversary celebration.

    Housing a 130-seater High Definition cinema made possible by Panasonic, a film and creative merchandise retail outlet as well as studio and post facilities made possible by Apple, Sinema Old School hopes to be the homebase for Singapore filmmakers and film lovers!

    Besides regular short+feature film screenings, future activities will also include technology workshops, film forums and dialogue sessions as well as gigs for local bands and musicians.

    The retail store wants to be the first in Singapore to distribute and sell DVDs by Singapore Filmmakers, CDs by Singapore bands and musicians, magazines by local indie publishers, books by Singapore writers

    Works can be published or unpublished (we can help publish it). It can even be self-published (a.k.a DIY!)

    It will also have indie filmmaking gear and products for sale too.

    Contact us if you want your works to be available for sale at our store!

    Sinema Old School is also available for rental for creative and performing arts groups seeking to collaborate with filmmakers on special projects.

    Venue bookings can be made via www.oldschool.sg

    40 Comments Read

    1st
    DEC

    ADD and Tsubaki’s update

    Posted by tsubaki | Filed under Personal

    konagureeeen.jpg

    Firstly, I want to thank everyone for your warm feedbacks and comments regarding my short film. It’s very heartening to see it being appreciated by so many, because to honest, I didn’t think it was good. But well I guess it’s natural to only want to be better each time, since you’re only as good as your last piece of work.

    Having said that, I thought I should share a little more about what’s installed for me, as well as ADD in the future.

    37 Comments Read

    28th
    NOV

    My shortfilm: swindle

    Posted by tsubaki | Filed under Personal

    null

    Alright, as promised, I’ve uploaded the short film I was working on a while ago on youtube. Basically for my school, we have to produce short films every semester which is considered as a “solo project”, where we pratically do everything ourselves. Of course, we are allowed to enlist help from others. But I prefer working alone, only getting help on certain parts that I really need help with. So yes, this film was written, produced, directed, shot and edited by myself.

    I won’t say it’s teh best film, because I’ll be honest and say I intended it to be a little lame. Lol. But it’s all fun, since we really have full control over everything, as opposed to a proper film crew with assigned positions and all.

    Alright, let me throw in the introduction and the whole after thought process under the cut.

    24 Comments Read

    22nd
    NOV

    2nd screening of Byousoku 5cm!

    Posted by tsubaki | Filed under Anime

    ZOMFG, due to popular demand, the organizers have prepared another screening of Byousoku 5cm. This time, it’s held on the 1st of December at 12.30pm. I’m happy about them rescreening it, but of all the dates, WHY ON THE DAY THAT I HAVE TO WORK? THE PAIN. THE AGONY. THE HATRED.

    For those who want to watch Byousoku 5cm, I suggest you get your ass over to the e-ticketing counter now. The sale for it is now avaliable, so hurry up. Sigh, I want to watch but on the 1st of Dec I’m working as a videographer that’s going to pay me by the hundreds for just 1 day of work.

    « Previous Posts