Gngwc Room

05/10/2012 23:25 LegendM#1
Hello guys I want add my gngwc room to my server
[Only registered and activated users can see links. Click Here To Register...]
Here's the picture

I get coord. from pic so I created warp using
[Only registered and activated users can see links. Click Here To Register...]

And I put this things to char tb.
/warp Region /x/y/z

When I select char.I get error server is not running
Here's the refbinassoc table
PHP Code:
CHINA    0
TQ    0
West_China    1
Oasis_Kingdom    0
Thief Village    1
Roc    0
Eu    0
Am    0
Ca    0
SD    0
KingsValley    0
Pharaoh    0
DELTA    0
TEMPLE    0
FORT_JA_AREA    0
FORT_DW_AREA    0
FORT_HT_AREA    0
FORT_CT_AREA    0
FORT_SK_AREA    0
FORT_BJ_AREA    0
FORT_HM_AREA    0
FORT_ER_AREA    0
ARENA_OCCUPY    1
ARENA_FLAG    1
ARENA_SCORE    1
SIEGE_DUNGEON    1
ARENA_GNGWC    1
GOD_TOGUI    0
GOD_WRECK_IN    0
GOD_FLAME    0
GOD_WRECK_OUT    0
EVENT_GHOST    0
JUPITER    0
PRISON    0
GM_EVENT    1
NULL    NULL 
So what's wrong?
05/10/2012 23:30 Neko*#2
Check the RefReigon table , and make sure all exist there , cuz i think it is not ready since vsro is a Test files and if it success and you were teleported to a empty place , then update your Map.pk2.
you can get the GNGWC files from it's client , or Creddy Map.pk2 , and i think it is also exist in server files data folder :D

GL
05/10/2012 23:32 rushcrush#3
ofc RefReigon table dont have the lines for Gngwc lol
you can get this lines from isro client Gngwc(from Reigon.text) GL in getting them xD
i want to have them too
but i cant find working link for Gngwc isro client
05/10/2012 23:33 LegendM#4
Quote:
Originally Posted by Neko* View Post
Check the RefReigon table , and make sure all exist there , cuz i think it is not ready since vsro is a Test files and if it success and you were teleported to a empty place , then update your Map.pk2.
you can get the GNGWC files from it's client , or Creddy Map.pk2 , and i think it is also exist in server files data folder :D

GL
I already checked refregion.There's no service or something like that.And I think it's already have visual files in test client

Quote:
Originally Posted by rushcrush View Post
ofc RefReigon table dont have the lines for Gngwc lol
you can get this lines from isro client Gngwc(from Reigon.text) GL in getting them xD
i want to have them too
but i cant find working link for Gngwc isro client
Lets try credy online client then :)
05/10/2012 23:34 Neko*#5
I think creddy have this lines , isn't the screen shot from creddy ?
they activated it , i think lines should match ^^
05/10/2012 23:39 LegendM#6
Yea,I think so anyway I'll try tomorrow
05/10/2012 23:40 rushcrush#7
Quote:
Originally Posted by LegendM View Post
I already checked refregion.There's no service or something like that.And I think it's already have visual files in test client



Lets try credy online client then :)
no server have it
in this pic not GNGWC lol
it's arena
05/10/2012 23:40 ✗EpicSoul✗#8
you know there is a stored procedure which adds the regions from the regioninfo.txt from the server files.

here it is :

Code:
USE [SRO_VT_SHARD]
GO
<-- for epvpers from epicsoul :)--->
/****** Object:  StoredProcedure [dbo].[_InsertRefRegion]    Script Date: 05/10/2012 22:45:19 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER    PROCEDURE [dbo].[_InsertRefRegion]
@RegionID		as smallint,
@X_NotUsed		as int,
@Z_NotUsed		as int,
@Continent		as varchar(128),
@AreaName		as varchar(128),
@IsBattleField		as tinyint,
@ClimateID		as int,
@Capacity		as int
as
begin transaction
begin
	declare @_x	tinyint
	declare @_z	tinyint
	if (@RegionID > 0)
	begin
		set @_x = @RegionID % 256
		set @_z = @RegionID / 256
	end
	else
	begin
		set @_x = 0
		set @_z = 0
	end
	if (exists(select wRegionID from _RefRegion where wRegionID = @RegionID))
	begin
		update _RefRegion 
		set 	X = @_x, Z = @_z, ContinentName = @Continent, AreaName = @AreaName, IsBattleField = @IsBattleField,
			Climate = @ClimateID, MaxCapacity = @Capacity, AssocObjID = 0,
		<-- insert the refregion path here-->
			AssocFile256 = 'xxx'
		where wRegionID = @RegionID
	end
	else
	begin
		insert into _RefRegion(wRegionID, X, Z, ContinentName, AreaName, IsBattleField, Climate, MaxCapacity, AssocObjID, AssocServer, AssocFile256)
		values (@RegionID, @_x, @_z, @Continent, @AreaName, @IsBattleField, @ClimateID, @Capacity, 0, 0, 'xxx')
	end
	
 	if (@@error <> 0)
	begin
		raiserror('리젼정보 추가 [혹은 갱신] 실패했다! [RID: %d]' ,  1, 16, @RegionID)
		rollback transaction
		return
	end
	commit transaction
end
05/10/2012 23:44 Neko*#9
Quote:
Originally Posted by rushcrush View Post
no server have it
in this pic not GNGWC lol
it's arena
no , GNGWC use same pattern , tiles , and texture of Battle arena.

btw creddy have it , you can check here , the pyramid design area ...

Quote:
Originally Posted by ✗EpicSoul✗ View Post
you know there is a stored procedure which adds the regions from the regioninfo.txt from the server files.

here it is :
is is just .... :awesome: :awesome:
05/10/2012 23:48 LegendM#10
Quote:
Originally Posted by ✗EpicSoul✗ View Post
you know there is a stored procedure which adds the regions from the regioninfo.txt from the server files.

here it is :

Code:
USE [SRO_VT_SHARD]
GO
<-- for epvpers from epicsoul :)--->
/****** Object:  StoredProcedure [dbo].[_InsertRefRegion]    Script Date: 05/10/2012 22:45:19 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER    PROCEDURE [dbo].[_InsertRefRegion]
@RegionID		as smallint,
@X_NotUsed		as int,
@Z_NotUsed		as int,
@Continent		as varchar(128),
@AreaName		as varchar(128),
@IsBattleField		as tinyint,
@ClimateID		as int,
@Capacity		as int
as
begin transaction
begin
	declare @_x	tinyint
	declare @_z	tinyint
	if (@RegionID > 0)
	begin
		set @_x = @RegionID % 256
		set @_z = @RegionID / 256
	end
	else
	begin
		set @_x = 0
		set @_z = 0
	end
	if (exists(select wRegionID from _RefRegion where wRegionID = @RegionID))
	begin
		update _RefRegion 
		set 	X = @_x, Z = @_z, ContinentName = @Continent, AreaName = @AreaName, IsBattleField = @IsBattleField,
			Climate = @ClimateID, MaxCapacity = @Capacity, AssocObjID = 0,
		<-- insert the refregion path here-->
			AssocFile256 = 'xxx'
		where wRegionID = @RegionID
	end
	else
	begin
		insert into _RefRegion(wRegionID, X, Z, ContinentName, AreaName, IsBattleField, Climate, MaxCapacity, AssocObjID, AssocServer, AssocFile256)
		values (@RegionID, @_x, @_z, @Continent, @AreaName, @IsBattleField, @ClimateID, @Capacity, 0, 0, 'xxx')
	end
	
 	if (@@error <> 0)
	begin
		raiserror('리젼정보 추가 [혹은 갱신] 실패했다! [RID: %d]' ,  1, 16, @RegionID)
		rollback transaction
		return
	end
	commit transaction
end
thanks for share but i couldnt understand 1 thing.What you mean with regioninfo.txt in server files?client or what ?
05/10/2012 23:49 ✗EpicSoul✗#11
check your servers data folder. you will see what i mean.
05/10/2012 23:51 Neko*#12
Quote:
Originally Posted by LegendM View Post
thanks for share but i couldnt understand 1 thing.What you mean with regioninfo.txt in server files?client or what ?
it will add the regions from server files .. to refregion table , and then you can make a client .txt copy.

just update your server files folder with GNGWC client , data , map PK2[s]
05/10/2012 23:52 LegendM#13
Quote:
Originally Posted by ✗EpicSoul✗ View Post
check your servers data folder. you will see what i mean.
got it.
thank you guys both of you
05/11/2012 00:05 rushcrush#14
Quote:
Originally Posted by Neko* View Post
it will add the regions from server files .. to refregion table , and then you can make a client .txt copy.

just update your server files folder with GNGWC client , data , map PK2[s]
GNGWC client , data , map PK2[s] where?
05/11/2012 00:06 Neko*#15
Quote:
Originally Posted by LegendM View Post
got it.
thank you guys both of you
Great , Keep going , and tell us if you succeeded to add it , please explain your steps ^^

Quote:
Originally Posted by rushcrush View Post
GNGWC client , data , map PK2[s] where?
well i don't have it , and also i am pretty sure it is so hard to get this client ..
i think Creddy client have all the data.pk2 files , and also all the map.pk2 of GNGWC arena , since they activated it , we can get it from it's client i think ! :bandit: