完整带黑名单、防复制、固定登陆器、防外挂储存

1302678 发表于 2009-4-13 09:31:04

完整带黑名单、防复制、固定登陆器、防外挂储存

本帖最后由 1302678 于 2009-4-13 09:37 编辑

有兴趣的拿去研究，赚点小钱。
if exists (select * from dbo.sysobjects where id = object_id(N'.') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure .
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE .
@AccountID varchar(21),
@Password varchar(13),
@nRet smallint OUTPUT,
@strReason varchar(255)output
AS

DECLARE @Nation tinyint, @CharNum smallint, @AccountCh varchar(21)
DECLARE @CompareValue varchar(13)
SET @Nation = 0
SET @CharNum = 0

DECLARE @pwd varchar(13)

SET @CompareValue = null
SET @pwd = null
SET @AccountCh = null
set @strReason=null

SELECT @pwd = strPasswd, @strReason=reasons FROM . WHERE strAccountID = @AccountID
IF @pwd = @Password
BEGIN
SET @nRet = 5
         --SET @nRet = 5 被封号
RETURN
END

SELECT @pwd = strPasswd FROM . WHERE strAccountID = @AccountIDandidays=6
IF @pwd IS null
BEGIN
SET @nRet = 9
         --SET @nRet = 9 没有注册
RETURN
END

ELSE IF @pwd <> @Password
BEGIN
SET @nRet = 10
         --SET @nRet = 10 密码不对
RETURN
END

SELECT @pwd = strPasswd FROM . WHERE strAccountID = @AccountID
IF @pwd IS null
BEGIN
Insert into CheckUSERs values( @AccountID, @Password)
delete from CURRENTUSER where strAccountID = @AccountID
SET @nRet = 8
         --SET @nRet = 8
RETURN
END
ELSE IF @pwd = @Password
BEGIN
delete from CURRENTUSER where strAccountID = @AccountID
delete from CheckUSERs where strAccountID = @AccountID
Insert into CheckUSERs values( @AccountID, @Password)
SET @nRet = 8
         --SET @nRet = 8
RETURN
END
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

if exists (select * from dbo.sysobjects where id = object_id(N'.') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure .
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE .
@AccountID varchar(21),
@Password varchar(13),
@nRet smallint OUTPUT

AS

DECLARE @Nation tinyint, @CharNum smallint
SET @Nation = 0
SET @CharNum = 0

DECLARE @pwd varchar(13)
DECLARE @AccountOld varchar(21)

SET @pwd = null
set @AccountOld =null

SELECT @pwd = strPasswd FROM . WHERE strAccountID = @AccountID
IF @pwd =@Password
BEGIN
SET @nRet = 5

RETURN
END

SELECT @pwd = strPasswd FROM . WHERE strAccountID = @AccountID
IF @pwd IS null
BEGIN
SET @nRet = 0

RETURN
END
ELSE IF @pwd <> @Password
BEGIN
SET @nRet = 0
         --SET @nRet = 0
RETURN
END

SELECT @AccountOld = strAccountID FROM . WHERE strAccountID = @AccountID
IF @AccountOld =@AccountID
BEGIN
SET @nRet = 0

RETURN
END

SELECT @pwd = strPasswd FROM . WHERE strAccountID = @AccountID and idays=6
IF @pwd IS null
BEGIN
SET @nRet = 0
         --SET @nRet = 4
RETURN
END

ELSE IF @pwd <> @Password
BEGIN
SET @nRet = 0
         --SET @nRet = 3
RETURN
END

DECLARE @gokhantasci varchar(21)
select @gokhantasci = count(straccountid)FROM premium_service WHERE strAccountID = @AccountID

if @gokhantasci = 0
begin
insert into PREMIUM_SERVICE (strAccountID, strType, nDays) VALUES (@AccountID, 1, 3)
end

SELECT @Nation = bNation, @CharNum = bCharNum FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID
IF @@ROWCOUNT = 0
BEGIN
SET @nRet = 1
RETURN
END
IF @CharNum = 0
BEGIN
SET @nRet = 1
RETURN
END
ELSE
BEGIN
SET @nRet = @Nation+1
         --SET @nRet = 1
RETURN
END
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

if exists (select * from dbo.sysobjects where id = object_id(N'.') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure .
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE .
@AccountID varchar(21),
@nRet smallint OUTPUT
AS
BEGIN TRAN
DELETE FROM CURRENTUSER WHERE strAccountID = @AccountID
DELETE FROM CheckUSERs WHERE strAccountID = @AccountID
COMMIT TRAN
SET @nRet = 1

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

if exists (select * from dbo.sysobjects where id = object_id(N'.') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure .
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE .
@AccountID varchar(21),
@Password varchar(13),
@strReasons varchar(60),
@nRet smallint OUTPUT

AS

DECLARE @Nation tinyint, @CharNum smallint, @AccountCh varchar(21)
DECLARE @CompareValue varchar(13)

DECLARE @pwd varchar(13)

SET @CompareValue = null
SET @pwd = null
SET @AccountCh = null

SELECT @pwd = strPasswd FROM . WHERE strAccountID = @AccountID
IF @pwd is null
BEGIN
Insert into Black_USER values( @AccountID, @Password, @strReasons)
delete from Check_USER where strAccountID = @AccountID
delete from CURRENTUSER where strAccountID = @AccountID
SET @nRet = 5
         --SET @nRet = 5
RETURN
END

SELECT @pwd = strPasswd FROM . WHERE strAccountID = @AccountID
IF @pwd <> @Password
BEGIN
SET @nRet = 10

RETURN
END
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

if exists (select * from dbo.sysobjects where id = object_id(N'.') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table .
GO

CREATE TABLE . (
(21) COLLATE Chinese_PRC_Stroke_CI_AI NOT NULL ,
(13) COLLATE Chinese_PRC_Stroke_CI_AI NOT NULL
) ON
GO

CREATE TABLE . (
(21) COLLATE Chinese_PRC_Stroke_CI_AI NOT NULL ,
(13) COLLATE Chinese_PRC_Stroke_CI_AI NOT NULL ,
(255) COLLATE Chinese_PRC_Stroke_CI_AI NOT NULL
) ON
GO

十二周 发表于 2009-4-13 09:34:35

第一次坐沙发。

怎么用啊？

十二周 发表于 2009-4-13 09:38:22

LZ教教如何使用？

1302678 发表于 2009-4-13 09:41:03

用SQL查询分析器就可以，还要相应的登录器

公子づ风 发表于 2009-4-13 10:14:07

130 有好的点登陆器不也和大家共享下！

hl8882 发表于 2009-4-13 11:28:58

骗子，还我钱~！

yangwx 发表于 2009-4-13 13:38:23

骗子，还我钱~！
hl8882 发表于 2009-4-13 11:28 http://www.kofans.cn/bbs/static/image/common/back.gif
咋的啦？？？

十二周 发表于 2009-4-13 14:09:42

操，降价啦。
我可是20买的。！！！

hl8882 发表于 2009-4-13 15:29:15

万能登陆器不能用，要专用的登陆器管理器，大家别买了

1302678 发表于 2009-4-13 20:38:33

我都说了要相应登录器，你的口放干净点。

页: [1] 2

骑士爱好者's Archiver

完整 带黑名单、防复制、固定登陆器、防外挂储存

完整带黑名单、防复制、固定登陆器、防外挂储存