I've been editing a database for myself using the FCD2014 database as a starting point. Everything went smoothly (transferts, new maillots, some other little graphic editions...), but I have a huge problem with the skins of the riders in 3D race.
I'll try to explain myself. Alberto Contador has it skin linked in the "STA_tga_skin" table, "IDtga_skin" column, value '16'. Both names in "gene_sz_tga_skin" and "CONSTANT" are the same as his files in "...\3D\Cyclists\Body", 'contador'. No capital letters. And "gene_b_forcebuild" is ticked. Then, in "DYN_cyclist", "fkIDtga_skin", when I looked into Alberto's row, it appears '16 contador ▼'. So I assumed it was correctly linked. But when I went to the game, Contador just showed a random 'type_X' skin.
However, in that same 3D race, I could see perfectly some other skins from some other riders as Sagan, Nibali, Valverde, Voeckler... Wiggins, Purito, Rojas, Visconti, Jungels, Schleck, Boom, Démare... But other ones like Cavendish, Froome, Quintana or Kreuziger simply didn't appear.
I came back to the editor, and saw that Wiggins had it skin linked the same way, but with an "IDtga_skin" value of '36'. Some others (Nibali, Valverde, Sagan, Voeckler...) didn't even have their skin linked. I assume this is because they have their own files in "...\3D\Cyclists\Professional", but I don't know where the game is said to get this files.
The funniest part came here: as I saw that Contador's files were not working, but Wiggins' were; I tried to link Wiggins' skin to Alberto Contador. The result in 3D race: Wiggins was showing his own skin; but Contador still showed his random 'type_X' skin.
Then, I thought that the problem was the rider row. I tried to attach Contador's skin to Wiggins; and Contador's skin appeared in the game as if by magic. But only in Wiggins. Contador still showed his random "type_X" skin.
Next idea: change value by value both riders in "DYN_cyclist"; so that Wiggins became Contador, and Contador became Wiggins. I rewrited every data, with the only exception of the "IDcyclist" column. That way, Contador should appear with his skin, and Wiggins with a default skin. But as if some kind of god was laughing at me from the heights, Wiggins showed his skin and Contador still looked random.
Is there anything I didn't take into account? I spent a lot of time in improving my favourite riders skins, and I really want them to show into the game
Thank you so much again. Any tip could be a great help. I look forward your answers ;D
Edited by Sage on 06-04-2015 00:02
But what happens if you (temporarily) delete the faces of the riders whose skins are not working in game? So Sagan, Voeckler, Contador, Nibali and Valverde?
matt17br wrote:
But what happens if you (temporarily) delete the faces of the riders whose skins are not working in game? So Sagan, Voeckler, Contador, Nibali and Valverde?
Do you mean deleting them from "...\3D\Cyclists\Body"? I'm going to try when I get to my other computer, and share here the results.
Sagan, Voeckler, Nibali, Valverde and Rolland do work properly in my game; but they don't have their skin linked in the CDB file. The problem comes with some riders that do have their skin linked in the CDB; as Contador, Quintana, Froome, Pinot, Cavendish, Kreuziger, Paolini, Malori... they don't show their skin, when others in the same situation do (Wiggins, Visconti, Gerrans, Jungels, Rojas...). I don't know if I explained it correctly in the message, sorry if not!
I have been doing several tests. These are the results:
1.) Deleting only "...\3D\Cyclist\Body".
Contador and Wiggins showed a default face. Surprisingly, Nibali and Sagan also showed a default face, even with the "Professional" folder intact.
2.) Deleting only "...\3D\Cyclist\Professional".
Nibali and Sagan showed a default face, as expected as they are not linked in the CDB file. Wiggins showed his right face, as the "Body" folder was OK in this test. But Contador still showed a default face.
3.) Without deleting any folder.
Everyone of the four is showing his own skin, with the exception of Contador.
4.) Changing skin links in the CDB.
This is my "DYN_Cyclist". You can see Nibali is not linked, and Contador/Wiggins have their link. If I change the links of Contador and Wiggins...
This happens.
Wiggins shows Contador's skin; but Contador doesn't show Wiggins skin, that worked perfectly in the former tests.
I'm completely lost with this
(Sorry for the bad quality of the pictures)Edited by Sage on 06-04-2015 14:43
Ok, after several tries changing different things in the CDB, I have got the clue: the game only show the skins of the national/world champions or ex-champions. That's why Wiggins, Jungels, Rodríguez, Visconti, Rojas, Schelck... appeared OK; and others like Contador, Froome, Quintana, Urán... didn't. Now it makes sense. If I load a timetrial stage, Contador shows his skin and Purito doesn't.
I don't know if this works the same for every PCM2014 of yours; but changing the value in "gene_i_champion_bit" to '48' (Both route/tt national champion), '33' (Route national champion and tt nat. ex-champion) or similar values solved the problem.
There is now another problem: the champions have a different shirt. And the ex-champions have the trims. I opted to make them current champions, and using a national champion maillot the same as the normal maillot for them. Works OK if you are not going to start a career (I normally play single stages or tours). But there are several teams in which you can find the current national champion and a rider from the same country you want his skin to be showed (e.g. Sky with Kennaugh and Froome). I solved this very situation changing Froome's nationality to Kenya and then changing Kenya flag with UK flag. But other situations (FDJ: Pinot/Démare; BMC: Van Garderen/Phinney...) cannot be solved that way.
Thanks for your time in this thread, Matt; and I hope this "discover" can help other people. Still, if there were some method to show the skin of those not-nc, I would be happy to know it
Isn't there a limit on faces?
Not sure how many it was, could as well be the 127 you mentioned.
But it would make sense to me, if it exceeds the limit, it'd just randomize the faces it does display each time you enter a race. Not sure though, just a thought.
Jesleyh wrote:
Isn't there a limit on faces?
Not sure how many it was, could as well be the 127 you mentioned.
But it would make sense to me, if it exceeds the limit, it'd just randomize the faces it does display each time you enter a race. Not sure though, just a thought.
I also thought on that; but there was no randomization: the game always displayed certain skins, and always missed the same others. I have changed almost every rider with an assigned skin to be a national champion, and now everyone shows it skin
Not sure about the limit, though.
Edited by Sage on 08-04-2015 20:03
Not that is a research, and I think you got it. It has trouble me as long as I have had the game. The random faces is not random at all. It's champions in some sort, that I will buy,
Just bloody sad that it's restricted to this. Your solutions sounds tricky and surely might work, but then it will be fiddling with other stuff.
Like my damn loss of garden trees, which I can't find any answer too. But you proof that one can always figure out why things are as they are.
Only now wish I can get my tree in city/villages gardens back. Still hoping and testing.
The face case could almost be considered solved IMHO,
