So I'm playing a career with Jelly Belly in the PCMdaily database. The main problem is that I don't race enough to keep teh sponsors happy. When I go to the calendar to register for races, it won't even let me request invitations for continental races! And when I try and go to certain months in the calendar, it crashes. How can I edit which races I'm in with a database editor?
Yeah, I have hannes convertor too. And I'm telling you it's easier to use Dashboard.
But, considering you are persistant:
Open up DYN_team to find your team' ID number
Open up STA_race to find the race ID you want to enter
Open up DYN_team_race:
Go to the bottom of the list.
Add in to the bottom the next number in IDteam_race.
Add in your team's ID in fkIDteam
Add in the race's ID in fkIDrace
Add in a number 3 in fkIDinvitation_state to get your team in the race.
Ignore column gene_ilist_roster.
Add a 0 into the gene_f_cost.
Awesome. And I just downloaded Dashboard. It IS easier to use. However, it's pissing me off because I can't change my sponsor goals. I got fired, so I switched back to Jelly Belly, but when I did, I brought along the sponsor goals, which are all Italian. And now, with Dashboard, I can change other teams' goals, just not my own. VERY FRUSTRATING!
And somehow I once managed to change one of my goals, but I can't change all of them. Go figure...
Open up your save game in Hannes again:
Open up DYN_objectif_cym6, STA_objectif_sponsor and STA_objectif_sponsor_info
First look at STA_objectif_sponsor:
Look under the pipo_sz_name column and scroll down to find the objectives and star-ranked objectives you want. Take down the numbers of the first column as we need to input them into another table later. (for example: tourofmalaysia3star is IDobjectif_sponsor 1)
Arrange them in rank of:
3star
3star
2star
2star
1star
1star
then the 5 objectives you want.
WHen you have a list consisting of those numbers with a comma between each number (no space required), you can input them into these two tables:
STA_objectif_sponsor_info and DYN_obj_sponsor_cym6
In the STA table, find your teams ID and input those numbers into the 2nd column.
In the DYN table, fill down the fkIDobjectif_sponsor column and put all values in the gene_i_state as "2" or "1" if they have been completed.
Edited by rjc_43 on 18-10-2008 21:04
Here to help 
and dance like a banana!
