Been using this excellent DB, and changed Belkin name, sponsor and kit over to how it should be but they still use bright blue bikes, helmets etc. Any advice as to how to change, perhaps to any white equipment already in the db?
The easiest solution should be to find a team which has the white equipment you want.
Then copy the equipment setup from that team to Belkin.
This would be 4 or 5 columns in DYN_team if I am not mistaken.
Equipment are defined in fkIDequipment_marques_roue: For wheels. Shouldn't matter for you in this situation. fkIDequipment_marques_cadre: For frames. If you turn off "use lists" and enter either 7, 8, 9 or 10 they will be given non team-specific frames. fkIDequipment_marques_helmet: For helmets. Non team-specific helmets are 18, 30 and 31
For all these number there will (often) be coloured part, which uses the colour defined in the column "gene_sz_color"
Atlantius wrote:
Equipment are defined in fkIDequipment_marques_roue: For wheels. Shouldn't matter for you in this situation. fkIDequipment_marques_cadre: For frames. If you turn off "use lists" and enter either 7, 8, 9 or 10 they will be given non team-specific frames. fkIDequipment_marques_helmet: For helmets. Non team-specific helmets are 18, 30 and 31
For all these number there will (often) be coloured part, which uses the colour defined in the column "gene_sz_color"
If you use those numbers, they'll ride on auto-color bikes, but they'll ride on several bikes of different brands at the same time
Assuming that you have copied STA_equipment exactly the same like it is in the PCM12 DB, you could use 91 for frames, 93 for helmets and 100 for wheels. Then they'll ride in Giant bikes, Giro helmets and Shimano wheels
