Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Rappelz > Rappelz Private Server
You last visited: Today at 15:37

  • Please register to post and access all features, it's quick, easy and FREE!

 

[Help Thread] Please post your questions here.

Reply
 
Old   #661
 
elite*gold: 0
Join Date: May 2011
Posts: 6
Received Thanks: 0
Hello Guys I need UR HElp ! Who can Tell me How I can Repair master classs Quest .
Thnak You



xlapeto94 is offline  
Old   #662
 
elite*gold: 0
Join Date: Aug 2011
Posts: 7
Received Thanks: 0
Quote:
Originally Posted by xlapeto94 View Post
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...


Dragon171 is offline  
Old   #663
 
elite*gold: 0
Join Date: Sep 2008
Posts: 1,570
Received Thanks: 1,154
Quote:
Originally Posted by Dragon171 View Post
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.
c1ph3r is offline  
Old   #664
 
elite*gold: 0
Join Date: Aug 2011
Posts: 2
Received Thanks: 0
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



dodo11dodo is offline  
Old   #665
 
elite*gold: 0
Join Date: Sep 2008
Posts: 1,570
Received Thanks: 1,154
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
c1ph3r is offline  
Thanks
1 User
Old   #666
 
elite*gold: 0
Join Date: Jan 2012
Posts: 102
Received Thanks: 2
Hey c1ph3r
Can u tell me how can i change prices in NPC's please ???? Item by item , and not with :
Quote:
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 .
OmegaStars is offline  
Old   #667
 
elite*gold: 0
Join Date: Sep 2008
Posts: 1,570
Received Thanks: 1,154
Quote:
Originally Posted by OmegaStars View Post
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!

Code:
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:

Code:
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:

Code:
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.
c1ph3r is offline  
Old   #668
 
elite*gold: 0
Join Date: Aug 2011
Posts: 7
Received Thanks: 0
Quote:
Originally Posted by c1ph3r View Post
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.

Code:
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
Dragon171 is offline  
Old   #669
 
elite*gold: 0
Join Date: Jun 2008
Posts: 104
Received Thanks: 14
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
hackfever is offline  
Thanks
1 User
Old   #670
 
elite*gold: 0
Join Date: Sep 2008
Posts: 1,570
Received Thanks: 1,154
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!
c1ph3r is offline  
Thanks
2 Users
Old   #671
 
elite*gold: 0
Join Date: Jan 2011
Posts: 134
Received Thanks: 61
I think the problem come of the "Reiteration_count" who comport 1 caracter, but some skill have reiteration_count >9
bwr_62 is offline  
Old   #672
 
elite*gold: 0
Join Date: Aug 2011
Posts: 7
Received Thanks: 0
Quote:
Originally Posted by hackfever View Post
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!

Quote:
Originally Posted by c1ph3r View Post
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 ^^
Dragon171 is offline  
Old   #673
 
elite*gold: 0
Join Date: Jun 2008
Posts: 104
Received Thanks: 14
your welcome dragon
hackfever is offline  
Old   #674
 
elite*gold: 0
Join Date: Jan 2012
Posts: 102
Received Thanks: 2
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)
OmegaStars is offline  
Old   #675
 
elite*gold: 0
Join Date: Sep 2008
Posts: 1,570
Received Thanks: 1,154
You will need the 7.4 SkillResource, SkillStage and SkillTree Tables...


c1ph3r is offline  
Thanks
1 User
Reply

Tags
7.4, client, rappelz



« Previous Thread | Next Thread »

Similar Threads
[Helping Topic] 24/7 Helping Services!
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...
31 Replies - EO PServer Hosting



All times are GMT +2. The time now is 15:37.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy
Copyright ©2017 elitepvpers All Rights Reserved.