[SOLVED] Allow users to deactivate (unpublish) their profil

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?

Absolutely, please use the below query.

The above would only unban them if the reason is exactly "Account manually disabled" (without quotes).

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 :dry:

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 :dry:

Of course, the query only addresses unsetting of the ban and not setting of the ban. The below would address setting of the ban.

Please understand this is basic MYSQL and time consuming to continually personalize. I recommend reviewing the below MYSQL documentation.

dev.mysql.com/doc/refman/5.0/en/index.html

Thanks K, I will read it and try to learn. Thanks for your help!!
BK