SSAGO Website, Phase II

If you set your way back machine for June 2006 you’ll see a stub about how I changed the SSAGO Messageboard to use phpBB and particularly the Categories Hierarchy modification. Well the rest of the site did follow shortly after but it didn’t sit well with those viewing in Internet Explorer because of their issue with list indentation, not to mention the design compromises embossed by democratic vote.

So a new layout was needed and whilst I was at it I wanted to deliver on my promise to provide a Content Management System for SSAGO News. Well I knew I couldn’t change the forum software again so I had to find something that someone had already developed an integration method for or one I could quickly bodge together myself.

I tried a Joomla! but it was far too complicated, I had to assume that the next Publicity Officer, whether this would be me re-elected at the Loughborough SSAGO Rally AGM or in Feb 2008. I went through a slew of them; I rejected Drupal for it’s unfriendly support community, e107 worked fine but I couldn’t figure out how to get it to work along side phpBB and XOOPS was just too obscure. (Thank God for Open Source CMS.)

Then it dawned on me, WordPress. I’d been using WordPress as my blog software for 6 months or so and I loved it, I’d gotten quite close to the community and familiar with the code but I wasn’t sure how robust it would be with dozens of pages stored on it.

After a quick bit of research I found a code edit to accelerate the static page listings page which had exponentially gotten slower as I added more. (link) Next issue was user integration, there was a plugin with some minor code edits that I tried for a time but realised the author hadn’t updated it in almost a year, I tried working out what he had done and update it myself but decided that it would be quicker to start a fresh development cycle than catch up on an existing one.

So I had one WordPress blog working as the CMS and as the SSAGO News Article System. Hopefully the partnership will be a fruitful one.

SSAGO Website, Phase I

When the National SSAGO website moved servers a lot of things were made non-functional, after struggling for weeks to convert the Cutecast flat files into a MySQL database and getting them to work with a modified messageboard I’ve managed to finally get it all working together and online.

I used the Flat file to SQL converter here: LINK after reversing the order of the flatfiles to have them numbered in the database in order of creation.

Hopefully people will be happy that they have a far superior messageboard and not annoyed at the forum, for no fault of my own, being down.

Hopefully this new phpBB messageboard will last a while and the rest of the site won’t be far behind.

Visit the SSAGO Website to see it in action.