Is this thing on?

Its that time of year again, cant focus of anything useful during the hot weather so I tend to naturally shift into my preferred PST zone. Nice cool evenings phase into all-nighters and bed at dawn…

This of course suits me just fine and gives me the perfect opportunity to get back into some uninterrupted coding sessions late at night. Well, only interrupted occasionally by occasional bollocks-talking on IRC and calling me a cunt on a regular basis. All of which is fine by me

Actually fired up the IDE for the first time in ages this week and after half an hour of “what the fuck does that do?” and “why did I do it that way?” I found myself settling back into the flow and so you can expect to hear me rattling on about my little shooter again in the not too distant…

written by RiK \\ tags: coding, programming, shooter

Today (so far) I have mainly been noodling with php, nothing complex just thought I’d add a more sensible contact form to my school site since the old one was ASP and I’m no longer on that shitty ‘doze server.

Not really done that much with php before apart fromt he forum stuff but so far it seems like a piece of cake.

I dunno, all this SQL and php in one week…. I’ll be after Dan’s job soon

written by RiK \\ tags: coding, forum, IT, php, SQL

Most pleased to see that since migrating my website over to 1&1 and more importantly since getting the forum running on a decent server that it is getting a bit of a new lease of life.

It was horribly clunky running on an access server, and hence apart from where we *had* to use it to discuss some important issues regarding that muppet in Canada it wasn’t really getting a lot of use for anything else.

I’m not criticising Access as such, because I think it is excellent for desktop apps and I run my whole school quite happily with one big access database which works really well. It’s just not suited to running a large multi-user forum remotely. Horses for courses I guess, and as I said before, that’ll teach me to go for the ‘cheap’ option when I originally set up my hosting.

written by RiK \\ tags: coding, database, forum

This database conversion is a right pain in the rear end..

I found a tool which claims to convert an Access database to mysql which is exactly what I need to do, so I did this locally (got mysql server running on a spare PC here), so far so good.

Ran mysqldump to get the thing into a usable format and threw this at the new DB with phpmyadmin. All good so far.

Changed the config files for the forum to look for a mysql forum and ran it, amazingly the forum looked intact. I was mildly suprised by this fact, but rather chuffed that it had all gone relatively smoothly.

Duh.

As soon as I tried to do *anything* on the forum which involved editing or posting a message it FUBARed…

Arse!

Further investigation by comparison of the backup file which phpbb generates from a clean install showed that the tables are in fact not identical, and hence I think I’m going to have to spend a few days beavering away hand-rolling the sql to make it work.

Feck.

written by RiK \\ tags: coding, forum

I’ve spent all day trying to figure out a sensible way of migrating the phpbb forum from my old site over to the new provider. The phpbb bit is a piece of cake, sadly, as I went for the cheapie option of hosting an access database when I set it up first I am now paying the price..

The Access setup was fine when the post count was low and we only had a few users, but now with 50+ users and 5000 posts it is flaky at best and so I have new provider with a mysql database.

I seem to be winning finally and have found a useful tool which should do the conversion for me so I’m just off to install mysql on my PC & check it out…

Wish me luck!

written by RiK \\ tags: coding, forum, problem

Back at my own desk after a succesful trip to Lionhead with Jeff where he managed to suitably fry their brains with the llatest stuff in Unity. They confirmed that they are happy with where he’s at so far and that they were going to get their act together and crack on with the audio stuff so I came home with a happy Yakkie which is a good thing

Oh, they showed us the llatest build of Fable, BC, Black & White 2 and the Movies as well… I’m so glad I’m building a new monster PC, I’m going to need it

written by RiK \\ tags: coding, Friends, lionhead, unity