[SOLVED] Family subscriptions with CBSubs and AutoActions

I may have one tiny little question left...

I'm trying to block both the child and parent accounts in case of unsubscription. I'm using CBSubs SQL actions as you suggested. In my plan, right now, I have this:

Note that I'm using the child account's user name now - which I collect earlier in the process just after generating it, this is stored in the parent account. I'm doing this because they could change their e-mail address so filtering on the e-mail isn't reliable enough.
The first request works fine and the child account gets blocked.
The second request doesn't work and I'm wondering why. I've checked and the owner's user name is indeed stored in a field named [username] in lower case... So I guess this should work.
Can I use the user ID there? [user_id] I guess? It's not listed in the examples on that page.

Thanks.

Seb.

It's supposed to split up the queries that end in a ; followed by a line break. So it should run the first query followed by the second query. Ensure there is an actual linebreak after ; of the first query.

Hi,

They are both on their own line and just to make sure, I added an empty line between the two... Only the first query is being executed.
For a moment I wondered if there wouldn't be a problem with the where clause and my [username] field, but I created the "family 3" subscription (1 main account + 2 sub-accounts), so when unsusbscribing from this one I have one additional query, like this:

I know both [cb_family1user] and [cb_family2user] are properly populated (plus, if they were not, the accounts wouldn't have been created anyway...) yet only the 1st query works.

Any idea why?

Thanks.

Seb.

Edit: forget the last part of my answer... I apparently had set the query for family2user only for expiration, not for deactivation. I'll test and see if it's being executed, if yes then it means the problem lies only with the main account's query.

Ok... The family2user query was executed, both sub-accounts were disabled.
The problem is definitely with the main account's query...

You could always just use a single query for that. Example as follows.


Regarding why your current usage isn't working it's because after [cb_family1user] you're missing a single quote before ;. Notice it only has 1 quote. I'm surprised this works at all given the missing quote.

Am also unsure if you can even block a user at that time as they're going to be have their user object saved by CBSubs which will probably override your query change to the main account.

No I do have that quote, look closer...
Besides I've confirmed the second query with family2user is being executed just fine.
But if you think CBSubs may be be overriding my change then this would explain...
I'll look for another solution for the main account then. Maybe change its group which would deny him access just as surely as blocking his account since all the features reserved to my subscribers depend on a particular group...