Skip to Content Skip to Menu

[SOLVED] Trigger to block user

  • Hansueli
  • Hansueli
  • OFFLINE
  • Posts: 48
  • Thanks: 1
  • Karma: 0
10 years 8 months ago - 10 years 8 months ago #241918 by Hansueli
[SOLVED] Trigger to block user was created by Hansueli
As a result of a trigger I like to block a user.
I cannot find a Type where I can change the Joomla variable __user.block
Cab you help me?

rh
Last edit: 10 years 8 months ago by krileon.

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 48478
  • Thanks: 8282
  • Karma: 1443
10 years 8 months ago #241954 by krileon
Replied by krileon on topic Trigger to block user
I'm not sure what trigger you're using, but to block them you'll need to use a Query action with the below query.

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


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.
The following user(s) said Thank You: Hansueli

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

  • Hansueli
  • Hansueli
  • OFFLINE
  • Posts: 48
  • Thanks: 1
  • Karma: 0
10 years 8 months ago - 10 years 7 months ago #242030 by Hansueli
Replied by Hansueli on topic Trigger to block user
perfect

rh
Last edit: 10 years 7 months ago by Hansueli.

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

Moderators: beatnantkrileon
Powered by Kunena Forum