trac mysql schema optimization

For anyone using Trac with the MySQL database backend, check out this ticket: http://trac.edgewall.org/ticket/6986

I applied the database schema changes on the MobileScrobbler trac site, and it’s reduced the time it takes to modify or create a ticket from several seconds down to less than a second. Finally, no more error 500 pages when an operation takes too long to complete!

DreamZZT update

I made a bit of progress on DreamZZT. You can now adjust the game speed and the sound volume from the title screen:

I’ve also integrated the Trac ticket system into the game. When loading a game, it will check to see if any tickets are open that affect that game, and show you a warning with a list:

You can view the details of a specific bug by selecting it:

Also, you can submit new bug reports from inside the game:


Creating bugs from the game will automatically record the version, platform, game, and board, as well as attaching a save of your game.