I’ve just managed to break my mouse.
It was an old mouse - it used a ball. In fact, it was this ball that lead to it’s downfall.
Y’see cutting out people from pictures can be a real pain in the arse. Doing this with a dodgy old ball mouse is just plain infuriating.
I don’t really remember how it happened, sorta the red veil effect…
Anyway, RIP dodgy old ball-mouse. You’ve served me well for many years, but you won’t be missed at all.
I love this project…
Whilst having a wee skim through the calendar, I found this: http://www.ussu.net/epicentre/events.php?id=346
Last night I crafted the largest MySQL query I’ve ever used. It’s very pretty:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 | SELECT g.group_display, g.group_id, gm.admincount, e.eventcount FROM groups g LEFT JOIN ( SELECT g.group_id AS group_id, COUNT(gm.member_id) AS admincount FROM groups g LEFT JOIN groupmembers gm ON gm.group_id = g.group_id GROUP BY g.group_id ) AS gm ON gm.group_id = g.group_id LEFT JOIN ( SELECT g.group_id AS group_id, COUNT(e.event_id) AS eventcount FROM groups g LEFT JOIN events e ON e.group_id = g.group_id WHERE e.event_start > UNIX_TIMESTAMP() GROUP BY g.group_id ) AS e ON e.group_id = g.group_id WHERE g.group_active = 1 ORDER BY g.group_display ASC; |
And it does this: http://www.ussu.net/epicentre/groups.php
During a break from bug-hunting (why are they so hard to replicate? why?) I started messing around with a pretty javascript library called modalbox.
After the usual add-a-line-to-your-<head> I was away. Knocked up a quick ajax callback and now plan to start messing around with slick user interaction. Take a look at the site: http://www.ussu.net/epicentre and try using the link in the top-right of the window that either says ‘Where next boss?’ or ‘Log in?’ depending on whether you’re logged in or not.
Oh, and have an easter egg: Try clicking on the slogan “Shaking up events at Sussex!”…
Is it any wonder they tell me I’m pretty fly?
It’s been brought to my attention that I’ve not posted anything interesting in a while. Unfortunately this is a sad reflection of my present position, both in life, and with epicentre…. So I thought todays post would be less of a code snippet and more of a general note about writing a large piece of software.
As I’m approaching the first of many key deadlines I’ve less and less time to investigate cool new ways of tackling problems, and have to focus on tying everything together. This involves lots of code-repetition and lots of testing. Yawn.
I’ve become very distractable (there’s a whole internet out there) and quite irritable too. Like the pressure’s building, and I’m trying to ignore it.
I’m beginning to suspect that it’s altogether too easy, at times like these, to forget that it’s this boring graft that actually produces a useful product.
Take home message: Snippets are cool, but they don’t wash the dog.
My facebook status