|
Converting DB
|
| jnz_1989 |
Posted on 22-02-2016 16:08
|
Free Agent
Posts: 142
Joined: 03-02-2012
PCM$: 200.00
|
Good afternoon!
As the title says I'm interested in converting a DB for PCM13 originally from PCM15. For personal use.
I've some editing knowledge but clearly I'm missing some parts. So, I want to convert the 2015 expansion pack. My laptop doesn't cope very well with it and it has some random crashes that I don't like.
Now, let's go to the practical side of things. What tables do I need to copy? I'm thinking on the following:
- dyn_cyclist (stats and all that stuff);
- sta_race and sta_stage (I'm not sure on this yet but maybe use .cdx to create the different races);
- dyn_team, dyn_sponsor and dyn_sponsorregions. Then copying all the stuff from gui and 3D ( shirts, maillots, photos, etc);
- sta_program and sta_program_info;
Am I missing something? I know I need to pay attention to all the different structures on the DB. I always use excel editor. For me it's more easy to do it.
Now I think I might have 2 problems:
- the development teams. Does this might to cause some problems passing the teams? Is there a table that shows the connections where I can disable this? I'm thinking that because of this maybe it's better to use the JESGD DB from PCM14. What's your thoughts on this?;
- the equipment. As the games are different I won't copy the relative tables and instead continue to use the equipment already on PCM13. However if I want to change the equipment of Belkin (Lotto) to another one how can I do this? Just using the numbers from sta_equipment on the marques column and change it in dyn_team?
I hope I've explained myself in a good way. If you have some points that might need some explanation just tell me.
Thanks in advance.
Cheers!
Edited by jnz_1989 on 22-02-2016 16:15
|
| |
|
|
| matt17br |
Posted on 22-02-2016 16:25
|
Directeur Sportif
Posts: 10525
Joined: 28-09-2013
PCM$: 200.00
|
- the development teams. Does this might to cause some problems passing the teams? Is there a table that shows the connections where I can disable this? I'm thinking that because of this maybe it's better to use the JESGD DB from PCM14. What's your thoughts on this?;
Don't use dev teams in PCM 13. So just don't copy teams from ID 200 on. The table where the links to main teams are done is dyn_u23_link for pcm 15.
- the equipment. As the games are different I won't copy the relative tables and instead continue to use the equipment already on PCM13. However if I want to change the equipment of Belkin (Lotto) to another one how can I do this? Just using the numbers from sta_equipment on the marques column and change it in dyn_team?
Exactly  Or at least since I recall dyn_brand_contract not being there yet, that's the way.
|
| |
|
|
| jnz_1989 |
Posted on 22-02-2016 16:42
|
Free Agent
Posts: 142
Joined: 03-02-2012
PCM$: 200.00
|
Thanks for your answers Matt!
I've one other question, still regarding the equipment. The screen just before starting a race ( the one with the screenshot) counts for something? It's just because I've tried to edit the names of the teams to appear there and it was all messed up. Just tried to delete Garmin (having only Cannondale-Garmin), putting IAM on the screen with the WT teams, etc So it's important for something? |
| |
|
|
| matt17br |
Posted on 22-02-2016 16:45
|
Directeur Sportif
Posts: 10525
Joined: 28-09-2013
PCM$: 200.00
|
Sorry I don't really get which screen you're talking about 
|
| |
|
|
| jnz_1989 |
Posted on 22-02-2016 16:49
|
Free Agent
Posts: 142
Joined: 03-02-2012
PCM$: 200.00
|
The one where shows all the equipment. Before the team briefing. All this on PCM13. Because it is different on the new ones. |
| |
|
|
| matt17br |
Posted on 22-02-2016 17:02
|
Directeur Sportif
Posts: 10525
Joined: 28-09-2013
PCM$: 200.00
|
Yeah I got it, just this part seemed weird and thought you were talking about something else:
It's just because I've tried to edit the names of the teams to appear there and it was all messed up. Just tried to delete Garmin (having only Cannondale-Garmin), putting IAM on the screen with the WT teams, etc So it's important for something?
What do you mean? Could you explain it in more detail?
|
| |
|
|
| jnz_1989 |
Posted on 22-02-2016 17:11
|
Free Agent
Posts: 142
Joined: 03-02-2012
PCM$: 200.00
|
Let's use the IAM example.
My base DB was the 2014 v1 to PCM13. There IAM was on the pro continental rank so it didn't appear together with the WT teams equipment. Instead it appeared with the other pro continental teams equipment (Bardiani, Androni, etc). How can I pass them to WT part together with Astana, BMC, etc? |
| |
|
|
| sgdanny |
Posted on 22-02-2016 17:15
|
Classics Specialist
Posts: 3591
Joined: 18-03-2014
PCM$: 200.00
|
could you upload the cdb, so I can remind myself how equipment worked in pcm13 xD
|
| |
|
|
| jnz_1989 |
Posted on 22-02-2016 17:24
|
Free Agent
Posts: 142
Joined: 03-02-2012
PCM$: 200.00
|
I'm currently reinstalling the game and for my amusement the CD is kinda broked lol.
When i start to convert all the stuff I'll post it here.
I can do all the other stuff but the equipment is my biggest headache.
Thank you! |
| |
|
|
| jnz_1989 |
Posted on 23-02-2016 11:22
|
Free Agent
Posts: 142
Joined: 03-02-2012
PCM$: 200.00
|
Just to talk about my progress.
The converting is going pretty well. I've done all the cyclists (from the development teams I've just copied the riders with a potential above 5 and put them as free riders), teams and sponsors.
What did take more time was the renaming of the team logos. Because that feature did disappeared from PCM15 I needed to rename all the logos to match with the jersey. Copied those from the JESGD DB. Today I'll finish this, the races and stages and the palmares. Then I'll go straight into equipment and the problems shall start lol.
The process is easy but can take some time. |
| |
|
|
| Ad Bot |
Posted on 23-11-2024 11:43
|
Bot Agent
Posts: Countless
Joined: 23.11.09
|
|
| IP: None |
|
|
| jnz_1989 |
Posted on 24-02-2016 02:48
|
Free Agent
Posts: 142
Joined: 03-02-2012
PCM$: 200.00
|
So, I'm finished with the converting and all seems to be ok. I've decided to not touch on the equipment. At least for now. So Lotto-Jumbo will ride with the Belkin equipment and so on.
However I've a small problem. The game crashes on the day of New Zealand's ITT championships and doesn't let me pass that day. The race seems to be well inserted on the DB (I even reinserted it) and this problem didn't occur with the Australian ones. Do you know what might be wrong? Every team has their material (for the teams that didn't exist on PCM13 I gave them the same equipment as the free riders) and in the table in sta_country New Zealand seems to be well inserted. Also this isn't a case of excessive amount of teams.
Thanks in advance. |
| |
|
|
| matt17br |
Posted on 24-02-2016 07:14
|
Directeur Sportif
Posts: 10525
Joined: 28-09-2013
PCM$: 200.00
|
It could be because the stage was made for a later version of pcm. Did you copy paste all stages?
|
| |
|
|
| jnz_1989 |
Posted on 24-02-2016 10:36
|
Free Agent
Posts: 142
Joined: 03-02-2012
PCM$: 200.00
|
I did copy and paste but it was from a previous DB that I had. I'm sure they're all compatible with PCM13.
It's strange because when the game enters day 10 appears a pink square above the flag of NZL. The flag appears but with a pink above. When I press to continue instead of appear the names of the cities related to the stage appears Plouay-Plouay and the game crashes. |
| |
|
|
| matt17br |
Posted on 24-02-2016 10:44
|
Directeur Sportif
Posts: 10525
Joined: 28-09-2013
PCM$: 200.00
|
That means that the game can't find that exact stage. You definitely copied something in the wrong folder. Make sure you can find natitt_nzl in cm_stages
|
| |
|
|
| jnz_1989 |
Posted on 24-02-2016 10:48
|
Free Agent
Posts: 142
Joined: 03-02-2012
PCM$: 200.00
|
Hmm I think I did it yesterday but yeah I could be wrong. If i can't pull that off I will try a .cdx. if it's still not working I'll try to post screenshots here and attach the .cdb
Thanks for your help! |
| |
|
|
| jnz_1989 |
Posted on 24-02-2016 14:17
|
Free Agent
Posts: 142
Joined: 03-02-2012
PCM$: 200.00
|
I've found out what was causing the crash. I'm feeling very dumb lol
It was the pcmdaily cup. I've deleted those races from the sta_race but totally forgot to delete them on sta_stage. All is working for now. If I've another problem I'll report and ask for your help.
I've decided that I won't touch on equipment. It were small thimgs. It's not game breaking for me and all the teams seem to have their right equipment so I'll start the proper playing.
Thank you!!! |
| |
|
