What is the Encryption of password in the sql

[adarelk2]

i try to build login function with php
but i dont know what is the name of the Encryption...
like 123123 = 0abc07bace35a1a512ae6393b901a978
what is it?

PHP Code:

DECLARE [MENTION=290795]username[/MENTION] varchar(16)
DECLARE [MENTION=413413]password[/MENTION] varchar(100)
DECLARE [MENTION=950314]email[/MENTION] varchar(100)
DECLARE [MENTION=501413]Salt[/MENTION] varchar(100)

/* PLEASE SET THE VARAIBLES BELOW BEFORE EXECUTING THE SCRIPT! */
SET [MENTION=290795]username[/MENTION]    = 'adarelk2' -- Username (use this to login)    
SET [MENTION=413413]password[/MENTION]    = '123123' -- Password (use this to login)
SET [MENTION=950314]email[/MENTION]        = '' -- Email (optional)
SET [MENTION=501413]Salt[/MENTION]        = 'flight' -- MD5 Salt (default: flight)

PRINT N'********************************************************************************
*************          Project Flight Account Creation Tool         ************
*************                  Created by Cuvvvvie                  ************
*************               [url]http://project-flight.com/[/url]              ************
********************************************************************************'

SET NOCOUNT ON
DECLARE @RC int
DECLARE [MENTION=2999838]MD5[/MENTION] varchar(32)
SET [MENTION=2999838]MD5[/MENTION] = lower(CONVERT(VARCHAR(32), HashBytes('MD5', [MENTION=501413]Salt[/MENTION] [MENTION=413413]password[/MENTION]), 2)) 


[KetchupSamurai]

md5

[adarelk2]

Originally Posted by KetchupSamurai

md5

I tried but its not that...

Originally Posted by KetchupSamurai

md5

PHP Code:

DECLARE [MENTION=290795]username[/MENTION] varchar(16)
DECLARE [MENTION=413413]password[/MENTION] varchar(100)
DECLARE [MENTION=950314]email[/MENTION] varchar(100)
DECLARE [MENTION=501413]Salt[/MENTION] varchar(100)

/* PLEASE SET THE VARAIBLES BELOW BEFORE EXECUTING THE SCRIPT! */
SET [MENTION=290795]username[/MENTION]    = 'adarelk2' -- Username (use this to login)    
SET [MENTION=413413]password[/MENTION]    = '123123' -- Password (use this to login)
SET [MENTION=950314]email[/MENTION]        = '' -- Email (optional)
SET [MENTION=501413]Salt[/MENTION]        = 'flight' -- MD5 Salt (default: flight)

PRINT N'********************************************************************************
*************          Project Flight Account Creation Tool         ************
*************                  Created by Cuvvvvie                  ************
*************               [url]http://project-flight.com/[/url]              ************
********************************************************************************'

SET NOCOUNT ON
DECLARE @RC int
DECLARE [MENTION=2999838]MD5[/MENTION] varchar(32)
SET [MENTION=2999838]MD5[/MENTION] = lower(CONVERT(VARCHAR(32), HashBytes('MD5', [MENTION=501413]Salt[/MENTION] [MENTION=413413]password[/MENTION]), 2)) 


how i make it in php?

[KetchupSamurai]

its md5 encryption lol.

salt + pass = encrypted password

[FlyffServices]

$password = 'pass123';
$salt = 'flight';
$hashed_password = md5( $password . $salt );

[KingKeesie]

Its a md5 hash, it's sort of a security thing.

[xTwiLightx]

Originally Posted by KingKeesie

Its a md5 hash, it's sort of a security thing.

md5 is way beyond security today.

md5 is an algorithm to create a hash with a fixed length of 32 characters and should be replaced with some sha-256 or even 512 hash. Or even better, bcrypt.
@: Even your snippet is using the SQL Server hashbytes function with md5 used as algorithm...

[FlyffServices]

Originally Posted by xTwiLightx

md5 is way beyond security today.

md5 is an algorithm to create a hash with a fixed length of 32 characters and should be replaced with some sha-256 or even 512 hash. Or even better, bcrypt.
@: Even your snippet is using the SQL Server hashbytes function with md5 used as algorithm...

Eigentlich hat ja MD5 nur 16 (128bits) chars aber wegen der lesbarkeit wird er in HEX-format angezeigt.

[adarelk2]

thanks everybody