Hi, I'm new to PCM and am enjoying it quite a bit. One thing about me is I like to modify just about every PC game I play, whether it's Madden,NBA2k or MLB2k12, so I am fairly used to editing database information-except this one!
I am using the Lachi editor, which is an amazing piece of work, thanks to the creator of it.
I have used it to create a team using the PCMdailyrealname db for 13, a revamped Ariostea team. The jerseys show up, the selection screen jersey shows up, logos, everything, but I cannot seem to properly assign the colnago frame from that database to Ariostea. If I use Ariostea of course I can select the proper frame/wheels etc, but if I select another team, say Astana, then Ariostea riders use all different bikes.
I see one table seems to effect another and that's where I am confused. I found this topic https://pcmdaily.c...d_id=21510
a decent introduction, but need more details please. I even tried reverse engineering from the Sali 1994 db to see where I'm going wrong but to no avail, I can't see it. Can someone please give a step-by-step guide as to where to start here?
Thanks!
PS - I noticed how to assign a frame using the custom frame slot, but would prefer to make a special place like the other teams in the db have.
Edited by slickster222 on 05-07-2014 22:28
First, welcome to the forum I'm assuming that you've added Ariostea through editing the database file, right? If not, let me know and I can explain it more in more details
Well, since you say that the Ariostea riders use all different bikes, I assume you've put the value of 7 or 8 in column fkIDequipment_marques_cadre in Ariostea's line in DYN_team? These values correspond to the equipment menu that have the Colnago frames. But if you assign them to a team, that means that the team will choose from any of the frames included in that marque. What you should do, instead, is to assign the value of one of the "default" marques in STA_equipment of PCMdaily's DB. More specifically, the marque with ID 86 (named "Default 8" ) uses Colnago frames, so if you put the value of 86 in Ariostea's DYN_team -> fkIDequipment_marques_cadre cell, it should work
Hi lluuiiggii, and thank you for the welcome! I have only had the game for two weeks but have gotten hooked!
I added the team using the Lachi editor and you are correct, I tried each of the "Standard" allocations in the fkIDequipment_marques_cadre cell, and had been wondering how it finds the correct brand that use that designation in standard 2 or 3.
In my db, for some reason, I have in STA_equipment ID # 94 for colonago_frame. I have an ID#1364 for a "gene_sz_name" of Default 8 and a "gene_sz_nomenclature" of frame_colnago_tt.
Just to simplify things for a moment, to do this, I only need to look at tales DYN_team and STA_equipment since the frames.wheels etc are already in the DB?
Also when trying the DYN_team -- fkIDequipment_marques_cadre cell, I don't seem to be able to input anything other than what the drop menu gives me ex. Pro Continental 1,2,3... Standard 1,2,3,4 etc. I also should have known that inputing a selection was wrong because the other teams that were created have nothing selected.
Still confused though, I think I am over complicating this as sometimes happens when I attempt to mod a new game! Thanks for your response lluuiiggii! Also, thanks to those who worked on the PCMdaily real name db. I know how tedious and monotonous this sort of work is.
Edited by slickster222 on 06-07-2014 15:18
Okay, I see now how to add the value, use the + on the left of the table list and get the team linked items to show, than create an equipment list from there? And I create this list by entering a new existence ID in STA_equipment? If so, I have a question or two about STA_equipment. Making a new instance I change what I need to and follow the previously entered information that the DB creators did for their entries on others (fkiIDcharacmountain - all are 14), I noticed some that I have no clue:
fkIDequipment_unlock - should this be 94 colnago? No idea what this is.
gene_tga_ID_photo - where do I get this number from?
I had a look here https://pcmdaily.c...pid=457964 but am unsure if this is still usable for this version. I am pretty confuse - level 4 out of 5!
Edit- HAve also had a look at this tutorial https://pcmdaily.c...ad_id=6571 - Not sure how much it relates to now, but I guess I would be starting at "Step #6".
Edited by slickster222 on 06-07-2014 16:31
slickster222 wrote:
Just to simplify things for a moment, to do this, I only need to look at tales DYN_team and STA_equipment since the frames.wheels etc are already in the DB?
Yes. Since you just want to assign a frame that is already in the DB to a team, you don't need to add anything in STA_equipment or STA_equipment_marques, just look at certain values (read next question ) in STA_equipment and fill them in the equipment columns in DYN_team.
slickster222 wrote:
In my db, for some reason, I have in STA_equipment ID # 94 for colonago_frame. I have an ID#1364 for a "gene_sz_name" of Default 8 and a "gene_sz_nomenclature" of frame_colnago_tt.
It's the latter of those the one you want - the "Default 8" frame_colnago/frame_colnago_tt. However the value that you need to copy into DYN_team is the value in column fkIDequipment_marques; for this "Default 8" equipment, the marques value is 86
To give a more detailed explanation:
- STA_equipment is the database table in which equipment is added. The equipment can be put together into different "marques", which is French for brand, through using the same ID in column fkIDequipment_marques. The idea is that the "marques" correspond to the menus that you see in the equipment selection menu in game (in the original database, each 'menu' consists of 2~3 equipment pieces by only one brand, thus the name marques). But in order for the equipment menus to appear in game, the "marques" also have to be 'declared' in table STA_equipment_marques.
- The marques value will also be used to assign teams their equipment. If you put the ID of a marques with 10 equipment pieces in the equipment columns in DYN_team (fkIDequipment_marques_cadre/roue/helmet), then the team will ride with a random one of those 10 equipment pieces.
- So how to assign teams a specific equipment and make sure they use only that one? The trick is to use "hidden" marques. The idea is that, in STA_equipment, you create new 'marques' (compile equipment under a same unused fkIDequipment_marques value), that is, new sets of equipment that will not be "declared" in STA_equipment_marques (thus they won't appear as menus in game); however, they can still be used in DYN_team to make sure that team A will use the equipment contained in marques B (even if marques B is not "declared" in STA_equipment_marques).
- Therefore the PCMdaily database has equipment in STA_equipment that are compiled in "marques" which correspond to one of the equipment selection menus (that is the case of the Colnago frame with ID 94; notice how it has marques value of 7, which corresponds to 'Standard 1' in STA_equipment_marques) and also 'hidden' marques which do not correspond to menus and thus are not in STA_equipment_marques but rather are used in DYN_team to assign equipment to teams. That is the case of the Colnago frame of ID 1364; it has a marques value of 86. If you check the equipment in marques 86, you'll notice that, for frames, it only has the Colnago TT and Colnago RR frame; this means that, by assigning marques 86 as the equipment of a team in DYN_team, you'll assure that they'll be riding Colnago
slickster222 wrote:
Also when trying the DYN_team -- fkIDequipment_marques_cadre cell, I don't seem to be able to input anything other than what the drop menu gives me ex. Pro Continental 1,2,3... Standard 1,2,3,4 etc. I also should have known that inputing a selection was wrong because the other teams that were created have nothing selected.
This is because the drop down menu 'reads' the info from STA_equipment_marques, but, as explained above, the values used in Daily's database to assign equipment to the teams are all 'hidden', i.e. they don't appear in STA_equipment_marques and thus the dropdown menu appears blank. There should be an option to disable using lists in the editor, then you can manually fill the value of 86
slickster222 wrote:
fkIDequipment_unlock - should this be 94 colnago? No idea what this is.
gene_tga_ID_photo - where do I get this number from?
This would be useful in order to add new equipment, which, in this case, you don't have to do. But just since you asked:
- fkIDequipment_unlock refers to the "order" in which the equipment in the same marques will appear in the equipment menu in game. 0 refers to the first equipment in the list; while a value other than 0 means "this equipment will be following the equipment of ID X". For example, if you have:
ID
Name
Marques
fkIDequipment_unlock
1
Frame A
1
0
2
Frame B
1
1
3
Frame C
1
2
4
Frame D
1
3
5
Frame E
1
4
6
Helmet A
2
9
7
Helmet B
2
8
8
Helmet C
2
10
9
Helmet D
2
7
10
Helmet E
2
0
Marques 1 will look like in game:
Frame A (because it has unlock value of 0)
Frame B (because it has unlock value of 1 - i.e. it follows ID 1, which is Frame A)
Frame C
Frame D
Frame E
While marques 2 will look like:
Helmet E (because unlock is 0)
Helmet C (because unlock is 10, i.e. it follows ID 10, which is Helmet E)
Helmet B (because unlock is 8, i.e. it follows ID 8, which is Helmet C)
Helmet D
Helmet A
You can also see that there'll always be an ID in a given marques whose value does not appear in the fkIDequipment_unlock value of other equipment in that marques - this will correspond to the last equipment that will appear in the menu
As for gene_tgaID_photo, it corresponds to the ID of the picture corresponding to that frame, which is set in the Local.cdb (My Docs/PCM13/Local.cdb), table STA_TGA.
slickster222 wrote:
I had a look here https://pcmdaily.c...pid=457964 but am unsure if this is still usable for this version. I am pretty confuse - level 4 out of 5!
Edit- HAve also had a look at this tutorial https://pcmdaily.c...ad_id=6571 - Not sure how much it relates to now, but I guess I would be starting at "Step #6".
They are a bit outdated, but it's mostly the same. The tutorial in the first link explains how to add a equipment to the selection menu (not this case). Most of the post actually goes to explaning fkIDequipment_unlock, the idea is a bit tricky at a first moment As for the second tutorial, it pretty much goes over the entire process: adding pictures for the equipment, adding a new menu for the equipment, adding the equipment and finally linking it to the team. In this case, the part concerning your problem is only linked to step 7
slickster222 wrote:
Also, thanks to those who worked on the PCMdaily real name db. I know how tedious and monotonous this sort of work is.
You should try PCMdaily's Expansion Pack. It's a bit big to download (13 GB) but it's insane, much more complete than the real name DB. It has thousands more equipment, jerseys, more than a hundred variants (race routes that change every year), more teams, new races... well pretty much everything you need
Wow lluuiiggii thank you so much for this in-depth tutorial! I don't have time today to put it all into use, but I wanted to let you know how much I appreciate you taking the time to assist me. Hopefully tomorrow I will have some quiet time to concentrate on this project.
Many happy tailwinds for you lluuiiggii!
Thanks lluuiiggii for your in-depth assistance, it almost all makes sense to me know! The biggest stumbling block was the "use table lookup" function. Once I changed from that mode I was able to input my proper numbers. Really appreciate the time you took, and my goofy idea of using a current roster of cyclists with nostalgic sponsors is about to begin.
I also took your advice and downloaded the Extended mod, an amazing piece of work. Thanks for the advice on that!
I'm assuming that you've added Ariostea through editing the database file, right? If not, let me know and I can explain it more in more details 
