vSRO Paylaşım vSRO Toplu Prosedür Paylaşımı

Tittle

if (@ItemRefID = '78646' and @Operation = 41) begin update SRO_VT_SHARD.dbo._Char set HwanLevel = 1 where CharID = @charID end
Durability Reset scroll
Kod:
if(@Operation = 41 and @ItemRefID= '78343') --DURABILITY RESET SCROLL
begin
Update SRO_VT_SHARD.._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 SRO_VT_SHARD.._Inventory where CharID = @CharID and Slot =13 and ItemID Between 1 AND 999999999)

end



Devil Cinsiyet Değiştirici

IF (@Operation = 41) -- If item used!
Begin
IF (@ItemRefID = 78342) -- DEVIL GENDER CINSIYET DEĞİŞTİRİCİ
Begin
Declare @InvID INT = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0)
Declare @RefItemID INT = (Select RefItemID From [SRO_VT_SHARD].[dbo].[_Items] Where ID64 = @InvID)
IF @RefItemID in (24414,24972,24974,24976,24978,24406,24408,24410,24412) -- IF found your Devil is Male
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24413' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24414 --@Devil B Event
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24971' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24972 --@Devil A Red Event
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24973' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24974 --@Devil A Yellow Event
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24975' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24976 --@Devil A Blue Event
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24977' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24978 --@Devil S Event
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24405' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24406 --@Devil A Red Mall
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24407' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24408 --@Devil A Yellow Mall
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24409' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24410 --@Devil A Blue Mall
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24411' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24412 --@Devil S Mall
End
ELSE IF @RefItemID in (24413,24971,24973,24975,24977,24405,24407,24409,24411) -- IF found your Devil is Female
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24414' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24413 --@Devil B Event
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24972' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24971 --@Devil A Red Event
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24974' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24973 --@Devil A Yellow Event
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24976' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24975 --@Devil A Blue Event
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24978' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24977 --@Devil S Event
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24406' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24405 --@Devil A Red Mall
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24408' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24407 --@Devil A Yellow Mall
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24410' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24409 --@Devil A Blue Mall
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24412' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24411 --@Devil S Mall
End
End

Thief Şehir içi bug fix

IF @operation = 144
BEGIN
DECLARE @JobType tinyint , @IsBattleField bit, @ItemID int
SELECT @JobType = CTJ.JobType, @IsBattleField = R.IsBattleField FROM SRO_VT_SHARD.dbo._Char C
INNER JOIN SRO_VT_SHARD.dbo._CharTriJob CTJ ON C.CharID = CTJ.CharID
INNER JOIN SRO_VT_SHARD.dbo._RefRegion R ON C.LatestRegion = R.wRegionID
WHERE C.CharID = @CharID

IF @JobType = 2 AND @IsBattleField = 0
BEGIN
SELECT @ItemID = ID64 FROM SRO_VT_SHARD.dbo._Items WHERE Serial64 = @ItemSerial
UPDATE SRO_VT_SHARD.dbo._InvCOS SET ItemID = 0 WHERE ItemID = @ItemID
END
END

model switcher

IF (@Operation = 41 AND (@ItemRefID between '78001' and '78012')) -- 1-12 Dg Moon Model Switcher
Begin
EXEC SRO_VT_LOG.dbo._MODEL_SWITCHER_MOON @CharID,@ItemRefID
End

Adv silici

IF (@Operation = 41 AND @ItemRefID='78013') -- ADV SİLİCİ
Begin
EXEC SRO_VT_LOG.dbo._Scroll @CharID,@ItemRefID
End

Snow shield açıcı

IF (@Operation = 41 AND @ItemRefID='78014') -- SNOW SHIELD AÇICI
BEGIN
EXEC SRO_VT_LOG.dbo._Scroll @CharID,@ItemRefID
END
Stat Recall
Kod:
IF (@Operation=41 AND @ItemRefID='70001') --STAT RECALL
BEGIN
EXEC SRO_VT_LOG.dbo._Scroll @CharID,@ItemRefID
END
Skill recall

IF (@Operation=41 AND @ItemRefID='70002') --SKILL RECALL
BEGIN
EXEC SRO_VT_LOG.dbo._Scroll @CharID,@ItemRefID
END
Fgw Time reset

IF (@Operation=41 AND @ItemRefID='70004') -- FGW Time Remove
BEGIN
EXEC SRO_VT_LOG.dbo._Scroll @CharID,@ItemRefID
END

Premium reset

IF (@Operation=41 AND @ItemRefID='78015') -- Premium Delete Scroll
BEGIN
EXEC SRO_VT_LOG.dbo._Scroll @CharID,@ItemRefID
END

Job Reset

if(@Operation = 41 and @Slot_To = 255 and (@ItemRefID = 78016)) --Job Penalty Remover-- --coded:sonerefe--
begin
DELETE FROM SRO_VT_SHARD.._TimedJob WHERE CharID=@CharID and (JobID = 1 and Category = 2)
DELETE FROM SRO_VT_SHARD.._TimedJob WHERE CharID=@CharID and (JobID = 2)
end

GiftBox

IF (@Operation=41 AND @ItemRefID='78036') -- Gift Box
BEGIN
EXEC SRO_VT_LOG.dbo._Scroll @CharID,@ItemRefID
END
+ sınırlama

-- ARTI SINIRLAMA

IF (@Operation = 90 AND @strDesc like '%Opt: +13%' )
BEGIN
UPDATE SRO_VT_SHARD.dbo._Items SET OptLevel = 12 WHERE Serial64 = @ItemSerial
END
IF (@Operation = 90 AND @strDesc like '%Opt: +14%' )
BEGIN
UPDATE SRO_VT_SHARD.dbo._Items SET OptLevel = 12 WHERE Serial64 = @ItemSerial
END
IF (@Operation = 90 AND @strDesc like '%Opt: +15%' )
BEGIN
UPDATE SRO_VT_SHARD.dbo._Items SET OptLevel = 12 WHERE Serial64 = @ItemSerial
END
IF (@Operation = 90 AND @strDesc like '%Opt: +16%' )
BEGIN
UPDATE SRO_VT_SHARD.dbo._Items SET OptLevel = 12 WHERE Serial64 = @ItemSerial
END
IF (@Operation = 90 AND @strDesc like '%Opt: +17%' )
BEGIN
UPDATE SRO_VT_SHARD.dbo._Items SET OptLevel = 12 WHERE Serial64 = @ItemSerial
END
IF (@Operation = 90 AND @strDesc like '%Opt: +18%' )
BEGIN
UPDATE SRO_VT_SHARD.dbo._Items SET OptLevel = 12 WHERE Serial64 = @ItemSerial
END
IF (@Operation = 90 AND @strDesc like '%Opt: +19%' )
BEGIN
UPDATE SRO_VT_SHARD.dbo._Items SET OptLevel = 12 WHERE Serial64 = @ItemSerial
END
IF (@Operation = 90 AND @strDesc like '%Opt: +20%' )
BEGIN
UPDATE SRO_VT_SHARD.dbo._Items SET OptLevel = 12 WHERE Serial64 = @ItemSerial
END

teşekkürler