Change Job wait Time

01/04/2013 18:09 G2K91#1

Hello
I�m trying to change the Job wait Time..
Normally you have to wait 7 days I would like to change it at 1sec. in which shard table it needs to be changed?
can someone help me?

Thank you

01/04/2013 18:31 PenguinSRO#2

Stored Procedure TimedJob

01/04/2013 19:44 G2K91#3

Okay thank you, but how can i change it for all chars?

01/05/2013 01:04 IceAmStiel#4

Reducing the time isn't going to work, even if you change the timestamp in the procedure - the client holds the actual timestamp of +7 days and updates it regularily.
Either you're going to delete the record out of the table after the creation (not to trigger a disconnect) or you're going to provide a homepage form to reduce the penalty by a certain amount of seconds - or you're telling them to relog after the leaving of their job to lower the penalty properly.

01/05/2013 11:33 G2K91#5

Thank you. I have edit the Stored Procedure AddTimedJob. It works, but players must Teleport after leaving the Job

01/06/2013 23:43 PenguinSRO#6

You can't do it without player need to teleport

06/23/2017 19:06 sonzenbi#7

Hello
So,how to change the Job Wait Time -> 7 day
i'm tried this qr but not working

Quote:

USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_AddTimedJob] Script Date: 6/23/2017 10:11:59 PM ******/
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
return @NewJobID

The problem has been resolved
if (@TimeToKeep <= 0)
^.^