You can approve them all with SQL, but first, you need to find out why they need approval. Are you using the Newly Registered users group? Does your registered users group require approval? Why is this happening?
But here is the SQL:
Executing SQL Queries in phpMyAdmin
Code: Select all
UPDATE phpbb_posts SET post_visibility = 1 WHERE post_visibility = 0;
UPDATE phpbb_topics SET topic_visibility = 1 WHERE topic_visibility = 0;
UPDATE phpbb_topics SET topic_posts_approved = topic_posts_unapproved + topic_posts_unapproved;
UPDATE phpbb_topics SET topic_posts_unapproved = 0 WHERE topic_posts_unapproved > 0;
If your table prefix is NOT
Disable the board in the ACP before running this AND BACKUP the users, posts and topics tables BEFORE running this SQL.
After you run this, Resync the post counts and statistics in the ACP, General tab.
Test everything thoroughly before re-enabling the Board. If there are any issues, restore your backups and post back here.