بخصوص Adv Remover

[Mostafa Shaaban]

دلوقتي انا ضفت اسكرول بيشيل الادفنس وتمام و بينزل عادي وكل حاجه بس لما بضربه مش بيشيل حاجه
حتي لو رجعت التون او عملت ريسترت للاكونت ودا El TimedJop_
بتاعه

كود PHP:

if(@JobID= '33854') -- Remover ADV Ticket added by krmfrnc
        begin 
            DELETE FROM  _BindingOptionWithItem where nItemDBID IN (SELECT ItemID FROM _Inventory WHERE Slot BETWEEN 0 AND 12 AND CharID=@CharID) and bOptType=2
            return -3 
        end 


[Mr Z!dane]

33854 الرقم ده بتاع اية ؟؟
RefSkill ولا انت مغير فيه حاجا ؟؟

[Dangers SrO]

انتا دفتها في
l TimedJop

[Dangers SrO]

اتاكد منها في Refskill
same code

[Mostafa Shaaban]

Yes 33854 This Form RefSkill
وانا ضفتها Times Jop

[Hamza FiGo]

اول حاجة من كلامك انك ضايفها غلط اقولك لية

لان انت لما تستخدم الاسكرول لازم يجيلك DC علشان return -3

لو مجالكش DC يبقي الــ ID مختلف تماما

[Mostafa Shaaban]

دا ال Timed jop بتاعي ممكن تتاكد

USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_AddTimedJob] Script Date: 24/02/2015 10:44:55 ص ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


ALTER procedure [dbo].[_AddTimedJob]
@CharID int,
@Category tinyint,
@JobID int,
@TimeToKeep int,
@Data1 int,
@Data2 int,
--##begin due to develop composite item
@Data3 int,
@Data4 int,
@Data5 int,
@Data6 int,
@Data7 int,
@Data8 int,
@Serial64 bigint,
@JID int
--##end due to develop composite item
as
if (not exists (select CharID from _Char with (nolock) where CharID = @CharID))
return -1
if (@TimeToKeep <= 0)
return -2
declare @NewJobID int
set @NewJobID = 0
--##begin due to develop composite item
insert into _TimedJob(CharID,Category,JobID,TimeToKeep,Data1,D ata2,Data3,Data4,Data5,Data6,Data7,Data8,Serial64, JID)
values(@CharID, @Category, @JobID, @TimeToKeep, @Data1, @Data2, @Data3, @Data4, @Data5, @Data6, @Data7, @Data8, @Serial64, @JID)
--##end due to develop composite item
set @NewJobID = @@identity
if (@@error <> 0 or @@rowcount = 0)
return -3

if @Category=2 and @JobID=2
begin
delete from _TimedJob where ID=@NewJobID
end
return @NewJobID
if(@JobID= '33853') ---Remove Maximum By Che---
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 CharID = @CharID and Slot between 0 and 12 and ItemID Between 1 AND 99999)
end
---------designed by krmfrnc--------------
if(@JobID= '33854') -- Remover ADV Ticket added by krmfrnc
begin
DELETE FROM _BindingOptionWithItem where nItemDBID IN (SELECT ItemID FROM _Inventory WHERE Slot BETWEEN 0 AND 12 AND CharID=@CharID) and bOptType=2
return -3
end
---------designed by krmfrnc--------------

[Hamza FiGo]

زي منا قولتلك حضرتك ضايفها غلط

اتفضل يا باشا

USE [SRO_VT_SHARD]
GO
/****** Object:  StoredProcedure [dbo].[_AddTimedJob]    Script Date: 24/02/2015 01:17:11 م ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER   procedure [dbo].[_AddTimedJob]
@CharID            int,
@Category        tinyint,
@JobID            int,
@TimeToKeep    int,
@Data1            int,
@Data2            int,
--##begin due to develop composite item
@Data3            int,
@Data4            int,
@Data5            int,
@Data6            int,
@Data7            int,
@Data8            int,
@Serial64        bigint,
@JID            int
--##end due to develop composite item
as
        
if(@JobID= '33853') ---Remove Maximum By Che---
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 CharID = @CharID and Slot between 0 and 12 and ItemID Between 1 AND 99999)
end
---------designed by krmfrnc--------------
if(@JobID= '33854') -- Remover ADV Ticket added by krmfrnc
begin
DELETE FROM _BindingOptionWithItem where nItemDBID IN (SELECT ItemID FROM _Inventory WHERE Slot BETWEEN 0 AND 12 AND CharID=@CharID) and bOptType=2
return -3
end
	if (not exists (select CharID from _Char with (nolock) where CharID = @CharID))
                return -1
            if (@TimeToKeep <= 0)
                return -2
            declare @NewJobID int
            set @NewJobID = 0
            --##JobID 1 = Guild // JobID 2 = Thief/Hunter/Trader
            --##If you want to only have one not both, then just modify the line below!
            --if (@JobID = 1 and @Category = 2 and @Serial64=0) or (@JobID = 2 and @Category = 2 and @Serial64=0)  --For Guild and CharJob            
     if (@JobID = 1 and @Category = 2 and @Serial64=0)   --Only for Guild
            BEGIN
            set @CharID = 0            
            insert into _TimedJob(CharID,Category,JobID,TimeToKeep,Data1,Data2,Data3,Data4,Data5,Data6,Data7,Data8,Serial64,JID)
            values(@CharID, @Category, @JobID, @TimeToKeep, @Data1, @Data2, @Data3, @Data4, @Data5, @Data6, @Data7, @Data8, @Serial64, @JID)
            
            END
            ELSE
            BEGIN
            --##begin due to develop composite item
            insert into _TimedJob(CharID,Category,JobID,TimeToKeep,Data1,Data2,Data3,Data4,Data5,Data6,Data7,Data8,Serial64,JID)
            values(@CharID, @Category, @JobID, @TimeToKeep, @Data1, @Data2, @Data3, @Data4, @Data5, @Data6, @Data7, @Data8, @Serial64, @JID)
            END
            --##end due to develop composite item
            set @NewJobID = @@identity
            if (@@error <> 0 or @@rowcount = 0)
                
                return -3
     return @NewJobID  
--????

[Hamza FiGo]

تمام يغلق

##