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!

{reserved}:confused:

*Clicks Install*

Thanks, this will come in handy a little later on. Just confirming this will work for 3.6.2 as well, as I couldnt find a 3.6 thread.

Thanks.

EDIT: Read in the other thread that this will work for 3.5.5 up to 3.6.2

Thanks.

Thnaks CyberRanger !

Hi

I have the latest downloadsII installed, I have also just added this and ii am admin at the admin usergroup to "Can Manage Moderation Queue" yet when a file is uploaded ii do not get a PM with regards to the said file, Any ideas please?

You will only get a PM if the user uploading the file has the usergroup permission "Can Avoid Moderation Queue" set to "No". Is the file in the moderation queue?

Hi, Yeah the permission is set to no for "Can Avoid Moderation Queue"
I have checked this on 1 of my staff and also on a spare standard account that ii have for such as checking stuff like this...

Do ii need to re upload the product again?

Can you PM me your URL with a vb admin user account and password? I'll check it out for.

Also, for your account, make sure in your usercp -> options that "Receive Private Messages only from Buddies and Moderators" is not checked. The mod will not over-ride that.

Hi....PM sent, I have PM's set for all members to PM me as well :)

Did you find anything untoward m8?

Sorry, but not yet. I looked extensively the other day but can't figure out why the PM is not sent. As I'm sure you've seen, no errors ... but no PMs! I fear that something with your other PM mod is interfering. I hope to look at it some more tomorrow.

Ok m8 no probs, thanks again :)

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?

Is my idea not possible to make? Would really be a nice feature.

Does this work with 3.6.+?

Yes, it does ;)

i have installed the donwloadII mod in my vb 3.6.5 without problems, but if i install this mod i receive a databse error when a user try to make an unpload, the file is upload but i do not receive pm notifications.. i receive a database error from vbulletin. this is the content of the message:

Database error in vBulletin 3.6.5:

Invalid SQL:
SELECT title, usergroup.usergroupid, username, userid
FROM vb_usergroup, vb_user
WHERE ecdownloadpermissions & 1024 AND usergroup.usergroupid = user.usergroupid;

MySQL Error : Unknown column 'usergroup.usergroupid' in 'field list'
Error Number : 1054
Date : Thursday, March 8th 2007 @ 12:15:36 PM
Script : http://www.mydomain.com/foro/downloads.php?do=add&id=
Referrer : http://www.mydomain.com/foro/downloads.php?do=add&cat=1

i have uninstalled the pm-notification mod and all is working fine...

@Jelle: Could you have a look at msg #14? I posted it long ago, but did not get an answer if it was possible or if you could maybe put it in a future release.

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:
CHANGE TO:

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

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

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

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

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 :-)

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

Found another question.:)
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?

Then you need to replace:
With:
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 ...

Great, thank you very much!!!

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

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.

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

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 :confused:
Try uninstalling the add-on (not DownloadsII itself of course :p) and reinstalling it.

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:
Usergroup 6=Administrator, however, I would rather to have it send only a pm to me.

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

Then you better use this query:

Great I will try the last one then, thanks!