hello

I would like to know if is possible to directly subscribe some specific users to a specific Free plan using a SQL query.

In fact I want hidden (using CSS) from registrations page all plan and according to what kind of data user provide, I want place user in some specific plan and usergroup. In practice that mean user will not be allowed to choose anything at registration. Is only when they are already member of a plan, I will display some private upgrade plan in their own Subs Tab and allow them to chose something.

Is possible ??

My setup is a bit complex and will be quite long to explain...but all my need can be done if is possible to do that...

thank

no I target all users (who have a secret key) and not only one. In fact is because I would like use your own plugin DB Lookup field and add to it a query who allow to subscribe users to a specific plan.

I already ask you that on the Incubator forum and you told me it can be difficult but without telling more about. However I suppose is possible but maybe not... I don't know if the fact to put a user inside a Plan can be done with a query or if is technically not possible...

any clue ?

many thank

Ok I see....

So after making many test it seem the only way for me to do what I want is to set all my plan to be not exclusive...but I'm not sure if this setup will not give me bad surprise...

I don't understand well the concept "exclusive" and if that make sens to have it when used with other plan who are not exclusive...

For example here at Joomlapolis you have choose to make all your plan exclusive (if I'm not wrong). That mean we can't be at the same time Simple user, Advanced and Professional...but concretely is the case because I'm Professional and so I can get all stuff planned for Advanced and Simple free users. So instead to be recognized as Simple Free User + Advanced + Professional I'm just Professional...

Maybe is better to tell you what kind of setup I have actually:

1) REGISTERED free exclusive lifetime plan (for registered usergroup)

2) SILVER business free exclusive lifetime plan (for author usergroup)

3) GOLD business paid exclusive plan for 1 year (for author usergroup)

All plan are TOP plans and do not have any children plans...

My REGISTERED simple users will never move from this plan and will never be allowed to upgrade to SILVER or GOLD. My SILVER users will be allowed to upgrade to GOLD only and never allowed to downgrade to REGISTERED. My GOLD users will be only allowed to back to SILVER when they GOLD subscription finish and never allowed to downgrade to REGISTERED.

Later I think to create some other plan who will allow SILVER or GOLD only to subscribe and get more features...

So if now I transform all my plans from Exclusive to non-Exclusive I will be able to place users (in hidden manner) in the plan I want when they registers. This because by making plan non-exclusive is possible to set all plans "default/checked" and to conditionally propose plans based on CB field and CB Lookup field. All plans are hidden (using CSS) from Registration form/process so only me will know where users will be placed at registration according to data they provide.

The only problem I see is when my users become GOLD they will be also SILVER...and this is a bit annoying... Otherwise it seem no other "problem" will happen...

Actually I don't have many users and 99% of them are simple REGISTERED. So if I must make some change, is now the time to do because in near future many SILVER and GOLD must normally come... So I need to be sure to choose the correct setup and to think to the future when I will create other plans.

Have you some suggestion/advices to tell me ? Do you see some limit or issue if I choose to make all my plan not Exclusive ??

PS: The best for me would have been able to place users who will use the CB Lookup field directly in the SILVER plan OR to be able to set as default all Exclusive plan...but those solutions are not possible.

thank