Project Hospital
Would you like to react to this message? Create an account in a few clicks or log in to continue.

PH Database Editor

+5
andyking233
QEUH
ivanchu0411
jan.oxymoron
juraj.horvath
9 posters
Go down
avatar
andyking233
intern
Posts : 4
Reputation : 7
Join date : 2019-03-06

PH Database Editor Empty PH Database Editor

Wed Mar 06, 2019 10:33 pm
Message reputation : 100% (3 votes)
Hi everybody,

I really enjoy the complexity of the game! As many of you, I had a look at the xml files: thanks to the good work of the developers the file structure and the xml nodes are quite self explanary, but the size of some files makes it hard to create own symptoms, diagnoses, etc, especially if you're looking for some cryptic Treatment-ID...

My idea is to write a little helper program which is able to load the database in some UI, so even users with less xml experience are able to easily edit game options or create new diseases, symptoms, etc! Maybe this tool could be useful for some experienced modders too, who want to create way more than "just a few tweaks".

I added a screenshot of the current development - which is quite at the beginning, but please have a look by yourself.

Planned Features:

  • Edit General game Settings
  • Edit, Create or Delete Symptoms, Examinations, Treatments
  • Multi-Language Support based on language files
  • Edit many more XML files (which i Need to explore first, too!)


I would like to know, what you guys think? Is a tool like this helpful for you as modder? What features would you like to see?
Greetings,
Andy

PH Database Editor Phdb10

Vainitalinda likes this post

avatar
juraj.horvath
specialist
Posts : 146
Reputation : 8
Join date : 2018-08-07
Age : 45
Location : Bratislava, Slovak Republic

PH Database Editor Empty Re: PH Database Editor

Thu Mar 07, 2019 7:46 am
Hi,

you did a great job, but I think that current structure of files is not usable for modding. If several modders affect same game files, it will be mess and possibly it could lead to serious conflict.
jan.oxymoron
jan.oxymoron
developer
Posts : 2309
Reputation : 336
Join date : 2018-03-23

PH Database Editor Empty Re: PH Database Editor

Thu Mar 07, 2019 12:46 pm
Hi Andy, this is actually quite amazing! Smile

We edit the xml files directly on our side, but I can imagine how useful this tool can become, so let me give you a couple of tips at this point (we're working on documentation for modders in the meantime, but unfortunately as I'm currently also integrating workshop functionality, it still keeps changing too much, especially the location of files and asset loading).

The database is designed to be modular, so for example a mod with new diagnoses can consist of a new set of Diagnoses.xml, Symptoms.xml etc (you can check Objects, these are already in separate files), so the editor would need to be able to load/save the database from different folders.

Also, there are still some minor changes expected in the database structure (luckily not much on this 'medical' side), so please be aware of that. One example is the N:M relation between examinations/treatments and rooms, that will need to be changed to allow both new rooms and new procedures without changing the main database files every time.

Really curious to see how this progresses, but I should also suggest to wait for the documentation, as it might save you some time and implementation changes. Smile




avatar
andyking233
intern
Posts : 4
Reputation : 7
Join date : 2019-03-06

PH Database Editor Empty Re: PH Database Editor

Thu Mar 07, 2019 10:36 pm
Thank you guys for your feedback so far. I am aware of the current situation with conflicted files and editing "base files".
But I think the xml structures in the mod files won't be much different from the core files, so changing the functionality won't be a big difficulty.

jan.oxymoron wrote:Hi Andy, this is actually quite amazing! Smile

We edit the xml files directly on our side, but I can imagine how useful this tool can become, so let me give you a couple of tips at this point (we're working on documentation for modders in the meantime, but unfortunately as I'm currently also integrating workshop functionality, it still keeps changing too much, especially the location of files and asset loading).
Sounds like you could need some tool, too  Cool
When the general functionalities are working, the oncoming changes on the database won't be that tricky. But yes, the program will have to be updated every time the DB structures are getting changed.

jan.oxymoron wrote:The database is designed to be modular, so for example a mod with new diagnoses can consist of a new set of Diagnoses.xml, Symptoms.xml etc (you can check Objects, these are already in separate files), so the editor would need to be able to load/save the database from different folders.
That was some important information. The program is already able to load many xml files of the same type (e.g. symptoms + symptoms_main) and combine them for editing. I will also implement some kind of "packet" / "module" manager, in which you can load/save/create packages without affecting the default files.

jan.oxymoron wrote:Also, there are still some minor changes expected in the database structure (luckily not much on this 'medical' side), so please be aware of that. One example is the N:M relation between examinations/treatments and rooms, that will need to be changed to allow both new rooms and new procedures without changing the main database files every time.
OK, i will keep that in mind. There are plenty of other things to do in the meanwhile  Very Happy

jan.oxymoron wrote:
Really curious to see how this progresses, but I should also suggest to wait for the documentation, as it might save you some time and implementation changes. Smile
I will keep you informed about the process and hope to upload an early alpha version soon. Until the release of the documentation i will try to focus on the generic functions.

Greetings,
Andy
avatar
ivanchu0411
medic
Posts : 2
Reputation : 0
Join date : 2019-03-11

PH Database Editor Empty Re: PH Database Editor

Mon Mar 11, 2019 11:45 pm
Beautiful job!!!! I do not see the time to start loading new pathologies and symptoms into the game
avatar
andyking233
intern
Posts : 4
Reputation : 7
Join date : 2019-03-06

PH Database Editor Empty Re: PH Database Editor

Wed Apr 03, 2019 10:35 pm
Message reputation : 100% (1 vote)
Hey guys,
short update on the dev process.
At the moment the following xml's can be loaded and edited:

  • Symptoms (including Symptoms_main)
  • Treatments (including Surgery, TreatmentsHospitalization)
  • Examinations
  • Departments
  • Diagnoses grouped by Department


The following xml structures are also planned:

  • Languages: with the ability to easily create / modify translations.
  • InsuranceCompanies
  • Events
  • Tweakables
  • ....


I know, there are many more xml's, but I think these are the most common to be edited?

PH Database Editor Treatm10
PH Database Editor Diagno10
QEUH
QEUH
specialist
Posts : 239
Reputation : 42
Join date : 2018-03-26
Location : Glasgow

PH Database Editor Empty Re: PH Database Editor

Fri Apr 12, 2019 2:19 am
Great work, would love to try this out!
avatar
andyking233
intern
Posts : 4
Reputation : 7
Join date : 2019-03-06

PH Database Editor Empty Re: PH Database Editor

Wed May 01, 2019 1:23 am
Message reputation : 100% (3 votes)
Hey all, short update on the current development:
- Language Integration finished. You can now edit database entries in a desired language.

I am able to relase an early alpha version shortly... Smile

PH Database Editor Unbena10
PH Database Editor Unbena11
PH Database Editor Unbena12

avatar
Wafthrudnir
resident
Posts : 22
Reputation : 2
Join date : 2018-08-24

PH Database Editor Empty Re: PH Database Editor

Mon Jun 03, 2019 2:38 pm
That's fantastic, neat and clever. Great job!
avatar
Linus
resident
Posts : 27
Reputation : 3
Join date : 2018-03-26
Location : Austria

PH Database Editor Empty Re: PH Database Editor

Mon Jun 03, 2019 2:53 pm
Would absolutely try it, good job!
GameTrip
GameTrip
intern
Posts : 6
Reputation : 1
Join date : 2019-06-04
Location : France
http://www.gametrip.net

PH Database Editor Empty Re: PH Database Editor

Sat Jun 08, 2019 12:15 pm
Absolutely great and useful job ! thanks ! can't wait to test that
avatar
Butch
attending
Posts : 46
Reputation : 7
Join date : 2019-06-06

PH Database Editor Empty Re: PH Database Editor

Sat Jun 08, 2019 1:38 pm
Amazing work! Can't wait to try this out.
Sponsored content

PH Database Editor Empty Re: PH Database Editor

Back to top
Permissions in this forum:
You cannot reply to topics in this forum