PCM.daily banner
18-08-2018 03:35
PCM.daily
Users Online
· Guests Online: 18

· Members Online: 0

· Total Members: 134,654
· Newest Member: strojw9
Donate
View Thread
PCM.daily » Pro Cycling Manager 2017 » PCM 17: Databases
 Print Thread
Lachis Editor v32 for PCM 2017 (August, 14)
Lachi
I made a test version for the new game.

This version should be able to open all tables in the PCM 2017 databases as well as the local.cdb

Updates in v32:
- Bugfix for table DYN_cyclist_peak_detail

Updates in v31:
- None except compatibility with PCM 2017

Updates in v30:
- Additional filter criteria: Contains
The filtering criterias have to be separated by comma
- Bugfix for crash in file selection dialog

Updates in v29:
- Lookups for DYN_season_targets

Features (same as last years version):
- Numbers are displayed nice
- Look-up of linked tables (fkID...)
- Recognizes totally wrong numbers
- Possibility to only see data from own team
- Table layouts can be customized and saved
- Individual table layouts for each game version
- Works with all versions of the game (hopefully)
- 7 languages: English, German, Portuguese, French, Spanish, Italian, Norwegian
- Referential integrity for foreign keys (fkID...)
- Tables linked to parent table
- Linked tables are sorted alphabetically
- Filtering is possible for all tables and columns
- Region lookup in DYN_sponsor + sponsor_region shows country + region
- Mass editing feature

Short description of the mass editing feature
Select the column you want to edit, then select how you want to change the values in that column. Lastly enter the value or factor, then press 'Apply'.
At the moment only numeric columns can be altered using one of these modes:
"=" will overwrite the values in the column with the given number
"+" will increase the value in the column by the given number
"-" will decrease the value in the column by the given number
"+ %" will increase the value in the column by the given percentage
"- %" will decrease the value in the column by the given percentage
For example you can increase the age of decline for all riders by 2. Or you lower the sprint value for all Italian riders by 5%. Unlimited possibilities also means unlimited possibilities to mess so, so save before using this feature. You can also make a backup of the cdb file to be extra sure.

WARNING: This version is considered a test version, so better don't overwrite your save, just in case.

To unpack this archive, you need a tool like 7-zip, which can be downloaded for free: https://www.7-zip....

To run this editor, you need to have Microsoft .Net Framework 3.5 SP1 or higher installed.

You can download my editor here:
https://lachi.myga...tor_v32.7z
Edited by Lachi on 14-08-2017 16:39
 
hillis91
Awesome dude! Allways the best Banana
i.imgur.com/vR8EVAA.png
i.imgur.com/t8UX9zz.png
i.imgur.com/5dUeeMH.png
 
Dostra
Hello,

can I use 17┬┤Lachi Editor for PCM 16 with WIN 10,especially savegames?

thx in advance
 
matt17br
Dostra wrote:
Hello,

can I use 17┬┤Lachi Editor for PCM 16 with WIN 10,especially savegames?

thx in advance

It seems to work just fine on my machine.
Manager of pcmdaily.com/files/Micros17/ged.png Generali - EDF pcmdaily.com/files/Micros17/ged.png

i.imgur.com/pyvc2uc.png
 
http://v.ht/Matt17
Dostra
matt17br wrote:
Dostra wrote:
Hello,

can I use 17┬┤Lachi Editor for PCM 16 with WIN 10,especially savegames?

thx in advance

It seems to work just fine on my machine.


Thanks for request my friend.
 
Lachi
Yes, my editor should work for all PCM games.
You can edit DBs, save games, and the local.cdb.
And it should work under all recent Windows operating systems.
 
HeDi
Hi Lachi, thanks for the new editor.

Just one thing, when I define the table layout the editor crashs as soon as I edit something in the Cyclist table and then try to sort it.. Maybe due to another table format?
 
JumpingKnights
Hi,

i am new to the game, i tried to install the editor.
i first installed 7-zip, then installed the editor but cant find it i setted on my screen, there i can found it but cant use it.

Any help possible?
My thanks
 
matt17br
JumpingKnights wrote:
Hi,

i am new to the game, i tried to install the editor.
i first installed 7-zip, then installed the editor but cant find it i setted on my screen, there i can found it but cant use it.

Any help possible?
My thanks

If you've followed the installation guide correctly, then you will have opened the rar file with 7-zip and extracted the 'LachisEditor' folder - containing all the relevant files - to your preferred directory. In order to open the Editor, you'll have to double click on 'LachisEditor.exe'.
Manager of pcmdaily.com/files/Micros17/ged.png Generali - EDF pcmdaily.com/files/Micros17/ged.png

i.imgur.com/pyvc2uc.png
 
http://v.ht/Matt17
Ad Bot
Posted on 18-08-2018 03:35
Bot Agent

Posts: Countless
Joined: 23.11.09

IP: None  
JumpingKnights
matt17br wrote:
JumpingKnights wrote:
Hi,

i am new to the game, i tried to install the editor.
i first installed 7-zip, then installed the editor but cant find it i setted on my screen, there i can found it but cant use it.

Any help possible?
My thanks

If you've followed the installation guide correctly, then you will have opened the rar file with 7-zip and extracted the 'LachisEditor' folder - containing all the relevant files - to your preferred directory. In order to open the Editor, you'll have to double click on 'LachisEditor.exe'.


hi tnx, i got it. it works, now can i use it on my solo char? i mainly play career from scratch with my cyclist (not manager) can i edit his stats?)
 
hillis91
JumpingKnights wrote:
matt17br wrote:
JumpingKnights wrote:
Hi,

i am new to the game, i tried to install the editor.
i first installed 7-zip, then installed the editor but cant find it i setted on my screen, there i can found it but cant use it.

Any help possible?
My thanks

If you've followed the installation guide correctly, then you will have opened the rar file with 7-zip and extracted the 'LachisEditor' folder - containing all the relevant files - to your preferred directory. In order to open the Editor, you'll have to double click on 'LachisEditor.exe'.


hi tnx, i got it. it works, now can i use it on my solo char? i mainly play career from scratch with my cyclist (not manager) can i edit his stats?)


Yes you can, click "Team filter" and then load up dyn_cyclist -> Find the rider you want to edit -> Edit away
i.imgur.com/vR8EVAA.png
i.imgur.com/t8UX9zz.png
i.imgur.com/5dUeeMH.png
 
JumpingKnights
hillis91 wrote:
JumpingKnights wrote:
matt17br wrote:
JumpingKnights wrote:
Hi,

i am new to the game, i tried to install the editor.
i first installed 7-zip, then installed the editor but cant find it i setted on my screen, there i can found it but cant use it.

Any help possible?
My thanks

If you've followed the installation guide correctly, then you will have opened the rar file with 7-zip and extracted the 'LachisEditor' folder - containing all the relevant files - to your preferred directory. In order to open the Editor, you'll have to double click on 'LachisEditor.exe'.


hi tnx, i got it. it works, now can i use it on my solo char? i mainly play career from scratch with my cyclist (not manager) can i edit his stats?)


Yes you can, click "Team filter" and then load up dyn_cyclist -> Find the rider you want to edit -> Edit away


i mean the pro cyclist.
Because cant find my cyclist name in it.
 
matt17br
You are probably not loading your savegame, you need to load the file found in documents\pcm 17\cloud\username.
Manager of pcmdaily.com/files/Micros17/ged.png Generali - EDF pcmdaily.com/files/Micros17/ged.png

i.imgur.com/pyvc2uc.png
 
http://v.ht/Matt17
Netris
Nice ! Gonna try it now Pfft
 
Lachi
HeDi wrote:
Hi Lachi, thanks for the new editor.

Just one thing, when I define the table layout the editor crashs as soon as I edit something in the Cyclist table and then try to sort it.. Maybe due to another table format?

I cannot reproduce this error.
Can you please explain in more detail?
What did you change in the table layout?
What are you editing?
Which error? (There is a file called Error.txt which should contain the error)
 
nickyoe45
Iam wondering how i can change he tiredness and my fitness.
I really dont understand. Anyone know how does this works
hoi123
 
hillis91
nickyoe45 wrote:
Iam wondering how i can change he tiredness and my fitness.
I really dont understand. Anyone know how does this works


You need to use the riders ID number, f.eks. 301

Then go to Dyn_fitness_cycliste --> Cycliste_Id and 301 (In the team filter window) --> Press enter --> To change form it's -5536 for "top" form, and three rows to the right its Fatigue, just set it to 0 if you want to erase the fatigue.

Writing this out of memory, so it might be a bit wierd explained, if nobody else explains it better, i can write a new post later after work.
i.imgur.com/vR8EVAA.png
i.imgur.com/t8UX9zz.png
i.imgur.com/5dUeeMH.png
 
HeDi
Lachi wrote:
HeDi wrote:
Hi Lachi, thanks for the new editor.

Just one thing, when I define the table layout the editor crashs as soon as I edit something in the Cyclist table and then try to sort it.. Maybe due to another table format?

I cannot reproduce this error.
Can you please explain in more detail?
What did you change in the table layout?
What are you editing?
Which error? (There is a file called Error.txt which should contain the error)




It's not an real error, the program just does not response.. I attached a picture how I changed the layout.
Unfortunatly there is no file called Error.txt..

I edit one stat of a rider for example. then I try to order all riders by one stat (for example by climbing) and at this step the editor stops working or gives no answer. And the problem only comes up when trying to sort the table.

After some tests I noticed that this problem only exists when I open the full cyclist table, with team filter on there is no problem.. Frown Editor also works more smooth with team filter on.

I used the editor also before the update for pcm17 and there also were this problem. I'm not sure but I guess this lag appeared after updating Windows 10 to the new Creators update. So I tested it on another system (Windows 8.1) and it worked perfectly. I think there is something new in Windows which stops the editor at its work.

I hope it is a little bit clearer now :lol:
HeDi attached the following image:
unbenannt2.png
 
nickyoe45
hillis91 wrote:
nickyoe45 wrote:
Iam wondering how i can change he tiredness and my fitness.
I really dont understand. Anyone know how does this works


You need to use the riders ID number, f.eks. 301

Then go to Dyn_fitness_cycliste --> Cycliste_Id and 301 (In the team filter window) --> Press enter --> To change form it's -5536 for "top" form, and three rows to the right its Fatigue, just set it to 0 if you want to erase the fatigue.

Writing this out of memory, so it might be a bit wierd explained, if nobody else explains it better, i can write a new post later after work.

Thanks for your answer but unfortunately its not working. everything i want to edit is not working
hoi123
 
Lachi
HeDi wrote:
Lachi wrote:
HeDi wrote:
Hi Lachi, thanks for the new editor.

Just one thing, when I define the table layout the editor crashs as soon as I edit something in the Cyclist table and then try to sort it.. Maybe due to another table format?

I cannot reproduce this error.
Can you please explain in more detail?
What did you change in the table layout?
What are you editing?
Which error? (There is a file called Error.txt which should contain the error)


It's not an real error, the program just does not response.. I attached a picture how I changed the layout.
Unfortunatly there is no file called Error.txt..

I edit one stat of a rider for example. then I try to order all riders by one stat (for example by climbing) and at this step the editor stops working or gives no answer. And the problem only comes up when trying to sort the table.

After some tests I noticed that this problem only exists when I open the full cyclist table, with team filter on there is no problem.. Frown Editor also works more smooth with team filter on.

I used the editor also before the update for pcm17 and there also were this problem. I'm not sure but I guess this lag appeared after updating Windows 10 to the new Creators update. So I tested it on another system (Windows 8.1) and it worked perfectly. I think there is something new in Windows which stops the editor at its work.

I hope it is a little bit clearer now :lol:

Thanks, I understand it now.
I have the creators update also and did not see this problem yet but I will try again.
 
Jump to Forum:
Similar Threads
Thread Forum Replies Last Post
News in August Cycling 85 17-08-2018 15:54
2017 Jerseys | Overview PCM 17: Graphics 424 16-08-2018 11:43
Changes in Fast Editor PCM 18: Technical issues 1 15-08-2018 23:44
National Championships 2017 Discussion [Man-Game] Other Races 215 10-08-2018 09:35
Man-Game GT Watch 2017 [Man-Game] General 56 09-08-2018 18:43
Login
Username

Password



Not a member yet?
Click here to register.

Forgotten your password?
Request a new one here.
Latest content
Screenshots
Scandinavian Domination
Scandinavian Domination
PCM09: General Screenshots
Fantasy Betting
Current bets:
No bets available.
Best gamblers:
bullet Vien 15,335 PCM$
bullet Paul23 9,050 PCM$
bullet qwerty 7,600 PCM$
bullet kodman 7,250 PCM$
bullet Dippofix 4,350 PCM$

bullet Main Fantasy Betting page
bullet Rankings: Top 100
ManGame Betting
Current bets:
No bets available.
Best gamblers:
bullet trekbmc 10,694 PCM$
bullet Vien 6,100 PCM$
bullet baseball... 5,456 PCM$
bullet jseadog1 5,355 PCM$
bullet Selwink 4,700 PCM$

bullet Main MG Betting page
bullet Get weekly MG PCM$
bullet Rankings: Top 100
Render time: 0.11 seconds