السلام عليكم
نبتدي على طول
Go Sro_vt_shard
وفتح ال بتعتك tablts
_RefEventZone
هتضيف
كود PHP:
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
بعد كدة روح _RefGame_World
add
كود PHP:
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
add
كود PHP:
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
add
كود PHP:
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
بعد كدة روح _RefRegionBindAssocServer
كود PHP:
ARABIA_TOWN_01 1
بعد كدة روح _LinkRefRegions
add
كود PHP:
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
ده كدة شغال بنسبة 95% عن تجربة وsoon هاجيب جزء الميديا 
01-10-2012, 09:26 PM
المواضيع المتشابهه
.gif){kind=icon}
العرض الشجري