PFM 3.5.2 - Updated string handling

[Walrusjones]

Are you changing their horse files as well?

[Swiss Halberdier]

Thanks Augustusng for the new table fix!

[Walrusjones]

So main units was another crash source, thank you Swiss!

[Swiss Halberdier]

So main units was another crash source, thank you Swiss!

Basically it was an "unknown" column until July. Modders can use this column to create an AOR (Area of recruitment) system in Attila. But it didn't caused a crash.

[Augustusng]

Are you changing their horse files as well?

Yep, I've changed the entries in the mounts table too. Not sure what else it could be.

Thanks Augustusng for the new table fix! I updated my scheme with your fix.

This post is an addition to my original post where I updated the scheme with fixes from several modders:
http://www.twcenter.net/forums/showt...1#post14595051

I counted 426 downloads and nobody reported any bugs from using it.

Here is the new updated master_schema.xml:
http://www.mediafire.com/view/0ccdz8...ter_schema.xml

These fixes for Attila are covered:

> main_units_tables (contains the AOR column "region_unit_resource_requirement" discovered by GrudgeNL, Ahiga, Swiss Halberdier)

For more information how to implement an AOR (Area of recruitment) system in Attila you can check Ahiga's/Swiss Halberdier's thread here:
[Resource] Community Campaign Map with Area of Recruitment/Unit Resources

> factions_tables
> campaign_climate_change_phases_tables
> campaign_religious_relations_tables
> culture_settlement_occupation_options_tables

Here are all codes listed:

Spoiler Alert, click show to read: 

<table table_name='main_units_tables'
         table_version='17' >
    <field name='additional_building_required' 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='religion_required' 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='unknown24' type='boolean' />
    <field name='unknown25' type='boolean' />
    <field name='unknown26' type='boolean' />
    <field name='unknown27' type='boolean' />
    <field name='unknown28' type='boolean' />
    <field name='unknown29' type='boolean' />
    <field name='unique_index' type='int' />
    <field name='special_edition_mask' type='int' />
    <field name='in_encyclopedia' type='boolean' />
    <field name='region_unit_resource_requirement' type='optstring_ascii' />
    <field name='voiceover' type='string_ascii' />
    <field name='ui_unit_group_land' type='string_ascii' />
    <field name='ui_unit_group_naval' type='string_ascii' />
    <field name='tier_level' type='int' />
</table>

<table table_name='factions_tables'
         table_version='18' >
    <field name='key' type='string_ascii' pk='true' />
    <field name='index' type='int' />
    <field name='unknown2' type='int' />
    <field fkey='cultures_subcultures_tables.subculture' name='subculture' type='string_ascii' />
    <field name='category' type='string_ascii' />
    <field name='screen_name' type='string_ascii' />
    <field name='screen_adjective' type='string_ascii' />
    <field fkey='names_groups_tables.key' name='name_group' type='int' />
    <field name='skin' type='string_ascii' />
    <field name='ui_skin' type='optstring_ascii' />
    <field name='is_rebel' type='boolean' />
    <field name='mp_use_republic_early' type='boolean' />
    <field name='mp_use_republic_late' type='boolean' />
    <field name='icons_path_units' type='string_ascii' />
    <field name='flags_path' type='string_ascii' />
    <field name='republican_flag_path' type='optstring_ascii' />
    <field name='same_gov_type_revolution_flag_path' type='optstring_ascii' />
    <field name='primary_colour_r' type='float' />
    <field name='primary_colour_g' type='float' />
    <field name='primary_colour_b' type='float' />
    <field name='alt_primary_colour_r' type='float' />
    <field name='alt_primary_colour_g' type='float' />
    <field name='alt_primary_colour_b' type='float' />
    <field name='secondary_colour_r' type='float' />
    <field name='secondary_colour_g' type='float' />
    <field name='secondary_colour_b' type='float' />
    <field name='alt_secondary_colour_r' type='float' />
    <field name='alt_secondary_colour_g' type='float' />
    <field name='alt_secondary_colour_b' type='float' />
    <field name='uniform_colour_r' type='float' />
    <field name='uniform_colour_g' type='float' />
    <field name='uniform_colour_b' type='float' />
    <field name='alt_uniform_colour_r' type='float' />
    <field name='alt_uniform_colour_g' type='float' />
    <field name='alt_uniform_colour_b' type='float' />
    <field fkey='groupings_military_tables.military_group' name='military_group' type='string_ascii' />
    <field fkey='factions_tables.key' name='settler_rebellion_faction' type='optstring_ascii' />
    <field name='rebel_colour_r' type='float' />
    <field name='rebel_colour_g' type='float' />
    <field name='rebel_colour_b' type='float' />
    <field fkey='movie_event_strings_tables.id' name='movie_death_event' type='optstring_ascii' />
    <field name='screen_name_when_rebels' type='string_ascii' />
    <field fkey='names_groups_tables.key' name='unit_regiment_name_group' type='int' />
    <field fkey='names_groups_tables.key' name='ship_name_group' type='int' />
    <field name='attack_desc' type='string_ascii' />
    <field name='defend_desc' type='string_ascii' />
    <field name='clan_summary_name' type='optstring_ascii' />
    <field name='pre_battle_speech_parameter' type='string_ascii' />
    <field name='can_be_regionless' type='boolean' />
    <field name='card_colour_r' type='float' />
    <field name='card_colour_g' type='float' />
    <field name='card_colour_b' type='float' />
    <field name='unknown52' type='int' />
    <field name='unknown53' type='boolean' />
    <field name='unknown54' type='boolean' />
    <field name='unknown55' type='boolean' />
    <field name='unknown56' type='string_ascii' />
    <field name='unknown57' type='optstring_ascii' />
    <field name='voiceover_subculture' type='string_ascii' />
</table>

<table table_name='culture_settlement_occupation_options_tables'
         table_version='2' >
    <field name='option' type='string_ascii' pk='true' />
    <field name='acting_army_faction_effect_bundle' type='optstring_ascii' />
    <field name='acting_army_faction_effect_bundle_turns' type='int' />
    <field name='target_settlement_faction_effect_bundle' type='optstring_ascii' />
    <field name='target_settlement_faction_effect_bundle_turns' type='int' />
    <field name='group' type='string_ascii' />
    <field name='acting_army_effect_bundle' type='optstring_ascii' />
    <field name='acting_army_effect_bundle_turns' type='int' />
</table>

<table table_name='campaign_climate_change_phases_tables'
         table_version='0' >
    <field name='campaign' type='string_ascii' />
    <field name='climate_art_set' type='string_ascii' />
    <field name='human_imperium_threshold' type='int' />
    <field name='phase' type='int' />
    <field name='round_threshold' type='int' />
    <field name='fertility_factor' type='int' />
</table>

<table table_name='campaign_religious_relations_tables'
         table_version='0' >
    <field name='attitude_base' type='float' />
    <field name='campaign' type='optstring_ascii' />
    <field name='negative_attitude_multiplier' type='float' />
    <field name='positive_attitude_multiplier' type='float' />
    <field name='source' type='string_ascii' />
    <field name='target' type='string_ascii' />
</table>

Thanks to you too! But don't forget the updated character_skill_nodes_tables.

<table table_name='character_skill_nodes_tables'
         table_version='4' >
    <field name='unknown0' type='optstring' />
    <field fkey='character_skills_tables.key' name='character_skill_key' type='string_ascii' />
    <field fkey='character_skill_node_sets_tables.key' name='character_skill_node_set_key' type='string_ascii' />
    <field fkey='factions_tables.key' name='faction_key' type='optstring_ascii' />
    <field name='indent' type='float' />
    <field name='key' type='string_ascii' />
    <field name='tier' type='float' />
    <field name='unknown7' type='optstring_ascii' />
    <field name='points_on_creation' type='int' />
  </table>

[Swiss Halberdier]

Thanks to you too! But don't forget the updated character_skill_nodes_tables.

I included this fix.

[Walrusjones]

Yep, I've changed the entries in the mounts table too. Not sure what else it could be.

I mean, I can get it to boot just by deleting the units still. I don't see the point of releasing an overhaul that doesn't nerf Athars Chosen to the ground, however.

[dreadnod244]

hey um I can't edit factions in factions table im no good at decoding lol I need a new schema

[dreadnod244]

it's for attila I can't edit that one

[Augustusng]

it's for attila I can't edit that one

See Swiss Halberdier's post above. He's uploaded a new schema for this already.

[legoras]

Solution how to open battlefield_buildings table ? I want to change barricade HP.

[Augustusng]

Solution how to open battlefield_buildings table ? I want to change barricade HP.

Here's an updated schema for it.

<table table_name='battlefield_buildings_tables'
         table_version='19' >
    <field name='key' type='string_ascii' />
    <field fkey='battlefield_building_categories_tables.category' name='category' type='string_ascii' />
    <field fkey='models_building_tables.key' name='model' type='string_ascii' />
    <field fkey='audio_materials_enums_tables.key' name='audio_material' type='string_ascii' />
    <field name='hit_points' type='int' />
    <field fkey='missile_weapons_tables.key' name='gun_type' type='optstring_ascii' />
    <field fkey='battlefield_buildings_names_tables.key' name='onscreen_name' type='optstring_ascii' />
    <field name='ignition_threshold' type='int' />
    <field name='radar_icon' type='optstring_ascii' />
    <field name='fortwall_penetration_chance' type='int' />
    <field name='visible_in_public_ted' type='boolean' />
    <field name='collision_3d' type='boolean' />
    <field name='destruct_thresholds' type='optstring_ascii' />
    <field name='joiner' type='boolean' />
    <field name='auxiliary' type='boolean' />
    <field name='burn_rate' type='float' />
    <field name='height_map_mesh' type='boolean' />
    <field name='can_burn' type='boolean' />
    <field fkey='battle_building_visibility_enums_tables.key' name='visibility_mode' type='string_ascii' />
    <field name='blood_pack_model_override_folder' type='optstring_ascii' />
  </table>

Also here's an update for the plagues_tables, not a new schema, just putting names on the columns, since I've been using this table. Helps to have names on the columns.

<table table_name='plagues_tables'
         table_version='0' >
    <field fkey='effect_bundles_tables.key' name='region_effect_bundle' type='optstring_ascii' />
    <field fkey='effect_bundles_tables.key' name='military_force_effect_bundle' type='optstring_ascii' />
    <field name='grade' type='int' />
    <field name='infectivity' type='int' />
    <field name='lifetime' type='int' />
    <field name='minimum_squalor' type='int' />
    <field name='name' type='string_ascii' />
  </table>

[legoras]

Thanks a lot!!!

[SharpEyed]

thanks to all people that are contributing to update the master_schema thingy

it may not be so hard with the great help of assembly kit but it's time consuming, that's for sure

[Yenicer]

Even with the new schema Attila is crashing after changes in land_units

[THANGDACLAC]

They waste time to do this fk thing. Nothing has changed, land_units can't be changed. I wait for dainu to make new version of PFM.(although i copy these codes and add to master schema)

[Walrusjones]

You can change land units if you delete the following units from the list:

Warra'i
Sana'i
Athars's Chosen
Beher's Chosen
Mavra's Chargers, Chosen, Lancers, and Bodyguard
Almaqua's Lancers
T'or Warriors.
Elite T'or Warriors
Mäsqäl Spearmen

(If it still crashes, I would move on to Marz archers next.)

[SharpEyed]

Thanks Augustusng for the new table fix! I updated my scheme with your fix.

This post is an addition to my original post where I updated the scheme with fixes from several modders:
http://www.twcenter.net/forums/showt...1#post14595051

I counted 426 downloads and nobody reported any bugs from using it.

Here is the new updated master_schema.xml:
http://www.mediafire.com/view/0ccdz8...ter_schema.xml

These fixes for Attila are covered:

> main_units_tables (contains the AOR column "region_unit_resource_requirement" discovered by GrudgeNL, Ahiga, Swiss Halberdier)

For more information how to implement an AOR (Area of recruitment) system in Attila you can check Ahiga's/Swiss Halberdier's thread here:
[Resource] Community Campaign Map with Area of Recruitment/Unit Resources

> factions_tables
> campaign_climate_change_phases_tables
> campaign_religious_relations_tables
> character_skill_nodes_tables
> culture_settlement_occupation_options_tables

thanks again, but I have a question, PFM can open the "culture_settlement_occupation_options_tables" but shows it as red, is that intended?

[dreadnod244]

hey in master_schema the unkown54 is already there but still can't open faction tables. how do I fix this?

[RainWizzard]

Hello guys I am trying to create a mod for the Himyar by adding the semitic units to the top tier jewish rax, I though all this would require was some copy and pasting in budildings_units_allowed but there is no unknown 6 in my directory and when I copy the unit entries and give them unique numbers the game refuses to start, help here would be great