Thomas.B submitted a new resource:
Autocomplete Location Lite - Autocomplete for the location field
This add-ons makes it super easy for your members to state their location (city, state or country). Often the right location is already shown on the autocomplete list after the user entered only...
You can run these two queries to approve all moderated posts:
WHERE content_type = 'post';
SET message_state = 'visible'
WHERE message_state = 'moderated';
And here are the queries to approve all moderated threads:
You can run these queries to soft delete all moderated posts. You need to change the red pieces to attribute these deletions to a user_id and username, as well as give the reason. These things are recorded in the deletion log:
INSERT INTO xf_deletion_log (content_type, content_id, delete_date...
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 = (
FROM xf_post AS post
LEFT JOIN xf_thread AS thread ON (thread.thread_id = post.thread_id)...