I probably missed it, but couldn't find the answer to my questions in previous posts, so apologizing now if this has already been answered.
I'm trying to use the Hannes Converter to extend the contract of 1 of my riders (please, don't judge ). I don't need instruction on how to use the editor, I need instructions on which tables and columns to update.
I've figured out what to update to extend the contract from 2008 to 2009; however, when viewing the rider's profile, part of the contract section hasn't been updated. The status for next year, still says "No contract" and "Wants to sign a new contract", even though his current contract is being reflected as good thru 2009 (I'm still in 2008 season).
So, does someone know the tables/columns that need to be updated to update the "next year info"? I would have thought it would have been in the table labeled "...cyclist_next_year", but its not.
I didn't check, but this is my guess:
Open up STA_contract_state and DYN_cyclist. Find your rider in DYN_cyclist, scroll to fkIDstatut_contract. It probably says '2', and in your case, you'd want to change this to '1'. You can find the 'definitions' in STA_contract_state.
CrueTrue wrote:
I didn't check, but this is my guess:
Open up STA_contract_state and DYN_cyclist. Find your rider in DYN_cyclist, scroll to fkIDstatut_contract. It probably says '2', and in your case, you'd want to change this to '1'. You can find the 'definitions' in STA_contract_state.
No, that doesn't seem to be it. The STA_Contract_State table definitely defines the different states, but I can't figure out where that value is store/applied to the cyclist. Within the DYN_cylist table, there is a field called "fkIDStatut_contrat" (not typo - missing "c" in contrat), but that column is filled with a "9" for every cyclist in the table.
I believe I've figure out how to extend contracts within saved game databases. I won't know for sure until I get to the end of my season and the riders that I've extended haven't asked or signed a new contract, but their profile page is updated to reflect that they are extended with current team.
Assumptions:
1) You know how to edit a saved game database. There are other threads that explain that process, that is not the intention of this posting/thread.
2) The cyclist (who's contract you are extending) has not already entered contract re-negotiations. There may be other updates to make if the cyclist is in that stage.
Directions:
1. Identify values for IDcyclist, fkIDteam, and fkIDstatut from DYN_cyclist table after searching/identifying cyclist who's contract you want to extend.
2. Add new row to bottom of DYN_cyclist_next_year table...
2a. Increment value of IDcyclist_next_year from previous row's value and note value (you'll need this later)
2b. Set fkIDcyclist to value noted in step 1 from IDcyclist
2c. Set affil_i_index to "3" (Note: this value is a guess,I'm not sure what this represents or what impact it has)
2d. Set fkIDxchange_cyclist_new_contract to 0
2e. Set fkIDteam to value noted in step 1 from fkIDteam
2f. Set fkIDstatut to value noted in step 1 from fkIDstatut
3. Update finan_i_period_date_end column within DYN_contract_cyclist table to date you want current contract to run thru.
4. Update DYN_cylist table...
4a. Set fkIDcyclist_next_year value to that noted on step 2a.
4b. Set fkIDcyclist_future value to "6" (satisfied with contract)
5. Save changes to tables and export to saved game.
6. Confirm on rider's profile page that the contract was extended.
). I don't need instruction on how to use the editor, I need instructions on which tables and columns to update.
