I want to accept a spam comment and then delete it, rather than marking it as spam in the moderation queue.
My problem is once I do this, this particular comment author will now be able to make comments without going through the moderation queue. (My comments option is set to old comment authors are ok to post comments)
My solution is to edit the database in PhpAdmin - table "wp_comments" directly and change the setting from approved to spam.
Is this ok to mess with the database directly or is there a better method?
The reason I'm doing this is because of a bug in the "DG Review Site Plug In" which records a rating even in the moderation queue, but doesn't change it back to the original ratings unless the comment is accepted first.
Thanks for any help/advice.