This is a work in progress for when and if someone wants to build a non classical version of the database.
Database Changes Required:
- Starting factions table in the eq2emu world server must be added, removed from classic since clients have a variety of “choice” sent. DoF sends 0 for boat 1 for isle of refuge, while newer clients like AoM send a starting city value. Removing all starting factions allows us to have a blank faction slate and when we arrive on isle of refuge we can pick Qeynos or Freeport without factions preset.
/resources/starting_factions.zip
- Spells and data must be reverted as the content team re-used spells and focused on a classic commoner design
- Spells in the standard database are classic data and names, need to revert data/names to respective values for after LU19 and when KoS began.
/resources/eq2emu_2021_spells.zip
- spell_traits table in classic only has ID 1000+ for the classic traits. The original traits have spell_traits ID's of 428 and lower. Those were removed to not conflict with the classic setup, the whole set is included below. If you want non classic you need to delete from spell_traits where id≥1000;
/resources/spell_traits_restorenonclassic.zip
- Abilities/Spells to specific classes are removed from starting_spells in the classic DB, insert the original sql
/resources/starting_spells_nonclassic.zip
Rules to be changed:
- Mini Dings are every 10% after classic, not 20%:
update ruleset_details set rule_value=10 where rule_type='MiniDingPercentage';