Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
vBMQN - Moderation Queue Notifications + Desktop App Details »
vBMQN - Moderation Queue Notifications + Desktop App
Mod Version: 2.0, by Lee Roberts (Contributor) Lee Roberts is offline
Developer Last Online: Nov 2016 I like it Show Printable Version Email this Page

vB Version: 4.2.x Rating: (4 votes - 5.00 average) Installs: 35
Released: 11 Feb 2013 Last Update: 12 Feb 2013 Downloads: 159
Not Supported Uses Plugins Additional Files Re-usable Code Translations  

****


Introduction
There are many scenarios where this mod would come in handy for administrators. There are too many for me to cover them all, so I will give you the scenario this mod was developed for...

If you have a hand full of moderating staff and a large number of forums, adding each moderator to each forum can be quite a pain, however doing it that way would give you notifications for those moderators when something dose need their attention from within those said forums...

Another option would be to setup staff to be Global Moderators, this removes the need to add them to specific forums but it also removes queue notifications because moderators wouldnít be assigned to individual forums...

We require new members to be moderated and/or that their first submissions to the forum require moderating, this can become quite a pain because again staff would need to continually check the moderation queue for new items...

The Solution and Requirements
What we need is moderation queue notifications via email and possibly a desktop app for those staff that would rather not use their email/inbox.

Features:
- Email Notifications for multiple users/addresses
- Notifications for every item type (posts, threads, attachments etc.)
- Email sending using the vB mail method/system (plain text emails)
- Email generation should use the vB Phrase system (multi-language support)
- Automated checking of the moderation queue (vB Cron system)
- Should support the Scheduled Task log system (debugging, report actions taken)
- Support for external applications and their development (xml based status)

All of the above are present in the first release of this mod (v1), please see the screen shots.

This mod is setup as a vB Cron task; I could not see/find a better way to make this an automated system working with anything else from within the vB system. By default the Cron task is setup to run every 30 minutes, if you would like to adjust this, simply go in and adjust the Cron job as you wish.

Desktop App
At the moment I am still developing a windows (.net) desktop app to work with this, right now we donít have a big need for this so itís not a priority for me to develop this and get it out to you any time soon, when the moderation queue is checked regardless of its current state the included xml file is updated to reflect this. So all your own app would need to do is read in this xml file and take the action you require.

If there is a massive interest in the desktop app for this I could be persuaded to push it to the top of my job list, for now though it is work in progress and with no planned deadline or release date.

Support
We have been using this mod in a production environment for almost 12 months now with no problems at all, it is really quite a simple mod and Iím surprised it hasnít been done already, given the number of requests I have seen.

I will support this as best I can, I am a busy guy so you will need to understand this if you do run into any problems and request support.

Install/Upgrade
Installing this mod is much like any other, upload the files in the download to the same locations on your server, import the product xml file, go to the Admin > Settings > Options > vBMQN: General Options page and configure as you wish. If you are upgrading from an older version simply follow the same steps as installing for the first time.

Change Log
v1.0 - 11 Feb 2013
- First version

v2.0 - 12 Feb 2013
- Added support for table prefix's ( config.php > $config['Database']['tableprefix'] = ''; )
- Rewrite of the database query code, now uses the vB Database Class ( $vbulletin->db->query_first )
- Changed from the use of the php "number_format" function to the vB function "vb_number_format"
- Added instant email notification rather than sending emails to the vB mail queue ( $notsubscription = true )

Enjoy!
This has helped us allot and I hope those of you who have requested this before find it to be ďjust the jobĒ as well.

Regards,
Lee Roberts

Download Now

Only licensed members can download files, Click Here for more information.

Screenshots

Click image for larger version

Name:	00.png
Views:	493
Size:	60.6 KB
ID:	143705   Click image for larger version

Name:	01.png
Views:	503
Size:	70.8 KB
ID:	143706   Click image for larger version

Name:	02.png
Views:	508
Size:	46.3 KB
ID:	143707   Click image for larger version

Name:	03.png
Views:	439
Size:	27.5 KB
ID:	143708  

Click image for larger version

Name:	04.png
Views:	515
Size:	63.8 KB
ID:	143709   Click image for larger version

Name:	05.png
Views:	829
Size:	44.4 KB
ID:	143710  

Show Your Support

  • To receive notifications regarding updates -> Click to Mark as Installed.
  • If you like this modification support the author by donating.
  • This modification may not be copied, reproduced or published elsewhere without author's permission.
Similar Mod
Mod Developer Type Replies Last Post
Forum Home Enhancements SCANU's Quick Moderation: Moderation queue info on Forum home Scanu vBulletin 4.x Add-ons 116 23 Nov 2016 23:27

Comments
  #2  
Old 11 Feb 2013, 15:04
Lee Roberts's Avatar
Lee Roberts Lee Roberts is offline
 
Join Date: Jun 2008
Real name: Lee
** Reserved **

Dont forget to mark as Installed, Nominate and Rate/Vote for it !

.Me

Last edited by Lee Roberts; 13 Feb 2013 at 21:10.
Reply With Quote
  #3  
Old 11 Feb 2013, 20:36
Bluemax712 Bluemax712 is offline
 
Join Date: Oct 2010
Installed on a vB4.20 test forum with only this mod installed
but no luck so far getting it to send email notifications

The Scheduled Task Log viewer shows vBMQN "Queue Checked"evertime it is run
but never shows a "Notification Sent" even though there are messages waiting in the mod queue.
The Sendmail log shows no activity or errors.

Have also tried manually running the Process E-Mail Queue and then vBMQN scheduled tasks with same results.
Reply With Quote
  #4  
Old 11 Feb 2013, 21:25
Lee Roberts's Avatar
Lee Roberts Lee Roberts is offline
 
Join Date: Jun 2008
Real name: Lee
Hi,

Humm that is a strange one, i've used the "$notsubscription = true" in my code and this means "do not use the mail queue and send immediately" so i dont think its that.

How is the test forum setup to send mail? my test forum is setup to use SMTP for sending mail, however your cron log is telling you "Queue Checked" not "Notification Sent"...

What settings have you used for the Admin > Settings > Options > vBMQN: General Options page?

.Me
Reply With Quote
  #5  
Old 11 Feb 2013, 21:38
Bluemax712 Bluemax712 is offline
 
Join Date: Oct 2010
for vBMQN General Options:
- Moderator Control Panel (tried leaving blank and using modcp)
- Email Notification: Yes
- Notification Recipients: testmod@server.al.home
(this email works when sending a test message via VBulletin CP)
-Desktop Notification: Yes (but also tried No)

I've tried setting to SMTP too
and enabling/disabling the Email Queue system
and trying with and without the -f parameter

test messages from the CP -send test email to all users - work fine.
Reply With Quote
  #6  
Old 11 Feb 2013, 21:47
Lee Roberts's Avatar
Lee Roberts Lee Roberts is offline
 
Join Date: Jun 2008
Real name: Lee
Have you got another email address you can test with, i am wondering if there is an issue with the "dots" in that address?

Will see if i can replicate this now...

I just used that email address on my test forum and i got "Notification Sent".

The email was also recived by my mail server.

What items do you have in your mod que at the momment?

.Me

Last edited by Lee Roberts; 12 Feb 2013 at 21:32.
Reply With Quote
  #7  
Old 11 Feb 2013, 22:31
Bluemax712 Bluemax712 is offline
 
Join Date: Oct 2010
I've just been creating new "threads" everytime for testing -
it shows the awaiting messages count increase in the the admin control front status page under Threads to Moderate

I've then been running the vBMQN cron script manually

Don't have any other emails to try yet
only user@server.al.home type of emails addreses work for now with my setup
- vBulletin gives me "invalid email address" if I try to set a user's address to : user@localhost
though it does work if I mail from the command line

EDIT:
Installed on another server 4.1.12 (production) which has a few other plugins installed
inc Glowhost Spam-O-Matic + FractalizeR and a few others.

I get this error when running the vBMQN cron script manually

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

vBMQN

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in [path]/includes/cron/vbmqn.php on line 23

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in [path]/includes/cron/vbmqn.php on line 26

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in [path]/includes/cron/vbmqn.php on line 29

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in [path]/includes/cron/vbmqn.php on line 32

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in [path]/includes/cron/vbmqn.php on line 35

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in [path]/includes/cron/vbmqn.php on line 38
Queue Checked
Done
================================================================================ ===================================================

Edit 3: Also tried installing it on a test vB 3.8.7 with FractilezeR installed - got no errors when running the vBMQN script
but same results as the test vB4 server receive no emails
- Scheduled Task log only shows "vBMQN Queue Checked" (never says Emails Sent)

Edit4 : noticed if I purposely set the "modcp" setting to the wrong name - nothing changes - no errors shown
everything functions same

Last edited by Bluemax712; 12 Feb 2013 at 02:59. Reason: update for3rd try using vB3.8.7
Reply With Quote
  #8  
Old 12 Feb 2013, 00:38
Jeromedia603 Jeromedia603 is offline
 
Join Date: May 2008
This could be a great mod! Spot Reserved for when I have time to take a better look!
Reply With Quote
  #9  
Old 12 Feb 2013, 01:24
Bluemax712 Bluemax712 is offline
 
Join Date: Oct 2010
Originally Posted by Jeromedia603 View Post
This could be a great mod! Spot Reserved for when I have time to take a better look!
I know- can only pray will be able to get this to work
thanks much Lee
Reply With Quote
  #10  
Old 12 Feb 2013, 04:37
Bluemax712 Bluemax712 is offline
 
Join Date: Oct 2010
Not sure if I'm the only one having trouble and only know basics of programming but ...
Since it's only version 1.0 - it would be cool if could add a debug function to print out all the variables on a separate page while it's running
Reply With Quote
  #11  
Old 12 Feb 2013, 11:44
Lee Roberts's Avatar
Lee Roberts Lee Roberts is offline
 
Join Date: Jun 2008
Real name: Lee
Hi guys,

I dont think any other mods would/will give this mod any problems its far to simple for that and the info it needs from the database is unlikely to change unless vB make an update or change and i really cant see that happening.

The "Moderator Control Panel" setting dose nothing more then setup the link in the email that you recive, you should have this set to "modcp" unless your moderator control panel is in a folder with another name.

Your welcome, hopefully I can make this happen for you.

Lee

Last edited by Lee Roberts; 12 Feb 2013 at 21:36.
Reply With Quote
  #12  
Old 12 Feb 2013, 13:51
Bluemax712 Bluemax712 is offline
 
Join Date: Oct 2010
Thanks for the quick response Lee! Sent you a PM with the output
Reply With Quote
  #13  
Old 12 Feb 2013, 21:29
Lee Roberts's Avatar
Lee Roberts Lee Roberts is offline
 
Join Date: Jun 2008
Real name: Lee
Hi,

Today it was clear I needed to do some more work on this mod as it was failing for people, today I have released version 2 and would like you to download and install this version.

Please see the "Change Log" section of the main description for the things that have been done. Version 2 also fix's the problems apsrfvb4 has been having, so generally version 2 is better, sorry for any inconvenience!

Thanks,
Lee

Last edited by Lee Roberts; 12 Feb 2013 at 21:45.
Reply With Quote
  #14  
Old 12 Feb 2013, 23:39
Bluemax712 Bluemax712 is offline
 
Join Date: Oct 2010
Everything works perfect now Lee
Thanks so much for this awesome mod.

Installed on a 4.1.12 PL2 and a 4.2.0 PL3 server
Reply With Quote
  #15  
Old 15 Feb 2013, 16:21
cdoyle cdoyle is offline
 
Join Date: Oct 2004
Just installed, waiting for some moderated posts now

One thing for the next version that would be nice is to have an option so it just sends to all moderators.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Mod Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 10:44.

Layout Options | Width: Wide Color: