Try something akin to this:
PHP Code:
if ($bbuserinfo['usergroupid'] == 3) // awaiting email conf
{
$useractivation = $DB_site->query_first("SELECT activationid FROM useractivation WHERE userid = " .
$bbuserinfo['userid']);
$extraacttext = "You have not yet activated your account. To do so, click this link: <a href=\"register.php?s=" . $session['sessionhash'] .
"&a=" . $useractivation['activationid'] . "\">activate</a>";
}
else unset($extraacttext);
Then add $extraacttext to the correct template. Of course it makes activation via e-mail completely useless...