Page 2 of 3 FirstFirst 1 2 3 LastLast
Results 21 to 40 of 46

Thread: PFM Schema Update Thread

  1. #21

    Default Re: PFM Schema Update Thread

    Rome 2-
    Code:
        <table table_name='faction_civil_war_setups_tables'         table_version='2' >
        <field fkey='factions_tables.key' name='primary_faction' type='string_ascii' pk='true' />
        <field fkey='factions_tables.key' name='secondary_faction' type='string_ascii' />
        <field name='unknown2' type='string_ascii' />
      </table>
    
    
      
    <table table_name='faction_to_campaign_junctions_tables'
             table_version='0' >
        <field name='campaign' type='string_ascii' />
        <field name='faction' type='string_ascii' />
      </table>
      
      <table table_name='character_skill_nodes_tables'
             table_version='2' >
        <field name='unknown0' type='optstring_ascii' />
        <field name='unknown1' type='string_ascii' />
        <field name='unknown2' type='string_ascii' />
        <field name='unknown3' type='optstring_ascii' />
        <field name='unknown4' type='int' />
        <field name='unknown5' type='string_ascii' />
        <field name='unknown6' type='int' />
        <field name='unknown7' type='optstring_ascii' />
      </table>
      
        <table table_name='political_traits_tables'
             table_version='0' >
        <field name='unknown0' type='string_ascii' />
        <field name='unknown1' type='string_ascii' />
        <field name='unknown2' type='optstring_ascii' />
      </table>
      <table table_name='politics_government_type_political_action_junctions_tables'
             table_version='0' >
        <field name='unknown0' type='string_ascii' />
        <field name='unknown1' type='boolean' />
        <field name='unknown2' type='boolean' />
        <field name='unknown3' type='boolean' />
        <field name='unknown4' type='boolean' />
        <field name='unknown5' type='string_ascii' />
      </table>
          <table table_name='politics_government_types_tables'
             table_version='0' >
        <field name='unknown0' type='string_ascii' />
      </table>
      <table table_name='political_actions_effect_bundles_tables'
             table_version='2' >
        <field name='unknown0' type='string_ascii' />
        <field name='unknown1' type='string_ascii' />
        <field name='unknown2' type='int' />
      </table>
      <table table_name='region_campaign_overrides_tables'
             table_version='0' >
        <field name='unknown0' type='string_ascii' />
        <field name='unknown1' type='string_ascii' />
        <field name='unknown2' type='boolean' />
        <field name='unknown3' type='string_ascii' />
        <field name='unknown4' type='int' />
      </table>
      <table table_name='plagues_tables'
             table_version='0' >
        <field name='unknown0' type='int' />
        <field name='unknown1' type='int' />
        <field name='unknown2' type='int' />
        <field name='unknown3' type='string_ascii' />
        <field name='unknown4' type='int' />
        <field name='unknown5' type='string_ascii' />
        <field name='unknown6' type='string_ascii' />
      </table>
      <table table_name='send_diplomat_incidents_tables'
             table_version='0' >
        <field name='unknown0' type='string_ascii' />
        <field name='unknown1' type='string_ascii' />
        <field name='unknown2' type='string_ascii' />
        <field name='unknown3' type='int' />
      </table>
      <table table_name='culture_subculture_politics_government_types_tables'
             table_version='3' >
        <field name='unknown0' type='string_ascii' />
        <field name='unknown1' type='string_ascii' />
        <field name='unknown2' type='optstring_ascii' />
        <field name='unknown3' type='string_ascii' />
        <field name='unknown4' type='optstring_ascii' />
        <field name='unknown5' type='optstring_ascii' />
        <field name='unknown6' type='boolean' />
        <field name='unknown7' type='string_ascii' />
      </table>
    Main units needs an update, if anyone can work on that.
    Last edited by Dresden; November 08, 2017 at 11:06 PM.

  2. #22
    Litharion's Avatar Artifex
    Join Date
    Sep 2013
    Location
    Germany
    Posts
    2,602

    Default Re: PFM Schema Update Thread

    Rome 2
    Code:
     <table table_name='main_units_tables'
             table_version='13' >
        <field name='unknown0' type='optstring_ascii' />
        <field name='campaign_cap' type='int' />
        <field fkey='unit_castes_tables.caste' name='caste' type='string_ascii' />
        <field name='create_time' type='int' />
        <field name='is_naval' type='boolean' />
        <field fkey='land_units_tables.key' name='land_unit' type='string_ascii' />
        <field name='num_men' type='int' />
        <field name='multiplayer_cap' type='int' />
        <field name='multiplayer_cost' type='int' />
        <field fkey='naval_units_tables.key' name='naval_unit' type='optstring_ascii' />
        <field name='num_ships' type='int' />
        <field name='min_men_per_ship' type='int' />
        <field name='max_men_per_ship' type='int' />
        <field name='prestige' type='int' />
        <field name='recruitment_cost' type='int' />
        <field name='unknown15' type='optstring_ascii' />
        <field name='unknown16' type='optstring_ascii' />
        <field name='unit' type='string_ascii' pk='true' />
        <field name='upkeep_cost' type='int' />
        <field fkey='unit_weights_tables.key' name='weight' type='optstring_ascii' />
        <field name='campaign_total_cap' type='int' />
        <field name='unknown21' type='boolean' />
        <field name='unknown22' type='boolean' />
        <field name='unknown23' type='boolean' />
        <field name='special_edition_mask' type='int' />
        <field name='unique_index' type='int' />
        <field name='prestige27' type='int' />
        <field name='in_encyclopedia' type='boolean' />
        <field fkey='region_unit_resources_tables.key' name='region_unit_resource_requirement' type='optstring_ascii' />
        <field fkey='cultures_subcultures_tables.subculture' name='audio_language' type='string_ascii' />
        <field name='unknown31' type='optstring_ascii' />
      </table>
    main unit table now working, some strange entries after the audio entry...
    EasSpecial
    RomSpecial
    Last edited by Litharion; November 09, 2017 at 08:52 AM.

  3. #23

    Default Re: PFM Schema Update Thread

    Thanks buddy!

    Those entries refer to audio_vo keys in a new table.

  4. #24

    Default Re: PFM Schema Update Thread

    Litharion, Thanks so much

  5. #25

  6. #26

    Default Re: PFM Schema Update Thread

    I'm downloading Rome2 right now, and can start to look through the tables tomorrow. I'll combine a new schema with the fixes from Dresden and Litharion, thanks guys.

    Further I want to integrate more drop down columns for the Warhammer tables. Any wishes?

  7. #27
    Magnar's Avatar Artifex
    Join Date
    Jul 2013
    Location
    The last place you look
    Posts
    4,142

    Default Re: PFM Schema Update Thread

    @Litharion, did you manually change the table number to 13? That number already exists and as such it should be different or there will be backwards compatibility issues.

  8. #28
    Magnar's Avatar Artifex
    Join Date
    Jul 2013
    Location
    The last place you look
    Posts
    4,142

    Default Re: PFM Schema Update Thread

    Rome 2

    Code:
      <table table_name='banditry_events_tables'
             table_version='0' >
        <field name='unknown0' type='int' />
        <field name='unknown1' type='string_ascii' />
        <field name='unknown2' type='float' />
        <field name='unknown3' type='string_ascii' />
        <field name='unknown4' type='string_ascii' />
        <field name='unknown5' type='int' />
      </table>
    
      <table table_name='province_to_mercenary_set_junctions_tables'
             table_version='1' >
        <field fkey='mercenary_pools_tables.key' name='mercenary_set' type='string_ascii' pk='true' />
        <field fkey='provinces_tables.key' name='province' type='string_ascii' pk='true' />
        <field name='unknown2' type='optstring_ascii' />
      </table>
    think thats the lat of the tables
    Last edited by Magnar; November 14, 2017 at 04:49 AM.

  9. #29

    Default Re: PFM Schema Update Thread

    I seem to be getting crashes when adding new units to the game or creating completely new mods.

  10. #30

    Default Re: PFM Schema Update Thread

    If i implement the changes to the Rome 2 main unit tables, it allows me to edit files made for patch 18, but I can no longer open the main unit tables of older files.

  11. #31

    Default Re: PFM Schema Update Thread

    Hi all.
    Sorry for the delay, I uploaded the fixes for the Rome2 Power and Politics update today. I also included in schema version 106 updates for WH2, all tables should work properly now.

  12. #32

    Default Re: PFM Schema Update Thread

    Thanks so much! Main_units table in Rome 2 opens with schema version 106.
    Last edited by Starsmil; December 01, 2017 at 08:24 AM.

  13. #33

    Default Re: PFM Schema Update Thread

    I have updated mods that use main units for rome2 and they dont work still.. think there is still something funky going on.
    ~My Rome 2 Mods~
    No Moral, Land and Naval
    ---------------------------
    ~My Shogun 2 Mods~
    1 Turn Buildings all campaigns
    ---------------------------
    No unit moral, Land and Naval

  14. #34
    Maximus183's Avatar Ducenarius
    Join Date
    Oct 2008
    Location
    Magna Scandinavia
    Posts
    991

    Default Re: PFM Schema Update Thread

    Also seems to be something strange going on with Attila's unit_variants table. Changes aren't taking effect.

  15. #35

    Default Re: PFM Schema Update Thread

    Hi everyone,
    todays new version 107 includes updates for:

    Rome2:
    - column names and minor tweaks for all newly added tables from the last Power and Politics update
    - a new main_units version: some column names were mixed up, some columns didn't show up at all. I can't seem to get rid of column unknown26 though, it doesn't do anything.
    - fix for the new banditry_event, column "duration" was not showing

    Attila:
    - included is a properly working version of the agents tables

    WH2:
    - a fix for main_units, column "food_cost" is properly shown now
    - added first working version for table lab_settings
    - fixed intrigue_actions_incidents_junctions_tables
    - named the ritual_tables columns
    - land_units: changed those unknown boolean columns into "num_animals" and "animal"
    Last edited by Larynja; December 15, 2017 at 06:51 AM.

  16. #36
    Maximus183's Avatar Ducenarius
    Join Date
    Oct 2008
    Location
    Magna Scandinavia
    Posts
    991

    Default Re: PFM Schema Update Thread

    Using that latest schema I'm getting the following error for Attila when trying to open campaign_character_arts_tables.


  17. #37

    Default Re: PFM Schema Update Thread

    Quote Originally Posted by Maximus183 View Post
    Using that latest schema I'm getting the following error for Attila when trying to open campaign_character_arts_tables.
    Did it work prior to the update? I didn't change anything about that table. I'll check it.

  18. #38
    Maximus183's Avatar Ducenarius
    Join Date
    Oct 2008
    Location
    Magna Scandinavia
    Posts
    991

    Default Re: PFM Schema Update Thread

    No idea to be honest but probably not. Thanks!

  19. #39

    Default Re: PFM Schema Update Thread

    Quote Originally Posted by Larynja View Post
    Hi everyone.

    To make it easier to separate db editing updates and PFM bug reports and usage questions, we decided to split it into two different threads.
    From now on, I'll post any schema related news in this thread. Feel free to ask any db schema related questions and let me now if something isn't working properly. For everything else the PFM main thread can still be used.
    All db schemas can still be downloaded here.
    If you get a chance, could you correct the following tables for the next schema update for TWW2 please.

    army_special_abilities_tables (There is a column too many also)
    army_special_ability, unit_special_ability, unique_id, enables_siege_assaults

    effect_bonus_value_military_force_ability_junctions_tables
    effect, bonus_value_id, force_ability

    special_ability_to_invalid_target_flags_tables
    special_ability, invalid_target

    unit_abilities_additional_ui_effects_tables
    key, sort_order

    unit_abilities_to_additional_ui_effects_juncs_tables
    ability, effect

    unit_sets_tables
    key, use_unit_exp_level_range, min_unit_exp_level_exclusive, max_unit_exp_level_inclusive

    Thank you in advance.

  20. #40

    Default Re: PFM Schema Update Thread

    Hey Larynja! Been working on something in the battle_set_pieces tables, and noticed every column was labeled as "unknown". So I took it upon myself to rename them, using data_core in PFM and DaVE to make sure everything matched perfectly. I have my updated master_schema here: https://drive.google.com/open?id=1OL...qvgaahWxj6UdSw ; Column 4032 - 4208 field names have been adjusted to their DaVE equivalent

    Most of the columns are also in a weird order compared to their placement in DaVE. Notably, battle_set_pieces_tables, battle_set_piece_armies_tables, and battle_set_piece_armies_characters_tables.

Page 2 of 3 FirstFirst 1 2 3 LastLast

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •