[TUTORIAL]Cum adaugi MD5

[TUTORIAL]Cum adaugi MD5 pe MuServerul tau

Links:
SCF JoinServer +MD5 +Account Auto Disconnect Fix.

[Trebuie sa fiti inscris si conectat pentru a vedea acest link]

Copiati Codul urmator in Query Analyzer

Cod:

USE [master]GOif 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]'GOSET QUOTED_IDENTIFIER OFF GOSET ANSI_NULLS OFF GOexec sp_addextendedproc N'XP_MD5_EncodeKeyVal', N'WZ_MD5_MOD.dll'GOSET QUOTED_IDENTIFIER OFF GOSET ANSI_NULLS ON GOif 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]'GOSET QUOTED_IDENTIFIER OFF GOSET ANSI_NULLS OFF GOexec sp_addextendedproc N'XP_MD5_CheckValue', N'WZ_MD5_MOD.dll'GOSET QUOTED_IDENTIFIER OFF GOSET ANSI_NULLS ON GOUSE [MuOnline]GOif 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]GOSET QUOTED_IDENTIFIER OFF GOSET ANSI_NULLS OFF GOCREATE PROCEDURE SP_MD5_ENCODE_VALUE @btInStr VARCHAR(10), @btInStrIndex VARCHAR(10)--RETURNS BINARY(16)--Created By WebZen--Adapted By [CzF]DeathwayAS 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 @btOutValENDGOSET QUOTED_IDENTIFIER OFF GOSET ANSI_NULLS ON GO

Start>All Programs>Microsoft SQL Server>Query Analyzer



Introducetiva Parola de la SQL





Cam Atat pentru Server.

Acum pentru Website:
Copiati fisierul WZ_MD5_MOD.dll din C:/Xampp/htdocs/INSTALL_STUFF
in C:/Program Files/Microsoft SQL Server\80\Tools\Bin