Site Tweaking

It would appear that trying to move the site at 2am wasn’t the brightest thing to do! I was experiencing some slowdowns and pauses since I’d missed out a few steps for restoring WordPress. I found this article very useful. And this and this one too.

I needed to edit two records in the “wp_options” table. They were “siteurl” and “home”, which had to point to the new site. Unfortunately you have to manually change them in the database (I used phpMyAdmin). I’m not quite sure why there aren’t options within WordPress to do this?

I also had to fix a few image urls. I would have thought this would have been done with some kind of tag before them, e.g. :IMAGEURL:, and then WordPress could parse that and put in the proper url. That way it would be very portable. Unfortunately it seems to hardcode the urls in the post! Maybe thats BlogJet’s doing? Anyway, that involved a bit of tedious tweakage.

However I could have nipped both of these in the bud by just doing a search and replace on the SQL dumpout of the site before restoring! Ah well, live and learn.

Welcome to!

Yep, new domain name and new host. Its now :D. Which is nice. I’ve switched to a proper host instead of the steam powered box in my living room. It saddens me but it just wasn’t up to the job and if I’m to get MPQ Archive up and running, well it needs to be done properly.

So I’ve gone with SiteGround. I have to say I’m impressed, actually more than that, I’m stunned. I had a few queries beforehand so I was going to email them but found an online chat option. I asked a ton of stupid, obvious questions (can I run this? can I install this? can I blah blah?) and got good answers back quickly.

Setting it up was a breeze. My account and site were created as soon as I paid and I’ve managed to get WordPress up and running with everything that was on the old site. The cPanel admin page makes setting it up so damn easy. So yay!

The “basic” package I’ve got gives you 12GB space, 500GB a month bandwidth, PHP access, 10 MySQL databases etc. Lots of stuff, more than I need! The pessimist in me is hoping there isn’t a catch?

My old site ( just redirects here and I’ll turn if off at some point. So can the 3 of you with links to the old site, update them please! Thanks.

Oh and BlogJet still works, so double yay!

Useful Utils #1 – SlickRun

I thought I’d waffle on about what apps and utils that I find useful. It’ll be in no particular order, just what springs to mind. So for my first useful util I’ve chosen is something I use everyday, almost all the time.

Its SlickRun from Bayden Systems. Essentially its a floating command line that allows you to set up aliases (magic words as it calls them) to various actions. For me its meant I can get rid of all my short cuts and icon clutter. All I need to do now is press “Windows Key + Q” to open the prompt and then start typing the magic word I’m after, as you can see below:


It might not be the most sexy looking of programs but it sure is functional. The amount of time this program has saved me is immeasurable. Instead of playing hunt the icon on a toolbar I can quickly run pretty much anything in seconds.

It doesn’t just run programs though, you can also type in paths and file names and it’ll open them. It also has a little maths parser built in. If you type “=” first and then your calculation, as you would in Calc, then hit enter, you’ll get a result. Obviously for something like this it has auto-complete for that little speed bump in usage. Oh and its free too!

I found it purely by accident from a 10 utilities in 10 minutes video that Scott Hanselman did last year. Expect more utils from that video!

Amusingly, someone I converted to SlickRun says he’s sure programs load faster with it! I wonder if there’s any truth in that?

Yep, you guessed it, SlickRun is a Delphi app :D.

O’Reilly Network Safari Bookshelf

Just over a couple of weeks ago I was in the thick of writing reams of PHP code for my group website & design project. I was searching the interweb looking for PHP security guides (I know has a ton of stuff there, but I was after something specific) and stumbled across a website for an O’Reilly book, Essential PHP Security.

As it happens the two chapters I needed were downloadable (as PDF’s), but after finishing those I wanted to read more of it. I thought surely there would be an e-book version of it? I tried the “Buy Now” option and ended up on Amazon America where I have no intention of buying off. So I went to the O’Reilly website and after much messing about I ended up at the Safari Bookshelf.

It works like a library where you can have so many books a month depending on your subscription level. A 14 day trial was available so I signed up on that. I picked the book I was after… and found out I could read all of it online but needed “download tokens” to get the individual chapters as PDF’s. On the trial you get 1 as a gift but you can’t buy any more. Bugger!

Anyway I found the service very useful. I was able to search all of their books, but in order to properly read them I needed to add them to my “bookshelf”. You can look at a book beforehand but you can only see the first few lines of a chapter. You get so many slots on your bookshelf and depending on the size of a book, it may take up more than 1 slot. Also worth noting is that its not just O’Reilly books you have access to, but books from other publishers such as Addison Wesley, Microsoft Press, Sams and Que to name a few.

My 14 day trial finished last weekend and I err… well I was in two minds about signing up. My mind was made up for me though because I didn’t cancel it, so I’m subscribed monthly at $20 (ex VAT) which allows me 10 bookshelf slots, 5 download tokens and 30 to 35% off the print version of any book. Since I’m doing some Citrix work at the moment, I’ve decided to keep subscribed, since there’s a ton of useful stuff.

But I do have a few gripes. I don’t like the font used for the books content, petty I know, but its Times New Roman which is just an unreadable, horrible, mess of a font. You can increase the size of it but its not good enough. Its just not nice to look at (but with a bit of Web Developer Extension and Greasemonkey tweaking I’m sure I can sort that out :D).

Second to that is how many download tokens its costs to download a book chapter. The logic for it doesn’t add up. I currently have a Citrix book on my bookshelf which takes up 2 slots. The book has well over 20 chapters and it seems each chapter costs 3 download tokens!? With the subscription level I have I get 5 tokens automatically, but to download the book I would need 60+ tokens. A pack of 5 tokens costs $10 which means to buy enough to download the book would cost $120. The book retails for $55! And since I’m now subscribed, I can get a 35% discount so its only $35ish. Ouch. Apparently thats a worst case though…

Finally, whatever method is used to check you’re logged in (cookies me thinks) can be a bit flaky. There have been a few occasions where I’ve closed Firefox, brought it back up and it thinks I’m logged in but doesn’t know who I am! Logging in again fixes that.

All said and done though, I think its a very useful service. I think the pricing could do with lowering but one way to think of it, is like this: If you’re happy to just read online then $20 for 10 books for a month is a bit cheaper than buying them all!

Note 1: I should mention that the majority of the Essential PHP Security book is also available as an Apache Conference paper. Of course I didn’t find that out until afterwards!

Note 2: I also found out that the author, Chris Shiflett, has an excellent PHP Security blog, so that got added into my many, many feeds in FeedDemon.

Renewing my passport costs how much?

I’m apparently getting married abroad later in the year and there’s a long list of things to get sorted. Near the top of the list is a new passport since my existing one runs out next month. Now maybe I’m a cheap bastard but I find the charge for renewing my passport is a tad steep, at £51.

Oh, I know you could say “Well thats for 10 years, so thats only £5.10 a year!”… but that doesn’t really equate since I have to pay for it now, not over several years. To add insult to injury you have to pay for postage. Why is that then?

This isn’t for some special quick service either, it’ll be 3 weeks! If you’re feeling flush you can pay nearly £80 for it to be done in a week, but you have to book an appointment at you local post office for that. If its urgent you can pay another 20 quid more and get it done on the same day.

The cost keeps going up too, the lovely wife to be renewed hers last year and it was about £47. What’s suddenly changed to cause it go up so much? Thats alot more than inflation!

Site Tweaking

I’ve yet to find a WordPress theme that I really like, but out of those I’ve looked at Regulus by Binary Moon is my current choice. B0rked-CategoriesEven with this theme I’m not totally happy, so I’ve been making minor changes to it. I wanted the categories section in the sidebar to show the count of items in each category. I was told the default theme did that, so I loaded it up, worked out it was wp_list_cats() with various parameters and tweaked the Regulus layout to match. Unfortunately I broke it slightly… as you can see from the picture on the right.

I was a bit stumped as to what the problem was. There was nothing obvious in the HTML source, so I figured it must be the CSS. Oh joy, this could take a while! I was looking at messing about with it in TopStyle.

However, Vondur pointed me to this excellent Firefox plugin, the Web Developer Extension. I know every man and his dog who has the vaguest interest in web development has it already but I don’t see the point of adding another Firefox extension unless I really need it (Firefox uses enough memory as it is!).

And boy was it useful, I was able to edit the CSS and the changes appeared instantly, which made finding the problem easy. The culprit was “display:block;” in “#sidebar a”. Turning that off fixed it, but the links were too close together. So I tweaked “#sidebar li” with padding-top / padding-bottom values and that fixed it.

Having the right tools for the job makes it so much easier!

MPQArchive using WordPress?

A thought occurred to me, what if I use WordPress for the MPQArchive site? It might be stretching it a bit, but its got to be quicker than me writing something.

If I could set the reviews up as pages and not posts and have them categorised, I think it would work. Just need someone to come up with a nice design :D. Gom, Vondur, what do reckon?

Yay! Exams over!

I’m currently doing a part time degree in Internet and Information Technology and earlier this evening I finished the databases module (I hope!) with a 2 hour exam. So I can now empty my head of the following:

  • Normalisation
  • Entity Relationship Modelling
  • Formal Database Models (Network, Hierarchical and Relational + Others)
  • Types of DBMS (Database Management System)
  • The Layers of Abstraction (External, Logical and Physical)
  • Transactions – The ACID model
  • Serial / Serializable Execution
  • Concurrency Control Methods
  • Two Stage Commit Process
  • Locking methods (Exclusive, Share, Pessimistic, Optimistic)
  • Timestamping
  • Distributed Databases
  • Horizontal and Vertical Table Fragmentation
  • Lost, Assumed and Phantom reads
  • etc…

Well maybe not, some of it might actually stick!

At least it brings to an end 3 weeks of hard graft and 2am+ nights / mornings. I’ve had to do a group project about websites (lots of PHP coding plus Apache security tweaking), a presentation of that, a two part assignment (1500 word essay and 15 SQL questions) and an exam. The latter two of which were due in the same day (today). So I’ve had to make sure I was organised, but I still had to take some days off work to make sure I was prepared enough. Which is a bit annoying, since I took extra time off work at the beginning of January to get a start on it. Thankfully where I work is very understanding.

Getting back to databases, I found Databases Demystified (book) incredibly useful. It was the cheapest database book at the local Waterstones, but I doubt any of the the others could do a better job. It covered pretty much everything except distributed databases and table fragmentation. The notes we were given were a bit lacking in substance and examples so I needed something!

I found tons of stuff on the net as you’d expect, but it was hard to work out what was right and what was wrong. I found a great example on distributed databases two phase commit (its like a wedding apparently) but it never came up in the exam (I thought it might do, it was in the previous years). I read one example about vertical and horizontal tables where 3 “experts” answered a related question. The first chap waffled on and mixed the two up, the second was straight to the point and the third obviously didn’t care! The majority of stuff just isn’t worth a light.

Sadly Wikipedia fairs no better and is average to poor on the subject. Don’t get me wrong, there is a lot of stuff there, but some of its badly written, poorly linked and at worst inconsistent. I’ve gone and edited a page or two so they link together better but what it really needs is an expert in the field to give the entire section a good going over. Amusingly I thought that back in December when my first databases assignment was due and now some of the pages say exactly that.

With that over with, I’ve got a two one week break until the second semester fires up!