[Update] Customized DB2Media

[guckguck]

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.



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:



The source is updated to VS2015.

Have fun.

[XxGhostSpiriTxX]

Good thanks for shared bro!

[VORTEX*]

that's kinda nice from you to edit other work to make it useful

[guckguck]

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.

[*Deadly]

Thank you

[ByMnkn]

Originally Posted by guckguck

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

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

[White Ros3]

nice one

[guckguck]

Originally Posted by ByMnkn

Works if you leave sql_name empty

<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.

_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:

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.

[[OrO]

how to fix please

[ByMnkn]

Originally Posted by [OrO

how to fix please

<sql_name></sql_name>

and work

[[OrO]

Originally Posted by ByMnkn

<sql_name></sql_name>

and work

itry this too .. same problem

[ByMnkn]

Originally Posted by [OrO

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

[guckguck]

The SQL name is only "SQLEXPRESS" in your case, while "TAREK" being your server- (computer-) name.

[[OrO]

same problem

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

did ihave to edite them ?

[guckguck]

I forgot to attach the SDEncrypt.dll in the zip file.
Please download it one more time and try it again.