[Open-Source] DB2Media <-> Media2DB Converter

07/07/2020 08:05 Isoline*#1
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 :handsdown:)
  • Credits goes to to SUPERKHUNG from gamevn for the skilldata encryption-decryption a while back.



Contribution:
  • Chardata issue caused by a typo in its query fixed, reported by @[Only registered and activated users can see links. Click Here To Register...] - Source code in attachements has been updated to v1.1
07/07/2020 10:53 @Grayson#2
good work
07/07/2020 12:03 ! Split#3
g.j keep it up
07/07/2020 17:30 Worshiper#4
Nice work
07/07/2020 19:48 guckguck#5
Could you please add to your description what kind of pro and cons this tool offers compared to the "old one": [Only registered and activated users can see links. Click Here To Register...]

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.
07/07/2020 20:24 Isoline*#6
Quote:
Originally Posted by guckguck View Post
Could you please add to your description what kind of pro and cons this tool offers compared to the "old one": [Only registered and activated users can see links. Click Here To Register...]

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.
07/07/2020 20:42 *Deadly#7
Quick feedback, it adds those lines to any characterdataxxx supposed to be empty.
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]
07/07/2020 21:13 guckguck#8
Quote:
Originally Posted by Isoline* View Post
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...
07/07/2020 22:07 Isoline*#9
Quote:
Originally Posted by *Deadly View Post
Quick feedback, it adds those lines to any characterdataxxx supposed to be empty.
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]
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 View Post
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.
07/07/2020 22:28 iNhaLaToR#10
hmm, that link is dead.. archive is broken... or is it just me?
07/08/2020 01:29 WhyKillMyFox#11
good job
07/09/2020 02:12 Isoline*#12
Quote:
Originally Posted by iNhaLaToR View Post
hmm, that link is dead.. archive is broken... or is it just me?
It's just you.
Quote:
Originally Posted by WhyKillMyFox View Post
good job
Thank you.


Really guys no contribution whatsoever ? kinda making me feel disappointed...
07/09/2020 03:56 Skedaddle!#13
I've made the Media2DB as a SQL scripts long ago, it was a good idea tho.
Good Job, isoline! :kappa:
07/09/2020 06:58 Worshiper#14
Quote:
Originally Posted by Skedaddle! View Post
I've made the Media2DB as a SQL scripts long ago, it was a good idea tho.
Good Job, isoline! :kappa:
Share this script :)
07/09/2020 08:51 sirs1ayer#15
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