|
You last visited: Today at 19:19
Advertisement
[Help Thread] Please post your questions here.
Discussion on [Help Thread] Please post your questions here. within the Rappelz Private Server forum part of the Rappelz category.
03/30/2022, 17:48
|
#8371
|
elite*gold: 0 
Join Date: Jul 2020
Posts: 190
Received Thanks: 85
|
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.
|
|
|
|
03/30/2022, 18:09
|
#8372
|
elite*gold: 0
Join Date: Dec 2016
Posts: 182
Received Thanks: 82
|
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
|
|
|
|
|
03/30/2022, 19:06
|
#8373
|
elite*gold: 0
Join Date: May 2019
Posts: 11
Received Thanks: 2
|
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 .
|
|
|
|
|
03/30/2022, 19:23
|
#8374
|
elite*gold: 0
Join Date: Feb 2015
Posts: 101
Received Thanks: 3
|
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
|
|
|
|
|
03/30/2022, 19:36
|
#8375
|
elite*gold: 0
Join Date: Dec 2016
Posts: 182
Received Thanks: 82
|
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
|
|
|
|
|
03/30/2022, 20:22
|
#8376
|
elite*gold: 0
Join Date: May 2019
Posts: 11
Received Thanks: 2
|
thank for help Sandro1029
|
|
|
|
|
03/30/2022, 21:26
|
#8377
|
elite*gold: 0
Join Date: Dec 2016
Posts: 182
Received Thanks: 82
|
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
|
|
|
|
|
03/30/2022, 21:37
|
#8378
|
elite*gold: 0
Join Date: Feb 2015
Posts: 101
Received Thanks: 3
|
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
|
|
|
|
|
03/31/2022, 19:07
|
#8379
|
elite*gold: 0
Join Date: Mar 2009
Posts: 136
Received Thanks: 155
|
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
|
|
|
|
|
03/31/2022, 19:26
|
#8380
|
elite*gold: 0
Join Date: Dec 2016
Posts: 182
Received Thanks: 82
|
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
|
|
|
|
|
03/31/2022, 19:39
|
#8381
|
elite*gold: 0
Join Date: Mar 2009
Posts: 136
Received Thanks: 155
|
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.
|
|
|
|
|
03/31/2022, 20:18
|
#8382
|
elite*gold: 0
Join Date: Dec 2016
Posts: 182
Received Thanks: 82
|
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?
|
|
|
|
|
03/31/2022, 20:25
|
#8383
|
elite*gold: 0
Join Date: Mar 2009
Posts: 136
Received Thanks: 155
|
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.
|
|
|
|
|
03/31/2022, 21:57
|
#8384
|
Moderator
elite*gold: 1
Join Date: Dec 2012
Posts: 4,912
Received Thanks: 1,490
|
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.
|
|
|
|
|
04/01/2022, 01:33
|
#8385
|
elite*gold: 0
Join Date: Mar 2009
Posts: 136
Received Thanks: 155
|
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.
|
|
|
|
Similar Threads
|
[Helping Topic] 24/7 Helping Services!
08/27/2008 - EO PServer Hosting - 31 Replies
stucked on anything while setuping your server?
post your problem here and you will get answer as fast as possible better than spamming with posts :cool:
first of all try reading Ahmedpotop's Pserver All thing guide.
if your couldn't solve it out post your problem down here
""That includes PHP rankings pages / registrations pages / Status pages""
|
All times are GMT +1. The time now is 19:23.
|
|
![[Help Thread] Please post your questions here.](https://www.elitepvpers.com/forum/iconimages/rappelz-private-server/help-thread-please-post-your-questions-here_ltr.gif){kind=small}
