Flexibility concerns

Hello guys,

I'm about to launch an e-commerce site with a subscription model. Already tried AEC and I would like to test CBSubs as well.

However, flexibility is my main concern regarding your product. Is there any possibility to execute PHP code upon subscription and/or membership expiration. I would like to interact with an autoresponder and grant/deny access to PHPBB3 groups. I'm currently using JFusion for the bridge part between Joomla and PHPBB3. I'm a developer so I'll be able to handle the coding part.

For the autoresponder I can manage to subscribe people either by executing php code or by sending a message to an specific e-mail address, I don't know if the e-mail plugin will be up to the task. For the PHPBB3 part, I believe that JFusion will handle the user sync and perhaps by using the SQL plugin I'll be able to grant/deny group access, but I'll have to take a closer look.

Hoping to get a quick answer from you,

Best regards.

Post edited by: amazeika, at: 2009/07/06 20:21

There is currently no PHP execution plugin. It would be possible to develop an integration plugin to execute whatever PHP you so desire.

It would be possible to develop an integration plugin to execute whatever PHP you so desire.

This sounds interesting, but I'll need some kind of guide. Do you explain the procedure of plugin creation in your doc ?. If not, a non-encrypted plugin will do.

Thanks

Beat,

I think you are the guy that can help me out here. Is there any simple way to execute some PHP lines upon subscription/expiration. I can't believe you guys never though on this possibility, which I believe should not be that hard to implement.

krileon proposed an integration plugin. I'll be happy to work on that, but like I said, I need some guidance. A basic hello world kind integration plugin would be excellent.

I already bought a license to test it out. I'm reading the doc, tomorrow morning I'll make some tests.

From a developer's point of view, what I'm asking is an essential feature.

Best regards.

Agreeing with you.

CBSubs 1.0.1 provides that for MySQL but not yet for PHP.
MySQL 5 allows already many programatic actions btw.

We have that on our plans as soon as time permits to finish the API refactoring, however such simple events could be done faster.

Finally, i'm pretty sure you can do PHPBB3 groups access settings with simple SQL queries and using the SQL integrations plugin. Probably no PHP needed at all

This subforum about SQL action queries should give plenty of inspiration for that:

www.joomlapolis.com/component/option,com_joomlaboard/Itemid,38/func,showcat/catid,90/


FR #1141

Thank you Beat .

I'm pretty sure too that the SQL plugin will be enough for the PHPBB3 integration. The problem that I might have is that the Joomla and PHPBB tables are within the same server but in different DBs. I've not yet seen the SQL plugin, so I'll have to check if it can handle queries to external DBs. I see no reason why it shouldn't.

An idea, if PHP is necessary, of course this is a temporary solution, would be to run a cron job, let's say every 10 mins or so that checks for newly created subscriptions/expirations directly in the DB. Then the necessary actions will be performed through PHP.

I like a lot what I've seen so far, but the PHP integration is a must .

Thank you and take care,

Arunas