[Pro's only...] Matchserver Crashing

Joe9099 · Jul 8, 2010

Right this is the most annoying crap ever now, but i have had some matchserver problems, always crashing every couple hours maybe.

I only want you guys that know what your talking about to reply below, so if you dont know what the duck is going on then dont reply.

I have a couple logs below which show the crash "Kinda" but i have no idea how to read these logs and find the cause of the crash.

Code:

nhn server mode is real
Load XML from memory : strings.xml(0x0037) - SUCCESS
Load XML from memory : cserror.xml(0x0037) - SUCCESS
[07/06/10 19:27:32] DBMS connected
[07/06/10 19:27:32] Command registeration completed

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

10
Inited client file list (1)
success init security.
FILE PATH : C:\Documents and Settings\Administrator\Desktop\EVILGUNZ C8\MatchServer\MD5HashValue.txt
MD5 Hash Value => 22 d1 ac 14 2e 2e 92 b6 1a b8 f8 e2 40 9e 5b 88 

================================== Server configure info ==================================
[07/06/10 19:27:32] Release Date : Jun 13 2007
[07/06/10 19:27:32] X-Trap Off
[07/06/10 19:27:32] MD5 Check Off
[07/06/10 19:27:32] Server Country : BRAZIL
[07/06/10 19:27:32] Command version : (56)
[07/06/10 19:27:32] Event usable state : (false)
[07/06/10 19:27:32] Load event size : (0)
[07/06/10 19:27:32] FileCRCCheckSum usable state : (false)
[07/06/10 19:27:32] FileCRC size : (1)
[07/06/10 19:27:32] Country Code Filter usalbe state : (false)
[07/06/10 19:27:32] Accept Invalied IP state : (true)
[07/06/10 19:27:32] Keeper IP : (**********)
[07/06/10 19:27:32] Monitor IP : (127.0.0.1)
===========================================================================================

[07/06/10 19:27:32] Match Server Created (Port:7657)
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'.

[07/06/10 19:32:32] GARBAGE SESSION CLEANING : ClientCount=4, SessionCount=5, AgentCount=1
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

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

[07/06/10 19:37:32] GARBAGE SESSION CLEANING : ClientCount=6, SessionCount=7, AgentCount=1
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'.

[07/06/10 19:42:32] GARBAGE SESSION CLEANING : ClientCount=11, SessionCount=13, AgentCount=1
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

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

[07/06/10 19:47:32] GARBAGE SESSION CLEANING : ClientCount=12, SessionCount=14, AgentCount=1
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

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

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

[07/06/10 19:52:32] GARBAGE SESSION CLEANING : ClientCount=14, SessionCount=16, AgentCount=1
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

RealCPNet> SessionCreated=48, SessionDestroyed=31

Code:

nhn server mode is real
Load XML from memory : strings.xml(0x0037) - SUCCESS
Load XML from memory : cserror.xml(0x0037) - SUCCESS
[07/06/10 19:55:19] DBMS connected
[07/06/10 19:55:20] Command registeration completed

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

10
Inited client file list (1)
success init security.
FILE PATH : C:\Documents and Settings\Administrator\Desktop\EVILGUNZ C8\MatchServer\MD5HashValue.txt
MD5 Hash Value => 22 d1 ac 14 2e 2e 92 b6 1a b8 f8 e2 40 9e 5b 88 

================================== Server configure info ==================================
[07/06/10 19:55:20] Release Date : Jun 13 2007
[07/06/10 19:55:20] X-Trap Off
[07/06/10 19:55:20] MD5 Check Off
[07/06/10 19:55:20] Server Country : BRAZIL
[07/06/10 19:55:20] Command version : (56)
[07/06/10 19:55:20] Event usable state : (false)
[07/06/10 19:55:20] Load event size : (0)
[07/06/10 19:55:20] FileCRCCheckSum usable state : (false)
[07/06/10 19:55:20] FileCRC size : (1)
[07/06/10 19:55:20] Country Code Filter usalbe state : (false)
[07/06/10 19:55:20] Accept Invalied IP state : (true)
[07/06/10 19:55:20] Keeper IP : (***********)
[07/06/10 19:55:20] Monitor IP : (127.0.0.1)
===========================================================================================

[07/06/10 19:55:20] Match Server Created (Port:7657)
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'.

[07/06/10 20:00:20] GARBAGE SESSION CLEANING : ClientCount=15, SessionCount=15, AgentCount=0
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'.

[07/06/10 20:05:20] GARBAGE SESSION CLEANING : ClientCount=18, SessionCount=18, AgentCount=0
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

SPEEDHACK : User='^6Watermelon', SyncRatio=2.126000 (TimeDiff=42520) 
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

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

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

[07/06/10 20:10:20] GARBAGE SESSION CLEANING : ClientCount=18, SessionCount=19, AgentCount=1
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

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

[07/06/10 20:15:20] GARBAGE SESSION CLEANING : ClientCount=16, SessionCount=23, AgentCount=0
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

[07/06/10 20:17:50] ChatRoom Created : 'FreeSex' 
[07/06/10 20:18:11] ChatRoom Created : 'all join for sex' 
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

[07/06/10 20:20:20] GARBAGE SESSION CLEANING : ClientCount=14, SessionCount=22, AgentCount=1
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

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

[07/06/10 20:21:44] TIMEOUT CLIENT CLEANING : ITouch(0257, 200.104.192.245) (ClientCnt=16, SessionCnt=23)
[07/06/10 20:22:01] TIMEOUT CLIENT CLEANING : ^LChamp^9re(021, 96.48.48.149) (ClientCnt=15, SessionCnt=22)
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

RealCPNet> SessionCreated=71, SessionDestroyed=49

Code:

nhn server mode is real
Load XML from memory : strings.xml(0x0037) - SUCCESS
Load XML from memory : cserror.xml(0x0037) - SUCCESS
[07/06/10 18:34:59] DBMS connected
[07/06/10 18:35:00] Command registeration completed

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

10
Inited client file list (1)
success init security.
FILE PATH : C:\Documents and Settings\Administrator\Desktop\EVILGUNZ C8\MatchServer\MD5HashValue.txt
MD5 Hash Value => 22 d1 ac 14 2e 2e 92 b6 1a b8 f8 e2 40 9e 5b 88 

================================== Server configure info ==================================
[07/06/10 18:35:02] Release Date : Jun 13 2007
[07/06/10 18:35:02] X-Trap Off
[07/06/10 18:35:02] MD5 Check Off
[07/06/10 18:35:02] Server Country : BRAZIL
[07/06/10 18:35:02] Command version : (56)
[07/06/10 18:35:02] Event usable state : (false)
[07/06/10 18:35:02] Load event size : (0)
[07/06/10 18:35:02] FileCRCCheckSum usable state : (false)
[07/06/10 18:35:02] FileCRC size : (1)
[07/06/10 18:35:02] Country Code Filter usalbe state : (false)
[07/06/10 18:35:02] Accept Invalied IP state : (true)
[07/06/10 18:35:02] Keeper IP : (**********)
[07/06/10 18:35:02] Monitor IP : (127.0.0.1)
===========================================================================================

[07/06/10 18:35:02] Match Server Created (Port:7657)
success to update CustomIP
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

[07/06/10 18:40:03] GARBAGE SESSION CLEANING : ClientCount=0, SessionCount=1, AgentCount=1
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

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

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

[07/06/10 18:45:03] GARBAGE SESSION CLEANING : ClientCount=3, SessionCount=4, AgentCount=1
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'.

[07/06/10 18:50:03] GARBAGE SESSION CLEANING : ClientCount=5, SessionCount=6, AgentCount=1
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

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

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

[07/06/10 18:55:03] GARBAGE SESSION CLEANING : ClientCount=7, SessionCount=8, AgentCount=1
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

[07/06/10 19:00:03] GARBAGE SESSION CLEANING : ClientCount=7, SessionCount=8, AgentCount=1
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'.

[07/06/10 19:05:03] GARBAGE SESSION CLEANING : ClientCount=10, SessionCount=11, AgentCount=1
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

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

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

[07/06/10 19:08:28] ChatRoom Created : 'Leave the room' 
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

[07/06/10 19:09:43] ChatRoom Created : 'hi' 
[07/06/10 19:10:03] GARBAGE SESSION CLEANING : ClientCount=11, SessionCount=12, AgentCount=1
MMatchDBMgr::InsertQuestGameLog - Arithmetic overflow error for data type tinyint, value = 9805.
The statement has been terminated.

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

[07/06/10 19:15:03] GARBAGE SESSION CLEANING : ClientCount=8, SessionCount=9, AgentCount=1
CrashDump Entered 1
CrashDump Entered 2
CrashDump Leaving
CrashDump Leaved

If you need anymore crash logs i have plenty BUT there almost ALL the same as this...
It's the most strange piece of crap, but if anyone can help it would be great, ty

corrado · Jul 8, 2010

Try fix the db

Joe9099 · Jul 8, 2010

i myself thought it might have been a DB problem.
Might be kore, who knows.

but heh lets see how long it withhelds for.
-Joe

-Phoenix- · Jul 8, 2010

its the x hours matchserver crash probally just get an restarter and let it run it will restart your matchserver right after the crash one time

Đevil · Jul 8, 2010

if its Kore you can fix it With ASM ( theres a TuT in Release Section ) Its Patches all the Crashers, i have tried it myself.

and have u tried to reinstall GuNZ Database?

Oh and have you got Any Custom Dll or any other File what modifity the Client ?

wesman2232 · Jul 8, 2010

Code:

MMatchDBMgr::InsertQuestGameLog - Arithmetic overflow error for data type tinyint, value = 9805.
The statement has been terminated.

I'm thinking that means the value max for the column may be too small, but I could be wrong.
And to fix the other one, make LogDB with a ConnLog table, I don't remember exactly on that one lol.

Phoenix · Jul 8, 2010

Execute these 3 scripts onto your DB to prevent those errors. I used to have the same Quest Log error before. These scripts will take care of the Connection log and quest errors.

Code:

DROP TABLE [dbo].[QuestGameLog]
GO
/****** Object:  Table [dbo].[QuestGameLog]    Script Date: 11/04/2009 02:05:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[QuestGameLog](
    [id] [int] IDENTITY(1,1) NOT NULL,
    [GameName] [varchar](64) NULL,
    [Master] [int] NOT NULL,
    [Player1] [int] NULL,
    [Player2] [int] NULL,
    [Player3] [int] NULL,
    [TotalQItemCount] [int] NULL,
    [ScenarioID] [int] NOT NULL,
    [StartTime] [smalldatetime] NOT NULL,
    [EndTime] [smalldatetime] NOT NULL,
PRIMARY KEY NONCLUSTERED 
(
    [id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

Code:

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[spRegularUpdateConnLog]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'
CREATE PROC [dbo].[spRegularUpdateConnLog]
AS
 SET NOCOUNT ON

 DECLARE @Year char(4)
 DECLARE @Mon char(2)
 DECLARE @OldDate smalldatetime
 DECLARE @OldTableName varchar(128)

 SET @OldDate = DATEADD( mm, -1, GETDATE() )
 SET @Year = DATEPART(yy, @OldDate)
 SET @Mon = DATEPART(mm, @OldDate)

 SET @OldTableName = ''ConnLog_'' + @Year + 
  CASE WHEN @Mon < 10 THEN ''0'' + CAST(@Mon AS char(1))
  ELSE CAST(@Mon AS char(2)) END

 EXEC sp_rename ''ConnLog'', @OldTableName

 CREATE TABLE ConnLog(
  id int IDENTITY
 , AID int NOT NULL
 , Time smalldatetime
 , IPPart1 tinyint NOT NULL
 , IPPart2 tinyint NOT NULL
 , IPPart3 tinyint NOT NULL
 , IPPart4 tinyint NOT NULL
 , CountryCode3 char(3) )

 CREATE NONCLUSTERED INDEX IX_ConnLog_AID
 ON ConnLog( AID )

 CREATE NONCLUSTERED INDEX IX_ConnLog_Time
 ON ConnLog( Time )

' 
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[spWebGetCharClan]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'
CREATE PROC [dbo].[spWebGetCharClan] 
 @CID   int  
AS  
 SET NOCOUNT ON
 SELECT cl.CLID AS CLID, cl.Name AS ClanName FROM ClanMember cm(nolock), Clan cl(nolock) WHERE cm.cid=@CID AND cm.CLID=cl.CLID  

' 
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[spWebGetClanList]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'
CREATE PROC [dbo].[spWebGetClanList]  
 @Page INT,  
 @Backward INT  = 0  
AS  
SET NOCOUNT ON
BEGIN  
 DECLARE @PageHead INT  
 DECLARE @RowCount INT  
  
 IF @Backward = 0  
 BEGIN  
  SELECT @RowCount = ((@Page -1) * 15 + 1)  
    
  SET ROWCOUNT @RowCount  
  SELECT @PageHead = CLID FROM Clan(NOLOCK) WHERE DeleteFlag=0 ORDER BY CLID DESC  
    
  SET ROWCOUNT 15  
  SELECT cl.CLID AS CLID, cl.Name as ClanName, c.Name AS Master, cl.RegDate AS RegDate, cl.EmblemUrl AS EmblemUrl, cl.Point AS Point  
  FROM Clan cl(NOLOCK), Character c(nolock)  
  WHERE cl.MasterCID=c.CID AND cl.DeleteFlag=0 AND cl.CLID<@PageHead   
  ORDER BY cl.CLID DESC  
 END  
 ELSE  
 BEGIN -- 역순  
  SELECT @RowCount = ((@Page -1) * 15 + 1)  
    
  SET ROWCOUNT @RowCount  
  SELECT @PageHead = CLID FROM Clan(NOLOCK) WHERE DeleteFlag=0 ORDER BY CLID  
    
  SET ROWCOUNT 15  
  SELECT CLID, ClanName, Master, RegDate, EmblemUrl, Point  
  FROM  
  (  
   SELECT TOP 15 cl.CLID AS CLID, cl.Name as ClanName, c.Name AS Master, cl.RegDate AS RegDate, cl.EmblemUrl AS EmblemUrl, cl.Point AS Point  
   FROM Clan cl(NOLOCK), Character c(nolock)  
   WHERE cl.MasterCID=c.CID AND cl.DeleteFlag=0 AND cl.CLID>=@PageHead ORDER BY cl.CLID  
  ) AS t  
  ORDER BY CLID DESC  
 END  
END  

' 
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[spWebGetClanListSearchByName]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'
CREATE PROC [dbo].[spWebGetClanListSearchByName]
 @Name VARCHAR(24)  
AS  
SET NOCOUNT ON
BEGIN  
 SELECT TOP 20 cl.CLID AS CLID, cl.Name as ClanName, c.Name AS Master, cl.RegDate AS RegDate, cl.EmblemUrl AS EmblemUrl, cl.Point AS Point  
 FROM Clan cl(NOLOCK), Character c(NOLOCK)  
 WHERE cl.MasterCID=c.CID AND c.DeleteFlag=0 AND cl.Name=@Name   
 ORDER BY cl.CLID  
END  

' 
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[spWebGetClanMember]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'
CREATE PROC [dbo].[spWebGetClanMember]  
 @CLID  int  
AS  
 SET NOCOUNT ON
 SELECT cm.clid AS CLID, cm.Grade AS ClanGrade, c.cid AS CID, c.name AS CharName  
 FROM ClanMember cm(nolock), Character c(nolock)  
 WHERE CLID=@CLID AND cm.cid=c.cid  

' 
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[spWebGetClanRankingHistory]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'
CREATE  PROC [dbo].[spWebGetClanRankingHistory]  
 @Year INT,  
 @Month INT,  
 @Page INT,  
 @Backward INT = 0  
AS  
SET NOCOUNT ON
BEGIN  
 /* 한페이지에 20개씩 보여준다 (속도를위해 갯수 고정) */  
 DECLARE @RowCount INT  
 DECLARE @PageHead INT  
  
 IF @Backward = 0  
 BEGIN  
  SELECT @RowCount = ((@Page -1) * 20 + 1)  
  SELECT TOP 20 Ranking, ClanName as ClanName, Point, Wins, Losses, CLID FROM ClanHonorRanking(NOLOCK)   
  WHERE Year=@Year AND Month=@Month AND Ranking>0 AND Ranking >= @RowCount ORDER BY Ranking  
 END  
 ELSE  
 BEGIN  
  SELECT @RowCount = ((@Page -1) * 20 + 1)  
   
  SET ROWCOUNT @RowCount  
  SELECT @PageHead = Ranking FROM Clan(NOLOCK) WHERE DeleteFlag=0 ORDER BY Ranking DESC  
   
  SET ROWCOUNT 20  
  SELECT  Ranking, RankIncrease=0, ClanName, Point, Wins, Losses, CLID, EmblemUrl=NULL FROM  
  (  
   SELECT TOP 20 Ranking, ClanName, Point, Wins, Losses, CLID FROM ClanHonorRanking(NOLOCK)   
   WHERE Year=@Year AND Month=@Month AND Ranking>0 AND Ranking <= @PageHead ORDER BY Ranking DESC  
  ) AS t ORDER BY Ranking  
 END  
END  
  

' 
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[spWebGetClanRankingMaxPage]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'
CREATE PROC [dbo].[spWebGetClanRankingMaxPage]  
AS  
SET NOCOUNT ON
BEGIN  
 DECLARE @MaxPage INT  
 SELECT TOP 1 @MaxPage = Ranking / 20 + 1 FROM Clan(NOLOCK) WHERE DeleteFlag=0 AND Ranking>0 ORDER BY Ranking DESC  
-- SELECT @MaxPage  
 RETURN @MaxPage  
END  

' 
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[spWebGetClanRankingSearchByRanking]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'
CREATE PROC [dbo].[spWebGetClanRankingSearchByRanking]  
 @Ranking INT  
AS  
SET NOCOUNT ON
BEGIN  
 SELECT TOP 20 Ranking, RankIncrease, Name as ClanName, Point, Wins, Losses, CLID, EmblemUrl FROM Clan(NOLOCK)   
 WHERE DeleteFlag=0 AND Ranking>0 AND Ranking=@Ranking ORDER BY Ranking  
END  

' 
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ConnLog]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[ConnLog](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[AID] [int] NOT NULL,
	[Time] [smalldatetime] NULL,
	[IPPart1] [tinyint] NOT NULL,
	[IPPart2] [tinyint] NOT NULL,
	[IPPart3] [tinyint] NOT NULL,
	[IPPart4] [tinyint] NOT NULL,
	[CountryCode3] [char](3) NULL
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DeleteAccountLog]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[DeleteAccountLog](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [varchar](24) NOT NULL,
	[AID] [int] NOT NULL,
	[RegDate] [smalldatetime] NULL,
PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ServerLogStorage]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[ServerLogStorage](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[ServerID] [smallint] NOT NULL,
	[PlayerCount] [int] NOT NULL,
	[GameCount] [int] NOT NULL,
	[BlockCount] [int] NOT NULL,
	[NonBlockCount] [int] NOT NULL,
	[Time] [smalldatetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
END

Code:

USE [GunZDB]
GO
/****** Object:  StoredProcedure [dbo].[spInsertConnLog]    Script Date: 05/20/2009 23:46:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO

ALTER PROC [dbo].[spInsertConnLog] 
 @AID int
, @IPPart1 tinyint
, @IPPart2 tinyint
, @IPPart3 tinyint
, @IPPart4 tinyint
, @CountryCode3	char(3)
AS
 SET NOCOUNT ON
 INSERT INTO ConnLog( AID, Time, IPPart1, IPPart2, IPPart3, IPPart4, CountryCode3)
 VALUES (@AID, GETDATE(), @IPPart1, @IPPart2, @IPPart3, @IPPart4, @CountryCode3)

ElternalFire · Jul 8, 2010

Kore attackers :S.
Change the Matchserver ports and it will be saver =)
I did it to but now I had a matchserver problem, fixed it and now the matchagent doesn't work anymore -.-

Joe9099 · Jul 8, 2010

Thanks guys you have been great help.
We have applyed the ASM patch to the server and hopefully has fixed it, no crashes for 7 hours lawl, record -.-

I'll also apply them Queries above, thanks man.

-Joe

Phoenix · Jul 8, 2010

Joe9099 said:
Thanks guys you have been great help.
We have applyed the ASM patch to the server and hopefully has fixed it, no crashes for 7 hours lawl, record -.-

I'll also apply them Queries above, thanks man.

-Joe

Be aware that Kore Revision 2's exploit 0,2 & 7 still crash the MatchServer, using Gregon's patch. Do something about it.

ElternalFire · Jul 8, 2010

Great job.
My is never got attacked again XD, only the first day like 2x every hour with Matchserver crash -.-
But now we're gonna make a V2 because the old server files fucked up ^^.
I fixed the MatchServer error but now he can't make the port 7777 in the MatchAgent, so ye... (fail XD)

Joe9099 · Jul 8, 2010

Are u above on a different story rofl?

but anyways mod lock please, fixed.

pluke001 · Jul 8, 2010

Joe9099 said:
but anyways mod lock please, fixed.

You can lock it yourself since you started this theard. Just press theard tools.

Touchwise · Jul 8, 2010

The last crash is by kore for sure but gregon's patch doesn't work that well on the 2008 files don't forget that... and joe i think we need a lil chat

Welcome!

[Pro's only...] Matchserver Crashing

Joe9099

An old mofo

corrado

Experienced Elementalist

Joe9099

An old mofo

-Phoenix-

Skilled Illusionist

Đevil

Newbie Spellweaver

wesman2232

DRGunZ 2 Creator

Phoenix

Moderator

ElternalFire

Experienced Elementalist

Joe9099

An old mofo

Phoenix

Moderator

ElternalFire

Experienced Elementalist

Joe9099

An old mofo

pluke001

What year is this?

Touchwise

Freelance GunZ Developer

About Us

Online statistics

Forum statistics

RaGEZONE Sponsor