Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Problem on ' forgotten world '

Joined
Aug 18, 2012
Messages
511
Reaction score
174
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
 

mag

Initiate Mage
Joined
Apr 3, 2013
Messages
47
Reaction score
0
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
 
Upvote 0
Back
Top