I do all the things,But not loaded Map
Printable View
I do all the things,But not loaded Map
how edit _LinkRefRegions is good??
teleportQuote:
Originally Posted by djoctan
linkPHP Code:1 250 GATE_AR 43642 SN_GATE_AR 22618 1075 -236 323 50 1 0 1
1 251 GATE_AR_M 43643 SN_NPC_AR_GATE_04 22618 1287 -236 36 50 0 0 1
1 252 GATE_AR_N 43644 SN_NPC_AR_GATE_02 22874 1798 -430 835 50 0 0 1
1 253 GATE_AR_W 43645 SN_NPC_AR_GATE_01 22617 724 -431 481 50 0 0 1
1 254 GATE_AR_S 43646 SN_NPC_AR_GATE_03 22106 1316 -432 832 50 0 0 1
1 255 GATE_KARK_TO_MONG 43647 SN_STORE_KARKPORTAL 22101 750 0 300 50 0 0 1
1 256 GATE_MONG_TO_KARK 43648 SN_STORE_MONGPORTAL 20815 332 229 514 50 0 0 1
1 257 GATE_MONG_TO_BOSS 43649 SN_STORE_MONGPORTAL 18769 961 -341 574 50 0 0 1
1 258 GATE_ARABIA_DUNGEON_START 43650 SN_NPC_AR_DSTARTPORTAL 23636 1577 -430 1105 50 0 0 112
1 259 GATE_ARABIA_DUNGEON_END 43651 SN_NPC_AR_DSTARTPORTAL 23891 959 -236 527 50 0 0 112
1 260 GATE_BOSS_TO_MONG 43652 SN_STORE_BOSSPORTAL -32743 0 7 360 30 0 0 113
PHP Code:1 1 250 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1 250 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
MGProjects
you can pos your _LinkRefRegions pls??thanks
Thx@MGProjects
-:-)
what wrong??
Attachment 115084
atal CGObj::EnterWorld Failed!!! at ResolveCellAndHeight() GAMEWORLDID[1,1], Pos(1075.000,-236.000,323.000) 2012-10-07 21:39:17 791
fatal CGame::EnterWorld() => CGObj::EnterWorld() Failed!!! XX [JID:1, CharID:7384][rid: 0x585a(x:90, y:88)][worldid : 1, pos: 1075.000, -236.000, 323.000] 2012-10-07 21:39:17 793
fatal Char Login Failed(Invalid Pos): XX 2012-10-07 21:39:17 794
warnning SR_READY_TO_PLAY, Game::EnterWorld() failed!! [JID: 1] 2012-10-07 21:39:17 799
Quote:
Originally Posted by nemo07
Whenever I add even 1 line to the reftelelink it get overlap error on shard. Did you fix that or just skip it?
Did you add the Ref teleport lines and the Refobjcommon lines ?Quote:
Originally Posted by SL1MSH4DY
Yes they are added and gameserver loads fine until I try to add the reftelelink linesQuote:
Originally Posted by nemo07
plz notify Loading GameWorld WorldSet[1] Regions!! 2012-10-08 05:40:55 032
fatal REGIONMGR failed to load 21850(x:90, z:85) region 2012-10-08 05:40:55 032
fatal Create Game World Map Failed!!! GAMEWORLDID[1] 2012-10-08 05:40:55 032
fatal Failed to initialize Map 2012-10-08 05:40:55 032
fatal Failed To Load Initial Resource 2012-10-08 05:40:55 032
fatal Failed To Init Local Data 2012-10-08 05:40:55 032
fatal SR_GameServer is initialized successfully 2012-10-08 05:40:55 032
Quote:
Originally Posted by nemo07
HELP MEQuote:
Originally Posted by MGProjects
notify Loading GameWorld WorldSet[1] Regions!! 2012-10-08 05:40:55 032
fatal REGIONMGR failed to load 21850(x:90, z:85) region 2012-10-08 05:40:55 032
fatal Create Game World Map Failed!!! GAMEWORLDID[1] 2012-10-08 05:40:55 032
fatal Failed to initialize Map 2012-10-08 05:40:55 032
fatal Failed To Load Initial Resource 2012-10-08 05:40:55 032
fatal Failed To Init Local Data 2012-10-08 05:40:55 032
fatal SR_GameServer is initialized successfully 2012-10-08 05:40:55 032
Well I was able to run around the city after putting my cords to 22618 1075 -236 323 and only adding and enabling ARABIA_TOWN. Then I added the other areas to RefRegionBindAssocServer and the game server would not load so I changed all RefInstance_World_Region ID's to 1. I ran MGProjects query back some pages and executed LinkRefRegion again and now the gameserver loads all regions when enabled. Now whats funny is when I log into the town with cords 22618 1075 -236 323 I get instant DC. :D
Edit: Well the problem with me seems that my gm name char gets DC there. I made a new char on same account and put his cords there and it works lol
Can we compile a list of warp points that will take you to the different areas?
/warp 22618 1075 -236 323 - Arabia Town 1
What's this town?
http://i66.photobucket.com/albums/h2...ann05/what.jpg
hereQuote:
Originally Posted by wang0788
PHP Code:USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_LinkRefRegions] Script Date: 10/08/2012 01:11:49 ******/
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_DUNGEON int
---declare @ARABIA_FIELD_02_BOSS int
---declare @ARABIA_FIELD_01 int
---declare @ARABIA_FIELD_02 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_DUNGEON = AssocServer from _RefRegionBindAssocServer where AreaName = 'ARABIA_DUNGEON'
---select @ARABIA_FIELD_02_BOSS = AssocServer from _RefRegionBindAssocServer where AreaName = 'ARABIA_FIELD_02_BOSS'
---select @ARABIA_FIELD_01 = AssocServer from _RefRegionBindAssocServer where AreaName = 'ARABIA_FIELD_01'
---select @ARABIA_FIELD_02 = AssocServer from _RefRegionBindAssocServer where AreaName = 'ARABIA_FIELD_02'
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 = @ARABIA_TOWN where AreaName = 'ARABIA_TOWN'
---update _RefRegionBindAssocServer set AssocServer = @ARABIA_DUNGEON where AreaName = 'ARABIA_DUNGEON'
---update _RefRegionBindAssocServer set AssocServer = @ARABIA_FIELD_02_BOSS where AreaName = 'ARABIA_FIELD_02_BOSS'
---update _RefRegionBindAssocServer set AssocServer = @ARABIA_FIELD_01 where AreaName = 'ARABIA_FIELD_01'
---update _RefRegionBindAssocServer set AssocServer = @ARABIA_FIELD_02 where AreaName = 'ARABIA_FIELD_02'
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
_RefRegionBindAssocServerQuote:
Originally Posted by SL1MSH4DY
about DC.. Try disable all Teleport from Arabia in RefTeleport and tryPHP Code:ARABIA_TOWN 1
ARABIA_FIELD_01 1
ARABIA_FIELD_02 1
ARABIA_FIELD_02_BOSS 1
ARABIA_DUNGEON 1
Put _RefInstance_World_Region originals ID'sQuote:
Originally Posted by 314138320
and use my _LinkRefRegions and _RefRegionBindAssocServer
go in _RefGame_World check in 113 Type=0
NP :)Quote:
Originally Posted by djoctan
you dont need any stored shit BTW
I still have this issue.Quote:
Originally Posted by SL1MSH4DY
What warp gets me to dungeon and other areas?
you get overlap cuz you add a link that dont have dataQuote:
Originally Posted by SL1MSH4DY
when i do the dungeon warp i go to another town LOL
