Clean MT Comments
Since MT-Blacklist does not work with my Movable Type installation and the MT admin interface for comments is slow as fuck I created my own interface for removing comments.
I started out by entering SQL queries directly into PostgreSQL shell and then created a simple XHTML interface for it. The UI shows a table with some of the columns of the DB table and at the top of the table there are text inputs where you can filter the rows. When the text in the inputs change a new query is sent to the web server and the data is updated with the results.
September 24th, 2004 at 13:08
Oopops, I guess I managed to delete all comments from 2004-09-*. At least I hope I did that, otherwise it means someone knows my password.
September 25th, 2004 at 11:25
Heh, too bad.
By the way, if it already is Moz-only, why not in XUL?
September 26th, 2004 at 10:37
Good question. The answer is that I’m not that good with XUL yet and trees in XUL are not as easy to use as a sortable table. The table I got cannot really be replaced with a XUL tree. It could possibly be replaced by a XUL grid (or some other elements) though.
September 28th, 2004 at 13:52
this really is too damn kewl, man…. very nice work!
really impressed with just how fast it works… wow. too bad it’s Moz-only, tho… *chuckle*
/takes a peak at your XSL
June 1st, 2005 at 19:27
lol