[SOLVED] CB Auto-actions: unconfirm account

tommytoxen
OFFLINE
Posts: 61
Thanks: 11
Karma: 6

12 years 2 months ago - 12 years 2 months ago #213461 by tommytoxen

[SOLVED] CB Auto-actions: unconfirm account was created by tommytoxen

Loving CB Auto-actions. Got several setup already but having trouble figuring this one out.

I've created a tab in members "edit profile" called "security"

In there is a checkbox called "Delete account?"

If they check that then save their profile I'd like it to unconfirm their account. (I have a prune software installed, all unconfirmed accounts are deleted after 90 days).

I'm having trouble figuring out what to put in the code and triggers

Anyone know how to please? I know I'm a pain in butt :blush:

Last edit: 12 years 2 months ago by krileon.

Please Log in or Create an account to join the conversation.

krileon
ONLINE
Posts: 48708
Thanks: 8319
Karma: 1447

12 years 2 months ago - 12 years 2 months ago #213523 by krileon

Replied by krileon on topic Re: CB Auto-actions: unconfirm account

The below should do the trick.

Type: Query
Triggers: onAfterUserUpdate
Access: Everybody
Conditional: [cb_checkbox] Equal To 1
Query:

Code:

UPDATE `#__comprofiler` SET `confirmed` = 0 WHERE `id` = '[user_id]'

I'm not sure if you meant CBs confirmation field or not, but the above adjusts it. The below adjusts "block", which IMO seams the most appropriate.

Code:

UPDATE `#__users` SET `block` = 1 WHERE `id` = '[user_id]'

You could also have a second auto action after this that'll log them out too.

Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

Last edit: 12 years 2 months ago by krileon.

Please Log in or Create an account to join the conversation.

tommytoxen
OFFLINE
Posts: 61
Thanks: 11
Karma: 6

12 years 2 months ago #214091 by tommytoxen

Replied by tommytoxen on topic Re: CB Auto-actions: unconfirm account

I've said it before - you're a star.

Works like a charm, thank you!

The following user(s) said Thank You: krileon

Please Log in or Create an account to join the conversation.

Moderators: beat, nant, krileon