[Source] MatchServer Crashing

[Military]

[07/12/12 17:46:49]  MMatchDBMgr::ExceptionHandler
ErrSQL( {CALL spUpdateServerStatus_Netmarble (0, 0, 1)} ), ErrCode( -1 )
ErrMsg - Could not find stored procedure 'spUpdateServerStatus_Netmarble'.
State:37000,Native:2812,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]

Anyone has that stored procedure??

[MentaL]

[CobraBite]

USE GunzDB
GO

CREATE PROCEDURE dbo.spUpdateServerStatus_Netmarble
@CurrPlayer SMALLINT,
@NatePlayer SMALLINT,
@ServerID INT
AS BEGIN

UPDATE ServerStatus
Set CurrPlayer = @CurrPlayer, NatePlayer = @NatePlayer, Time=GETDATE()
WHERE ServerID=@ServerID

END

Edit: Sorry pressed reply button by mistake.
Next time check your DATABASE folder from the source :), There are lot of sql scripts there.

[Chrisss]

build in Release

[Vusion]

build in Release

Go away.

Edit: Sorry pressed reply button by mistake.
Next time check your DATABASE folder from the source :), There are lot of sql scripts there.

Actually, you ought not to use that one; you should just change the call for netmarble's spUpdateServerStatus to the normal one.
You'll know why later on.

[Military]

Fixed , thanks to Vusion.