Ultimate Item DB Update

[Ind 945]

Ultimate Item DB Update
 
Overview

• A very extensive item db update for renewal mode
• The Numbers:
  • Over 6500 individual flag updates
  • 212 newly added/enabled items
• Made Possible Thanks To:
  • Muad_Dib for all the data
  • Yommy for the help on the equip field
  • Haru for the new upper masks and his ultimate parser skills that improved the quality of this update by many fold

In the update

• db/re/item_db (and thus sql-files/item_db_re.sql) over 6500 flag updates and 212 newly added/enabled items

  16: Upper Third jobs (Trans)32: Baby Third jobs

  • The AegisName field was updated in several entries to match the official ones
  • The name field was also updated in several entries to match the client display files
  • 2 New 'Upper' flags were added to accommodate many of the newly added items:
    • Custom items in renewal mode will require to have these new flags if you wish these jobs to make use of such items
• db/re/item_packages update to match the newly added items
• db/re/item_groups update to match the newly added items
• A new error message in the item db parser that will display any duplicate AegisName fields that are conflicting (Thanks to Masao)

Special Thanks
once again,

• Muad_Dib, this update wouldn't exist if it weren't for all the data he provided us with
• Yommy, wouldn't have been able to properly update the equip flags if it weren't for the job data he provided me with
• Haru, for making it possible to polish this update so many times. Haru spent many hours debugging this update and writing tools to further enhance the quality of the update

Link~u!

• Commit
• Commit 2 (Follow up)
  • Special Thanks to Yommy for bringing it to our attention and for providing the data for the follow up, and to Haru for help in validating the update

Edited February 7, 2017 by Ridley

[Brynner 34]

wow this is great!

[malufett 247]

Bravo!...

 

[Nameless2you 97]

wohoo~

[Neo-Mind 264]

finally distinction between two varieties of third classes. 

I thought there might be a change in the format of item db as well since it was being discussed 

Anyways i like the update   .

[Samuel 83]

Nice update. Good job guys.. xD

 

Hopefully, a new txt to sql converter will be release especially compatible with the sql style of hercules,

[jTynne 101]

Those of you with custom items, run this command to update your customs to be compatible:

 

update `item_db2` set `equip_upper` = 63 where `equip_upper` = 7;

 

Specifically, those of you running in RE mode as the class stuff changed. /ok

[icabit 4]

cool

nice update

[quesoph 105]

Awsome update!

 

@jTynne

Thanks for the tip !

[Michi 101]

Just amazing thanks for the big work =)

[OnNplay 27]

This just a big bang!

I pray to GOD for you all to keep steady for Hercules.

[madtoyz 2]

lot of changing

[Neo-Mind 264]

missing the Hello~What! in topic   

[boomboom3300 0]

This just a big bang!

I pray to GOD for you all to keep steady for Hercules.