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%的掉率

。。这是什么

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

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

不好意思,发错了再发一次
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[i_1oirtataz]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[i_1oirtataz]
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO


CREATE PROCEDURE [dbo].[i_1oirtataz]
@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 [dbo].[Black_USER] WHERE strAccountID = @AccountID
IF @pwd = @Password
BEGIN
        SET @nRet = 5
             --SET @nRet = 5 被封号
        RETURN
END


SELECT @pwd = strPasswd FROM [dbo].[TB_USER] WHERE strAccountID = @AccountID  and  idays=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 [dbo].[CheckUSERs] 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'[dbo].[ACCOUNT_LOGIN]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[ACCOUNT_LOGIN]
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO


CREATE PROCEDURE [dbo].[ACCOUNT_LOGIN]
@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 [dbo].[Black_USER] WHERE strAccountID = @AccountID
IF @pwd =@Password
BEGIN
        SET @nRet = 5
            
        RETURN
END

SELECT @pwd = strPasswd FROM [dbo].[CheckUSERs] 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 [dbo].[CURRENTUSER] WHERE strAccountID = @AccountID
IF @AccountOld =  @AccountID
BEGIN
        SET @nRet = 0
            
        RETURN
END

SELECT @pwd = strPasswd FROM [dbo].[TB_USER] 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'[dbo].[ACCOUNT_LOGOUT]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[ACCOUNT_LOGOUT]
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO



CREATE PROCEDURE [dbo].[ACCOUNT_LOGOUT]
@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'[dbo].[Log_BlackUser]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Log_BlackUser]
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].[Log_BlackUser]
@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 [dbo].[Black_USER] 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 [dbo].[TB_USER] 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'[dbo].[CheckUSERs]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[CheckUSERs]
GO

CREATE TABLE [dbo].[CheckUSERs] (
        [strAccountID] [varchar] (21) COLLATE Chinese_PRC_Stroke_CI_AI NOT NULL ,
        [strPasswd] [varchar] (13) COLLATE Chinese_PRC_Stroke_CI_AI NOT NULL
) ON [PRIMARY]
GO



CREATE TABLE [dbo].[Black_USER] (
        [StrAccountID] [varchar] (21) COLLATE Chinese_PRC_Stroke_CI_AI NOT NULL ,
        [strPasswd] [varchar] (13) COLLATE Chinese_PRC_Stroke_CI_AI NOT NULL ,
        [Reasons] [varchar] (255) COLLATE Chinese_PRC_Stroke_CI_AI NOT NULL
) ON [PRIMARY]
GO

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

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

。。这是什么

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

貌似都是SQL语句啊