FractalizeR: Show items, awaiting moderation in notifications area

[FractalizeR]

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 (https://vborg.vbsupport.ru/member.php?u=426684) that fixes notification count for moderators with limited permissions.


11-05-2011)

Attached a version by A825F933D42B (https://vborg.vbsupport.ru/member.php?u=232617) 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

[ZexTasy]

This is very interesting, thanks! Tagged for later!

[ProFifaLeagues]

Tagged looks handy for my forum will install tonight!!

[Adem GEN?]

No menu
116339

[synseal]

No menu
116339

Same for me, just shows the number 8 and when you click on it theres nothing to do.

[FractalizeR]

Can you post screenshots of the problem please?

[grc]

We use moderator approved registrations and I basically am only interested having administrators see users awaiting registration approval in the notifications area. I installed the mod, but I can't tell that it's doing anything. As I understand it, I should be seeing the checked items listed, with or without pending action.

Any ideas?

[SuperGLS]

Any screenshots of the vB4.X version?

[Fungsten]

We use moderator approved registrations and I basically am only interested having administrators see users awaiting registration approval in the notifications area. I installed the mod, but I can't tell that it's doing anything. As I understand it, I should be seeing the checked items listed, with or without pending action.

Any ideas?

Same here.

[Sador]

Tagged, seems very useful.

[grc]

I see last update: today and then "Not Supported." I take it that the coder released this version and saw some of the problems and decided not to put any more time into it.

Is that correct?

[FractalizeR]

No, that is not. On my forum mod works ok. Now I am looking into problem with user moderation not being displayed.

As I understand it, I should be seeing the checked items listed, with or without pending action.
No. If there is nothing in your moderation queue, empty item is not displayed in menu. Do you have unmoderated users right now?

[FractalizeR]

All bugs fixed. Please update to latest version. Screenshot update is on the way

[FractalizeR]

Screenshots updated. Modification settings fixed. Now it is showing as Supported.

[Adem GEN?]

No menu
116339
Now no problem
Thank you, very nice mod

Turkish language files here (http://www.vb-ipuclari.com/vbulletin-turkce-dil-dosyalari/vbulletin-forum-pluginlerin-turkce-dil-dosyasi.html)

[grc]

No. If there is nothing in your moderation queue, empty item is not displayed in menu. Do you have unmoderated users right now?

Thanks for the response. I've updated to the current release and reactived the mod. I'm only going to use it for notifications of new registrations, so I'll have to wait for someone new to come along (we get a few a day).

The reason I was under the impression that, if activated, I'd see information listed under "Notifications" with our without items to moderate is because of the wording in the options:
Show notification even if count is zero
Text will be shown in notifications area even if there is nothing to notificate about (0)

I see that as saying that there will be information under notifications even if there is nothing pending. Please understand, I'm okay with it either way, just that I had that impression based on that option.

Also, I'll mention that I'm rather sensitive to "supported" or "not supported" right now because of the way the coder of the "Thanks" mod has just discontinued support leaving many users with a mod missing several features that weren't upgraded for vB4.

Thanks for your support of your nice mod!

[FractalizeR]

Yea, Abe1 disappointed me as well. I am slowly switching to Helpful answers mod (https://vborg.vbsupport.ru/showthread.php?t=233296) instead because of that.

I will check how options affect mod behaviour, thanks for bug report. Stay tuned.

[FractalizeR]

I see that as saying that there will be information under notifications even if there is nothing pending. Please understand, I'm okay with it either way, just that I had that impression based on that option.

I've searched VBulletin code and it seems, VBulletin now hides notifications with 0 items count itself:

if ($vbulletin->userinfo["$userfield"] > 0)
{
$show['notifications'] = true;
$notifications_total += $vbulletin->userinfo["$userfield"];
$notification['total'] = vb_number_format($vbulletin->userinfo["$userfield"]);
$templater = vB_Template::create('navbar_notifications_menubit' );
$templater->register('notification', $notification);
$notifications_menubits .= $templater->render();
}


It seems, that I should remove that option from plugin.

[FractalizeR]

Ok, non-working option removed. Russian translation fixed.

Please don't forget to click Installed if you installed my mod.

[grc]

Yea, Abe1 disappointed me as well. I am slowly switching to Helpful answers mod (https://vborg.vbsupport.ru/showthread.php?t=233296) instead because of that.

I will check how options affect mod behaviour, thanks for bug report. Stay tuned.

Let me report back that your mod is working fine for me. The only thing moderated on our forum is registration so I had to wait till a couple of new ones came in to know for sure, but the notification worked just fine. Thanks!

An aside, how hard do you think it would be to get search capability going on the Thanks mod? Since it was working before the upgrade to vB4, I'd think (easy for me, a non coder to say) it wouldn't be that hard to get to working.

[chriske]

Thanks for this mod, thats excatly what i need!

installed & rated

[wampforum]

installed thanks. any way this can notify of articles awaiting moderation?

[FractalizeR]

installed thanks. any way this can notify of articles awaiting moderation?
I didn't use CMS yet. I will have a look, but a little later.

An aside, how hard do you think it would be to get search capability going on the Thanks mod? Since it was working before the upgrade to vB4, I'd think (easy for me, a non coder to say) it wouldn't be that hard to get to working.
I am not sure, I will try to have a look. It looks a bit complex for me. But it seems, that forum rules prohibit to rerelease modifications... :( May be I can try to release a patch.

[RedDevil]

I installed this now its putting posts in moderation from my rss feeds which it wasnt happening before so ive temp disabled it now posts normal, any idea what this is?

[FractalizeR]

This mod doesn't change database structure at all. It just reads it to determine the items, waiting for moderation. So, it can't put anything to moderation queue itself.

[Skyrider]

That's weird. It says in my notifications that 3 threads are awaiting moderation. But when I click it, no threads are showing up. And when I check the AdminCP it says:

Threads to Moderate - 0

[Julie]

Mine says I have two threads waiting, but there are no threads awaiting moderation...

[FractalizeR]

Thanks for reporting, I will check.

[Brandon Sheley]

nice mod, very helpful
will bookmark this for my 4.0 installs :)

[FractalizeR]

Can these posts be deleted before you had a chance to look into them?

[Skyrider]

Can these posts be deleted before you had a chance to look into them?
Come again? I have no idea what posts needs to be accepted. I have no idea why it even says I need to accept 3 of them.

[FractalizeR]

I mean, when you move from main forum page (where you see 3 threads to moderate) to admincp (where this number shown is zero) and then back, do you see again 3 posts in moderation queue?

[Skyrider]

I mean, when you move from main forum page (where you see 3 threads to moderate) to admincp (where this number shown is zero) and then back, do you see again 3 posts in moderation queue?

Here you go:

At the Forums:
https://vborg.vbsupport.ru/attachment.php?attachmentid=116708&stc=1&d=1273049715

When I click on it:
https://vborg.vbsupport.ru/attachment.php?attachmentid=116710&stc=1&d=1273049807

In the AdminCP:
https://vborg.vbsupport.ru/attachment.php?attachmentid=116709&stc=1&d=1273049715

https://vborg.vbsupport.ru/attachment.php?attachmentid=116711&stc=1&d=1273049884

And yes, I still see it even I go to the moderation view of all threads in the AdminCP back to the refreshment on the forum homepage.

[FractalizeR]

Thanks, I will look. I noticed that admincp queries are almost like mine....

[Skyrider]

Any updates regarding this? :)

[grc]

FractalizeR, I just wanted to tell you how much I'm enjoying having your mod on my forum. I only activated the "new registration" part of the mod, as we manually approve all registrations, but don't do any moderation of posts.

I used to get emails on new registrations, but would be busy and forget about them. Now, everything I go to the forum, it's there in Notifications.

I have another member of the team who has helped with registrations and I see that he's handling more of them than before. I think it's because of the Notifications of new registrations.

Thanks again for the good work.

[Reeve of shinra]

I am actually having the same issues as FF|Skyrider, has there been any determinations for what causes this?

[RobDog888]

Great mod, just what I was looking for but... Installed on 4.0.5 and I dont have the zero option in the admincp and seems I get a duplicate notification during my testing.

I unapproved one of my existing profile visitor messages and it added "Visitor messages awaiting moderation" as well as "Unapproved Visitor Messages". The second one is the vB system one as you can tell by the phrase text is all proper case vs yours with all lowercase except the very first letter in the message.

Edit: when I approve the visitor message, both notifications go away.

Edit2: Can you add Attachment moderation also? I added it myself but others may like it too :)

[MonsterDK]

Be great if this was updated as I take it, it will not work on 4.0.6

[FractalizeR]

I will try to discover and fix recovered issues soon, but I am pretty much disappointed with VB 4.x and I am going to stop developing for it. Waiting for XenForo to switch my forums to it. I am tired of struggling with VB.

[mohammad6006]

tank for usefull mod

but i have a problem:

i say this problem in example

we have 3 forums section and 3 seprate moderator for each section

now the moderator of number 1 section can see notificate for section 2 awaiting moderate and number 3 section

and also other moderators can see awaiting notificate for all forums

___________
i want each moderator can see just himself awaiting notificate number

excuse for bad english

[FractalizeR]

I'm afraid that your suggestion will add too much queries to display notifications.

[mohammad6006]

I'm afraid that your suggestion will add too much queries to display notifications.

but this is big problem for us
what can i do?

[FractalizeR]

You can hire someone to change my modification for you. I'm done with VB. Waiting for XenForo. Sorry.

[A825F933D42B]

Attached a version with Attachment support. With this you also see attachments which need moderation.

@FractalizeR: Feel free to add my lines of code to your script ;-)

[atcspaul]

great mod thank you

[Bluemax712]

Upgraded vB Forum from 4.07 to 4.1.1 (no problems)
Then installed this mod - works perfect so far - just what I was looking for

Thank you FractalizeR :)

[Meestor_X]

Does this MOD also show items to moderate for Blogs and Articles?

[BadgerDog]

Installed with thanks for testing on 4.04 .... :up:

Unfortunately, shows 8 threads and 1 post needing moderation, yet when clicked on, none show up. Something's not adding up .. :D Nice idea though ....

Un-installed ....

Regards,
Doug

[beatyourtruck]

4.1.2 installed fine. Shows items to be moderated but when clicked, there are none.

uninstalling.......doesn't work.

[sergioloporto]

Hello, does it work on VB 4.1.3?

Thanks

[Xerosis]

thanks

[SimpleFTA]

Attached a version with Attachment support. With this you also see attachments which need moderation.

@FractalizeR: Feel free to add my lines of code to your script ;-)


@A825F933D42B THANK YOU for this! Exactly what I was looking for. Kind of surprised it wasn't included in the original mod.

@FractalizeR thanks for the mod!

[Meestor_X]

Any chance of adding all the rest of the "mod"-able items? (Blogs, Blog Comments, Articles, Article Comments, etc.)

[Taurus1]

Works perfect on 4.1.3 for me. Thank you very much. I used the version with the A825F933D42B in it.

[Meestor_X]

Still hoping that this can get updated with all the rest of the possible items that can be moderated...

[CK]

This really should be included in the core product. Tagged for now.

[Bluemax712]

FractalizeR,

This mod has been working perfect with 4.1.1 to display awaiting moderation notifications
Thanks Again

Is there a way to also be notified by email
when there awaiting moderation notifications?

[CK]

Installed, thank you!

[derrene]

hi

i think the mod works fine,(vb4.1.4)

but one problem..
when i activate this mod
then i should to moderate all usergroups on my forum.
how i can disable thos
or how to get notification for an individual usergroup als example new users

[AURFSCAN]

thanks .. work well

[B@legar]

Its possible to add same functions for Vba Links Directory?

[MrD]

Hi,
is it possible to show articles from the CMS that are unpublished?

[MalluParadise]

work with 4.1.7?

[FractalizeR]

It should.

[deverill2010]

Hi does this work for say example.

I allow guests to post on my site but it must be approved before becoming visible on our site.i hardly ever check the admin panel so seem to keep missing these guest posts as they just get lost.

Will this mod give me a notification of when a guest has posted and it needs approving?

[Ramsesx]

Thanks for this great add-on FractalizeR.

[Rik Brown]

Like I did recently, I've noted several other users run into a problem where the mod shows Notifications of threads to moderate but when you click on the Notifications dropdown menu, there are no threads to moderate, etc.

What I've done to clear those messages is to totally clear out the moderation table with a simple mysql query:
delete from moderation

This will nuke all moderation messages in that table so don't use it unless that is your intention.

Hope that helps. -- Rik

[Alfa1]

Thanks a lot. That annoyed me and my staff for many years now. If I only knew before that this was so simple.

Fractalizer, please consider to include blogs, blog comments and articles. (mind that there is an addon that adds a blog search controller)

[FractalizeR]

Fractalizer, please consider to include blogs, blog comments and articles. (mind that there is an addon that adds a blog search controller)

I doubt I will have time to do that. But I will think, thanks.

[m!dn!ght]

hello
first thanks for this useful mod
i have a problem
notification shows up 11 Threads awaiting moderation but when i do click on link i see just 5 Threads awaiting moderation
vbulletin 4.1.8 + vBSEO

[james shadle]

Very cool, thanks.

[Bluemax712]

Hello,
This Mod has worked perfect - been running on 4.0.7 - 4.1.5 currently
I've asked this before but didn't receive a response

Is there a way to also get notified by email when a new notification shows up?
Any help appreciated

Thanks again for a Mod

[Luca_ITA]

Thanks for this great add-on FractalizeR.
v4.1.9

[metalguy639]

Does not seem to work at all. Am I missing something? I installed it and it did not alert me on a new thread in a forum that I had moderation set up for threads.

[deverill2010]

Hi does this work for say example.

I allow guests to post on my site but it must be approved before becoming visible on our site.i hardly ever check the admin panel so seem to keep missing these guest posts as they just get lost.

Will this mod give me a notification of when a guest has posted and it needs approving?

Again does this do the above? And does this work on 4.1.10?

[Dwarden]

I really like this mod, got it installed and using it with 4.1.10 version

yet there is some problem with visitor messages
it reports 34 visitor messages for moderation yet there is none in admin CP

(if there is any visible in admin CP it always add these 34 to the value)

[Superorb]

Is there any way to get this mod to look like this mod (https://vborg.vbsupport.ru/showthread.php?t=92809)? I like having Moderation separate from PM's.

[chimpmaster]

Great mod and one I have been looking for. Working fine in 4.1.12

[cowudders14]

I've got it installed and it report 2 threads needing moderation, yet no threads, posts or anything are in my mod queue when I get there. If I could get round this error, this is exactly what I've been after. Great mod.

I'm using 4.0.4 PL1 but I'm going to upgrade to the latest next week if I have time so I'll let you know again.

[cowudders14]

Random thought: Could these odd messages be ones that have been deleted without ever having been approved? If you delete from the admin or mod control panel, it hard deletes - they are gone, but if you do a soft delete from the thread itself, the posts are still there, and presumably still carry their 'moderated post' status, but they are also deleted, so would not show up in lists of posts. I do occasionally delete posts from the thread as I read them in context before deleting them.

I wouldn't have a clue how to check SQL tags or whatever it is to find out but it's a theory. Can anyone who does know how to play with SQL see if this is the case please?

[cstreater]

Works fine 4.2.

[ShadeDL]

Yea, i've been looking for something similar to the moderation module in vba, so I installed this on my vb4.2. Anyways, nothing shows up. Settings are in the admincp and everything.. but nothing shows up on the notifications menu besides pm's.

Anyone have any ideas?

[Bluemax712]

This still working for me with 4.1.12 PL2 but...

still looking for a way to also send an email - when a notification pops up
so don't have to keep checking in to see if there are any new notifications.

Someone mentioned a mod that will send a PM - when there is a new notification
but haven't found it yet. :(
(this would work since I get sent an email whenever a new PM arrives)


Any ideas?

[Disco_Stu]

Seems to be working ok in 4.2.PL1

[HondaATC]

This coupled with Spam-O-Matic are a wonderful pair :)

[datoneer]

Thanks great mod!

[MrD]

Hi,
is there any option to Display new Articels wich are in moderation?

[Bluemax712]

Just installed Lee Robert's vBMQN - Moderation Queue Notifications Mod
works perfect alongside FractilizeR to also email the notifications

https://vborg.vbsupport.ru/showthread.php?t=294999

[EliasAlucard]

Installed, checked, nominated and voted 5 stars. Great plugin. You should update it more often though.

[fxdigi-cash]

Thanks for the mod!

However, this is an issue when it comes to ie browser. The menu is messed up !!!

any idea how to get around that?

[Barbara1]

works fine with 4.2.0 pl3

[thunderclap82]

I have this installed on two systems running 4.2.2. On one it works fine, the other it shows a 1 thread needs to be moderated yet no threads need moderating. Any thoughts?

[Meestor_X]

Does anyone know how to add these notifications to vBNotifications (https://vborg.vbsupport.ru/showthread.php?t=266914)?

[Skyrider]

How does this 'exactly' work permission wise? I've created a new usergroup of which a) is a super mod group and b), i've given myself moderation access to the specific section where posts are being moderated. (yes, given it "can moderate" access as well).

But when I set the usergroup permissions to a group that I want it to view notifications, it refuses to work. When I set it to admins ,it works as a charm.. why admins only?

[Skyrider]

Update regarding my post would be nice.

[megabink]

Yeah it would be great if someone could take over this mod and give it a good update so that it works again...i have used this mod for years and it is really a time saver!

[gundamz]

I have this installed on two systems running 4.2.2. On one it works fine, the other it shows a 1 thread needs to be moderated yet no threads need moderating. Any thoughts?

had this issue too.

[Terrablade]

im getting this error https://imgur.com/bwr4jQY
moderate.php is inside modcp folder. What could be triggering this?

[Skyrider]

im getting this error https://imgur.com/bwr4jQY
moderate.php is inside modcp folder. What could be triggering this?

The problem is the / moderate.php/?do=messages. It should be moderate.php?do=messages without the slash.

[Terrablade]

its adding the / automatically. even if i take it out. What is causing it?

[BasicGreatGuy]

Anyone figure out why it shows threads that need moderation when there aren't any? It works fine for new threads. It would be nice to be able to get rid of the nonexistent 4 threads notification.

[Bluemax712]

Anyone figure out why it shows threads that need moderation when there aren't any? It works fine for new threads. It would be nice to be able to get rid of the nonexistent 4 threads notification.


This occasional happens to me too where it incorrectly shows threads/post need moderation

Usually loading the mod control panel panel directly
and then reloading the forum page corrects the notification error

[BasicGreatGuy]

This occasional happens to me too where it incorrectly shows threads/post need moderation

Usually loading the mod control panel panel directly
and then reloading the forum page corrects the notification error

Not sure what you are saying. I imported it via the admin panel under products and programs.

[Bluemax712]

Not sure what you are saying. I imported it via the admin panel under products and programs.

Instead of clicking on the notification area in upper right which this mod provides
where it says 4 threads awaiting approval

Load your forum's 'moderate threads' page directly:
http://yourforumname/modcp/moderate.php?do=posts
it should show no threads/posts awaiting approval

Then reload your forum homepage and the 4 threads notification in the upper right should be set back to 0

[BasicGreatGuy]

Instead of clicking on the notification area in upper right which this mod provides
where it says 4 threads awaiting approval

Load your forum's 'moderate threads' page directly:
http://yourforumname/modcp/moderate.php?do=posts
it should show no threads/posts awaiting approval

Then reload your forum homepage and the 4 threads notification in the upper right should be set back to 0

I just tried that, and it is still showing the phantom 4 thread notification.

[Bluemax712]

Do you have an alternate Admin/Mod account you can login with
to see if it also shows the same phantom threads
or try making a new account to test with

[BasicGreatGuy]

Do you have an alternate Admin/Mod account you can login with
to see if it also shows the same phantom threads
or try making a new account to test with

I upgraded my user test account to admin and logged in, and it still shows the 4 phantom threads.

[Bluemax712]

I upgraded my user test account to admin and logged in, and it still shows the 4 phantom threads.


Well can always try this using this mod instead
(haven't tried it myself)

SCANU's Quick Moderation: Moderation queue info on Forum home
https://vborg.vbsupport.ru/showthread.php?t=285008&highlight=awaiting+moderation

[BasicGreatGuy]

Well can always try this using this mod instead
(haven't tried it myself)

SCANU's Quick Moderation: Moderation queue info on Forum home
https://vborg.vbsupport.ru/showthread.php?t=285008&highlight=awaiting+moderation

Thanks for the reply. I just tried it, and it shows the same thing, unfortunately. I see in the comments for it, that some others have the same issue. Maybe it is a vbulletin bug. It is really irritating to see the phantom display. lol

[Bluemax712]

Thanks for the reply. I just tried it, and it shows the same thing, unfortunately. I see in the comments for it, that some others have the same issue. Maybe it is a vbulletin bug. It is really irritating to see the phantom display. lol


You'll probably have better luck getting help from Scanu - than Fractilizer
- mark it as installed - vote it up and post the question in his thread
- and I'm sure a donation never hurts :)

[Terrablade]

im getting this error https://imgur.com/bwr4jQY
moderate.php is inside modcp folder. What could be triggering this?


Anyone with a solution?

[Bluemax712]

Well there is a difference between the vB4 and vB3 versions which involves the slash
Could you be using the wrong version for your forum?

============================
vB4 version:

'visitormessage' => array(
'link' => $vbulletin->options['bburl'] . '/' . trim($vbulletin->config['Misc']['modcpdir'], '/') . '/moderate.php?do=messages',
'total' => 0

==============================
vB3 version:
'visitormessage' => array(
'link' => $vbulletin->options['bburl'] . '/' . $config['Misc']['modcpdir'] . '/moderate.php?do=messages',
'count' => 0
==================================

[Terrablade]

Well there is a difference between the vB4 and vB3 versions which involves the slash
Could you be using the wrong version for your forum?

============================
vB4 version:

'visitormessage' => array(
'link' => $vbulletin->options['bburl'] . '/' . trim($vbulletin->config['Misc']['modcpdir'], '/') . '/moderate.php?do=messages',
'total' => 0

==============================
vB3 version:
'visitormessage' => array(
'link' => $vbulletin->options['bburl'] . '/' . $config['Misc']['modcpdir'] . '/moderate.php?do=messages',
'count' => 0
==================================


I have vb 3.8.7 and I use the version for vb3 :/

[Bluemax712]

Does the built-in one in the ACP for checking awaiting messages work right?

[Terrablade]

Built in in ACP works fine..
The other options in fractalizer works fine. Just that one gives problems

[Bluemax712]

ok - just checking - that is weird :)

I see from the vB3 thread others had this same problem - have you tried manually editing that line in the xml file and reimporting
https://vborg.vbsupport.ru/showthread.php?t=186326

posts 106 or 107

[AUGI Web Team]

I believe the original version of this mod, depending on the options to show, showed a notification for all items listed in the moderation queue. This is regardless if the user can handle the items in the queue.

This attachment limits this view to threads / replies in which a moderator can handle it. The other options were not adjusted as it is not a focus for us. If the user is considered as a super moderator or above, then all threads / replies in the queue are included in the notifications count.

Thanks for this mod.

[BasicGreatGuy]

I believe the original version of this mod, depending on the options to show, showed a notification for all items listed in the moderation queue. This is regardless if the user can handle the items in the queue.

This attachment limits this view to threads / replies in which a moderator can handle it. The other options were not adjusted as it is not a focus for us. If the user is considered as a super moderator or above, then all threads / replies in the queue are included in the notifications count.

Thanks for this mod.

Thank you for this post. It fixed the ghost threads waiting moderation problem.

[FractalizeR]

Attached AUGI's version to the post.

[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.php?p=2521205&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]

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]

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]

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.

[Venlaw]

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

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

[Wedframe]

Venlaw, My Hattiesburg
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]

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]

product-fr_notifymoditems (A825F933D42B).xml

Works on 4.2.3 :)

GIz

[Stratis]

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]

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.

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:

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]

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:

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]

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.

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]

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:
$m_forums = "AND forumid IN ( ". implode(',', modForums( $vbulletin)) ." )";
and replace it with:
$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]

UPDATE! !Previous post not enough correct!
for correct processing of rights of moderation with this hack, we need to this piece of 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
//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:
if(!isSuperMod($vbulletin)){
must be replaced with:
if(!isSuperMod($vbulletin) AND can_moderate()){

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

Both issues from same module:
Showing notifications

[gsk8]

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]

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

[gsk8]

Yes, I'm admin.

[Paul M]

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

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

[gsk8]

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]

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]

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]

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:


//#################### 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:


//#################### 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]

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]

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]

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.php?p=2600536&postcount=6

[djbaxter]

Thanks final kaoss. Good to know.