MD5 Problem

[19871986]

message: Disallowed implicit conversion from data type varchar to data type varbinary, table 'MuOnline.dbo.MEMB_INFO', column 'memb__pwd'. Use the CONVERT function to run this query.


thats problem while register at web, how i can fix it ?

[MentaL]

[KrYsSu]

you need add rullz for MD5 and need DLL to put in MSQL.

Oky so run this in sql query

[CODE]
CREATE FUNCTION [dbo].[fn_md5] (@data VARCHAR(10), @data2 VARCHAR(10))
RETURNS BINARY(16) AS
BEGIN
DECLARE @hash BINARY(16)
EXEC master.dbo.XP_MD5_EncodeKeyVal @data, @data2, @hash OUT
RETURN @hash
END
[CODE]

Good luck if the problem persist please share more info ! Your website Muweb,mucore !

Thx

[19871986]

problem still continue

.dll is include mssql files and all tables supported for md5

i need php function for change datatype

my website is not muweb and mucore its a different engine dont have name :/

- And my Register.php - signup with md5 code -

if($Web['MD5'] == 1){
$md5_code=" [dbo].[UFN_MD5_ENCODEVALUE]('$pw', '$login')";
}
else{
$md5_code="$pw";
}

[Alexell]

1.Copy WZ_MD5_MOD.dll to C:\Program Files\Microsoft SQL Server\MSSQL\Binn
2.new querry

USE MASTER
EXEC SP_ADDEXTENDEDPROC 'XP_MD5_EncodeKeyVal', 'WZ_MD5_MOD.dll'