I've got about 390 threads that showed up in the moderation queue today... (out of no where) and I want to approve them all at once... does anyone know of a query to do it manually or a way to do it all at once in the web ui?
DELETE FROM xf_moderation_queue WHERE content_type = 'thread'
UPDATE xf_thread SET discussion_state = 'visible' WHERE discussion_state = 'moderated'
I think you'll have to clear the cache in the Data Registry too.But it doesn't update the Moderation Queue number shown in the screenshot above. I can't figure out how to update that number.
DELETE FROM xf_data_registry WHERE data_key = 'moderationCounts'