Today I uploaded a quick update for 'These Automatic Arms': some small bug-fixes, a couple new levels, a new gameplay mechanic. It's still a 5-15 minute game, and I still don't know if it's worth fleshing out much further.
Had you the eyes with which to see it (and, of course, the arms with which to play) I think you'd enjoy the new crumbling walls. "They crumble like paper," you'd say. "Yes," I'd whisper back. "Like a real diary's paper?" "Yes, like a real book's paper, they crumble in the face of your obvious charms." "For I am the future, bright and cold?" "Yes, you are the future, my diary, my electronic diary. But show some humility. No one likes a braggart."
recreate the excitement as you give your own GDC lecture! Don't forget to advance the slides of your powerpoint presentation to rack up scoring multipliers!
EDIT: fixed click bug I hope. Thanks Alan!
Two player 1-button game. Avoid getting pushed to the left. Cry.
To be different I did a Wolfenstein level with a silly name. Has absolutely no relation to defunct female empowerment pop groups.
Also, up your butt 64kb image limitation I wanted that title screen red as Nazi blood not grey as silt.
My very first ZZT game :o
no action + very short + hastily translated from french to english
LOOSELY BASED on a REAL PERSON'S NEUROSES, NEUROSES is a VIDEO GAME about having NEUROSES and doing EVERYDAY TASKS.
Navigate your way through the exciting world of indie games!
An erotic (and interactive!) birthday card made in twine! Choose your own birthday adventure!
Made for Anna Anthropy, who recently had a birthday! Why not wish her a happy birthday in the comments?
Why not, indeed!
Arrows + space.
Made with a team for Molyjam NYC.
Monster sprite ripped from Monsters, Inc. GBA.
Music ripped from To the Moon.
Full credits in game.
So, the site was down for a couple of hours today, and it is going to be acting a little funny for the next little while. You will notice that pages will sit not loading for up to 20-30 seconds at a time, and then suddenly everything will work fine for a short while. This is expected and, sadly, appears to be unavoidable.
Shortest version: PHP is a hateful language and the source of all misery in the world.
Short version: don't try to delete 3.5 million rows from a table in MySQL all at once, especially one that's accessed every time someone visits a page on your website.
Longer version: When someone visits the site without a cookie (for instance, someone visiting the site for the first time, someone who has logged out and back in, spambots, viewing from seperate browsers, whatever), Drupal generates a random number for the client to use as its session identifier. It shoves this number into a database table, along with a timestamp of when it gave that number out. Every so often, it is meant to do a search for old, expired sessions, and clean them out of the database, because otherwise it would just grow and grow forever and become monstrously full of useless data.
This has not been happening. Ever. In the five years the site has been running.
It turns out that the "garbage collection" process controlled via an internal PHP configuration setting, which Debian Linux turns off because the way it works is kind of dumb (instead of being scheduled on a predictable basis, as would be sensible, it happens at random when someone tries to view a page). Unfortunately, the alternative they set up doesn't work with Drupal.
So I turned it on. And tried to load the site. And then it turns out that while it's cleaning up the session table, the site can't access it. And the site needs to access it on every pageview to see if you're logged in or not.
Well, I figured it had a lot of data to crunch through, so I decided to let it do its thing. And I waited. And waited. And 2.5 hours later it still wasn't done. I looked around online and decided that maybe the more sensible course of action was, instead of sorting through and deleting 600mb of data all at once, maybe I could write a little script to just delete a little at a time, and let other things talk to the database once in a while. Like my website.
So that's what it's doing. Unfortunately there's so much data to wade through that even deleting 1000 rows at a time takes like 20 seconds. This process will hopefully speed up as more old sessions get deleted, until eventually, sometime, maybe tomorrow?, there will be no noticeable pauses at all when browsing the site. Won't that be great? I'm looking forward to it.
Anyway, thought I'd let people know what was going on.