>>>>>>>>>> TheRock2007 <<<<<<<<<<
_RefEventZone_RefRegionBindAssocServer
1 342 POS_STRUCTURE_ARABIA_CITY_SOUTH_01 OBJECT 4 2 0 0 0 STRUCTURE_ARABIA_CITY_SOUTH_01 xxx xxx xxx xxx 1 343 POS_STRUCTURE_ARABIA_CITY_SOUTH_02 OBJECT 4 2 0 0 0 STRUCTURE_ARABIA_CITY_SOUTH_02 xxx xxx xxx xxx 1 344 POS_STRUCTURE_ARABIA_CITY_SOUTH_03 OBJECT 4 2 0 0 0 STRUCTURE_ARABIA_CITY_SOUTH_03 xxx xxx xxx xxx 1 345 POS_STRUCTURE_ARABIA_CITY_SOUTH_04 OBJECT 4 2 0 0 0 STRUCTURE_ARABIA_CITY_SOUTH_04 xxx xxx xxx xxx 1 346 POS_STRUCTURE_ARABIA_CITY_SOUTH_05 OBJECT 4 2 0 0 0 STRUCTURE_ARABIA_CITY_SOUTH_05 xxx xxx xxx xxx 1 347 POS_STRUCTURE_ARABIA_CITY_SOUTH_06 OBJECT 4 2 0 0 0 STRUCTURE_ARABIA_CITY_SOUTH_06 xxx xxx xxx xxx 1 348 POS_STRUCTURE_ARABIA_CITY_WEST_01 OBJECT 4 2 0 0 0 STRUCTURE_ARABIA_CITY_WEST_01 xxx xxx xxx xxx 1 349 POS_STRUCTURE_ARABIA_CITY_WEST_02 OBJECT 4 2 0 0 0 STRUCTURE_ARABIA_CITY_WEST_02 xxx xxx xxx xxx 1 350 POS_STRUCTURE_ARABIA_CITY_WEST_03 OBJECT 4 2 0 0 0 STRUCTURE_ARABIA_CITY_WEST_03 xxx xxx xxx xxx 1 351 POS_STRUCTURE_ARABIA_CITY_WEST_04 OBJECT 4 2 0 0 0 STRUCTURE_ARABIA_CITY_WEST_04 xxx xxx xxx xxx 1 352 POS_STRUCTURE_ARABIA_CITY_WEST_05 OBJECT 4 2 0 0 0 STRUCTURE_ARABIA_CITY_WEST_05 xxx xxx xxx xxx 1 353 POS_STRUCTURE_ARABIA_CITY_WEST_06 OBJECT 4 2 0 0 0 STRUCTURE_ARABIA_CITY_WEST_06 xxx xxx xxx xxx 1 354 POS_STRUCTURE_ARABIA_CITY_WEST_07 OBJECT 4 2 0 0 0 STRUCTURE_ARABIA_CITY_WEST_07 xxx xxx xxx xxx 1 355 POS_STRUCTURE_ARABIA_CITY_WEST_08 OBJECT 4 2 0 0 0 STRUCTURE_ARABIA_CITY_WEST_08 xxx xxx xxx xxx 1 356 POS_STRUCTURE_ARABIA_CITY_NORTH_01 OBJECT 4 2 0 0 0 STRUCTURE_ARABIA_CITY_NORTH_01 xxx xxx xxx xxx 1 357 POS_STRUCTURE_ARABIA_CITY_NORTH_02 OBJECT 4 2 0 0 0 STRUCTURE_ARABIA_CITY_NORTH_02 xxx xxx xxx xxx 1 358 POS_STRUCTURE_ARABIA_CITY_NORTH_03 OBJECT 4 2 0 0 0 STRUCTURE_ARABIA_CITY_NORTH_03 xxx xxx xxx xxx 1 359 POS_STRUCTURE_ARABIA_CITY_NORTH_04 OBJECT 4 2 0 0 0 STRUCTURE_ARABIA_CITY_NORTH_04 xxx xxx xxx xxx 1 360 POS_STRUCTURE_ARABIA_CITY_EAST_01 OBJECT 4 2 0 0 0 STRUCTURE_ARABIA_CITY_EAST_01 xxx xxx xxx xxx 1 361 POS_STRUCTURE_ARABIA_CITY_EAST_02 OBJECT 4 2 0 0 0 STRUCTURE_ARABIA_CITY_EAST_02 xxx xxx xxx xxx 1 362 POS_STRUCTURE_ARABIA_CITY_EAST_03 OBJECT 4 2 0 0 0 STRUCTURE_ARABIA_CITY_EAST_03 xxx xxx xxx xxx 1 363 POS_STRUCTURE_ARABIA_CITY_EAST_04 OBJECT 4 2 0 0 0 STRUCTURE_ARABIA_CITY_EAST_04 xxx xxx xxx xxx 1 364 POS_STRUCTURE_ARABIA_CITY_EAST_05 OBJECT 4 2 0 0 0 STRUCTURE_ARABIA_CITY_EAST_05 xxx xxx xxx xxx 1 365 POS_STRUCTURE_ARABIA_CITY_EAST_06 OBJECT 4 2 0 0 0 STRUCTURE_ARABIA_CITY_EAST_06 xxx xxx xxx xxx 1 366 POS_STRUCTURE_ARABIA_CITY_EAST_07 OBJECT 4 2 0 0 0 STRUCTURE_ARABIA_CITY_EAST_07 xxx xxx xxx xxx 1 367 POS_STRUCTURE_ARABIA_CITY_MIDDLE_01 OBJECT 4 2 0 0 0 STRUCTURE_ARABIA_CITY_MIDDLE_01 xxx xxx xxx xxx 1 368 POS_STRUCTURE_ARABIA_CITY_MIDDLE_02 OBJECT 4 2 0 0 0 STRUCTURE_ARABIA_CITY_MIDDLE_02 xxx xxx xxx xxx 1 369 POS_STRUCTURE_ARABIA_CITY_MIDDLE_03 OBJECT 4 2 0 0 0 STRUCTURE_ARABIA_CITY_MIDDLE_03 xxx xxx xxx xxx 1 370 POS_STRUCTURE_ARABIA_CITY_MIDDLE_04 OBJECT 4 2 0 0 0 STRUCTURE_ARABIA_CITY_MIDDLE_04 xxx xxx xxx xxx
>>>>>>>>>> TheRock2007 <<<<<<<<<<
_RefGame_World>>>>>>>>>> TheRock2007 <<<<<<<<<<
112 INS_ARABIA_DUNGEON 1 100 8 0 0 0 10800000 600000 GROUP_ARABIA_DUNGEON 113 INS_ARABIA_FIELD_02_BOSS 1 100 8 0 0 0 10800000 600000 GROUP_ARABIA_FIELD_02_BOSS 114 INS_ARABIA_PETRA 1 100 8 0 0 0 0 0 GROUP_ARABIA_PETRA 115 INS_ARABIA_GARDEN 1 100 8 0 0 0 0 0 GROUP_ARABIA_GARDEN 116 INS_SURVIVAL_COLOSSEUM 1 200 20 0 0 0 0 0 GROUP_SURVIVAL_COLOSSEUM 117 INS_SURVIVAL_DESERT 1 200 30 0 0 0 0 0 GROUP_SURVIVAL_DESERT 118 INS_SURVIVAL_PALACE 1 200 50 0 0 0 0 0 GROUP_SURVIVAL_PALACE
_RefGame_World_Config>>>>>>>>>> TheRock2007 <<<<<<<<<<
1 937 GROUP_ARABIA_DUNGEON GAME_WORLD_NORMALIZE_TYPE GAME_WORLD_NORMALIZE_TYPE_A STRING 1 938 GROUP_ARABIA_DUNGEON ENTER_LIMIT_CONDITION_LEVEL_MINIMUM_NUM 123 INT32 1 939 GROUP_ARABIA_DUNGEON GAMEWORLD_DISAPPEARANCE_TIME 1800000 INT32 1 940 GROUP_ARABIA_DUNGEON GAMEWORLD_DISAPPEARANCE_TIME 1200000 INT32 1 941 GROUP_ARABIA_DUNGEON GAMEWORLD_DISAPPEARANCE_TIME 600000 INT32 1 942 GROUP_ARABIA_DUNGEON GAMEWORLD_DISAPPEARANCE_TIME 300000 INT32 1 943 GROUP_ARABIA_DUNGEON DUNGEON_TICKET ITEM_CODE(???? ??) STRING 1 944 GROUP_ARABIA_DUNGEON ENTER_LIMIT_CONDITION_ENTRY_MAXIMUM_NUM 3 INT32 1 945 GROUP_ARABIA_DUNGEON ENTER_LIMIT_CONDITION_FRPVP_VOUCHER_TAKE_OFF ON STRING 1 946 GROUP_ARABIA_DUNGEON ENTERWORLD_LIMIT_CONDITION_FLEAMARKET ON STRING 1 947 GROUP_ARABIA_DUNGEON ENTER_LIMIT_CONDITION_RIDE_COS_NOT_RIDING ON STRING 1 948 GROUP_ARABIA_DUNGEON ENTER_LIMIT_CONDITION_TRADE_COS_NOT_RIDING ON STRING 1 949 GROUP_ARABIA_DUNGEON CONTROL_NOTIFY_SPAWN_UNIQUE_MONSTER_MSG ON STRING 1 950 GROUP_ARABIA_DUNGEON ENTER_LIMIT_CONDITION_REENTRY ON STRING 1 951 GROUP_ARABIA_DUNGEON ENTER_LIMIT_CONDITION_JOB_CLOTHES_TAKE_OFF ON STRING 1 952 GROUP_ARABIA_DUNGEON ENTER_LIMIT_CONDITION_PARTY ON STRING 1 953 GROUP_ARABIA_DUNGEON ENTERWORLD_LIMIT_CONDITION_TRADE ON STRING 1 954 GROUP_ARABIA_FIELD_02_BOSS GAME_WORLD_NORMALIZE_TYPE GAME_WORLD_NORMALIZE_TYPE_A STRING 1 955 GROUP_ARABIA_FIELD_02_BOSS ENTER_LIMIT_CONDITION_LEVEL_MINIMUM_NUM 123 INT32 1 956 GROUP_ARABIA_FIELD_02_BOSS GAMEWORLD_DISAPPEARANCE_TIME 1800000 INT32 1 957 GROUP_ARABIA_FIELD_02_BOSS GAMEWORLD_DISAPPEARANCE_TIME 1200000 INT32 1 958 GROUP_ARABIA_FIELD_02_BOSS GAMEWORLD_DISAPPEARANCE_TIME 600000 INT32 1 959 GROUP_ARABIA_FIELD_02_BOSS GAMEWORLD_DISAPPEARANCE_TIME 300000 INT32 1 960 GROUP_ARABIA_FIELD_02_BOSS DUNGEON_TICKET ITEM_CODE(???? ??) STRING 1 961 GROUP_ARABIA_FIELD_02_BOSS ENTER_LIMIT_CONDITION_ENTRY_MAXIMUM_NUM 3 INT32 1 962 GROUP_ARABIA_FIELD_02_BOSS ENTER_LIMIT_CONDITION_FRPVP_VOUCHER_TAKE_OFF ON STRING 1 963 GROUP_ARABIA_FIELD_02_BOSS ENTERWORLD_LIMIT_CONDITION_FLEAMARKET ON STRING 1 964 GROUP_ARABIA_FIELD_02_BOSS ENTER_LIMIT_CONDITION_RIDE_COS_NOT_RIDING ON STRING 1 965 GROUP_ARABIA_FIELD_02_BOSS ENTER_LIMIT_CONDITION_TRADE_COS_NOT_RIDING ON STRING 1 966 GROUP_ARABIA_FIELD_02_BOSS CONTROL_NOTIFY_SPAWN_UNIQUE_MONSTER_MSG ON STRING 1 967 GROUP_ARABIA_FIELD_02_BOSS ENTER_LIMIT_CONDITION_REENTRY ON STRING 1 968 GROUP_ARABIA_FIELD_02_BOSS ENTER_LIMIT_CONDITION_JOB_CLOTHES_TAKE_OFF ON STRING 1 969 GROUP_ARABIA_FIELD_02_BOSS ENTER_LIMIT_CONDITION_PARTY ON STRING 1 970 GROUP_ARABIA_FIELD_02_BOSS ENTERWORLD_LIMIT_CONDITION_TRADE ON STRING
_RefInstance_World_Region>>>>>>>>>> TheRock2007 <<<<<<<<<<
1 21850 1 22104 1 22105 1 22106 1 22107 1 22108 1 22109 1 22360 1 22361 1 22362 1 22363 1 22364 1 22365 1 22616 1 22617 1 22618 1 22619 1 22620 1 22621 1 22622 1 22872 1 22873 1 22874 1 22875 1 22876 1 22877 112 23378 112 23379 112 23380 112 23381 112 23382 112 23634 112 23635 112 23636 112 23637 112 23638 112 23890 112 23891 112 23892 112 23893 112 23894 112 24146 112 24147 112 24148 112 24149 112 24150 113 -32743 113 18767 113 18768 113 18769 113 18770 113 19023 113 19024 113 19025 113 19026 113 19279 113 19280 113 19281 113 19282 113 19535 113 19536 113 19537 113 19538 113 19791 113 19792 113 19793 113 19794 113 20047 113 20048 113 20049 113 20050 113 20303 113 20304 113 20305 113 20306 113 20559 113 20560 113 20561 113 20562 113 20815 113 20816 113 20817 113 20818 113 22098 113 22099 113 22100 113 22101 113 22102 113 22103 113 22354 113 22355 113 22356 113 22357 113 22358 113 22359 113 22610 113 22611 113 22612 113 22613 113 22614 113 22615 113 22866 113 22867 113 22868 113 22869 113 22870 113 22871
ARABIA_TOWN_01 1
>>>>>>>>>> TheRock2007 <<<<<<<<<<_LinkRefRegions
set ANSI_NULLS OFF
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 @JUPITER int
declare @ARABIA_TOWN 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 @JUPITER = AssocServer from _RefRegionBindAssocServer where AreaName = 'JUPITER'
select @ARABIA_TOWN= AssocServer from _RefRegionBindAssocServer where AreaName = 'TOWN_ARABIA'
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'
update _RefRegionBindAssocServer set AssocServer = @JUPITER where AreaName = 'JUPITER'
update _RefRegionBindAssocServer set AssocServer = @ARABIA_TOWN where AreaName = 'TOWN_ARABIA'
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
>>>>>>>>>> TheRock2007 <<<<<<<<<<
USE [SRO_VT_SHARD]
exec _LinkRefRegions
>>>>>>>>>> TheRock2007 <<<<<<<<<<
i have code wrong please help. :blink:
:lol: administrator no Delete my TOPICAL :lol:
