Printable View
_RefInstance_World_RegionQuote:
Originally Posted by TryToMakeServer
im talking about this table
90 worldid region with many regionid's
added them as 90 22219 ...
this map working
same with others worldid's
or it does not need to be added to this table at all? for start load maps in gameserver
i do all this steps and all done except _RefInstance_World_Start_Pos i don't know how to add the codes and how i can get them.
Teleported to this fkn jupiter dungeon Hall Of worship but client crashed after loading screen
guess i added wrong start pos ..or too much of them lol
as far as i can see...we are missing the linkedregions1 to 10 in the refregion table...because they cant be found in media pk:)...and i think thats why li sent us to look in a stored procedure...or you are talking about more procedures?:)
more hints please!!!:thumbup:
USE SRO_VT_SHARD_INITQuote:
Originally Posted by mariustopor
exec _LinkRefRegions
i mean the linked regions for jupiter:)...
Btw i need world id's from jupiter....are they...86,87,88,89,90,91(notsure),93,94'?
Posted via Mobile Device
i have same problem..someone can say me how fix it?Quote:
Originally Posted by saxz
Last Hint#:
Ksro full updated media.pk2 = _RefRegion.txt
exec _LinkRefRegions
But modify it, before you execute it xD
ty li...i love you:x...ill try tommorrow and see if i can succed:d....already added all the regions from that txt...the last thing to do is to modify the procedure:)..i think i looked before there..but didnt notice what should i modify...anyway dont tell...i want tomorrow to succed:d:)...btw...in refinstancegameworld...or smthing like that..we should add something:d?
Posted via Mobile Device
Can you answer about this table plz _RefInstance_World_Region ?Quote:
Originally Posted by TryToMakeServer
if i'm not add world and regionid to there gameserver not loading those maps
it does not need to be added there?
adding txt to mssql is easy... like with program txttosql
yep, look at the error :DQuote:
if i'm not add world and regionid to there gameserver not loading those maps
it does not need to be added there?
nth work -.-
keep get same error lol
http://img687.imageshack.us/img687/9492/unledmnr.png
Code:2011-11-07 19:48:59 [SR_GameServer] CGObj::EnterWorld Failed!!! at ResolveCellAndHeight() GAMEWORLDID[90,1], Pos(253.000,-204.000,1519.000)
2011-11-07 19:48:59 [SR_GameServer] CGame::EnterWorld() => CGObj::EnterWorld() Failed!!! Parafuso [JID:2, CharID:2][rid: 0x5bca(x:202, y:91)][worldid : 90, pos: 253.000, -204.000, 1519.000]
2011-11-07 19:49:28 [SR_GameServer] CGObj::EnterWorld Failed!!! at ResolveCellAndHeight() GAMEWORLDID[90,1], Pos(253.000,-204.000,1519.000)
2011-11-07 19:49:28 [SR_GameServer] CGame::EnterWorld() => CGObj::EnterWorld() Failed!!! Suellen [JID:45, CharID:37][rid: 0x5bca(x:202, y:91)][worldid : 90, pos: 253.000, -204.000, 1519.000]
need modify stored procedure ? it's autofilling JUPITER LinkRegions without modifyQuote:
Originally Posted by TryToMakeServer
maybe this wrong, but i checked it filling right
http://forum.ragezone.com/attachment...1&d=1320819138
someone have any idea what need modify in it lol ?
i tried adding Jupiter and effect same, map not loading if i'm not add manual
WorldID and RegionID to _RefInstance_World_Region table
PHP Code: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
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'
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
if you could find the region links for all the jupiter flours it would be great!!