|
You last visited: Today at 04:45
Advertisement
Change Job wait Time
Discussion on Change Job wait Time within the SRO Private Server forum part of the Silkroad Online category.
01/04/2013, 18:09
|
#1
|
elite*gold: 0
Join Date: Dec 2012
Posts: 77
Received Thanks: 11
|
Change Job wait Time
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
|
#2
|
elite*gold: 0
Join Date: Dec 2012
Posts: 62
Received Thanks: 60
|
Stored Procedure TimedJob
|
|
|
01/04/2013, 19:44
|
#3
|
elite*gold: 0
Join Date: Dec 2012
Posts: 77
Received Thanks: 11
|
Okay thank you, but how can i change it for all chars?
|
|
|
01/05/2013, 01:04
|
#4
|
elite*gold: 0
Join Date: Jul 2011
Posts: 1,058
Received Thanks: 1,118
|
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
|
#5
|
elite*gold: 0
Join Date: Dec 2012
Posts: 77
Received Thanks: 11
|
Thank you. I have edit the Stored Procedure AddTimedJob. It works, but players must Teleport after leaving the Job
|
|
|
01/06/2013, 23:43
|
#6
|
elite*gold: 0
Join Date: Dec 2012
Posts: 62
Received Thanks: 60
|
You can't do it without player need to teleport
|
|
|
06/23/2017, 19:06
|
#7
|
elite*gold: 0
Join Date: Feb 2017
Posts: 186
Received Thanks: 117
|
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)
^.^
|
|
|
|
Similar Threads
|
guild wait time
11/20/2011 - Metin2 Private Server - 4 Replies
How to adjust guild thing so that I don't need to wait to create a new one or join a new one .. etc?
I tried removing this but I get "Code0125" when trying to make a new guild after closing one..
if game.get_event_flag("guild_withdraw_delay&quo t;)*86400 >
get_global_time() - pc.getqf("new_withdraw_time") then
say(string.format("You cannot create a guild yet, please wait a while.", game.get_event_flag("guild_withdraw_delay&quo t;)))
|
question - guild wait time
10/20/2010 - Metin2 Private Server - 1 Replies
How to remove the time to join another guild? or create one ..etc?
|
[Release] Box wait time ...
05/21/2010 - Kal Online - 63 Replies
Hi @ all
once again Im bored...
now I show you guys how to get the productionbar away while opening a box.
1. Open your UCE
2. Attach exe
3. Start game , and stay in town or what ever
4. Go memory browser and press CTRL + F then type in productionbar
5. rightclick on the value and press copy to clipboard :
http://img441.imageshack.us/img441/5112/someeum2. th.jpg
|
Syntax tut about no wait time
12/27/2009 - Kal Online - 12 Replies
Hello guys i got a problem, idk if this tut too old or something but i cant see images attached: http://www.elitepvpers.com/forum/kal-online/109110- release-box-wait-time.html
even more at step 4: "4. Go memory browser and press CTRL + F then type in productionbar" lol..what to type in the productionbar? :D
and a question...anyone got an CE that works on pservers (gbl) and got working memory browser?
|
no tali wait time....need help
09/12/2008 - Kal Online - 15 Replies
ehm i did read guide in ''read before ask'' topic and did as said but it says change ''jn'' to ''jmp''....but there i always get ''jo'' :S could any1 help me with how the hell i change waiting time on talis? :S
btw: if i change jo to jmp it doesnt work either.....:S
edit: answear plz any1 omg.....
|
All times are GMT +2. The time now is 04:45.
|
|