[Release] WIP on 9dragons US Server Files

[ZeroBurner]

Re: WIP on 9dragons US Server Files

Nvm, the fix is to actually upgrade to Datacenter edition or download it from pirate bay... credits go to the post below me.


[strike]if someone wants to fix that database.. restore it into EXCEL using a software example like ->

You must be registered to see links

and send me the file ... i will repair the corrupt data.

or.... i can just re build the database for the community if the community really needs that database, but this will require me using someones test server + a lot of time and effort! - Seeing how this is written in python "wtf who uses python in the gaming industry" this will be a little annoying
[/strike]

Lol, I've created that scripts to help, and I've done them in python because I like python and I script daily with that. The DB is not corrupted i've imported it and several other ppl did that before.

In any case, you are not obliged to use my stuffs and you can create things on your own.

Sent using Tapatalk on my Samsung Galaxy S3

 

[ZeroBurner]

Re: WIP on 9dragons US Server Files

Since lot of ppl have problems with the ND_HISTORY_0 database I've done a cleanup on an imported version of useless historical data, and created a new backup.

To fix the Autoconf.py problem restoring this database this is the procedure:

1) Download the file

You must be registered to see links

(around 3 mb)

2) Place it onto your c:\9dragons\db folder overwriting the existing version

3) relaunch the autoconf.py


As a side note in any case is better to use the full MSSQL rather than the express, since it have more functionalities and will avoid you problems with tables size.

Ps. doing an export to another datasource type, like the excel files you will lose all the stored procedures in the programmability section that are needed to execute the 9dragons server.
9dragons for the 99% of the times uses the stored procedures to access the database and not direct queries to the DB.

I hope it helps.

 

[ZeroBurner]

Re: WIP on 9dragons US Server Files

im getting the same error after doing this mate.

I've uploaded a new version, I forgot to update the datafile size after the cleanup... apologize for that.

You must be registered to see links

 

[Gilberto Rivera]

Re: WIP on 9dragons US Server Files

SQL SERVER 2008 R2 ------>

You must be registered to see links

 

[yasumori]

Re: WIP on 9dragons US Server Files

*Hey bro, do you know whats the use of that tool " oper_tool_german.exe "

* U still cant log a Gm character ?

*Can you tell me whats the table that contains character names or where i can rename a Character ?

BTW thanks i finally got a 9D server runing and ive running 2 more helping friends, so for all people Just read everything is here .

About changing name - check procedures in ND_GAME_0, there are few of 'em. But to see effects I needed to reset whole sv.
*tested few procedures, deleted storages, items and so more because of 1 fault xD*

anyone know how i can spawn my self items like IM weps be's etc... i know how to spawn the items from the cash shop but they have no names so i dont know which item it is

About BEs, you can get 'em from Item Mall too.

200 BE - Item Code: 2211447

 

[ZeroBurner]

Re: WIP on 9dragons US Server Files

You have to replace the IP with your VM IP (the one you've used in autoconf) and you need to insert them inside your PC, where you are going to run the client.

retry to login....

did you copied the authentication.py file?

are you using the correct client?

 

[ZeroBurner]

Re: WIP on 9dragons US Server Files

I still keep getting error From DS_Server
INIT - CS_Com: Connect Failed < Code =10049>
[INIT FAIL] Log SVR connect Failed.

how do i fix this?

This happen when your Log Server is not started or crashed, did you have a LOG_SERVER window started on your machine?

Did you start the CheckProcedues.py on your machine to fix your procedures? as described in the tutorial?

i Wanna ask this one 188 pach is the one with +17 reffinement and icy dungeon or no ? and if no can you tell where is possible to get news pach? becaus i updated my cleant i used all pach that Zero shared but still i have just +12 max reff and no icy dungeon or so...

This server is version 188, they introduced the +17 refinement (NPC options, the server already knows the +17 mechanism) in 189 if I'm nto wrong, this mean weapons +17 can exist but the server does not know how to accept the +13 ++ refinement from the client.

if you update to a version higher than 188 the game will log but a lot of NPC will stop to work.

regarding ICY dungeon it was not implemented in this version and it is not supported from the actual server, each map have configuration files and data about the instances.

Probably I will be able to make this server able to do +17 ref from the NPC, and I expect to make the server also able to run LL map, but for ICY dungeon I don't think it will be possible.
remember this is not a snap from the latest server.

atm we have to work with that.

cheers

 

[ZeroBurner]

Re: WIP on 9dragons US Server Files

why this error shows when i execute the 'create_add_user.sql'

fixed... download new version at

You must be registered to see links

Anyone got an idea why I cannot connect to a server when i type in username and pass?

what message do you receive? give more details, we will need to help you...

 

[duong383]

Re: WIP on 9dragons US Server Files

 

[ZeroBurner]

Re: WIP on 9dragons US Server Files

i found the client_GM.exe files....maybe have some founctions ....

You must be registered to see links

Interesting... I'll have a look, but a lot depends from how is compiled and btw I think some things more are needed to execute it... ty for sharing!

 

[thai0101]

Re: WIP on 9dragons US Server Files

@ for login GM, must have grant permission ...

 

[thai0101]

Re: WIP on 9dragons US Server Files

help me，how to change the character font to suport the chinese ？View attachment 141265

... this is a hint !

Ollydbg search current font name (in English)

Next replace from old font to new font .

Unpack TR_XFONT.XP

Patch new font in TR_XFONT.XP

Repack it ! ... done !

 

[soly95]

Re: WIP on 9dragons US Server Files

help me，how to change the character font to suport the chinese ？View attachment 141265

1. You got to make a new ND_TEXTDB.XSD with Chinese Translation of the game using Saweet's Tool

2. Change Your Locale to Chinease


if i got time i can help you with the TextDB, but i dont promise.

 

[thai0101]

Re: WIP on 9dragons US Server Files

1. You got to make a new ND_TEXTDB.XSD with Chinese Translation of the game using Saweet's Tool

2. Change Your Locale to Chinease


if i got time i can help you with the TextDB, but i dont promise.

wrong, bro.
in that image he's using NDTEXTDB_CN.xsd changed to NDTEXTDB_EN.xsd ...
because invalid font format !

 

[baraq]

Re: WIP on 9dragons US Server Files

seems to be an virus file

@ for login GM, must have grant permission ...

to grant permission need to edit the Character Class to 10?
becouse i got this error after i change 19 to 10,and not log the account.

 

[ZeroBurner]

Re: WIP on 9dragons US Server Files

oh then ... it's not match with server ... may be in that server files get diff with client

You changed the member_class not the GM, you have to go into the ND_GAME_0 ND_Charac table and change the GM value

 

[thai0101]

Re: WIP on 9dragons US Server Files

You changed the member_class not the GM, you have to go into the ND_GAME_0 ND_Charac table and change the GM value

member_class near "Vagabond" value !

GM Class under ".: Venus :." name !

 

[sdoch1]

Re: WIP on 9dragons US Server Files

I just replace the exe and use kr client but got that item property error and i dont know what that means.

I copy the item_table that i found inside the kr scr_base to gs\nfofile but got the same error.

2

 

[yasumori]

Re: WIP on 9dragons US Server Files

you mean i should
copy the us item_table to kr client
or
the kr client item_table to server? (<--dont work)

Copy KR client item_table to our priv client.

BTW. Can you upload that KR client or just item_table thing?

Ithink we can use Play9D's R3 TextDB and Item_Table they both based on korean file, am i wrong ?

If you still have R3 client, we can try that. I removed that 2 days ago. F...

 

[sdoch1]

Re: WIP on 9dragons US Server Files

this one is from mai 2013
kr