Tenra 0 Report post Posted September 11, 2019 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: 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) Maybe there are already merged bases of the type as on this site: https://info.cerberus-games.com/main/mob/00001 0 Quote Share this post Link to post Share on other sites
KaZantip 6 Report post Posted September 11, 2019 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. 1 Quote Share this post Link to post Share on other sites
Ron 408 Report post Posted September 11, 2019 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. 2 Quote RF-Dev Administrator Account Settings | Update Signature | Community Guidelines | RF-Dev on Discord Share this post Link to post Share on other sites
4erepaxa 67 Report post Posted September 12, 2019 I can export your script's data to mssql for free 1 Quote ? Share this post Link to post Share on other sites
Tenra 0 Report post Posted September 15, 2019 (edited) 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 0 Quote Share this post Link to post Share on other sites
Wade 33 Report post Posted September 15, 2019 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. 1 Quote RFD Share this post Link to post Share on other sites
KaZantip 6 Report post Posted September 16, 2019 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) 1 Quote Share this post Link to post Share on other sites
Tenra 0 Report post Posted September 18, 2019 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 ?? 0 Quote Share this post Link to post Share on other sites