How to make the 9dragons US Server files working.

This tutorial is something I already posted on my WIP post WIP on 9dragons US Server Files - Page 10, but
I would like to recap there since I did a lot of changes during the way and is better to keep a single entry point where I'll update this page rather than adding new posts.

Step by step guide on how to make the server working.

IMPORTANT:
This tutorial is intended to align the community with my progresses there are some open items or if you prefer things that are not working in this release

From my tests what is not working right now is:

- You cannot login any GM character (This can be caused from several factors maybe an alternate client is needed)
- You cannot drop any item to the floor from your char, I suspect this can be solved starting the maps in a certain order but I'm not really sure about that.

All the rest seems to work right now.

Disclaimer: Since I'm a really busy person :D and I'm the person who's writing this tutorial I will post only the procedure using windows server 2003 Enterprise SP2 32 bit
I'm not going to provide any link for licensed software or any cracked item You will be responsible to find everything you need on your own, I will share only free items for your convenience

I've decided to use Windows 2003 Server Enterprise SP2 32bit since I think this windows version is the more robust and reliable I've found until now.


If you want to follow my tutorial you must use the paths as I've specified or the auto-build script will not work.
In any case you are free to change everything on your own :) Everything is free here and I'm not jealous of things I'm releasing!

What do you need:
VMWARE Workstation
Windows 2003 32 bit (you can use the one with SP2 integrated)
If you are using a clean Windows 2003 you will need also the SP2, you can download it from microsoft for free (The SP not the OS) (I've added the SP also to my share)
Python 2.7 32 bit (in my share)
PyODBC for this version of python (in my share)
Apache http sever 2.0 (in my share)
Microsoft Visual C++ 2010 runtime libraries (in my share)


My share link
https://mega.co.nz/#F!cMt0GJ6Y!K5NoaSPdajh893pqarxUZg

Step 1:
Install Windows Server 2003 SP2 on a virtual machine, I'm using VMWARE since I've an ESX server at home but
you can chose whatever you want, I've tested it also on VMWARE Workstation without any problem.
I've tried on Oracle Virtual Box and IT DOES NOT WORK, at least for me....
I suggest you to create the VM with a BRIDGED network adapter, this will make things easier :)
Each Map works as a separate process, this means you will need a good machine to execute the software.
I'm using 4 cores and 16Gb of memory and the server runs correctly with all the maps.
I've not done any regression test to identify the minimum requirements, but I've successfully executed a lot of maps in a 2cores 8Gb of memory machine.
You will need around 60Gb to install everything but I suggest you to create a 100Gb disk if you have enough space.

IMPORTANT NOTE: Is mandatory to define an administrator password otherwise you will
have severe issues installing and using the Database
IMPORTANT NOTE2: You are obliged to use a static ip assignement, no DHCP, tested and is not working
IMPORTANT NOTE3: If you install Windows Server 2003 Standard you will have the 4GB limit, so is useless to give more than 4 GB of memory.

take note of the IP address you assigned to the server, you will need it.

Step 2:
Prepare the environment
REBOOT THE MACHINE EVERY TIME IS REQUESTED! Don't skip reboots or things can give you problems
remember is windows :)

Before all i suggest you to install a good text editor (like scite or Notepad++) on the virtual machine

0) If you are installing on a VM install the guest additions (like vmware tools or whatever)
1) Install SP2
2) Install Microsoft Visual C++ 2010 runtime libraries
3) Install Python 2.7.5 32 bit (install for all users with default options on c:\python27)
4) Install PyODBC (All default options, it should find automatically where to install)
5) Install Apache 2.0
In Network Domain and in Server Name put your vM Ip address
Put an Email (is not necessarely a valid email) on Admin Email address
Install for all users!
Select Custom and Change the install directory to c:\httpd
Verify you can reach the web server from a web browser

Now we need to configure apache to execute python cgi
a) Remove c:\httpd\Apache2\cgi-bin\printenv.pl
b) Remove everything in c:\httpd\Apache2\htdocs (NOT THE DIRECTORY ITSELF! ONLY THE CONTENT)
c) Edit C:\httpd\Apache2\conf\httpd.conf
Search for uncommented line: Options Indexes FollowSymLinks (if you install from the binary I posted should be row 267)
Change it to: Options Indexes FollowSymLinks ExecCGI
Search for: #AddHandler cgi-script .cgi (if you install from the binary I posted should be row 778)
Remove the # to uncomment the line and add .py to the end of the line (will become: AddHandler cgi-script .cgi .py)
Save the file
Restart apache
Start -> All Programs -> Apache HTTP Server 2.0 -> Control Apache Server -> Restart
copy the testenv.py script to c:\httpd\Apache2\cgi-bin\
Open your web browser to http://<yourvmip>/cgi-bin/testenv.py
you should see a simple web page that will demonstrate python is working and correctly configured
After that you can remove the file c:\httpd\Apache2\cgi-bin\testenv.py

6) Create an administrative account on your VM to run the MSSQL services, this will be the database owner account
I'm lazy to explain how to create it from graphical intefaces so I will guide you trough the old fashion command line style :D
Decide a password, I will reference it as yourpassword on the following lines
open a command prompt on your vm and give the following commands:

net user mssqladmin yourpassword /add
net localgroup Administrators mssqladmin /add

You should set password never expires flag for this user, to do that you can:
press start, right click on my computer click manage
click on Local users and groups
on the right pane dobule click on users
double click mssqladmin
tick password never expires
click ok

7) Install SQL Server 2008 R2 on your machine
For this phase your VM should be able to connect to the internet otherwise you will have to install your prerequisites manually (.net 3.51 and others)
This phase can require up two reboots of your virtual machine
After the setup support file is completed you will be promped for the installation type
Select SQL Server Feature Installation
Install Everything EXCEPT the Reporting Services
On the Server Configuration leave the default instance! This is mandatory or 9d will not work as well as the autoconf script.
Now the service accounts page should open, click on "Use the same account for all SQL Server services"
Insert the credentials of your mssqladmin user
click next
On the next page select Mixed Mode (SQL Server authentication and Windows Authentication)
specify a password for your sa user (you will need this password really soon :))
Click on Add current user
Click on Add -> on the box that will open write mssqladmin and click check names; click ok
Click NEXT
again, click Add current user
Click on Add -> on the box that will open write mssqladmin and click check names; click ok
click next
click next
click next
click install
wait :D

8) Create a directory on c:\ called scripts
copy the content of the scripts directory in my share inside the directory c:\scripts

9) Extract the content of the file posted on the release topic (the 9dragons server rar) to c:\9dragons on your virtual machine

10) Copy the file ND_LOG_0_backup.bak from my share to c:\9dragons\DB
Expecially if you are using SQLExpress copy the file ND_HISTORY_0_backup_2012_04_15_021519_2283750.bak on to c:\9dragons\DB replacing the old one

11) Launch the c:\script\autoconf.py script (I suggest you to do from a command prompt)
c:
cd \scripts
autoconf.py

The script will ask you for some details, provide them
1st the IP address of your db server
2nd the password you defined for the SA user on step 7

During this phase your system can become unresponsive if you try to perform other tasks!

12) Copy the file c:\scripts\lump.dat onto C:\9dragons

13) On to the directory svrctl there is a link called LOG_SERVER right click on it and do properties
change the ip at the end of the target with your vm ip address


Step 3:
Import the web content
Under My share there is a web directory
Copy the content of cgi-bin to c:\httpd\Apache2\cgi-bin
Copy the content of htdocs into c:\httpd\Apache2\htdocs
edit the file c:\httpd\Apache2\htdocs\ND1\PATCH.PSC
Change the IP address 192.168.0.211 to your VM ip address

Step 4:

Configure your client to access this 9dragons server
Extract the 9dragons client from the release in your machine (not the VM)
on your machine edit the file C:\windows\system32\drivers\etc\hosts

add the following entries (replacing 192.168.0.211 with your vm ip address)

192.168.0.211 onnetnprotect.http.internapcdn.net
192.168.0.211 nprotect.cdnetworks.net
192.168.0.211 nprotect.pb.in.th
192.168.0.211 nprotect.unbbz.com
192.168.0.211 9dragons.http.internapcdn.net

Launch the ndreg Editor contained inside the client

write your vm ip address into:
Status server
Login Server

into patch server write (replacing 192.168.0.211 with your vm ip address)
http://192.168.0.211

Step 5:
Go back to your VM and launch the script CheckProcedures.py
This script must be executed everyday, I suggest you to schedule it to be executed every midnight and everytime you login...

Go into your VM and launch the Server using the links in your c:\scripts\svrctl folder
you need to execute the scripts in the following order:

1) LOG_SERVER
2) MS
3) NDLOGIN_US
4) DS_SERVER

if you want to use it I've created a batch file that start the entire server, if you used my configuration script to install the server, and you have c:\scripts\dbauth.py you can use the batch file I'm attaching, this will allow you to start a single component or all the server components in the correct order.
To use it you need to have the dbauth.py correctly configured, and this is done by the autoconf.py
This will start the server components but not the maps, for the maps I'll post something later today
To work the script needs to be copied into your c:\scripts directory and is contained in my share under the script directory (Start9dServer.bat)




once the DS Server is started completely (it will need something like 30 seconds normally) open the DS_SERVER window
press ESC
write
set server open
press enter
(This will open the server)

Now launch the maps
There is one shortcurt for each map inside svrctl
launch at least bamboo

Step 6:

Open the client using ndlauncher
if you did everything correctly it should start to patch

You can login with any user that already exist in this db (check the Ninedragons_Accounts to find one) with the default password
On the next days I will post more info on how to change other things... like exp rate and other stuffs

Inside the scripts directory you have a changepassword script that can help a lot :)

To exit any component press esc on the window and write quit... this will close the item
if you close the first map you open everything will crash

Step 6: Additional Configurations

1) Server Rates

There is a file that is loaded everytime a map start, so if you make a change to the file you need to restart the maps that are running.
edit the file c:\9dragons\gs\nfofile\groupbonus.txt
change the multipliers for group 0 the multipliers are self explicative

2) Refine Rates

The file required to change the refine success rate is SERVER ONLY the same file is placed encrypted also on the client but for other purposes, not for the rates. the rates client side are IGNORED. let's say that if you want to change the item required to refine you need to change both the files but if you want just to change the refine rate you need to modify it just server side.

Edit the file c:\9dragons\GS\nfofile\InchantTable.TXT and...

each row represent a refine level, the first number represent the level the other two numbers the min and max success possibilities, change the min/max and you will change the success rate.

The refinement success rate is expressed in 1/1000000 (seven digits) so it goes from 0 that is 0% to 1000000 that is 100% change all the numbers to 10000000

3) Item Mall

Regarding the item mall there is a stored procedure in the database go under MSSQL Server Management, open the CIS_DB > Programmability > Stored Procedures > db.Sp_Purchase_Using right click and press execute Stored Procedure

on the user_id value you need to put the USERNAME
on cart_itemCode you need to write a valid item code
on the game_server write 0
on the item_price write what number you want, does not matter...

Click ok and you will have the item like you purchase something in 9d item mall inside your purchase history.

for a valid list of items, you can find it on c:\9dragons\gs\nfofiles\cashitempackage.txt

inside this file the first number is the valid id that you can use in the procedure, the other numbers represent info about the content. they reference to the item table and this values must match the encrypted version inside the client otherwise it will fail to deliver.

the last column is the description. if you scroll down you will found also the us items.

4) The Official Map management system

Based on the EU Release that shdoc1 has kindly signaled me I've modified the map control system to work on this server.
What you need to do:
Download the updated mapcontrol from my share


extract somewhere on your 9d VM

Let's assume you have extracted it onto c:\MAPCONTROL
To configure it you need to:
1)
edit the file c:\MAPCONTROL\Commander\env.ini
Replace the IP address with your VM ip address
2)
Copy the file c:\9dragons\env\ServerEnv.inf into c:\MAPCONTROL\Commander\
3)
Edit the file C:\MAPCONTROL\Ctrl\env.ini
Replace the IP address with your VM ip address


Now it's configured.

To use it, you need to execute first LocalServerCtl.exe from c:\MAPCONTROL\Ctrl
after is started you need to execute the LocalCommader.exe from c:\MAPCONTROL\Commander

A nice Interface will start... Click on the group 0 from the Group List
Now you can start the maps one by one or all together.

To start a single map you need to click on the Number of the map, the click is not really precise, so click the number until it become blue (Selected) then click ON on Server Command.

If you want to start all the maps (Is really CPU/Memory consuming so if you don't have a good machine you'll need to pay attention to that) you can use the group command, like all on etc etc

5) The Zero's create user stored procedure

I've created a procedure to create a user into your 9d server

copy the file into your server, double click it and when management studio loads, click on the ! to execute query.

create_add_user.sql is in my share

This will create a stored procedure you can access from: NineDragons_Account > Programmability > Stored Procedures > dbo.pr_Create_Account

Right click and Execute Stored Procedure.

This will require you to insert a username and password and will create account and password data in the various tables.

You can integrate it with any webserver, if the user already exist the procedure will obviously fail.

Making the oper_tool working require two different phases,

one to configure the DB and one to configure the oper_tool itself.

Configuring the DB:

1) Open the MSSQL server Management Studio and expand the GMS db to go into tables
2) Right click on dboLocalServerData and select edit top 200 rows
3) Select the line 1(Yang) and right click on the row, select delete
4) Do the same for row 2 (Yin)
5) click on charac_addr value (should be 10.101.102.51) to edit it
write the ip of your db server there (the VM or wherever you've installed the MSSQL)
6) Move to charac_id and write sa
7) on charac_password write your sa password (the one you have defined during mssql installation and autoconf.py)
8) Leave Charac_dbname as is
9) Move to log_addr and write the ip of your db server there (the VM or wherever you've installed the MSSQL)
10)change log_id to sa
11)change log_password to your sa password (the one you have defined during mssql installation and autoconf.py)
12) Move to ds_addr and write the ip of your db server there (the VM or wherever you've installed the MSSQL)
13) Move to ms_addr and write the ip of your db server there (the VM or wherever you've installed the MSSQL)
14) Move to history_addr and write the ip of your db server there (the VM or wherever you've installed the MSSQL)
15)Move to history_id and write sa
16) Move to history_password and write your sa password (the one you have defined during mssql installation and autoconf.py)
17) Start pressing the TAB KEY until you go to the next line and all the red exclamation marks disappears
18) Right click on dbo.UserDBData and click Edit top 200 rows
19) on address write your vm db ip address
20) on id write sa
21) on password write your password
22) press tab until your red exclamation marks does not disappear
23) edit the top 200 rows of the dbo.OPER_list table
24) search the join date value for the first row and take note on how the date is stored,
this depend on how your locale is set so will change from machine to machine
is important to take note of this format, you can also copy this value and reuse it
and reuse it for every new account you create
I suggest you to cleanup this table deleting row by row like we did on step 3 for the servers

You will need to repeat this tasks for each machine you want to enable
open the oper_tool on the machine where you want to run the gm_tool
take not of the HOST NAME exactly how is written in the Login table

25) edit the top 200 rows of the dbo.OPER_list table
26) start on the blank line and write the following values:
27) on oper_id write a username of your choice, like admin or gmbla or whatever you like, this user does not need to exist as a 9d user
28) on password write a password for this login
29) on oper_name write something like your name or whatever you want, is not important
30) on oper_nick leave the value as is (NULL)
31) on ip leave the value as is (NULL)
32) on pc_name write the hostname you noted
33) on oper_level write 1
34) on join_date write a date in the style noted on step 24

To configure the oper_tool open it
click on configuration
on DB address write the ip of your db server
on id write sa
on password write your sa password
on the DB write GMS

click apply setting

Now write the ID and PASSWORD you've created and... that's all... if you did everything correctly it should work like a charm.

enjoy it!

Thank you for good guild :)

but I have a question about this

Quote:

---

Now the service accounts page should open, click on "Use the same account for all SQL Server services"
Insert the credentials of your mssqladmin user

---

if my windows doesn't have password what would I do ?

Thank you :)

You need to have a password, if you have not defined one during the installation just define one using the windows change password

Sent using Tapatalk on my Samsung Galaxy S3

Ok,Thank you :)

Great Guide Zero. one question does the server and client work 100%? Thanks!

help , error : Gameguard xexcute error : 380

Quote:

---

Originally Posted by luvssti

Great Guide Zero. one question does the server and client work 100%? Thanks!

---

As I wrote in the tutorial, there are things that does not work 100%,
IMPORTANT:
This tutorial is intended to align the community with my progresses there are some open items or if you prefer things that are not working in this release

From my tests what is not working right now is:

- You cannot login any GM character (This can be caused from several factors maybe an alternate client is needed)
- You cannot drop any item to the floor from your char, I suspect this can be solved starting the maps in a certain order but I'm not really sure about that.

All the rest seems to work right now.

Quote:

---

Originally Posted by str8killa

you didnt have to make a new thread you allready posted this in yours

---

I did that because the WIP 3d was too much crowded and I wanted ppl not to have to look around in a lot of pages but to have everything on the first post of a new 3d.
I don't know if I did something wrong doing that, that was not my intention... if I broke any rule I ask a mod to let me know and I can remove this new 3d.
.

Quote:

---

Originally Posted by duong383

help , error : Gameguard xexcute error : 380

---

Ehm... did you modify the hosts file?

Zero can you share link from where you download sql ? this will really help for much ppl , becauos there are many ppl that download the wrong sql or so . And great job for great guid :)

Quote:

---

Originally Posted by modze99

Zero can you share link from where you download sql ? this will really help for much ppl , becauos there are many ppl that download the wrong sql or so . And great job for great guid :)

---

I'm not downloading it since I've all this software licensed, OS and SQL server, cannot do more than give you the name of versions to use, like I did.

Quote:

---

Originally Posted by zeroburner

I'm not downloading it since I've all this software licensed, OS and SQL server, cannot do more than give you the name of versions to use, like I did.

---

Ohh, okey :)

Can you please include the procedure in the ninedragons_account , ( the procedure to make accounts) because im getting problems to import the .sql file

Quote:

---

Originally Posted by Gilberto Rivera

Can you please include the procedure in the ninedragons_account , ( the procedure to make accounts) because im getting problems to import the .sql file

---

Try that...

close the SQL studio if you have it open
doubleclick the SQL file
the studio should open, login
click on the code one time
and click on the !execute

let me know.

how to do that other ppl can join my server?

I needed to change DB Name in OPER TOOL from GMS-TB to GMS, but it's working. Somehow.

Quote:

---

Originally Posted by yasumori

I needed to change DB Name in OPER TOOL from GMS-TB to GMS, but it's working. Somehow.

---

yes i had to change it to

Quote:

---

Originally Posted by modze99

yes i had to change it to

---

Absoultely right, I forgot to write it down :)

Thank you, I've corrected the tutorial.

Quote:

---

Originally Posted by yasumori

I needed to change DB Name in OPER TOOL from GMS-TB to GMS, but it's working. Somehow.

---

exactly right

i guess u have to make a clean DB called GMS-TS

http://i.imgur.com/6wG89mD.jpg

and add GM account in it

like this

http://i.imgur.com/WGGOXel.png

Quote:

---

Originally Posted by zeroburner

Absoultely right, I forgot to write it down :)

Thank you, I've corrected the tutorial.

---

So dude you have any idea how to make it that other ppl would can join in my server ?

i have problems to connect its under maintenance dont now what to do now the server seems to be working good.

Quote:

---

Originally Posted by elco

i have problems to connect its under maintenance dont now what to do now the server seems to be working good.

---

Again, in the tutorial there is the procedure to open the server.
focus on the DS window, press esc
write set server open
press enter

Quote:

---

Originally Posted by zeroburner

Again, in the tutorial there is the procedure to open the server.
focus on the DS window, press esc
write set server open
press enter

---

Quote:

---

Originally Posted by modze99

So dude you have any idea how to make it that other ppl would can join in my server ?

---

depends how expert you are with port forwarding :)
because this is what you need, open the ports and give the ppl your public IP.

Any idea if i can make it using Hamachi?

Quote:

---

Originally Posted by zeroburner

depends how expert you are with port forwarding :)
because this is what you need, open the ports and give the ppl your public IP.

---

what you mean about that ports ? that they should tell what ping they have?

Quote:

---

Originally Posted by modze99

what you mean about that ports ? that they should tell what ping they have?

---

>< ports that accepts ouuter connection to ur PC ><

and any idea how to make them ?

1. Google for it

2. Consult Your ISP

Quote:

---

Originally Posted by elco

i have problems to connect its under maintenance dont now what to do now the server seems to be working good.

---

i have that "set server open" thing else its closed thats not it
and i dont see any error on the windows and it cant be the firewall because its down.

found out the client ips where not correct

guys in what file i can set up lvl or so i cant find it ;/ ? any idea?

Quote:

---

You will need to repeat this tasks for each machine you want to enable
open the oper_tool on the machine where you want to run the gm_tool
take not of the HOST NAME exactly how is written in the Login table

---

where i find this login table?

~~
i already found it.

Quote:

---

Originally Posted by modze99

guys in what file i can set up lvl or so i cant find it ;/ ? any idea?

---

what do you mean by setup lvl?

how do I spawn mobs?

btw you can spawn +17 weaps by GM tools
;D
https://fbcdn-sphotos-f-a.akamaihd.n...41761041_o.jpg

Quote:

---

Originally Posted by baraq

how do I spawn mobs?

btw you can spawn +17 weaps by GM tools
;D
https://fbcdn-sphotos-f-a.akamaihd.n...41761041_o.jpg

---

not directly but you can spawn a +15 and obtain a +2 scroll to do that... is in item mall or you can add the item to your inventory

about spawning mobs, I think this will require the GM client, I didn't find anything to peform this task from Operator tools

IS it jsut me or is odder tools abit bugged? cant enter teh Item mall section nor can i adjust stuff on my character like adding 2nd role and so on.

Quote:

---

Originally Posted by ruffyice

IS it jsut me or is odder tools abit bugged? cant enter teh Item mall section nor can i adjust stuff on my character like adding 2nd role and so on.

---

As I already said, the operator tools, (I think you are talking about that) are developed for a different version of 9dragons, so there are things that does not work as expected, I'm working on them (together with other plenty of stuffs) If I'll be able to improve them I'll update the community, like I did for all the other things.

Ah, well atleast some stuffs works like completing quests and so on :D happy with that ^^

U've done a awesome job btw :)

Quote:

---

Originally Posted by zeroburner

not directly but you can spawn a +15 and obtain a +2 scroll to do that... is in item mall or you can add the item to your inventory

about spawning mobs, I think this will require the GM client, I didn't find anything to peform this task from Operator tools

---

How can I spawn +15 item? It's telling me - not above 12 inchant or something like that.

Somebody asked about changing level. I did that only via DB, made my own query, but idk - is it possible from OPER TOOL?

Quote:

---

Originally Posted by yasumori

How can I spawn +15 item? It's telling me - not above 12 inchant or something like that.

Somebody asked about changing level. I did that only via DB, made my own query, but idk - is it possible from OPER TOOL?

---

You cannot enchant to +15 from oper tool but only to +12 but you can spawn the item directly refined to +15 selecting the refine level

How do yolu set character's level?


iPhone 'den Tapatalk aracılığı ile gönderildi

@zeroburner

*1.Im just wondering if there is a procedure to wipe all account ( delete all accounts) and start with a clean account DB

*. Im running my server at windows 7 x32, Non Vm, and ive open the ports on router :

( ext ip:50001 --->192.168.0.2:50001 my local ip) status server
( ext ip:48300 --->192.168.0.2:48300 my local ip) login server
( ext ip:80 --->192.168.0.2:80 my local ip) web server

*Open ports at windows firewall too

*and i do a port scan test and they appear open.
* i sent a ping to my ext ip:(both ports) and is 174

but when i try to login from another pc throug internet, web server works and client how server open, but cant login just say canot conect to login server

Can you give me some hint why i cant login ...
Thanks mate

Quote:

---

Originally Posted by Gilberto Rivera

@zeroburner

*1.Im just wondering if there is a procedure to wipe all account ( delete all accounts) and start with a clean account DB

*. Im running my server at windows 7 x32, Non Vm, and ive open the ports on router :

( ext ip:50001 --->192.168.0.2:50001 my local ip) status server
( ext ip:48300 --->192.168.0.2:48300 my local ip) login server
( ext ip:80 --->192.168.0.2:80 my local ip) web server

*Open ports at windows firewall too

*and i do a port scan test and they appear open.
* i sent a ping to my ext ip:(both ports) and is 174

but when i try to login from another pc throug internet, web server works and client how server open, but cant login just say canot conect to login server

Can you give me some hint why i cant login ...
Thanks mate

---

There is not an existing procedure, I can try to make one somehow interacting with the Database...

did you open both UDP and TCP? 9dragons use a lot of udp connections....

Quote:

---

Originally Posted by zeroburner

You cannot enchant to +15 from oper tool but only to +12 but you can spawn the item directly refined to +15 selecting the refine level

---

Thanks, found it by myself a bit later. I just checked the forum.

BTW. I made short list of useful pills with NULL/empty/bad name. You can use these IDs to add pills/stack of 'em to character via OPER_TOOL.

If somewhere is written (ALL CHECK) - please check if these pills are working (exp cards & LL pills)

http://oi44.tinypic.com/qo6fsh.jpg

9d serv - pills - Pastebin.com

I've found few other, nice items like Icy banners & some funny relicts, but I lost these IDs.
I can tell only, wis/str +25 orns, banners and lv1~10 elixirs are existing there.

Quote:

---

Originally Posted by yasumori

Thanks, found it by myself a bit later. I just checked the forum.

BTW. I made short list of useful pills with NULL/empty/bad name. You can use these IDs to add pills/stack of 'em to character via OPER_TOOL.

If somewhere is written (ALL CHECK) - please check if these pills are working (exp cards & LL pills)

http://oi44.tinypic.com/qo6fsh.jpg

9d serv - pills - Pastebin.com

I've found few other, nice items like Icy banners & some funny relicts, but I lost these IDs.
I can tell only, wis/str +25 orns, banners and lv1~10 elixirs are existing there.

---

great :) thank you for sharing :)

I need somebody to make whole list of skills, since they've got too short names to recognize most of 'em (I'll post later these ones I know).

BTW. Found also leech bags:
http://oi42.tinypic.com/2hi9qo0.jpg
1st Type: 16 (Cloth2 tab)
Item ID: 20073

http://oi39.tinypic.com/o1b10.jpg
1st Type: 16 (Cloth2)
Item ID: 20476

Icy banners are PROBABLY:
1st Type: 9 (Accessories)
Item ID: 694, 695

Ornaments - 25 str, 25 wis, 100 def:
1st Type: 14 (Socket)
Item ID: 493, 494, 496

Elixirs lv.7~10 are existing in DB. For STR ND, they're just ID: 7, 8, 9, 10. 1st Type: 5 (Elixir)

If you want to have +55 elixirs (till lv10 maxed) put "2,3,4,5,6,6,6,6,7,10," w/o quotation marks ("") and DON'T DELETE last comma (,).
Attachment 141232

Put it where the red rectangle is and press EDIT.

#edit:
Effect:
http://oi41.tinypic.com/2efj8f5.jpg

And next nice relict:
http://oi39.tinypic.com/znllat.jpg

Don't have an ID now, so search by name that one.

EW pill is posted in the list.
http://oi41.tinypic.com/10zqyrq.jpg

What those 3 items does? I remember i get one from drop at G1 times.
http://i1337.photobucket.com/albums/...ps635439ac.jpg

Quote:

---

Originally Posted by korolisa2

What those 3 items does? I remember i get one from drop at G1 times.
http://i1337.photobucket.com/albums/...ps635439ac.jpg

---

They are different that these G1's. These are 25 str, 25 wis and 100 def ornaments.

anyone managed to successfully run their server with Hamachi?

Quote:

---

Originally Posted by yasumori

They are different that these G1's. These are 25 str, 25 wis and 100 def ornaments.

---

hey how you set your lvl to hi12(240) ?

Can someone explain the editing level stat etc?


iPhone 'den Tapatalk aracılığı ile gönderildi

Quote:

---

Originally Posted by modze99

hey how you set your lvl to hi12(240) ?

---

Quote:

---

Originally Posted by delicocuk

Can someone explain the editing level stat etc?


iPhone 'den Tapatalk aracılığı ile gönderildi

---

I don't know about modifying stats, but I made somehow, how to change level.

Let me turn on the SQL Serv.

Quote:

---

Originally Posted by yasumori

I don't know about modifying stats, but I made somehow, how to change level.

Let me turn on the SQL Serv.

---

Waiting bro!


iPhone 'den Tapatalk aracılığı ile gönderildi

Quote:

---

Originally Posted by delicocuk

Waiting bro!


iPhone 'den Tapatalk aracılığı ile gönderildi

---

In SQL Server click New Query:
Attachment 141241

and write something like that:

use ND_GAME_0;
select * from [dbo].[VIEW_ND_V01_CharacList] where chr_name = 'test[000000]';
update [dbo].[VIEW_ND_V01_CharacList] set inner_level = 239 where chr_name = 'test[000000]';

Where test[000000] is your char name.

Click EXECUTE. And it PROBABLY will work. I can't test it now, so just try it. You know what you can change with that, so you know what you need to fix if it fails xD

#edit: You need to make that when server (or at least character) is off.


MS Paint - level master.

Thanks alot brouther!!!

Quote:

---

Originally Posted by delicocuk

Thanks alot brouther!!!

---

Better tell us if it's working or not. IDK where I could make the mistakes.

Working bro thanksss


iPhone 'den Tapatalk aracılığı ile gönderildi

Quote:

---

Originally Posted by delicocuk

Working bro thanksss


iPhone 'den Tapatalk aracılığı ile gönderildi

---

Np. Somebody can make a stored procedure? Or wait for me when I learn how to make one.

Now one question how to dell that all users from db ? to do wipe

can someone schare a working oper_tool mine cant connect to user database

Quote:

---

Originally Posted by elco

can someone schare a working oper_tool mine cant connect to user database

---

so its seams like you did something wrong. Do you changed in cofiguration from GMS-TS to GMS?

would appreciate it if someone took time out of their busy schedules and made a screenshot or video version for all the visual learners out there. :D

Quote:

---

Originally Posted by dmangucci

would appreciate it if someone took time out of their busy schedules and made a screenshot or video version for all the visual learners out there. :D

---

It will took few hours, you really think anybody will watch how the DB is recovering? Trust me - nobody.

Zero's post is the best one. Just make it step by step. Or maybe SQL Server installation is too hard?

Quote:

---

Originally Posted by dmangucci

would appreciate it if someone took time out of their busy schedules and made a screenshot or video version for all the visual learners out there. :D

---

visual or lazy? :D

Quote:

---

Originally Posted by zeroburner

visual or lazy? :D

---

Guess lazy.

Quote:

---

Originally Posted by zeroburner

visual or lazy? :D

---

no honestly..i read the whole thing but couldn't make sense of somethings. that's why it would be better to see.. its just a suggestion though :). Your work is good:thumbup1:

Quote:

---

Originally Posted by yasumori

It will took few hours, you really think anybody will watch how the DB is recovering? Trust me - nobody.

Zero's post is the best one. Just make it step by step. Or maybe SQL Server installation is too hard?

---

i would watch it...might just be me..but if people really wanted to make the server, i dont think they would mind watching all the videos

I started up my server and yesterday i just could play..... but now it is "Checking client version" and i get " Failed to connect to an upgrade information server "

What to do ?

Quote:

---

Originally Posted by martijn464

I started up my server and yesterday i just could play..... but now it is "Checking client version" and i get " Failed to connect to an upgrade information server "

What to do ?

---

Check if your log server is still alive, as I said you should execute the checkprocedures.py every day otherwise the log server will crash and nothing will work anymore, without this component up nothing will work.

I suggest you to schedule the execution of that py every day at midnight + everytime you login.

Quote:

---

Originally Posted by zeroburner

Check if your log server is still alive, as I said you should execute the checkprocedures.py every day otherwise the log server will crash and nothing will work anymore, without this component up nothing will work.

I suggest you to schedule the execution of that py every day at midnight + everytime you login.

---

And what if i have done all this ?

I have runned the checkprocedures file 2 times now
Logserver is OK ( give no error or something )

Still not working ( still checking the client version....... )

Quote:

---

Originally Posted by martijn464

And what if i have done all this ?

I have runned the checkprocedures file 2 times now
Logserver is OK ( give no error or something )

Still not working ( still checking the client version....... )

---

You're stuck in Launcher? maybe IP change on the VM? are you able to access trough your browser?

Quote:

---

Originally Posted by zeroburner

You're stuck in Launcher? maybe IP change on the VM? are you able to access trough your browser?

---

Got it it was something with the ip yea

And i now what XD

For all you guys DO NOT INSTALL HAMACHI ON UR VM XDDDDDDD fucked up my server




Can someone tell me what relics Yasamuri have equiped on the ss he posted on page 4 of this topic

Quote:

---

Originally Posted by martijn464

Got it it was something with the ip yea

And i now what XD

For all you guys DO NOT INSTALL HAMACHI ON UR VM XDDDDDDD fucked up my server




Can someone tell me what relics Yasamuri have equiped on the ss he posted on page 4 of this topic

---

lol...

I didn't look at the SS but I'm quite sure you're talking about the GM test orb ;)

Quote:

---

Originally Posted by zeroburner

lol...

I didn't look at the SS but I'm quite sure you're talking about the GM test orb ;)

---

O.o and those things have a specific name or ?

Quote:

---

Originally Posted by martijn464

O.o and those things have a specific name or ?

---

yes... the name is GM test orb

Quote:

---

Originally Posted by martijn464

Got it it was something with the ip yea

And i now what XD

For all you guys DO NOT INSTALL HAMACHI ON UR VM XDDDDDDD fucked up my server




Can someone tell me what relics Yasamuri have equiped on the ss he posted on page 4 of this topic

---

I'm not Yasamuri, lol xD it's Yasumori. If you want, call me Adrian, Adek or Shuji, Yasu, Yasumori, whatever. But, don't, really, don't call me Yasamuri xD it sucks xD

If you want to use Hamachi as a way to make it 'public' server, you need to install it first and use Hamachi's IP, I think. I needed to turn it completely off (whole Hamachi network, even with their controller) to make the SV work.

The Test Orb is the one giving awesome amount of def, hp & ve. Its ID is:
1st Type: 9 (Accessory)
Item ID: 430

*can't login to the game to make SS of that*

H4 set MALE (note - you can make it 4slotted, same with ANY clothes, even WD def sets). To make it female, add +1 to ID (example: Jacket male 13081 -> female 13082)
-- 1st Type: 1 (Cloth) --
Jacket: 13081
Pants: 13083
WB dmg: 13085
WB ck: 13087
Boots: 13089
Hat: 13091

WD 600 def set MALE (IDK about fem, probably +5 to ID)
Jacket: ID 12226
Pants: ID 12227
-got also more from WD set - hats, boots & wbs, but they're a bit weak

PS6 set MALE (found only male Jacket & Pants - no name here) - NEED 2nd ROLE!
Jacket: ID 13517
Pants: ID 13518
Bag: ID 13519

For HH/PSH/IM/Upgraded weapons, check Weapon3 tab (1st Type: 19)
- example: Upgraded IM bracers: ID 11952
*Upgraded means similar to Heaven's from GC US*

Don't forget you can add/delete 'expires time' thing with Edit/Delete Period (right side of Inventory thing)

For lazy people:
Ornaments: 1st Type 14 (Socket)
--WARDROBE
- Dodge 130: ID 485
- Defence 100 (with no icon, Icy dungeon drop): ID 196

--WEAPON
- 10% crit PHY: ID 70
- 10% crit CK : ID 75
- 7/1k hp: ID 481 (probably the best one now)
- 25 str: ID 493
- 25 wis: ID 494

And most useful pill when you're making solo YS (IM12 epi, got one, lol, since I got bored)
- Korean Ginseng:1st Type: 3 (Potion)
Item ID: ​161

Quote:

---

Originally Posted by yasumori

I'm not Yasamuri, lol xD it's Yasumori. If you want, call me Adrian, Adek or Shuji, Yasu, Yasumori, whatever. But, don't, really, don't call me Yasamuri xD it sucks xD

If you want to use Hamachi as a way to make it 'public' server, you need to install it first and use Hamachi's IP, I think. I needed to turn it completely off (whole Hamachi network, even with their controller) to make the SV work.

The Test Orb is the one giving awesome amount of def, hp & ve. Its ID is:
1st Type: 9 (Accessory)
Item ID: 430

*can't login to the game to make SS of that*

H4 set MALE (note - you can make it 4slotted, same with ANY clothes, even WD def sets). To make it female, add +1 to ID (example: Jacket male 13081 -> female 13082)
-- 1st Type: 1 (Cloth) --
Jacket: 13081
Pants: 13083
WB dmg: 13085
WB ck: 13087
Boots: 13089
Hat: 13091

WD 600 def set MALE (IDK about fem, probably +5 to ID)
Jacket: ID 12226
Pants: ID 12227
-got also more from WD set - hats, boots & wbs, but they're a bit weak

PS6 set MALE (found only male Jacket & Pants - no name here) - NEED 2nd ROLE!
Jacket: ID 13517
Pants: ID 13518
Bag: ID 13519

For HH/PSH/IM/Upgraded weapons, check Weapon3 tab (1st Type: 19)
- example: Upgraded IM bracers: ID 11952
*Upgraded means similar to Heaven's from GC US*

Don't forget you can add/delete 'expires time' thing with Edit/Delete Period (right side of Inventory thing)

For lazy people:
Ornaments: 1st Type 14 (Socket)
--WARDROBE
- Dodge 130: ID 485
- Defence 100 (with no icon, Icy dungeon drop): ID 196

--WEAPON
- 10% crit PHY: ID 70
- 10% crit CK : ID 75
- 7/1k hp: ID 481 (probably the best one now)
- 25 str: ID 493
- 25 wis: ID 494

And most useful pill when you're making solo YS (IM12 epi, got one, lol, since I got bored)
- Korean Ginseng:1st Type: 3 (Potion)
Item ID: ​161

---

Woow thx just were searching for H4 set

Thanks yasumori !! XD

btw what is the name of the 2 bags ? 4/5 bagg

Quote:

---

Originally Posted by martijn464

Woow thx just were searching for H4 set

Thanks yasumori !! XD

btw what is the name of the 2 bags ? 4/5 bagg

---

They are Eternity bags, find 'em via Item Mall.

For Male perma bag: 2211387
For Fem perma bag: 2211388


These are most useful IM items, probably (I didn't add here Tears/Scales because I did 100% ref rate. And that was before I've got OPER TOOL)

Quote:

---

2211447 - BE (200)
2211429 - Blue Box (30+18)
2211402 - Jade Separator (5)
2211398 - +1
2211399 - +2
2211400 - Remove Scroll
2211387 - Bag (M)
2211388 - Bag (F)
2211389 - Transport (25)
2211379 - Detach (12)

---

Don't forget that these codes are for SQL Stored Procedures to Item Mall (dbo.Sp_Purchase_Using probably in CIS_DB, but I'm not sure now).

And don't make faults like me - user_id IS NOT Account nor Character Unique ID, just your login.

---
By the way,
I made my own procedure dbo._pr_CharacChangeName, but didn't notice there IS one to make it. So if you want to rename your character, just use dbo._prDSU_CheckAndChangeName in ND_GAME_0 Stored Procedures.

This does not work for me...... I cant enter any data in there.....



3) Item Mall

Regarding the item mall there is a stored procedure in the database go under MSSQL Server Management, open the CIS_DB > Programmability > Stored Procedures > db.Sp_Purchase_Using right click and press execute Stored Procedure

on the user_id value you need to put the USERNAME
on cart_itemCode you need to write a valid item code
on the game_server write 0
on the item_price write what number you want, does not matter...

Click ok and you will have the item like you purchase something in 9d item mall inside your purchase history.

for a valid list of items, you can find it on c:\9dragons\gs\nfofiles\cashitempackage.txt

inside this file the first number is the valid id that you can use in the procedure, the other numbers represent info about the content. they reference to the item table and this values must match the encrypted version inside the client otherwise it will fail to deliver.

the last column is the description. if you scroll down you will found also the us items.

Quote:

---

Originally Posted by martijn464

This does not work for me...... I cant enter any data in there.....



3) Item Mall

Regarding the item mall there is a stored procedure in the database go under MSSQL Server Management, open the CIS_DB > Programmability > Stored Procedures > db.Sp_Purchase_Using right click and press execute Stored Procedure

on the user_id value you need to put the USERNAME
on cart_itemCode you need to write a valid item code
on the game_server write 0
on the item_price write what number you want, does not matter...

Click ok and you will have the item like you purchase something in 9d item mall inside your purchase history.

for a valid list of items, you can find it on c:\9dragons\gs\nfofiles\cashitempackage.txt

inside this file the first number is the valid id that you can use in the procedure, the other numbers represent info about the content. they reference to the item table and this values must match the encrypted version inside the client otherwise it will fail to deliver.

the last column is the description. if you scroll down you will found also the us items.

---

Lol.
Press Execute:
on the right, when you can put value put:
- your login - not char name
- that number
- 0
- 0
- leave two left empty

and press OK.

I posted the most useful IDs, try to use them. If you don't know, what are you doing with IM stuff, don't use that. I crashed client twice and 1 of my characters is unable to even login

i sugest to use the snapshot funktion in vmware workstation so you can save your system before try things

Quote:

---

Originally Posted by sdoch1

i sugest to use the snapshot funktion in vmware workstation so you can save your system before try things

---

Snapshot is quite disk consuming, maybe can be easier to backup the DB (like I do ;) )

I'm actually working on a server reset py that will reset the db without any account on (maybe just one becouse one is alway needed)
but if you guys like it I can work also on a backup/restore db procedure... let me know I love to help when I can...

Zero you are life saver!!!


iPhone 'den Tapatalk aracılığı ile gönderildi

@yasumori
for full skill name you can use sawets tool
http://i.epvpimg.com/3xijh.jpg
the ID is the same in oper tool

Quote:

---

Originally Posted by sdoch1

@yasumori
for full skill name you can use sawets tool
http://i.epvpimg.com/3xijh.jpg
the ID is the same in oper tool

---

it works with item mall too

can someone help me with apache...says no services installed
installing server on pc, no vmware

error during inst
(OS 10048)Only one usage of each socket address (protocol/network address/port) is normally permitted. : make_sock: could not bind to address 0.0.0.0:80 no listening sockets available, shutting down
Unable to open logs

edit* FIXED

Can someone post a guide " how to make the server accesible throug internet " ?

Ive tryed forwarding ports and i can even see the server status ON when try to login from another pc throug internet, but cant login , im not sure if need to use the external ip when im installing the server, and maybe i need to config the server to accept external conecction from internet.

Quote:

---

Originally Posted by Gilberto Rivera

Can someone post a guide " how to make the server accesible throug internet " ?

Ive tryed forwarding ports and i can even see the server status ON when try to login from another pc throug internet, but cant login , im not sure if need to use the external ip when im installing the server, and maybe i need to config the server to accept external conecction from internet.

---

do u have static IP ?

Am stuck trying to connect to game
i have checked procedures
everything seems to run perfectly and i have configured hosts and ndreg ips
someone please help
Attachment 141332Attachment 141333Attachment 141334

Your web server is up?

Zero need help

11) Launch the c:\script\autoconf.py script (I suggest you to do from a command prompt)
c:
cd \scripts
autoconf.py

The script will ask you for some details, provide them
1st the IP address of your db server
2nd the password you defined for the SA user on step 7

During this phase your system can become unresponsive if you try to perform other tasks!

in this step

i add my IP or the SQL server name (which is My PC name ) ?

cause i get an error when excuting NDLOGIN_US

http://i.imgur.com/rWdLuY2.png

Quote:

---

Originally Posted by soly95

Zero need help

11) Launch the c:\script\autoconf.py script (I suggest you to do from a command prompt)
c:
cd \scripts
autoconf.py

The script will ask you for some details, provide them
1st the IP address of your db server
2nd the password you defined for the SA user on step 7

During this phase your system can become unresponsive if you try to perform other tasks!

in this step

i add my IP or the SQL server name (which is My PC name ) ?

cause i get an error when excuting NDLOGIN_US

---

you use your vmware ip
and the pass is what you made at the beggining..cmd msql input

Quote:

---

Originally Posted by dmangucci

you use your vmware ip
and the pass is what you made at the beggining..cmd msql input

---

well this what i get

http://i.imgur.com/2JaHHk9.png

Quote:

---

Originally Posted by zeroburner

Your web server is up?

---

yeah..i tested your testenv file and also i searched my ip on web search

took me to index

Quote:

---

Originally Posted by soly95

well this what i get

http://i.imgur.com/2JaHHk9.png

---

ok you need to find your 9dragons server file named "9dragons" and put it in C:/
the cmd is looking for DB in the server files so to reach it you need to do that

Quote:

---

Originally Posted by soly95

do u have static IP ?

---

Yes my ip is static

Quote:

---

Originally Posted by sdoch1

@yasumori
for full skill name you can use sawets tool
http://i.epvpimg.com/3xijh.jpg
the ID is the same in oper tool

---

Thanks bro, I completely forgot about XSD files!

Quote:

---

Originally Posted by dmangucci

yeah..i tested your testenv file and also i searched my ip on web search

took me to index



ok you need to find your 9dragons server file named "9dragons" and put it in C:/
the cmd is looking for DB in the server files so to reach it you need to do that

---

solved it ... the problem was that the TCP/IP wasnt enabled in the configs

failed to connect to upgrade information server!

anyone encounter problem like this? running server on pc, no vmware. any ideas on how to fix it.. everything is running perfectly

Quote:

---

Originally Posted by dmangucci

failed to connect to upgrade information server!

anyone encounter problem like this? running server on pc, no vmware. any ideas on how to fix it.. everything is running perfectly

---

re-check your ndreg.xrg

i am running on my pc, no vmware

i reinstalled server files from autoconf.py, change htdocs ip, hosts and all

still get "Failed to connect to an upgrade information server".

maybe has something to do with this "g_pDSComQueue->Int() failed"

ndreg editor
status server 192.168.1.84 status port:50001
Login server 192.168.1.84 login port: 49300
patch server http://192.168.1.84

-Forwarded my ports.
Used External ip in apache.
-Apache is working
-tested to see if python is configured, its configured.
-Set SQL up with my external IP.
-Ran autoconf.py, inputted External ip and sa pass, i typed my pass correctly.
-stuck at trying to connect to 'external ip' with the given credentials.
-Enabled TCP/IP in config still doesnt work
Note: I have set it up before using my internal ip and it worked fine but this time when using my external ip, it doesnt work.

Quote:

---

Originally Posted by mumzy111

-Forwarded my ports.
Used External ip in apache.
-Apache is working
-tested to see if python is configured, its configured.
-Set SQL up with my external IP.
-Ran autoconf.py, inputted External ip and sa pass, i typed my pass correctly.
-stuck at trying to connect to 'external ip' with the given credentials.
-Enabled TCP/IP in config still doesnt work
Note: I have set it up before using my internal ip and it worked fine but this time when using my external ip, it doesnt work.

---

I don't think this is going to work... the DB must listen to the local IP, not to the public, otherwise you'll mess up the configuration, unless you have a static public IP address...

Quote:

---

Originally Posted by zeroburner

I don't think this is going to work... the DB must listen to the local IP, not to the public, otherwise you'll mess up the configuration, unless you have a static public IP address...

---

Meh, guess i cant play it with my friends, Hamachi doesnt load the server list. ffs

when someone of you will make that your friends will can join your own server , pls post it here how did you made that i would be really thanksfull for it :)*

Were can i get that sawets tool ?
Post a download link ?


BTW; is it possible that my internet crashes when playing my server ? ( maybe i loaded to much maps ? or something, but my internet crashed an hour ago........ took my this long to set it up agin ...... )