[Open-Source] DB2Media <-> Media2DB Converter

Isoline* · 07/07/2020, 08:05

Hi,
I know that this was already made before, however, many structures are missing nor doesn't work in some extreme cases, as always had to do things a wee bit different.

I thought about starting this open-source project that all of you can contribute and decipher the media-db relations. I think that this community lacks contribution. In the hope that it will include all of the tables-texts relations.
Source-code attached.

In a nutshell this is just your run of the mill DB2Media Converter.

Dynamically creates the correct division for Item/Character/Skill Data based on your server IDs range.
Supports local or remote mssql connection.
Every file on textdata folder path will be deleted upon startup. So i'd advise you not to keep anything important there.
The output folder will be focused on after completion.
Set your configuration on config.ini
Never bothered to include the full Media2DB project, you have the logic just reverse it. (Sorry, no leeching on other servers )
Credits goes to to SUPERKHUNG from gamevn for the skilldata encryption-decryption a while back.

Supported .txt files:

Contribution:

Chardata issue caused by a typo in its query fixed, reported by @ - Source code in attachements has been updated to v1.1

@Grayson · 07/07/2020, 10:53

good work

! Split · 07/07/2020, 12:03

g.j keep it up

Worshiper · 07/07/2020, 17:30

Nice work

guckguck · 07/07/2020, 19:48

Could you please add to your description what kind of pro and cons this tool offers compared to the "old one":

The source code is attached, flexible configuration added and it is still developed. It is quite pointless to contribute in two projects of the same topic.

Isoline* · 07/07/2020, 20:24

Quote:

Originally Posted by guckguck

Could you please add to your description what kind of pro and cons this tool offers compared to the "old one":

The source code is attached, flexible configuration added and it is still developed. It is quite pointless to contribute in two projects of the same topic.

It supports more files than whats out there. It creates the files dynamically not constantly so even if you got your object IDs messed up like most server do, it will still support it and it's parent file.
It has the base for the opposite Media2DB route.
That about sums it up.

*Deadly · 07/07/2020, 20:42

Quick feedback, it adds those lines to any characterdataxxx supposed to be empty.

guckguck · 07/07/2020, 21:13

Quote:

Originally Posted by Isoline*

It supports more files than whats out there. It creates the files dynamically not constantly so even if you got your object IDs messed up like most server do, it will still support it and it's parent file.
It has the base for the opposite Media2DB route.
That about sums it up.

I guess it will be better to spare some time fixing the database IDs instead.
If ppl are using IDs of e.g. 800k it is their own issue and it will support "copy paste" from other clients...

Isoline* · 07/07/2020, 22:07

Quote:

Originally Posted by *Deadly

Quick feedback, it adds those lines to any characterdataxxx supposed to be empty.

Hiya, thanks for your feedback.
There was a typo in one of my queries. It's fixed now. I updated the source in the attachements.
Feel free to report / suggest anything else.

Quote:

Originally Posted by guckguck

I guess it will be better to spare some time fixing the database IDs instead.
If ppl are using IDs of e.g. 800k it is their own issue and it will support "copy paste" from other clients...

I didn't say that pserver owners messing up their IDs is okay. However, you should always design your programs to handle exteme conditions. And making it constant like mentioned above is not that flexible imo and not an acceptable approach at least by me.

iNhaLaToR · 07/07/2020, 22:28

hmm, that link is dead.. archive is broken... or is it just me?

~~WhyKillMyFox~~ · 07/08/2020, 01:29

good job

Isoline* · 07/09/2020, 02:12

Quote:

Originally Posted by iNhaLaToR

hmm, that link is dead.. archive is broken... or is it just me?

It's just you.

Quote:

Originally Posted by WhyKillMyFox

good job

Thank you.

Really guys no contribution whatsoever ? kinda making me feel disappointed...

Skedaddle! · 07/09/2020, 03:56

I've made the Media2DB as a SQL scripts long ago, it was a good idea tho.
Good Job, isoline!

Worshiper · 07/09/2020, 06:58

Quote:

Originally Posted by Skedaddle!

I've made the Media2DB as a SQL scripts long ago, it was a good idea tho.
Good Job, isoline!

Share this script

sirs1ayer · 07/09/2020, 08:51

feedback:
have a default config.ini file in project that is copied on build
if textdata folder is not created unhandled exception, check directory exists / create it before opening it