[4 Hints] Adding new maps

[Nah001]

Hint: '-' codes shouldnt be added into the ref start table

_RefInstance_World_Region
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

[Kemo]

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.

[Nah001]

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

[mariustopor]

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!!!

[sladlejrhfpq]

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!!!

USE SRO_VT_SHARD_INIT
exec _LinkRefRegions

[mariustopor]

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

[MGProjects]

hmmm this problem i get when i open gameserver

also i clicked on execte for _LinkRefRegions and back to open it again to see the effect
but didnt found the jupiter ^^
i did something wrong?

i have same problem..someone can say me how fix it?

[TryToMakeServer]

Last Hint#:
Ksro full updated media.pk2 = _RefRegion.txt
exec _LinkRefRegions
But modify it, before you execute it xD

[mariustopor]

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

[Nah001]

Last Hint#:
Ksro full updated media.pk2 = _RefRegion.txt
exec _LinkRefRegions
But modify it, before you execute it xD

Can you answer about this table plz _RefInstance_World_Region ?
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

[TryToMakeServer]

if i'm not add world and regionid to there gameserver not loading those maps

it does not need to be added there?

yep, look at the error :D

[saxz]

nth work -.-
keep get same error lol

[dezner]

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]

[Nah001]

Last Hint#:
Ksro full updated media.pk2 = _RefRegion.txt
exec _LinkRefRegions
But modify it, before you execute it xD

need modify stored procedure ? it's autofilling JUPITER LinkRegions without modify
maybe this wrong, but i checked it filling right


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

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 

[mariustopor]

if you could find the region links for all the jupiter flours it would be great!!