Skip to Content Skip to Menu

[SOLVED] cb:if statement

  • dmpneuro
  • dmpneuro
  • OFFLINE
  • Posts: 14
  • Thanks: 0
  • Karma: 0
11 years 8 months ago - 11 years 8 months ago #209885 by dmpneuro
[SOLVED] cb:if statement was created by dmpneuro
is there a way to create a cb:if statement with a comparison against a cb field?

for example

[cb:if username=[cb_altusername]][/cb:if]

so, it's to compare a user_id or usertype against the value in a cb field rather than a constant value (like "Public")?

Thanks
Last edit: 11 years 8 months ago by krileon.

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 68625
  • Thanks: 9109
  • Karma: 1434
11 years 8 months ago - 11 years 8 months ago #209900 by krileon
Replied by krileon on topic Re: cb:if statement
Nope, your best solution is to do your value matching with a CB Query Field then output and 1 if success or 0 if fail then match 1 or 0 in your CB IF statement with the query field. Example as follows.

Query:
Code:
SELECT IF( `cb_field` = `cb_field`, 1, 0 ) FROM `#__comprofiler` WHERE `id` = '[user_id]'

Substitution:
[cb:if cb_query="1"]Pass[/cb:if]


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: 11 years 8 months ago by krileon.

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

  • dmpneuro
  • dmpneuro
  • OFFLINE
  • Posts: 14
  • Thanks: 0
  • Karma: 0
11 years 8 months ago #210007 by dmpneuro
Replied by dmpneuro on topic Re: cb:if statement
Thanks!

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

Moderators: beatnantkrileon
Powered by Kunena Forum

Facebook Twitter LinkedIn