Summary.

1. If I want to add or delete a race, which tables do I need to edit?

1. Open up STA_race. This is the table where you add the 'general' settings for the race, e.g. the name, the UCI classification, etc. What's important to understand is that you can find out what you need to type into each column by looking in other tables of the DB.

E.g., you need to type in the country code of the race in fkIDcountry. You can find these in STA_country. Next, you need to type in UCI classification of the race in fkIDnewUCI_class - you can find these by looking in STA_UCI_class.

And so on.

You also need to add some stages to the race. This is done in STA_race and is a bit more complicated. There's several 'technical' words, but have a look at this document, and you should be alright. (CrueTrue)

https://www.pcmdaily.com/forum/attachm...itions.rar

2. If I want to add or delete a team, which tables do I need to edit?

Adding a team is done in DYN_team. As with the STA_race, you can find what you need by looking in other tables of the DB. Some of the ones you can't find are value_i_nationalism (1 = not nationalistic, 4 = very nationalistic), which decides whether a team should sign riders from other countries than the origin country, gene_sz_tga_skin, which is what the riders' skin colour will be (can be found in CM_Textures/cycliste/skin) and the equipment tables (copy the ones from a different team, and you should be alright). In general, check a different team when filling in your own. (CrueTrue)

3. If I want to add or delete a rider, which tables do I need to edit?

Adding a rider is done in DYN_cyclist. Mainly focus on the name tables, country, team, photo, birthday and age, potential and the stats. Copy the rest from the rider above the one you're adding.

There's one column called value_f_current_evaluation. You don't need to fill out this column as it's calculated automatically by the game.
However, if you're adding an entire team, and all of them have 0 in that column, the team will show up with only 1 star in the team selection screen. The way to avoid this is to start a game with your new DB, then open your save game and copy the calculations from the game to the DB. (CrueTrue)

4. How can I edit riders' favourite races?

Open up DYN_cyclist. Find "gene_ilist_fkIDfavorite_races" column and type in races' IDs - you can find them in STA_race. (Adams55)

5.How do I edit the riders training tiredness and race days?

DYN_cyclist and the columns fitness_f_forme_fatigue and fitness_f_race_points. (CrueTrue)

6.Is there a save-game editor like it was in the 06 version?

No, no yet. (CrueTrue)

7. How do you get started with the Advanced Editor

You put the database you want to edit in "Databases" and open the Editor. In the Import section, find the DB, write something in the Output folder and click Export. (CrueTrue)



8.How can I edit the riders contracts?

Done in DYN_contract_cyclist. (CrueTrue)

9. How can I add scouting zones?, I want to make China a scouting zone, for example, and then add a few young china riders.

Well, basically, you need to look in STA_newrider_area. You'll quickly notice that it's a bit more complicated than another kinds of editing - but of course, it can be done. It may just be me who thinks it's complicated. (CrueTrue)

Also, try this thread. I haven't read it all though, so it could be absolute nonsense. (fenian)

https://www.pcmdaily.com/forum/viewthr...rowstart=0

10. How can i edit finance ?

Gene_f_solde in DYN_team.

11. Could you tell me how to edit a rider's favoured weather please? And disliked weather, favoured temps and disliked temps.

DYN_cyclist. gene_ilist_fkIDtemp_favorite/detestee and gene_ilist_fkID_weather_favorite/detestee. (CrueTrue)

12. This question will help many fans of the "custom team" function, I think. Since some of us like to use an all youth team, and by this get a bad sponsor confidence.

How do you edit the sposor confidence in PCM09? It has changed since last version..

It has changed, yes, but the idea is the same.

Open DYN_manager, find sponsor_f_points, sponser_f_coeff_from_team_classification and sponsor_f_overall. Set the values higher than they are, and your sponsor confidence will increase. (CrueTrue)

Strangely, my first questions are:

1. If I want to add or delete a race, which tables do I need to edit?

2. If I want to add or delete a team, which tables do I need to edit?

3. If I want to add or delete a rider, which tables do I need to edit?

1. STA_race

2. DYN_team

3. DYN_cyclist

I'm pretty sure there are other tables too for each of the questions.

For example, for 1, you need to edit sponsor goals if you delete a race. You also need to do add/delete stages in another table.

I don't think you ever need to delete races
And if you delete race, I don't 'need' to delete stages, too... Only if you add race...
But with the sponsor goals you was right...

You had true...I little misunderstood your questions

1. Open up STA_race. This is the table where you add the 'general' settings for the race, e.g. the name, the UCI classification, etc. What's important to understand is that you can find out what you need to type into each column by looking in other tables of the DB.

E.g., you need to type in the country code of the race in fkIDcountry. You can find these in STA_country. Next, you need to type in UCI classification of the race in fkIDnewUCI_class - you can find these by looking in STA_UCI_class.

And so on.

You also need to add some stages to the race. This is done in STA_race and is a bit more complicated. There's several 'technical' words, but have a look at this document, and you should be alright.

2. Adding a team is done in DYN_team. As with the STA_race, you can find what you need by looking in other tables of the DB. Some of the ones you can't find are value_i_nationalism (1 = not nationalistic, 4 = very nationalistic), which decides whether a team should sign riders from other countries than the origin country, gene_sz_tga_skin, which is what the riders' skin colour will be (can be found in CM_Textures/cycliste/skin) and the equipment tables (copy the ones from a different team, and you should be alright). In general, check a different team when filling in your own.

3. Adding a rider is done in DYN_cyclist. Mainly focus on the name tables, country, team, photo, birthday and age, potential and the stats. Copy the rest from the rider above the one you're adding.

There's one column called value_f_current_evaluation. You don't need to fill out this column as it's calculated automatically by the game.
However, if you're adding an entire team, and all of them have 0 in that column, the team will show up with only 1 star in the team selection screen. The way to avoid this is to start a game with your new DB, then open your save game and copy the calculations from the game to the DB.


I'm planning to write an article serial where I go through the steps of making a 'complete' DB. I'll go into more depth in those

deleted, because to late

A lot of this were changed in PCM09.

DYN_contract_cyclist is no longer used pre-game. It's automatically done when starting a career.

STA_race only needs entries of the team for it to participate in Single Race mode - not in career mode.

DYN_team_race is only used in save games, not pre-game. Just like in PCM08.

Edit: Lachi edited his post

Cool. Thanks for the info.

And one more question.

I remember before when Basso was suspended I added him to a different .db. I think because I didn't give him a ranking, he was valued very lowly, nobody was interested in him and I was able to get him for a very low wage as a free agent.

Any advice on handling the rankings part? If I ranked him say 15, I'd have had to amend a couple of hundred other rankings...

So, is it a secret? Or just a case of getting excel to re-jig the numbers?

Didn't see your response.

I actually didn't know that the ranking had any effect. I usually give all the rider 0 in the UCI rank, and that's been working out fine so far

Besides, having two riders with the rank of 15 wouldn't do any harm, I guess.

Thanks and thinking about it, I can't remember if I added Basso into a savegame at the end of season 1 or the 'original' .db.

Even though I gave him stats making him one of the best riders in the game, no one was interested and I managed to sign him for Skil-Shimano on 5,000 a week. I just assumed at the time it was the lack of ranking as his stats were way up there...

How can I edit riders' favourite races?

Open up DYN_cyclist. Find "gene_ilist_fkIDfavorite_races" column and type in races' IDs - you can find them in STA_race.

Thanks. Dzieki!

1.How do I edit the riders training tiredness and race days?

2.Is there a save-game editor like it was in the 06 version?

1. DYN_cyclist and the columns fitness_f_forme_fatigue and fitness_f_race_points.

2. No, unfortunately not.

I see here how to add a rider, but im actually interested in how to delete one with the advanced editor, in the database and in my save game. And dont tell me to delete all the colums on by one.

Simply...click by the left side of the first column....all columns of the rider will be selected...then press Delete...I hope you understand my English

Yea, i understand, thx m8

And i you delete them in your save game, are they fully gone or are they still in the results of races?