New online database of RF Online

[Tenra 0]

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: https://info.cerberus-games.com/main/mob/00001

[KaZantip 6]

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.

[Ron 408]

As above. Such a tool has never needed to be public so nothing like this is available... yet. We have such an idea to add utility to another project we are releasing in the future, and this will be open source so you can adapt it easily.

[4erepaxa 67]

I can export your script's data to mssql for free

[Tenra 0]

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: https://ibb.co/bBDnQ2D

Edited September 15, 2019 by Tenra

[Wade 33]

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.

 

[KaZantip 6]

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)

[Tenra 0]

On 9/16/2019 at 4:21 PM, KaZantip said:

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)

Thank you very much ??