I've figured out how to edit most things using too SQLite DB browser like exp,lvl, class lvl, items, money. But I cannot figure out how to edit masteries. I know they are located in the "companypropertymaster" section but I do not how to add masteries because there are many different types of entries and I think the in game mastery name is different from the save file mastery id. Does anyone have any tips?
I don't know how to add new mastery too,
but I know how to edit amounts of masteries.
In the "companyPropertyMaster",
the entry of mastery amount is "Mastery/mastery name/amount"
Hi there,
I found the mastery entries. But I don't see any editable numbers. Only the text.
How do you change the value of the amount?
Do you add a number after 'amount'? Or do you replace the word 'amount' with the number you need?
It would be great if you could shed some light on this one.
Thanks!
update companyProperty
set cpValue = 9999
where masterIndex in (select masterIndex from companyPropertyMaster where masterName like '%Amount')
Ahh, now I understand.
I thought that the values could be modified without any scripts.
Well, I should have known better.
Thank you for the fast reply!
Ahh, now I understand.
I thought that the values could be modified without any scripts.
Well, I should have known better.
Thank you for the fast reply!
You can actually edit the data row directly without script. This script I only created to make the job easier.
For someone whom has never done this before and has 0 idea about codes and scripting, it's hard to edit the data, especially if you have to find multiple values. Thank you for the script.
About the game crashing when you load a save, i found a way to avoid it :
Load a save that your game accept (a copy of an old save),
Start the game, load the save
Then go back to title menu,
Then replace the save with the one you want to use,
Then load the save again in the game (without closing it), and voila it will always works
Edit : and delete the "cache client" file in Documents folder.
bro do you know why i can't delete the save at the main menu?
it suddenly give me error thing when i delete the save file, it says the file was used by the game. itnever happened before
thanks
I never had this issue and i don't understand why it happen, so i don't know, sorry
About the game crashing when you load a save, i found a way to avoid it :
Load a save that your game accept (a copy of an old save),
Start the game, load the save
Then go back to title menu,
Then replace the save with the one you want to use,
Then load the save again in the game (without closing it), and voila it will always works
Edit : and delete the "cache client" file in Documents folder.
bro do you know why i can't delete the save at the main menu?
it suddenly give me error thing when i delete the save file, it says the file was used by the game. itnever happened before
thanks
You don't delete the save, you copy and paste your "broken" save over the working one. At least that's how it works for me.
update companyProperty
set cpValue = 9999
where masterIndex in (select masterIndex from companyPropertyMaster where masterName like '%Amount')
Thanks for the script. Do you know of any way to add mastery that you haven't unlocked/found yet? It seems this script will only modify amounts of mastery you already have. I tried adding new entries to the db such as mastery/"mastery name"/amount but noticed the mastery names are not always the same in the db as they are in game. For example, counterattack mastery is called BladeParry in the db. Is there anyway to find a list of mastery IDs for the db?
About the game crashing when you load a save, i found a way to avoid it :
Load a save that your game accept (a copy of an old save),
Start the game, load the save
Then go back to title menu,
Then replace the save with the one you want to use,
Then load the save again in the game (without closing it), and voila it will always works
Edit : and delete the "cache client" file in Documents folder.
bro do you know why i can't delete the save at the main menu?
it suddenly give me error thing when i delete the save file, it says the file was used by the game. itnever happened before
thanks
Happened to me once, what I did was disconnect my internet, somehow the game process was using the save while internet was connected. Disconnect and you can replace your save no problem, then reconnect whenever you want.
The masterIndex is not the same as mastery ID, it is just there for data governance in relational database. It doesn't really mean anything outside of the database itself. For example, here's mine, I've manually added many entries by just incrementing masterIndex off the latest one. Btw, the "masteryMaster" table is for equipped masteries. To change the equip status (on/off + which mastery board), do it in "mastery" table.
The masterIndex is not the same as mastery ID, it is just there for data governance in relational database. It doesn't really mean anything outside of the database itself. For example, here's mine, I've manually added many entries by just incrementing masterIndex off the latest one. Btw, the "masteryMaster" table is for equipped masteries. To change the equip status (on/off + which mastery board), do it in "mastery" table.
Thanks for the reply m8. I got the hang of the masteries with your help.
Could you give me a light on altering stats aswell? I've been changing the values on "stats/etc" from the rosterpropertymastery but the values ingame doesn't seem to change.
[FONT=verdana]I delete the cache in documents, but it keeps crashing, even upon making a new company, if the old .sav file is in there, it crashes when clicking new game, and creating a new save which will work for a while or sometimes just until you exit and re launch the game, importing old .sav doesn't work, it crashes anyway, cache file deleted as well.
Can't get it to work, keeps crashing when i try load my save, it works for a while but eventually stops and have to start from scratch. It seems to be something within the .sav file, a flag there or something.
I also wonder if it's possible to add Carter's abilities/masteries to the company.[/FONT]
update companyProperty
set cpValue = 9999
where masterIndex in (select masterIndex from companyPropertyMaster where masterName like '%Amount')
Not familiar with implementing scripts can anyone kindly explain the step by step how to do this please? I have DB browser (SQLite) installed and made some small changes, Vill, item amount etc.
