What is the name of the table in the Database where all users information is stored, especially passwords.
What is the name of the table in the Database where all users information is stored, especially passwords. |
profiles |
i can forewarn you about the passwords and hope the post is not too late. *DO NOT MESS WITH THOSE PASSWORDS* you need to mod those password from the forgot password function on the front of the site. the fact that you couldnt even find the profiles table, would throw fear all over the place. passwords are SALT encrypted, now if you can figure out $ALT, but couldnt figure out how to find the profiles table, you are a character indeed. Regards, DosDawg When a GIG is not enough --> Terabyte Dolphin Technical Support - Server Management and Support |
Dos Dog, Ok I am trying to enter members a large list and I am stuck on this exact issue got past the d5 thing for password but stuck o the salt thing how does that work? Look all I want to do is get this done I'm not here for ego trip or boost only to get job done. I am an idiot at heart with a lot of ambition just want to have my members be in the system......any thoughts are appreciated..... Csampson |
If you're inserting users that have MD5 passwords into the Profiles table using a SQL script, add the random SALT value at the same time using: CONV(FLOOR(RAND()*99999999999999), 10, 36) Once the inserts are done, execute the following SQL to convert the MD5 passwords to the D7 format:
Please make sure your admin user's ID is 1 or else you will wipe out your admin password. If it's not 1, then adjust the WHERE clause accordingly. Good Luck! |