vb.org Archive - Moderation Queue on FORUMHOME

Page 2 of 2

Show 40 post(s) from this thread on one page

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

- vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)

- - Moderation Queue on FORUMHOME (https://vborg.vbsupport.ru/showthread.php?t=120150)

Nudda

02-16-2007 10:20 PM

^^i second that

taydu

02-25-2007 02:22 AM

Thanks Acidburn, is there a way to not display moderation in certain forums in the moderation queue

Quote:

Originally Posted by acidburn0520 (Post 1167327)

Untested, but should work. ;)

Find in forumhome_moderationqueue:

Code:

<if condition="$permissions[modqueueperms] & $vbulletin->bf_ugp[modqueueperms][view_queue]">

Replace with:

Code:

<if condition="$permissions[modqueueperms] & $vbulletin->bf_ugp[modqueueperms][view_queue] OR $bbuserinfo['userid'] == 'xx'">

Replace xx with the UserID of the User you'd like to view the queue.

t325	03-30-2007 07:02 PM

It's working great in 3.6.5 for me. Thanks for the addon!

Muellmann

04-21-2007 12:36 AM

Thanks that's awesome and very useful.

snags204

05-11-2007 07:23 PM

Is there a way to add pm moderation from the pm mod. By https://vborg.vbsupport.ru/showthrea...=pm+moderation

jgommel

01-25-2008 10:08 PM

Seems to have installed okay other than I'm getting the following message at the top... "There are currently Array event(s) requiring your attention." Any ideas how to fix this?

Jafo232

05-01-2008 02:46 PM

This product is not working for 3.7, it throws the following error:

Quote:

Database error in vBulletin 3.7.0:

Invalid SQL:

SELECT COUNT(*) AS count
FROM moderation AS moderation
INNER JOIN post AS post USING (postid)
WHERE moderation.type='reply';

MySQL Error : Unknown column 'postid' in 'from clause'
Error Number : 1054

gopherhockey

05-12-2008 04:02 PM

Quote:

Originally Posted by Jafo232 (Post 1504628)

This product is not working for 3.7, it throws the following error:

I'd love to see an update...

Jafo232

05-12-2008 06:13 PM

ditto...

badboy_29

06-11-2008 09:01 PM

Is there any way to make this work with 3.7.1 Or does it and my site is just messed up.

Bacon Butty

06-12-2008 09:58 AM

Would be great if this could be available for 3.7.

Gondola

06-13-2008 04:29 AM

Also very interested in an update for this.

lostgirl815

06-24-2008 02:41 AM

Me too! It's really really handy. But in 3.7 it causes the forum home page to display a database error message. If you need more specific information I can enable it again and copy the source code. Anyway, posting so I'll know if it's available again. :)

Konstantinos

06-28-2008 03:28 AM

this is cool but u really need to add an option which stuff to be dispayed. for example there is no need for moderators to see how many users need moderation since they cant use user moderation

gopherhockey

08-25-2008 01:19 PM

Bump... anyone have this for 3.7? I can't believe it hasn't been updated or something similar hasn't been created.

DVDGuy

09-10-2008 06:07 AM

I managed to get this working with a bit of SQL hacking. The reason this stopped working in 3.7.x is because the "moderation" table has changed (from having separate threadid and postid columns, to now a single primaryid column).

I fixed it by editing "product-moderation_forumhome.xml"

Find:

PHP Code:


		
			
// ##### Posts to Moderate

if (can_moderate(0, 'canmoderateposts'))

{

$postcount = $db->query_first("

    SELECT COUNT(*) AS count

    FROM " . TABLE_PREFIX . "moderation AS moderation

    INNER JOIN " . TABLE_PREFIX . "post AS post USING (postid)

    WHERE moderation.type='reply'

");

Change:
INNER JOIN " . TABLE_PREFIX . "post AS post USING (postid)

To:
INNER JOIN " . TABLE_PREFIX . "post AS post ON post.postid=moderation.primaryid

Similarly, find:

PHP Code:


		
			
// ##### Threads to Moderate

$threadcount = $db->query_first("

    SELECT COUNT(*) AS count

    FROM " . TABLE_PREFIX . "moderation AS moderation

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

    WHERE moderation.type='thread'

");

Change:
INNER JOIN " . TABLE_PREFIX . "thread AS thread USING (threadid)

To:
INNER JOIN " . TABLE_PREFIX . "thread AS thread ON thread.threadid=moderation.primaryid

This makes the plugin work for me in 3.7.3.

epolitica

09-18-2008 08:21 AM

Quote:

Originally Posted by DVDGuy (Post 1618765)

DVDGuy, you're the man!

Thanks very much, I confirm it works under 3.7.3 :up:

badboy_29

09-26-2008 01:56 AM

I made the edits and they do work. Thank you for posting the changes.

Meestor_X

10-03-2008 08:15 PM

Is there a way to make this mod send a PM or e-mail when there are new items that need moderating? Saves having to continually log into the forum to check.

DrSnoCaps

10-29-2008 09:15 PM

Quote:

Originally Posted by Meestor_X (Post 1636741)

Is there a way to make this mod send a PM or e-mail when there are new items that need moderating? Saves having to continually log into the forum to check.

I'll second that!

cmd19872002

11-19-2008 04:59 AM

Tyvm DVDGuy

washingtonboise

01-27-2011 05:05 AM

Thread subscribed, standing by for version, compatibility, and development updates.

All times are GMT. The time now is 01:05 PM.

Page 2 of 2

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01342 seconds Memory Usage 1,766KB 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_code_printable (2)bbcode_php_printable (5)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (22)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: