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
And execute gives me this error: Msg 208, Level 16, State 6, Procedure _RedStatRemover, Line 9
Invalid object name 'dbo._RedStatRemover'.
Which else ill need for this remove red option scroll?
Maximum Durability Scroll Remover 04/02/2020 - SRO Private Server - 6 Replies Hi guys who can help me changing this Produce to remove only the Maximum durability % reduce , be cause right now clean me all the blue in the item
IF(@JobID= '33859')
BEGIN
Update _Items
Set MagParamNum = 0, MagParam1 = NULL, MagParam2 = NULL, MagParam3 = NULL, MagParam4 = NULL, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL where ID64 in (select ItemID from _Inventory where...
problem with recall Durability & Blue Scroll 03/21/2019 - SRO Private Server - 9 Replies IF (@Operation = 41) and (@ItemRefID = XXXXXXXXX)
Begin
Update SRO_VT_SHARD.dbo._Items Set MagParamNum = 0, MagParam1 = NULL, MagParam2 = NULL, MagParam3 = NULL, MagParam4 = NULL, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL Where ID64 = (Select ItemID From .. Where CharID = ChariD and Slot = '13' and ItemID > 0)
End
this scroll will remove all the blues and the durability at the same...
[Buying] Looking for an account with plat rewards of s5 maximun 30 euros 04/27/2016 - League of Legends Trading - 1 Replies I´m looking for an euw acc s5 plat rewards with a maximun of 30 euros by paypal or psc pls only trusted guys add me skype:tumilet10
[Buying] Looking for an account with plat rewards of s5 maximun 30 euros 04/26/2016 - League of Legends Trading - 4 Replies I´m looking for an account with s5 plat rewards i have 30 euros maximun pls contact me via skype :tumilet10 i will go first if you are trusted i pay by paypal or psc
[B]Crysis 2 Maximun Edition [S] PSC/e*gold 12/04/2012 - elite*gold Trading - 3 Replies Hi,
biete hier meinen Crysis 2 Maximum Edition Steamaccount:
Ich habe es 6 Minuten gespielt, da ich erst dann gemerkt habe, mein PC ist zu schlecht für die Grafik :(
Ich suche PSC/E*gold, bietet einfach was. GGF tausche ich auch!!
Kaufbeleg müsste ich schnell suchen :s