Clan war problem

[Bartjehh]

Hello,

I got a Clan server but i don't see the scores in CC ( Clan channel )
I can Clan war 2 vs 2 but sometimes ( Most of the times ) 2 of them turns out 999 ping and only 1 stays at
18 ping ( I got NAT so that ping is super! )
So i got 2 problems, Maybe someone could help (A)?
And yes MatchAgent is running!
Kind regards,

Bartjehh

[MentaL]

[X-Weaver]

ur database crashed...

[diosz]

look this

I have fixed mine.

dbo.spWinTheClanGame:

Find:

UPDATE Clan SET Losses=Losses+1, Point= game.fnGetMax(0, Point+(@LoserPoint)) WHERE CLID=@LoserCLID 

Replace to:

UPDATE Clan SET Losses=Losses+1, Point= dbo.fnGetMax(0, Point+(@LoserPoint)) WHERE CLID=@LoserCLID 

Reason: User Game does not exist, causing the game to crash.
Wizkid said change game.fnGetMax to game.GetMax, which made MatchServer find no function, causing MatchServer to crash.

[Bartjehh]

Omg, i don't got the dbo.spWinTheClanGame

[diosz]

Since there are a lot of people that have the problem, I'll post a tut. This fix solves the MatchServer crash after the clanwar finished. Feel free to flame, but be sure you don't cry after I flamed you back. Note that this is a noob-friendly tutorial with pictures.

1) Start MSSQL Studio Express. If you do not know how, please suicide now before it's too late.
2) Navigate to your GunzDB, select Programmability, then select Stored Procedures.

3) Scroll down to the stored procedure called spWinTheClanGame. Rightclick it, then select Modify.

4) Find

UPDATE Clan SET Losses=Losses+1, Point= game.fnGetMax(0, Point+(@LoserPoint)) WHERE CLID=@LoserCLID 

and change game.fnGetMax to dbo.fnGetmax. So after the edit it will look like

UPDATE Clan SET Losses=Losses+1, Point= dbo.fnGetMax(0, Point+(@LoserPoint)) WHERE CLID=@LoserCLID 

5) Hit Execute.
6) Thank me for sharing this.

is easy no ?

P.D. I edit the original quote =P and edit the problem
4) Find [/B]

UPDATE Clan SET Losses=Losses+1, Point= game.fnGetMax(0, Point+(@LoserPoint)) WHERE CLID=@LoserCLID 

and change game.fnGetMax to dbo.fnGetmax. So after the edit it will look like

UPDATE Clan SET Losses=Losses+1, Point= dbo.fnGetMax(0, Point+(@LoserPoint)) WHERE CLID=@LoserCLID 

[00niels00]

Than is your database fked up.