[Update] Customized DB2Media

Page 1 of 2 1 2
03/25/2020 16:59 guckguck#1
Hello everyone,

Recently I was searching for an automated textdata generator to use it with other tools. I saw that the “DB2Media” converter released by JustNrik seems to do a good job, but I found some issues while using it and created a more flexible version.

[Only registered and activated users can see links. Click Here To Register...]

New features:
- output filenames are configurable by XML (see files.xml)
- option to close the window after completing automatically
- option to use an absolute foldername, if you want to generate the files in a different location
- option to autodelete "skilldata" files if you are using vsro
- option to autodelete "skilldataenc" files if you are not using vsro
- option to partially generate files (see files.xml)
- If you start the tool after autogenerating the XML files it will ask for connection details
- removed the watermark from output files and added a delay to show JustNrik's name

Bugfix:
- The tool will ping on your target before connecting with SQL
- If you do not have an output folder the tool will not automatically close anymore
- Fixed filenames to match vsro (you can edit them anyway)
- standard "username" and "password" is changed to "0815" to enable external XML handling (seems to be tricky with empty entries)

Usage:
- You can execute the exe anywhere, it will autogenerate config files.
- The tool will ask for your login details on the 2nd startup
- It will run automatically, if you were able to connect to the SQL server.

While using this tool I discovered some issues in my own database. You might not be able to use the autogenerated textfiles before fixing all the issues by hand. I'll recommend to copy the files one by one in your media.pk2 and run a complete login (spawn your char too...). Then continue with the next file.

Example of "bugs":
- Generated a <crlf> at the end of a bsr link in chardata
- Chardata did not match to worldmapguide, disabled entries in DB
- Skilldata files messed up

Virustotal Link:
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]

The source is updated to VS2015.

Have fun.
03/25/2020 17:46 XxGhostSpiriTxX#2
Good thanks for shared bro!
03/26/2020 07:14 VORTEX*#3
that's kinda nice from you to edit other work to make it useful
03/26/2020 15:07 guckguck#4
Small update:
- changed standard entries for username/password to "0815"

It is not possible to "update" empty XML entries if you use an external tool. Thus it is easier to use some kind of dummy entry.
03/26/2020 18:36 *Deadly#5
Thank you
04/01/2020 05:58 ByMnkn#6
Quote:
Originally Posted by guckguck View Post
Small update:
- changed standard entries for username/password to "0815"

It is not possible to "update" empty XML entries if you use an external tool. Thus it is easier to use some kind of dummy entry.
Works if you leave sql_name empty

Code:
<server_name>BYMNKN</server_name>
<sql_name></sql_name>
<database>SRO_VT_SHARD</database>
<username>sa</username>
<password>123</password>
04/01/2020 10:02 White Ros3#7
nice one
04/01/2020 17:13 guckguck#8
Quote:
Originally Posted by ByMnkn View Post
Works if you leave sql_name empty

Code:
<server_name>BYMNKN</server_name>
<sql_name></sql_name>
<database>SRO_VT_SHARD</database>
<username>sa</username>
<password>123</password>
If you are using an external function call like below, you cannot leave it blank. The "XML update" function is failing on empty entries. Ofc. you could add an entry like "if empty then code else other code" but this is complicated with autoit's XML API, because you would need additional functions for writing into an empty entry.

Code:
_XML_UpdateField($oXMLDoc_config, "config/sqlconfig/password", $sql_pass_name)
I do not call this program from the explorer window. There is a button in my DB adjusting tool, that is creating required media files on request. The XML file will be generated prior execution to support partial downloading and options. There is even a backup routine, because the program is using the SMC patch folder directly:

Code:
1: Open XML file
2: Update entries according to user selection
3: Write XML file
4: Run zip backup
5: Call the "DB2Media" tool
Btw. I tried to leve the SQL name blank and it did not connect. Maybe it is trying to use a default SQL server in your case, if there is only one valid selection.
04/28/2020 20:10 [OrO#9
how to fix please

[Only registered and activated users can see links. Click Here To Register...]

[Only registered and activated users can see links. Click Here To Register...]
04/29/2020 05:45 ByMnkn#10
Quote:
Originally Posted by [OrO View Post
how to fix please

[Only registered and activated users can see links. Click Here To Register...]

[Only registered and activated users can see links. Click Here To Register...]

<sql_name></sql_name>

and work
04/29/2020 07:03 [OrO#11
Quote:
Originally Posted by ByMnkn View Post
<sql_name></sql_name>

and work
itry this too .. same problem
04/29/2020 13:04 ByMnkn#12
Quote:
Originally Posted by [OrO View Post
itry this too .. same problem

<server_name>BYMNKN</server_name>
<sql_name></sql_name>
<database>SRO_VT_SHARD</database>
<username>sa</username>
<password>123</password>

try

server_name
username
password

edit
04/29/2020 14:44 guckguck#13
The SQL name is only "SQLEXPRESS" in your case, while "TAREK" being your server- (computer-) name.
04/29/2020 18:32 [OrO#14
same problem [Only registered and activated users can see links. Click Here To Register...]

what i do with <folder>\Patch_Internal\media\server_dep\silkroad\ textdata</folder>
<folder2>C:\Textdata</folder2>

did ihave to edite them ?
04/29/2020 21:28 guckguck#15
I forgot to attach the SDEncrypt.dll in the zip file.
Please download it one more time and try it again.
Page 1 of 2 1 2