|
Adding records (i.e. most wins) for a race
|
| cactus-jack |
Posted on 11-09-2011 14:15
|
Classics Specialist
Posts: 3936
Joined: 31-07-2009
PCM$: 200.00
|
Several of the WT-races have records for most wins in the Archive. I don't mean who won the race in 2011, 2010, 2009, etc. but rather who has the most stage wins, most overall wins, etc.
I'm just wondering, is there a way to include more races in this drop-down box? I mean, it must be in the DB somewhere, right? Say if I won 3 stages in the USA Pro Cycling Challenge is there a way for me to add that info to the game? If not stages, atleast overall wins. |
| |
|
|
| CrueTrue |
Posted on 11-09-2011 14:23
|
Tour de France Champion
Posts: 29989
Joined: 20-10-2006
PCM$: 200.00
|
You can add records for any race. It's done in STA_records. |
| |
|
|
| cactus-jack |
Posted on 11-09-2011 14:39
|
Classics Specialist
Posts: 3936
Joined: 31-07-2009
PCM$: 200.00
|
And that isn't just for who won it in 2007, 2008, etc.
Say for example, that a rider has won USA Pro Cycling Challenge 3 times, the last time being in 2011. For the sake of the example, lets say that the riders ID is 1 and the ID for the race is 10. How would I go about adding that record?
Also, what does fkIDrecord_type and gene_i_value stand for?
Have I understood the others correctly?
- IDrecord is just to distinguish each record from another, right?
- value_i_year mena which year the rider accomplished it?
- fkIDrace means which race the record is for?
Edit: I think I've figured it out:
- gene_i_value means how many times a rider has won each race?
- fkIDrecord_type means what it is that he has won? 1=overall GC, 2=point jersey, 3=KoM, etc.?
Edited by cactus-jack on 11-09-2011 14:47
|
| |
|
|
| CrueTrue |
Posted on 11-09-2011 15:17
|
Tour de France Champion
Posts: 29989
Joined: 20-10-2006
PCM$: 200.00
|
Correct.
IDrecord = a unique ID (if 1,2 and 3 are used, your new line is 4)
fkIDrecord_type = What type of record is it - GC wins, stage wins, Ardennes classics wins? The list of record types can be found in STA_records_type.
fkIDpalmares_cyclist = the rider's ID in DYN_palmares_cyclist
value_i_year = the year where the latest win was recorded (usually not used for stage wins)
gene_i_value = the amount of GC wins, stage wins, whatever
fkIDrace = the race it was won in (STA_race)
Edited by CrueTrue on 11-09-2011 15:51
|
| |
|
|
| cactus-jack |
Posted on 11-09-2011 15:34
|
Classics Specialist
Posts: 3936
Joined: 31-07-2009
PCM$: 200.00
|
Grand.
I know what I must add in STA_records, but is there something I have to do before that? For example, how do I "get" the riders ID in DYN_palmares_cyclists? Seeing as there isn't a record for this at the moment the rider who would have the record isn't listed there. What should I add there?
This might be a tall order, but if someone has the time could you maybe give me a step-by-step list of what i should do? I'll give you an example; In the USA Pro Cycling Challenge a rider won 4 stages.
Lets just say that the ID for the race is 10, and the rider-ID is 1. |
| |
|
|
| Ad Bot |
Posted on 24-11-2024 14:55
|
Bot Agent
Posts: Countless
Joined: 23.11.09
|
|
| IP: None |
|
|
| CrueTrue |
Posted on 11-09-2011 15:51
|
Tour de France Champion
Posts: 29989
Joined: 20-10-2006
PCM$: 200.00
|
IDrecord = something unique
fkIDrecord_type = 4
fkIDpalmares_cyclist = Open DYN_palmares_cyclist. In the first column, add a unique number, write his name in the 2nd, and in the 3rd = 1 (his rider ID). The unique number you wrote in DYN_palmares_cyclist is the one that has to be written here in fkIDpalmares_cyclist.
value_i_year = 2011
gene_i_value = 4
fkIDrace = 10
Edited by CrueTrue on 11-09-2011 15:52
|
| |
|
|
| cactus-jack |
Posted on 11-09-2011 16:18
|
Classics Specialist
Posts: 3936
Joined: 31-07-2009
PCM$: 200.00
|
Thanks a lot!
Just one more question; if I were to add both overall wins, stage wins, climbers jersey, etc. for the race how would it look in the archive page? I'm wondering because the only races that have such detailed info are the three GTs. |
| |
|
|
| cactus-jack |
Posted on 13-09-2011 21:05
|
Classics Specialist
Posts: 3936
Joined: 31-07-2009
PCM$: 200.00
|
Okay, just to try, I started a save with Liquigas so I could use it for "testing".
I decided to give Ivan Basso the record for 5 stage wins in the USA Pro Cycling Challenge in 2010 (since I hadn't advanced a single day in the save).
I followed the instructions step by step and overwrote the original file and closed the editor. I then went into the game and opened it, but the record wasn't there. I checked every single site in the Archive-part.
Since I haven't done anything in the save Basso hasn't really won those stages. Does it have to have taken place for the game to recognize it?
Also, I simply overwrote the file when i saved it and opened my save game again. Is there something else I have to do? Look in another folder in My Doc.->PCM2011? |
| |
|
|
| Lachi |
Posted on 13-09-2011 22:17
|
Grand Tour Champion
Posts: 8516
Joined: 29-06-2007
PCM$: 200.00
|
You can either edit the save or the database, but if you edit the DB, then it will not be visible in the started career. If that was not your question, then re-open the file you edited and check if your changes are still there. |
| |
|
|
| cactus-jack |
Posted on 13-09-2011 22:18
|
Classics Specialist
Posts: 3936
Joined: 31-07-2009
PCM$: 200.00
|
I edited the save game.
The changes are there, they are just nowhere to be found in the actuall game. |
| |
|
|
| cactus-jack |
Posted on 14-09-2011 20:06
|
Classics Specialist
Posts: 3936
Joined: 31-07-2009
PCM$: 200.00
|
Okay, for the pst two days I've tried everything I can think of. I've followed the guide provided here exactly, yet it does not work. The changes are there in the save game when I open it, but I can't see it in the game.
When I'm done editing I click "extract to DB" (or something, it's option nr. 2 from above) and overwrite the existing save game. Then I open the game and click "load last saved game". I've search through the entire Archive-site, but the record is nowhere to be seen.
Something is wrong somewhere, please help me out here. |
| |
|
|
| CrueTrue |
Posted on 16-09-2011 17:00
|
Tour de France Champion
Posts: 29989
Joined: 20-10-2006
PCM$: 200.00
|
No matter what you do, the stats of continental races won't show up in the list of records.
However, as far as I remember, it's mentioned in the news (e.g. "XXXX has won 5 stages of XXXX race and now holds the record of most stage wins). |
| |
|
|
| cactus-jack |
Posted on 16-09-2011 21:49
|
Classics Specialist
Posts: 3936
Joined: 31-07-2009
PCM$: 200.00
|
CrueTrue wrote:
No matter what you do, the stats of continental races won't show up in the list of records.
No offence, but what the hell was the point of all this in the first place? Thta's kinda what I wanted to achieve... |
| |
|
|
| Lachi |
Posted on 17-09-2011 12:04
|
Grand Tour Champion
Posts: 8516
Joined: 29-06-2007
PCM$: 200.00
|
You only asked how to add them, you did not say what you want to achieve. |
| |
|
|
| cactus-jack |
Posted on 17-09-2011 13:22
|
Classics Specialist
Posts: 3936
Joined: 31-07-2009
PCM$: 200.00
|
Well, I thought it was sort of given. I suppose I'll do it for one or two races that I enjoy racing. Those that I will be going for every year.
I do think it's odd that you can't add records and for them to be visible. |
| |
|
