1. Forums
  3. Support and Presales
  5. Professional Members Support
  7. [SOLVED] Integration CBSubs 1.2.0 with GroupJive 2.3 RC2

[SOLVED] Integration CBSubs 1.2.0 with GroupJive 2.3 RC2

12 years 9 months ago #169351 by mmjurado
Replied by mmjurado on topic Re: Integration CBSubs 1.2.0 with GroupJive 2.3 RC2
I was thinking that CB could use an update SQLActions for the plan and update the category auto_2 with [username]

To see how it works for me; backup done ""

Please Log in to join the conversation.

12 years 9 months ago - 12 years 9 months ago #169436 by krileon
Replied by krileon on topic Re: Integration CBSubs 1.2.0 with GroupJive 2.3 RC2
GJ 2.3 RC2 is out of date, please upgrade to GJ 2.3 Stable. CBSubs 1.2 GJ integration has full support for GJ 2.3; no need for SQL Actions. Please note using queries to alter GJ will result in none of the triggers being fired.. depending on what is changed and what variables integrations depend on this could result in serious problems. At any rate the below query would do as you're wanting.
UPDATE `#__groupjive_categories` SET `name` = '[username]' WHERE `name` = 'auto_2' AND `user_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: mmjurado

Please Log in to join the conversation.

12 years 9 months ago - 12 years 9 months ago #169443 by mmjurado
Replied by mmjurado on topic Re: Integration CBSubs 1.2.0 with GroupJive 2.3 RC2
If you upgrade to 2.3 stable and everything works perfect, but the query it gives me, I do not think it to generate a default group in the category [username].

I think it would:
INSERT INTO `jos_groupjive_groups` (`id`, `user_id`, `name`, `logo`, `description`, `type`, `date`, `ordering`, `category`, `published`, `access`, `invite`, `users`, `notify`, `params`) VALUES (null, [user_id], 'Mi Grupo', NULL, '', 1, CURRENT_TIMESTAMP(), 1, (select id from `jos_groupjive_categories` where user_id=[user_id]), 1, -2, 0, 1, '1|*|2', 'about_show=1\
about_public=1\
events_show=1\
events_public=1\
events_schedule=0\
file_show=1\
file_public=1\
file_upload=1\
wall_show=1\
wall_public=1\
wall_post=0');

thank you very much

Please Log in to join the conversation.

12 years 9 months ago - 12 years 9 months ago #169446 by mmjurado
Replied by mmjurado on topic Re: Integration CBSubs 1.2.0 with GroupJive 2.3 RC2
Excuse my English, you understand what I said?


With SQLAction and sql insert, yes generates the group "Mi Grupo " in the category of the username, all in one plan.

Attach image




Regards and thanks.
Attachments:

Please Log in to join the conversation.

12 years 9 months ago - 12 years 9 months ago #169480 by krileon
Replied by krileon on topic Re: Integration CBSubs 1.2.0 with GroupJive 2.3 RC2
Don't understand what you're trying to do. The integration can generate groups and/or categories based off subscription. You should not use direct queries as integrations do NOT execute. It's fine to UPDATE certain aspects of an EXISTING group or category as by then the critical triggers would've done executed assuming the group or category was created with API.

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.

Please Log in to join the conversation.

12 years 9 months ago #169492 by mmjurado
Replied by mmjurado on topic Re: Integration CBSubs 1.2.0 with GroupJive 2.3 RC2
I want to create a subscription plan with a category named [username] and a group "My Group" in the category [username].

From the plugin I can make a second auto_2 but obligatory (combo box) there have to select a category and I want to set [username].



Attachments:

Please Log in to join the conversation.

Moderators: beat, nant, krileon
  1. Forums
  3. Support and Presales
  5. Professional Members Support
  7. [SOLVED] Integration CBSubs 1.2.0 with GroupJive 2.3 RC2
Time to create page: 0.254 seconds

Facebook Twitter LinkedIn

    You are here:  
  1. Home
  2. Forums
  3. Support and Presales
  4. Professional Members Support
  5. [SOLVED] Integration CBSubs 1.2.0 with GroupJive 2.3 RC2

Search

Login / Logout

User Menu