[SOLVED] Integration CBSubs 1.2.0 with GroupJive 2.3 RC2

mmjurado
OFFLINE
Posts: 25
Thanks: 0
Karma: 0

13 years 3 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 or Create an account to join the conversation.

krileon
OFFLINE
Posts: 48419
Thanks: 8274
Karma: 1443

13 years 3 months ago - 13 years 3 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.

Code:

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.

Last edit: 13 years 3 months ago by krileon.

The following user(s) said Thank You: mmjurado

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

mmjurado
OFFLINE
Posts: 25
Thanks: 0
Karma: 0

13 years 3 months ago - 13 years 3 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:

Code:

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

Last edit: 13 years 3 months ago by mmjurado.

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

mmjurado
OFFLINE
Posts: 25
Thanks: 0
Karma: 0

13 years 3 months ago - 13 years 3 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:

Last edit: 13 years 3 months ago by mmjurado.

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

krileon
OFFLINE
Posts: 48419
Thanks: 8274
Karma: 1443

13 years 3 months ago - 13 years 3 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.

Last edit: 13 years 3 months ago by krileon.

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

mmjurado
OFFLINE
Posts: 25
Thanks: 0
Karma: 0

13 years 3 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 or Create an account to join the conversation.

Moderators: beat, nant, krileon