-
SilkRoad vSro Service
Problem on ' forgotten world '
When i tried open Hole Gate ' Forgotten world gate ' to inter
when i inter i get DC and got this fatal on game server
##COpenMarketMgr::AsyncQueryFailed 2676## Requester is offline. [CharID: 11303]
Any idea about how to fix and active forgotten world !
my forgotten world 101~120
-
-
SilkRoad vSro Service
Re: Problem on ' forgotten world '
-
Newbie
Re: Problem on ' forgotten world '
UP
I have that same problem
-
Member
Re: Problem on ' forgotten world '
USE [SRO_VT_SHARD]
GO
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 = 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
-
Re: Problem on ' forgotten world '
@mag, might want to start using [code] tag's so it doesn't mass tag members on the forum and mess up the code