Clan Bug

[-Phoenix-]

hello i restarted my clanserver now all scores are 0-0 why thyre gone

[MentaL]

[Phoenix]

I'm not going to ask you to make the edit and push it further. I don't think you can. Execute this query in your database.

USE [GunZDB]
GO
/****** Object:  StoredProcedure [dbo].[spWinTheClanGame]    Script Date: 05/20/2009 20:20:48 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

-- 클랜전 결과 업데이트  
ALTER  PROC [dbo].[spWinTheClanGame]  
 @WinnerCLID  int,  
 @LoserCLID  int,  
 @IsDrawGame  tinyint,  
 @WinnerPoint  int,  
 @LoserPoint  int,  
 @WinnerClanName  varchar(24),  
 @LoserClanName  varchar(24),  
 @RoundWins  tinyint,  
 @RoundLosses  tinyint,  
 @MapID   tinyint,  
 @GameType  tinyint,  
 @WinnerMembers  varchar(110),  
 @LoserMembers  varchar(110)  
AS  
 SET NOCOUNT ON -- 추가.  
  
 IF @IsDrawGame = 0  
 BEGIN  
  BEGIN TRAN  
  -- 이긴팀 Wins+1  
  UPDATE Clan SET Wins=Wins+1, Point=Point+@WinnerPoint, TotalPoint=TotalPoint+@WinnerPoint WHERE CLID=@WinnerCLID  
  IF 0 = @@ROWCOUNT BEGIN -- 여기 추가.  
   ROLLBACK TRAN  
   RETURN  
  END  
  
  -- 진팀 Losses+1  
  UPDATE Clan SET Losses=Losses+1, Point= dbo.fnGetMax(0, Point+(@LoserPoint)) WHERE CLID=@LoserCLID  
  IF 0 = @@ROWCOUNT BEGIN -- 여기 추가.  
   ROLLBACK TRAN  
   RETURN  
  END  
--  UPDATE Clan SET Point=0 WHERE CLID=@LoserCLID AND Point<0  
  
  -- 전적 로그를 남긴다.  
  INSERT INTO ClanGameLog(WinnerCLID, LoserCLID, WinnerClanName, LoserClanName, RoundWins, RoundLosses, MapID, GameType, RegDate, WinnerMembers, LoserMembers, WinnerPoint, LoserPoint)  
  VALUES (@WinnerCLID, @LoserCLID, @WinnerClanName, @LoserClanName, @RoundWins, @RoundLosses, @MapID, @GameType, GETDATE(), @WinnerMembers, @LoserMembers, @WinnerPoint, @LoserPoint)  
  IF 0 <> @@ERROR BEGIN -- 여기 추가.  
   ROLLBACK TRAN  
   RETURN  
  END  
  COMMIT TRAN  
 END  
 ELSE  
 BEGIN  
  UPDATE Clan SET Draws=Draws+1 WHERE CLID=@WinnerCLID OR CLID=@LoserCLID  
 END

Credits to Wizkid & Goldoracko. This is from the DB Fix pack.

[-Phoenix-]

do i need to delete from the editor at the table all or jsut where i need to start O.O AND IN WICH TABLE ?!

[Phoenix]

I didn't ask you to delete or mess with any table. Go to MSSQL > Look around on top > Click on New Query or something like that > Paste the above code > Execute.

I'm sure it's not too hard. This is the exact fix to the problem. Click the thanks button after you do it :)

[-Phoenix-]

fixed :P thanks :D btw how i can enable the rank at the ingame theres not enable my ranking

[Phoenix]

Ranking takes time to update. Like a day or so. Be patient.
Posted via Mobile Device