Registered game account Help

soil · Sep 20, 2015

OS:Win2008 x64 r2 Sql2008 R2

WZ_MD5_MOD.dll 64KB

Game DB ME_ONLINE------MEMB_INFO----memb__pwd-----varbinary(16)

use master
gosp_addextendedproc 'XP_MD5_EncodeKeyVal', 'WZ_MD5_MOD.dll'
go
sp_addextendedproc 'XP_MD5_CheckValue', 'WZ_MD5_MOD.dll'
go
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[UFN_MD5_CHECKVALUE]') and xtype in (N'FN', N'IF', N'TF'))
drop function [dbo].[UFN_MD5_CHECKVALUE]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[UFN_MD5_ENCODEVALUE]') and xtype in (N'FN', N'IF', N'TF'))
drop function [dbo].[UFN_MD5_ENCODEVALUE]
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE FUNCTION UFN_MD5_CHECKVALUE
(
@btInStr VARCHAR(10),
@btInStrIndex VARCHAR(10),
@btInVal BINARY(16)
)
RETURNS TINYINT
AS
BEGIN
DECLARE ioutResult TINYINT
EXEC master..XP_MD5_CheckValue @btInStr, @btInVal, @btInStrIndex, ioutResult OUT
RETURN ioutResult
END
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE FUNCTION UFN_MD5_ENCODEVALUE
(
@btInStr VARCHAR(10),
@btInStrIndex VARCHAR(10)
)
RETURNS BINARY(16)
AS
BEGIN
DECLARE @btOutVal BINARY(16)
EXEC master..XP_MD5_EncodeKeyVal @btInStr, @btInStrIndex, @btOutVal OUT
RETURN @btOutVal
END
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].[UFN_MD5_CHECKVALUE]') and xtype in (N'FN', N'IF', N'TF'))
drop function [dbo].[UFN_MD5_CHECKVALUE]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[UFN_MD5_ENCODEVALUE]') and xtype in (N'FN', N'IF', N'TF'))
drop function [dbo].[UFN_MD5_ENCODEVALUE]
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE FUNCTION UFN_MD5_CHECKVALUE
(
@btInStr VARCHAR(10),
@btInStrIndex VARCHAR(10),
@btInVal BINARY(16)
)
RETURNS TINYINT
AS
BEGIN
DECLARE ioutResult TINYINT
EXEC master..XP_MD5_CheckValue @btInStr, @btInVal, @btInStrIndex, ioutResult OUT
RETURN ioutResult
END
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE FUNCTION UFN_MD5_ENCODEVALUE
(
@btInStr VARCHAR(10),
@btInStrIndex VARCHAR(10)
)
RETURNS BINARY(16)
AS
BEGIN
DECLARE @btOutVal BINARY(16)
EXEC master..XP_MD5_EncodeKeyVal @btInStr, @btInStrIndex, @btOutVal OUT
RETURN @btOutVal
END
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
--------------------------------------------------------------------------------------------------------------------------------

Test SQL to:

INSERT INTO MEMB_INFO (memb___id,memb__pwd,bloc_code,ctl1_code,PassWDType,BirthDay,tgman,IsGetPass,mBlockCount,JF)
VALUES ('aaaaaa8',[dbo].[UFN_MD5_ENCODEVALUE]('aaaaaa8','aaaaaa8'),0,0,0,19800201,0,0,0,5000)

Error:
訊息 515，層級 16，狀態 2，行 1
無法插入 NULL 值到資料行 'memb__pwd'，資料表 'ME_MUONLINE.dbo.MEMB_INFO'; 資料行不得有 Null。INSERT 失敗。
陳述式已經結束。

Please help me thank!!!