2014-11-16, 08:54 PM
Quick question, recently i just had to convert a few boards into 1 mybb board for a friend. All has went well.
The question is this, i see all mybb data except sessions are kept directly in users. I also seen merge add's lots of bloat to the end of the user table. Hence the need to login convert.
I want to remove the plugin and and also the bloat.
Now... Users PW's are blank, so are the salts and login keys.. What i need to know is how can i randomly generate a new salt for all users and a password for them?
I know this:
Will update the login key, so how can i do it for salt and pw's?
I ask this because i changed my salt # to a different number to make it a bit longer.
Figured it out, solved
The question is this, i see all mybb data except sessions are kept directly in users. I also seen merge add's lots of bloat to the end of the user table. Hence the need to login convert.
I want to remove the plugin and and also the bloat.
Now... Users PW's are blank, so are the salts and login keys.. What i need to know is how can i randomly generate a new salt for all users and a password for them?
I know this:
UPDATE mybb_users SET loginkey=SHA1(CONCAT(RAND(),UUID(),loginkey));
Will update the login key, so how can i do it for salt and pw's?
I ask this because i changed my salt # to a different number to make it a bit longer.
Figured it out, solved