Printable View
Hello. I hav a problem with my gunz. IF i launch the game without servers running then it loads and all and shows empty server menu, which is right. But if i run game with server,matchagent and locator running, then it finishes loading, the server menu is about to appear and then baang, it crashed without even an error message! and im back on desktop. any ideas?
bump cause i need help.
I have the same problem with my offline server.Quote:
Originally Posted by AloEST
And also have no fucking clue why its happening ...
Reinstalling everything didnt worked out.
Im to lazy to try reinstalling my whole machine ...
i also tried hamachi connecting. by then, it doesnt crash in the pc im trying to connect to here but it doesnt show the server too. Anyone who can fix this,please help us!
Your Client is crashing, right? if so toss up your mlog. and check your error logs for matchserver while you're at it.
As for me:
Shows nothing unusual ...
Expect thatline in my matchservers log ...Code:MMatchDBMgr::InsertConnLog - Ungültiger Objektname 'LogDB.game.ConnLog'.
Since we have the similiar problem this might be the source/could be the solution to that problem.
May I ask you. Did that error show up while using 2008 files?Quote:
Originally Posted by HellSniper
okay, i redone it using the videotut and its files. now it doesnt crash, but i dont see my server. i opened ports, still dont see. i added my own ip to launcher, still nothing. added my ip to config.xml, still nothing. what to do? -.-
@Hell Sniper, execute these 2 scripts on your database to prevent the Log errors.
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)
but what about me? :/
Was about to post the same.Quote:
Originally Posted by phoenix_147
2008 database:
Maybe it helps to create the table.PHP Code:USE [GunzDB]
GO
/****** Object: StoredProcedure [dbo].[spInsertConnLog] Script Date: 06/08/2010 18:36:33 ******/
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 LogDB.dbo.ConnLog( AID, Time, IPPart1, IPPart2, IPPart3, IPPart4, CountryCode3)
VALUES (@AID, GETDATE(), @IPPart1, @IPPart2, @IPPart3, @IPPart4, @CountryCode3)
what about my "server not seen" problem?:mad:Quote:
Originally Posted by 00niels00
Its a offline server for testing purposes, its a 07 br client.
And i will try it some time later, thanks.
For now help AloEST!
AloEST post your server.ini.
the one i use now is offline server? i need an online one which works with my external ip.
I hope its any help.
Post it, not upload it. Post it in the form of a code here.
oh lol, sry.
Code:[DB]
DNS="GunzDB"
USERNAME="sa"
PASSWORD="classified"
[SERVER]
MAXUSER=100
SERVERID=1
SERVERNAME="Eesti"
FREELOGINIP="90.190.235.175"
KEEPERIP="90.190.235.175"
MONITORIP="127.0.0.1"
MONITORPORT=9000
MODE="test"
COUNTRY="BRZ"
LANGUAGE="BRZ"
USETICKET="0"
[LANGUAGE]
LANG_TYPE="eng"
[LOCALE]
DBAgentPort=5100
DBAgentIP=127.0.0.1
[FILTER]
USE="0"
ACCEPT_INVALID_IP="1"
[ENVIRONMENT]
USE_HSHIELD="0"
USE_XTRAP="0"
USE_EVENT="0"
USE_FILECRC="0"
USE_MD5="0"
You need to leave FREELOGINIP blank. Anyways, use this server.ini
Code:[DB]
DNS="GunzDB"
USERNAME="sa"
PASSWORD="classified"
[SERVER]
MAXUSER=100
SERVERID=1
SERVERNAME="Eesti"
FREELOGINIP=""
KEEPERIP="90.190.235.175"
MONITORIP="127.0.0.1"
MONITORPORT=9000
MODE="test"
COUNTRY="BRZ"
LANGUAGE="BRZ"
USETICKET="0"
[LANGUAGE]
LANG_TYPE="eng"
[LOCALE]
DBAgentPort=5100
DBAgentIP=127.0.0.1
[FILTER]
USE="0"
ACCEPT_INVALID_IP="1"
[ENVIRONMENT]
USE_HSHIELD="0"
USE_XTRAP="0"
USE_EVENT="0"
USE_FILECRC="0"
USE_MD5="0"
ill try, ty.
EDIT:still nothing.
if your trying for an offline server, for now leave everything as 127.0.0.1 (in all files, including system/config.xml, you know all the client and server configuration files, and in the DB).
If that does nothing, then if you have a router you should try to port forward.
im trying for online server,not offline. and all ports are open and even launcher has ip-s changed to external ip. i dunno whats wrong...Quote:
Originally Posted by wesman2232
Well, I just run those 2 scripts, there were no problems with executing them.
But didnt helped me.
Ive checked the Ip's once again and every ip is the same IP, the Lan Ip.
Mlog Shows nothing expect 2 texture load errors from the lobby.
But thats not the reason for the crashs ...
All the Other logs dont have any wrong entries.
well,did u use the jan tutorial? cause i did too and it crashed while running server. but when i used the videotut by that spanish guy,then i got it working without crash but i didnt see the server too -.- u shud try that spanish tut too.
look at your db what ips there are maybe there are wrong ips ...
Are you serious?? It's a part of the database it doesn't need to get executed since it already is. It's because the code says it wants to store data in a ConnLog table.Quote:
Originally Posted by HellSniper
I have the same problem, I tried everything, but the server won't show up.
Never count out issues with your router. I once had a router that was broken and refused to open ports even when it said they were open. but more often than not you just made a small error.
so how im going to fix this? i am using a THOMSON Speedtouch 546v6 router
Well, you should read what pheonix told me to do...!
well that was to fix the crash maybe? did it get u to see the server too?
bumpz0r.
bumpz0r -.-
I understand that you want this fixed, but breaking forum rules won't get it fixed. I've reported your post and I'd love to help you, but I don't know why it's crashing sometimes and just not showing the other. too many variables. if you've done it all to tutorial it /should/ work. Your router may to be to blame, or just human error.