[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
            ");