[Marco van Herwaarden]

Better to edit the manageActivation.php.

Find:

PHP Code:

    $userArray=$DB_site->query("
        SELECT username," . TABLE_PREFIX . "user.userid,email,joindate,activationid 
        FROM " . TABLE_PREFIX . "user
        LEFT JOIN " . TABLE_PREFIX . "useractivation ON (" . TABLE_PREFIX . "user.userid=" . TABLE_PREFIX . "useractivation.userid)
        WHERE " . TABLE_PREFIX . "user.usergroupid=3 AND " . TABLE_PREFIX . "user.posts = 0 
    "); 


And replace by:

PHP Code:

    $userArray=$DB_site->query("
        SELECT username,user.userid,email,joindate,activationid 
            FROM " . TABLE_PREFIX . "useractivation AS useractivation
            LEFT JOIN " . TABLE_PREFIX . "user AS user ON(user.userid=useractivation.userid)
            WHERE dateline = 
                (select MAX(dateline) FROM " . TABLE_PREFIX . "useractivation AS ua2 WHERE ua2.userid = useractivation.userid)
            AND user.usergroupid=3 AND user.posts = 0    "); 


Your code wouldn't work sabe, try it.

PS I not tried my solution, so test it on a testboard first.

Not tested, but i think that would do the trick.