Seriously needs an update.
So yah, in about 2 weeks, when I’ve finished college for good, I’m going to get down to working on this site, as I’ve been neglecting it for aaaaaages. There are a number of things that need to be done.
I really need to work on more text parsing shit, like possibly bulleted lists, so I don’t have to use gay o’s to do it.
The entire stats section needs sorting out, I’m going to run most of it as a cron job, to save SQL being raped every time the page is loaded just to do all those sums.
Every SQL query on the site needs optimising, as MySQL is being used *heavily, I’m seeing like 1GB+ of data being loaded since its start-up (about 80days ago), and that’s just insane for a ~1mb database. I *know* the site hasn’t been loaded that many times.
The quotes DB needs a bit of a cleanout, there’s a lot of repeating jokes and stuff in there that’s just cluttering things.
The comments page needs some kind of verification, as I’ve been seeing *insane* amounts of spam on it. The last comment ID that was left was about a week ago was 438 (they’re sequential), and the increment number on SQLs db is like 590. That’s just insane for a week.
I need to generally tidy all the code of the site, the whole thing is so bad and kinda… hacked, which would explain the dire speed of the site half the time.
I’m considering upgrading MySQL to 5 from 4.1, this will require a large amount of work as the DB will need to be altered and I may have to change some queries etc.
The server itself will need some software upgrades; I’m also getting a NAS soon which I will connect to the server too, which means I might as well do a buildworld to upgrade the OS and such.
I’m also going to generally tidy up the HTML output of the site, as parts of it are…interesting.
My Admin panel also needs to be revamped, as performing certain duties is just unpleasant.
And finally, I’m going to work on some pagination stuff, so the quotes DB doesn’t take an age to load.
So yeah…in about 4 weeks when I’ve finished college and had a rest, I’ll get to work (I hope).