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!

[bc3tech]

i also do not receive a PM.

[RS_Jelle]

Originally Posted by bc3tech

i also do not receive a PM.

1. Are you sure that there are files placed in the moderation queue? You won't receive a noficiation of a file which passes the moderation queue and is added immediately.
2. Are you in a primary usergroup which has got the "Can Manage Moderation Queue" permission set to "Yes"?

Also make sure you are running the latest version of DownloadsII (version 5.0.6 at this moment).

[Black Tiger]

I just discovered I also don't receive pm's anymore after upgrading to the newest Download II version.
I can also answer both your questions with "yes" and it was working before.

[CyberRanger]

Originally Posted by Black Tiger

I just discovered I also don't receive pm's anymore after upgrading to the newest Download II version.
I can also answer both your questions with "yes" and it was working before.

I'll try to check this out sometime this week.

[CyberRanger]

Thx Jelle for once again doing almost all of the work!

################################################## ###############
# DownloadsII PM moderation notification Add-On 1.1 Changelog # Dec 14, 2007
################################################## ###############

CyberRanger
- Fixed the missing table prefixes causing a database error when you were using a table prefix for vBulletin

Jelle
- Changed some small things to the vBulletin coding standards
- Added a url, version check url and DownloadsII 5.0.4 dependency to the product XML (requires vBulletin 3.6)

################################################## ###############
# DownloadsII PM moderation notification Add-On 1.0 Changelog #
################################################## ###############

CyberRanger
- Initial Release

[Black Tiger]

Nice work! Does this also fix the pm problem we had?

[RS_Jelle]

Originally Posted by Black Tiger

Nice work! Does this also fix the pm problem we had?

I tested it on my site (DownloadsII 5.0.6, vBulletin 3.6.8 PL2), but I didn't experienced any problems
Try uninstalling the add-on (not DownloadsII itself of course ) and reinstalling it.

[Black Tiger]

Well it was working before the update to 3.6.8 PL1 and before the update to the next download II version.
It also could be it stopped working because of the change I made so only 1 usergroup will get the pm's. Maybe I made a mistake in there? It now says this:

PHP Code:

if ($_POST['purgatory'] == 1)
{

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


Usergroup 6=Administrator, however, I would rather to have it send only a pm to me.

[RS_Jelle]

Originally Posted by Black Tiger

Well it was working before the update to 3.6.8 PL1 and before the update to the next download II version.
It also could be it stopped working because of the change I made so only 1 usergroup will get the pm's. Maybe I made a mistake in there? It now says this:

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 = 6"); 


Usergroup 6=Administrator,

There's a small mistake in the query. The user and usergroup results aren't linked. This should work:

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 AND " . TABLE_PREFIX . "usergroup.usergroupid = 6"); 


Originally Posted by Black Tiger

however, I would rather to have it send only a pm to me.

Then you better use this query:

PHP Code:

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


[Black Tiger]

Great I will try the last one then, thanks!