Jump to content
Sign in to follow this  
Tenra

New online database of RF Online

Recommended Posts

Hello community! 😃

I want to create the most complete online database of RF Online.
With all the information and links from any item or mob to everything connected with it.

Also on this resource, server administrators will be able to register and post guides of their server and set the rates of their server, which at the output will give the correct data for all items and mobs. (It’s possible except drop, but this is not certain).

 

In this regard, I have questions:

  1. Is there any tool that allows you to translate .dat files directly to sql or, as a last resort, to excel. (Yes, I know that through "010 Editor" you can convert to excel, but for him to do it correctly, you need to do a lot of actions before that, but unfortunately I do not have much free time)
  2. Maybe there are already merged bases of the type as on this site: You must be a registered member of RF-Dev and logged in to view this content.

Share this post


Link to post
Share on other sites

There is no such thing in free access.
You need to make your own parser, which will collect data in a single.
It is not difficult for any programmer to do this.
We have long wanted to do the same thing that you wrote about, but for the Russian segment.

Share this post


Link to post
Share on other sites

Thank you all 😃
I found almost all db files already in excel
Now I check their relevance, and try to understand the purpose of all the columns.
For example, in a table with rings, these columns are not clear to me:

  • KindClt
  • FixPart
  • IsAbr
  • EffState
  • IsUseableNormalAcc

And where can I find models for effects (EffCode) and other things?

Here is what I know about EffCode:

'12' = 'increase movement speed '
'6' = 'increase all attacking abilities'
'4' = 'increase ability to evade attacks'
'5' = 'increase HP / FP '
'7' = 'increase protection'
'17' = 'damage from attacks translates into HP'

Excel img: You must be a registered member of RF-Dev and logged in to view this content.

Edited by Tenra

Share this post


Link to post
Share on other sites

KindClt : What kind of item ( for example 9 is ring and 10 is amulet )

FixPart : Socket ( Where do you put that item to use it ) For example ammo slot is 200 

IsAbr : 2 Different value. 1 or 0 If its 1 that item has durability just like siege a kit.

EffState : Dont know

IsUseableNormalAcc : 0 or 1. Mostly its 1 if its 0 only gm can use.

Im not sure they might be wrong.  Also you may find something in this link.

 


RFD

Share this post


Link to post
Share on other sites

I apologize in advance for my translation.

1 - increase in sp (1 = 100%, 0.1 = 10%)
2 - Costs for FP (1 = 100%, 0.1 = 10%)
3 - Increase Accuracy (1 = 1 accuracy)
4 - Increase Dodge (1 = 1 Dodge)
5 - Increase hp / fp (1 = 100%, 0.1 = 10%)
6 - Increase Attack (1 = 100%, 0.1 = 10%)
7 - Increase Defense (1 = 100%, 0.1 = 10%)
8 - Skill level (1 = 1 skill level)
9 - stealth (0)
10 - discovery (1)
11 - Removes a defensive skill
12 - Increase Run (1 = 1 to run)
13 - Discloses Adversary Vulnerability Information
14 - Regen FP
15 - Increase Mag. attacks (1 = 100%, 0.1 = 10%)
16 - Increase FP (1 = 100%, 0.1 = 10%)
17 - Vampirism (1 = 100%, 0.1 = 10%)
18 - Vampiric FP
19 - Critical Chance. attacks (1 = 1 to ver. critical attack)
20 - radius of attack (1 = 1 to radius of attack)
21 - Protection (siege only)
22 - Increasing the time negative forces (1 = 100%, 0.1 = 10%)
23 - Regen HP
24 - Dodge in % ratio
25 - Launcher Reload Speed (rollback before firing) (-1000 = 1 sec)
26 - Increase all mage attacking abilities (1 = 100%, 0.1 = 10%)
27 - Opponent's critical strike chance (100 = 100%, 1 = 1%)
28 - Block shield (1 = 1 to block)
29 - + to the elements (1 = 1 to the elements)
30 - Increase hp (1 = 100%, 0.1 = 10%)
31 - the duration of the action of negative forces decrease (-1 = 100%, -0.1 = 10%)
32 - block shield (1 = 1 to block shield)
33 - reload of ranged skills (1000 = 1 second)
34 - reload of melee skills (1000 = 1 second)
35 - reload magic powers (1000 = 1 second)

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...