MLocator Problem.

[SirMaster]

Korean: MLocator::Create - 접속 허용 국가 코드 리스트 초기화 실패.
English: MLocator:: Create - connection permission national cord list initial anger it fails.

I have finished all procedures and tables of the locator and follows without walking if somebody has some information that helps me please that it puts it here.

[MentaL]

[lutchius]

try setting country code filter to no

[SirMaster]

My setting:
[DB]
DNS="xxxxxxxxxxxxxxx"
USERNAME="xxxxxxxxxx"
PASSWORD="xxxxxxxxxxxx"

[NETWORK]
IP="xxxxxxxxxxxxxxxxxxxx"
PORT=8900

[ENV]
ID=1
LOCATOR_UID_HIGH=999
LOCATOR_UID_LOW=0
MAX_ELAPSED_UPDATE_SERVER_STATUS_TIME=1
UDP_LIVE_TIME=1
MAX_FREE_RECV_COUNT_PER_LIVE_TIME=9
BLOCK_TIME=300000
UPDATE_UDP_MANAGER_ELAPSED_TIME=2000
MARGIN_OF_ERROR_MIN=6
USE_COUNTRY_CODE_FILTER="no"
GMT_DIFF=-3
ELAPSED_TIME_UPDATE_LOCATOR_LOG=3600000
ELAPSED_TIME_UPDATE_COUNTRYCODEFILTER_LOG=1
Already no working :S

[ThuGie]

all i can tell you its a problem in your procs of the locator etc ;).
so your db aint correct.

[SirMaster]

spStartUpLocatorStatus:
CREATE PROCEDURE [dbo].[spStartUpLocatorStatus]
@nServerID int,
@nIP varchar(4000),
@nPort int,
@nStatusTime int
AS
INSERT INTO ServerStatus (ServerID,IP,Port,StatusTime) VALUES (@nServerID,@nIP,@nPort,@nStatusTime)
GO

spUpdateLocatorStatus:
CREATE PROCEDURE [dbo].[spUpdateLocatorStatus]
@nServerID INT,
@nTime VARCHAR(20),
@nIP VARCHAR(4000),
@nPort INT,
@nOpened INT
AS
BEGIN
SET NOCOUNT ON;
UPDATE ServerStatus
SET Time = @nTime, IP = @nIP, Port = @nPort, Opened = @nOpened
WHERE ServerID = @nServerID
END
GO

Others Locator Procedures:
CREATE PROCEDURE [dbo].[spGetIPCountryCode]
@nCode NVARCHAR
AS
SELECT IPFrom, IPTo, CountryCode3 FROM BlockCountryCode(NOLOCK) WHERE Code = @nCode
GO

CREATE PROCEDURE [dbo].[spGetIPtoCountryList]
AS
SELECT IPFrom, IPTo, CountryCode3 FROM BlockCountryCode(NOLOCK)
GO

Table:
CREATE TABLE [dbo].[ServerStatus] (
[PK_ServerStatus] [int] NULL ,
[ServerID] [int] NOT NULL ,
[Opened] [int] NULL ,
[CurrPlayer] [int] NULL ,
[Time] [varchar] (20) COLLATE Modern_Spanish_CI_AS NULL ,
[IP] [nvarchar] (4000) COLLATE Modern_Spanish_CI_AS NULL ,
[Port] [int] NULL ,
[ServerName] [varchar] (8000) COLLATE Modern_Spanish_CI_AS NULL ,
[PlayerCount] [int] NULL ,
[MaxPlayer] [int] NULL ,
[StatusTime] [int] NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[BlockCountryCode] (
[IPFrom] [varchar] (4000) COLLATE Modern_Spanish_CI_AS NULL ,
[IPTo] [varchar] (4000) COLLATE Modern_Spanish_CI_AS NULL ,
[CountryCode3] [varchar] (4000) COLLATE Modern_Spanish_CI_AS NULL ,
[IsBlock] [int] NULL ,
[Comment] [varchar] (4000) COLLATE Modern_Spanish_CI_AS NULL ,
[Code] [varchar] (4000) COLLATE Modern_Spanish_CI_AS NULL ,
[RountingURL] [varchar] (4000) COLLATE Modern_Spanish_CI_AS NULL
) ON [PRIMARY]
GO



Already no work.

[ThuGie]

yeah i take it there empty though..
and dont expect me to check what you got wrong.. to lazy and atm almost 7 am still need to sleep.

[ThuGie]

Although i have to thank you..

i had

CREATE PROCEDURE [dbo].[spUpdateLocatorStatus]
@ID INT,
@uidPlayer INT,
@dwIP varchar(20),
@nPort INT,
@UpdateTime INT

i knew it was wrong though but didnt know what it sould be :p.
a other question though do you have the pdb file of locator ?

[ThuGie]

Uhm somehow i have a feeling its wrong though..

[Rotana]

Mine locator couldn't find the stored procedure of GetServerStatus. Does some have that one? one would share it with me?

[SirMaster]

GetServerStatus procedure no exist already use commands in the locator


ThuGie i dont have a .pdb archive and locator already no working i edited to you information and no work.

[ThuGie]

well i got locator running though already have it for a few days..
but it says the matchserver is dead instead of running no clue why..

but uhm
CREATE PROCEDURE [dbo].[spUpdateLocatorStatus]
@nServerID INT,
@nTime VARCHAR(20),
@nIP VARCHAR(4000),
@nPort INT,
@nOpened INT
serverid is correct..
the rest just keeps returning 0..

could you tell me why you think its opened port ip etc ?

[SirMaster]

you can post you procedures of locator?

[ThuGie]

Well i didnt create them for myself..

But for somebody else and i have a feeling that person rather keep it private :$.

[SirMaster]

good sight vos you help me my and I help you so that we have the servants to the 100% ok? single need procedures the locator later I needs to fix the clan just of the clan I am in charge I ok? if decis that if enviame a message deprived with procedures and I with each advance that does in the data bases you the control ok?

[ThuGie]

could you typ that again but this time in english?

and if you where asking me if i needed clan procs or what ever nope i probably already have all procs.. maybe missing or need to fix 1 or 2..
but i can do that myself.

[-Lambda-]

Working?..

[Keith]

me and Thugie got it working correct ;)

[Komotost]

well i got locator running though already have it for a few days..
but it says the matchserver is dead instead of running no clue why..

but uhm
CREATE PROCEDURE [dbo].[spUpdateLocatorStatus]
@nServerID INT,
@nTime VARCHAR(20),
@nIP VARCHAR(4000),
@nPort INT,
@nOpened INT
serverid is correct..
the rest just keeps returning 0..

could you tell me why you think its opened port ip etc ?

You can get this from the Locator.exe

I belive you missed at least one proc, not too sure about all the others....

Anyways this is what I came up with for it..

(and yes, GetServerStatus just reads from BlockCountryCode

Edit: oops forgot to put the values, 1 sec let me fix it!

Lets work together on gettin this thing working already!

[Hakurah]

Shouldn't you share something like this here, then, LGKeiz and ThuGie? xP
I don't care if you take long to do that. I just want to know if you'll share it. =~
Give me just a bonus for knowing English nicely, something most people here don't! ><

[virustheking]

can share LG?

[StarNet]

Guys and gals, don't expect any shares from LG anytime soon because that just the way he works, he has public server for god shake, ppls with public server won't share their ultimate weapons and loose their players :)

Just my bad experience with him as an evil moderator :)
Don't trust this guy!