[Guide] How to fix MD5 in your website

MeMoS

Well-Known Member
Joined
Oct 18, 2008
Messages
620
Reaction score
498
Сега ще ви покажа как да оправите(сложите) MD5 в сайта си
Now i will show you how to fix(put) MD5 in your website

1. свалете dll файла WZ_MD5_MOD или го вземете от MuWeb 0.8 или MuWeb 0.9
1. download the dll file WZ_MD5_MOD or you can get it from MuWeb 0.8 or MuWeb 0.9

2. сложете това в Query Analyzer-а
2. put this in the Query Analyzer
USE Master
exec sp_addextendedproc N'XP_MD5_CheckValue', N'WZ_MD5_MOD.dll';
GO

Use MuOnline
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

3. сложете dll файла в C:\Program Files\Microsoft SQL Server\80\Tools\Binn
3. put the dll file in C:\Program Files\Microsoft SQL Server\80\Tools\Binn

4. в сайта намерете memb__pwd = '$password' с memb__pwd = [dbo].[fn_md5]('$password','$account')
4. in the website change memb__pwd = '$password' with memb__pwd = [dbo].[fn_md5]('$password','$account')

ако е друго и неможете да се оправите пишете в темата
if is something else and you can't make it write in the topic

ако има друга подобна тема моля да ме извините не съм я видял

Credits: =Master=
 

Attachments

  • WZ_MD5_MOD.rar
    28.4 KB · Views: 77
Last edited:

™DinamiX™

New Member
Joined
Mar 20, 2011
Messages
263
Reaction score
44
MeMoS искам попитам каде се намира тва memb__pwd щото прерових сички файлове в сайта и няма никаде такова ;( :mad: или поне не знам къде е
 

Toshy

Active Member
Joined
Sep 29, 2010
Messages
402
Reaction score
98
MeMoS искам попитам каде се намира тва memb__pwd щото прерових сички файлове в сайта и няма никаде такова ;( :mad: или поне не знам къде е

Това е една от таблиците ти в Дата Базата на MuOnline
 

Dungeon

New Member
Joined
Nov 15, 2009
Messages
2,234
Reaction score
819
MeMoS , Може ли да прикачиш един регистер с мд5 ? ^_^
 

GaG

New Member
Joined
Apr 12, 2015
Messages
11
Reaction score
0
Msg 111, Level 15, State 1, Line 2
'CREATE FUNCTION' must be the first statement in a query batch.
Msg 137, Level 15, State 2, Line 6
Must declare the scalar variable "@data".
Msg 178, Level 15, State 1, Line 7
A RETURN statement with a return value cannot be used in this context.

help :)
 

dota-sdso

Well-Known Member
Joined
Apr 30, 2014
Messages
590
Reaction score
822
Msg 111, Level 15, State 1, Line 2
'CREATE FUNCTION' must be the first statement in a query batch.
Msg 137, Level 15, State 2, Line 6
Must declare the scalar variable "@data".
Msg 178, Level 15, State 1, Line 7
A RETURN statement with a return value cannot be used in this context.

help :)

Just divide your error messages and search for answers in google as I did:

1st error "CREATE FUNCTION' must be the first statement in a query batch."

.net - 'CREATE FUNCTION' must be the first statement in a query batch. Entity Framework Code Frist - Stack Overflow

2nd error "Must declare the scalar variable "@data"."
sql - Don't understand error message: Must declare the scalar variable "@Username". - Stack Overflow

3rd error "A RETURN statement with a return value cannot be used in this context."
sql server - A return value cannot be used in this context - Stack Overflow

I am not saying that the answers you get will be 100% correct but at least you will find a path to find the real problem in your case. Making a procedure isn't so easy as the people think. You have to understand the basics and even then sometimes is complicated.