Still loving that my users can activate or deactivate their account, but now I'm facing another problem. Suppose I want to Ban their profile for some reason, they can always simply select Enable and reactivate their account.
Is there a way to allow them to reactivate their account, only if the reason = Account manually disabled?

UPDATE `#__comprofiler` SET `banned` = 0, `unbanneddate` = NOW() WHERE `user_id` = '[user_id]' AND `bannedreason` = 'Account manually disabled'

userbk wrote: Thanks K, but the problem is that even if a moderator disables the account for say "Cause I feel like it" reason and then the user disables his own account, the reason turns into "Account manually disabled" and then he can simply update the account again with enabled selected and it unbans it

UPDATE `#__comprofiler` SET `banned` = 1, `banneddate` = NOW(), `bannedby` = '[user_id]', `bannedreason` = 'Account manually disabled' WHERE `user_id` = '[user_id]' AND `bannedreason` IN ( '', 'Account manually disabled' )