Detecting user account confirmation

[TruDan]

For forum-side checking, please make it possible to check whether the user has confirmed their forum account (such as email-activation that the forums do). This is generally a column in the same table as users, so its a case of adding a WHERE clause to the SQL