Notify Moderators

All new MODs released in our MOD Database will be announced in here. All support for released MODs needs to take place in the Customisations Database.
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

NOTICE: This forum is only for the announcement of new releases and/or updates of MODs. Any MOD support should be obtained through the Customisations Database in the support area designated for each MOD.

A direct link to support for each MOD is in the first post of the respective topic.
NicksNet
Registered User
Posts: 55
Joined: Sat Apr 04, 2009 1:16 pm

Re: Notify Moderators - Installing

Post by NicksNet »

PhilTilson wrote:I have carefully followed all the instructions for installing this mod (though, as this is the first time I have attempted anything like this, I may well have cocked it up!) and when I get to the very bottom, it says

"1. Open your web browser and run install_notify_moderators.php."

When I try to do this, I get a message saying that I must have Founder status to run this. As I am the one who uploaded and set up the damned thing in the first place, surely I AM the founder?!

Clearly there is something I need to do here, but the FAQs on the board have no mention of founder at all. Can somebody advise, please?

Thanks.

hi,

you must be logged in to your board to install, check in ACP if you are the founder of the board - founder is, who has installed the forum... on install you have to declare a user (on memberlist mostly its the first user - userid 2)

also you can change the founder option for your account in phpmyadmin

good luck
Sorry, my English isn't the best...
PhilTilson
Registered User
Posts: 19
Joined: Thu Aug 06, 2009 3:02 pm

Re: Notify Moderators

Post by PhilTilson »

you must be logged in to your board to install, check in ACP if you are the founder of the board - founder is, who has installed the forum... on install you have to declare a user (on memberlist mostly its the first user - userid 2)
Yes, I was logged in but I can find nothing in the ACP to say that I was the founder of the board - even though I was/am!

I have looked in the users table in the database and I appear to be in there twice - it's difficult to tell as many fields are BLOBs. However, I am pretty sure I was user_id 2, as the user_ip shown was mine. However, no avatar reference is shown. I also seem to be there as user_id 31 - this shows the same user_ip but also shows an avatar reference.

It's probably something stupid I did when setting the thing up! It's the first time I have tried anything like this.

Following another posting, I ran a MySQL update to change the user_type to 3 for the second of the records mentioned above - user_id 2 was already user_type 3. Can I have two user_type 3's? And it still hasn't made any difference.

I even tried deleting everything in the cache directory (except index.htm - there was no .htaccess) but that hasn't helped either - I just get the same error message.
also you can change the founder option for your account in phpmyadmin
I think this is probably what I was just describing - or is there something else I can do? :(
NicksNet
Registered User
Posts: 55
Joined: Sat Apr 04, 2009 1:16 pm

Re: Notify Moderators

Post by NicksNet »

in phpmyadmin table phpbb_users your user_type is 3?
then you must have the permission to install mods

in ACP under USer and Groups, search your username and on first page is the founder option - you can see founder checkbox only if you are founder (i think so)

if you are a founder and still you cant install, please ask here for help

regards
Sorry, my English isn't the best...
steve.dietrich
Registered User
Posts: 1
Joined: Fri Nov 20, 2009 1:32 am

Version 3.06 using AutoMod

Post by steve.dietrich »

I realize it states only tested on version 3.01, however I would really like to use this Mod.

This is the error I receive when using AutoMod.
Find
delete_posts('post_id', $post_disapprove_sql);
Add Before
// Notify moderators mod
if (!function_exists('notify_moderators'))
{
include_once($phpbb_root_path . 'includes/functions_notify_moderators.' . $phpEx);
}
foreach ($post_disapprove_sql as $disapprove_post_id)
{
notify_moderators('disapprove', $disapprove_post_id, $user->data['user_id'], $disapprove_reason);
}
The Find specified by the MOD could not be found


I did a force install but, it did not seem to work at all. Any suggestions or ideas on a fix??

If this will not work with 3.06, is there a similar mod to this?

Thank you!

~Steve
Last edited by steve.dietrich on Fri Nov 20, 2009 4:25 pm, edited 1 time in total.
PhilTilson
Registered User
Posts: 19
Joined: Thu Aug 06, 2009 3:02 pm

Re: Notify Moderators

Post by PhilTilson »

Post removed - my mistake! :oops:
Last edited by PhilTilson on Fri Nov 20, 2009 9:57 am, edited 1 time in total.
PhilTilson
Registered User
Posts: 19
Joined: Thu Aug 06, 2009 3:02 pm

Re: Notify Moderators

Post by PhilTilson »

Hi NicksNet - problem solved! Thanks for your help.

I think it was a combination of things - the fact that I was somehow there as two separate users, only one of whom was a founder, and the fact that the board is actually in a sub-folder of the main account.

I was trying to activate the mod from the main account, rather than the board sub-folder. It now seems to be working fine; if I have any other problems, I'll let you know!

Thanks again. :D
mroberts3
Registered User
Posts: 2
Joined: Wed Dec 02, 2009 8:23 am

Re: Notify Moderators

Post by mroberts3 »

I just installed this on 3.0.6. After doing the complete install I went back and made the changes on page 1.

I'm not receiving emails when new posts occur. I then enabled the PM, but did not receive them either.

Anyone have any ideas?? Has anyone successfully installed this on 3.0.6?

Thanks for any help you can provide.
sabbelprotz
Registered User
Posts: 1
Joined: Mon Nov 16, 2009 7:24 pm

Re: Notify Moderators

Post by sabbelprotz »

Hi there!

I installed this mod on 3.0.5. The version I used is 1.0.1. I also applied the additional mod instructions on the first page of this thread.

Tip to get Mails:
Make sure you config it to notify admins, mods and global mods (set all three to yes in ACP).

It worked with 3.0.5.
And I updated to 3.0.6 !

For 3.0.6 I had a lot of work to translate new features of the board to German. Also mods needed special attention. But the update went pretty good. Only with Notify Moderators there were an issue in report.php. The update failed to get the changes in this file handeled. At least I used the new original 3.0.6 report.php and applied changes for the mod afterwards. That was quite easy and in generall the update was successful.

But that was my first update and I wanted to be sure. So I created a detailed testing szenario (only mail notification was tested) to check every single feature of the Notify Admins MOD.

Errors with phpBB3 3.0.6:
  • When denying a topic or post in the moderator queque there are errors displayed and previously informed admins/mods are NOT informed that the task has been done.

    Code: Select all

    [phpBB Debug] PHP Notice: in file /includes/mcp/mcp_queue.php on line 872: Invalid argument supplied for foreach()
    
    Warning: Cannot modify header information - headers already sent by (output started at /myroot/htdocs/phpBB3/includes/functions.php:3493) in /myroot/htdocs/phpBB3/includes/functions.php on line 4209
    
    Warning: Cannot modify header information - headers already sent by (output started at /myroot/htdocs/phpBB3/includes/functions.php:3493) in /myroot/htdocs/phpBB3/includes/functions.php on line 4211
    
    Warning: Cannot modify header information - headers already sent by (output started at /myroot/htdocs/phpBB3/includes/functions.php:3493) in /myroot/htdocs/phpBB3/includes/functions.php on line 4212
    
    Warning: Cannot modify header information - headers already sent by (output started at /myroot/htdocs/phpBB3/includes/functions.php:3493) in /myroot/htdocs/phpBB3/includes/functions.php on line 4213
  • A new feature in 3.0.6 is that PNs can be reported. The Notify Admin Mod handels theese reports too but the links in all e-Mails are NOT usable.

    Code: Select all

    Hello Testuser,
    
    You are receiving this notification because are either an Administrator or
    a moderator of the  forum.
    
    The following report has been made by  in the topic : 
    
    Topic URL      :  http://www.myurl.de/viewtopic.php?f=&p=
    Report URL     : 
    http://www.myurl.de/mcp.php?i=reports&mode=report_details&f=&r=
    Subject        :  
    Report reason  :  
    Report message :
I really hope the functionality of this mod + display of quequed items (quequed posts/topics, open reports, group applications, accounts to unlock) are included by default in phpBB3.

Thanks to the author of this mod! Good work!
If there is a new version of the mod let us know.
lkview
Registered User
Posts: 6
Joined: Mon Feb 23, 2009 6:31 am

Re: Notify Moderators

Post by lkview »

I have 3.06. I installed this mod using Automod. It seemed go flawlessly, except for one one issue, where it could not find this in includes/mcp/mcp_queue.php:
delete_posts('post_id', $post_disapprove_sql);

But I found another line that was nearly the same:
delete_posts('post_id', array_keys($post_disapprove_list));

So I inserted the code before that line instead.

Next, I did all the edits on p1 of this thread.

But apparently the install did not work, because I don't see any place to make configuration changes in the control panel. Any suggestions what I should do now? Thanks very much for your assistance.
ping20
Registered User
Posts: 8
Joined: Mon Dec 14, 2009 9:26 am

Re: Notify Moderators

Post by ping20 »

is it possible to notify even I am edit my post? if so how can I do it? Thank you.
rautamiekka
Registered User
Posts: 125
Joined: Wed Jul 18, 2007 10:47 pm

Re: Notify Moderators

Post by rautamiekka »

ping20 wrote:is it possible to notify even I am edit my post? if so how can I do it? Thank you.
ACP -> ".MODS" tab -> Notify moderator settings.
ping20
Registered User
Posts: 8
Joined: Mon Dec 14, 2009 9:26 am

Re: Notify Moderators

Post by ping20 »

Thank you sir :-)
Next things is I didn't get any e-mail when I edit my post reply and it is not the last post reply of that topic.

Any idea for this issue?

Best Regards,
Ping
ping20
Registered User
Posts: 8
Joined: Mon Dec 14, 2009 9:26 am

Re: Notify Moderators

Post by ping20 »

Hello again :)

I have a question, is it possible to config this mod to notify other group? anyone had ever implement this before? Thank you in advance for your help.

Kindly Regards,
Ping.
User avatar
dmkratt
Registered User
Posts: 3
Joined: Thu Feb 11, 2010 4:53 pm

Re: Notify Moderators

Post by dmkratt »

On SLQ Server (2008, but this would occur on 2000 or 2005 as well) receiving an error


General Error
SQL ERROR [ mssql ]

Column 'phpbb_users.username' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
Column '%.*ls.%.*ls' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. [8120]

SQL

SELECT TOP 25 u.user_id, u.username, u.username_clean, u.user_lastvisit, u.user_colour, u.user_notify_type, u.notify_moderator FROM phpbb_users u WHERE u.user_id IN (2, 55, 57, 53, 54, 56, 58) GROUP BY u.user_id ORDER BY u.username_clean ASC

BACKTRACE


FILE: includes/db/mssql.php
LINE: 153
CALL: dbal->sql_error()

FILE: includes/db/mssql.php
LINE: 205
CALL: dbal_mssql->sql_query()

FILE: includes/db/dbal.php
LINE: 170
CALL: dbal_mssql->_sql_query_limit()

FILE: includes/acp/acp_notify_moderators.php
LINE: 126
CALL: dbal->sql_query_limit()

FILE: includes/functions_module.php
LINE: 507
CALL: acp_notify_moderators->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()



The SQL in includes\acp\acp_notify_moderators.php here:

Code: Select all

				// Get moderator details
				$sql = 'SELECT u.user_id, u.username, u.username_clean, u.user_lastvisit, u.user_colour, u.user_notify_type, u.notify_moderator
					FROM ' . USERS_TABLE . ' u
					WHERE ' . $db->sql_in_set('u.user_id', array_unique($mod_notify_ary)) . '
					GROUP BY u.user_id
					ORDER BY u.username_clean ASC';
needs to be replaced with:

Code: Select all

				// Get moderator details
				$sql = 'SELECT u.user_id, u.username, u.username_clean, u.user_lastvisit, u.user_colour, u.user_notify_type, u.notify_moderator
					FROM ' . USERS_TABLE . ' u
					WHERE ' . $db->sql_in_set('u.user_id', array_unique($mod_notify_ary)) . '
					GROUP BY u.user_id, u.username, u.username_clean, u.user_lastvisit, u.user_colour, u.user_notify_type, u.notify_moderator  
					ORDER BY u.username_clean ASC';
rautamiekka
Registered User
Posts: 125
Joined: Wed Jul 18, 2007 10:47 pm

Re: Notify Moderators

Post by rautamiekka »

A feature request:

Admins/Mods shouldn't be notified of happenings inside locked areas, meaning the ones access to the area must use the subscription feature inside phpBB. Also, Notify Moderators should in that case check whether the subscripted ones are Admins or Mods, depending on the settings of Notify Moderators so that the allowed ones can receive notifications of every event inside the area ofcourse depending on the settings of Notify Moderators.

Return to “[3.0.x] MOD Database Releases”