Cum sa adaugi md5 la server

Dacă doriţi să adăugaţi MD5 la DB-ul curent urmati pasii:

1. Du-te la Enterprise Manager -> MuOnline DB -> procedurile stocate
2. Crearea tuturor acestor proceduri

Cod:

CREATE PROCEDURE SP_MD5_ENCODE_VALUE

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

--RETURNS BINARY(16)
--Created By WebZen
--Adapted By Cryve`
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


Cod:
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


Cod:
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


Cod:
/****** 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. Voila, acum site-ul tau trebuie instalat pe md5 MD5 / conturi ar trebui să funcţioneze în joc:), daca nu schimba CS şi JoinServer cu unele de md5.