Minecraft multiplayer is fun, but playing it quickly grows old. Without the challenges imposed by server-side health, enemy mobs, and the tempting, easily-available /item spawn command, it doesn’t pose a whole lot of challenge for a server admin. Running the server is interesting, though.
Today, I’m working on moving the backend configuration to MySQL out of flat files. That part is done. I wrote a script to parse the text files and insert them into tables, restarted the server, and everything seems pretty okay, with the exception of some duplicate entries in the groups table, and some leftovers in the user table. I’m rewriting the “contributor” script, which will promote users from “regular” to “member”, the premium rank.
2 subscriptions so far. Rolling in the dough!
Still to do: add Google adsense ads to the global WordPress template, and then fix the Paypal registration script. Currently it doesn’t renew subscriptions properly.
2 replies on “Moving to MySQL”
I run a minecraft server at my house, and am trying to move from a flatfile into mySQL and was hoping you would be willing to share your script that let you move over to the DB.
Probably should have posted it – http://novylen.net/~minecraft/scripts/ has the script I used.
It is provided as-is, and may require some hacking to get it to work.