jinwenjian 发表于 2009-6-23 12:08:41

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

INSERT INTO make_item_group (iItemGroupNum, iItem_1, iItem_2, iItem_3, iItem_4, iItem_5, iItem_6, iItem_7, iItem_8, iItem_9, iItem_10, iItem_11, iItem_12, iItem_13, iItem_14, iItem_15, iItem_16, iItem_17, iItem_18, iItem_19, iItem_20, iItem_21, iItem_22, iItem_23, iItem_24, iItem_25, iItem_26, iItem_27, iItem_28, iItem_29, iItem_30 )
VALUES       (6051, 310150009, 310150019, 310150029, 310150039, 310150079, 320110009, 320110019, 320110029, 320110039, 320110079, 330110009, 330110019, 330110029, 330110039, 330110079, 340150009, 340150019, 340150029, 340150039, 340150079, 330620270, 266003030, 310510104, 340110255, 310610106, 320610119, 330110255, 330150257, 310310004, 310310006 )


UPDATE K_monster_item SET iItem01 = 6051, SPERSENT01 = 500 WHERE sIndex = 3671
UPDATE K_monster_item SET iItem01 = 6051, SPERSENT01 = 500 WHERE sIndex = 1171


说明,第一步先在随机掉落组添加+9首饰和暗金代码
第二步给怪物列表里加入掉落物品5%的掉率

feifeixia 发表于 2009-6-23 12:57:00

。。这是什么

桂AG2126 发表于 2009-6-23 15:20:28

忽悠别人！CT把楼主封了。。。。。。。。。。。。。汗！！

duwanli2000 发表于 2009-6-24 09:14:46

内容跟主题不同呀？？在干嘛呢?真的要把它封了。

jinwenjian 发表于 2009-6-24 11:47:01

不好意思,发错了再发一次
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

桂AG2126 发表于 2009-6-25 00:23:29

应该是忘记了吧！
叫CT封他号他才发的第二个储存！我汗！！！！！
现在又忘记了东西没发，，

wang9898 发表于 2009-6-26 03:58:22

可惜了，没有我的管理器。单单有这些存储过程，是没有任何意义的

zcyzcy 发表于 2010-5-19 11:52:25

。。这是什么

ubifk 发表于 2010-11-26 09:55:46

这个太高深了吧，解释一下嘛

harvester 发表于 2010-11-28 03:36:23

貌似都是SQL语句啊
页: [1] 2
查看完整版本: 完整 带黑名单、防复制、固定登陆器、防外挂储存