Printable View
now please some1 help me.
i've teleport to town with a warp but after time it crashes, the warp i use teleports me into the teleporter from which i cant move, so i dont know if im able to move in the town or no because im stuck in teleporter object :DD and when i say it crashes, it crashes after specific time, i mean client crashes and the windows 7 pop up shows up that Sro_client.exe stopped working.
heres some screens
Attachment 114903Attachment 114904
I only got a question, do I need to update Data @ Server side (in Server folder) and 9_22 etc?
only folder DataQuote:
Originally Posted by FuriousRage
I've added all data files, but I keep getting this error:Quote:
Originally Posted by MGProjects
This is due to Const fortress, shouldnt it work together with it?Quote:
REGIONMGR failed to load 15194(x:90, z:59) region
Create Game World Map Failed!!! GAMEWORLDID[5]
EDIT: Disabled CONST FW @ RefRegionBindAssocServer, it loads now but it crashes now after loading :S
Quote:
Originally Posted by FuriousRage
client crash?
i got client crash on bagda center, other place i can log normal
check screen:
http://imageshack.us/a/img268/2258/s...0408284517.jpg
in other place i have check dmp files and problem is
res\item\etc\drop_mall_scroll.bsr
CPSMission::OnCreate (0) 0° SR_MYCHARACTER_DATA 0° OnMyCharacterEntered - Start 0° CICPlayer::CICPlayer() 0°I (MGP[1]) ³ªÅ¸³² [90 x 88] [1046.031128,-236.585739,320.289673] [3.499998]QY° ¸®Á¯ °Ç³Ô´Ù.[90 x 88]QY° OnMyCharacterEntered - End
Just open the town for now It will load ;)Quote:
Originally Posted by FuriousRage
Already did, it loads to Region[20] and then it crashes (just closes) :SQuote:
Originally Posted by nemo07
EDIT: RefBindAssocServer:
ARABIA_TOWN_01
ARABIA_DUNGEON
ARABIA_FIELD_01
ARABIA_FIELD_02
ARABIA_FIELD_02_BOSS
@MGProjects
I havent tried client yet, just want the DB side to work first :S
open this only ARABIA_TOWN_01Quote:
Originally Posted by FuriousRage
and make the others 0
I tried it, still aint loading correctly. I'm gonna restore the DB and just add the stuff and see if it works, i wont add dungeon and all thatQuote:
Originally Posted by nemo07
tryQuote:
Originally Posted by FuriousRage
_RefRegionBindAssocServer
ARABIA_TOWN
procedure link
PHP Code:USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_LinkRefRegions] Script Date: 10/04/2012 08:57:30 ******/
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
Ok I've updated the town etc, everything loads, I havent updated Data @ Server yet.
I have added all folders etc "Arabia" but havent updated navemesh, as soon as I seem to update navemesh, I get errors with Const fortress, so any ideas how to fix this? Anyone got Arabia + Const FW working?
Im working already on it till now to make the arabia town full working with Const FW like Myth ^^Quote:
Originally Posted by FuriousRage
This is probably why mine isn't working then. I will try to work it out, we can try to help eachother, I'm not the best but :P do you have msn?Quote:
Originally Posted by nemo07
what wrong??
fatal [CNewTradeManager::_CheckReferenceData] - data needs for New Trade (_RefRegion -> AreaName : TOWN_ARABIA) !! 2012-10-04 21:18:55 017
fatal [CNewTradeManager::Initialize] - CheckRefData failed!!! 2012-10-04 21:18:55 017
fatal Failed to initialize New Trade manager 2012-10-04 21:18:55 017
fatal Failed To Init Local Data 2012-10-04 21:18:55 017
fatal SR_GameServer is initialized successfully
anybody can help with my issue?Quote:
Originally Posted by kankorezis