29K Posts Under Moderation - Unable to Moderate

[EvoDarrenshan]

Hello,

I was wondering if there was a way to load moderated thread/posts in sets of a hundred per page instead of the full page because we currently have 29k un-moderated posts awaiting moderation but every time we try to load the page well... It doesn't load.

Thanks Darren.

[ozzy47]

How on earth did you manage to get 29k in moderated posts?
Is this from the ACP?
Are these posts or threads?
What action did you want to do with these posts?

[ozzy47]

Well it don't matter if it is threads or posts.

What you will need to do is open the file, modcp/moderate.php

In that file find the following:

PHP Code:

    $moderated = $db->query_read("
        SELECT *
        FROM " . TABLE_PREFIX . "moderation
        WHERE type IN ('thread', 'reply')
    "); 


And change it to this:

PHP Code:

    $moderated = $db->query_read("
        SELECT *
        FROM " . TABLE_PREFIX . "moderation
        WHERE type IN ('thread', 'reply')
        LIMIT 100
    "); 


That will limit the page to 100 results.