[SOLVED]adding arabia map final problem
i have this problem that annoys me he it is
Code:
notify successfully server task registered 2012-09-29 00:43:48 154
notify request server certification 2012-09-29 00:43:48 155
notify Add ServerNotify : (704) - FarmManager 2012-09-29 00:43:48 161
notify successfully server certificated 2012-09-29 00:43:48 164
fatal server cord established : 1 (41.41.1.166:15882) 2012-09-29 00:43:48 165
notify Connected to FarmManager [#704] 2012-09-29 00:43:48 166
notify InitializeDB is Successful 2012-09-29 00:43:48 250
fatal server cord established : 2 (41.41.1.166:2281) 2012-09-29 00:43:48 529
notify Connected to AgentServer [#707] 2012-09-29 00:43:48 531
fatal server cord established : 3 (41.41.1.166:15883) 2012-09-29 00:43:50 081
notify Connected to ShardManager [#705] 2012-09-29 00:43:50 087
fatal !!! there is no record in this[TAB_REFRANKING_TRADERACTIVITY] table !!! 2012-09-29 00:43:59 670
fatal !!! there is no record in this[TAB_REFRANKING_TRADERCONTRIBUTION] table !!! 2012-09-29 00:43:59 670
fatal !!! there is no record in this[TAB_REFRANKING_ROBBERACTIVITY] table !!! 2012-09-29 00:43:59 671
fatal !!! there is no record in this[TAB_REFRANKING_ROBBERCONTRIBUTION] table !!! 2012-09-29 00:43:59 671
fatal !!! there is no record in this[TAB_REFRANKING_HUNTERACTIVITY] table !!! 2012-09-29 00:43:59 671
fatal !!! there is no record in this[TAB_REFRANKING_HUNTERCONTRIBUTION] table !!! 2012-09-29 00:43:59 672
fatal !!! there is no record in this[_RefRentItem] table !!! 2012-09-29 00:43:59 685
fatal Invalid Region!![ID:9][ObjName128:·ÎÅ©»ê] 2012-09-29 00:43:59 686
fatal Invalid Region!![ID:10][ObjName128:½ÉÀåÀǺÀ¿ì¸®] 2012-09-29 00:43:59 687
fatal Invalid Region!![ID:11][ObjName128:¹ö·ÁÁø¸¶À»] 2012-09-29 00:43:59 688
fatal Invalid Region!![ID:12][ObjName128:¾çÄ¡±â¸¶À»] 2012-09-29 00:43:59 688
fatal Invalid Region!![ID:13][ObjName128:¹Ù¶÷ÀǸ¶À»] 2012-09-29 00:43:59 689
fatal Invalid Region!![ID:32][ObjName128:Áø½Ã2Ãþ (2ÃþÀÔ±¸)] 2012-09-29 00:43:59 689
fatal Invalid Region!![ID:33][ObjName128:Áø½Ã3Ãþ (3ÃþÀÔ±¸)] 2012-09-29 00:43:59 690
fatal Invalid Region!![ID:38][ObjName128:Áø½Ã4Ãþ (¹é»çÀÔ±¸)] 2012-09-29 00:43:59 691
fatal Invalid Region!![ID:39][ObjName128:¾Ë·º»êµå¸®¾Æ (³²)] 2012-09-29 00:43:59 691
fatal Invalid Region!![ID:40][ObjName128:¾Ë·º»êµå¸®¾Æ (ºÏ)] 2012-09-29 00:43:59 692
fatal Invalid Region!![ID:41][ObjName128:ºÓÀº´ëÁö] 2012-09-29 00:43:59 693
fatal Invalid Region!![ID:42][ObjName128:¼Ò±Ý»ç¸·] 2012-09-29 00:43:59 694
fatal !!! there is no record in this[_RefEventReward] table !!! 2012-09-29 00:43:59 694
fatal !!! there is no record in this[_RefEventRewardItems] table !!! 2012-09-29 00:43:59 695
fatal !!! there is no record in this[_RefUIString_Mt] table !!! 2012-09-29 00:43:59 695
fatal !!! there is no record in this[_RefTriggerVariable] table !!! 2012-09-29 00:43:59 696
notify LoadReferenceData is Successful 2012-09-29 00:43:59 769
notify SetupInstanceDataAccess is Successful 2012-09-29 00:43:59 862
warnning Individual Exp Gain Ratio: 500000 2012-09-29 00:43:59 865
warnning Party Exp Gain Ratio: 750000 2012-09-29 00:43:59 866
warnning Item Drop Ratio: 100000 2012-09-29 00:43:59 866
warnning Gold Drop Amount Factor: 45000 2012-09-29 00:43:59 866
fatal There is no WINTER_EVENT_2009 info !!! is it ok? 2012-09-29 00:43:59 867
fatal At initialize Server, Loading Siege data :: CurrentTax = 516360 2012-09-29 00:43:59 868
fatal At initialize Server, Loading Siege data :: CurrentTax = 0 2012-09-29 00:43:59 869
fatal At initialize Server, Loading Siege data :: CurrentTax = 0 2012-09-29 00:43:59 871
fatal At initialize Server, Loading Siege data :: CurrentTax = 0 2012-09-29 00:43:59 872
notify Siege Fortress Manager is successfully initialized 2012-09-29 00:43:59 873
notify GameWorld Instance Manager initialized 2012-09-29 00:43:59 885
notify Loading GameWorld WorldSet[1] Regions!! 2012-09-29 00:44:00 626
fatal REGIONMGR failed to load 21850(x:90, z:85) region 2012-09-29 00:44:00 626
fatal Create Game World Map Failed!!! GAMEWORLDID[1] 2012-09-29 00:44:00 627
fatal Failed to initialize Map 2012-09-29 00:44:00 627
fatal Failed To Load Initial Resource 2012-09-29 00:44:00 628
fatal Failed To Init Local Data 2012-09-29 00:44:00 628
fatal SR_GameServer is initialized successfully 2012-09-29 00:44:00 629
my _LinkRefRegion
Code:
GO
/****** Object: StoredProcedure [dbo].[_LinkRefRegions] Script Date: 09/29/2012 00:34:39 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[_LinkRefRegions]
AS
--- Blow Query is Each Area and FORT matching ---
declare @China int
declare @West_China int
declare @Oasis_Kingdom int
declare @Eu int
declare @Am int
declare @Ca int
declare @ARABIA_TOWN int
declare @ARABIA_FIELD_01 int
declare @ARABIA_FIELD_02 int
declare @ARABIA_FIELD_02_BOSS int
declare @ARABIA_DUNGEON int
select @China = AssocServer from _RefRegionBindAssocServer where AreaName = 'CHINA'
select @West_China = AssocServer from _RefRegionBindAssocServer where AreaName = 'West_China'
select @Oasis_Kingdom = AssocServer from _RefRegionBindAssocServer where AreaName = 'Oasis_Kingdom'
select @Eu = AssocServer from _RefRegionBindAssocServer where AreaName = 'Eu'
select @Am = AssocServer from _RefRegionBindAssocServer where AreaName = 'Am'
select @Ca = AssocServer from _RefRegionBindAssocServer where AreaName = 'Ca'
select @ARABIA_TOWN = AssocServer from _RefRegionBindAssocServer where AreaName = 'ARABIA_TOWN'
select @ARABIA_FIELD_01 = AssocServer from _RefRegionBindAssocServer where AreaName = 'ARABIA_FIELD_01'
select @ARABIA_FIELD_02 = AssocServer from _RefRegionBindAssocServer where AreaName = 'ARABIA_FIELD_02'
select @ARABIA_FIELD_02_BOSS = AssocServer from _RefRegionBindAssocServer where AreaName = 'ARABIA_FIELD_02_BOSS'
select @ARABIA_DUNGEON = AssocServer from _RefRegionBindAssocServer where AreaName = 'ARABIA_DUNGEON'
update _RefRegionBindAssocServer set AssocServer = @China where AreaName = 'FORT_JA_AREA'
update _RefRegionBindAssocServer set AssocServer = @China where AreaName = 'FORT_BJ_AREA'
update _RefRegionBindAssocServer set AssocServer = @West_China where AreaName = 'FORT_DW_AREA'
update _RefRegionBindAssocServer set AssocServer = @West_China where AreaName = 'FORT_HM_AREA'
update _RefRegionBindAssocServer set AssocServer = @Oasis_Kingdom where AreaName = 'FORT_HT_AREA'
update _RefRegionBindAssocServer set AssocServer = @Eu where AreaName = 'FORT_CT_AREA'
update _RefRegionBindAssocServer set AssocServer = @Am where AreaName = 'FORT_ER_AREA'
update _RefRegionBindAssocServer set AssocServer = @Ca where AreaName = 'FORT_SK_AREA'
begin TRANSACTION
begin
declare @LinkNum int
declare @this_region int
declare @region_x int
declare @region_z int
declare @wRegionID smallint
declare @wTempRID smallint
declare @col_link varchar(256)
declare @query varchar(256)
declare @db_id_to_link smallint
-- clear all existing region link
set @LinkNum = 1
while (@LinkNum <= 10)
begin
set @query = 'update _RefRegion set LinkedRegion_' + cast(@LinkNum as varchar(10)) + ' = 0'
execute (@query)
set @LinkNum = @LinkNum + 1
end
-- loop all region
declare region_cursor CURSOR FOR
select wRegionID
from _RefRegion
OPEN region_cursor
FETCH NEXT FROM region_cursor INTO @wRegionID
WHILE @@FETCH_STATUS = 0
begin
if (@@error = 0 and @wRegionID <> 0)
begin
-- ´øÀüÀº ½ºÅµ!
if (@wRegionID > 0)
begin
set @LinkNum = 8
while (@LinkNum >= 0)
begin
set @region_z = (@wRegionID & 0xff00) / 256
set @region_x = (@wRegionID & 0x0ff)
set @wTempRID = 0;
if (@LinkNum = 0)
begin
set @region_x = @region_x - 1
set @col_link = 'LinkedRegion_1'
end
else if (@LinkNum = 1)
begin
set @region_x = @region_x - 1
set @region_z = @region_z + 1
set @col_link = 'LinkedRegion_2'
end
else if (@LinkNum = 2)
begin
set @region_z = @region_z + 1
set @col_link = 'LinkedRegion_3'
end
else if (@LinkNum = 3)
begin
set @region_x = @region_x + 1
set @region_z = @region_z + 1
set @col_link = 'LinkedRegion_4'
end
else if (@LinkNum = 4)
begin
set @region_x = @region_x + 1
set @col_link = 'LinkedRegion_5'
end
else if (@LinkNum = 5)
begin
set @region_x = @region_x + 1
set @region_z = @region_z - 1
set @col_link = 'LinkedRegion_6'
end
else if (@LinkNum = 6)
begin
set @region_z = @region_z - 1
set @col_link = 'LinkedRegion_7'
end
else if (@LinkNum = 7)
begin
set @region_x = @region_x - 1
set @region_z = @region_z - 1
set @col_link = 'LinkedRegion_8'
end
set @wTempRID = (@region_z & 0x00ff) * 256
set @wTempRID = @wTempRID + (@region_x & 0x00ff)
select @db_id_to_link = wRegionID
from _RefRegion
where wRegionID = @wTempRID
if (@@ROWCOUNT <> 0)
begin
set @query = 'update _RefRegion set ' + @col_link + ' = ' + cast(@db_id_to_link as varchar(10)) + ' where wRegionID = ' + cast(@wRegionID as varchar(10))
end
else -- Á¸ÀçÇÏÁö ¾Ê´Â region link ´Â 0À¸·Î ä¿î´Ù
begin
set @query = 'update _RefRegion set ' + @col_link + ' = 0 where wRegionID = ' + cast(@wRegionID as varchar(10))
end
execute(@query)
set @LinkNum = @LinkNum - 1
end
end
end
FETCH NEXT FROM region_cursor INTO @wRegionID
end
CLOSE region_cursor
DEALLOCATE region_cursor
COMMIT TRANSACTION
end
Re: adding arabia map final problem
I've got the same issue..
Re: adding arabia map final problem
Quote:
Originally Posted by
InsaneDev
i have this problem that annoys me he it is
Code:
notify successfully server task registered 2012-09-29 00:43:48 154
notify request server certification 2012-09-29 00:43:48 155
notify Add ServerNotify : (704) - FarmManager 2012-09-29 00:43:48 161
notify successfully server certificated 2012-09-29 00:43:48 164
fatal server cord established : 1 (41.41.1.166:15882) 2012-09-29 00:43:48 165
notify Connected to FarmManager [#704] 2012-09-29 00:43:48 166
notify InitializeDB is Successful 2012-09-29 00:43:48 250
fatal server cord established : 2 (41.41.1.166:2281) 2012-09-29 00:43:48 529
notify Connected to AgentServer [#707] 2012-09-29 00:43:48 531
fatal server cord established : 3 (41.41.1.166:15883) 2012-09-29 00:43:50 081
notify Connected to ShardManager [#705] 2012-09-29 00:43:50 087
fatal !!! there is no record in this[TAB_REFRANKING_TRADERACTIVITY] table !!! 2012-09-29 00:43:59 670
fatal !!! there is no record in this[TAB_REFRANKING_TRADERCONTRIBUTION] table !!! 2012-09-29 00:43:59 670
fatal !!! there is no record in this[TAB_REFRANKING_ROBBERACTIVITY] table !!! 2012-09-29 00:43:59 671
fatal !!! there is no record in this[TAB_REFRANKING_ROBBERCONTRIBUTION] table !!! 2012-09-29 00:43:59 671
fatal !!! there is no record in this[TAB_REFRANKING_HUNTERACTIVITY] table !!! 2012-09-29 00:43:59 671
fatal !!! there is no record in this[TAB_REFRANKING_HUNTERCONTRIBUTION] table !!! 2012-09-29 00:43:59 672
fatal !!! there is no record in this[_RefRentItem] table !!! 2012-09-29 00:43:59 685
fatal Invalid Region!![ID:9][ObjName128:·ÎÅ©»ê] 2012-09-29 00:43:59 686
fatal Invalid Region!![ID:10][ObjName128:½ÉÀåÀǺÀ¿ì¸®] 2012-09-29 00:43:59 687
fatal Invalid Region!![ID:11][ObjName128:¹ö·ÁÁø¸¶À»] 2012-09-29 00:43:59 688
fatal Invalid Region!![ID:12][ObjName128:¾çÄ¡±â¸¶À»] 2012-09-29 00:43:59 688
fatal Invalid Region!![ID:13][ObjName128:¹Ù¶÷ÀǸ¶À»] 2012-09-29 00:43:59 689
fatal Invalid Region!![ID:32][ObjName128:Áø½Ã2Ãþ (2ÃþÀÔ±¸)] 2012-09-29 00:43:59 689
fatal Invalid Region!![ID:33][ObjName128:Áø½Ã3Ãþ (3ÃþÀÔ±¸)] 2012-09-29 00:43:59 690
fatal Invalid Region!![ID:38][ObjName128:Áø½Ã4Ãþ (¹é»çÀÔ±¸)] 2012-09-29 00:43:59 691
fatal Invalid Region!![ID:39][ObjName128:¾Ë·º»êµå¸®¾Æ (³²)] 2012-09-29 00:43:59 691
fatal Invalid Region!![ID:40][ObjName128:¾Ë·º»êµå¸®¾Æ (ºÏ)] 2012-09-29 00:43:59 692
fatal Invalid Region!![ID:41][ObjName128:ºÓÀº´ëÁö] 2012-09-29 00:43:59 693
fatal Invalid Region!![ID:42][ObjName128:¼Ò±Ý»ç¸·] 2012-09-29 00:43:59 694
fatal !!! there is no record in this[_RefEventReward] table !!! 2012-09-29 00:43:59 694
fatal !!! there is no record in this[_RefEventRewardItems] table !!! 2012-09-29 00:43:59 695
fatal !!! there is no record in this[_RefUIString_Mt] table !!! 2012-09-29 00:43:59 695
fatal !!! there is no record in this[_RefTriggerVariable] table !!! 2012-09-29 00:43:59 696
notify LoadReferenceData is Successful 2012-09-29 00:43:59 769
notify SetupInstanceDataAccess is Successful 2012-09-29 00:43:59 862
warnning Individual Exp Gain Ratio: 500000 2012-09-29 00:43:59 865
warnning Party Exp Gain Ratio: 750000 2012-09-29 00:43:59 866
warnning Item Drop Ratio: 100000 2012-09-29 00:43:59 866
warnning Gold Drop Amount Factor: 45000 2012-09-29 00:43:59 866
fatal There is no WINTER_EVENT_2009 info !!! is it ok? 2012-09-29 00:43:59 867
fatal At initialize Server, Loading Siege data :: CurrentTax = 516360 2012-09-29 00:43:59 868
fatal At initialize Server, Loading Siege data :: CurrentTax = 0 2012-09-29 00:43:59 869
fatal At initialize Server, Loading Siege data :: CurrentTax = 0 2012-09-29 00:43:59 871
fatal At initialize Server, Loading Siege data :: CurrentTax = 0 2012-09-29 00:43:59 872
notify Siege Fortress Manager is successfully initialized 2012-09-29 00:43:59 873
notify GameWorld Instance Manager initialized 2012-09-29 00:43:59 885
notify Loading GameWorld WorldSet[1] Regions!! 2012-09-29 00:44:00 626
fatal REGIONMGR failed to load 21850(x:90, z:85) region 2012-09-29 00:44:00 626
fatal Create Game World Map Failed!!! GAMEWORLDID[1] 2012-09-29 00:44:00 627
fatal Failed to initialize Map 2012-09-29 00:44:00 627
fatal Failed To Load Initial Resource 2012-09-29 00:44:00 628
fatal Failed To Init Local Data 2012-09-29 00:44:00 628
fatal SR_GameServer is initialized successfully 2012-09-29 00:44:00 629
my _LinkRefRegion
Code:
GO
/****** Object: StoredProcedure [dbo].[_LinkRefRegions] Script Date: 09/29/2012 00:34:39 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[_LinkRefRegions]
AS
--- Blow Query is Each Area and FORT matching ---
declare @China int
declare @West_China int
declare @Oasis_Kingdom int
declare @Eu int
declare @Am int
declare @Ca int
declare @ARABIA_TOWN int
declare @ARABIA_FIELD_01 int
declare @ARABIA_FIELD_02 int
declare @ARABIA_FIELD_02_BOSS int
declare @ARABIA_DUNGEON int
select @China = AssocServer from _RefRegionBindAssocServer where AreaName = 'CHINA'
select @West_China = AssocServer from _RefRegionBindAssocServer where AreaName = 'West_China'
select @Oasis_Kingdom = AssocServer from _RefRegionBindAssocServer where AreaName = 'Oasis_Kingdom'
select @Eu = AssocServer from _RefRegionBindAssocServer where AreaName = 'Eu'
select @Am = AssocServer from _RefRegionBindAssocServer where AreaName = 'Am'
select @Ca = AssocServer from _RefRegionBindAssocServer where AreaName = 'Ca'
select @ARABIA_TOWN = AssocServer from _RefRegionBindAssocServer where AreaName = 'ARABIA_TOWN'
select @ARABIA_FIELD_01 = AssocServer from _RefRegionBindAssocServer where AreaName = 'ARABIA_FIELD_01'
select @ARABIA_FIELD_02 = AssocServer from _RefRegionBindAssocServer where AreaName = 'ARABIA_FIELD_02'
select @ARABIA_FIELD_02_BOSS = AssocServer from _RefRegionBindAssocServer where AreaName = 'ARABIA_FIELD_02_BOSS'
select @ARABIA_DUNGEON = AssocServer from _RefRegionBindAssocServer where AreaName = 'ARABIA_DUNGEON'
update _RefRegionBindAssocServer set AssocServer = @China where AreaName = 'FORT_JA_AREA'
update _RefRegionBindAssocServer set AssocServer = @China where AreaName = 'FORT_BJ_AREA'
update _RefRegionBindAssocServer set AssocServer = @West_China where AreaName = 'FORT_DW_AREA'
update _RefRegionBindAssocServer set AssocServer = @West_China where AreaName = 'FORT_HM_AREA'
update _RefRegionBindAssocServer set AssocServer = @Oasis_Kingdom where AreaName = 'FORT_HT_AREA'
update _RefRegionBindAssocServer set AssocServer = @Eu where AreaName = 'FORT_CT_AREA'
update _RefRegionBindAssocServer set AssocServer = @Am where AreaName = 'FORT_ER_AREA'
update _RefRegionBindAssocServer set AssocServer = @Ca where AreaName = 'FORT_SK_AREA'
begin TRANSACTION
begin
declare @LinkNum int
declare @this_region int
declare @region_x int
declare @region_z int
declare @wRegionID smallint
declare @wTempRID smallint
declare @col_link varchar(256)
declare @query varchar(256)
declare @db_id_to_link smallint
-- clear all existing region link
set @LinkNum = 1
while (@LinkNum <= 10)
begin
set @query = 'update _RefRegion set LinkedRegion_' + cast(@LinkNum as varchar(10)) + ' = 0'
execute (@query)
set @LinkNum = @LinkNum + 1
end
-- loop all region
declare region_cursor CURSOR FOR
select wRegionID
from _RefRegion
OPEN region_cursor
FETCH NEXT FROM region_cursor INTO @wRegionID
WHILE @@FETCH_STATUS = 0
begin
if (@@error = 0 and @wRegionID <> 0)
begin
-- ´øÀüÀº ½ºÅµ!
if (@wRegionID > 0)
begin
set @LinkNum = 8
while (@LinkNum >= 0)
begin
set @region_z = (@wRegionID & 0xff00) / 256
set @region_x = (@wRegionID & 0x0ff)
set @wTempRID = 0;
if (@LinkNum = 0)
begin
set @region_x = @region_x - 1
set @col_link = 'LinkedRegion_1'
end
else if (@LinkNum = 1)
begin
set @region_x = @region_x - 1
set @region_z = @region_z + 1
set @col_link = 'LinkedRegion_2'
end
else if (@LinkNum = 2)
begin
set @region_z = @region_z + 1
set @col_link = 'LinkedRegion_3'
end
else if (@LinkNum = 3)
begin
set @region_x = @region_x + 1
set @region_z = @region_z + 1
set @col_link = 'LinkedRegion_4'
end
else if (@LinkNum = 4)
begin
set @region_x = @region_x + 1
set @col_link = 'LinkedRegion_5'
end
else if (@LinkNum = 5)
begin
set @region_x = @region_x + 1
set @region_z = @region_z - 1
set @col_link = 'LinkedRegion_6'
end
else if (@LinkNum = 6)
begin
set @region_z = @region_z - 1
set @col_link = 'LinkedRegion_7'
end
else if (@LinkNum = 7)
begin
set @region_x = @region_x - 1
set @region_z = @region_z - 1
set @col_link = 'LinkedRegion_8'
end
set @wTempRID = (@region_z & 0x00ff) * 256
set @wTempRID = @wTempRID + (@region_x & 0x00ff)
select @db_id_to_link = wRegionID
from _RefRegion
where wRegionID = @wTempRID
if (@@ROWCOUNT <> 0)
begin
set @query = 'update _RefRegion set ' + @col_link + ' = ' + cast(@db_id_to_link as varchar(10)) + ' where wRegionID = ' + cast(@wRegionID as varchar(10))
end
else -- Á¸ÀçÇÏÁö ¾Ê´Â region link ´Â 0À¸·Î ä¿î´Ù
begin
set @query = 'update _RefRegion set ' + @col_link + ' = 0 where wRegionID = ' + cast(@wRegionID as varchar(10))
end
execute(@query)
set @LinkNum = @LinkNum - 1
end
end
end
FETCH NEXT FROM region_cursor INTO @wRegionID
end
CLOSE region_cursor
DEALLOCATE region_cursor
COMMIT TRANSACTION
end
"Data Folder" inside DB Files. Need be added the navmesh. :sleep:
Re: adding arabia map final problem
"Data Folder" inside DB Files. Need be added the navmesh.
What folders i need to add them?
Just one folder or more in datebase folder?
- - - Updated - - -
Who wanna help me