Clan war problem

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

ur database crashed...

look this

Quote:

---

Originally Posted by Linear88

I have fixed mine.

dbo.spWinTheClanGame:

Find:

PHP Code:

---

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


---

Replace to:

PHP Code:

---

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.

---

Omg, i don't got the dbo.spWinTheClanGame

Quote:

---

Originally Posted by Wizkidje

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.
http://i35.tinypic.com/2wn4h7r.jpg
3) Scroll down to the stored procedure called spWinTheClanGame. Rightclick it, then select Modify.
http://i34.tinypic.com/161z0jl.jpg
4) Find

PHP Code:

---

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

PHP Code:

---

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


---

5) Hit Execute. http://i34.tinypic.com/1zb85rk.jpg
6) Thank me for sharing this.

---

is easy no ?

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

PHP Code:

---

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

PHP Code:

---

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


---

Than is your database fked up.