[SOLVED] CBSubs: CB Fields integration not working on deactivation
8 years 2 months ago #278576
by lousyfool
Replied by lousyfool on topic CBSubs: CB Fields integration not working on deactivation
Oh Kyle...
Me again
I was too fast, it wasn't solved, yet. Any unsubscribing of a plan in the frontend, by either user or moderator, would not result in the "Plan Expired" Auto Action to be successful, the field value wouldn't change.
Tired of it, I've now scrapped all related CB Fields integration and Auto Actions, and instead solely rely on SQL Actions in the plans, for example...
...for activation and renewal:
...for expiration and deactivation:
I know, the manual says it shouldn't be used for modding #__comprofiler, but I can't see how this could hurt.
Case finally closed - thanks again!
Me again
I was too fast, it wasn't solved, yet. Any unsubscribing of a plan in the frontend, by either user or moderator, would not result in the "Plan Expired" Auto Action to be successful, the field value wouldn't change.
Tired of it, I've now scrapped all related CB Fields integration and Auto Actions, and instead solely rely on SQL Actions in the plans, for example...
...for activation and renewal:
UPDATE `#__comprofiler` SET `cb_paa` = '1' WHERE `id` = [user_id]...for expiration and deactivation:
UPDATE `#__comprofiler` SET `cb_paa` = '0' WHERE `id` = [user_id]I know, the manual says it shouldn't be used for modding #__comprofiler, but I can't see how this could hurt.
Case finally closed - thanks again!
Please Log in to join the conversation.
krileon
8 years 2 months ago #278653
by lousyfool
Thanks - good stuff, simple enough, and maybe it's something for "sarah963" or others. With my SQL Actions working, I might leave it there until some point later.
On your note, I could think of more Auto Actions with CBSubs which I also didn't get to work, so I also had to use SQL Actions with slightly more tricky queries (this was about CBSubs and CB Activity).
But again, with all these SQL Actions working for me, I now need to focus on other to-do's in the project...
Replied by lousyfool on topic [SOLVED] CBSubs: CB Fields integration not working on deactivation
krileon wrote: You can quickfix this issue in CBSubs with the below change.
Thanks - good stuff, simple enough, and maybe it's something for "sarah963" or others. With my SQL Actions working, I might leave it there until some point later.
On your note, I could think of more Auto Actions with CBSubs which I also didn't get to work, so I also had to use SQL Actions with slightly more tricky queries (this was about CBSubs and CB Activity).
But again, with all these SQL Actions working for me, I now need to focus on other to-do's in the project...
Please Log in to join the conversation.
Moderators: beat, nant, krileon
Time to create page: 0.228 seconds
