[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.