Import Users

Questions related to using nuBuilder Forte.

Import Users

Postby Timo » Sun Mar 18, 2018 6:09 pm

Hi all, I need to import about 400 users to the zzzzsys_user table. How do I set a default password (e.g. welcome) for all users after the import? Is there a sql or php function to do that?
Timo
 
Posts: 141
Joined: Fri Mar 16, 2018 5:56 am

Re: Import Users

Postby Timo » Sun Mar 18, 2018 6:23 pm

I think I found a way to do it

Code: Select all
$pw   = md5('welcome');
nuRunQuery("UPDATE zzzzsys_user SET sus_login_password = '$pw' WHERE sus_login_password is null");
Timo
 
Posts: 141
Joined: Fri Mar 16, 2018 5:56 am

Re: Import Users

Postby admin » Mon Mar 19, 2018 8:39 am

Timo,

Thanks how I would have done it too.

Steven
admin
Site Admin
 
Posts: 2732
Joined: Mon Jun 15, 2009 9:53 am


Return to General