Problem on ' forgotten world '

Results 1 to 5 of 5
  1. #1
    SilkRoad vSro Service MaDenGo is offline
    Grand MasterRank
    Aug 2012 Join Date
    vSro CommunityLocation
    512Posts

    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


  2. #2
    SilkRoad vSro Service MaDenGo is offline
    Grand MasterRank
    Aug 2012 Join Date
    vSro CommunityLocation
    512Posts

    Re: Problem on ' forgotten world '

    up :)

  3. #3
    Newbie fatihusta is offline
    MemberRank
    Nov 2015 Join Date
    1Posts

    Re: Problem on ' forgotten world '

    UP

    I have that same problem

  4. #4
    Member mag is offline
    MemberRank
    Apr 2013 Join Date
    47Posts

    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

  5. #5
    Moderator Blacksheep25 is offline
    ModeratorRank
    Jan 2009 Join Date
    715Posts

    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



Advertisement