Config.DB values

[Ky0_GC]

Hello @Red,

I would like to know if it's faisible that any time we have an update, the "old" datas DB, could be kept as it is?
I mean I made some changes in DB but every time new update comes I have to deal with the same thing, that is to reconfigure all the changes again and again... at the same time I made some translation language tests, and same here... have to re-do it again...
I would like to know if it would be possible to consider to keep for the DB and config/settings files all the "old/changed" data and only update those files with the new content, instead of "reset" all the files ?

If faisible without too much trouble for you, would be a very great addition

Ty and keep the good work as usual
Congratz

[red51]

Unfortunately I'm afraid that this isn't possible =/ The changes are downloaded by Steam, unfortunately there is no way to hook into this process... so it's out of our control. Once the game launches (i.e. as soon as we gain control), the DB file had already been replaced...

We could think about a way that the user could keep a copy of the file which contains all the changes... although it's probably tricky to define which changes the user acutally wants to keep...

Another thing I could think of is to enable custom SQL commands to be supported by the game (which would be applied to the database when starting the game). So instead of editing the definitions file, you would just add SQL commands to achieve the same thing (for instance, if you want to change the stack size of all items to 999, the SQL command for that would be "UPDATE items SET stacksize=999"). However, this isn't very user friendly... and it gets quite verbose if you want to update individual items differently, for example.

Having said that, being able to edit the definitions through the Plugin API is also on our to-do list. Once that's implemented, we could release an example plugin to change settings in the definitions (although we would still have to think about a user friendly way to perform the changes then).

[Kaeru Gaman]

reading your reply....
would it be possible for a player to create a batch file with the SQL commands he wants and have this batch file executed if it is there?
something like "player_DB_conf.sqlbat" (don't know the ending for an SQL batch)

that way the player could collect all the SQL changes they want and keep the batch file over the updates...

[Ky0_GC]

ok, I see...
Maybe a simple option before update that tolds you :
"do you want to save some DB/properties files?"
Then when updated if you had ticked that option to keep some old files backuped, then the game proposes you to add old data files with the new files... let's say on the new files the game will copy old file and merge it with the new file, like that you will have a "recompiled" file with old datas and new implemented datas in one

don't know if I’m explaining clearly :D

[red51]

Originally posted by Kaeru Gaman:

reading your reply....
would it be possible for a player to create a batch file with the SQL commands he wants and have this batch file executed if it is there?
something like "player_DB_conf.sqlbat" (don't know the ending for an SQL batch)

that way the player could collect all the SQL changes they want and keep the batch file over the updates...

We can add this, but it's basically more or less the same I meant with the "custom SQL commands" in my post above (I used the word "queries" earlier but that's misleading, so I've changed that) ^^
It's still not very user friendly though... the user would have to set up SQL commands instead of being able to edit the DB with a UI-based tool =/

Originally posted by Ky0_GC:

Maybe a simple option before update that tolds you :
"do you want to save some DB/properties files?"
Then when updated if you had ticked that option to keep some old files backuped, then the game proposes you to add old data files with the new files... let's say on the new files the game will copy old file and merge it with the new file, like that you will have a "recompiled" file with old datas and new implemented datas in one

Basically that would require some kind of UI where you can select which columns and rows you actually want to copy from another db file... if we just let the user store the entire items table, for example, this might get problematic if some values for existing items changed with an update (e.g. the model path). The game would need some kind of editor or dialog where you could select the columns you want to overwrite (e.g. if you just want to update the stack sizes, for example). There is unfortunately quite some work involved to implement something like that (and I also guess that the majority of users doesn't edit the database file at all)...

[Ky0_GC]

Originally posted by red51:

...if some values for existing items changed with an update...

Hammyeah... didn't think about that... indeed... :/
Well yeah... maybe with some Plugin API... dunno