[CyberRanger]

Originally Posted by bonnie

Hello,

it's a great hack! Thanks.

But I have some problem. If I want upload a file to database, I get a SQL Error:

Database error in vBulletin 3.6.4:

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

MySQL-Error : Unknown table 'usergroup' in field list
Error no.   : 1109

The problem is: all table of my database begining with Tablepr?fix "vb_". Where can I found the SQL?

regards
J?rgen

ah ... darn! That's actually a problem in the PM notification add-on.
Look in the plugins "Alert Mods to New File in Moderation" and "Alert Mods to Edited File in Moderation". The code needs to be added near the beginning of each of those plugins.