[jluerken]

// Get all users who have not activated their accounts.
$userArray=$DB_site->query("
SELECT username,user.userid,email,joindate,activationid
FROM user
LEFT JOIN useractivation ON (user.userid=useractivation.userid)
WHERE user.usergroupid=3 AND user.posts = 0
");

This part is not working when using table prefixes. Could this be updated please?

I also only want to have an email as admin which users can be deleted. I don't want the script to do so.