Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

MLocator Problem.

C/C++ Programmer
Joined
Mar 1, 2006
Messages
314
Reaction score
191
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.
 
C/C++ Programmer
Joined
Mar 1, 2006
Messages
314
Reaction score
191
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
 
Upvote 0
C/C++ Programmer
Joined
Mar 1, 2006
Messages
314
Reaction score
191
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.
 
Upvote 0
ThuGie.NL - Webmaster
Joined
Apr 16, 2006
Messages
607
Reaction score
55
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 ?
 
Upvote 0
C/C++ Programmer
Joined
Mar 1, 2006
Messages
314
Reaction score
191
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.
 
Last edited:
Upvote 0
ThuGie.NL - Webmaster
Joined
Apr 16, 2006
Messages
607
Reaction score
55
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 ?
 
Upvote 0
C/C++ Programmer
Joined
Mar 1, 2006
Messages
314
Reaction score
191
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?
 
Upvote 0
ThuGie.NL - Webmaster
Joined
Apr 16, 2006
Messages
607
Reaction score
55
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.
 
Upvote 0
Junior Spellweaver
Joined
Jan 3, 2007
Messages
145
Reaction score
27
Working?..


SirMaster - MLocator Problem. - RaGEZONE Forums
 
Upvote 0
Newbie Spellweaver
Joined
Jan 8, 2007
Messages
93
Reaction score
0
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!
 
Last edited:
Upvote 0
Joined
Dec 30, 2006
Messages
595
Reaction score
25
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! ><
 
Upvote 0
Back
Top