discussion

This simple addon shows a moving flame icon on thread list. Manage your hot threads with the thread reply counts. You can control your hot threads with the style properties . Just select a moving image with .gif extension according to the number of answers. Image size should be 16x16px.

You can run these two queries to approve all moderated posts: DELETE FROM xf_moderation_queue WHERE content_type = 'post'; UPDATE xf_post SET message_state = 'visible' WHERE message_state = 'moderated'; And here are the queries to approve all moderated threads: DELETE FROM xf_moderation_queue...

This will recalculate and update the post counts for all users at once. This is a large query that may take a while to finish. UPDATE xf_user AS user SET message_count = ( SELECT COUNT(*) FROM xf_post AS post LEFT JOIN xf_thread AS thread ON (thread.thread_id = post.thread_id)...