I'd also like to know how to fix the participation of teams in the various races, including a wild-card system for the Tour de France, or the participation of all teams of a country in their national tour (including the Giro and the Vuelta)
Moreover, I would also know how to properly adjust the different teams in the three divisions (how many teams in GS1 and GS2, will the game be playable with few teams in GS3 and maybe zero ?)
I would also like to know how to change the name of the material to have the name of realistic equipment.
I'd also like to know how to fix the participation of teams in the various races, including a wild-card system for the Tour de France, or the participation of all teams of a country in their national tour (including the Giro and the Vuelta)
sta_race -> gene_ilist_fkidteam
Moreover, I would also know how to properly adjust the different teams in the three divisions (how many teams in GS1 and GS2, will the game be playable with few teams in GS3 and maybe zero ?)
dyn_team -> fkid_team. The game needs at least 5 teams in CT otherwise you'll fuck up the promotion/relegation system in career mode, but you can put 0 if your db is not intended for savegames.
I would also like to know how to change the name of the material to have the name of realistic equipment.
sta_brand to change the brand names, sta_equipment_model to change the model names, dyn_brand_contract to change the brands assigned to each team.
I'd also like to know how to fix the participation of teams in the various races, including a wild-card system for the Tour de France, or the participation of all teams of a country in their national tour (including the Giro and the Vuelta)
sta_race -> gene_ilist_fkidteam
When i try to fix the participation, i see this :
So i wonder two things :
- why these numbers and what do they match ?
- what shall I do for the three "Grand Tours" ? Put 10, 12, 14 or 18 teams in the field and in game missing teams will be provided by wild cards ?
Those numbers are the team ids in dyn_team. If the IDs remain numeric, that means no teams referincing to that ID can be found in dyn_team. When fast editor finds a reference in dyn_team, it will write down the team name instead of the mere ID.
- what shall I do for the three "Grand Tours" ? Put 10, 12, 14 or 18 teams in the field and in game missing teams will be provided by wild cards ?
You can 1. take a look at sta_uci_class/sta_race_rules and change the amount of maximum teams in a race or 2. put the amount of teams you want in sta_race -> teams list as long as they're less than the limit of teams provided in the aforementioned tables and the rest will be in fact decided by the game through wild cards, in career mode. In single race mode, wild cards will not be used.
2. put the amount of teams you want in sta_race -> teams list as long as they're less than the limit of teams provided in the aforementioned tables and the rest will be in fact decided by the game through wild cards, in career mode. In single race mode, wild cards will not be used.
Wild-Cards are awarded for each race, or only main races such as WT ?
For example : la Vuelta de Burgos. If I set the race for 16 participating teams, and if I choose to include all Spanish, Colombian and Portuguese, there are four places remaining. In career mode, will this race be contested by only these 12 teams selected, or 16 after four wild-cards ? In the second case, what criterias will be considered ?
"wild-cards" - which in case of non-WT races are not wildcards but simply teams asking for invitations - are a thing. But it's not 100% sure 4 teams will fill the 4 remaining spots, in fact, most of the time you'll find yourself with only those initial 12 teams or just 1 or 2 more.
Is it possible to program automatically a change of sponsor (and therefore associated jersey)? For example Reynolds stopping at the end of the first season to make way for Banesto. And if it is, how proceed ?
Theoretically yes, practically, not sure. Not sure mostly if the game overwrites the changes you make during the save game. But what you need to follow is this guide and apply it on the database and not on your save game.
Nationalism has never been used in PCM but apparently Cyanide prefers to keep columns just in case.
And "IDtype_rider_orientation" in the table DYN_team ? And what is the use of the values "charisme" and "popularity" ?
The kind of rider teams prefer to sign. Etixx will prefer Northern Classics riders, Movistar climbers. You can find out what the numbers mean in sta_type_rider.
Charisme it's not used anymore I don't think, popularity is the chance a certain rider has to spark the interest of other teams in a scale from 0 to 100. It also makes sponsors happier to have riders with higher popularities.
CONSTANT isn't used anymore either, but it used to be used to differentiate certain teams from others for certain aspects of the game. For example, BMC used to be the demo team a few games ago, the one shown in the tutorial.
fkid calendar 3 the 3rd preferred calendar. sta_roster_listraces are lists of races part of a certain type of season a rider can have.
Thanks thanks to you matt17br, the DB will probably be finished soon !
In the table DYN_sponsor, if i leave 0 in the column "budget", does it mean that the teams will start the season without money ? Or the money will be automatically awarded, and if so, what criteria?
The table DYN_sponsor_regions : is it used to fix the recruitment of riders already in game (and with others teams, or free-agent), or is it used to indicate what kind of neo-professional a team will pick?
In the table DYN_sponsor, if i leave 0 in the column "budget", does it mean that the teams will start the season without money ? Or the money will be automatically awarded, and if so, what criteria?
Second one you said, dbs normally have budget on 0 for all teams. Criterium as far as I know is only fame of the sponsor.
The table DYN_sponsor_regions : is it used to fix the recruitment of riders already in game (and with others teams, or free-agent), or is it used to indicate what kind of neo-professional a team will pick?
Second one you said again, it's the percentage of riders coming from a certain nationality the team sponsor requires the team to have in their roster. It's again a scale from 0 to 100, where 100 means all riders need to come from a certain region, 0 where the sponsor leaves carte blanche to the team nationalities wise. The importance - 1, 2 or 3 - affects how much happy or disappointed the sponsor can be if you meet the targets they set.
Well, with the Zuri-Metzgete race i found in another site, i can say the pre-version of the DB comes quickly !
But I intend to create a DB careful and realistic as much as possible, as I wondered what would happen if I removed Kazakhstan, Ukraine and Lithuania on the list of countries participating in the World Championships ? Bug or not ?
I also need help for the table STA_journalist. If possible, do people walking around (and more precisely in this topic) can tell me, if they know, the name of his main local cyclist journalist at the end of the 80s ?
But I intend to create a DB careful and realistic as much as possible, as I wondered what would happen if I removed Kazakhstan, Ukraine and Lithuania on the list of countries participating in the World Championships ? Bug or not ?
If you mean removing their entries from dyn_national team and putting a 0 in the nt column in sta_country that's ok. There's a limit of 26 for national teams so you can still add 3 others - or just leave the game with only 23 teams.
