Thread

My client wants a membership site with two separate registration forms.

One form for free membership in the Investors member group that uses custom fields.
One form for paid membership in the Entrepreneur member group that also uses custom fields.

The custom fields are unique to each member group. I think I can do this with the standalone registration form for each group but how do I assign a user to a group? I haven’t found a solution in the forums.

If I use custom php to assign member groups what db tables to I need to update?

For payment I’m using SecurePay API and I need to know what db table and field to access to turn on membership after payment.

Do I have to use the standalone registration form? what limitations do I have in editing the provided member templates?

Thanks for your help.

Welcome to the ExpressionEngine forums, CapitalWorldConnect.

I’d recommend Solspace’s User Module.

If you use your own solution to update the member tables, you’d be using:

exp_members
exp_member_data
exp_member_homepage

For payment I’m using SecurePay API and I need to know what db table and field to access to turn on membership after payment.

EE membership levels are stored in the group_id field of exp_members. So it depends on which group you want them to be changed to.

Does that help?

I decided to fork over the cash and buy Solspace User Module because I’m on deadline and thought it would help me finish up faster.  I really like it!  I was kinda frustrated that I couldn’t use template embed code in the default member profile templates.

Next step is to attach to SecurePay and on success change the member group.

I’m glad you found a solution that you like so far.  Good luck with SecurePay! 

Since you have your initial issue fixed, I’m closing this thread out.  Don’t hesitate to start another if anything else comes up!

-greg