The Arcive of Official vBulletin Modifications Site.

About Developer · **Released**: 04-25-2010

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:

Code:

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

Venlaw · #**132** 05-24-2015, 11:12 AM

Quote:

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.

Code:

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.....

Same issue here. Finally got around to shutting off my site and finding this plugin was the cause of my login issues.

Wedframe · #**133** 06-07-2015, 06:28 PM

Venlaw, My Hattiesburg

Quote:

In my case, i was have one moderator which was not moderate at least one forum.

Exactly this moderator could not login to forum, because of receiving the DB-error.
So,.. for me, the solution of the problem was - to assign him to moderate any forum section. After this problem has been resolved.

Wedframe · #**134** 06-08-2015, 06:02 AM

I create new version of plugin. This version based on product-fr_notifymoditems-4_0_3_by_AUGI.xml with added blog entries in moderation queue.

Gizmo99 · #**135** 08-29-2015, 07:01 PM

product-fr_notifymoditems (A825F933D42B).xml

Works on 4.2.3

GIz

Stratis · #**136** 09-16-2015, 03:12 PM

Avatar is ok in thread moderate, but not shown up in post moderate.
Is this issue only to me? if its not, did any one fixed this issue?

Thanks

djbaxter · #**137** 12-22-2015, 08:59 PM

Quote:

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.

Code:

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.....

Quote:

Originally Posted by My Hattiesburg

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.

Quote:

Originally Posted by Venlaw

Same issue here. Finally got around to shutting off my site and finding this plugin was the cause of my login issues.

Had the same problem on one vBulletin 4.2.3 forum and none of the available versions worked. Uninstalled the product and the login issue disappeared.

Then discovered on another 4.2.3 forum, the product wasn't causing login errors but it simply wasn't working any more.

On a third 4.2.3 forum, the plugin is still working without the login error or any other errors.

The SQL error is because of this part of the query:

Code:

WHERE type = 'reply' AND forumid IN (  );

No forum ID is specified, hence the SQL error.

I have no idea why it works on some forums and not others... I don't have the time to try to track down what causes this behavior.

The best solution currently is simply to uninstall the product.

hazem_aliraqi · #**138** 12-29-2015, 05:14 PM

Quote:

Originally Posted by djbaxter

Had the same problem on one vBulletin 4.2.3 forum and none of the available versions worked. Uninstalled the product and the login issue disappeared.

Then discovered on another 4.2.3 forum, the product wasn't causing login errors but it simply wasn't working any more.

On a third 4.2.3 forum, the plugin is still working without the login error or any other errors.

The SQL error is because of this part of the query:

Code:

WHERE type = 'reply' AND forumid IN (  );

No forum ID is specified, hence the SQL error.

I have no idea why it works on some forums and not others... I don't have the time to try to track down what causes this behavior.

The best solution currently is simply to uninstall the product.

i have the same problem with admin login

taravasya · #**139** 02-15-2016, 10:23 AM

djbaxter, hazem_aliraqi
Hi! Please read previous messages very carefully! This errore appears when try to login moderator what do not assign at least one forum to moderate it.

Quote:

Originally Posted by Wedframe

Venlaw, My Hattiesburg

Exactly this moderator could not login to forum, because of receiving the DB-error.
So,.. for me, the solution of the problem was - to assign him to moderate any forum section. After this problem has been resolved.

taravasya · #**140** 02-22-2016, 08:30 AM

Well.. I try to fix the root of the problem. As I understand, DB error occurs only with product by_AUGI.
So... if you have installed product by_AUGI, then in module
"Showing notifications"
found string:

PHP Code:


			
$m_forums = "AND forumid IN ( ". implode(',', modForums( $vbulletin)) ." )";

and replace it with:

PHP Code:


			
$m_forums = "AND forumid IN ( '". implode(',', modForums( $vbulletin)) ."' )";

BTW! Idea AUGI was in to regulate notifications to moderators according to theirs permissions. But... this is just dont work. Notification appears no matter whether the right to moderate in this section of the forum or not. As a result, if moderator with limited privileges receives a notification about moderation items in forum the moderator of which he is does not, when viewing the moderation queue it gets an error...

taravasya · #**141** 07-12-2016, 04:16 AM

UPDATE! !Previous post not enough correct!
for correct processing of rights of moderation with this hack, we need to this piece of code:

PHP Code:


			
    //visitormessage, groupmessage, picturecomment 
    if(count(array_intersect($fr_itemsToTrack, array('visitormessage', 'groupmessage', 'picturecomment')))>0) { 
        $query = "SELECT COUNT(type) AS total, type 
                  FROM ". TABLE_PREFIX ."moderation 
                  GROUP BY type"; 
        $fr_result = $vbulletin->db->query_read($query); 
        while($fr_entry = $vbulletin->db->fetch_array($fr_result)) { 
            $fr_modItems[$fr_entry['type']] ['total'] = $fr_entry['total']; 
        } 
    }

rearrange upward, so that it would-be over

PHP Code:


			
    //reply - post 
    if(in_array('reply', $fr_itemsToTrack)) { 
        $query = "SELECT COUNT(*) AS num 
                  FROM " . TABLE_PREFIX . "moderation AS moderation 
                  INNER JOIN " . TABLE_PREFIX . "post AS post ON (moderation.primaryid = post.postid) 
                  INNER JOIN " . TABLE_PREFIX . "thread AS thread ON (post.threadid = thread.threadid) 
                  WHERE type = 'reply' ". $m_forums; 
        $fr_result = $vbulletin->db->query_first($query); 
        $fr_modItems['reply'] ['total'] = $fr_result['num']; 
    }

================================================== =========================================
================================================== =========================================

Anf another suggest is for that would not appear a database error when entering/leaving forum by moderator/super-moderator/administrator without any forum moderated, string:

PHP Code:


			
if(!isSuperMod($vbulletin)){

must be replaced with:

PHP Code:


			
if(!isSuperMod($vbulletin) AND can_moderate()){

================================================== =========================================

Both issues from same module:
Showing notifications

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.13407 seconds Memory Usage 2,389KB Queries Executed 28 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (5)bbcode_code (6)bbcode_php (7)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (4)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)pagenav_pagelinkrel (11)post_thanks_box (4)post_thanks_box_bit (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (3)post_thanks_postbit (11)post_thanks_postbit_info (10)postbit (7)postbit_attachment (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.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/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_postinfo_query fetch_postinfo fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start fetch_musername post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end post_thanks_function_fetch_thanks_bit_start post_thanks_function_show_thanks_date_start post_thanks_function_show_thanks_date_end post_thanks_function_fetch_thanks_bit_end post_thanks_function_fetch_post_thanks_template_start post_thanks_function_fetch_post_thanks_template_end postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_attachment postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

3 благодарности(ей) от:
mokujin, Teascu Dorin

Благодарность от:
hazem_aliraqi

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!