Help error match server

[riku83]

Hi all :)

I have a runtime error when i try to launch match server (i use the 1.5 files) here is the log :

Load XML from memory : strings.xml(0x0037) - SUCCESS
Load XML from memory : cserror.xml(0x0037) - SUCCESS
[09/29/12 10:44:34] DBMS connected


[09/29/12 10:44:34] MMatchDBMgr::ExceptionHandler
ErrSQL( {CALL spUpdateServerInfo (1000, 'Gunz de la Hess', 1)} ), ErrCode( -1 )
ErrMsg - Procédure stockée 'spUpdateServerInfo' introuvable.
State:37000,Native:2812,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]

[09/29/12 10:44:34] Command registeration completed


[09/29/12 10:44:34] MMatchDBMgr::ExceptionHandler
ErrSQL( {CALL spGetGambleItemList} ), ErrCode( -1 )
ErrMsg - Procédure stockée 'spGetGambleItemList' introuvable.
State:37000,Native:2812,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]

init gamble machine fail.

[09/29/12 10:44:35] MMatchDBMgr::ExceptionHandler
ErrSQL( {CALL spGetSurvivalGroupRanking} ), ErrCode( -1 )
ErrMsg - Procédure stockée 'spGetSurvivalGroupRanking' introuvable.
State:37000,Native:2812,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]

can someone help me ?

And also the link for download the runnable is dead.. can someone reupload it ?

Thank you and sorry for my bad english :)

[MentaL]

[Gunblade]

It seems like you are using an incorrect Database.
DB's.rar (1.5, RE-Uploaded by Z1ls)

[riku83]

Thank you for your answer

I did It with this one but same problem :/

[Gunblade]

Thank you for your answer

I did It with this one but same problem :/

Oh, hm... Where did you get your matchserver from? Did you compile it yourself from the source?
If you haven't build the matchserver yourself, do it, its way better and if you don't understand how, PM and I'll provide some help :)

[riku83]

I understand thank you.

did I have to use visual studio ? or can I use things like codeblocks ? ^^

[Gunblade]

I understand thank you.

did I have to use visual studio ? or can I use things like codeblocks ? ^^

Visual Studio 2003 is the easiest to use with the GunZ source.
If you are experienced with programming, You can port the source to 2010

[riku83]

Okay i will try thanx

[Vusion]

It seems like you are using an incorrect Database.
DB's.rar (1.5, RE-Uploaded by Z1ls)

Emisand's db was missing few Gamble Items-related Stored Procedures which caused them not to work, but you can get those easily from the Database directory within the stable branch.

[riku83]

I try to start the matchserver that I have compiled but same problem ...

[qqq1]

USE [GunzDB]
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
--ALTER PROC [dbo].[spChangeGambleItemToRewardNormalItem]  
CREATE PROC dbo.spChangeGambleItemToRewardNormalItem  
      @CID                INT
    , @CIID                INT
    , @GIID                INT
    , @GRIID            INT
    , @RewardItemID        INT
    , @RewardRentPeriod    INT


AS BEGIN

    SET NOCOUNT ON;

    DECLARE @RentHourPeriod        INT;
    DECLARE @GambleItemCount    INT;
    
    -----------------------------------------------------------------------------
            
    SELECT    @RentHourPeriod = ISNULL(RentHourPeriod, 0)
    FROM    GambleRewardItem gri(NOLOCK)  
    WHERE    GRIID = @GRIID
    AND        GIID = @GIID 
    AND        (ItemIDMale = @RewardItemID OR ItemIDFemale = @RewardItemID)
    
    IF (0 = @@ROWCOUNT) BEGIN
        SELECT -1 AS 'Ret'  
        RETURN
    END
            
    SELECT    @GambleItemCount = ISNULL(Cnt, 1)
    FROM    CharacterItem(NOLOCK)
    WHERE    CIID = @CIID;
        
    -----------------------------------------------------------------------------
    
    DECLARE @NowDate    DATETIME;
    SET @NowDate = GETDATE();    
    
    -----------------------------------------------------------------------------
            
    BEGIN TRAN -----------  
    
        ----------------------------------------------------------------------------------------
        
        IF( @GambleItemCount > 1 ) BEGIN
        
            UPDATE    CharacterItem 
            SET        Cnt = Cnt - 1
            WHERE    CID = @CID 
            AND        CIID = @CIID 
            
            IF (0 <> @@ERROR) OR (0 = @@ROWCOUNT) BEGIN  
                ROLLBACK TRAN  
                SELECT -2 AS 'Ret'  
                RETURN
            END
            
        END
        ELSE BEGIN
        
            UPDATE    CharacterItem 
            SET        CID = NULL
            WHERE    CID = @CID 
            AND        CIID = @CIID
            
            IF (0 <> @@ERROR) OR (0 = @@ROWCOUNT) BEGIN  
                ROLLBACK TRAN  
                SELECT -3 AS 'Ret'  
                RETURN
            END
            
        END
        
        ---------------------------------------------------------------------------------------    
        
        INSERT CharacterItem(CID, ItemID, RegDate, RentDate, RentHourPeriod, Cnt)
        VALUES (@CID, @RewardItemID, @NowDate, @NowDate, @RentHourPeriod, 1)
        
        DECLARE @OrderCIID INT;            
        SET @OrderCIID = @@IDENTITY;
            
        IF (0 <> @@ERROR) BEGIN  
            ROLLBACK TRAN  
            SELECT -4 AS 'Ret'  
            RETURN
        END
            
            
        INSERT dbo.ItemChangeLog_CharacterItem(ChangeType, ChangeDate, CID, CIID, ItemID, [Count])
        VALUES (202, @NowDate, @CID, @CIID, @GIID, 1);    
        
        IF (0 <> @@ERROR) BEGIN  
            ROLLBACK TRAN  
            SELECT -5 AS 'Ret'  
            RETURN
        END

        INSERT dbo.ItemChangeLog_CharacterItem(ChangeType, ChangeDate, CID, CIID, ItemID, [Count])
        VALUES (102, @NowDate, @CID, @OrderCIID, @RewardItemID, 1);
        
        IF (0 <> @@ERROR) BEGIN  
            ROLLBACK TRAN  
            SELECT -6 AS 'Ret'  
            RETURN
        END

        INSERT INTO LogDB..GambleLog(CID, GIID, RewardItemID, RegDate)  
        VALUES (@CID, @GIID, @RewardItemID, @NowDate);
        
        IF (0 <> @@ERROR) BEGIN  
            ROLLBACK TRAN  
            SELECT -7 AS 'Ret'  
            RETURN
        END
        
        ----------------------------------------------------------------------------------------

    COMMIT TRAN  -----------
        
    SELECT 0 AS 'Ret', @OrderCIID AS 'ORDERCIID'
END 

IS THIS?;
Posted by Cerealnp

[riku83]

It not works :/