CREATE PROCEDURE RMS_DOITEMGROWTH

        @GameID varchar(14),

        @WindowKind        int,

        @WindowIndex        int,

        @ItemKind        int,

        @ItemIndex        int,

        @AttackGrade        int,

        @StrengthGrade        int,

        @SpiritGrade        int,

        @DexterityGrade        int,

        @PowerGrade        int,

        @NextItemKind        int,

        @NextItemIndex        int,

        @NextAttackGrade        int,

        @NextStrengthGrade        int,

        @NextSpiritGrade        int,

        @NextDexterityGrade        int,

        @NextPowerGrade        int

AS

set nocount on

begin transaction

        DECLARE @ItemID        int

        SET        @ItemID= 0        

        SELECT TOP 1 @ItemID=ID FROM tblSpecialItem1 WHERE GameID=@GameID AND WindowKind=@WindowKind AND WindowIndex=@WindowIndex AND 

                ItemKind=@ItemKind AND ItemIndex=@ItemIndex AND AttackGrade=@AttackGrade AND StrengthGrade=@StrengthGrade AND SpiritGrade=@SpiritGrade AND DexterityGrade=@DexterityGrade AND PowerGrade=@PowerGrade AND Position=1

        IF (@ItemID > 0) AND (@AttackGrade < 4)  and (@ItemIndex < 175)

        BEGIN

                UPDATE tblSpecialItem1 SET ItemKind=@NextItemKind,ItemIndex=@NextItemIndex,AttackGrade=@NextAttackGrade,StrengthGrade=@NextStrengthGrade,SpiritGrade=@NextSpiritGrade,DexterityGrade=@NextDexterityGrade, PowerGrade=@NextPowerGrade WHERE ID=@ItemID

END

ELSE

 BEGIN

UPDATE tblSpecialItem1 SET ItemKind=@NextItemKind,ItemIndex=@ItemIndex,AttackGrade=@AttackGrade,StrengthGrade=@NextStrengthGrade,SpiritGrade=@NextSpiritGrade,DexterityGrade=@NextDexterityGrade, PowerGrade=@NextPowerGrade WHERE ID=@ItemID

        END

commit transaction

GO