[Help Thread] Please post your questions here.

[xlapeto94]

Hello Guys I need UR HElp ! Who can Tell me How I can Repair master classs Quest .
Thnak You

[Dragon171]

Originally Posted by xlapeto94

Hello Guys I need UR HElp ! Who can Tell me How I can Repair master classs Quest .
Thnak You

If you are using Infinite 7.3 files, try adding mobs to spawn list. I've stucked on zealot quests, spawned Them correctly and questline goes on correctly until had problem with two statues near Light Pope Lucian. I've tried searching/adding quest item with no luck, so at this moment i'm waiting for better fix/answer...

[c1ph3r]

Originally Posted by Dragon171

If you are using Infinite 7.3 files, try adding mobs to spawn list. I've stucked on zealot quests, spawned Them correctly and questline goes on correctly until had problem with two statues near Light Pope Lucian. I've tried searching/adding quest item with no luck, so at this moment i'm waiting for better fix/answer...

...Instead of waiting you can use the search button...your mapfiles are outdated which is described in a lot of threads

Go to Rappelz Download Center and download the NCarbon Dumper. Dump the Mapfiles from your Client and put them in the newmap folder.

[dodo11dodo]

I want to add the lydin sklls but how? I download xijezu resource editor but whem i load skill tree it give me a uncorrect sentenses

[c1ph3r]

Xijezus Resource Editor (public version) is too old you can't open 7.4 Files in it. You have to develop your own tool...or wait till somebody will give you the correct tables...or wait till someone will share the tables

[OmegaStars]

Hey c1ph3r
Can u tell me how can i change prices in NPC's please ???? Item by item , and not with :

USE Arcadia
GO
UPDATE dbo.MarketResource
SET price_ratio=0.400 change to raise/lower the prices
WHERE price_ratio>0.0000

And how can i add new Items into NPC ?? THanks in advance . i searched but i can't found a good Answer .

[c1ph3r]

Originally Posted by OmegaStars

Hey c1ph3r
Can u tell me how can i change prices in NPC's please ???? Item by item , and not with :


And how can i add new Items into NPC ?? THanks in advance . i searched but i can't found a good Answer .

You have to know the item id of the item!

USE Arcadia
GO
UPDATE dbo.MarketResource
SET price_ratio=0.400 change to raise/lower the prices
WHERE code=[I]your_item_id[/I]

If you don't know the item id you can search it with this query:

SELECT STRING.value, ITEM.id
FROM dbo.ItemResource as ITEM
LEFT JOIN dbo.StringResource as STRING
on STRING.code=ITEM.name_id
WHERE STRING.value like '%ITEM_NAME%'

Replace ITEM_NAME with the name of the Item.

Example:

SELECT STRING.value, ITEM.id
FROM dbo.ItemResource as ITEM
LEFT JOIN dbo.StringResource as STRING
on STRING.code=ITEM.name_id
WHERE STRING.value like '%Baron Madius card%'

You need a readable StringResource in your DB to use this query! You can use NCarbon Dumper to dumpt the db_string.rdb out of your client. Next you can use the String Editor to import the db_string.rdb into your Arcadia.

[Dragon171]

Originally Posted by c1ph3r

Don't really know why you want to add states 314091-314093 again because they are allready in the infinite db. And there is still one missing id in your insert script.

INSERT [dbo].[StateResource] ([state_id], [text_id], [tooltip_id], [is_harmful], [state_time_type], [state_group], [duplicate_group_1], [duplicate_group_2], [duplicate_group_3], [uf_avatar], [uf_summon], [uf_monster], [reiteration_count], [base_effect_id], [fire_interval], [elemental_type], [amplify_base], [amplify_per_skl], [add_damage_base], [add_damage_per_skl], [effect_type], [value_0], [value_1], [value_2], [value_3], [value_4], [value_5], [value_6], [value_7], [value_8], [value_9], [value_10], [value_11], [value_12], [value_13], [value_14], [value_15], [value_16], [value_17], [value_18], [value_19], [icon_id], [icon_file_name], [fx_id], [pos_id], [cast_skill_id], [cast_fx_id], [cast_fx_pos_id], [hit_fx_id], [hit_fx_pos_id], [special_output_timing_id], [special_output_fx_id], [special_output_fx_pos_id], [special_output_fx_delay], [state_fx_id], [state_fx_pos_id]) VALUES (314069, 30314069, 60314069, N'0', 1, 0, 0, 0, 0, N'1', N'1', N'1', 0, 0, 0, 0, CAST(0.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), 0, 0, 2, CAST(0.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), CAST(12288.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), CAST(0.060 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), 20009, N'icon_skill_act_penetration_focus_conditionditionion', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0)

INSERT [dbo].[StateResource] ([state_id], [text_id], [tooltip_id], [is_harmful], [state_time_type], [state_group], [duplicate_group_1], [duplicate_group_2], [duplicate_group_3], [uf_avatar], [uf_summon], [uf_monster], [reiteration_count], [base_effect_id], [fire_interval], [elemental_type], [amplify_base], [amplify_per_skl], [add_damage_base], [add_damage_per_skl], [effect_type], [value_0], [value_1], [value_2], [value_3], [value_4], [value_5], [value_6], [value_7], [value_8], [value_9], [value_10], [value_11], [value_12], [value_13], [value_14], [value_15], [value_16], [value_17], [value_18], [value_19], [icon_id], [icon_file_name], [fx_id], [pos_id], [cast_skill_id], [cast_fx_id], [cast_fx_pos_id], [hit_fx_id], [hit_fx_pos_id], [special_output_timing_id], [special_output_fx_id], [special_output_fx_pos_id], [special_output_fx_delay], [state_fx_id], [state_fx_pos_id]) VALUES (314060, 30314060, 60314060, N'0', 1, 0, 0, 0, 0, N'1', N'1', N'1', 0, 0, 0, 0, CAST(0.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), 0, 0, 1, CAST(2048.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), CAST(6.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), 20009, N'icon_condition_0011_light_darkness_conditiontionion', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0)

INSERT [dbo].[StateResource] ([state_id], [text_id], [tooltip_id], [is_harmful], [state_time_type], [state_group], [duplicate_group_1], [duplicate_group_2], [duplicate_group_3], [uf_avatar], [uf_summon], [uf_monster], [reiteration_count], [base_effect_id], [fire_interval], [elemental_type], [amplify_base], [amplify_per_skl], [add_damage_base], [add_damage_per_skl], [effect_type], [value_0], [value_1], [value_2], [value_3], [value_4], [value_5], [value_6], [value_7], [value_8], [value_9], [value_10], [value_11], [value_12], [value_13], [value_14], [value_15], [value_16], [value_17], [value_18], [value_19], [icon_id], [icon_file_name], [fx_id], [pos_id], [cast_skill_id], [cast_fx_id], [cast_fx_pos_id], [hit_fx_id], [hit_fx_pos_id], [special_output_timing_id], [special_output_fx_id], [special_output_fx_pos_id], [special_output_fx_delay], [state_fx_id], [state_fx_pos_id]) VALUES (314061, 30314061, 60314061, N'0', 1, 0, 0, 0, 0, N'1', N'1', N'1', 0, 0, 0, 0, CAST(0.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), 0, 0, 1, CAST(4096.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), CAST(-6.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), 20009, N'icon_condition_0012_light_darkness_conditiontionion', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0)

I've searched whole forum for tip about bugged Mercenary skill Immorality and bugged Deadeye skill Frozen Arrows. Added this states and yes, it fixed Oracle buff Rapture (Yay!) anyone got answer about two others? Tried to fix skills in db-still bugged two last skills... I'm using ,,Infinite files working 100%'' modified 2012-04-27 and rest of this is working perfectly... (sry for my eng)

Edit: Now Deadeye slow arrow buffs shows correctly-but stil client dc after around 5-10 shots

[hackfever]

compare your arcadia to Arcadia.bak 7.3 From official arab server! from download center and change the values on skills that are different and itll fix all master class skills

when restoring arab arcadia for comparison make a new database called test in the restore window make sute after u select the arab arcadia to put test into the database box because it will change it to Arcadia then go to files tab and under restore as change first to c:\Program Files\Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\DATA\test.mdf
and second to
c:\Program Files\Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\DATA\test_log.ldf

under options select Overwrite the existing database with replace and unselect both tail log backups and select close existing connections to destination database then click ok

[c1ph3r]

The error is not in the SkillResource! There are missing some states in your StateResource. Go through your SkillResource and check the bugged skills. Check the state_id and var1. Sometimes there are 2 states. First in state_id and second in var1. If one of them is missing in your StateResource the client will cause a dc!

[bwr_62]

I think the problem come of the "Reiteration_count" who comport 1 caracter, but some skill have reiteration_count >9

[Dragon171]

Originally Posted by hackfever

compare your arcadia to Arcadia.bak 7.3 From official arab server! from download center and change the values on skills that are different and itll fix all master class skills

when restoring arab arcadia for comparison make a new database called test in the restore window make sute after u select the arab arcadia to put test into the database box because it will change it to Arcadia then go to files tab and under restore as change first to c:\Program Files\Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\DATA\test.mdf
and second to
c:\Program Files\Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\DATA\test_log.ldf

under options select Overwrite the existing database with replace and unselect both tail log backups and select close existing connections to destination database then click ok

Thank you very much for help, you are right-still missed three state_ids, added to db.StateResource and now working 100% purely, thank you so much for help!

Originally Posted by c1ph3r

The error is not in the SkillResource! There are missing some states in your StateResource. Go through your SkillResource and check the bugged skills. Check the state_id and var1. Sometimes there are 2 states. First in state_id and second in var1. If one of them is missing in your StateResource the client will cause a dc!

Thanks for answer, but done with that ^^

[hackfever]

your welcome dragon

[OmegaStars]

Thanks again c1phr3 and how can i add cubric dungeon (with mobs) + Lydian skills ?? (for lydian i have passif skills(most the skills) + actif skill "fear" and another one i forget it x) )

PS : i have full 7.3 (no bugs)

[c1ph3r]

You will need the 7.4 SkillResource, SkillStage and SkillTree Tables...