Hello,
I have imported from Links 2.0 => the user have their e-mail as username but no Pass. Only newsletter user have a random generated pass.
So my question : Is there a way to give each user without password a radom generated pass (it is enough when they could become only integers 375436 (6 digits) ).
So I can e-mail all user with there username and password.
LinksSQL uses mySQL so it must be easy to make it.
Something like
Insert into databasename (User) where password=empty Values (Random(999999));
Please what is the correct command?? Anybody understand a little about mySQL/SQL and the table structure of LinksSQL??
Please help me
I have imported from Links 2.0 => the user have their e-mail as username but no Pass. Only newsletter user have a random generated pass.
So my question : Is there a way to give each user without password a radom generated pass (it is enough when they could become only integers 375436 (6 digits) ).
So I can e-mail all user with there username and password.
LinksSQL uses mySQL so it must be easy to make it.
Something like
Insert into databasename (User) where password=empty Values (Random(999999));
Please what is the correct command?? Anybody understand a little about mySQL/SQL and the table structure of LinksSQL??
Please help me