vb.org Archive - 29K Posts Under Moderation

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)

- - 29K Posts Under Moderation - Unable to Moderate (https://vborg.vbsupport.ru/showthread.php?t=313742)

EvoDarrenshan

08-16-2014 09:07 PM

29K Posts Under Moderation - Unable to Moderate

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

08-16-2014 09:10 PM

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

08-16-2014 09:25 PM

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.

All times are GMT. The time now is 01:10 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01388 seconds Memory Usage 1,714KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (3)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: