[RELEASE] 9Dragons XSD Editor

9Dragons XSD Editor is a program for modifying XSD files for 9Dragons. The XSD files typically used for 9Dragons are the NDTEXTDB*.XSD files in the datascript directory of your 9Dragons installation directory. This program is an editor, not a translator, however it can be used like a translator. This program is NOT for complete idiots, if you don't know what the NDTEXTDB is, don't waste your time!

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

Usage

Creating an XSD

This is for experienced users who are familiar with XSD files. There is little point in creating an XSD from scratch, but the point here is that you can.

1. Click the Add button and type in the new table name
2. Make sure your table is selected in the table list
3. In the rows list on the right, there is a row with an * at the beginning. This is for entering new rows
4. Type in an ID and name, then drill down or press enter to add the row. To cancel press ESC
5. Click Save from the menu or toolbar

Modify an existing XSD

1. Click Open and select an XSD file
2. Select a table from the list on the left
3. Rows from that table are populated in the list on the right
4. To edit a row, select the column cell and begin typing to overwrite, or click the column cell so it is highlighted then click it again to enter edit mode
5. To delete a row, click the > button to the left of the row, the entire row will become highlighted, now press the delete key
6. To create a table, click the Add button, type in the table name
7. To edit a table, select the table and click the Edit... button
8. To delete a table, select the table and click the Delete button
9. Click Save from the menu or toolbar to overwrite the file. Click Save As under the File menu to save to a new file

Merging two XSDs

1. Open the XSD you want to merge into
2. Click the Merge drop down button on the toolbar, select a merging option
3. Browse to the XSD file you want to merge into the currently open XSD, click Open
4. Click Save or Save As to save the merged file if it completed successfully

Merging Types
Matching Only - This merging type will merge tables and rows only when matching identifiers are found in both files. All others are ignored. This is the safest, most stable, and currently the only option.

For Translating

One useful feature of the editor is that you can use it to translate an XSD from one language into another language. This can be accomplished in two different ways, manually editing by hand, or by merging an XSD that is in the language you want.

1. Open the XSD you want to translate (ie: NDTEXTDB_CN.XSD)
2. Click the Merge drop down button on the toolbar, select a merging option
3. Browse to the XSD file that is in your desired language (ie: NDTEXTDB_US.XSD)
4. Click Save or Save As to save the merged file if it completed successfully

What happens above is that tables and rows are merged (depending on the merging type chosen) from the NDTEXTDB_US.XSD file and into the NDTEXTDB_CN.XSD.

Reporting Bugs
Please do not report bugs in this thread. Instead, send me a Private Message with a description of the bug. Please do not Private Message with installation and/or usage issues.

Some features may not work correctly and undesired behavior may occur. Read the DISCLAIMER at the bottom before downloading! Do not download this program or any imitation of it from any site other than the download link in this post.

Disclaimer

Installation

1. Download and extract the file
2. Run the NineDragons XSD Editor

I put a lot of effort into this program, please click the * Thanks button down below if you found this useful. Thank you and enjoy!

Hello?

OMG! Thank you. Gonna check it out right NOW!


Edit: At last it works!! Thanks again. ;)

so this can work for the NDTEXTDB_CN.XSD of DDO?

illidank : Yeah.

Oh, I see. I'll try to translate for Polish naabies our XSD files! Gogo to create all-language translations for 9D :D

Quote:

Originally Posted by illidank so this can work for the NDTEXTDB_CN.XSD of DDO?

There is one gotcha. Some NDTEXTDB's use different table names, in order to merge with another XSD they must have the same table names. For example, the NDTEXTDB_CN for DDO uses MobModel.XMS and Skill_Table.xls, whereas another XSD might use MobModel_XMS and Skill_Table, because they are different these tables will not merge. The solution is to make a copy of your XSD, load it up and Edit the table names to match, save, and then merge. Hope that helps!

Quote:

Originally Posted by adek1994 Oh, I see. I'll try to translate for Polish naabies our XSD files! Gogo to create all-language translations for 9D :D

I started to translate to lithuanian long time ago. In fact there was not only me who was traslating. There were 5 of us. But still we just traslated more than half mobs, lots of EODs, all mastery, just a little piece of items and none of quests. We have done that in 7 month. And yeah. We werent serious about publishing it. It was just fun. :] Btw anyone knows why lithuanian letters transforms into '?' in-game?

Quote:

Originally Posted by taiezys I started to translate to lithuanian long time ago. In fact there was not only me who was traslating. There were 5 of us. But still we just traslated more than half mobs, lots of EODs, all mastery, just a little piece of items and none of quests. We have done that in 7 month. And yeah. We werent serious about publishing it. It was just fun. :] Btw anyone knows why lithuanian letters transforms into '?' in-game?

if you want to see lithuanian letters in your game , you must change your system locale to Lithuanian . On windows 7 you can do that by going to Control Panel -> Region and language -> Administrative -> Change system locale and choose Lithuanian from the list. you have to restart ur PC afterwards. If your game wont work anymore and the folder in which u installed the game has chinese letters you must rename it to something else ...like DDO( i had this problem beacause i kept the original folder name) . Good luck :)

Quote:

Originally Posted by djsysulica if you want to see lithuanian letters in your game , you must change your system locale to Lithuanian . On windows 7 you can do that by going to Control Panel -> Region and language -> Administrative -> Change system locale and choose Lithuanian from the list. you have to restart ur PC afterwards. If your game wont work anymore and the folder in which u installed the game has chinese letters you must rename it to something else ...like DDO( i had this problem beacause i kept the original folder name) . Good luck :)

No. It somehow automaticaly generates lithuanian symbol to '?'. Its not with my PC settings. But still thanks.

If anyone succeeds making/traslating atleast skills and stats.. PLS share =D

Quote:

Originally Posted by taiezys No. It somehow automaticaly generates lithuanian symbol to '?'. Its not with my PC settings. But still thanks.

My PC`s system locale was set to English by default...And when i was using the chinese ndtextdb all i saw was ???? everywhere ...So i changed the system locale to Chinese and now i can see all the chinese characters like they should look like...I just thought it might work the same in your case :)

Quote:

Originally Posted by djsysulica My PC`s system locale was set to English by default...And when i was using the chinese ndtextdb all i saw was ???? everywhere ...So i changed the system locale to Chinese and now i can see all the chinese characters like they should look like...I just thought it might work the same in your case :)

Well yeah. But when I tried to put my traslation to acclaim (I said that traslation is old) it automaticaly trasforms to similar symbol. Like ė traslates to e. So I think every 9D ver has its symbols restriction. But that restriction is not in .XSD script I think its somewhere else.

Quote:

Originally Posted by aljaz94 If anyone succeeds making/traslating atleast skills and stats.. PLS share =D

lol, are you srsly? Havent you red saweet tutorial? If you are to lasy or to stupid just say it then I will upload new XSD special for you.

I started it today, and I'm at ID 401 of mobs. I think I'll end translate my PL XSD file at half of October... or faster, if I'll get some help. All epvpers help each other, and create new topic with FULL translates :P

Quote:

Originally Posted by taiezys lol, are you srsly? Havent you red saweet tutorial? If you are to lasy or to stupid just say it then I will upload new XSD special for you.

yes. i am serious. and not stupid or lasy. some people just dont have the time to do it so yes...i would appreciate if u upload it.