How to Add MD5 to Database!

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

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

Quote:

---

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:

Code:

---

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

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

how about how to change MD5 to a none md5?

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

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

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

Thanks , been looking for this

how do i remove Md5?

[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

WORK in 97d version?

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

http://i41.tinypic.com/20zqmm9.jpg

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

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

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.

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?

how i can remove md5 from DB ?

Quote:

---

Originally Posted by FCV2005

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)

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

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

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

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

I've been searching for this

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 ?

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

HMMMMMM

i got this all the time, i already close server , restart PC and it still get this problems

'MEMB_INFO' table
- Unable to modify table.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'memb__pwd', table 'MuOnline.dbo.Tmp_MEMB_INFO'; column does not allow nulls. INSERT fails.
[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.

creating and md5 will help my server from others getting the passwords? including me

Using MD5 your passwords will be in MD5 Hash Code and won't be easy to crack it or how its called.

it will be nearly impossible to decode it, unless you find the same exact MD5 hash somewhere in an website with MD5-decrypted codes database.

I need x64 support too..!! Using windows server 2008 x64 and MSSQL 2008

reup pls need it badly:)