Welcome Guest, Not a member yet? Register   Sign In
Using the PASSWORD() function
#2

(This post was last modified: 03-28-2018, 02:31 PM by jreklund. Edit Reason: Formatting )

1. Add "passwordConverted" in the database, default into 0.
2. Select user from database based on username/email
2. Check if "passwordConverted" are 0 or 1

If 0:
1. Make a query with the password, if it's matches login user
2. Rehash password and replace password in DB.
3. Set "passwordConverted" into 1 in DB.

If 1:
1. Validate with password_verify, if it's matches login user.

According to Google, MySQL password() function are equal too:
PHP Code:
function mysql_password($string){
    
$pass strtoupper(
            
sha1(
                    
sha1($stringtrue)
            )
    );
    
$pass '*' $pass;
    return 
$pass;


If that's correct, you can do passwordConverted = 0:
1. If it's a match with mysql_password; login user
2. Rehash password and replace password in DB.
3. Set "passwordConverted" into 1 in DB.
Reply


Messages In This Thread
Using the PASSWORD() function - by barrypoore - 03-28-2018, 01:29 PM
RE: Using the PASSWORD() function - by jreklund - 03-28-2018, 02:24 PM
RE: Using the PASSWORD() function - by barrypoore - 03-28-2018, 02:49 PM
RE: Using the PASSWORD() function - by jreklund - 03-29-2018, 03:04 AM
RE: Using the PASSWORD() function - by barrypoore - 04-09-2018, 11:40 AM
RE: Using the PASSWORD() function - by jreklund - 04-09-2018, 12:50 PM
RE: Using the PASSWORD() function - by barrypoore - 04-09-2018, 01:44 PM
RE: Using the PASSWORD() function - by jreklund - 04-09-2018, 02:48 PM



Theme © iAndrew 2016 - Forum software by © MyBB