|
1989 Database
|
| vandentruckmusch |
Posted on 14-09-2016 14:17
|
Under 23
Posts: 86
Joined: 25-05-2007
PCM$: 200.00
|
Hi everyone !
I just finished creating (names + rating + riders in teams) a 1989 DB. There are the following teams :
Belgium : ADR-W-Cup, Mini-Flat-Isoglass, Domex-Weinmann, Lotto, S.E.F.B., Boccaccio Life, La William, Humo TW Rock, Histor-Sigma, Hitachi
Columbia : Kelme, Café de Colombia, Manzana Postobon
Spain : BH, O.N.C.E., Caja Rural, Reynolds, Puertas Mavisa, Lotus-Zahor, CLAS, Seur, Teka
France : Fagor, Super U-Raleigh, R.M.O., Z-Peugeot
Netherlands : PDM, TVM, Panasonic, Superconfex
Italy : Atala, Ariostea, Malvor-Sidi, Gewiss, Carrera, Chateau d'Ax, Del Tongo, Jolly
Australia : Polli-Mobiexport
San Marino : Alfa-Lum (but only soviet riders)
West Germany: Stuttgart
Switzerland : Frank-Toyo, Eurocar, Helvetia
USA 7Eleven, Coors Light
______________________
But the work is not yet complete. Indeed, I want to change several settings via the Fast Editor to make the DB playable in career mode and realistic. So I need help to put to Het Volk and Paris-Tours in the World Tour instead of Beijing and Down Under, demote the GP de Québec (to keep the Montreal race as single WT contest), and, if possible (= if I can find the course), put the GP des Nations, the Wincanton Classic and Zurich Metzgere in WTi.
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.
Thanks for your help, |
| |
|
|
| matt17br |
Posted on 14-09-2016 15:49
|
Directeur Sportif
Posts: 10525
Joined: 28-09-2013
PCM$: 200.00
|
But the work is not yet complete. Indeed, I want to change several settings via the Fast Editor to make the DB playable in career mode and realistic. So I need help to put to Het Volk and Paris-Tours in the World Tour instead of Beijing and Down Under, demote the GP de Québec (to keep the Montreal race as single WT contest), and, if possible (= if I can find the course), put the GP des Nations, the Wincanton Classic and Zurich Metzgere in WTi.
Edit this in sta_race under fkid_uci_class
In order to add races follow this guide: https://pcmdaily.com/tipstricks.php?ti...p?tipid=50
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.
|
| |
|
|
| vandentruckmusch |
Posted on 14-09-2016 17:51
|
Under 23
Posts: 86
Joined: 25-05-2007
PCM$: 200.00
|
Thanks for the reply which is very helpful.
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 ?
|
| |
|
|
| matt17br |
Posted on 14-09-2016 19:27
|
Directeur Sportif
Posts: 10525
Joined: 28-09-2013
PCM$: 200.00
|
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.
|
| |
|
|
| vandentruckmusch |
Posted on 15-09-2016 12:44
|
Under 23
Posts: 86
Joined: 25-05-2007
PCM$: 200.00
|
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 ? |
| |
|
|
| matt17br |
Posted on 15-09-2016 12:49
|
Directeur Sportif
Posts: 10525
Joined: 28-09-2013
PCM$: 200.00
|
"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.
|
| |
|
|
| vandentruckmusch |
Posted on 16-09-2016 00:44
|
Under 23
Posts: 86
Joined: 25-05-2007
PCM$: 200.00
|
Many thanks again for your help !
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 ? |
| |
|
|
| Ad Bot |
Posted on 22-12-2024 01:54
|
Bot Agent
Posts: Countless
Joined: 23.11.09
|
|
| IP: None |
|
|
| matt17br |
Posted on 16-09-2016 07:09
|
Directeur Sportif
Posts: 10525
Joined: 28-09-2013
PCM$: 200.00
|
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.
https://pcmdaily.c...st_1021283
|
| |
|
|
| vandentruckmusch |
Posted on 16-09-2016 17:34
|
Under 23
Posts: 86
Joined: 25-05-2007
PCM$: 200.00
|
O.K. many thanks again ?
And now, what means the value "nationalisme" in the table DYN_cyclist ?
And "IDtype_rider_orientation" in the table DYN_team ? And what is the use of the values "charisme" and "popularity" ? |
| |
|
|
| matt17br |
Posted on 16-09-2016 21:58
|
Directeur Sportif
Posts: 10525
Joined: 28-09-2013
PCM$: 200.00
|
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.
|
| |
|
|
| vandentruckmusch |
Posted on 17-09-2016 12:10
|
Under 23
Posts: 86
Joined: 25-05-2007
PCM$: 200.00
|
Well, "nationalism" sounds very strangely... Patriotism, I'd have undesrtood, but "Nationalism"...
In the table DYN_team, what's the use of "CONSTANT" ? And "fkIDcalendar3" ? And the table "STA_roster_listraces" ? |
| |
|
|
| matt17br |
Posted on 17-09-2016 12:54
|
Directeur Sportif
Posts: 10525
Joined: 28-09-2013
PCM$: 200.00
|
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.
|
| |
|
|
| vandentruckmusch |
Posted on 17-09-2016 12:59
|
Under 23
Posts: 86
Joined: 25-05-2007
PCM$: 200.00
|
If I understand, sta_roster_listraces is a sort of mandatory program for selected riders ? |
| |
|
|
| matt17br |
Posted on 17-09-2016 13:21
|
Directeur Sportif
Posts: 10525
Joined: 28-09-2013
PCM$: 200.00
|
Yep
|
| |
|
|
| vandentruckmusch |
Posted on 17-09-2016 16:13
|
Under 23
Posts: 86
Joined: 25-05-2007
PCM$: 200.00
|
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? |
| |
|
|
| matt17br |
Posted on 17-09-2016 16:32
|
Directeur Sportif
Posts: 10525
Joined: 28-09-2013
PCM$: 200.00
|
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.
|
| |
|
|
| vandentruckmusch |
Posted on 17-09-2016 21:18
|
Under 23
Posts: 86
Joined: 25-05-2007
PCM$: 200.00
|
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 ? |
| |
|
|
| matt17br |
Posted on 18-09-2016 00:49
|
Directeur Sportif
Posts: 10525
Joined: 28-09-2013
PCM$: 200.00
|
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.
|
| |
|
|
| vandentruckmusch |
Posted on 18-09-2016 13:10
|
Under 23
Posts: 86
Joined: 25-05-2007
PCM$: 200.00
|
EDIT : I had a problem but it was solved
Edited by vandentruckmusch on 18-09-2016 18:02
|
| |
|
|
| matt17br |
Posted on 18-09-2016 19:36
|
Directeur Sportif
Posts: 10525
Joined: 28-09-2013
PCM$: 200.00
|
Can't see any problem on a quick glance, would prefer if you sent me the actual db though because those pics are hard to pay attention to.
|
| |
|
