yml x mysql understanding

[millu]

 

Please, I need help understanding the definition of these fields in the item_db_re table (mysql). I need to import yml to mysql, it's all done, but I don't understand the use of these fields, since they *when they exist in yml are of little clarity*, so,

When will one of these fields be set to true?

  `class_all` tinyint(1) unsigned DEFAULT NULL,
  `class_normal` tinyint(1) unsigned DEFAULT NULL,
  `class_upper` tinyint(1) unsigned DEFAULT NULL,
  `class_baby` tinyint(1) unsigned DEFAULT NULL,
  `class_third` tinyint(1) unsigned DEFAULT NULL,
  `class_third_upper` tinyint(1) unsigned DEFAULT NULL,
  `class_third_baby` tinyint(1) unsigned DEFAULT NULL,
  `class_fourth` tinyint(1) unsigned DEFAULT NULL,    

 

Edited September 29, 2023 by millu

[Harvin]

rAthena developer has provide us with tools that can convert yml to sql, if you in windows just build/rebuild all of project rAthena Solution, then run yml2sql.bat there you need some input what to convert and what not by pressing Y or N key on your keyboard, you will have ready sql file to import in sql-files folder

Edited September 29, 2023 by Harvin

[millu]

22 hours ago, Harvin said:

rAthena developer has provide us with tools that can convert yml to sql, if you in windows just build/rebuild all of project rAthena Solution, then run yml2sql.bat there you need some input what to convert and what not by pressing Y or N key on your keyboard, you will have ready sql file to import in sql-files folder

friend, thank you for your attention, however:

1) I really want to understand the *logic*, for a specific development, *that if it works as I think I will soon make it public* and believe me, it will be very useful;

2) this import does not work.

For example, yml has an item id 1100, after import this item did not appear in any item_db in mysql.

So I'm still waiting for someone to explain *the logic and purpose of these fields*.

 

Edited September 30, 2023 by millu