الـجـروب الـرسـمى لـلـمـنـتـدى FaceBook | Official Group

**SAGY** · 21-05-2017, 06:49 AM

السلام عليكم
انا دلوقتي عندي skill & state reset scroll في الداتا .. لما بنزلهم و اضربهم مثلا بيرجع المدينة عادي
بس مفيش حاجة بتحصل كأنها سكرول عادي يعني ..
حلها فين دي

**MikrotikBody** · 21-05-2017, 12:17 PM

وريني ال _AddLogItem

**SAGY** · 21-05-2017, 02:14 PM

كود:

USE [sro_vt_shard]
GO
/****** Object:  StoredProcedure [dbo].[_AddLogItem]    Script Date: 5/21/2017 4:14:00 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO


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)
		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)
				values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @Operation, @Slot_From, @Slot_To, @EventPos, @strDesc, @ItemSerial)
			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)
				values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @Operation, @Slot_From, @Slot_To, @EventPos, @ItemSerial)
			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)
				values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @Operation, @Slot_From, @Slot_To, @strDesc, @ItemSerial)
			end
			else if (@len_pos = 0 and @len_desc = 0)
			begin
				insert _LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, Serial64)
				values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @Operation, @Slot_From, @Slot_To, @ItemSerial)
			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

**MikrotikBody** · 21-05-2017, 02:40 PM

SRO_VT_SHARLOG Not SRO_VT_SHARD

**SAGY** · 21-05-2017, 02:54 PM

كود:

USE [sro_vt_shardlog]
GO
/****** Object:  StoredProcedure [dbo].[_AddLogItem]    Script Date: 5/21/2017 4:54:11 AM ******/
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 
  IF @ItemRefID = '41853' AND @Operation = '41'
  BEGIN
  DELETE FROM SRO_VT_HYRIEUS.dbo._GemSkillLog WHERE CharID = @CharID
  DELETE FROM SRO_VT_SHARD.dbo._CharSkill WHERE CharID = @CharID AND SkillID BETWEEN '39236' AND  '39441'
  EXEC SRO_VT_SHARD.[dbo].[_RoyalAddEquipment] @CharID , 24668,'11','0'
  END
  IF @ItemRefID = '22926' AND @Operation = '41'
  BEGIN
  DECLARE @CharName21 varchar(128) = (SELECT CharName16 FROM SRO_VT_SHARD.dbo._Char  With(NoLOCK) where CharID = @CharID)
  INSERT INTO SRO_VT_HYRIEUS.dbo._Chat ([send],[sendto],[Message],[date]) VALUES ('0',@CharName21,'Please remember to teleport in order to activate the item you ve used!',GETDATE())
  	END
  -- Gem Mastery Scroll Setting
  IF @Operation = '41' AND @ItemRefID BETWEEN '47747' AND '47768'
  BEGIN
  EXEC SRO_VT_HYRIEUS.dbo._GemScrollsz @CharID,@ItemRefID,@Operation
  END
  -- Skill Scroll System 
  IF (@ItemRefID BETWEEN '47726' AND '47770' OR @ItemRefID BETWEEN '47840' AND '47843') AND @Operation = '41'
  BEGIN
  DECLARE @SkillID INT = (SELECT ItemID FROM SRO_VT_HYRIEUS.dbo._SSys WITH (NOLOCK) WHERE ScrollID = @ItemRefID)
  IF @SkillID IS NOT NULL
  BEGIN
  INSERT INTO SRO_VT_SHARD.dbo._CharSkill (CharID,SkillID,[Enable]) VALUES (@CharID,@SkillID,1)
  END
   END
  -- Dye Effect System
  IF @ItemRefID Between '47644' AND '47657' AND @Operation = '41' 
  BEGIN
  EXEC SRO_VT_HYRIEUS.dbo._EffectSystem_Weapon @CharID , @ItemRefID
  END
  IF @ItemRefID Between '47658' AND '47671' AND @Operation = '41' 
  BEGIN
  EXEC SRO_VT_HYRIEUS.dbo._EffectSystem_Shield @CharID , @ItemRefID
  END 
                   
  --- Egy Box System
  IF (  @Operation =   '41') AND @ItemRefID BETWEEN '41847' AND '41848'
  BEGIN 
  DECLARE @Type Varchar(16)  
       IF @ItemRefID = '41847'
       BEGIN
       SET @Type = 'EGY_A'
       END
       ELSE IF @ItemRefID = '41848'
       BEGIN
       SET @Type = 'EGY_B'
       END
  DECLARE @RandomID int = (SELECT TOP 1 ItemID FROM SRO_VT_HYRIEUS.dbo._EgyBoxs WITH(NOLOCK)  WHERE [Type] = @Type ORDER BY NEWID() )
  EXEC SRO_VT_SHARD.dbo._RoyalAddEquipment @CharID,@RandomID,1,'0' 
  END
  --- Rec System
  IF (  @Operation =   '41') AND @ItemRefID BETWEEN '41911' AND '41958'
  BEGIN 
  DECLARE @ItemIDS int = (SELECT ItemID FROM SRO_VT_HYRIEUS.dbo._RecSystemT WITH(NOLOCK) WHERE ScrollID = @ItemRefID)
  EXEC SRO_VT_SHARD.dbo._RoyalAddEquipment @CharID,@ItemIDS,1,'8' 
  END
  IF  (  @Operation =   '41') AND (@ItemRefID BETWEEN '41841' AND '41846') 
             BEGIN
              EXEC SRO_VT_HYRIEUS.dbo.[_RecSystem] @CharID,@ItemRefID
               END
 --- Treasure Box System 
 IF  (  @Operation =   '41') AND (@ItemRefID BETWEEN '41835' AND '41837' OR @ItemRefID BETWEEN '41838' AND '41840') 
             BEGIN
              EXEC SRO_VT_HYRIEUS.dbo.[_TreasureBox] @CharID,@ItemRefID,@Operation
               END
 --- Full Blue System           
 IF (  @Operation =   '41') AND @ItemRefID  BETWEEN '41821' AND '41832'
    BEGIN 
    EXEC [SRO_VT_HYRIEUS].dbo.[_FbScroll] @CharID,@ItemRefID,@Operation 
    END
    -- Guild Penalty Remover
 IF (  @Operation =   '41') AND @ItemRefID  = '41833' 
     BEGIN DELETE FROM SRO_VT_SHARD.dbo._TimedJob  where JobID = '1'AND CharID = @CharID END
    -- Job Penalty Remover
 IF (  @Operation =   '41') AND @ItemRefID  = '41834' 
     BEGIN DELETE FROM SRO_VT_SHARD.dbo._TimedJob  where JobID = '2'AND CharID = @CharID END          
 /*   -- Pk Remover
 IF(@ItemRefID = '41820' AND  @Operation =   '41') -- Pk Remover 
        BEGIN 
        UPDATE SRO_VT_SHARD.dbo._Char 
        SET DailyPK = 0 , TotalPK = 0 ,PKPenaltyPoint = 0  WHERE CharID = @CharID 
        END*/
    -- SP Scroll To Char
    DECLARE @SPCount int 
            SELECT @SPCount = 
            CASE WHEN @ItemRefID = '41811' Then '100000'
                 WHEN @ItemRefID = '41812' Then '200000'
                 WHEN @ItemRefID = '41813' Then '350000'
                 WHEN @ItemRefID = '41814' Then '500000'
                 ELSE 0 END
  IF (  @Operation =   '41') AND (@ItemRefID BETWEEN  '41811' AND '41814')
                   BEGIN
                     EXEC SRO_VT_SHARD.[CGI].[CGI_SkillPoint_Charger] @CharID,@SPCount
                      END
    /* --- Skill Reset Scroll
     if(@ItemRefID = '41810' )
              BEGIN
              IF (  @Operation =   '41')
              
		begin
		Declare @cname16 varchar(256);
		SET @cname16 = (Select charname16 from SRO_VT_SHARD.DBO._Char WITH(NOLOCK) where CharID = @CharID)
		
			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 <= '110'
			SELECT @TotalSPMastery = SUM(SRO_VT_SHARD.DBO._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 <= '110'
			UPDATE SRO_VT_SHARD.DBO._Char SET RemainSkillPoint=RemainSkillPoint+@TotalSP+@TotalSPMastery+'1200000' WHERE CharID=@CharID
			DELETE SRO_VT_SHARD.DBO._CharSkill FROM SRO_VT_SHARD.DBO._RefSkill, SRO_VT_SHARD.DBO._CharSkill WITH(NOLOCK) 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 <= '110' 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 <= '110'	 
			
			END
			 END */
          -- Prem Remover
          IF (  @Operation =   '41') AND (@ItemRefID = '41815')
            BEGIN
            DELETE FROM SRO_VT_SHARD.dbo._TimedJob  where  CharID = @CharID AND JobID = '9277'
             OR JobID = '9278' AND CharID = @CharID
			 OR	JobID = '5412' AND CharID = @CharID
			 OR	JobID = '35567' AND CharID = @CharID
			 OR	JobID = '34048' AND CharID = @CharID
             OR	JobID = '22924' AND CharID = @CharID
			 OR	JobID = '34049' AND CharID = @CharID
            END
       IF (  @Operation =   '41') AND (@ItemRefID = '41816')
        BEGIN
         DECLARE @ItemID int 
          SELECT @ItemID=ItemID from SRO_VT_SHARD.dbo._Inventory WITH(NOLOCK) where CharID = @CharID AND Slot = '13' 
           DELETE FROM SRO_VT_SHARD.dbo._BindingOptionWithItem  WHERE nItemDBID = @ItemID and bOptType=2
            END
            -- Avatar Remover
            DECLARE @Slot int 
            SELECT @Slot = 
            CASE WHEN @ItemRefID = '41817' Then '0'
                 WHEN @ItemRefID = '41818' Then '1'
                 WHEN @ItemRefID = '41819' Then '2'
                 ELSE 0
                        END
            
       DECLARE @ItemID_1 int 
          SELECT @ItemID_1=ItemID from SRO_VT_SHARD.dbo._InventoryForAvatar WITH(NOLOCK) where CharID = @CharID AND Slot = @Slot -- HaT
     IF  (@ItemRefID BETWEEN '41817' AND '41819') 
       BEGIN
       IF (  @Operation =   '41') 
        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 = @ItemID_1
         END
          END
          
             
   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  
        return -1
     end  
   else if (@len_pos > 0 and @len_desc = 0)  
   begin  
        return -1
     end  
    else if (@len_pos = 0 and @len_desc > 0)  
   begin  
        return -1
     end  
   else if (@len_pos = 0 and @len_desc = 0)  
   begin  
        return -1
     end  
    -- أ€¯·أ، ¾أ†أ€أŒأ…أ› ±¸أ€أ”أ€أŒ¸é!  
   -- #define LOG_ITEMEVENT_BUY_CASHITEM  (BYTE)35  
   if (@Operation = 35)  
  begin  
        return -1
     end

**MikrotikBody** · 21-05-2017, 06:20 PM

حضرتك قافل اللوج اللي مخصص لي كده :]
اتفضل جرب كده
وشوف لو في أي حاجه تاني انا موجود

كود بلغة HTML:

USE [sro_vt_shardlog]
GO
/****** Object:  StoredProcedure [dbo].[_AddLogItem]    Script Date: 5/21/2017 4:54:11 AM ******/
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 
  IF @ItemRefID = '41853' AND @Operation = '41'
  BEGIN
  DELETE FROM SRO_VT_HYRIEUS.dbo._GemSkillLog WHERE CharID = @CharID
  DELETE FROM SRO_VT_SHARD.dbo._CharSkill WHERE CharID = @CharID AND SkillID BETWEEN '39236' AND  '39441'
  EXEC SRO_VT_SHARD.[dbo].[_RoyalAddEquipment] @CharID , 24668,'11','0'
  END
  IF @ItemRefID = '22926' AND @Operation = '41'
  BEGIN
  DECLARE @CharName21 varchar(128) = (SELECT CharName16 FROM SRO_VT_SHARD.dbo._Char  With(NoLOCK) where CharID = @CharID)
  INSERT INTO SRO_VT_HYRIEUS.dbo._Chat ([send],[sendto],[Message],[date]) VALUES ('0',@CharName21,'Please remember to teleport in order to activate the item you ve used!',GETDATE())
  	END
  -- Gem Mastery Scroll Setting
  IF @Operation = '41' AND @ItemRefID BETWEEN '47747' AND '47768'
  BEGIN
  EXEC SRO_VT_HYRIEUS.dbo._GemScrollsz @CharID,@ItemRefID,@Operation
  END
  -- Skill Scroll System 
  IF (@ItemRefID BETWEEN '47726' AND '47770' OR @ItemRefID BETWEEN '47840' AND '47843') AND @Operation = '41'
  BEGIN
  DECLARE @SkillID INT = (SELECT ItemID FROM SRO_VT_HYRIEUS.dbo._SSys WITH (NOLOCK) WHERE ScrollID = @ItemRefID)
  IF @SkillID IS NOT NULL
  BEGIN
  INSERT INTO SRO_VT_SHARD.dbo._CharSkill (CharID,SkillID,[Enable]) VALUES (@CharID,@SkillID,1)
  END
   END
  -- Dye Effect System
  IF @ItemRefID Between '47644' AND '47657' AND @Operation = '41' 
  BEGIN
  EXEC SRO_VT_HYRIEUS.dbo._EffectSystem_Weapon @CharID , @ItemRefID
  END
  IF @ItemRefID Between '47658' AND '47671' AND @Operation = '41' 
  BEGIN
  EXEC SRO_VT_HYRIEUS.dbo._EffectSystem_Shield @CharID , @ItemRefID
  END 
                   
  --- Egy Box System
  IF (  @Operation =   '41') AND @ItemRefID BETWEEN '41847' AND '41848'
  BEGIN 
  DECLARE @Type Varchar(16)  
       IF @ItemRefID = '41847'
       BEGIN
       SET @Type = 'EGY_A'
       END
       ELSE IF @ItemRefID = '41848'
       BEGIN
       SET @Type = 'EGY_B'
       END
  DECLARE @RandomID int = (SELECT TOP 1 ItemID FROM SRO_VT_HYRIEUS.dbo._EgyBoxs WITH(NOLOCK)  WHERE [Type] = @Type ORDER BY NEWID() )
  EXEC SRO_VT_SHARD.dbo._RoyalAddEquipment @CharID,@RandomID,1,'0' 
  END
  --- Rec System
  IF (  @Operation =   '41') AND @ItemRefID BETWEEN '41911' AND '41958'
  BEGIN 
  DECLARE @ItemIDS int = (SELECT ItemID FROM SRO_VT_HYRIEUS.dbo._RecSystemT WITH(NOLOCK) WHERE ScrollID = @ItemRefID)
  EXEC SRO_VT_SHARD.dbo._RoyalAddEquipment @CharID,@ItemIDS,1,'8' 
  END
  IF  (  @Operation =   '41') AND (@ItemRefID BETWEEN '41841' AND '41846') 
             BEGIN
              EXEC SRO_VT_HYRIEUS.dbo.[_RecSystem] @CharID,@ItemRefID
               END
 --- Treasure Box System 
 IF  (  @Operation =   '41') AND (@ItemRefID BETWEEN '41835' AND '41837' OR @ItemRefID BETWEEN '41838' AND '41840') 
             BEGIN
              EXEC SRO_VT_HYRIEUS.dbo.[_TreasureBox] @CharID,@ItemRefID,@Operation
               END
 --- Full Blue System           
 IF (  @Operation =   '41') AND @ItemRefID  BETWEEN '41821' AND '41832'
    BEGIN 
    EXEC [SRO_VT_HYRIEUS].dbo.[_FbScroll] @CharID,@ItemRefID,@Operation 
    END
    -- Guild Penalty Remover
 IF (  @Operation =   '41') AND @ItemRefID  = '41833' 
     BEGIN DELETE FROM SRO_VT_SHARD.dbo._TimedJob  where JobID = '1'AND CharID = @CharID END
    -- Job Penalty Remover
 IF (  @Operation =   '41') AND @ItemRefID  = '41834' 
     BEGIN DELETE FROM SRO_VT_SHARD.dbo._TimedJob  where JobID = '2'AND CharID = @CharID END          
 /*   -- Pk Remover
 IF(@ItemRefID = '41820' AND  @Operation =   '41') -- Pk Remover 
        BEGIN 
        UPDATE SRO_VT_SHARD.dbo._Char 
        SET DailyPK = 0 , TotalPK = 0 ,PKPenaltyPoint = 0  WHERE CharID = @CharID 
        END*/
    -- SP Scroll To Char
    DECLARE @SPCount int 
            SELECT @SPCount = 
            CASE WHEN @ItemRefID = '41811' Then '100000'
                 WHEN @ItemRefID = '41812' Then '200000'
                 WHEN @ItemRefID = '41813' Then '350000'
                 WHEN @ItemRefID = '41814' Then '500000'
                 ELSE 0 END
  IF (  @Operation =   '41') AND (@ItemRefID BETWEEN  '41811' AND '41814')
                   BEGIN
                     EXEC SRO_VT_SHARD.[CGI].[CGI_SkillPoint_Charger] @CharID,@SPCount
                      END
     --- Skill Reset Scroll
     if(@ItemRefID = '41810' )
              BEGIN
              IF (  @Operation =   '41')
              
		begin
		Declare @cname16 varchar(256);
		SET @cname16 = (Select charname16 from SRO_VT_SHARD.DBO._Char WITH(NOLOCK) where CharID = @CharID)
		
			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 <= '110'
			SELECT @TotalSPMastery = SUM(SRO_VT_SHARD.DBO._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 <= '110'
			UPDATE SRO_VT_SHARD.DBO._Char SET RemainSkillPoint=RemainSkillPoint+@TotalSP+@TotalSPMastery+'1200000' WHERE CharID=@CharID
			DELETE SRO_VT_SHARD.DBO._CharSkill FROM SRO_VT_SHARD.DBO._RefSkill, SRO_VT_SHARD.DBO._CharSkill WITH(NOLOCK) 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 <= '110' 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 <= '110'	 
			
			END
			 END 
          -- Prem Remover
          IF (  @Operation =   '41') AND (@ItemRefID = '41815')
            BEGIN
            DELETE FROM SRO_VT_SHARD.dbo._TimedJob  where  CharID = @CharID AND JobID = '9277'
             OR JobID = '9278' AND CharID = @CharID
			 OR	JobID = '5412' AND CharID = @CharID
			 OR	JobID = '35567' AND CharID = @CharID
			 OR	JobID = '34048' AND CharID = @CharID
             OR	JobID = '22924' AND CharID = @CharID
			 OR	JobID = '34049' AND CharID = @CharID
            END
       IF (  @Operation =   '41') AND (@ItemRefID = '41816')
        BEGIN
         DECLARE @ItemID int 
          SELECT @ItemID=ItemID from SRO_VT_SHARD.dbo._Inventory WITH(NOLOCK) where CharID = @CharID AND Slot = '13' 
           DELETE FROM SRO_VT_SHARD.dbo._BindingOptionWithItem  WHERE nItemDBID = @ItemID and bOptType=2
            END
            -- Avatar Remover
            DECLARE @Slot int 
            SELECT @Slot = 
            CASE WHEN @ItemRefID = '41817' Then '0'
                 WHEN @ItemRefID = '41818' Then '1'
                 WHEN @ItemRefID = '41819' Then '2'
                 ELSE 0
                        END
            
       DECLARE @ItemID_1 int 
          SELECT @ItemID_1=ItemID from SRO_VT_SHARD.dbo._InventoryForAvatar WITH(NOLOCK) where CharID = @CharID AND Slot = @Slot -- HaT
     IF  (@ItemRefID BETWEEN '41817' AND '41819') 
       BEGIN
       IF (  @Operation =   '41') 
        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 = @ItemID_1
         END
          END
          
             
   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  
        return -1
     end  
   else if (@len_pos > 0 and @len_desc = 0)  
   begin  
        return -1
     end  
    else if (@len_pos = 0 and @len_desc > 0)  
   begin  
        return -1
     end  
   else if (@len_pos = 0 and @len_desc = 0)  
   begin  
        return -1
     end  
    -- أ€¯·أ، ¾أ†أ€أŒأ…أ› ±¸أ€أ”أ€أŒ¸é!  
   -- #define LOG_ITEMEVENT_BUY_CASHITEM  (BYTE)35  
   if (@Operation = 35)  
  begin  
        return -1
     end

**joesuef** · 22-05-2017, 03:27 AM

أدوات الموضوع
مشاهدة صفحة طباعة الموضوع أرسل هذا الموضوع إلى صديق
انواع عرض الموضوع
العرض العادي الانتقال إلى العرض المتطور الانتقال إلى العرض الشجري

المواضيع المتشابهه
الموضوع	كاتب الموضوع	المنتدى	الردود	آخر مشاركة
ازاى اجيب Reset state scroll	Hamada 156	قـسـم الاسـئـلـه و الاسـتـفـسـارات حـول الـلـعـبـة	3	16-07-2015 01:23 AM
Scroll To Remove pk/Blur AVatr/Reset skills.state/change name	che_9299	قسم الشروحات و البرامج المستخدمة في عمل السيرفرات الخاصة	3	19-05-2015 12:16 AM
Skill reset scroll	™XerK™	قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة	5	08-09-2014 08:51 PM

يتصفح الموضوع حالياً : 1 (0 عضو و 1 زائر)

	حفظ بياناتي ؟