Encrypt Password to MD5 with SQL query

[jetyao]

As my title, i would like to share about nowdays i found a solution about MD5 register in game

USE [RanUser]
GO
/****** Object: StoredProcedure [dbo].[Reg_MD5] Script Date: 04/16/2016 05:46:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
---------------------------
CREATE proc [dbo].[Reg_MD5]
@username varchar(20),
@userpass varchar(20),
@userpass2 varchar(20),
@var varchar(20)

as
set @var = SUBSTRING(master.dbo.fn_varbintohexstr(HashBytes('MD5', @Userpass)), 3, 19)
Insert into Userinfo (UserName,UserID,Userpass,Userpass2,UserType) Values (@username,@username,@userpass,@userpass2,'1')

If this work to your all~ just press a like to me



if wanna Register
just exec reg_md5 id,pass,delpass

Example

Use RanUser
exec reg_md5 jetyao95,12345,12345