vSRO Çözüldü return sıkıntısı

Prosedürlerini bi at bakalım, item tipi ile mi kodlama ilemi alakalı

Muhtemelen kodlama ile alakalı önce çalışıp sonra çalışmıyorsa, onun yakın satırlarına eklediğin bir eklenti yüzünden görevini gerçekleştirmiyor.

Promaker' Alıntı:

Prosedürlerini bi at bakalım, item tipi ile mi kodlama ilemi alakalı

Genişletmek için tıkla ...

USE [SRO_VT_LOG]
GO
/****** Object: StoredProcedure [dbo].[_AddLogItem] Script Date: 29.10.2025 23:28:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


-------------------------------------------------------------------------------------------------------------------
-- Step 2
-- ±âÁ¸ ¾ÆÀÌÅÛ ·Î±× ÀÔ·Â Stored procedure ¼öÁ¤
-- DataBase : Shard Log
ALTER procedure [dbo].[_AddLogItem]
@CharID int,
@ItemRefID int,
@ItemSerial bigint,
@dwData int,
@TargetStorage tinyint,
@Operation tinyint,
@Slot_From tinyint,
@Slot_To tinyint,
@EventPos varchar(64),
@strDesc varchar(128),
@Gold bigint -- #ifdef EXTEND_GOLD_TYPE »ðÀÔ
as
declare @len_pos int
declare @len_desc int
set @len_pos = len(@EventPos)
set @len_desc = len(@strDesc)
if (@len_pos > 0 and @len_desc > 0)
begin
insert _LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, EventPos, strDesc, Serial64, Gold) -- #ifdef EXTEND_GOLD_TYPE ±³Ã¼
values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @Operation, @Slot_From, @Slot_To, @EventPos, @strDesc, @ItemSerial, @Gold) -- #ifdef EXTEND_GOLD_TYPE ±³Ã¼
end
else if (@len_pos > 0 and @len_desc = 0)
begin
insert _LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, EventPos, Serial64, Gold) -- #ifdef EXTEND_GOLD_TYPE ±³Ã¼
values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @Operation, @Slot_From, @Slot_To, @EventPos, @ItemSerial, @Gold) -- #ifdef EXTEND_GOLD_TYPE ±³Ã¼
end
else if (@len_pos = 0 and @len_desc > 0)
begin
insert _LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, strDesc, Serial64, Gold) -- #ifdef EXTEND_GOLD_TYPE ±³Ã¼
values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @Operation, @Slot_From, @Slot_To, @strDesc, @ItemSerial, @Gold) -- #ifdef EXTEND_GOLD_TYPE ±³Ã¼
end
else if (@len_pos = 0 and @len_desc = 0)
begin
insert _LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, Serial64, Gold) -- #ifdef EXTEND_GOLD_TYPE ±³Ã¼
values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @Operation, @Slot_From, @Slot_To, @ItemSerial, @Gold) -- #ifdef EXTEND_GOLD_TYPE ±³Ã¼
end
-- À¯·á ¾ÆÀÌÅÛ ±¸ÀÔÀ̸é!
-- #define LOG_ITEMEVENT_BUY_CASHITEM (BYTE)35
if (@Operation = 35)
begin
insert _LogCashItem (RefItemID, CharID, Cnt, EventTime, Serial64)
values(@ItemRefID, @CharID, @dwData, GetDate(), @ItemSerial)
end

--Model Scroll
if (@ItemRefID = 43568 and @Operation = 16) begin exec SRO_VT_LOG.dbo._Switcher_08 @CharID,13 end --8 dg model
if (@ItemRefID = 43569 and @Operation = 16) begin exec SRO_VT_LOG.dbo._Switcher_09 @CharID,13 end --9 dg model
if (@ItemRefID = 43570 and @Operation = 16) begin exec SRO_VT_LOG.dbo._Switcher_11 @CharID,13 end --11 dg model
if (@ItemRefID = 43571 and @Operation = 16) begin exec SRO_VT_LOG.dbo._Switcher_11_A @CharID,13 end --11 dg power model
if (@ItemRefID = 43572 and @Operation = 16) begin exec SRO_VT_LOG.dbo._Switcher_11_B @CharID,13 end --11 dg fight model
if (@ItemRefID = 43573 and @Operation = 16) begin exec SRO_VT_LOG.dbo._Switcher_12 @CharID,13 end --12 dg model
if (@ItemRefID = 43574 and @Operation = 16) begin exec SRO_VT_LOG.dbo._Switcher_10 @CharID,13 end --13 dg model
if (@ItemRefID = 43575 and @Operation = 16) begin exec SRO_VT_LOG.dbo._Switcher_14 @CharID,13 end --14 dg model
if (@ItemRefID = 43576 and @Operation = 16) begin exec SRO_VT_LOG.dbo._Switcher_15 @CharID,13 end --15 dg model
if (@ItemRefID = 45948 and @Operation = 16) begin exec SRO_VT_LOG.dbo._Switcher_reset @CharID,13 end --reset


if (@ItemRefID = 45913 and @Operation = 16) begin exec SRO_VT_LOG.dbo._BLUE @CharID,13 end --blue
if (@ItemRefID = 45914 and @Operation = 16) begin exec SRO_VT_LOG.dbo._BODH @CharID,13 end --bodh
if (@ItemRefID = 45915 and @Operation = 16) begin exec SRO_VT_LOG.dbo._BODZ @CharID,13 end --bodz
if (@ItemRefID = 45916 and @Operation = 16) begin exec SRO_VT_LOG.dbo._FIRE @CharID,13 end --fıre
if (@ItemRefID = 45917 and @Operation = 16) begin exec SRO_VT_LOG.dbo._FIRE_1 @CharID,13 end --fıre1
if (@ItemRefID = 45918 and @Operation = 16) begin exec SRO_VT_LOG.dbo._GREEN @CharID,13 end --green
if (@ItemRefID = 45919 and @Operation = 16) begin exec SRO_VT_LOG.dbo._RED @CharID,13 end --red
if (@ItemRefID = 45920 and @Operation = 16) begin exec SRO_VT_LOG.dbo._YELLOW @CharID,13 end --yellow
if (@ItemRefID = 45921 and @Operation = 16) begin exec SRO_VT_LOG.dbo._RAINBOW @CharID,13 end --raınbow
if (@ItemRefID = 45922 and @Operation = 16) begin exec SRO_VT_LOG.dbo._PURB @CharID,13 end --purb
if (@ItemRefID = 45923 and @Operation = 16) begin exec SRO_VT_LOG.dbo._ORANGE @CharID,13 end --orange
if (@ItemRefID = 45924 and @Operation = 16) begin exec SRO_VT_LOG.dbo._RESET @CharID,13 end --RESET





--Tıtle scroll

IF (@Operation = 41) and (@ItemRefID = 43378)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 1 Where [CharID] = @CharID /* this is scroll no.: 1 , change 1 to your hwan number */
End

IF (@Operation = 41) and (@ItemRefID = 43379)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 2 Where [CharID] = @CharID /* this is scroll no.: 2 , change 2 to your hwan number */
End

IF (@Operation = 41) and (@ItemRefID = 43380)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 3 Where [CharID] = @CharID /* this is scroll no.: 3 , change 3 to your hwan number */
End

IF (@Operation = 41) and (@ItemRefID = 43381)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 4 Where [CharID] = @CharID /* this is scroll no.: 4 , change 4 to your hwan number */
End

IF (@Operation = 41) and (@ItemRefID = 43382)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 5 Where [CharID] = @CharID /* this is scroll no.: 5 , change 5 to your hwan number */
End

IF (@Operation = 41) and (@ItemRefID = 43383)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 6 Where [CharID] = @CharID /* this is scroll no.: 6 , change 6 to your hwan number */
End

IF (@Operation = 41) and (@ItemRefID = 43384)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 7 Where [CharID] = @CharID /* this is scroll no.: 7 , change 7 to your hwan number */
End

IF (@Operation = 41) and (@ItemRefID = 43385)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 8 Where [CharID] = @CharID /* this is scroll no.: 8 , change 8 to your hwan number */
End

IF (@Operation = 41) and (@ItemRefID = 43386)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 9 Where [CharID] = @CharID /* this is scroll no.: 9 , change 9 to your hwan number */
End

IF (@Operation = 41) and (@ItemRefID = 43387)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 10 Where [CharID] = @CharID /* this is scroll no.: 10 , change 10 to your hwan number */
End

IF (@Operation = 41) and (@ItemRefID = 43388)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 11 Where [CharID] = @CharID /* this is scroll no.: 11 , change 11 to your hwan number */
End

IF (@Operation = 41) and (@ItemRefID = 43389)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 12 Where [CharID] = @CharID /* this is scroll no.: 12 , change 12 to your hwan number */
End

IF (@Operation = 41) and (@ItemRefID = 43390)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 13 Where [CharID] = @CharID /* this is scroll no.: 13 , change 13 to your hwan number */
End

IF (@Operation = 41) and (@ItemRefID = 43391)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 14 Where [CharID] = @CharID /* this is scroll no.: 14 , change 14 to your hwan number */
End

IF (@Operation = 41) and (@ItemRefID = 43392)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 15 Where [CharID] = @CharID /* this is scroll no.: 15 , change 15 to your hwan number */
End

IF (@Operation = 41) and (@ItemRefID = 43393)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 16 Where [CharID] = @CharID /* this is scroll no.: 16 , change 16 to your hwan number */
End

IF (@Operation = 41) and (@ItemRefID = 43394)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 17 Where [CharID] = @CharID /* this is scroll no.: 17 , change 17 to your hwan number */
End

IF (@Operation = 41) and (@ItemRefID = 43395)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 18 Where [CharID] = @CharID /* this is scroll no.: 18 , change 18 to your hwan number */
End

IF (@Operation = 41) and (@ItemRefID = 43396)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 19 Where [CharID] = @CharID /* this is scroll no.: 19 , change 19 to your hwan number */
End

IF (@Operation = 41) and (@ItemRefID = 43397)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 20 Where [CharID] = @CharID /* this is scroll no.: 20 , change 20 to your hwan number */
End

IF (@Operation = 41) and (@ItemRefID = 43398)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 21 Where [CharID] = @CharID /* this is scroll no.: 21 , change 1 to your hwan number */
End

IF (@Operation = 41) and (@ItemRefID = 43399)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 22 Where [CharID] = @CharID /* this is scroll no.: 2 , change 2 to your hwan number */
End

IF (@Operation = 41) and (@ItemRefID = 43400)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 23 Where [CharID] = @CharID /* this is scroll no.: 3 , change 3 to your hwan number */
End

IF (@Operation = 41) and (@ItemRefID = 43401)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 24 Where [CharID] = @CharID /* this is scroll no.: 4 , change 4 to your hwan number */
End

IF (@Operation = 41) and (@ItemRefID = 43402)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 25 Where [CharID] = @CharID /* this is scroll no.: 5 , change 5 to your hwan number */
End

IF (@Operation = 41) and (@ItemRefID = 43403)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 26 Where [CharID] = @CharID /* this is scroll no.: 6 , change 6 to your hwan number */
End

IF (@Operation = 41) and (@ItemRefID = 43404)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 27 Where [CharID] = @CharID /* this is scroll no.: 7 , change 7 to your hwan number */
End

IF (@Operation = 41) and (@ItemRefID = 43405)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 28 Where [CharID] = @CharID /* this is scroll no.: 8 , change 8 to your hwan number */
End

IF (@Operation = 41) and (@ItemRefID = 43406)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 29 Where [CharID] = @CharID /* this is scroll no.: 9 , change 9 to your hwan number */
End

IF (@Operation = 41) and (@ItemRefID = 43407)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 30 Where [CharID] = @CharID /* this is scroll no.: 10 , change 10 to your hwan number */
End

IF (@Operation = 41) and (@ItemRefID = 43408)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 31 Where [CharID] = @CharID /* this is scroll no.: 11 , change 11 to your hwan number */
End

IF (@Operation = 41) and (@ItemRefID = 43409)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 32 Where [CharID] = @CharID /* this is scroll no.: 12 , change 12 to your hwan number */
End

IF (@Operation = 41) and (@ItemRefID = 43410)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 33 Where [CharID] = @CharID /* this is scroll no.: 13 , change 13 to your hwan number */
End

IF (@Operation = 41) and (@ItemRefID = 43411)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 34 Where [CharID] = @CharID /* this is scroll no.: 14 , change 14 to your hwan number */
End

IF (@Operation = 41) and (@ItemRefID = 43412)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 35 Where [CharID] = @CharID /* this is scroll no.: 15 , change 15 to your hwan number */
End

IF (@Operation = 41) and (@ItemRefID = 43413)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 36 Where [CharID] = @CharID /* this is scroll no.: 16 , change 16 to your hwan number */
End

IF (@Operation = 41) and (@ItemRefID = 43414)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 37 Where [CharID] = @CharID /* this is scroll no.: 17 , change 17 to your hwan number */
End

IF (@Operation = 41) and (@ItemRefID = 43415)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 38 Where [CharID] = @CharID /* this is scroll no.: 18 , change 18 to your hwan number */
End

IF (@Operation = 41) and (@ItemRefID = 43416)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 39 Where [CharID] = @CharID /* this is scroll no.: 19 , change 19 to your hwan number */
End

IF (@Operation = 41) and (@ItemRefID = 43417)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 40 Where [CharID] = @CharID /* this is scroll no.: 20 , change 20 to your hwan number */
End

IF (@Operation = 41) and (@ItemRefID = 43418)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 41 Where [CharID] = @CharID /* this is scroll no.: 16 , change 16 to your hwan number */
End

IF (@Operation = 41) and (@ItemRefID = 43419)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 42 Where [CharID] = @CharID /* this is scroll no.: 17 , change 17 to your hwan number */
End

IF (@Operation = 41) and (@ItemRefID = 43420)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 43 Where [CharID] = @CharID /* this is scroll no.: 18 , change 18 to your hwan number */
End

IF (@Operation = 41) and (@ItemRefID = 43421)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 44 Where [CharID] = @CharID /* this is scroll no.: 19 , change 19 to your hwan number */
End

IF (@Operation = 41) and (@ItemRefID = 43474)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 45 Where [CharID] = @CharID /* this is scroll no.: 20 , change 20 to your hwan number */
End


IF (@Operation = 41) -- scroll is used and item in first slot in inventory
BEGIN
IF (@ItemRefID = 43139) -- Adv removal
BEGIN
DELETE FROM [SRO_VT_SHARD].[dbo].[_BindingOptionWithItem] where nItemDBID IN (SELECT ItemID FROM [SRO_VT_SHARD].[dbo].[_Inventory] WHERE Slot= 13 AND CharID = @CharID) and bOptType = 2
END
END
--skill reset
IF ((@Operation = 41 ) AND (@ItemRefID = 43136))
BEGIN
declare @TotalSP int
declare @TotalSPMastery int
SELECT @TotalSP = SUM([SRO_VT_SHARD].[dbo]._RefSkill.ReqLearn_SP) FROM [SRO_VT_SHARD].[dbo]._RefSkill, [SRO_VT_SHARD].[dbo]._CharSkill WHERE [SRO_VT_SHARD].[dbo]._RefSkill.ID=[SRO_VT_SHARD].[dbo]._CharSkill.SkillID AND [SRO_VT_SHARD].[dbo]._CharSkill.CharID=@CharID AND [SRO_VT_SHARD].[dbo]._RefSkill.ReqCommon_MasteryLevel1 <= '120'
SELECT @TotalSPMastery = SUM(_RefLevel.Exp_M) FROM [SRO_VT_SHARD].[dbo].[_CharSkillMastery], [SRO_VT_SHARD].[dbo].[_RefLevel] WHERE [SRO_VT_SHARD].[dbo].[_RefLevel].Lvl=[SRO_VT_SHARD].[dbo].[_CharSkillMastery].Level AND [SRO_VT_SHARD].[dbo]._CharSkillMastery.CharID=@CharID AND [SRO_VT_SHARD].[dbo]._CharSkillMastery.Level <= '120'
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET RemainSkillPoint=RemainSkillPoint+@TotalSP+@TotalSPMastery+200000 WHERE CharID=@CharID
DELETE [SRO_VT_SHARD].[dbo].[_CharSkill] FROM [SRO_VT_SHARD].[dbo]._RefSkill, [SRO_VT_SHARD].[dbo]._CharSkill WHERE [SRO_VT_SHARD].[dbo]._RefSkill.ID=[SRO_VT_SHARD].[dbo]._CharSkill.SkillID AND [SRO_VT_SHARD].[dbo]._CharSkill.CharID=@CharID AND [SRO_VT_SHARD].[dbo]._RefSkill.ReqCommon_MasteryLevel1 <= '120' AND [SRO_VT_SHARD].[dbo]._RefSkill.ID NOT IN (1,70,40,2,8421,9354,9355,11162,9944,8419,8420,11526,10625)
UPDATE [SRO_VT_SHARD].[dbo]._CharSkillMastery SET Level='0' WHERE CharID=@CharID AND Level <= '120'

END

--job reset
IF ( @Operation = '41') AND @ItemRefID = '43138'
BEGIN
DELETE FROM [SRO_VT_SHARD].[dbo]._TimedJob where JobID = '2' AND CharID = @CharID
END

--durbilty

IF (@Operation = 41 and @ItemRefID = 49630)
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 in (select ItemID from [SRO_VT_SHARD].[dbo]._Inventory where CharID = @CharID and Slot between 0 and 12 and ItemID Between 1 AND 999999999)
END



--pre reset

IF (@Operation = 41 and @ItemRefID = 49631)
BEGIN
Delete FROM [SRO_VT_SHARD].[dbo]._TimedJob WHERE CharID = @CharID and JobID in (1,2,3,4,5,6)
END

@Promaker tunahan abi burda bir sıkıntı var sanırım komple bir yerde bir sıkıntı va burdaki scrollar çalışmıyor diğer scrollarda sıkıntı yok