Add-On Releases - DownloadsII PM moderation notification Add-On

DownloadsII PM moderation notification Add-On, is not a stand-alone mod. It requires DownloadsII 5.0.4 or higher.

You can find it here: DownloadsII (free)

What does it do?
When a user uploads a file via DownloadsII and that file is placed in moderation, all users that have the primary usergroup permission "Can Manage Moderation Queue" set to "Yes" will receive a PM notifying them about the file.

Installation
1. From the admincp, import the product file product-download2_pm.xml
2. Done!

Upgrade

1. From the AdminCP, import the product file product-download2_pm.xml with "Allow overwrite" set to yes
2. Done!

[CyberRanger]

Originally Posted by joeldaviddc

anybody can help me ???

Sorry for the slow replies. Lots of RL work keeping me tied up. I'll get an update out tomorrow to fix your problem and see if I can add more options for who gets the PM's.

In the meantime, if you'd like to fix the error yourself:

In the plugins "Alert Mods to Edited File in Moderation" and "Alert Mods to New File in Moderation",

FIND:

PHP Code:

$result = $db->query_read("SELECT title, usergroup.usergroupid, username, userid
               FROM " . TABLE_PREFIX . "usergroup, " . TABLE_PREFIX . "user
                           WHERE ecdownloadpermissions & 1024 AND  usergroup.usergroupid = user.usergroupid
            "); 


CHANGE TO:

PHP Code:

$result = $db->query_read("SELECT title, " . TABLE_PREFIX . "usergroup.usergroupid, username, userid
               FROM " . TABLE_PREFIX . "usergroup, " . TABLE_PREFIX . "user
                           WHERE ecdownloadpermissions & 1024 AND  " . TABLE_PREFIX . "usergroup.usergroupid = " . TABLE_PREFIX . "user.usergroupid
            "); 


[joeldaviddc]

thanks for your reply cyberranger.

I have made the changes you tell me, but i still receive a database error, finally i have changed a little bit your code to this

PHP Code:

$result = $db->query_read("SELECT title, vb_usergroup.usergroupid, username, userid
   FROM " . TABLE_PREFIX . "usergroup, " . TABLE_PREFIX . "user
                           WHERE ecdownloadpermissions & 1024 AND  " . TABLE_PREFIX . "usergroup.usergroupid = " . TABLE_PREFIX . "user.usergroupid
"); 


(my table prefix is vb_ , and i have added before the select for usergroup.usergroupid )

and now is working fine,

thanks a lot...

[CyberRanger]

Originally Posted by joeldaviddc

(my table prefix is vb_ , and i have added before the select for usergroup.usergroupid )

and now is working fine,

thanks a lot...

Ah, right, thanks! Sorry I missed that spot.

[Black Tiger]

Can my request from message #14 also be temporarily made by hacking a template or file? If yes, which code should i use?

[CyberRanger]

Originally Posted by Black Tiger

Nice hack. Coul'd there be a feature made so admin can decide who get's a pm? For example if you just want die admin to get a pm and not other people which can manage the moderation queu?

There are two plugins that control sending the PM's: "Alert Mods to Edited File in Moderation" and "Alert Mods to New File in Moderation" In both, the sql that selects the users to send the PM to is:

PHP Code:

$result = $db->query_read("SELECT title, usergroup.usergroupid, username, userid
               FROM " . TABLE_PREFIX . "usergroup, " . TABLE_PREFIX . "user
                           WHERE ecdownloadpermissions & 1024 AND  usergroup.usergroupid = user.usergroupid
            "); 


You could easily change the WHERE clause to get a different set of users. For example, to have the PM sent to the admin group, change the query to:

PHP Code:

$result = $db->query_read("SELECT title, usergroup.usergroupid, username, userid
               FROM " . TABLE_PREFIX . "usergroup, " . TABLE_PREFIX . "user
                           WHERE usergroup.usergroupid = 6
            "); 


[AScherff]

Originally Posted by CyberRanger

In the meantime, if you'd like to fix the error yourself:

In the plugins "Alert Mods to Edited File in Moderation" and "Alert Mods to New File in Moderation",

I have had the same problems and thought that was an error in DLII and contacted Jelle...

He gave me the hint to have a look here :-)

[Black Tiger]

@Cyberranger: Thanks very much! I will change it to admin only.

[Black Tiger]

Found another question.

WHERE usergroup.usergroupid = 6

Could there also be made a change to have just 1 user receive the pm's?
Maybe change this to WHERE userid = xx?
And if yes, do I need to change that somewhere else too?
Let's say I only want userid 2 to receive pm's, is that possible too?

[RS_Jelle]

Then you need to replace:

PHP Code:

$result = $db->query_read("SELECT title, usergroup.usergroupid, username, userid
               FROM " . TABLE_PREFIX . "usergroup, " . TABLE_PREFIX . "user
                           WHERE ecdownloadpermissions & 1024 AND  usergroup.usergroupid = user.usergroupid
            "); 


With:

PHP Code:

$result = $db->query_read("SELECT username, userid
               FROM " . TABLE_PREFIX . "user
                           WHERE userid = 2
            "); 


Note: you need to replace this two times. I removed the usergroup parts from the query as they aren't necessary for this, so it's a bit lighter.

It should work, but I didn't test it ...

[Black Tiger]

Great, thank you very much!!!