MyBB Community Forums

Full Version: Create users directly from MySQL
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hello,
I use MyBB version 1.4.13. I have over 1000 accounts that i need to create.

I want to create usernames and emails for them but without the password so the users will reset them afterwards.

Can this be done directly from mysql?
If not can you please suggest a script?

Thank you for your time.
Where are the accounts coming from? There's the merge system, but I dunno if that's what you're after?
I am afraid you will have to create a custom script that will insert every user.

Like: http://www.neowin.net/forum/index.php?app=spy
(2010-06-22, 12:19 AM)AJS Wrote: [ -> ]Where are the accounts coming from? There's the merge system, but I dunno if that's what you're after?


No, a custom account with the structure:
username, password, email, joindate, last_login
where password = sha1(username:password)

@Bob Jansen,
can you show me an example of your reference?