What is the Encryption of password in the sql

11/06/2017 11:57 adarelk2#1

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))

11/06/2017 12:23 KetchupSamurai#2

md5

11/06/2017 12:44 adarelk2#3

Quote:

Originally Posted by KetchupSamurai

md5

I tried but its not that...

Quote:

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?

11/06/2017 15:10 KetchupSamurai#4

its md5 encryption lol.

salt + pass = encrypted password

11/06/2017 15:19 FlyffServices#5

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

11/06/2017 15:57 KingKeesie#6

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

11/06/2017 23:10 xTwiLightx#7

Quote:

Originally Posted by KingKeesie

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

md5 is way beyond security today. :D

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.
@[Only registered and activated users can see links. Click Here To Register...]: Even your snippet is using the SQL Server hashbytes function with md5 used as algorithm...

11/07/2017 02:11 FlyffServices#8

Quote:

Originally Posted by xTwiLightx

md5 is way beyond security today. :D

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.
@[Only registered and activated users can see links. Click Here To Register...]: 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.

11/07/2017 07:10 adarelk2#9

thanks everybody :)