Send encrypted password to external database

Hi

I am testing external queries using cb auto actions that insert newly registered users into external databases. I can sucessfully insert values into the external #_users, #_comprofiler and #_user_usergroup_map tables using the following mysql (mysql for each table has appropriate alterations obviously):

INSERT INTO `****.`*****` (
`id` ,
`name` ,
`username` ,
`email` ,
`password` ,
`usertype` ,
`block` ,
`sendEmail` ,
`registerDate` ,
`lastvisitDate` ,
`activation` ,
`params`
)
VALUES (
NULL , '[name]', '[username]', '

Password is encrypted with PHP, you can't do this strictly through MYSQL. You should use a Code action with PHP as its method to register a user using the below API.

www.allmysocials.com/directory/tutorials/item/237-create-users-through-api

Ok thanks. Any tips on how I can go about doing this? I'm not well versed with this stuff. To recap: When a user registers on one site A I need the same user to be registered on site B automatically.

That's a bit different. I believe you'll need to point $_CB_database to your second site using the below.

After the above you'd do the registration and instead of using $_CB_database you'd use $_SQL_database.

Sorry, there is no tutorials or assistance with custom development. You'll simply have to keep working with it until you've understood the API and got it working.

Thanks, I'll look into that for potential future use. For the time being I solved the issue by using:[cb:userdata field="password" /]

Note [password] is plaintext after registration and after login. It has not been encrypted yet. Ensure you're using the appropriate trigger for the encrypted password.