Maximun Durability Scroll Remover

USE [SRO_VT_SHARD]
GO
/****** Object:  StoredProcedure [dbo].[_RedStatRemover]    Script Date: 03/07/2016 10:36:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
 
ALTER PROCEDURE [dbo].[_RedStatRemover]
 [MENTION=395373]Chari[/MENTION]D INT
 
AS
 
        DECLARE         [MENTION=1985011]param[/MENTION]1 BIGINT,
                        [MENTION=1985011]param[/MENTION]2 BIGINT,
                        [MENTION=1985011]param[/MENTION]3 BIGINT,
                        [MENTION=1985011]param[/MENTION]4 BIGINT,
                        [MENTION=1985011]param[/MENTION]5 BIGINT,
                        [MENTION=1985011]param[/MENTION]6 BIGINT,
                        [MENTION=1985011]param[/MENTION]7 BIGINT,
                        [MENTION=1985011]param[/MENTION]8 BIGINT,
                        [MENTION=1985011]param[/MENTION]9 BIGINT,
                        [MENTION=1985011]param[/MENTION]10 BIGINT,
                        [MENTION=1985011]param[/MENTION]Num TINYINT,
                        [MENTION=806297]sql[/MENTION] nvarchar(400),
                        [MENTION=783256]redsta[/MENTION]t TINYINT,
                        @ID64 INT;
 
        SELECT          [MENTION=1985011]param[/MENTION]1 = magic1.ID ,
                        [MENTION=1985011]param[/MENTION]2 = magic2.ID ,
                        [MENTION=1985011]param[/MENTION]3 = magic3.ID ,
                        [MENTION=1985011]param[/MENTION]4 = magic4.ID ,
                        [MENTION=1985011]param[/MENTION]5 = magic5.ID ,
                        [MENTION=1985011]param[/MENTION]6 = magic6.ID ,
                        [MENTION=1985011]param[/MENTION]7 = magic7.ID ,
                        [MENTION=1985011]param[/MENTION]8 = magic8.ID ,
                        [MENTION=1985011]param[/MENTION]9 = magic9.ID ,
                        [MENTION=1985011]param[/MENTION]10 = magic10.ID,
                        [MENTION=1985011]param[/MENTION]Num = items0.MagParamNum,
                        @ID64 = items0.ID64
 
        FROM            SRO_VT_SHARD.dbo._Inventory AS invent0
        INNER JOIN      SRO_VT_SHARD.dbo._Items AS items0 ON invent0.ItemID = items0.ID64 AND (invent0.Slot  = 13)
        INNER JOIN      SRO_VT_SHARD.dbo._RefObjCommon AS ref0 ON items0.RefItemID = ref0.ID
        INNER JOIN      SRO_VT_SHARD.dbo._Char AS chart ON invent0.CharID = chart.CharID
        LEFT JOIN       _RefMagicOptNew AS magic1 ON (items0.MagParam1 & 2147483647) = magic1.ID
        LEFT JOIN       _RefMagicOptNew AS magic2 ON (items0.MagParam2 & 2147483647) = magic2.ID
        LEFT JOIN       _RefMagicOptNew AS magic3 ON (items0.MagParam3 & 2147483647) = magic3.ID
        LEFT JOIN       _RefMagicOptNew AS magic4 ON (items0.MagParam4 & 2147483647) = magic4.ID
        LEFT JOIN       _RefMagicOptNew AS magic5 ON (items0.MagParam5 & 2147483647) = magic5.ID
        LEFT JOIN       _RefMagicOptNew AS magic6 ON (items0.MagParam6 & 2147483647) = magic6.ID
        LEFT JOIN       _RefMagicOptNew AS magic7 ON (items0.MagParam7 & 2147483647) = magic7.ID
        LEFT JOIN       _RefMagicOptNew AS magic8 ON (items0.MagParam8 & 2147483647) = magic8.ID
        LEFT JOIN       _RefMagicOptNew AS magic9 ON (items0.MagParam9 & 2147483647) = magic9.ID
        LEFT JOIN       _RefMagicOptNew AS magic10 ON (items0.MagParam10 & 2147483647) = magic10.ID
        LEFT JOIN       _RefMagicOptNew AS magic11 ON (items0.MagParam11 & 2147483647) = magic11.ID
        LEFT JOIN       _RefMagicOptNew AS magic12 ON (items0.MagParam12 & 2147483647) = magic12.ID
 
        WHERE chart.CharID = [MENTION=395373]Chari[/MENTION]D
 
        SET [MENTION=783256]redsta[/MENTION]t = (SELECT CASE WHEN [MENTION=1985011]param[/MENTION]1 BETWEEN 1 AND 4
                                        THEN 1
                                    WHEN [MENTION=1985011]param[/MENTION]2 BETWEEN 1 AND 4
                                        THEN 2
                                    WHEN [MENTION=1985011]param[/MENTION]3 BETWEEN 1 AND 4
                                        THEN 3
                                    WHEN [MENTION=1985011]param[/MENTION]4 BETWEEN 1 AND 4
                                        THEN 4
                                    WHEN [MENTION=1985011]param[/MENTION]5 BETWEEN 1 AND 4
                                        THEN 5
                                    WHEN [MENTION=1985011]param[/MENTION]6 BETWEEN 1 AND 4
                                        THEN 6
                                    WHEN [MENTION=1985011]param[/MENTION]7 BETWEEN 1 AND 4
                                        THEN 7
                                    WHEN [MENTION=1985011]param[/MENTION]8 BETWEEN 1 AND 4
                                        THEN 8
                                    WHEN [MENTION=1985011]param[/MENTION]9 BETWEEN 1 AND 4
                                        THEN 9
                                    WHEN [MENTION=1985011]param[/MENTION]10 BETWEEN 1 AND 4
                                        THEN 10
                                    ELSE NULL
                                END )
                               
           
        IF [MENTION=783256]redsta[/MENTION]t < [MENTION=1985011]param[/MENTION]Num
            BEGIN
                SET [MENTION=806297]sql[/MENTION] = ' UPDATE     SRO_VT_SHARD.dbo._Items
                            SET        MagParam' + CAST [MENTION=783256]redsta[/MENTION]t AS nvarchar(2)) + ' = MagParam' + CAST [MENTION=1985011]param[/MENTION]Num AS nvarchar(2)) + ',
                                       MagParam' + CAST [MENTION=1985011]param[/MENTION]Num AS nvarchar(2)) + ' = MagParam' + CAST [MENTION=783256]redsta[/MENTION]t AS nvarchar(2)) + ',
                                       MagParamNum -= 1
                            WHERE      ID64 = ' + CAST(@ID64 AS nvarchar(10))
                             
                EXEC sp_executeSQL [MENTION=806297]sql[/MENTION], N [MENTION=783256]redsta[/MENTION]t TINYINT, [MENTION=1985011]param[/MENTION]Num TINYINT, @ID64 INT', [MENTION=783256]redsta[/MENTION]t, [MENTION=1985011]param[/MENTION]Num, @ID64
                RETURN -3
            END
        ELSE IF [MENTION=783256]redsta[/MENTION]t = [MENTION=1985011]param[/MENTION]Num
            BEGIN
                UPDATE      SRO_VT_SHARD.dbo._Items
                SET         MagParamNum -= 1
                WHERE       ID64 = @ID64
                RETURN -1
            END
        ELSE
            BEGIN
                DECLARE [MENTION=3898309]charname[/MENTION] VARCHAR(32) = (SELECT Charname16 FROM SRO_VT_SHARD.dbo._Char WHERE CharID = [MENTION=395373]Chari[/MENTION]D)
                INSERT INTO _Notification (TYPE,Target,Content,Executor)
                VALUES (4 [MENTION=3898309]charname[/MENTION], 'Error | Put the Item into Inventory Slot 1 please.',0)
                EXEC SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN [MENTION=3898309]charname[/MENTION],'ITEM_RED_REMOVER',1,0
                RETURN -2
            END