|
Editing : FAQ
|
| fenian_1234 |
Posted on 09-07-2009 06:31
|
Grand Tour Specialist
Posts: 4790
Joined: 06-12-2006
PCM$: 200.00
|
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)
Edited by fenian_1234 on 28-07-2009 16:17
|
| |
|
|
| fenian_1234 |
Posted on 09-07-2009 06:32
|
Grand Tour Specialist
Posts: 4790
Joined: 06-12-2006
PCM$: 200.00
|
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? |
| |
|
|
| Inferio |
Posted on 09-07-2009 08:05
|
Domestique
Posts: 687
Joined: 31-12-2008
PCM$: 200.00
|
1. STA_race
2. DYN_team
3. DYN_cyclist |
| |
|
|
| fenian_1234 |
Posted on 09-07-2009 08:25
|
Grand Tour Specialist
Posts: 4790
Joined: 06-12-2006
PCM$: 200.00
|
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. |
| |
|
|
| Inferio |
Posted on 09-07-2009 08:40
|
Domestique
Posts: 687
Joined: 31-12-2008
PCM$: 200.00
|
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  |
| |
|
|
| CrueTrue |
Posted on 09-07-2009 10:16
|
Tour de France Champion
Posts: 29989
Joined: 20-10-2006
PCM$: 200.00
|
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 |
| |
|
|
| Lachi |
Posted on 09-07-2009 10:25
|
Grand Tour Champion
Posts: 8516
Joined: 29-06-2007
PCM$: 200.00
|
deleted, because to late
Edited by Lachi on 09-07-2009 10:26
|
| |
|
|
| Ad Bot |
Posted on 24-11-2024 23:59
|
Bot Agent
Posts: Countless
Joined: 23.11.09
|
|
| IP: None |
|
|
| CrueTrue |
Posted on 09-07-2009 10:30
|
Tour de France Champion
Posts: 29989
Joined: 20-10-2006
PCM$: 200.00
|
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
Edited by CrueTrue on 09-07-2009 10:30
|
| |
|
|
| fenian_1234 |
Posted on 09-07-2009 11:35
|
Grand Tour Specialist
Posts: 4790
Joined: 06-12-2006
PCM$: 200.00
|
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
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... |
| |
|
|
| fenian_1234 |
Posted on 10-07-2009 10:43
|
Grand Tour Specialist
Posts: 4790
Joined: 06-12-2006
PCM$: 200.00
|
fenian_1234 wrote:
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? |
| |
|
|
| CrueTrue |
Posted on 10-07-2009 10:46
|
Tour de France Champion
Posts: 29989
Joined: 20-10-2006
PCM$: 200.00
|
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. |
| |
|
|
| fenian_1234 |
Posted on 10-07-2009 13:20
|
Grand Tour Specialist
Posts: 4790
Joined: 06-12-2006
PCM$: 200.00
|
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... |
| |
|
|
| bolkoswidnicki |
Posted on 10-07-2009 19:25
|
Amateur
Posts: 16
Joined: 26-04-2008
PCM$: 200.00
|
How can I edit riders' favourite races? |
| |
|
|
| Adams55 |
Posted on 10-07-2009 19:34
|
Free Agent
Posts: 149
Joined: 01-03-2007
PCM$: 300.00
|
Open up DYN_cyclist. Find "gene_ilist_fkIDfavorite_races" column and type in races' IDs - you can find them in STA_race. |
| |
|
|
| bolkoswidnicki |
Posted on 10-07-2009 19:38
|
Amateur
Posts: 16
Joined: 26-04-2008
PCM$: 200.00
|
Thanks. Dzieki!
Edited by bolkoswidnicki on 10-07-2009 19:40
|
| |
|
|
| Baond |
Posted on 15-07-2009 00:06
|
Amateur
Posts: 2
Joined: 14-07-2009
PCM$: 200.00
|
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? |
| |
|
|
| CrueTrue |
Posted on 15-07-2009 09:48
|
Tour de France Champion
Posts: 29989
Joined: 20-10-2006
PCM$: 200.00
|
1. DYN_cyclist and the columns fitness_f_forme_fatigue and fitness_f_race_points.
2. No, unfortunately not. |
| |
|
|
| Kami |
Posted on 17-07-2009 17:29
|
Classics Specialist
Posts: 3485
Joined: 19-06-2009
PCM$: 200.00
|
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. |
| |
|
|
| Inferio |
Posted on 17-07-2009 17:31
|
Domestique
Posts: 687
Joined: 31-12-2008
PCM$: 200.00
|
Kami wrote:
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  |
| |
|
|
| Kami |
Posted on 17-07-2009 17:50
|
Classics Specialist
Posts: 3485
Joined: 19-06-2009
PCM$: 200.00
|
Inferio wrote:
Kami wrote:
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? |
| |
|
