x-MU.net форум

Цитата: DjSound от 2009 Нояб. 04, 14:02  fix register web


Скинуть WZ_MD5_MOD.dll в папку /Tools/Binn/ и перезагрузить Microsoft SQL Server

так теперь дальше...
Добавить таблици в Master DB

Спойлер

use Master
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[XP_MD5_CheckValue]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [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

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[XP_MD5_EncodeKeyVal]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [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

[свернуть]

В MEMB_INFO: добавить таблицу..

temphash varbinary   (17)

Теперь в query analyze База MuOnline добавить -

Спойлер

update memb_info set memb__pwd=temphash;
alter table memb_info drop column temphash;

[свернуть]

SP_MD5_ENCODE_VALUE

Спойлер

CREATE PROCEDURE SP_MD5_ENCODE_VALUE

@btInStr varchar(10),
@btInStrIndex varchar(10)
AS
BEGIN
DECLARE mytest SCROLL CURSOR FOR SELECT memb___id,memb__pwd FROM MEMB_INFO
DECLARE @btOutVal BINARY(16)
OPEN mytest
EXEC master..XP_MD5_EncodeKeyVal @btInStr, @btInStrIndex, @btOutVal OUT
UPDATE MEMB_INFO SET temphash = @btOutVal WHERE memb___id = @btInStrIndex
FETCH NEXT FROM mytest INTO @btInStrIndex, @btInStr;

END
GO

[свернуть]

Взято с RageZone[/b]