[HELP] Problem with "ServerStatus"

[w666sk]

My Gunz server don't works.
The logs are here :

Locator :
MLocatorDBMgr::GetServerStatus - Invalid object name 'ServerStatus'.
Statement(s) could not be prepared.

Fail to GetServerStatus
MLocator::Create -

[MentaL]

[Rotana]

You don't have the complete table of ServerStatus

Use this for it

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ServerStatus](
	[ServerID] [int] NULL,
	[ServerName] [nvarchar](32) COLLATE Latin1_General_CI_AS NULL,
	[PlayerCount] [int] NULL,
	[MaxPlayer] [int] NULL,
	[CurrPlayer] [int] NULL,
	[Time] [datetime] NULL,
	[IP] [varchar](50) COLLATE Latin1_General_CI_AS NULL,
	[Port] [int] NULL,
	[Opened] [varchar](50) COLLATE Latin1_General_CI_AS NULL,
	[StatusTime] [int] NULL,
	[UpdateTime] [int] NULL,
	[RecvUDP] [varchar](max) COLLATE Latin1_General_CI_AS NULL,
	[SendUDP] [varchar](max) COLLATE Latin1_General_CI_AS NULL,
	[BlockUDP] [int] NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

If there is an error, delete you own table first.

[w666sk]

You don't have the complete table of ServerStatus

Use this for it

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ServerStatus](
	[ServerID] [int] NULL,
	[ServerName] [nvarchar](32) COLLATE Latin1_General_CI_AS NULL,
	[PlayerCount] [int] NULL,
	[MaxPlayer] [int] NULL,
	[CurrPlayer] [int] NULL,
	[Time] [datetime] NULL,
	[IP] [varchar](50) COLLATE Latin1_General_CI_AS NULL,
	[Port] [int] NULL,
	[Opened] [varchar](50) COLLATE Latin1_General_CI_AS NULL,
	[StatusTime] [int] NULL,
	[UpdateTime] [int] NULL,
	[RecvUDP] [varchar](max) COLLATE Latin1_General_CI_AS NULL,
	[SendUDP] [varchar](max) COLLATE Latin1_General_CI_AS NULL,
	[BlockUDP] [int] NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

If there is an error, delete you own table first.

Ok now server "works".
But when i try to go on, i got "cannot access server"

[RepublicOfAstra]

For some people, logging into their server using Locator doesn't work if it's on the same network as the server. It works for people outside though. If you use Locator, it'll only work for others, but the host has to use debug mode