Questions related to DB-making
|
lluuiiggii |
Posted on 15-11-2013 15:11
|
Grand Tour Champion
Posts: 8542
Joined: 30-07-2010
PCM$: 200.00
|
Never heard about that problem, and can't really see why the number of equipment would have something to do with equipment names not appearing. Additionally, I've had brands with 21 equipment pieces and their names appear fine.
But when you say their names 'disappeared', you mean they all have the same name of some random equipment? If yes, then what happens is that one of the fkIDequipment_unlock values is wrong, messing up the whole menu below the 'faulty' equipment. But if you mean they disappeared for real (nothing appears at all), then I've really never seen anything like that.
|
|
|
|
timpiej |
Posted on 15-11-2013 15:53
|
Domestique
Posts: 598
Joined: 08-12-2007
PCM$: 200.00
|
No, the boxes of the frames etc. are there, only thing is they are empty. I'll check the collumn fkIDequipment_unlock like you said and see if I messed up there. Thanks for the help! |
|
|
|
Ad Bot |
Posted on 26-12-2024 04:01
|
Bot Agent
Posts: Countless
Joined: 23.11.09
|
|
IP: None |
|
|
timpiej |
Posted on 16-11-2013 09:22
|
Domestique
Posts: 598
Joined: 08-12-2007
PCM$: 200.00
|
Ok, I've checked the collumn and couln't find anything unusual.
The setup is first the track bikes (9), timetrial bikes (7) and then roadbikes (11). So there is a total of 27 frames.
Same setup with the wheels and same problem wheels and helmets.
I have other equipment marques that work flawlessly
So only thing I can think of that could be the problem is the track stuff in front. Because it's those marques that have this no-name problem. What are your experiences with track stuff and where to put it? |
|
|
|
lluuiiggii |
Posted on 16-11-2013 18:01
|
Grand Tour Champion
Posts: 8542
Joined: 30-07-2010
PCM$: 200.00
|
There's no problem in having track stuff together with 'normal' equipment marques. That happens for example in Daily's DB. But if the problems happens only and specifically in these marques, since I have no idea what else it could be I'd try deleting these equipment and seeing if it works.
|
|
|
|
timpiej |
Posted on 17-11-2013 13:25
|
Domestique
Posts: 598
Joined: 08-12-2007
PCM$: 200.00
|
I've tried what you said, and if I remove the trackstuff I can see the names (I've only tried this with the frames but I suppose if the frames work this way, so might the wheels & helmets). Is 9 trackframes too much to put in 1 marque? |
|
|
|
lluuiiggii |
Posted on 17-11-2013 15:16
|
Grand Tour Champion
Posts: 8542
Joined: 30-07-2010
PCM$: 200.00
|
No idea if track frames is too much to put in one marque, but again, I don't see why there'd be a link between equipment number and the names appearing or not But anyway, if that works, just do it for all the other ones and see if it works.
|
|
|
|
timpiej |
Posted on 17-11-2013 17:31
|
Domestique
Posts: 598
Joined: 08-12-2007
PCM$: 200.00
|
lluuiiggii wrote:
No idea if track frames is too much to put in one marque, but again, I don't see why there'd be a link between equipment number and the names appearing or not But anyway, if that works, just do it for all the other ones and see if it works.
That was my plan. And it did work So I have no more ideas about what the problem could be. I've attached the file for if anyone would be willing to look at it...
So in this rarfile there is the sta_equipment, sta_equipment_notrack (so without the trackstuff) and the sta_equipment marques. The problem is marques 1, 6, 7, 8 & 10.
EDIT: So I've seen in the pcmdaily DB that all trackstuff has 0 in the collumn fkIDequipment_unlock, so I did this for my equipment aswell. It works for the frames, but not for the wheels and helmets... Very strange this
timpiej attached the following file:
Edited by timpiej on 17-11-2013 20:38
|
|
|
|
timpiej |
Posted on 17-11-2013 20:40
|
Domestique
Posts: 598
Joined: 08-12-2007
PCM$: 200.00
|
EDIT: So I've seen in the pcmdaily DB that all trackstuff has 0 in the collumn fkIDequipment_unlock, so I did this for my equipment aswell. It works for the frames, but not for the wheels and helmets... Very strange this
So this is the DB I'm having right now
EDIT: a test with this DB revealed that the wheels and helmets are not visible in a 3D-race aswell. The frames are though. All equipment that is set for the teams is working without any problem.
timpiej attached the following file:
Edited by timpiej on 17-11-2013 20:58
|
|
|
|
Jesleyh |
Posted on 19-11-2013 14:35
|
Tour de France Champion
Posts: 15274
Joined: 21-07-2012
PCM$: 200.00
|
Does -1 in a table(f.e decline, or 'contract until' for sponsors) mean next year, or never, or already started last year?
Edited by Jesleyh on 19-11-2013 17:42
Feyenoord(football) and Kelderman fanboy
PCMdaily Awards: 12x nomination, 9x runner-up, 0x win.
|
|
|
|
Lachi |
Posted on 19-11-2013 20:51
|
Grand Tour Champion
Posts: 8516
Joined: 29-06-2007
PCM$: 200.00
|
There is one thing you can do. Make a copy of your save and edit it. Try -1, 0, 1 and a year to see how it looks like in the game. |
|
|
|
Jesleyh |
Posted on 19-11-2013 20:57
|
Tour de France Champion
Posts: 15274
Joined: 21-07-2012
PCM$: 200.00
|
Hmm, true, but for testing decline age, I of course have to simulate half a season multiple times to test it, so that's why I wondered if someone knew it straight away.
Feyenoord(football) and Kelderman fanboy
PCMdaily Awards: 12x nomination, 9x runner-up, 0x win.
|
|
|
|
timpiej |
Posted on 21-11-2013 16:24
|
Domestique
Posts: 598
Joined: 08-12-2007
PCM$: 200.00
|
Just a quick note to say that I've been a bit testing how far I can push the amount of teams, I've tried up to 219 teams at this point and the there are no problems, so the limit might indeed be removed. |
|
|
|
Lachi |
Posted on 21-11-2013 21:35
|
Grand Tour Champion
Posts: 8516
Joined: 29-06-2007
PCM$: 200.00
|
@Jesleyh: -1 in DYN_cyclist in gene_i_age_decline? I don't have it in my career. Maybe an error in the career, or is this about the database. |
|
|
|
Jesleyh |
Posted on 22-11-2013 06:06
|
Tour de France Champion
Posts: 15274
Joined: 21-07-2012
PCM$: 200.00
|
Database indeed
Feyenoord(football) and Kelderman fanboy
PCMdaily Awards: 12x nomination, 9x runner-up, 0x win.
|
|
|
|
timpiej |
Posted on 22-11-2013 13:01
|
Domestique
Posts: 598
Joined: 08-12-2007
PCM$: 200.00
|
How do I open a local? Apperently the full editor can't open it... |
|
|
|
lluuiiggii |
Posted on 22-11-2013 15:24
|
Grand Tour Champion
Posts: 8542
Joined: 30-07-2010
PCM$: 200.00
|
timpiej wrote:
How do I open a local? Apperently the full editor can't open it...
It should open it, did you try checking the 'Local.cdb' box?
|
|
|
|
timpiej |
Posted on 22-11-2013 16:50
|
Domestique
Posts: 598
Joined: 08-12-2007
PCM$: 200.00
|
lluuiiggii wrote:
timpiej wrote:
How do I open a local? Apperently the full editor can't open it...
It should open it, did you try checking the 'Local.cdb' box?
Yep, but all I get is an export.xml file with nothing in it, and the editor gives an error if trying to open the file.
Edit: tried opening the file with excel but there's only two 0's in the file
Edited by timpiej on 22-11-2013 16:51
|
|
|
|
Lachi |
Posted on 22-11-2013 22:00
|
Grand Tour Champion
Posts: 8516
Joined: 29-06-2007
PCM$: 200.00
|
You can open local.cdb with both of my editors, if I'a not mistaken. |
|
|
|
timpiej |
Posted on 23-11-2013 07:37
|
Domestique
Posts: 598
Joined: 08-12-2007
PCM$: 200.00
|
lluuiiggii wrote:
timpiej wrote:
How do I open a local? Apperently the full editor can't open it...
It should open it, did you try checking the 'Local.cdb' box?
Lachi wrote:
You can open local.cdb with both of my editors, if I'a not mistaken.
I made the noobish mistake to keep a space in the name, Lachi's editor pointed this out. Thanks. |
|
|
|
Lachi |
Posted on 23-11-2013 22:58
|
Grand Tour Champion
Posts: 8516
Joined: 29-06-2007
PCM$: 200.00
|
How can you have a space in "local.cdb"? |
|
|