Moderators Functions - FractalizeR: Show items, awaiting moderation in notifications area

What does it do?
This hack shows all items, that require moderation in a notifications area. Items are grouped by type:

• Threads
• Posts
• Group messages
• Visitor messages
• Picture comments
• Album pictures
• Users
• Calendar events

Clicking on a group redirects you to a moderation panel for that type of items.

You can also restrict, what usergroups can see notifications and what items you want to appear in notifications

Russian localization included.

How to install?

1. Install *.xml file via Admin Control Panel (Product management)

Files description:

• product-fr_notifymoditems.xml - main product XML. English localization included.
• vbulletin-language-ru.xml - russian localization. Import as a language overwritting russian.

Version history:

06-11-2014)
 Attached a version by AUGI Web Team that fixes notification count for moderators with limited permissions.

11-05-2011)
 Attached a version by A825F933D42B with attachments moderation support.

4.02 (28-04-2010)
 Non-working option to show zero values removed due to 4.x incompatibility
 Russian translation fixed

4.01 (28-04-2010)
 Critical bug fixed that prevented notifications from being displayed
 Forums with custom admincp and modcp paths are now supported.

4.0 (26-04-2010)
 VBulletin 4.x release

1.1.3 (07-08-2008)
 VBDynamics (and several other addons) compatibility ensured (aproape)
 Non-standard admincp and modcp directories are now respected (aproape)

1.1.2 (07-08-2008)
 Links bug fixed in new features

1.1.1 (07-08-2008)
 Path bug fixed.

1.1 (06-08-2008)
 Added moderation items for calendar events, users and album pictures. Each item requires one (but very quick) additional query
 Added an option to show/hide empty notifications (with 0 items).
 Added an option to show only selected notifications

[RNArmstrong]

Uploading product-fr_notifymoditems.xml (11.0 KB, 744 downloads) does not work for me to remove the 3 extra Threads, awaiting moderation in the Notifications. Any other suggestions?

[kapii]

Why does this mod show a notification for threads or posts if the moderator can not see a particular forum?

[Wedframe]

Thanks! Great mod! Mark as installed! vB v4.2.2 PL3

@kapii , I think its your case:
https://vborg.vbsupport.ru/showpost....&postcount=118

[Wedframe]

Hello! I found some errore in this mod.
In my case, i was have one moderator which was not moderate at least one forume. This generate a database errore 1064 with your mod enabled.

SELECT COUNT(*) AS num
              FROM moderation AS moderation
              INNER JOIN post AS post ON (moderation.primaryid = post.postid)
              INNER JOIN thread AS thread ON (post.threadid = thread.threadid)
              WHERE type = 'reply' AND forumid IN (  );

MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 5

I dont know, this errore of mod, or guilty of admin))) but this point exist.....

[Delfi_r]

I've installed on two 4.2.2pl4 forums. One is loaded of plugins, the other is lightweight. On both the installation of the last revision of this useful mod makes the login process impossible with fatal database error.

There are other requirements or known incompatible plugins?

[Delfi_r]

The problem it's not there on the A825F933D42B version

[My Hattiesburg]

For a long time now the notification has shown 1 visitor message and 15 posts need moderation but those items are nowhere to be found. Is there any way to reset those to 0?

[MarkFL]

Originally Posted by My Hattiesburg

For a long time now the notification has shown 1 visitor message and 15 posts need moderation but those items are nowhere to be found. Is there any way to reset those to 0?

In the AdminCP, go to Maintenance -> Execute SQL Query

and run the manual query:

truncate moderation;

This will clear that table and remove the errant entries.

[My Hattiesburg]

Originally Posted by MarkFL

In the AdminCP, go to Maintenance -> Execute SQL Query

and run the manual query:

truncate moderation;

This will clear that table and remove the errant entries.

I've never executed an SQL query before so I was a little hesitant, but that fixed it. Thanks!

[My Hattiesburg]

Originally Posted by Wedframe

Hello! I found some errore in this mod.
In my case, i was have one moderator which was not moderate at least one forume. This generate a database errore 1064 with your mod enabled.

SELECT COUNT(*) AS num
              FROM moderation AS moderation
              INNER JOIN post AS post ON (moderation.primaryid = post.postid)
              INNER JOIN thread AS thread ON (post.threadid = thread.threadid)
              WHERE type = 'reply' AND forumid IN (  );

MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 5

I dont know, this errore of mod, or guilty of admin))) but this point exist.....

I had been using the 4.02 version for awhile and never had any problems (except for the count being wrong but thanks to MarkFL for his help in fixing that) so I decided to install the 4.03 version and got the exact same problem. One of our owners got this error and couldn't log in until I disabled it. Going to go back to a previous version to see if it still works.