S2Mmber registrant Database

Greetings S2Member Support Team!
#1, if I could search your Support Forum I would have done that. But, you do NOT ( And I recomend you do have that in the future):

I have a unique situation where I have to “pre-qualify” members @ http://aqualifedealers.com/membership-application/

If I “qualify” a member, I want tto “push” their registartion info the S2member mysql datbase. Now, it is my undertanding that S2Member uses the wp_uers database. Is that correct?

f so, what do I place in th efollowing fieds:

user_login varchar(60) utf8_general_ci No Change Drop More
Browse distinct values Add primary key Add unique index Add index Add FULLTEXT index
3 user_pass varchar(64) utf8_general_ci No Change Drop More
Browse distinct values Add primary key Add unique index Add index Add FULLTEXT index
4 user_nicename varchar(50) utf8_general_ci No Change Drop More
Browse distinct values Add primary key Add unique index Add index Add FULLTEXT index
5 user_email varchar(100) utf8_general_ci No Change Drop More
Browse distinct values Add primary key Add unique index Add index Add FULLTEXT index
6 user_url varchar(100) utf8_general_ci No Change Drop More
Browse distinct values Add primary key Add unique index Add index Add FULLTEXT index
7 user_registered datetime No 0000-00-00 00:00:00 Change Drop More
Browse distinct values Add primary key Add unique index Add index Add FULLTEXT index
8 user_activation_key varchar(60) utf8_general_ci No Change Drop More
Browse distinct values Add primary key Add unique index Add index Add FULLTEXT index
9 user_status int(11) No 0 Change Drop More
Browse distinct values Add primary key Add unique index Add index Add FULLTEXT index
10 display_name

Thank You!

Hi Ralph.

#1, if I could search your Support Forum I would have done that. But, you do NOT ( And I recomend you do have that in the future):

You can find the search box in the header of the page, where the s2Member logo is, but on the right. Still, I don’t remember your question having been asked before.

I have a unique situation where I have to “pre-qualify” members @ http://aqualifedealers.com/membership-application/

If I “qualify” a member, I want tto “push” their registartion info the S2member mysql datbase. Now, it is my undertanding that S2Member uses the wp_uers database. Is that correct?

Yes, users are in the standard WP tables for users, so you can use the WP functions or your own queries to do it. You can google this, I’m sure you’ll find something that helps you with this.

s2Member Pro has an API you can try to create users: [hilite path]Dashboard -› s2Member® -› API / Scripting -› Remote Operations API[/hilite]

Now, what may be simpler, is to just let the user register as a free user as part of the application process, using the s2Member custom profile fields to have the extra info you want them to submit, and then if they qualify, just edit their profile and bump the level to 1 or whatever. You can also change their level with PHP: Knowledge Base » Changing Roles/Capabilities via PHP

I hope that helps. :)

Thank You for your Prompt Response:

Unfortunately, I was pulled to solve another issue and was just able to get to my question. Thank you for your response, but for more reasons you do not need gto know, I have to pre-qualify them with our form @

http://aqualifedealers.com/membership-application/

So, I have googled wp_users database and have not found any satisfactorly explanation of what to place in the wp_usrs fields.

I need to know what! you guys now place in each field BECAUSE you are using the wp_users database to enter s2member members.

So, once again, I am asking what do you enter for the following wp_users table fields:

user_login varchar(60)
user_pass varchar(64)
user_nicename varchar(50)
user_activation_key varchar(60)
user_status int(11)
display_name

So, for example, where do I place teh Roles/Capaibilites Permisssions”????\

Thank You!

Hi Ralph,

As Cristian mentioned, s2Member provides an API for creating users. See Dashboard -› s2Member® -› API / Scripting -› Remote Operations API.

If you don’t want to use the s2Member Pro API, then you will need to consult with the WordPress.org Support Forums for help with creating WordPress users directly via the database (there’s also the WordPress wp_insert_user() function that may be of interest).

Assisting with custom code outside of the s2Member plugin is beyond the scope of our support policy (please see s2Member® » Support Policy » Outside Scope).

Thank you for your suggestions. You suggestions have given me what I need to continue…

You’re welcome, Ralph. Let us know if there’s anything else we can help with. :)

Raam

You CAN COUNT ON IT!!!

Thanks