It would be nice to change the topic state from the command line.
For example, here a code review is required prior to code check in. The code review must be in the APPROVED state before the check in can proceed. Once the code has been successfully checked in, the topic state should change from APPROVED to SUBMITTED. Certainly there is no need for the reviewer(s) or an admin to manually change the state from APPROVED to SUBMITTED.
I'm on the cusp of getting a localized customization to version 1.9.2 accomplished here that does that. I'm trying to maintain the same object and model style and making certain that the database remains consistent.
For example, just changing the "state" column of the "topic" table in the "codestrikerdb" database would make the database inconsistent because I had not updated the topicstatehistory table (and others?) along with the topic table.
Since my SQL, DBI, Perl and OO are all rusty, I'm proceeding cautiously here.