Clan Server

**WooAf** · 06-12-08

Hello, I got problem with my clan war server,
when a clan war is finished, the matchserver crash.

Code:

nhn server mode is real
Load XML from memory : strings.xml(0x0037) - SUCCESS
Load XML from memory : cserror.xml(0x0037) - SUCCESS
[12/06/08 14:22:03] DBMS connected
[12/06/08 14:22:03] Command registeration completed

10
MBMatchServer::AddClanServerSwitchDownSchedule - make close clan mode schedule success. next close clan mode time is 8-12-31 23:50

10
Inited client file list (1)
success init security.
FILE PATH : D:\NicK\Gunz\MatchServer\MD5HashValue.txt
MD5 Hash Value => 6e ff 40 c1 22 1e 4b 2b 33 ce 22 41 7d c4 3a 3d 

================================== Server configure info ==================================
[12/06/08 14:22:03] Release Date : Jun 13 2007
[12/06/08 14:22:03] X-Trap Off
[12/06/08 14:22:03] MD5 Check Off
[12/06/08 14:22:03] Server Country : BRAZIL
[12/06/08 14:22:03] Command version : (56)
[12/06/08 14:22:03] Event usable state : (false)
[12/06/08 14:22:03] Load event size : (1)
[12/06/08 14:22:03] FileCRCCheckSum usable state : (false)
[12/06/08 14:22:03] FileCRC size : (1)
[12/06/08 14:22:03] Country Code Filter usalbe state : (false)
[12/06/08 14:22:03] Accept Invalied IP state : (true)
[12/06/08 14:22:03] Keeper IP : (67.212.70.178)
[12/06/08 14:22:03] Monitor IP : (67.212.70.178)
===========================================================================================

[12/06/08 14:22:03] Match Server Created (Port:6000)
success to update CustomIP
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

DB Query(GetClanInfo) Failed
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

DB Query(GetClanInfo) Failed
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

DB Query(GetClanInfo) Failed
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::WinTheClanGame - Cannot find either column "game" or the user-defined function or aggregate "game.fnGetMax", or the name is ambiguous.
Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1.

[14:26:13] Async DB Query(OnAsyncWinTheClanGame) Failed
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::CreateCharacter - Timeout expired

MMatchDBMgr::CreateCharacter - Timeout expired

This error:
MMatchDBMgr::WinTheClanGame - Cannot find either column "game" or the user-defined function or aggregate "game.fnGetMax", or the name is ambiguous.
Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1.

[14:26:13] Async DB Query(OnAsyncWinTheClanGame) Failed

Help me please

**MentaL**

**WooAf** · 06-12-08

Sorry for bad section.

**Solaire** · 06-12-08

WinTheClanGame.

Do I need to draw a picture of it or what? I told you around 20 times to have a look at the stored procedure. Do it and stop posting the same question over and over again.

/Lock requested.

**WooAf** · 06-12-08

I want help, I dont no how to fix that, if you say to look to the procedure, maybe I dont know how...

If I post the same thing its because its not resolved dude.

**Solaire** · 06-12-08

Originally Posted by WooAf

I want help, I dont no how to fix that, if you say to look to the procedure, maybe I dont know how...

If I post the same thing its because its not resolved dude.

Bump your old topic? What an idea, right?

If you don't know how to look into a stored procedure of MSSQL then that's the second proof you recompiled RoboGuard.

**WooAf** · 07-12-08

Originally Posted by Wizkidje

Bump your old topic? What an idea, right?

If you don't know how to look into a stored procedure of MSSQL then that's the second proof you recompiled RoboGuard.

Sure, why you dont stfu ?
I need help,
and I dont need to kow how to look into a stored procedure of MSSQL to know C# or C++

**Aimed** · 07-12-08

Originally Posted by WooAf

Sure, why you dont stfu ?
I need help,
and I dont need to kow how to look into a stored procedure of MSSQL to know C# or C++

Why don't you start on posting in correct forum, maybe then people will start helping you.

I realy don't get it. It seems people are blind OR stupid.. Cause I didn't learn the diffrence between "release" and "help" in school ya know, Isn't it clear enough?..

**WooAf** · 07-12-08

Look this reply :

Originally Posted by WooAf

Sorry for bad section.

**Joe9099** · 07-12-08

Originally Posted by WooAf

Look this reply :

Get your leeched dirty ass off this forum, You did NOT make that shit you posted about, You obviously dont know what the hell your doing..

So instead of telling others to stfu, why dont you? okthnxbai

**jaylord55** · 07-12-08

re apply the damn database its that simple

**Aimed** · 07-12-08

Originally Posted by jaylord55

re apply the damn database its that simple

Lawl.. 1 post and even he knows better xD

**CrashPoint** · 07-12-08

Originally Posted by WooAf

Sure, why you dont stfu ?
I need help,
and I dont need to kow how to look into a stored procedure of MSSQL to know C# or C++

Wrong section => Dont keep postin here = STFU Blind Chick

**Solaire** · 07-12-08

Originally Posted by jaylord55

re apply the damn database its that simple

Not even needed, you can edit it and hit save.

Originally Posted by WooAf

Sure, why you dont stfu ?
I need help,
and I dont need to kow how to look into a stored procedure of MSSQL to know C# or C++

Because I'm right, as always. And my dear boy, both C# and C++ comes with MSSQL support. So if you know C#, you know MSSQL.

**WooAf** · 07-12-08

Originally Posted by Wizkidje

Not even needed, you can edit it and hit save.

Because I'm right, as always. And my dear boy, both C# and C++ comes with MSSQL support. So if you know C#, you know MSSQL.

Nop, I can make a AntiHack in C# but no needed a db..

**Solaire** · 07-12-08

Originally Posted by WooAf

Nop, I can make a AntiHack in C# but no needed a db..

C# comes with ODBC and MSSQL. I know C# as well and I was teached MSSQL with it, although I already knew it.

**WooAf** · 08-12-08

Originally Posted by Wizkidje

C# comes with ODBC and MSSQL. I know C# as well and I was teached MSSQL with it, although I already knew it.

Look, I code a AntiCheat with C# and I dont need to know odbc or mssql for make it.

**ThievingSix** · 08-12-08

Ewww .net =(

/lol XD

**WooAf** · 08-12-08

Nop. C#

**WooAf** · 08-12-08

I know how to look the procedure, but what is the good procedure and what is the procedure name for clan war server?

**Linear88** · 08-12-08

Stop comparing yourself to others...

Enough of the flaming.

Databases > GunzDB > Programmability > Stored Procedures > dbo.spWinTheClanGame

**Solaire** · 08-12-08

Originally Posted by ThievingSix

Ewww .net =(

/lol XD

.NET is the future.

Originally Posted by WooAf

Nop. C#

That is .NET. Version 3.5.

Originally Posted by Linear88

Stop comparing yourself to others...

Enough of the flaming.

Databases > GunzDB > Programmability > Stored Procedures > dbo.spWinTheClanGame

Too bad. I wanted to see him angry.

**WooAf** · 08-12-08

Code:

USE [GunzDB]
GO
/****** Object:  StoredProcedure [dbo].[spWinTheClanGame]    Script Date: 12/08/2008 13:14:03 ******/
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= game.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

This is my dbo.spWinTheClanGame,
what is the error on it?

**Rotana** · 08-12-08

You got an complet wrong database, You are also missing the LogDB,

Look:

Code:

DB Query(GetClanInfo) Failed

This means the server can not get you clan info, You probelly got the wrong DB or made the clan yourself in the DB

Update CLOSED due the amount of off-topic reply's

Clan Server

Thread Tools

Search Thread

Clan Server

Re: Clan Server

Re: Clan Server

Re: Clan Server

Re: Clan Server

Re: Clan Server

Re: Clan Server

Re: Clan Server

Re: Clan Server

Re: Clan Server

Re: Clan Server

Re: Clan Server

Re: Clan Server

Re: Clan Server

Re: Clan Server

Re: Clan Server

Re: Clan Server

Re: Clan Server

Re: Clan Server

Re: Clan Server

Re: Clan Server

Re: Clan Server

Re: Clan Server

Advertisement