Added a new search trait, Hair Up.
Indexed roughly a hundred into it as well.
Also found a new type of SQL Injection on the site. Pretty nasty. It's a very complicated coding error, one I'm sure many other sites will be vulnerable to.
I may look over some old logs, see if anyone tried anything with it.
Having failed queries appear in the error log finally paid off though.
Made some major improvements to our Calendar
First off, replaced the Month+Year navigation at the top with something useful. The arrows were added so you can page forward and backward. Also added 2011 to the list, and fixed a mistake where 2008 was checked against 2009 - meaning 2008 could never be selected. lol Or something like that. It's fixed anyway.
Set the thumbnails to a fixed 200px width.
Updated the table to use newer CSS. MMm templates are fun to apply everywhere.
Well, also rewrote the code from a flat file coding style to modularized functions. Simplified the query generation, and yeah. Should be good for now.
I know I know, it's not exactly a calendar layout. But a flat list works well enough.
I've been applying some new CSS around the site. Last thing updated was the PM interface.
Been working on a PM Preview feature. I'm not too sure what to do about it. One approach would take a hundred lines of coded, another approach would take far less but would be very awkward.
It's a lot of work, and not very important I think.
Also brought back the Franchise Editor
. For non-Admin's all you can do is browse franchises.
It provides a nice listing of all the assigned titles and their characters.
Admins can use it to copy all the characters in the Right Hand Side list to the Franchise.
Also tweaked the Forums to place the name of the Forum or Thread in the Frame Header. Previously this info was only available in the browser title. Adds slightly more RAM usage storing the info in an array, but seemed the only approach... eventually the Forums will need some major rewrites. The code is still too much Proof-of-Concept.
There's plenty to do, so look for more news updates as it gets done!
An an update on our stats server
73375 rei 1 45 1 18088K 15100K accept 3 50:08 0.00% ss
Memory usage seems OK. No evidence of memory leaks.
The CPU usage is keeping pace with lightty. *sigh* I seriously need a good Shared Object or library I can link it against that provides a very simple to use Binary Tree. I don't want to see the code, or understand how it works. Plenty of nerds in University who have no doubt already done that, and I trust them.
With a good index, the code would run O(log^2n) faster ...
It's too bad a binary tree can't handle this data set:
F***ing beginner academic CS stuff has no real world application.
Wonder at what point they'd teach how to break that data set into:
Meh .... low priority for now.
And an update on keep-alives
They seem to be making a positive difference. Pages load quicker and more completely.
2011-07-27 06:47:16: (connections.c.137) (warning) close: 7 Socket is not connected
Also seeing some new types of errors in logs.
I may consider increasing the number of keep-alive requests, while maintaining the low timeouts values.