i have this problem that annoys me he it is
my _LinkRefRegionCode: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
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
Reply With Quote
Originally Posted by InsaneDev
