It’s time to make the bad man stop.
I promised a script to make it easy to close comments in Movable Type 2.x a few days ago, and I’ve finally found a few minutes to finish it off. It’s written in PHP and it’s available right here. My working installation is here (but you need the login and pass to use it). It’s still in beta phase. Here are the requirements for use:
- You don’t hold me responsible if something horribly bad happens
- You’re using Movable Type 2.x. (I don’t yet know if this works with MT 3.x. Anyone wanna take a look? It should be easy to make it work unless they changed the database structure a lot.)
- You’re using a MySQL database (version 4.x?) on the back end (Movable Type supports other kinds too, but MySQL is probably the most popular database for MT).
- You know the login and password to your MySQL database. Note: This is not necessarily your MT login. This is the login and pass used to access your MySQL database directly. If you’re not in charge of your database, you may need to ask your database admin to run this for you.
- You must put this script on the server that hosts the database it will be run against. (Translated into Geekish: this script assumes you want to use “localhost”).
I’ve already used the script on this blog, and it worked flawlessly. It’s ridiculous how easy it is to use. Just go through the script, and rebuild your blog. Done. The whole process takes far less than a minute.
This script asks you to select which database you want to query if you have multiple databases in your MySQL installation. It also asks you which blogs you want to affect if you have multiple blogs. I would love it if a few geeks out there with knowledge of PHP and MySQL could help me test this thing out. Just comment out line #130 (at least in the script’s current iteration) and the script won’t do a thing to your database, so it’ll be safe to test. It’s well-commented, so you should be able to follow it. I especially need someone to test this that has multiple databases in their installation of MySQL, and has different MT installations in each database. I don’t have the setup to test that scenario.
I look forward to hearing your feedback! Tell your friends about this (after you’ve seen a few success messages aside from mine, of course) if you think it might be useful to them.