vb.org Archive - Forum Home Enhancements - SCANU's Quick Moderation: Moderation queue info on Forum home

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

- vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)

- - Forum Home Enhancements - SCANU's Quick Moderation: Moderation queue info on Forum home (https://vborg.vbsupport.ru/showthread.php?t=285008)

Updated to 1.1: Less code and more compatibility with custom styles

Code:

database error in vBulletin 4.2.0:



Invalid SQL:

SELECT COUNT(*) AS count FROM blog WHERE state = 'moderation';



MySQL Error   : Table '*******_vbulletin.blog' doesn't exist

Error Number  : 1146

Request Date  : Friday, July 27th 2012 @ 11:43:27 PM

Error Date    : Friday, July 27th 2012 @ 11:43:27 PM

Script        : ****************

Referrer      : 

IP Address    : &***********

Username      : ************

Classname     : ************

MySQL Version : 5.5.24-cll

That's when i installed 1.1.......

Do you have blog on your site?

Quote:

Originally Posted by Scanu (Post 2351983)

Do you have blog on your site?

Nope i only have retail forum.

I thought just ad publishing suite.. :( Wait for an update and i will fix cms and blog problems

This looks awesome. Can't wait to install and give it a try.

Looking forward to the update. Doesn't work for me currently on 4.1.12 PL2. Keeps giving database errors since I don't have a blog, only the regular forum.

Thanks SCANU!

I would like to do it but unfortunately my macmini is dead :( but i will found a way to update this mod and "warning to users awaiting moderation"

Updated to 1.2 now i have fixed all that blog errors :) So if you have the blog just go in quick moderation settings and set blog option to off

Quote:

Originally Posted by Scanu (Post 2353315)

Updated to 1.2 now i have fixed all that blog errors :) So if you have the blog just go in quick moderation settings and set blog option to off

Thanks for the update but this still doesn't work for me.

The database errors no longer show up but the auto template option being on or off doesn't make a difference and nothing different shows up.

I would suggest you make the blog being off as the default option as I don't think most people use the blog and if they enable your plugin they will get a database error due to its default settings.

Also, your plugin doesn't have a descriptive title that shows up under the Settings in the ACP. It is just a blank line.

I'm disabling this for now until an update can get it working.

Thank you!

All suggestions are appreciated however after you disable autotemplate you have to put {vb:raw quickmod_template} wherever you want on forumhome template.

Ok thanks I will try that. Any idea on how to fix the blank line in ACP? Thanks!

Update does not work with retail forum 4.2.0....

Code:

Database error in vBulletin 4.2.0:



Invalid SQL:

SELECT COUNT(*) AS count FROM blog WHERE state = 'moderation';



MySQL Error   : Table '**********_vb1.blog' doesn't exist

Error Number  : 1146

Request Date  : Saturday, August 4th 2012 @ 09:47:30 PM

Error Date    : Saturday, August 4th 2012 @ 09:47:30 PM

Script        : ******************************

Referrer      : 

IP Address    : ************

Username      : **********

Classname     : vB_Database

MySQL Version : *********

Quote:

Originally Posted by AK47- (Post 2354437)

Update does not work with retail forum 4.2.0....

Code:

Database error in vBulletin 4.2.0:



Invalid SQL:

SELECT COUNT(*) AS count FROM blog WHERE state = 'moderation';



MySQL Error   : Table '**********_vb1.blog' doesn't exist

Error Number  : 1146

Request Date  : Saturday, August 4th 2012 @ 09:47:30 PM

Error Date    : Saturday, August 4th 2012 @ 09:47:30 PM

Script        : ******************************

Referrer      : 

IP Address    : ************

Username      : **********

Classname     : vB_Database

MySQL Version : *********

If you don't have a blog, you need to disable the blog feature in this product's settings in AdminCP -> Settings -> Options

Quote:

Originally Posted by RedTurtle (Post 2354438)

If you don't have a blog, you need to disable the blog feature in this product's settings in AdminCP -> Settings -> Options

Good work op it's works. You should make it clear on the thread. Nominated thread :)

doesn't work for me. using vbul Forum 4.2.0

have been using auto-template and manual, and both (manual+auto add template). Shows nothing...

Do you have the template "Quick moderation Template"

Quote:

Originally Posted by Scanu (Post 2356573)

Do you have the template "Quick moderation Template"

do you mean after installing the mod? haven't checked it yet.

Yes after installing the mod please check it

Quote:

Originally Posted by Scanu (Post 2356609)

Yes after installing the mod please check it

yes I have. what should i do now? ( my version is 4.2)

oh and btw, the options has no name (see attachment)

Quote:

Originally Posted by nyenius (Post 2356610)

yes I have. what should i do now? ( my version is 4.2)

oh and btw, the options has no name (see attachment)

Yes i know it's a strange bug for me too, however after you choose manual template edit you have to put {vb:raw quickmod_template} wherever you want on forumhome template. Did you add it?!

Quote:

Originally Posted by Scanu (Post 2356615)

Yes i know it's a strange bug for me too, however after you choose manual template edit you have to put {vb:raw quickmod_template} wherever you want on forumhome template. Did you add it?!

done it, no effect.

Mmh cold you paste you forumhome template?

Nice mod.

Just a couple of things:

*Attachments aren't entered under "vbulletin preregister" so a number doesn't show up, need to add

Code:

'attachments' => $attachments,

*No name in vbulletin settings, just a blank space, need to put this code into the <phrases> group

Code:

<phrase name="settinggroup_quickmod_settings"><![CDATA[SCANU's Quick Moderation Settings]]></phrase>

Quote:

Originally Posted by Scanu (Post 2356845)

Mmh cold you paste you forumhome template?

HTML Code:

{vb:stylevar htmldoctype}

<html xmlns="http://www.w3.org/1999/xhtml"<vb:if condition="$vboptions['enablefacebookconnect']"> xmlns:fb="http://www.facebook.com/2008/fbml"</vb:if> dir="{vb:stylevar textdirection}" lang="{vb:stylevar languagecode}" id="vbulletin_html">

<head>

        {vb:raw headinclude}

        <title>{vb:raw vboptions.bbtitle}</title>

        <script type="text/javascript" src="clientscript/vbulletin_read_marker.js?v={vb:raw vboptions.simpleversion}"></script>

        <vb:if condition="$vboptions['storecssasfile']">

        {vb:cssfile forumhome-rollup.css}

        <vb:else />

        {vb:cssfile forumbits.css,forumhome.css,options.css}

        </vb:if>

        <!--[if lt IE 8]>{vb:cssfile forumbits-ie.css,options-ie.css}<![endif]-->

        <vb:if condition="$show['sidebar']">

        {vb:cssfile sidebar.css,widgets.css,tagcloud.css}

        <!--[if lt IE 8]>{vb:cssfile sidebar-ie.css}<![endif]-->

        <script type="text/javascript">

        <!--

                document.write('<script type="text/javascript" src="' + yuipath + '/animation/animation-min.js?v={vb:raw vboptions.simpleversion}"></script>');

                var sidebar_align = '{vb:raw show.sidebarposition}';

                var content_container_margin = parseInt('{vb:math {vb:stylevar forum_sidebar_width}+{vb:math {vb:stylevar padding}*2}}');

                var sidebar_width = parseInt('{vb:stylevar forum_sidebar_width}');

        //-->

        </script>

        <script type="text/javascript" src="{vb:raw vboptions.bburl}/clientscript/vbulletin-sidebar.js?v={vb:raw vboptions.simpleversion}"></script>

        </vb:if>

        {vb:raw headinclude_bottom}

</head>

        <body>



        {vb:raw header}



        {vb:raw navbar}



        <div id="pagetitle">

                <h1>{vb:raw vboptions.bbtitle}</h1>

                <p id="welcomemessage" class="description">{vb:rawphrase welcome_to_the_x, {vb:raw vboptions.bbtitle}}</p>

        </div>



        <vb:if condition="$show['sidebar']">

        <div id="content_container" class="{vb:raw $sidebar_class} <vb:if condition="$show['sidebarposition'] == 'left'">contentright</vb:if>">

                <div id="content" <vb:if condition="$sidebar_class">class="{vb:raw $sidebar_class}"</vb:if>>

        </vb:if>

        <!-- main -->

        {vb:raw template_hook.forumhome_above_forums}

        <ol id="forums" class="floatcontainer">

                {vb:raw forumbits}

        </ol>

        {vb:raw template_hook.forumhome_below_forums}

        <!-- /main -->



        <div class="navlinks">

        <a href="{vb:raw $vboptions.vbforum_url}{vb:if "$vboptions['vbforum_url']", '/', ''}forumdisplay.php?{vb:raw session.sessionurl}do=markread&amp;markreadhash={vb:raw bbuserinfo.securitytoken}" rel="nofollow">{vb:rawphrase mark_forums_read}</a>

        <vb:if condition="$vboptions['forumleaders']">|

        <a href="showgroups.php{vb:raw session.sessionurl_q}" rel="nofollow">

                <vb:if condition="$vb_suite_installed">

                        {vb:rawphrase view_site_leaders}

                <vb:else />

                        {vb:rawphrase view_forum_leaders}

                </vb:if>

        </a></vb:if>

        </div>

        {vb:raw ad_location.board_after_forums}

        <!-- what's going on box -->

        <div id="wgo" class="collapse wgo_block block">

                <h2 class="blockhead">{vb:rawphrase whats_going_on}</h2>

                <div class="blockbody formcontrols floatcontainer">

                        {vb:raw template_hook.forumhome_wgo_pos1}

                        <vb:if condition="$show['loggedinusers']">

                        <!-- logged-in users -->

                        <div id="wgo_onlineusers" class="wgo_subblock section">

                                <h3 class="blocksubhead"><img src="{vb:stylevar imgdir_misc}/users_online.png" alt="{vb:rawphrase currently_active_users}" />{vb:rawphrase currently_active_users}</h3>

                                <div>

                                        <p>{vb:rawphrase there_are_x_y_online_link, {vb:raw totalonline}, {vb:raw session.sessionurl_q}} <span class="shade">{vb:rawphrase x_members_and_y_guests, {vb:raw numberregistered}, {vb:raw numberguest}}</span></p>

                                        <p>{vb:rawphrase most_users_ever_online_was_x_y_at_z, {vb:raw recordusers}, {vb:raw recorddate}, {vb:raw recordtime}}</p>

                                        <vb:if condition="$activeusers">

                                        <ol class="commalist" id="wgo_onlineusers_list">

                                                <vb:each from="activeusers" value="loggedin">

                                                        <li>{vb:stylevar dirmark}<a class="username" href="{vb:link member, {vb:raw loggedin}}">{vb:raw loggedin.musername}</a>{vb:raw loggedin.invisiblemark}{vb:raw loggedin.buddymark}{vb:raw loggedin.comma}</li>

                                                </vb:each>

                                        </ol>

                                        </vb:if>

                                </div>

                        </div>

                        <!-- end logged-in users -->

                        </vb:if>

                        {vb:raw template_hook.forumhome_wgo_pos2}

                        <!-- Start Members Today -->

                        <vb:if condition="$show['wgo_members']">

                        <div id="wgo_wgo_members_users" class="wgo_subblock section collapse">

                                <h3 class="blocksubhead"><a href="{vb:raw wgo_members.url}"><img src="{vb:stylevar imgdir_misc}/forum_stats.png" alt="{vb:phrase wgo_members_alt_title}"/></a>{vb:raw wgo_members.whotitle}</h3>

                                <a class="collapse" id="collapse_wgo_members_list" href="{vb:raw relpath}#top"><img src="{vb:stylevar imgdir_button}/collapse_40b{vb:raw wgo_members.collapse}.png" alt="" title="{vb:rawphrase collapse_expand}" /></a>

                                <div id="wgo_members_list" {vb:raw wgo_members.style}>

                                        <p>{vb:raw wgo_members.visitors}</p>

                                        <vb:if condition="$vboptions['wgo_members_names']">

                                                <vb:if condition="$wgo_members['totaltoday'] == 0">

                                                        {vb:phrase no_members_list} 

                                                <vb:else />

                                                        <ul class="commalist" id="wgo_wgo_members_list">

                                                                <vb:if condition="$wgo_members['template_hook']">

                                                                        {vb:raw wgo_members.template_hook}

                                                                <vb:else />

                                                                        <vb:each from="wgo_members_list" value="row">

                                                                                <li>{vb:stylevar dirmark}<a class="username" href="{vb:link member, {vb:raw row}}" title="{vb:raw row.wrdate}">{vb:raw row.musername}</a>{vb:raw row.markinv}{vb:raw row.comma}</li>

                                                                        </vb:each>

                                                                </vb:if>

                                                        </ul>

                                                </vb:if>

                                        <vb:else />

                                                {vb:phrase member_list_disabled} 

                                        </vb:if>

                                </div>

                        </div>

                        </vb:if>

                        <!-- End Members Today -->

                        {vb:raw template_hook.forumhome_wgo_pos6}

                        <vb:if condition="$show['upcomingevents']">

                        <div id="wgo_events" class="wgo_subblock section">

                                <h3 class="blocksubhead"><img src="{vb:stylevar imgdir_misc}/event.png" alt="{vb:rawphrase todays_events}" /><vb:if condition="$show['todaysevents']">{vb:rawphrase todays_events}<vb:else />{vb:rawphrase upcoming_events_for_the_next_x_days, {vb:raw vboptions.showevents}}</vb:if></h3>

                                <ol>

                                        {vb:raw upcomingevents}

                                </ol>

                        </div>

                        </vb:if>

                        {vb:raw template_hook.forumhome_wgo_pos3}

                        <vb:if condition="$show['birthdays']">

                        <!-- today's birthdays -->

                        <div id="wgo_birthdays" class="wgo_subblock section">

                                <h3 class="blocksubhead"><img src="{vb:stylevar imgdir_misc}/birthday.png" alt="{vb:rawphrase todays_birthdays}" />{vb:rawphrase todays_birthdays}</h3>

                                <ol class="commalist">

                                        <vb:each from="birthdays" value="row">

                                                <li><a href="{vb:link member, {vb:raw row}}">{vb:raw row.username}</a><vb:if condition="$row['age']"> ({vb:raw row.age})</vb:if>{vb:raw row.comma}</li>

                                        </vb:each>

                                </ol>

                        </div>

                        <!-- end today's birthdays -->

                        </vb:if>

                        {vb:raw template_hook.forumhome_wgo_pos4}

                        <div id="wgo_stats" class="wgo_subblock section">

                                <h3 class="blocksubhead"><img src="{vb:stylevar imgdir_misc}/forum_stats.png" alt="{vb:rawphrase x_statistics, {vb:raw vboptions.bbtitle}}" />{vb:rawphrase x_statistics, {vb:raw vboptions.bbtitle}}</h3>

                                <div>

                                        <dl>

                                                <dt>{vb:rawphrase threads}</dt>

                                                        <dd>{vb:raw totalthreads}</dd>

                                                <dt>{vb:rawphrase posts}</dt>

                                                        <dd>{vb:raw totalposts}</dd>

                                                <dt>{vb:rawphrase members}</dt>

                                                        <dd>{vb:raw numbermembers}</dd>

                                                <vb:if condition="$show['activemembers']">

                                                        <dt>{vb:rawphrase active_members}</dt>

                                                        <dd>{vb:raw activemembers}</dd>

                                                </vb:if>

                                        </dl>

                                        <p>{vb:rawphrase welcome_to_our_newest_member_x, {vb:link member, {vb:raw newuserinfo}}, {vb:raw newuserinfo.username}}</p>

                                        {vb:raw template_hook.forumhome_wgo_stats}

                                </div>

                        </div>

                        <div id="wgo_legend" class="wgo_subblock section">

                                <h3 class="blocksubhead"><img src="{vb:stylevar imgdir_misc}/legend.png" alt="{vb:rawphrase icon_legend}" />{vb:rawphrase icon_legend}</h3>

                                <div>

                                        <dl id="icon_legends" class="icon_legends">

                                                <dt><img src="{vb:stylevar imgdir_statusicon}/forum_new-16.png" alt="{vb:rawphrase new_posts_forum}" /></dt><dd>{vb:rawphrase new_posts_forum}</dd>

                                                <dt><img src="{vb:stylevar imgdir_statusicon}/forum_old-16.png" alt="{vb:rawphrase no_new_posts_forum}" /></dt><dd>{vb:rawphrase no_new_posts_forum}</dd>

                                                <vb:if condition="$vboptions['showlocks']"><dt><img src="{vb:stylevar imgdir_statusicon}/forum_lock-16.png" alt="{vb:rawphrase forum_is_closed_for_posting}" /></dt><dd>{vb:rawphrase forum_is_closed_for_posting}</dd></vb:if>

                                                <dt><img src="{vb:stylevar imgdir_statusicon}/category-16.png" alt="{vb:rawphrase category_forum}" /></dt><dd>{vb:rawphrase category_forum}</dd>

                                                <dt><img src="{vb:stylevar imgdir_statusicon}/forum_link-16.png" alt="{vb:rawphrase link_forum}" /></dt><dd>{vb:rawphrase link_forum}</dd>

                                        {vb:raw template_hook.forumhome_icon_legend}

                                        </dl>

                                </div>

                        </div>

                        {vb:raw template_hook.forumhome_wgo_pos5}

                </div>

        </div>

        <!-- end what's going on box -->



        {vb:raw ad_location.board_below_whats_going_on}

        <vb:if condition="$show['sidebar']">

                </div>

        </div>



        <div id="sidebar_container" class="<vb:if condition="$show['sidebarposition'] == 'left'">sidebarleft</vb:if><vb:if condition="$close_sidebar"> sidebar_closed</vb:if>">

                <a id="sidebar_button_link" href="#">

                        <vb:if condition="$show['sidebarposition'] == 'left'">

                        <img id="sidebar_button" src="{vb:stylevar imgdir_misc}/<vb:if condition="$close_sidebar">tab-expanded-left.png<vb:else />tab-collapsed-left.png</vb:if>" alt="" />

                        <vb:else />

                        <img id="sidebar_button" src="{vb:stylevar imgdir_misc}/<vb:if condition="$close_sidebar">tab-expanded.png<vb:else />tab-collapsed.png</vb:if>" alt="" />

                        </vb:if>

                </a>

                <ul id="sidebar" <vb:if condition="$close_sidebar">class="sidebar_hidden"</vb:if> >

                        {vb:raw sidebar}

                </ul>

        </div>

        </vb:if>

        <script type="text/javascript">

        <!--

        vbphrase['doubleclick_forum_markread'] = "{vb:rawphrase doubleclick_forum_markread}";

        init_forum_readmarker_system();

        //-->

        </script>

        {vb:raw footer}

</body>

</html>

I don't see {vb:raw quickmod_template} in that themplate

Quote:

Originally Posted by Scanu (Post 2357718)

I don't see {vb:raw quickmod_template} in that themplate

No i've added it below 'navbar'

HTML Code:

        <body>



        {vb:raw header}



        {vb:raw navbar}

{vb:raw quickmod_template}

still nothing shows

Fiuhhh Scanu, I finally found the culprit. The usergroup (admin, moderator/supermods), has to be the primary usergroup for the person to be able to see the quick moderation panel....

I'm sorry for all the trouble, it is a great mod!!!

rated 5 stars!

Thank you :) :) :)

Is there a way that secondary usergroups could also be included please?

Today, i try to create a dummy moderator for certain forum with 1 unapproved post. Instead of showing 1 unapproved post, the quick mod panel shows total number of all unapproved posts in the board (more than one).

Not an annoying problem for me, I still can explain it. But it would be nice if there any solution to this ;)

With Scanu's assistance I integrated this plugin into my Spam-O-Matic Statistics plugin and have the number of threads and posts that are awaiting moderation show up in the same place as the Spam-O-Matic statistics do.

I've always had the issue of not knowing when stuff is in the moderation queue and not going into the AdminCP or ModCP enough to check. I don't like the idea of users having posts stuck in moderation for a long period of time so I wanted something that quickly catches my attention when I visit the page.

Using some conditional statements I have it so that it only shows up if the number is greater than 0 and also is only viewable by admins and moderators. The entire phrase completely disappears if there are 0 items in the queue.

Also, just because I am a little OCD about being a perfectionist, the word Thread/Post/etc become pluralized (Threads/Posts) when the count is greater than 1.

Really would love to use this mod.
Installed the latest version and manually edited the template.
Shows fine but unfortunately no numbers show up.

What could be wrong?
Any help appreciated
Michael

Could you add an option to also send an email or a PM to Moderators
when there something in the Awaiting Moderation Queue?

Quote:

Originally Posted by apsrfvb4 (Post 2372604)

Could you add an option to also send an email or a PM to Moderators
when there something in the Awaiting Moderation Queue?

A lot of us would love to have this option.

This mod is awesome! Working in VB4.2. I have marked as installed.

As other people have said the mod's name is blank in the ACP > Options > Settings

Also it was showing up 13 Threads in moderation at first, due to 13 old entries that I had in the moderation table with threads that no longer existed. I simply deleted these entries from the moderation table and all is good now!

Another upgrade for this mod would be to have the text bold when something is in the queue

I want to use this mod, but the box is empty in my forum.

I have the same issue. mine was working fine & now it's empty??

No options page in ACP > Options > Settings

Could really use this, doesn't work however. No options in the AdminCP, box in blank in the forums.

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01499 seconds Memory Usage 1,911KB 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 (5)bbcode_code_printable (2)bbcode_html_printable (11)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (40)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 pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: