Since I wrote this here CMS thingy, I have learned quite a bit about database structure and normalisation and stuff. Therefore, I have been going through my queries and straightening them out. So far I've squished around two thirds of the queries I had, by optimising and generally refining my code. Using INDEXes and JOINs and stuff, oh yes.

...

Yes, my life really is that boring... :P
I haven't had much else to do other than organise my house move (not confirmed yet, lots going on but seemingly nothing happening) and being ill and stuff *yawn*.

You may remember my last rant about people who have written their own CMS, in which my point was pretty much that people are copying a simple blog tutorial and saying it's a CMS.

In part two of this thrilling instalment¹, I revisit the topic of the custom CMS to rant about the latest craze - which is... well... writing one's own CMS. Everyone and their dog seems to want to do it. It's the thing to do to earn cool points and tell everyone how great you are. I should know, I've done it.

But what I am seeing at the moment is people who have no idea what they're doing. People who simply want to make a CMS because it's cool. When I wrote this CMS, I did it after almost 3 years of being comfortable with the language, knowing exactly what I wanted and what each function does and why. I knew the security implications involved in it, the problems I might experience, the limitations of what I had to work with, etc. I didn't even write my first script until I'd been comfortable with the language for two years. Editing, picking apart other scripts was fine, but my own script? If you ever saw PHPAskIt v1 (it's still out there, worryingly enough) you'll know I wasn't even ready then. However, I'll still admit I only wrote this CMS because I was totally jealous of Jem it was cool. :(

As you may or may not know, I have been learning Ruby on Rails for the past 6 months or so. I am fairly familiar with it at the moment but I am freely able to admit that I am not under any circumstances ready to undertake as large a project as a CMS in it. I don't know how RoR can be exploited, I don't know what sort of problems there are by using X rather than Y - I just don't know enough at the moment. I'm comfortable hacking about existing scripts and adding on little bits and pieces, but that's it.

So my point today is this: before you decide "zomg!1 I must write a CMS!1!!", ask yourself the following questions:

1. I'm going to be using PHP and MySQL. Do I have enough knowledge in these areas to make my CMS work?
2. Do I know what the limitations of my server/host/databases are?
3. Will I have access to PHP4 or 5? What's the difference?
4. Why am I writing a CMS in the first place? What do I need it to do that others out there can't?
5. What do I know about security, particularly remote file inclusion, XSS and SQL injection? How will my CMS deal with these areas?
6. I want my CMS to do X, Y and Z. Do I know how I can achieve this?

If you're unsure of the answers to any of these questions, my advice would be you're not ready yet. Keep looking at existing scripts and see how they're doing things. Search the internet for vulnerabilities in those scripts and how they are exploited to ensure it doesn't happen to you. Get friends to try and break your script as much as they possibly can. I can guarantee that some things normal internet users might do, you'll never think of - for example I found people were trying to go to non-existent tags on my site or page numbers that didn't exist and it caused my site to break.

However, don't think I'm discouraging you from writing a CMS (much :P ). A CMS is the perfect way to develop confidence in a programming language and to learn more about it than you ever could have otherwise. By all means start trying to write your own CMS and learning techniques to make it work the way you want to - but here's the important part: don't put it online. Install yourself a web server (I have XAMPP - very easy to install, has everything you need and installs in a single click. Mac OS X has built-in web server features but you can get XAMPP and other similar packages for it if you're not entirely sure how to use the built-in stuff, I must admit it's always confused me) and develop your up-and-coming CMS there; learn how to interact effectively with MySQL and all that in your own time without hacker types lurking everywhere and undoing all your hard work. I made the mistake of writing the first version of PHPAskIt online and ended up with all sorts of security issues. While I was writing the CMS, it stayed offline for 8 months because I didn't feel it was secure enough to go online - would my host tell me off for too many database queries? Would my PHP version and theirs clash?

Don't think you have to write a CMS just because "everyone else is doing it". You need to feel you can do it and that there is actually a point to doing it. If WordPress or similar does everything you need, is it really necessary? There is no shame whatsoever in using WP. The only reason I stopped using it is because it started to take over my site in ways I really didn't like and I'd modified it so much in the end that every time there was an upgrade I had to update each file individually to make sure it didn't mess with my changes. You also need to make sure you know what you're doing and why you're doing it. If you don't know the slightest bit about PHP, it really isn't worth it.

¹ *Cough* ^

How on earth is it already August?! Where is the time going? Noooo

My internet is slow. Either that or all the sites I'm trying to visit are slow. One or two of them work, the rest don't. Blah.

The heatwave has died down at last, though I sort of wish it hadn't... It's been replaced with the usual summer weather for this country - rain, more rain, yet more rain and temperatures not quite making it into the 20°C (about 60°F? Not sure) region. That still doesn't stop our bedroom from being really hot and humid (even with the window open) and therefore stopping me from sleeping. Like now, it's 5:15am and I should probably not be on my computer at this time.

Anyway. I'm working on a custom blog/content management script. I'm really pleased with it so far, although the functionality kind of resembles WP in many ways so I'm not sure there'll be much point to it other than the fact that it's teaching me a lot in terms of PHP and stuff. So far I have posting (drafts, private entries, password protected entries), commenting, comment moderation and fancy URLs that don't rely on mod_rewrite. :D Yay! I don't have an admin panel yet, so that's the next step. It gets a bit annoying having to login to phpMyAdmin every time I want to approve some of my testers' comments, or edit/delete an entry/comment :P The script is completely written by me, but it borrows 3 functions from WP - mostly formatting stuff because I can't do regular expressions. Those functions are the 'safe' title generator, the entities converter for posts, and the nl2p function. I'm sure I'll eventually be able to "get" regexes and be able to rewrite all that myself (I really need to rewrite it all - WP's functions mess up my stuff by changing absolutely EVERYTHING into alternative entities...), but for now I'm going to use WP's until I get the rest of the script done. And no, I haven't been using the Build A Blog tutorial series, or indeed any tutorial series. This work is (mostly) all miiiiine. Heh.