Perfect Timed Job [Guild+Job]

[SL1MSH4DY]

Warning to all this breaks Forgotten World and Fortress War Dungeon. Everytime you try to go to these instances you get DC.

[sladlejrhfpq]

Warning to all this breaks Forgotten World and Fortress War Dungeon. Everytime you try to go to these instances you get DC.

I dont think it would cause anything like this, he just added this:

            if (@JobID = 1 or @JobID = 2)
            BEGIN
                return -1
            END
            ELSE 

to the original SP. It mean if the JobID=1 or 2, it won't add new line to the table _TimedJob. 1=Guild Penalty, 2=Job Penalty.

[SL1MSH4DY]

Then explain after running the original addtimedjob stored procedure it fixed the dc at FGW.
Posted via Mobile Device

[Caipi]

I dont think it would cause anything like this, he just added this:

            if (@JobID = 1 or @JobID = 2)
            BEGIN
                return -1
            END
            ELSE 

to the original SP. It mean if the JobID=1 or 2, it won't add new line to the table _TimedJob. 1=Guild Penalty, 2=Job Penalty.

FGW registers a penalty too - prolly it's the same ID but with different parameters - so theoretically to avoid those problems add more information to the IF clause which are specific for Guild and Job penalties

[SL1MSH4DY]

Ok guys listen up if you want to keep your 3 day guild penalty and remove the job penalty run this query. I did some testing and after running this the guild penalty is still there, but the job penalty is gone and Forgotten World is not broken. So FGW and Guild JobID must both = 1 and causes FGW to break when you try to run Jangan's query.

USE [SRO_VT_SHARD]
GO
/******By Jangan ******/
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

            --##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 = 2)
            BEGIN
                return -1
            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

[macihun93]

Nice, thanks :)

[SupremeSRO]

yes this broken the forgotten world :-/ any solution?

[nemo20122]

all query good but when any one leave guild jop get dc when open agine register normal and not wait 0min any one know how solve dc after leave

[Blackdiana]

Use eva tools from Chernobyl, this program make penalty delete... all penalty delete

[nemo20122]

can you upload it to me and how to used it thx

[na9er]

Use eva tools from Chernobyl, this program make penalty delete... all penalty delete

r u sure cuz i used Evangelion_1.0.5 and cant make penalty go.
is there any way to make no guild penalty without breaking FGW!

[na9er]

FGW registers a penalty too - prolly it's the same ID but with different parameters - so theoretically to avoid those problems add more information to the IF clause which are specific for Guild and Job penalties

+1 ya when i add @Category = 2 guild/job works with FGW

 if (@JobID = 1 and @Category = 2 or @JobID = 2)
            BEGIN
                return -1
            END
            ELSE
            BEGIN 

[nerobow012]

Hope Work Finally Found it thx ,, xS

[sonzenbi]

How to change time out job to 7 day like before ?