|
[PCM14] How to change equipment stats
|
| Vasilis |
Posted on 02-11-2014 16:44
|
Amateur
Posts: 12
Joined: 16-12-2012
PCM$: 200.00
|
Hi all,
I've just finished the Giro, but I have some problems with my eqiupment. For some mysterious reason, all my equipment has decreasing stats. I had a look into the DB to change it back again, and I somehow managed to change a few things, but it doesn't make any sense to me. Right now, my road bike for the flat is as aero as my TT bike, while it is lighter than the TT bike. This doesn't make any sense, so I'd want to make sure there's an aero difference again. Can anyone tell me how equipment stats work?
Thanks  |
| |
|
|
| matt17br |
Posted on 02-11-2014 17:06
|
Directeur Sportif
Posts: 10519
Joined: 28-09-2013
PCM$: 200.00
|
Let me know: did the stats decrease during the season?
|
| |
|
|
| Vasilis |
Posted on 02-11-2014 17:10
|
Amateur
Posts: 12
Joined: 16-12-2012
PCM$: 200.00
|
matt17br wrote:
Let me know: did the stats decrease during the season?
Yes they did. I have a R&D contract for frames, but all my frames and wheels got worse. My cobbles bike started off with comfort 4 and eventually ended up with 2.5 |
| |
|
|
| Vasilis |
Posted on 03-11-2014 19:55
|
Amateur
Posts: 12
Joined: 16-12-2012
PCM$: 200.00
|
Anyone knows how the equipment system works? |
| |
|
|
| matt17br |
Posted on 03-11-2014 21:04
|
Directeur Sportif
Posts: 10519
Joined: 28-09-2013
PCM$: 200.00
|
Vasilis wrote:
Anyone knows how the equipment system works?
l've never seen equipment stats decreasing, that's the point. The equipment system isn't too difficult to understand: You sign with an equipment sponsor, the AI decides if you can affect the developing of the models, and, if not, you'll receive the new models once a year.
|
| |
|
|
| Ad Bot |
Posted on 11-12-2025 13:38
|
Bot Agent
Posts: Countless
Joined: 23.11.09
|
|
| IP: None |
|
|
| Vasilis |
Posted on 03-11-2014 22:17
|
Amateur
Posts: 12
Joined: 16-12-2012
PCM$: 200.00
|
matt17br wrote:
Vasilis wrote:
Anyone knows how the equipment system works?
l've never seen equipment stats decreasing, that's the point. The equipment system isn't too difficult to understand: You sign with an equipment sponsor, the AI decides if you can affect the developing of the models, and, if not, you'll receive the new models once a year.
Well, I don't mean the ingame system, but in the database. It doesn't make sense to me and so I can't effectively edit it. I can't find where the equipment stats are defined. So that's what I'd like to find out. |
| |
|
|
| matt17br |
Posted on 04-11-2014 10:28
|
Directeur Sportif
Posts: 10519
Joined: 28-09-2013
PCM$: 200.00
|
Vasilis wrote:
matt17br wrote:
Vasilis wrote:
Anyone knows how the equipment system works?
l've never seen equipment stats decreasing, that's the point. The equipment system isn't too difficult to understand: You sign with an equipment sponsor, the AI decides if you can affect the developing of the models, and, if not, you'll receive the new models once a year.
Well, I don't mean the ingame system, but in the database. It doesn't make sense to me and so I can't effectively edit it. I can't find where the equipment stats are defined. So that's what I'd like to find out.
Take a look into dyn_equipement_techno 
|
| |
|
|
| Vasilis |
Posted on 04-11-2014 11:14
|
Amateur
Posts: 12
Joined: 16-12-2012
PCM$: 200.00
|
matt17br wrote:
Vasilis wrote:
matt17br wrote:
Vasilis wrote:
Anyone knows how the equipment system works?
l've never seen equipment stats decreasing, that's the point. The equipment system isn't too difficult to understand: You sign with an equipment sponsor, the AI decides if you can affect the developing of the models, and, if not, you'll receive the new models once a year.
Well, I don't mean the ingame system, but in the database. It doesn't make sense to me and so I can't effectively edit it. I can't find where the equipment stats are defined. So that's what I'd like to find out.
Take a look into dyn_equipement_techno
I've already looked into every table that contained the word 'equipment' (except 'track_equipment' ) and the only place that seemed to have to do with it, didn't really either, so I'm a little out of ideas.
Edited by Vasilis on 04-11-2014 11:22
|
| |
|
|
| matt17br |
Posted on 04-11-2014 11:20
|
Directeur Sportif
Posts: 10519
Joined: 28-09-2013
PCM$: 200.00
|
Vasilis wrote:
I've already looked into every table that contained the word 'equipment' (except 'track_equipment'  and the only place that seemed to have to do with it, didn't really either, so I'm a little out of ideas.
Well, actually that is the table that controls the equipment stats
As you can see: https://prntscr.co...
|
| |
|
|
| Vasilis |
Posted on 04-11-2014 11:26
|
Amateur
Posts: 12
Joined: 16-12-2012
PCM$: 200.00
|
matt17br wrote:
Vasilis wrote:
I've already looked into every table that contained the word 'equipment' (except 'track_equipment' and the only place that seemed to have to do with it, didn't really either, so I'm a little out of ideas.
Well, actually that is the table that controls the equipment stats
As you can see: https://prntscr.co...
I see it has something to do with it, which I knew, but not where the stats aerodynamics, lightness and comfort are defined. |
| |
|
|
| Lachi |
Posted on 04-11-2014 11:40
|
Grand Tour Champion
Posts: 8360
Joined: 29-06-2007
PCM$: 200.00
|
The tables starting with STA_ are the base tables.
I would look in tables starting with DYN_ if you want to find a problem in your career.
If I remember correctly, the word "brand" is part of the table name. |
| |
|
|
| matt17br |
Posted on 04-11-2014 11:46
|
Directeur Sportif
Posts: 10519
Joined: 28-09-2013
PCM$: 200.00
|
Vasilis wrote:
matt17br wrote:
Vasilis wrote:
I've already looked into every table that contained the word 'equipment' (except 'track_equipment' and the only place that seemed to have to do with it, didn't really either, so I'm a little out of ideas.
Well, actually that is the table that controls the equipment stats
As you can see: https://prntscr.co...
I see it has something to do with it, which I knew, but not where the stats aerodynamics, lightness and comfort are defined.
It may seem that it doesn't, but it actually controls the equipment stats. In fact you can see 6 columns into that table:
IDequipment: The ID of that model of frame/wheels/other;
IDteam: The team that is using it;
fkID_equipment_model: Model's name;
value_f_scoring: I don't know what does it control tbh;
value_f_fiability: Reliability score;
value_f_feeling: Comfort.
|
| |
|
|
| Vasilis |
Posted on 04-11-2014 12:33
|
Amateur
Posts: 12
Joined: 16-12-2012
PCM$: 200.00
|
Lachi wrote:
The tables starting with STA_ are the base tables.
I would look in tables starting with DYN_ if you want to find a problem in your career.
If I remember correctly, the word "brand" is part of the table name.
Brand is indeed part of it, it contains the equipment supplier's contracts, not the equipment itself though... |
| |
|
|
| Vasilis |
Posted on 04-11-2014 12:38
|
Amateur
Posts: 12
Joined: 16-12-2012
PCM$: 200.00
|
matt17br wrote:
Vasilis wrote:
matt17br wrote:
Vasilis wrote:
I've already looked into every table that contained the word 'equipment' (except 'track_equipment' and the only place that seemed to have to do with it, didn't really either, so I'm a little out of ideas.
Well, actually that is the table that controls the equipment stats
As you can see: https://prntscr.co...
I see it has something to do with it, which I knew, but not where the stats aerodynamics, lightness and comfort are defined.
It may seem that it doesn't, but it actually controls the equipment stats. In fact you can see 6 columns into that table:
IDequipment: The ID of that model of frame/wheels/other;
IDteam: The team that is using it;
fkID_equipment_model: Model's name;
value_f_scoring: I don't know what does it control tbh;
value_f_fiability: Reliability score;
value_f_feeling: Comfort.
I figured as much. Although 'comfort' is a little misleading here, because it defines the happiness effect on the rider riding it, not the ability to ride cobbles. |
| |
|
|
| Vasilis |
Posted on 07-11-2014 09:57
|
Amateur
Posts: 12
Joined: 16-12-2012
PCM$: 200.00
|
So no one really seems to know... Maybe I should look into some team-related tables. |
| |
|
|
| Dinn |
Posted on 15-03-2015 20:00
|
Amateur
Posts: 9
Joined: 09-10-2010
PCM$: 200.00
|
In STA_equipment_template you can see what diffrent kind of types give as stat. Like Poly give a 2-3-1 to frames. If you want to have bikes that are light you need to make them Mountain in STA_equipment_model, Find your frame there (with the IDequipment_techno in DYN_equipment_techno) and change its template.
By doing this you can change the stats of the equipment. |
| |
|
|
| Dinn |
Posted on 15-03-2015 20:08
|
Amateur
Posts: 9
Joined: 09-10-2010
PCM$: 200.00
|
Or even easier, just go to STA_equipment_template and put all values to 5, this way all the teams have the same stats for equipment and the research is less important. |
| |
|
|
| coolrex |
Posted on 15-03-2015 20:29
|
Protected Rider
Posts: 1161
Joined: 01-01-2015
PCM$: 300.00
|
Put the evaluation that's standard 20 and at max 30 in the editor.
put that stat at maybe 100 and it will have ridiculous high stat.
but in that way you can edit the equipments |
| |
|
