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

Is there a way I can allow my users to publish/unpublish their own account? Not delete it, but deactivate it and then be able to reactivate it.
Possible?

There might be something at Joomla.org, but am not aware of any such feature unless for example they ask a moderator to ban their account. CB it self does not provide such a feature. I suppose you could create a checkbox field then use CB Queries to execute a database query to ban their profile with the reason of "Disabled account" for instance after profile update checking that the checkbox field is equal to 1 first.

Good morning K,
I downloaded and installed Queries and created a checkbox for "Disable Account".

Is there any chance you could write me what the query I should add is? I haven't the faintest idea how to do that. I'll appreciate it enormously.

Also, once the user checks that box and disables his account, will that user be able to login again and re-enable his/her account?

Indeed, I found nothing that could do that, so that query is like the holy grail of... well... disabling accounts on CB

Cheers,
bk
PS - does this have anything to do with it? docs.joomla.org/API15:JTable/publish

Is there any chance you could write me what the query I should add is? I haven't the faintest idea how to do that. I'll appreciate it enormously.

Please see the below configuration. You will need to create 2 of these, 1 for enable and 1 for disable.

Disable
Trigger: onAfterUserUpdate,onAfterUpdateUser
User: Automatic
Access: - All Registered Users
Condition: FIELD, Equal To, 1
Query: Mode: Internal

Enable
Trigger: onAfterUserUpdate,onAfterUpdateUser
User: Automatic
Access: - All Registered Users
Condition: FIELD, Empty
Query: Mode: Internal

Please test the above thoroughly. It may require tweaking and is completely untested.

Also, once the user checks that box and disables his account, will that user be able to login again and re-enable his/her account?

No, but they'll still be able to use the site moderately; their profile would be disabled which would give them contact information to contact a moderator if need be.

I don't know what to say :woohoo:
I cannot give Community Builder another rave review since i already did on joomla.org
Thank you so much for your continuous incredible support. I am so glad I decided to use CB. What an incredible thing and what an incredible team you guys are.

Works perfectly well.

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?

BK