[Release] WIP on 9dragons US Server Files

[ZeroBurner]

I think the ninedragons_GM he compiled is not suitable for this version... but... who knows :)

Some more details:

How to change the 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

I've uploaded a new version of the autoconf.py, since in the first version there were some line commented by mistake... you will need the new version to restore the full database if you already downloaded it, please redownload.

[ZeroBurner]

I've to ask billion of times sorry but there is an error on my tutorial, i was sure i had modified this part but is not the case.

On the step 7 you need to create the default instance not a named on or autoconf and 9d servers will not work . If you already installed a named instance look on google, you have two possibilities, or you add a new instance as a default one and you remove the previous or you change the instanve port from dynamical to static and to listen on the default port. Apologize for the inconvenience

Inviato dal mio GT-I9300 utilizzando Tapatalk

[ZeroBurner]

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

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.

I hope it helps.

regarding my skype, I'll like to be 100% honest with you; I'm a really busy person, since I work for a big company as an IT solution architect and I don't like to use it, since I've not a lot of time and I tend to spend my free time with my kids, so you can add me on skype (zeroburner) but I doubt you will find me online often...

HnD
Zero

[sdoch1]

i upload it on zippyshare

server

Spoiler:

9Dragons.7z.001
9Dragons.7z.002
9Dragons.7z.003
9Dragons.7z.004
9Dragons.7z.005
9Dragons.7z.006
9Dragons.7z.007
9Dragons.7z.008
9Dragons.7z.009
9Dragons.7z.010
9Dragons.7z.011
9Dragons.7z.012

client

Spoiler:

9Dragons2.7z.001
9Dragons2.7z.002
9Dragons2.7z.003
9Dragons2.7z.004
9Dragons2.7z.005

awesome work zeroburner
you are my hero :D

[ZeroBurner]

yes thank you maybe should say it
zippyshare alow only 200 mb so i split it
and i have 7zip installed so i use it instead of winrar

this guide is awesome ^^
just managed to log in
its hard for someone who dont know anything in sql to find out some acc
found gm venus but game crashes when i try to log in

there is the management tool in the other release (gc germany), i tried to log in to the db but its not working

can you tell me more about this management tool and the release gc germany? I don't know anything about it, give me more details, maybe I can make it working :)

btw, here attached a user list from this release https://www.dropbox.com/s/b7s030unpca2cs9/users.txt

[sdoch1]

this one
http://forum.ragezone.com/f111/wip-9...3/#post7822651
is inside here
http://forum.ragezone.com/f111/9dragons-eu-967563/
the oper tool de ts folder

i uploaded the folder only
OPER_TOOL_DE_TS.7z

would be much easyer to config with this i think

thanks for the user list ^^
my acc isnt there (dont even know if i had one at that time lol)

[ZeroBurner]

*UPDATE 1*
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

https://www.dropbox.com/s/fjoxwbc8mr...rt9dServer.bat

*UPDATE 2*
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
https://www.dropbox.com/s/wuv9pfnr9c...MAPCONTROL.zip

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

more updates are coming ;)

[Gilberto Rivera]

*UPDATE 1*
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

https://www.dropbox.com/s/fjoxwbc8mr...rt9dServer.bat

*UPDATE 2*
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
https://www.dropbox.com/s/wuv9pfnr9c...MAPCONTROL.zip

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

more updates are coming ;)

Do you know how to send [Server Notice] , there is a command "msg" but dunno why when i use that command says "unknow comand or so".
im also looking on the DB tables to find a way to create new accounts and Gm accounts, and be able to log a gm character.

Again thanks for all :)

[ZeroBurner]

if you install the server following the guide that zeroburner posted, when you run the script " autoconf.py " it automatically change all the passwords of all accounts (it also restore the DB`s and make other things)in the DB to 9d123 , but if you want to use a different password you just need to edit the script with notepad and replace 9d123 for your desired password. obviously do that before run the script.

Almost correct... the Ninedragons_Accounts DB does not contain any info about the passwords, so the autoconf.py is creating a new table and populating it with the passwords.
All the rest is correct, you can change the default password or use the changepass.py to change the password of a specific user.

Now I would like to modify the stored procedure that create a new user to create also the entry on the other table.
Please be patient... I've a lot of stuffs to do and few time to do it.

[Gilberto Rivera]

Almost correct... the Ninedragons_Accounts DB does not contain any info about the passwords, so the autoconf.py is creating a new table and populating it with the passwords.
All the rest is correct, you can change the default password or use the changepass.py to change the password of a specific user.

Now I would like to modify the stored procedure that create a new user to create also the entry on the other table.
Please be patient... I've a lot of stuffs to do and few time to do it.

So that procedure just make a new account but dont store passwords, so you want to modify and that procedure ill write at the new table that store the changed passwords.

Btw im interested on that crypter/decrypter that u was coding, because there is some files that can be decrypted by 9dEncTool.exe and the other sh1t cant remember the name.

So we can customize even the quest and rewards and item table to remove useles things.

[ZeroBurner]

So that procedure just make a new account but dont store passwords, so you want to modify and that procedure ill write at the new table that store the changed passwords.

Btw im interested on that crypter/decrypter that u was coding, because there is some files that can be decrypted by 9dEncTool.exe and the other sh1t cant remember the name.

So we can customize even the quest and rewards and item table to remove useles things.

Simply because a lot of them are not encrypted but they are ascii databases created with a really old but stable methodology, file databases created with a specific structure that needs to be read and parsed with binary methods char by char... not easy as you can think believe me...

[ZeroBurner]

A new update

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.

https://www.dropbox.com/s/qzunjvqaow...e_add_user.sql

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.

I hope it helps some of you :)

help. im setup is step 11
c:
cd \scripts
autoconf.py
192.168.0.211 ( my ip)
pas 123456

resus :
attempt number 1 failed
attempt number 2 failed the scripts is not connect to able to database

Most probably you created a named instance and not a default instance, or your password is wrong... did you install the MSSQL server? is MSSQL 2008 R2?

i need help to in step 11 ... is there are any other way to make it becaus when i doing this it say ( autoconf.py is not recognized as an internal or extrenal command, operable program or batch file ) ir any idea what need ?

Did you follow the previous steps? Installing python etc etc?
Did you copy the necessary things on your machine?

did you launch the script from the correct directory? you have to do cmd
on the prompt write
c:
cd \scripts
autoconf.py

[yasumori]

I need to use my default gateway ip ? right ?

And i am not getting this... ( i dont get the webpage. .... ) Is it vital ?


Step 6
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

You should get:


like me. If won't - probably your Apache server isn't working correctly.

I got one question. I want to do it not on my VM, but on local, standalone OS. In step7, I still need to use 'mssqladmin' account or just my 'normal' Admin account?

[ZeroBurner]

You should get:


like me. If won't - probably your Apache server isn't working correctly.

I got one question. I want to do it not on my VM, but on local, standalone OS. In step7, I still need to use 'mssqladmin' account or just my 'normal' Admin account?

You are not obliged to use it, but is a best practicse to use a dedicated account since if you change the password for your admin you will not have to update your services in this way.

I'm almost sure you are using SQL Server via these .py files with config and to connect with DB when login into game.

Absolutely correct, my autoconf.py is doing the db configuration, importing the db backups, creating the missing tables and normalizing the user passwords, the authentication.py is connecting to the db to check the auth. those are py's not pyc so you can see the code inside, there is nothing hidden :)

Well my apache server isnt working then............ weard

But in the tutorial you posted zeroburner you install sql server 2008 R2 and stuff but you dont use it ? ?


9) Extract the content of the file posted on the release topic (the 9dragons server rar) to c:\9dragons on your virtual machine
can i do step 9 to ? cause i downloaded all the files Sdoch1 posted..... but it doesnt have any files in it our something ? ( i packed it with 7-zip file manager but now it only is a packed winrar file....... )

Someone help me. XD *( i am such a noob,,,,,,but i want my own server )

Thx

Keep hard, everyone was a noob at the beginning... also me :D (long time ago, I'm old now ;)) Did you restart apache btw? Do you follow the configuration as I explained? what error did you encounter?

Regarding the files kindly posted from sdoch1, those are equivalent to the rar in the release, just extract t them all in a folder called c:\9dragons in your vm and it will work.

[ZeroBurner]

don't found the dbauth.py，who can share it。thankyou

The dbauth.py is created on the server when the execution of the autoconf.py is completed.

Inviato dal mio GT-I9300 utilizzando Tapatalk

Followed all the steps from the guide and i am still stuck at step 11 even after reinstalling vm 3 times, it keeps giving me the same error.

------------------------------------------------------------------------
(Error)

attempt number 1 failed!
attempt number 2 failed! The scripts is not able to connect to the database maybe you provided the wrong credentials

The IP i inputted is according to my ip in ipconfig.
As for my password i have already checked it and was also able to login to the management studio with it.
So it should not be the password problem..
------------------------------------------------------------------------

And also some other problems that i dun understand
------------------------------------------------------------------------
(Problem 1)

Could you help me check if i downloaded the correct version of sql server 2008? I downloaded this: SQLEXPRADV_x86_ENU.exe from
Download Microsoft® SQL Server® 2008 R2 SP2 - Express Edition from Official Microsoft Download Center
------------------------------------------------------------------------
(Problem 2)

The no dhcp thing that you typed out on your guide which i dun understand

IMPORTANT NOTE2: You are obliged to use a static ip assignement, no DHCP, tested and is not working

Do i need to disable it? Do i disable it at administrative tools/services? if not what should i do?
------------------------------------------------------------------------
Hope you can help me out and i have to sleep already 7am here >.<
Thanks.

You messed up with the ip addresses for sure. You have to insert your vm ip on the autoconf, not the ip of your physical machine.

When i state to use static ip this mean not to use an automatically assigned ip and not to disable a service.

Inviato dal mio GT-I9300 utilizzando Tapatalk