[Help Thread] Please post your questions here.

Masumichan · 03/30/2022, 17:48

Quote:

Originally Posted by king1king

Can i lunch 9.5 GS whith this table there is way?

[id] int NOT NULL,
[name_id] int NOT NULL,
[tooltip_id] int NOT NULL,
[type] int NOT NULL,
[group] int NOT NULL,
[class] int NOT NULL,
[wear_type] int NOT NULL,
[set_id] int NOT NULL,
[set_part_flag] int NOT NULL,
[grade] tinyint NOT NULL,
[rank] int NOT NULL,
[level] int NOT NULL,
[enhance] int NOT NULL,
[socket] int NOT NULL,
[status_flag] int NOT NULL,
[limit_deva] char(1) COLLATE Korean_Wansung_CI_AS NOT NULL,
[limit_asura] char(1) COLLATE Korean_Wansung_CI_AS NOT NULL,
[limit_gaia] char(1) COLLATE Korean_Wansung_CI_AS NOT NULL,
[job_depth] tinyint NOT NULL,
[limit_fighter] char(1) COLLATE Korean_Wansung_CI_AS NOT NULL,
[limit_hunter] char(1) COLLATE Korean_Wansung_CI_AS NOT NULL,
[limit_magician] char(1) COLLATE Korean_Wansung_CI_AS NOT NULL,
[limit_summoner] char(1) COLLATE Korean_Wansung_CI_AS NOT NULL,
[use_min_level] int NOT NULL,
[use_max_level] int NOT NULL,
[target_min_level] int NOT NULL,
[target_max_level] int NOT NULL,
[range] decimal(10,2) NOT NULL,
[weight] decimal(10,2) NOT NULL,
[price] int NOT NULL,
[huntaholic_point] int NOT NULL,
[arena_point] int NOT NULL,
[ethereal_durability] int NOT NULL,
[endurance] int NOT NULL,
[material] int NOT NULL,
[summon_id] int NOT NULL,
[item_use_flag] int NOT NULL,
[available_period] int NOT NULL,
[decrease_type] tinyint NOT NULL,
[throw_range] decimal(10,2) NOT NULL,
[base_type_0] smallint NOT NULL,
[base_var1_0] decimal(12,2) NOT NULL,
[base_var2_0] decimal(12,2) NOT NULL,
[base_type_1] smallint NOT NULL,
[base_var1_1] decimal(12,2) NOT NULL,
[base_var2_1] decimal(12,2) NOT NULL,
[base_type_2] smallint NOT NULL,
[base_var1_2] decimal(12,2) NOT NULL,
[base_var2_2] decimal(12,2) NOT NULL,
[base_type_3] smallint NOT NULL,
[base_var1_3] decimal(12,2) NOT NULL,
[base_var2_3] decimal(12,2) NOT NULL,
[opt_type_0] smallint NOT NULL,
[opt_var1_0] decimal(12,2) NOT NULL,
[opt_var2_0] decimal(12,2) NOT NULL,
[opt_type_1] smallint NOT NULL,
[opt_var1_1] decimal(12,2) NOT NULL,
[opt_var2_1] decimal(12,2) NOT NULL,
[opt_type_2] smallint NOT NULL,
[opt_var1_2] decimal(12,2) NOT NULL,
[opt_var2_2] decimal(12,2) NOT NULL,
[opt_type_3] smallint NOT NULL,
[opt_var1_3] decimal(12,2) NOT NULL,
[opt_var2_3] decimal(12,2) NOT NULL,
[effect_id] int NOT NULL,
[enhance_id] int NOT NULL,
[skill_id] int NOT NULL,
[state_id] int NOT NULL,
[state_level] int NOT NULL,
[state_time] int NOT NULL,
[cool_time] int NOT NULL,
[cool_time_group] smallint NOT NULL,
[model_type_dem] int NOT NULL,
[model_type_def] int NOT NULL,
[model_type_asm] int NOT NULL,
[model_type_asf] int NOT NULL,
[model_type_gam] int NOT NULL,
[model_type_gaf] int NOT NULL,
[deco_model_change] tinyint NOT NULL,
[model_00] varchar(256) COLLATE Korean_Wansung_CI_AS NOT NULL,
[model_01] varchar(256) COLLATE Korean_Wansung_CI_AS NOT NULL,
[model_02] varchar(256) COLLATE Korean_Wansung_CI_AS NOT NULL,
[model_03] varchar(256) COLLATE Korean_Wansung_CI_AS NOT NULL,
[model_04] varchar(256) COLLATE Korean_Wansung_CI_AS NOT NULL,
[model_05] varchar(256) COLLATE Korean_Wansung_CI_AS NOT NULL,
[texture_filename] varchar(256) COLLATE Korean_Wansung_CI_AS NOT NULL,
[drop_type] varchar(256) COLLATE Korean_Wansung_CI_AS NOT NULL,
[icon_id] int NOT NULL,
[icon_file_name] varchar(256) COLLATE Korean_Wansung_CI_AS NOT NULL,
[script_text] varchar(512) COLLATE Korean_Wansung_CI_AS NOT NULL,
[2nd_array] int NOT NULL,
[group_bit_set] int NOT NULL
[IMG=expandable: 1][/IMG]

i can't work or edit somthing with GS
some one can do this ?

sorry for my bad english

Maybe check this out first.

Sandro1029 · 03/30/2022, 18:09

You can create a new view which gonna be readed as a table and in this view duplicate these rows, make them similar to 9.5, but based and read from your 9.6

~~forgephazer~~ · 03/30/2022, 19:06

Hello can someone ,help me with some issues i have with my server?i made a server with Mohcen files 9,6,2 but i cant find a working client.If anyone can help me i would appreciate.I would like to contact by discord or something .Thank you .

king1king · 03/30/2022, 19:23

Quote:

Originally Posted by Sandro1029

You can create a new view which gonna be readed as a table and in this view duplicate these rows, make them similar to 9.5, but based and read from your 9.6

i can't create this view
can you create view for me? @

and thank for first replay

sorry for my bad english

Quote:

Originally Posted by forgephazer

Hello can someone ,help me with some issues i have with my server?i made a server with Mohcen files 9,6,2 but i cant find a working client.If anyone can help me i would appreciate.I would like to contact by discord or something .Thank you .

same problem bro we need sframe 9.6 work with (RappelzCmdLauncher) i think

Sandro1029 · 03/30/2022, 19:36

Quote:

Originally Posted by king1king

i can't create this view
can you create view for me? @

and thank for first replay

sorry for my bad english

same problem bro we need sframe 9.6 work with (RappelzCmdLauncher) i think

Sandro#3370 discord

~~forgephazer~~ · 03/30/2022, 20:22

thank for help Sandro1029

Sandro1029 · 03/30/2022, 21:26

For a future, if anyone would like to do same:
1) Rename or remove your original ItemResource
2) Restore e9.6 ItemResource as with Item96Resource table name
3) Create new view in your Arcadia database:

Code:

SELECT
item.[id],
item.[name_id],
item.[tooltip_id],
item.[type],
item.[group],
item.[class],
item.[wear_type],
item.[set_id],
item.[set_part_flag],
item.[grade],
item.[rank],
item.[level],
item.[enhance],
item.[socket],
item.[status_flag],
item.[limit_deva],
item.[limit_asura],
item.[limit_gaia],
item.[job_depth],
item.[limit_fighter],
item.[limit_hunter],
item.[limit_magician],
item.[limit_summoner],
item.[use_min_level],
item.[use_max_level],
item.[target_min_level],
item.[target_max_level],
item.[range],
item.[weight],
item.[price],
item.[huntaholic_point],
item.[arena_point],
item.[ethereal_durability],
item.[endurance],
item.[material],
item.[summon_id],
item.[item_use_flag],
item.[available_period],
item.[decrease_type],
item.[throw_range],
item.[base_type_0],
item.[base_var1_0],
item.[base_var2_0],
item.[base_type_1],
item.[base_var1_1],
item.[base_var2_1],
item.[base_type_2],
item.[base_var1_2],
item.[base_var2_2],
item.[base_type_3],
item.[base_var1_3],
item.[base_var2_3],
item.[opt_type_0],
item.[opt_var1_0],
item.[opt_var2_0],
item.[opt_type_1],
item.[opt_var1_1],
item.[opt_var2_1],
item.[opt_type_2],
item.[opt_var1_2],
item.[opt_var2_2],
item.[opt_type_3],
item.[opt_var1_3],
item.[opt_var2_3],
item.[effect_id],
item.[enhance_id],
item.[skill_id],
item.[state_id],
item.[state_level],
item.[state_time],
item.[cool_time],
item.[cool_time_group],
item.[model_type_dem],
item.[model_type_def],
item.[model_type_asm],
item.[model_type_asf],
item.[model_type_gam],
item.[model_type_gaf],
item.[deco_model_change],
item.model_00 as "model_00",
item.model_00 as "model_01",
item.model_00 as "model_02",
item.model_01 as "model_03",
item.model_01 as "model_04",
item.model_01 as "model_05",
item.model_02 as "model_06",
item.model_02 as "model_07",
item.model_02 as "model_08",
item.model_03 as "model_09",
item.model_03 as "model_10",
item.model_03 as "model_11",
item.model_04 as "model_12",
item.model_04 as "model_13",
item.model_04 as "model_14",
item.model_05 as "model_15",
item.model_05 as "model_16",
item.model_05 as "model_17",
item.[texture_filename],
item.[drop_type],
item.[icon_id],
item.[icon_file_name],
item.[script_text],
item.[2nd_array],
item.[group_bit_set]
FROM
dbo.Item96Resource item

Save it with ItemResource name

Now if you wanna edit it, just edit Item96Resource table. Enjoy

king1king · 03/30/2022, 21:37

Quote:

Originally Posted by Sandro1029

For a future, if anyone would like to do same:
1) Rename or remove your original ItemResource
2) Restore e9.6 ItemResource as with Item96Resource table name
3) Create new view in your Arcadia database:

Code:

SELECT
item.[id],
item.[name_id],
item.[tooltip_id],
item.[type],
item.[group],
item.[class],
item.[wear_type],
item.[set_id],
item.[set_part_flag],
item.[grade],
item.[rank],
item.[level],
item.[enhance],
item.[socket],
item.[status_flag],
item.[limit_deva],
item.[limit_asura],
item.[limit_gaia],
item.[job_depth],
item.[limit_fighter],
item.[limit_hunter],
item.[limit_magician],
item.[limit_summoner],
item.[use_min_level],
item.[use_max_level],
item.[target_min_level],
item.[target_max_level],
item.[range],
item.[weight],
item.[price],
item.[huntaholic_point],
item.[arena_point],
item.[ethereal_durability],
item.[endurance],
item.[material],
item.[summon_id],
item.[item_use_flag],
item.[available_period],
item.[decrease_type],
item.[throw_range],
item.[base_type_0],
item.[base_var1_0],
item.[base_var2_0],
item.[base_type_1],
item.[base_var1_1],
item.[base_var2_1],
item.[base_type_2],
item.[base_var1_2],
item.[base_var2_2],
item.[base_type_3],
item.[base_var1_3],
item.[base_var2_3],
item.[opt_type_0],
item.[opt_var1_0],
item.[opt_var2_0],
item.[opt_type_1],
item.[opt_var1_1],
item.[opt_var2_1],
item.[opt_type_2],
item.[opt_var1_2],
item.[opt_var2_2],
item.[opt_type_3],
item.[opt_var1_3],
item.[opt_var2_3],
item.[effect_id],
item.[enhance_id],
item.[skill_id],
item.[state_id],
item.[state_level],
item.[state_time],
item.[cool_time],
item.[cool_time_group],
item.[model_type_dem],
item.[model_type_def],
item.[model_type_asm],
item.[model_type_asf],
item.[model_type_gam],
item.[model_type_gaf],
item.[deco_model_change],
item.model_00 as "model_00",
item.model_00 as "model_01",
item.model_00 as "model_02",
item.model_01 as "model_03",
item.model_01 as "model_04",
item.model_01 as "model_05",
item.model_02 as "model_06",
item.model_02 as "model_07",
item.model_02 as "model_08",
item.model_03 as "model_09",
item.model_03 as "model_10",
item.model_03 as "model_11",
item.model_04 as "model_12",
item.model_04 as "model_13",
item.model_04 as "model_14",
item.model_05 as "model_15",
item.model_05 as "model_16",
item.model_05 as "model_17",
item.[texture_filename],
item.[drop_type],
item.[icon_id],
item.[icon_file_name],
item.[script_text],
item.[2nd_array],
item.[group_bit_set]
FROM
dbo.Item96Resource item

Save it with ItemResource name

Now if you wanna edit it, just edit Item96Resource table. Enjoy

thank's for your help
you are the best

harmbasi · 03/31/2022, 19:07

How can I make my server available on the local network? When I use 127.0.0.1, I can't connect from other PC's on the network. I can't enter the lan IP into the gameserver.opt as then the gameserver doesn't even start.

Thanks

Sandro1029 · 03/31/2022, 19:26

Quote:

Originally Posted by harmbasi

How can I make my server available on the local network? When I use 127.0.0.1, I can't connect from other PC's on the network. I can't enter the lan IP into the gameserver.opt as then the gameserver doesn't even start.

Thanks

Type "ipconfig" in your cmd. It gonna show you your ipv4 local area network address. It will be 192.168.0.1xx.

You should add this in your opt and in bat launcher

harmbasi · 03/31/2022, 19:39

Quote:

Originally Posted by Sandro1029

Type "ipconfig" in your cmd. It gonna show you your ipv4 local area network address. It will be 192.168.0.1xx.

You should add this in your opt and in bat launcher

I've done that. The server refuses to start when I use my lan IP as mentioned in my post. 127.0.01 works/ my WAN IP works. Domain names/ lan IP dont work.

Sandro1029 · 03/31/2022, 20:18

Quote:

Originally Posted by harmbasi

I've done that. The server refuses to start when I use my lan IP as mentioned in my post. 127.0.01 works/ my WAN IP works. Domain names/ lan IP dont work.

Tried already to use WAN IP in opt but connect through LAN IP?

harmbasi · 03/31/2022, 20:25

Quote:

Originally Posted by Sandro1029

Tried already to use WAN IP in opt but connect through LAN IP?

no was just pointing out the OPT accepts WAN IP and 127.0.0.1 but does not accept domain names and Lan IP. Entering either domain name or WAN IP causes server to crash.

ThunderNikk · 03/31/2022, 21:57

LAN IP works where are you trying to put the LAN IP

I can share my .opt files when I get home but I run my server configured for

10.71.1.200 just fine and this is my LAN network. I connect with any PC in my house. My server computer is set for a reserved DHCP to simulate static.

harmbasi · 04/01/2022, 01:33

Quote:

Originally Posted by ThunderNikk

LAN IP works where are you trying to put the LAN IP

I can share my .opt files when I get home but I run my server configured for

10.71.1.200 just fine and this is my LAN network. I connect with any PC in my house. My server computer is set for a reserved DHCP to simulate static.

Thanks, it's just so weird on my end.

S:io.ip_address:192.168.0.76

This causes server not to start and crash but works with other IP's.