Abbygamerz missing procedures

Results 1 to 6 of 6
  1. #1
    Developer Eronisch is offline
    MemberRank
    Jul 2009 Join Date
    The NetherlandsLocation
    1,328Posts

    Abbygamerz missing procedures

    I'm not able to run the matchserver because of two missing procedures:

    [12/17/15 18:58:52] MMatchDBMgr::ExceptionHandler
    ErrSQL( {CALL SP_Get_WarriorClass ()} ), ErrCode( -1 )
    ErrMsg - Procedure SP_Get_WarriorClass has no parameters and arguments were supplied.
    State:37000,Native:8146,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]

    [12/17/15 18:58:52] MMatchDBMgr::ExceptionHandler
    ErrSQL( {CALL SP_Get_Skills_Race ()} ), ErrCode( -1 )
    ErrMsg - Procedure SP_Get_Skills_Race has no parameters and arguments were supplied.
    State:37000,Native:8146,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
    Does anyone have these two and would like to share them?


  2. #2
    Member Adam200214 is offline
    MemberRank
    Jun 2014 Join Date
    59Posts

    Re: Abbygamerz missing procedures

    Have fun
    Code:
    USE [GunzDB]
    GO
    /****** Object: StoredProcedure [dbo].[SP_Get_Skills_Race] Script Date: 02/12/2015 15:13:08 ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    
    
    ALTER PROC [dbo].[SP_Get_Skills_Race]
    @RaceId    int
    , @SkillId    int
    , @CoolDownTime int
    , @Speed    int
    , @HP    int
    , @AP    int
    AS
    SET NOCOUNT ON
    UPDATE RaceCustomZombie WITH (rowlock)
    SET RaceId=@RaceId, SkillId @SkillId, CooldownTime @CoolDownTime, Speed @Speed, HP=@HP, AP=@AP

  3. #3
    Member spaike23 is offline
    MemberRank
    Nov 2009 Join Date
    LeagueOfLegendsLocation
    52Posts

    Re: Abbygamerz missing procedures

    [12/20/15 22:37:42] NO SE CARGO LA SKILL RACE LIST

    [12/20/15 22:37:42] MMatchDBMgr::ExceptionHandler
    ErrSQL( {CALL SP_Get_WarriorClass ()} ), ErrCode( -1 )
    ErrMsg - Procedure SP_Get_WarriorClass has no parameters and arguments were supplied.
    State:37000,Native:8146,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
    fix it?

  4. #4
    TBF Guru jetman82 is offline
    MemberRank
    Jan 2009 Join Date
    631Posts

    Re: Abbygamerz missing procedures

    Not to be rude, but the source contains all the information necessary to recreate any missing procedures, just check mmatchdbmgr and see what the arguments are. :)

  5. #5
    Member spaike23 is offline
    MemberRank
    Nov 2009 Join Date
    LeagueOfLegendsLocation
    52Posts

    Re: Abbygamerz missing procedures

    done.

  6. #6
    Developer Eronisch is offline
    MemberRank
    Jul 2009 Join Date
    The NetherlandsLocation
    1,328Posts

    Re: Abbygamerz missing procedures

    Using native odbc drivers fixed the problem.



Advertisement