[Help Thread] Please post your questions here.

[Rollk]

<NULL>

[ilasoo]

Hi:, how can i repack my Files From 9.4 to 9.5 ?!!

[ThunderNikk]

Get a 9.5 client.

Dump required content from the 9.5 client data files.

Import as much data as you can into the database.

Resource or repack the 9.4 data files with as much content as you put into the database.

Get as many map files as you can get on the content that you are adding and try to add those into the server map files and also resource them into your 9.4 client or repack them into the 9.4 data files.

See this question as a whole is a tough one but if you take it step by step and ask for what you want to add one thing at a time then it can be explained a lot better.

BTW

If you are resourcing back up your working resource folder often and test new resourced content as often as you back it up. One mistake and a back up of the resources in the client can save a lot of back tracking.

If you are repacking then the same goes true for the data files.

If you are working with the maps and map resources. Back up your server map folder.

If you are rewriting .luas back up your lua files.

If you are entering new content into the database back up your databases.

In other words "Save and save often"

[Min@to]

Originally Posted by ThunderNikk

Get a 9.5 client.

Dump required content from the 9.5 client data files.

Import as much data as you can into the database.

Resource or repack the 9.4 data files with as much content as you put into the database.

Get as many map files as you can get on the content that you are adding and try to add those into the server map files and also resource them into your 9.4 client or repack them into the 9.4 data files.

See this question as a whole is a tough one but if you take it step by step and ask for what you want to add one thing at a time then it can be explained a lot better.

BTW

If you are resourcing back up your working resource folder often and test new resourced content as often as you back it up. One mistake and a back up of the resources in the client can save a lot of back tracking.

If you are repacking then the same goes true for the data files.

If you are working with the maps and map resources. Back up your server map folder.

If you are rewriting .luas back up your lua files.

If you are entering new content into the database back up your databases.

In other words "Save and save often"

I will try it Thank's

[PetTrainer]

hi i have a problem ...

i added a new "Smaragd Ignot" for 1.000.000.000 Rupees ...
i can buy it for 1.000.000.000 Rupees but can sell it only for 200.000.000 Rupees ..

thats the databeseline from my ignot:

 Spoiler

INSERT INTO [Arcadia].[dbo].[ItemResource] ([id], [name_id], [tooltip_id], [type], [group], [class], [wear_type], [set_id], [set_part_flag], [grade], [rank], [level], [enhance], [socket], [status_flag], [limit_deva], [limit_asura], [limit_gaia], [job_depth], [limit_fighter], [limit_hunter], [limit_magician], [limit_summoner], [use_min_level], [use_max_level], [target_min_level], [target_max_level], [range], [weight], [price], [huntaholic_point], [arena_point], [ethereal_durability], [endurance], [material], [summon_id], [item_use_flag], [available_period], [decrease_type], [throw_range], [base_type_0], [base_var1_0], [base_var2_0], [base_type_1], [base_var1_1], [base_var2_1], [base_type_2], [base_var1_2], [base_var2_2], [base_type_3], [base_var1_3], [base_var2_3], [opt_type_0], [opt_var1_0], [opt_var2_0], [opt_type_1], [opt_var1_1], [opt_var2_1], [opt_type_2], [opt_var1_2], [opt_var2_2], [opt_type_3], [opt_var1_3], [opt_var2_3], [effect_id], [enhance_id], [skill_id], [state_id], [state_level], [state_time], [cool_time], [cool_time_group], [model_type_dem], [model_type_def], [model_type_asm], [model_type_asf], [model_type_gam], [model_type_gaf], [deco_model_change], [model_00], [model_01], [model_02], [model_03], [model_04], [model_05], [model_06], [model_07], [model_08], [model_09], [model_10], [model_11], [model_12], [model_13], [model_14], [model_15], [model_16], [model_17], [texture_filename], [drop_type], [icon_id], [icon_file_name], [script_text], [2nd_array], [group_bit_set]) VALUES ('726', '800726', '900726', '0', '0', '0', '-1', '0', '0', '0', '0', '1', '0', '0', '0', '1', '1', '1', '15', '1', '1', '1', '1', '1', '300', '0', '0', '.00', '.10', '100000000', '0', '0', '0', '0', '3', '0', '1090551876', '0', '0', '.00', '0', '.00', '.00', '0', '.00', '.00', '0', '.00', '.00', '0', '.00', '.00', '0', '.00', '.00', '0', '.00', '.00', '0', '.00', '.00', '0', '.00', '.00', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'drop_etc_box', '0', 'icon_item_etc_smara', '', '600100', '32');

how can i change the sellprice ????

[Xijezu]

Originally Posted by PetTrainer

hi i have a problem ...

i added a new "Smaragd Ignot" for 1.000.000.000 Rupees ...
i can buy it for 1.000.000.000 Rupees but can sell it only for 200.000.000 Rupees ..

thats the databeseline from my ignot:

 Spoiler

INSERT INTO [Arcadia].[dbo].[ItemResource] ([id], [name_id], [tooltip_id], [type], [group], [class], [wear_type], [set_id], [set_part_flag], [grade], [rank], [level], [enhance], [socket], [status_flag], [limit_deva], [limit_asura], [limit_gaia], [job_depth], [limit_fighter], [limit_hunter], [limit_magician], [limit_summoner], [use_min_level], [use_max_level], [target_min_level], [target_max_level], [range], [weight], [price], [huntaholic_point], [arena_point], [ethereal_durability], [endurance], [material], [summon_id], [item_use_flag], [available_period], [decrease_type], [throw_range], [base_type_0], [base_var1_0], [base_var2_0], [base_type_1], [base_var1_1], [base_var2_1], [base_type_2], [base_var1_2], [base_var2_2], [base_type_3], [base_var1_3], [base_var2_3], [opt_type_0], [opt_var1_0], [opt_var2_0], [opt_type_1], [opt_var1_1], [opt_var2_1], [opt_type_2], [opt_var1_2], [opt_var2_2], [opt_type_3], [opt_var1_3], [opt_var2_3], [effect_id], [enhance_id], [skill_id], [state_id], [state_level], [state_time], [cool_time], [cool_time_group], [model_type_dem], [model_type_def], [model_type_asm], [model_type_asf], [model_type_gam], [model_type_gaf], [deco_model_change], [model_00], [model_01], [model_02], [model_03], [model_04], [model_05], [model_06], [model_07], [model_08], [model_09], [model_10], [model_11], [model_12], [model_13], [model_14], [model_15], [model_16], [model_17], [texture_filename], [drop_type], [icon_id], [icon_file_name], [script_text], [2nd_array], [group_bit_set]) VALUES ('726', '800726', '900726', '0', '0', '0', '-1', '0', '0', '0', '0', '1', '0', '0', '0', '1', '1', '1', '15', '1', '1', '1', '1', '1', '300', '0', '0', '.00', '.10', '100000000', '0', '0', '0', '0', '3', '0', '1090551876', '0', '0', '.00', '0', '.00', '.00', '0', '.00', '.00', '0', '.00', '.00', '0', '.00', '.00', '0', '.00', '.00', '0', '.00', '.00', '0', '.00', '.00', '0', '.00', '.00', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'drop_etc_box', '0', 'icon_item_etc_smara', '', '600100', '32');

how can i change the sellprice ????

Check out (same as retail): ItemID needs to be between 602700 and 602799, if it isn't it calculates the sell value.

[thefear511]

Originally Posted by PetTrainer

hi i have a problem ...

i added a new "Smaragd Ignot" for 1.000.000.000 Rupees ...
i can buy it for 1.000.000.000 Rupees but can sell it only for 200.000.000 Rupees ..

thats the databeseline from my ignot:

 Spoiler

INSERT INTO [Arcadia].[dbo].[ItemResource] ([id], [name_id], [tooltip_id], [type], [group], [class], [wear_type], [set_id], [set_part_flag], [grade], [rank], [level], [enhance], [socket], [status_flag], [limit_deva], [limit_asura], [limit_gaia], [job_depth], [limit_fighter], [limit_hunter], [limit_magician], [limit_summoner], [use_min_level], [use_max_level], [target_min_level], [target_max_level], [range], [weight], [price], [huntaholic_point], [arena_point], [ethereal_durability], [endurance], [material], [summon_id], [item_use_flag], [available_period], [decrease_type], [throw_range], [base_type_0], [base_var1_0], [base_var2_0], [base_type_1], [base_var1_1], [base_var2_1], [base_type_2], [base_var1_2], [base_var2_2], [base_type_3], [base_var1_3], [base_var2_3], [opt_type_0], [opt_var1_0], [opt_var2_0], [opt_type_1], [opt_var1_1], [opt_var2_1], [opt_type_2], [opt_var1_2], [opt_var2_2], [opt_type_3], [opt_var1_3], [opt_var2_3], [effect_id], [enhance_id], [skill_id], [state_id], [state_level], [state_time], [cool_time], [cool_time_group], [model_type_dem], [model_type_def], [model_type_asm], [model_type_asf], [model_type_gam], [model_type_gaf], [deco_model_change], [model_00], [model_01], [model_02], [model_03], [model_04], [model_05], [model_06], [model_07], [model_08], [model_09], [model_10], [model_11], [model_12], [model_13], [model_14], [model_15], [model_16], [model_17], [texture_filename], [drop_type], [icon_id], [icon_file_name], [script_text], [2nd_array], [group_bit_set]) VALUES ('726', '800726', '900726', '0', '0', '0', '-1', '0', '0', '0', '0', '1', '0', '0', '0', '1', '1', '1', '15', '1', '1', '1', '1', '1', '300', '0', '0', '.00', '.10', '100000000', '0', '0', '0', '0', '3', '0', '1090551876', '0', '0', '.00', '0', '.00', '.00', '0', '.00', '.00', '0', '.00', '.00', '0', '.00', '.00', '0', '.00', '.00', '0', '.00', '.00', '0', '.00', '.00', '0', '.00', '.00', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'drop_etc_box', '0', 'icon_item_etc_smara', '', '600100', '32');

how can i change the sellprice ????

i see that you might have forgot about the ratios, its hard and complicated but i can help you via teamviewer.

long story short ratios doubles the price if u used 1.000.000 ratio and put real price 10 the outcome in-game will be an item that is price 10.000.000 .

however, I have encountered some issues with items that i wanted its price to be 9 digits. billions for example.

[Dark Blaze]

Originally Posted by thefear511

i see that you might have forgot about the ratios, its hard and complicated but i can help you via teamviewer.

long story short ratios doubles the price if u used 1.000.000 ratio and put real price 10 the outcome in-game will be an item that is price 10.000.000 .

however, I have encountered some issues with items that i wanted its price to be 9 digits. billions for example.

Ratios aren't hard or complicated, it's pretty simple multiplication, if you put the price as 10,000,000.00(10M) and you want to sell it for 10M at the store then you put the ratio as 1.00(1) the price will be 10M.

[thefear511]

Originally Posted by Dark Blaze

Ratios aren't hard or complicated, it's pretty simple multiplication, if you put the price as 10,000,000.00(10M) and you want to sell it for 10M at the store then you put the ratio as 1.00(1) the price will be 10M.

the logic is simple but dealing with it you counter alot of issues, i started by editing via tools and it always run an error with 1 billion price and higher, then i started editing directly via sql and i can't put 9 digits so yea you need to figure your work around ^^.

[ThunderNikk]

They were referring to the resell price to the vendor anyway.

Not the ratio and the sell price of the item but when you sell it back, so it is not halved or quartered in price depending on your epic.

Pretty sure Xijezu's answer had them covered with the item number range.

[PetTrainer]

Originally Posted by Xijezu

Check out (same as retail): ItemID needs to be between 602700 and 602799, if it isn't it calculates the sell value.

Thx xijezu it's work

[Pepsilight69]

Hello,


-I want some monsters to spawn randomly, but still in an interval.
I thought, this could work:
respawn_rare_mob( -1, math.random(1,1000), ... )
They always spawns after 10 seconds, no RNG at all.


-How can I make the client play a sound every time certain mobs spawn and die ( the RNG spawned mobs)?


-Are notices editable? Like the color or font of a notice?

-

[thefear511]

Originally Posted by Pepsilight69

Hello,


-I want some monsters to spawn randomly, but still in an interval.
I thought, this could work:
respawn_rare_mob( -1, math.random(1,1000), ... )
They always spawns after 10 seconds, no RNG at all.


-How can I make the client play a sound every time certain mobs spawn and die ( the RNG spawned mobs)?


-Are notices editable? Like the color or font of a notice?

-

I'd like to note a great advice from @ "stop using Lua for mobs respawn", use nfm NFA (can't remember which one).
yes its harded since u will have to hash the files again and update them to the client but its more reliable and won't walk on walls

[Xijezu]

Originally Posted by thefear511

I'd like to note a great advice from @ "stop using Lua for mobs respawn", use nfm NFA (can't remember which one).
yes its harded since u will have to hash the files again and update them to the client but its more reliable and won't walk on walls

I don't see a reason using mapfiles over lua.
The mapfiles don't do anything different - which actually is a lua function that isn't hardcoded in the GS.


About that one tho:

respawn_rare_mob( -1, math.random(1,1000), ... )

The function gets called once, you pass the one-time generated value of math.random(1,1000), which may be 534, so the call ends up in this:

respawn_rare_mob( -1, 534, ... )

and not in "real" random intervals.

[thefear511]

Originally Posted by Xijezu

I don't see a reason using mapfiles over lua.
The mapfiles don't do anything different - which actually is a lua function that isn't hardcoded in the GS.


About that one tho:

respawn_rare_mob( -1, math.random(1,1000), ... )

The function gets called once, you pass the one-time generated value of math.random(1,1000), which may be 534, so the call ends up in this:

respawn_rare_mob( -1, 534, ... )

and not in "real" random intervals.

meh i might have got the concept wrong, but the box will keep mob from roaming too much i guess and getting stuck in walls.