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:

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

[holwebs]

Thank you but HOW do I empty it?

If I look in phpmyadmin & browse the table there are '0' rows so I thought it was empty.

[Alfa1]

I am amazed that so few people have installed this mod. I guess it is because of the bugs that where in previous versions.

Please post your experience with the latest version.

[mattysheff]

This cause me errors with VBadvanced.

Database error in vBulletin 3.7.2:

Invalid SQL:
UPDATE vbadv_dyna_entries SET views = views+1 WHERE entryid =;

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 1
Error Number : 1064
Request Date : Thursday, August 14th 2008 @ 12:14:35 AM
Error Date : Thursday, August 14th 2008 @ 12:14:35 AM
Script : http://www.queeruk.net/guide/showentry.php?e=90
Referrer : http://www.queeruk.net/guide/
IP Address :
Username :
Classname : vB_Database_MySQLi
MySQL Version : 5.0.51a-community

[Cocko]

Originally Posted by Alfa1

I am amazed that so few people have installed this mod. I guess it is because of the bugs that where in previous versions.

Never tried this hack appearing in navbar menu.
I am still waiting for an update of quick moderation box for vBadvanced CMPS.

[FractalizeR]

Originally Posted by mattysheff

This cause me errors with VBadvanced.

Database error in vBulletin 3.7.2:

Invalid SQL:
UPDATE vbadv_dyna_entries SET views = views+1 WHERE entryid =;

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 1
Error Number : 1064
Request Date : Thursday, August 14th 2008 @ 12:14:35 AM
Error Date : Thursday, August 14th 2008 @ 12:14:35 AM
Script : http://www.queeruk.net/guide/showentry.php?e=90
Referrer : http://www.queeruk.net/guide/
IP Address :
Username :
Classname : vB_Database_MySQLi
MySQL Version : 5.0.51a-community

I don't think it is a problem of my hack.

[KURTZ]

nice job thx

[mattysheff]

Everything works fine without it. I enable your hack and then it stops working which is a shame.

[holwebs]

I now have 2 bugs

1. I cannot clear the Thread Notification=1, even though the moderation table is EMPTY (see my post above)

2. I have now enabled Calendar Moderations & although it correctly shows one event awaiting moderation, the link in the pull-down is not correct - it just goes go to "myforum.com/1" wheras as post notofications go to "myforum.com/moderation.php?do=viewposts&type=moderated"

The same happens for Users & Album pictures.

There doesn't seem to be an option on the User Profile to moderate events - is that right? Do you have to go to modcp? - it looks like the link should be to "myforum.com/modcp/moderate.php?do=events"

Please can you look. Thanks.

[FractalizeR]

2holwebs
#2 Bug fixed. xml reuploaded. Thank you for reporting.

But I still cannot fix your bug #1. On my forum all is shown correctly. Can you please execute the following SQL on your forum DB and tell me the result:

SELECT COUNT(type) AS count, type FROM moderation GROUP BY type

[holwebs]

Hi,

have redownloaded & bug with calandar events is now fixed thanks.

Have run the query on my dbase for table moderation as requested:

Showing rows 0 - 0 (1 total, Query took 0.0002 sec)

so you're right there is one row there but vB shows 'no threads to moderate'. I've reported it on vbulletin.com although I know I could delete it manually but I wonder if there is a bug there.