I've totally frakked up the Sketch Fest site trying to make the prompts page load at something greater than seriously slow... scrambling to learn some new tools and get it fixed - or at least limping forward - within the next 45 minutes. Wish me luck.
ETA: OH HOLY HELL. All my sites are down now. Timing, you are NOT awesome...
It's an urgh and argh kind of day. I've ALMOST got the sketch fest improvements done, but there's one pesky, tiny little problem that requires a helluva lot more work, and I've already well overrun my allotted coding time AND most of my sketch time, and have no sketches to show for it, which makes me stompy and grumpy. I'm hanging up my coat for now, chopping some more wood for the fire, taking a shower, and going out for a movie with a friend.
Hopefully, I'll get some sketching in afterwards, and the code will cooperate. I fear it's going to take some more unpicking than I'd like, which should probably be done at at time when Sketch Fest isn't running... it is working for now, if somewhat slowly. The new page(s) will be quite sweet, substituting a whole lot of nested looping queries with one single query. But it does mean a new way to record the unregistered users. Who thought it would be nice to allow unregistered participants? Oh, that was me. *facepalm* And I didn't think far enough ahead to set them up seamlessly, so I'm going to need to do some database manipulation, which is always a little stressful.
Urgh, I say!
(But hey, I did learn about LEFT JOIN today, and count() and a few other neat tricks. Plus lots of ways not to use them...)
Dreamhost is doing a planned rolling outage through their sites. Sketch Fest may disappear for about 15 minutes, and appears to be down right now. Hopefully everything will go smoothly and reappear very quickly!!
ETA: It may be back up - I was able to upload a few pieces, but it's being sluggish again. I am about to fall into bed, so hopefully it will behave for those of you still sketching! See you in the morning!