About Item_db.txt and item_db.conf

[Tales]

rAthena will update the source to read item_db.conf? I'm talking about it because i use Cronus translates to run rAthena on my country. I like rAthena but i (we) need a translated database... =/

 

I wont leave rAthena to go to Hercules because this new item_db.conf system...

[Winz]

import folder? which?

 

I can't tell..

the settings will still work. it doesn't matter if you're using txt or sql.

[Winz]

item_db.conf? what is it? do you mean item_db.txt?

 

is it possible to compare item_db from rAthena and Hercules, and get Hercules' portugese (is it?) names to be stored as rAthena's? or to make it simpler, you can set to use SQL db, instead of txt, and do some modifications on the SQL,and it's like

update ragnarok.item_db set name= blah

 

I guess rA will only go with 100% english

[Tales]

The Hercules use the structure like this:
 

REF: https://raw.githubusercontent.com/HerculesWS/Hercules/master/db/re/item_db.conf

{
    Id: 501
    AegisName: "Red_Potion"
    Name: "Red Potion"
    Type: 0
    Buy: 50
    Weight: 70
    Upper: 63
    Script: <" itemheal rand(45,65),0; ">
},

And i want to know if rathena will update to this...


About SQL, i got some erros when import item_db.sql and monster_db.sql from SQL_FILES folder. Besides, i dont know how the item_db or mob_db.sql work's. I mean, if i use slq files, the battle/drops.conf will be read?

Edited October 13, 2014 by Tales

[Winz]

isn't it called iteminfo.lua lub?

 

wait. this structure..

 

not thinking so, rA uses a table like on SQL and TXT. try to open excel, import data from text file, select item_db.txt (pre-re, re both are fine) and delimit with a comma (,) then you can see it looks like a table. (it is a table)

 

If your question is: "Will rA modify the structure to be like this?" then,,, I don't know. you got to ask the developers. Probably, they would ask you "why?" because:

 

For every entry, you will need to write [ { ], [ <tab> ], [ ID: ] , [ AegisName ], etc right? each character has a size that will be written. it may be small. but, what about if Ragnarok keep developing and add more items? then the item_db.txt will be soooooo large.

This is the current rA's item_db.txt (mine, not sure if updated):

 

*btw, usually a single <tab> is considered as 4 white spaces. May be read as [4 white spaces] or [\t] accordingly.

 

conclusion: that structure will take up so many spaces.

[Tales]

I agree with you  (this will incress the file unnecessary) but, about that PhpMyAdmin reports when I up the slq tables of items and monsters? I forget?

[Winz]

Usually, it's caused by the size of file / the huge number of lines (entries, characters, texts). That happens all on the first time you upload them. on the next time, you'll just do some upgrades, so it's fine..

I mean, upgrades will upgrade (modify the values) and / or add some values (will never be more than 50 at a time).

 

To solve this, if you are using PMA, then copy some parts from the .sql and paste it on PMA's SQL box and execute it. do it several times.

[Tales]

oh! Nice trick, man!
But now, How will be the issue of moving from txt to sql? I mean...its hard to move and active it? And the configuration about battle/*.conf files, i can keep it on?

[Winz]

hmm, inter_athena.conf and search: "use_sql_db:" set it to yes.

 

The problem is that when you activate item_db_SQL, then other DBs (item_cash, mob_db, mob_skill_db) are also activated. Therefore, you need to load those as well.

another problem is that when you had made custom item, you need to manually add them to the SQL. but, this should do it:

INSERT INTO item_db VALUES (<your custom item goes here>);

1 line = 1 entry. e.g:

 

INSERT INTO item_db VALUES (1503,"A Wing",A_WING,....);
INSERT INTO item_db VALUES (1504,"B Wing",B_WING,....);
INSERT INTO item_db VALUES (1505,"V Wing",V_WING,....);

[Tales]

That means I'll have to redo all my IMPORT folder inside the database. 

 

In your opinion, what is the best? Database or text? What about the settings of battle / conf? will work if I use the database? I say this about the multiplier drops (battle / drops.conf)

[Tales]

Thx! I'll change my server to sql type.