Anime Characters Database

Print View
Jul 10, 2011
Rei
Finished adding a Print View option to every page.

See the footer for the "Print" link.

Here's an example using the news.

I've always been drawn to simplicity, but development always seems to lead away from simplicity. ACDBv2 was designed to be a simple site. But after 7 months, it's now every bit as bloated and complex as ACDBv1 was. lol This Print View at least allows us to turn back the clock a bit in removing the Top and Side focusing in on just the content.

Also nice to see W3C validates at least some of my code in the print view. I've been at odds with them for some time now. We'll never see eye-to-eye on the issue of id's. I've read the CSS specification top to bottom. Studied more than a dozen ways of using CSS. There is no other way to create style zones like ID's do. So f*** them.


Also used my first if ? : block. Made the most sense for auto generating valid print links.

if( $_SERVER['QUERY_STRING'] ? $PRINT = "$DEFAULT_ACTION&printview" : $PRINT = "$DEFAULT_ACTION?printview" )

Probably never use that syntax every again, but hey, I wanted a one liner, and it seemed the best way to do it. Using a traditional if-else block is all round easier to read though.
Lighttpd 1.4.29
Jul 10, 2011
Rei
been using Lighttpd 1.4.29 on the dev site for a few days now.

1.4.28 suffers from an sbwait problem ... basically, if you are using PHP CGI + lighttpd, and a fast_cgi process gets stuck waiting for data to be received by the php-cgi process.

i figured out 3 ways it could happen

1. the firewall could close a connection early
but that was proven impossible, as on each ACK the timer is reset. so even having a 10 second expiration on ESTABLISHED states wouldn't matter if data is ACKed each second since the timer would be constantly reset to 10 sec and could continue on like that all day

2. php max execution time or input time limit
this one possibly is to blame. i know insane sites likely set this to 0 but i prefer 60s. in theory, 16 file uploads limited to 1b/s transfer rates could shut down any default install of lighttpd+php-cgi so to prevent a one man dos, or at least mitigate it.. i like to kill off transfers but possibly in doing so, the TERM doesn't slide up to lighttpd properly.. but it should have a TIME_VAL and sighandler to break the connection

3. lighttp max upload size
also set this low. well if it's triggered, lighttpd send a 4xx status code. so.... not likely to be the cause

lighttpd 1.4.27 was borked on FreeBSD. not gonna run any new release on a production server until it's proven stable by other fools

for the meantime... i'm stuck manually reaping php-cgi processes zombied into an sbwait state

[rei@ai ~/sbwait]$ ps jlaux -U www | grep sbwait
www 3299 58416 58416 58416 0 IJ ?? 0:02.98 /p/bin/php-cgi - 80 0 44 0 27424 8072 sbwait 0.0 0.1 2:59PM
www 91809 58416 58416 58416 0 IJ ?? 0:03.88 /p/bin/php-cgi - 80 0 45 0 27424 8008 sbwait 0.0 0.1 Thu05PM

ai# kill -INT 91809
Updates
Jul 10, 2011
Rei
Added the Edit mode to news.php

It's a little over 300 lines of code now.

Also tweaked the Main Menu to include News and Calendar links.

Updated No Characters to use besttable CSS, ACDBv2 includes, and ACDBv2 links. Probably will update it to have images next.

Might rework the Calendar next to use a tile layout ... more condensed info is usually good.


mysql> select email_subject,count(*) as n from emails group by email_subject;
+--------------------------------------+-----+
| email_subject | n |
+--------------------------------------+-----+
| Reply Notification | 8 |
| Solved Notification | 8 |
| Welcome to Anime Characters Database | 431 |
+--------------------------------------+-----+
3 rows in set (0.01 sec)


Looks like we've sent out about 431 welcome emails since I switched over from e107 to my own system. Still meaning to rework the registration system - mainly want to log error codes when signups fail. More info is my best weapon in fighting spam signups.

Ah reminds me... "forgot password" code is still undone. Wanted to add a reminder for people to contact us by email if they forgot their username or password.