PCM.daily banner
23-12-2024 02:03
PCM.daily
Users Online
· Guests Online: 36

· Members Online: 0

· Total Members: 162,199
· Newest Member: champdaldeia
View Thread
PCM.daily » Pro Cycling Manager 2006-2020 » Pro Cycling Manager 2018
 Print Thread
Adding new Stage race - Quebec stage shows up
Ad Bot
Posted on 23-12-2024 02:03
Bot Agent

Posts: Countless
Joined: 23.11.09
IP: None  
cyclertom
Top  #1 Print Post
Posted on 17-10-2018 19:00
Hey guys!

I've just created several stages for our local Czech stage race. When I load them as a variant for an existing Stage race, they all work fine. But when I've tried to load them as a part of my own stage race, it didn't work.

Actually, the stage info, profile, etc. is ok. But when you go further, pick the team and get to the point, where you set the team strategy, it shows the Quebec stage...

So there must be something wrong with the DB. I just can't figure out what would that be.

Can anyone help? See the exported tables from the DB below.

STA_race
IDrace625
gene_sz_race_nameEast Bohemia Tour
gene_sz_abbreviationBohemia
gene_sz_filenamet1_bohemia
fkIDcountry33
fkIDUCI_class11
fkIDfirst_stage21139
fkIDlast_stage21143
gene_f_popularity5
gene_i_number_stages5
gene_sz_mailOrganisateur
gene_ilist_fkIDteam(40,50,51,58,77,108,114,115,122,126,147,176,187,192,198,307,310,199)
gene_ilist_objectif_info()
fkIDLastRaceLeader0
CONSTANTbohemia
gene_sz_classification_xmlcont_22.xml
gene_f_organisateur_coeff0
fkIDtype_tour5
gene_b_ForceProtourInvitation0
gene_b_aso0
gene_sz_currentvariant
value_i_prime0
gene_b_selected1


STA_stage
IDstage2113921140211412114221143
fkIDrace625625625625625
gene_i_day2021222324
gene_i_month66666
gene_i_computed_date00000
gene_i_stage_number12345
gene_b_selected11111
CONSTANT
gene_sz_variant


Stage itself is named like t1_bohemia_01_2018, etc.

Thanks a lot
Tomas
 
cyclertom.wz.cz
Selwink
Top  #2 Print Post
Posted on 17-10-2018 19:02
Your stage IDs are wrong. They should be 1625-5625. In STA_Race, change the fkID_firststage and laststage accordingly
pcmdaily.com/images/mg/micro/npn.png[PCT] Novatek-Panarmenian.net
[ICL] Sugoi-Xanterra & Canada Dry Dev Team
Stages (Requests closed)

i.imgur.com/vR8EVAA.png

'But why were [...] they helped to get to space? To find answers, we must look at predictions not of science, but of science-fiction.'
Ancient Aliens
 
cyclertom
Top  #3 Print Post
Posted on 17-10-2018 19:05
Oh, now I see... It has to be a combination of Stage no. and RaceID... Cool, thanks a lot for your help Selwing. You've saved my day!
 
cyclertom.wz.cz
Jump to Forum:
Login
Username

Password



Not a member yet?
Click here to register.

Forgotten your password?
Request a new one here.
Latest content
Screenshots
celebrating a 2nd place
celebrating a 2nd place
PCM10: Funny screenshots
Fantasy Betting
Current bets:
No bets available.
Best gamblers:
bullet fighti... 18,776 PCM$
bullet df_Trek 17,674 PCM$
bullet Marcovdw 15,745 PCM$
bullet jseadog1 13,752 PCM$
bullet baseba... 10,539 PCM$

bullet Main Fantasy Betting page
bullet Rankings: Top 100
ManGame Betting
Current bets:
No bets available.
Best gamblers:
bullet Ollfardh 21,990 PCM$
bullet df_Trek 15,820 PCM$
bullet Marcovdw 15,200 PCM$
bullet jseadog1 13,700 PCM$
bullet baseball... 7,432 PCM$

bullet Main MG Betting page
bullet Get weekly MG PCM$
bullet Rankings: Top 100
Render time: 0.19 seconds
Copyright © 2006-2023


Powered by PHP-Fusion Copyright © 2024 PHP-Fusion Inc
Released as free software without warranties under GNU Affero GPL v3