How to Add MD5 to Database!

[Shatter]

if you want to add MD5 to your current DB you are in the right place :P

1. Go to enterprise manager -> MuOnline DB -> stored procedures
2. Create all this procedures

a)

CREATE PROCEDURE SP_MD5_ENCODE_VALUE

@btInStr VARCHAR(10),
@btInStrIndex VARCHAR(10)

--RETURNS BINARY(16)
--Created By WebZen
--Adapted By [CzF]Deathway
AS
BEGIN
DECLARE @btOutVal BINARY(16)

EXEC master..XP_MD5_EncodeKeyVal @btInStr, @btInStrIndex, @btOutVal OUT
UPDATE MEMB_INFO SET memb__pwd = @btOutVal WHERE memb___id = @btInStrIndex
RETURN @btOutVal
END

GO


b)

CREATE PROCEDURE [dbo].[Encript]
@btInStr VARCHAR(10),
@btInStrIndex VARCHAR(10)
AS
BEGIN
DECLARE @btOutVal BINARY(16)
EXEC master..XP_MD5_EncodeKeyVal @btInStr, @btInStrIndex, @btOutVal OUT
UPDATE MEMB_INFO SET memb__pwd = @btOutVal WHERE memb___id = @btInStrIndex
END

GO


c)

CREATE PROCEDURE [dbo].[Encripta]
@btInStr VARCHAR(10),
@btInStrIndex VARCHAR(10)
AS

BEGIN
DECLARE @btOutVal BINARY(16)

EXEC master..XP_MD5_EncodeKeyVal @btInStr, @btInStrIndex, @btOutVal OUT

UPDATE MEMB_INFO SET memb__pwd = @btOutVal WHERE memb___id = @btInStrIndex
END

GO


d)


/****** Object: Stored Procedure dbo.Cassandra_MD5 Script Date: 03/09/2006 22.53.35 ******/
CREATE PROCEDURE [dbo].[Cassandra_MD5]
@btInStr VARCHAR(10),
@btInStrIndex VARCHAR(10)
AS
BEGIN
DECLARE @btOutVal BINARY(16)
EXEC master..XP_MD5_EncodeKeyVal @btInStr, @btInStrIndex, @btOutVal OUT
SELECT @btOutVal
END



GO


3. Voil

[MentaL]

[Disconnect1]

Hmm.... for me:
1. Go to MuOnline > Tables > Design Table MEMB_INFO, set

memb__pwd varbinary 16 NO NULL

2. Put the 'WZ_MD5_MOD.dll' in C:\Program Files\Microsoft SQL Server\MSSQL\Binn\
3. Run this script:

USE [master]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[XP_MD5_EncodeKeyVal]') and OBJECTPROPERTY(id, N'IsExtendedProc') = 1)
exec sp_dropextendedproc N'[dbo].[XP_MD5_EncodeKeyVal]'
GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

exec sp_addextendedproc N'XP_MD5_EncodeKeyVal', N'WZ_MD5_MOD.dll'
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[XP_MD5_CheckValue]') and OBJECTPROPERTY(id, N'IsExtendedProc') = 1)
exec sp_dropextendedproc N'[dbo].[XP_MD5_CheckValue]'
GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

exec sp_addextendedproc N'XP_MD5_CheckValue', N'WZ_MD5_MOD.dll'
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

USE [MuOnline]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SP_MD5_ENCODE_VALUE]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[SP_MD5_ENCODE_VALUE]
GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

CREATE PROCEDURE SP_MD5_ENCODE_VALUE 

	@btInStr		VARCHAR(10),
	@btInStrIndex		VARCHAR(10)

--RETURNS BINARY(16)
--Created By WebZen
--Adapted By [CzF]Deathway
AS  
BEGIN 
	DECLARE	@btOutVal	BINARY(16)

	EXEC master..XP_MD5_EncodeKeyVal @btInStr, @btInStrIndex, @btOutVal OUT
	UPDATE MEMB_INFO SET memb__pwd = @btOutVal WHERE memb___id = @btInStrIndex
	RETURN 	@btOutVal
END
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

4. Then replace your JoinServer
5. Install website MD5 on
6. Install Editor MD5 on

That`s all :D

[Shatter]

yea lol thanks mate, i was gonna add that but too lazy xD

[gum12345]

how about how to change MD5 to a none md5?

[Shatter]

there was one thread about that already, and answered too.. was GALACTICO's if i remember right

[euronimus]

i have problem, i been do all of this tutorial. but when I connect to my server, and write login and pass, i have error -> password incorrect.. help

[Shatter]

your Joinserver is non-md5, for md5 JS.. take a look to my attachments :)

[Maxim.T]

Thanks , been looking for this

[iago94]

how do i remove Md5?

[KREATOR]

[QUOTE=Shatter;3576038]if you want to add MD5 to your current DB you are in the right place :P

1. Go to enterprise manager -> MuOnline DB -> stored procedures
2. Create all this procedures

a)

CREATE PROCEDURE SP_MD5_ENCODE_VALUE

@btInStr VARCHAR(10),
@btInStrIndex VARCHAR(10)

--RETURNS BINARY(16)
--Created By WebZen
--Adapted By [CzF]Deathway
AS
BEGIN
DECLARE @btOutVal BINARY(16)

EXEC master..XP_MD5_EncodeKeyVal @btInStr, @btInStrIndex, @btOutVal OUT
UPDATE MEMB_INFO SET memb__pwd = @btOutVal WHERE memb___id = @btInStrIndex
RETURN @btOutVal
END

GO


b)

CREATE PROCEDURE [dbo].[Encript]
@btInStr VARCHAR(10),
@btInStrIndex VARCHAR(10)
AS
BEGIN
DECLARE @btOutVal BINARY(16)
EXEC master..XP_MD5_EncodeKeyVal @btInStr, @btInStrIndex, @btOutVal OUT
UPDATE MEMB_INFO SET memb__pwd = @btOutVal WHERE memb___id = @btInStrIndex
END

GO


c)

CREATE PROCEDURE [dbo].[Encripta]
@btInStr VARCHAR(10),
@btInStrIndex VARCHAR(10)
AS

BEGIN
DECLARE @btOutVal BINARY(16)

EXEC master..XP_MD5_EncodeKeyVal @btInStr, @btInStrIndex, @btOutVal OUT

UPDATE MEMB_INFO SET memb__pwd = @btOutVal WHERE memb___id = @btInStrIndex
END

GO


d)


/****** Object: Stored Procedure dbo.Cassandra_MD5 Script Date: 03/09/2006 22.53.35 ******/
CREATE PROCEDURE [dbo].[Cassandra_MD5]
@btInStr VARCHAR(10),
@btInStrIndex VARCHAR(10)
AS
BEGIN
DECLARE @btOutVal BINARY(16)
EXEC master..XP_MD5_EncodeKeyVal @btInStr, @btInStrIndex, @btOutVal OUT
SELECT @btOutVal
END



GO


3. Voil

[smithcyber]

WORK in 97d version?

[KREATOR]

when i try to change memb_pwd to varbinary (16) it says i cant change it. "i have to drop the table first and then recreated" How can i change it? i have in varchar (10) right now (Im using MSSQL 2008)

SS

[Shatter]

thats caused because you have muserver running or its in use by SQL, restart computer and edit it, should be fine.

[KREATOR]

i had just rebooted my pc, and my server was off at that moment...

[john_d]

Kreator i don't think u can change that.

i would suggest u drop the memb_pwd and add it again as what u wanted.

[KREATOR]

i just noticed that if i leave it with varbinary(50) it will let me change it. When I try to change it there is varbinary(50) and varbinary(MAX). I choose varbiynary(50) and then change the 50 for 16 and it does not let me change it but if I leave it varbinary(50) it will let me change. Does it still work with varbinary(50) if I wanna add MD5 to my DB?

[FCV2005]

how i can remove md5 from DB ?

[bramdebouvere]

how i can remove md5 from DB ?

you don't have to.. just use a non md5 joinserver.. always worked flawless for me..

(ofcoarse, if you have players in your db, you will have to find a way to decode their md5 passwords)

[dieweb]

Someone has WZ_MD5_MOD.dll adapted on windows 64 Bit?? Thanx
Because its dont work on my server windows 64 bit (MSSQL 2008)

[Trane23]

Yeah i need MD5 for x64 too, who has it???

[canddy]

failed...
i patch cs n js ,cannot open it
open and nothing happed

[barry952]

I also need md5 for x64....my web isnt working for logins with normal md5........even thoe db queries says already installed

[JoniverPH]

I've been searching for this

[Sarzoc]

I use MuServer 1.00l and MuWeb 0.8, I try to create a account but,when I do it it says account succesfully created....but I can't actually log in into that account,neither on the website. Help ?

---------- Post added at 09:59 AM ---------- Previous post was at 09:47 AM ----------

Dude! I still can't create an account from the website,and now its even more fcked up , it says my password is invalid, IT WORKED BEFORE! Did this guide help me ?Well not really, now I am asking for help. What do I do now ?

[extrmndor3]

shatter.. or anyone with good knowledge

i used your(shatter) 99%bugless server configuration..(wich i think your server backup database to restore were made for md5)i try to get on options and change md5 option to none on joinserver.. i went to sql and changed varbinary to varchar..(allow nulls and changed the character or something from 50 and 15 and some other and still) but somehow.. all the accounts get created succesfully but when i get in to the game.. i cant even join.. says my accounts are invalids... and yes i tried several joinservers