vb.org Archive - Moderators Functions - FractalizeR: Show items, awaiting moderation in notifications area

Page 4 of 4

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

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

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

- - Moderators Functions - FractalizeR: Show items, awaiting moderation in notifications area (https://vborg.vbsupport.ru/showthread.php?t=241301)

RNArmstrong

01-17-2015 11:14 PM

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

01-25-2015 09:35 PM

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

Wedframe

01-30-2015 12:37 AM

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

02-03-2015 04:01 PM

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

Delfi_r

02-13-2015 09:29 PM

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

02-14-2015 01:49 PM

The problem it's not there on the A825F933D42B version

My Hattiesburg

04-25-2015 03:50 PM

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

04-25-2015 04:09 PM

Quote:

Originally Posted by My Hattiesburg (Post 2544161)

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

My Hattiesburg

04-25-2015 06:57 PM

Quote:

Originally Posted by MarkFL (Post 2544166)

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

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

My Hattiesburg

04-26-2015 05:33 PM

Quote:

Originally Posted by Wedframe (Post 2535926)

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

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.

Venlaw

05-24-2015 11:12 AM

Quote:

Originally Posted by Wedframe (Post 2535926)

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

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

06-08-2015 06:02 AM

1 Attachment(s)

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

08-29-2015 07:01 PM

product-fr_notifymoditems (A825F933D42B).xml

Works on 4.2.3 :)

GIz

Stratis

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

12-22-2015 08:59 PM

Quote:

Originally Posted by Wedframe (Post 2535926)

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 (Post 2544244)

Quote:

Originally Posted by Venlaw (Post 2546329)

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

12-29-2015 05:14 PM

Quote:

Originally Posted by djbaxter (Post 2561001)

Code:

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

i have the same problem with admin login

taravasya

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 (Post 2547327)

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

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

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

gsk8	10-22-2016 03:41 PM

So when this is "enabled", I'm unable to log in. I get this error:

PHP Warning: implode(): Invalid arguments passed in ..../includes/class_bootstrap.php(1230) : eval()'d code on line 37

Love this mod but what can I do to fix?

taravasya

11-30-2016 09:28 AM

gsk8 you admin on your forum? You have at least one forum section there you assigned as moderator?

gsk8	12-01-2016 12:00 PM

Yes, I'm admin.

Paul M

12-01-2016 01:32 PM

and the second part of his question, which you did not answer ?

Quote:

.... You have at least one forum section there you assigned as moderator?

gsk8	12-02-2016 01:32 PM

Hi and thanks for responding/helping Tara and Paul!

I selected admin and moderators as usergroups which can view the notifications. Is there something else I was supposed to do?

MarkFL

12-02-2016 03:10 PM

Quote:

Originally Posted by gsk8 (Post 2579045)

Hi and thanks for responding/helping Tara and Paul!

I selected admin and moderators as usergroups which can view the notifications. Is there something else I was supposed to do?

What do you have for "Items to track?"

Stratis

01-03-2018 04:09 PM

Quote:

Originally Posted by MarkFL (Post 2579047)

What do you have for "Items to track?"

I have same problem, I changed this line
if(!isSuperMod($vbulletin)){

I have
Items to track: Posts and threads.

I do not understand the code above
//visitormessage, groupmessage, picturecomment
and
//reply - post

Do we must do something with that to?
Thanks

taravasya

02-28-2018 09:15 PM

Stratis its in module: "Showing notifications" of FractalizeR product.
At this time:
//reply - post
its begin of first if statement after comment:
//#################### Acquiring ####################

and....

//visitormessage, groupmessage, picturecomment
its begin of second if statement after comment:
//#################### Acquiring ####################

And all together looks like this:

PHP Code:


		
			
    //#################### Acquiring ####################  
    //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'];  
    } 

    //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'];  
        }  
    }

For correct processing of rights of moderation with this product you need to rearrange this two if statement upward. Like this:

PHP Code:


		
			
    //#################### Acquiring ####################  
    //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'];  
        }  
    }    

    //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'];  
    }

Sorry for my english.... :erm:

final kaoss

08-14-2019 06:24 PM

Hmm... seems like this one has some edits to be made... does anyone have it working on vb 4.2.5 & php 7.0?

djbaxter

08-14-2019 07:46 PM

Version 4.0.3 AUGI is working on vB 4.2.5 and PHP 7.1.31 for me:

product-fr_notifymoditems-4_0_3_by_AUGI.xml

final kaoss

09-04-2019 11:40 PM

Thanks for that dj, I tried the one you mentioned and it turns out it was responsible for causing a error for users logging in.

It seems this version of it resolves that issue.
product-fr_notifymoditems (A825F933D42B).xml

https://vborg.vbsupport.ru/showpost....36&postcount=6

djbaxter

09-05-2019 12:03 AM

Thanks final kaoss. Good to know.

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

Page 4 of 4

« First

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01702 seconds Memory Usage 1,883KB 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 (6)bbcode_code_printable (8)bbcode_php_printable (13)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 (32)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: