vb.org Archive - Moderation Feature & Coding

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

- vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)

- - Moderation Feature & Coding (https://vborg.vbsupport.ru/showthread.php?t=64594)

Moderation Feature & Coding

I asked this over at vb.com but I didn't get a reply. So I am now asking it here.

Ok let me give you some background information before I ask the question. Currently I have a forum section called NASCAR News which is setup to moderate all new threads. It is sorta of a pain having to go into the admin or mod cp to find out if there is any new moderated threads. The reason why I am doing this is because the NASCAR News shows up on my front page/vbindex page. I have a Main Menu block which is just a custom template

Currently the Main Main looks like this

Home
Forums
Links
Contact Us
Submit News
Admin Control Panel

What I am wanting to to do is add a number next to the "Admin Control Panel" link and to tell me that there is new threads to be moderated. Like this...

Home
Forums
Links
Contact Us
Submit News
Admin Control Panel (1)

Basically just pulling information from the database, etc and have it displayed as a number. And this number tells me if I have any moderated threads. I have tried severals thing, but I can't get it to work. Any suggestions would be helpful. Or I am even willing to pay someone for this.

PHP Code:


		
			
if (can_moderate()) {

    $queryids = array(0);

    foreach($imodcache AS $value) {

        foreach($value AS $userid) {

            if ($userid['userid'] == $bbuserinfo['userid']) {

                $queryids[] = $userid['forumid'];

            }

        }

    }



    $getposts = $DB_site->query_first("

        SELECT COUNT(*) AS total

        FROM ".TABLE_PREFIX."moderation AS moderation

        LEFT JOIN ".TABLE_PREFIX."thread AS thread USING(threadid)

        WHERE thread.forumid IN(".implode(',', $queryids).")

    ");



    if (!empty($getposts['total'])) {

        eval('$moderatepopup = "' . fetch_template('moderate_popup') . '";'); //change this

    }

}

Taken from my forums index.php, checks if there are any outstanding posts awating moderation in any of the forums the current user moderates. Change the fetch_template() line to do whatever you want if there are any posts awating.

I got this to work on the forumhome page of vbulletin.

In 'forums/index.php'
Find

PHP Code:


		
			
// ### ALL DONE! SPIT OUT THE HTML AND LET'S GET OUTA HERE... ###

Add Above:

PHP Code:


		
			
        $threadcount = $DB_site->query_first("

                SELECT COUNT(*) AS count

                FROM " . TABLE_PREFIX . "moderation

                WHERE type='thread'"

        );

Now add '$threadcount[count]' (with out quotes) to your forumhome template and it will display the number of new threads that need to be moderated.

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (3)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:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.00980 seconds Memory Usage 1,723KB 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 (3)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: