Okay, so basically I have added some fantasy teams to a DB. Shirts, logos etc. is working perfectly but I have problems with the equipment. I have not added my own equipment and I won't do that.
What I want is to decide which frame/manufacturer each team will ride when under computer control.
Let me give an example...
I have team X and in DYN_team in the table fkIDequipment_marques_cadre I can add 7, 8, 9 or 18 as Standard 1-4 (the in-game "folders").
Problem is that for example Standard 1 has both BMC, Bianchi and Cannondale etc. as options to choose. I can not decide which frame a given team will use in-race. Isn't this possible?
I can see in the PCMdaily2013DB that the real teams have an ID in the fkIDequipment_marques_cadre that is not in the STA_equipment_marque.
Edited by Wild Dog on 28-07-2013 16:26
You already answered your question, do it like PCMdaily does it. This info is already available in this forum but if you cannot find it, try to ask in the subforum related to that DB rather then in the technical subforum (as this is totally not technical).
I have searched the forum but can't find how to do it. You say that I have answered my own question, maybe, but how on earth do I know which ID to type in the fkIDequipment_marques_cadre column?..
Wild Dog wrote:
Can this be moved to the DB forum then?
I have searched the forum but can't find how to do it. You say that I have answered my own question, maybe, but how on earth do I know which ID to type in the fkIDequipment_marques_cadre column?..
In STA_equipment, there's the equipment_marques column. This is from where the IDs that you have to add in fkIDequipment_marques_cadre/helmet_roue columns.
F.e.: add the desired frames/helmets/wheels for the team you want in STA_equipment and give them equipment_marques of 100 (non-existant in STA_equipment_marques). Then write down 100 in the fkIDequipment columns in DYN_team.
