[Guide] 80 Cap Files: 7 Classes / Tutorial / Gameres / Client / Troubleshooting

[protocolbeta]

Hi! I'm ProtocolBeta!

This guide is a (hopefully) no stupid fool proof way to set up a server. I will be covering:

-SQL Setup
-Database Setup
-Server Setup
-Webfiles Setup
-Troubleshooting

Updates

V1.0: Release

---

Server files include:

Talismen: Working
Jades: Working
BDN Normal

---

Bugs:

BDN Hardcore not working.
Cleric Getting hit is bugged. FIX (Andre YCL Provided thank them!) HERE (Place in server side: char/player/cleric
Sorceress is Bugged: FIX (Andre YCL provided thank them!) (HERE) (Place in Server side: char/player/sorceress)

---

Download for files here: CLICK ME TO DOWNLOAD
Download Client Here: CLICK ME TO DOWNLOAD

The files in "Server.zip" that you download and extract include:



DO NOT RENAME ANYTHING.

XAMMP: Webfile setup.
Dragon Nest Information Startup: Has all the passwords and commands you need.
SQL: SQL 2008 R2 SP2 and SQL Management Studio.
DNConfig: A Folder that contains what you will be hosting on your Webserver.
dn: Your server. Contains Gameres and Database files.


Included in the dn folder: Dragon Nest GM Sheet.txt which shows all the GM Commands, MAPIDs, and setjob commands.

---

Once you finish setting up the server: Click here to learn how to change the name of your server.

Once you finish setting up the server: Click here to learn how to edit the UI and translate the client!


Fixes included in these files already:

Playerleveltable.dnt fix located here

Anything else you must fix yourself.

---

Let's begin!

---

Step 0:
Minimum System Requirements:

You should be able to run server and client on same computer with:

8 GB Ram
64 bit OS (Windows)
Intel i3 Processor or equivalent.
Brains
Administrator Rights for your computer.

---

Step 1: XAMMP

Click xampp-win32-1.8.3-5-VC11-installer and run as an administrator.



Wait for it to load and click next:



Check all and click next:



Choose where to install it and hit next (I would keep normal spot):



Uncheck Bitnami and hit next:



Just hit next again.



Let it install you will get this when it finishes. Let it start if your gonna do your server now either way click finish:



You should (if you hit start now) get a control panel like this:






We will come back to that later.

---

Step 2: Webserver

Go back to your Server folder and find the DNConfig folder.





Open: C:\xampp\htdocs (or wherever you put your XAMMP installation)



Drag the folder "DNConfig into htdocs:




So the path for the file "PatchList" is: C:\xampp\htdocs\DNConfig\PatchList.xml (or wherever you installed XAMMP)






After that you're done with Webserver.

---

Step 3: SQL Setup:

Go back to your Server folder and open the SQL Folder.


Inside you see:




Double click: SQLEXPR_x64_ENU.exe and it will show it extracting the setup files.



It will load a screen like this: Hit "New installation or add features to an existing installation"



After hitting it you will be greeted with:



Check "I accept the license terms" and hit next, it will show a stetup screen then show:



Check all and hit next.



Hit next make sure to keep the name SQLExpress.



Hit "Use the same account for all SQL Server services"



It will pop up the above window. Hit Browse.







Type the account username of your computer in the "Enter the object name to select" (example my name is Beta on this test PC)

Click Check Names



Should show COMPUTERNAME-PC\USERNAME (in example mine is BETA-PC\Beta

Hit Ok



Back at this screen it should show your Account Name now. Type in your password for logging into your computer. Don't have one? Go make one.



Should look like this now. Click next.



Hit "Mixed Mode" and type in a password, it doesn't have to be the same one as your account, but remember it.

Hit next after you type a password.



Hit next again.

It will start installing.

When it's done you should get:



Then you're good. Hit close and close out of the "new installation" page it is still open too.

Next for Management studio:

Go back to your server folder and select SQLManagementStudio_x64_ENU.exe



Open it and will extract like the last one.




Hit "New installation or add features to an existing installation."

It will load a setup check then the actual setup:



Hit New installation or add shared features and then click next.



Check that you accept the terms and hit next.



Select all and hit next.



Hit next and let it install.

If all is well it should show:




After that hit close and you're done with the SQL Setup.

---

Step 4: Databases

Go back to your Server folder and find the dn folder.

Move

this folder so the path is: C:\DN



Now open SQL Management Studio and Log in.



Right click Database and hit Attach.



Hit Add



Find DN > Server > Database and select a database to attach.



Let's start with DNGSM.



Hit OK




The window will close and there is your DNGSM database.

Repeat steps for the other 4 database.




When you're done it should look like this.

Now: Go to your Server folder, and find the "Dragon Nest Information Startup.txt" document.

Open it and find:



Go back to your SQL and pull down "Security" and right click "Login."



Click New Login:



Check "SQL Server Authentication"




In Login name: DragonNest
In Password and Confirm Password: 1B63162685d441a

Continued on next post

[MentaL]

[ProtocolBeta2]

Uncheck Enforce Password Expiration and User must change password at next login.



Hit ok and you're good.

Now repeat the same steps for SPExecutor with a random password.



Now you should have a:

DragonNest user with: 1B63162685d441a as password.

and a

SPExecutor user with: any password.

Next hit New Query:




In the Query run this script:

use DNMembership
go
EXEC sp_change_users_login 'Update_One', 'DragonNest', 'DragonNest'
go


use DNWorld
go
EXEC sp_change_users_login 'Update_One', 'DragonNest', 'DragonNest'
go


use DNGSM
go
EXEC sp_change_users_login 'Update_One', 'DragonNest', 'DragonNest'
go


use DNServerLog
go
EXEC sp_change_users_login 'Update_One', 'DragonNest', 'DragonNest'
go


use DNMembership
go
EXEC sp_change_users_login 'Update_One', 'SPExecutor', 'SPExecutor'
go


use DNWorld
go
EXEC sp_change_users_login 'Update_One', 'SPExecutor', 'SPExecutor'
go


use DNGSM
go
EXEC sp_change_users_login 'Update_One', 'SPExecutor', 'SPExecutor'
go


use DNServerLog
go
EXEC sp_change_users_login 'Update_One', 'SPExecutor', 'SPExecutor'

Now click "Execute"



If successful you will get this



Now close the query and go back to your DragonNest user in your Logins.


Right click it and hit Properties.

Will show a window like this: hit server roles



It will pull up a window like this:



Check all so it looks like this:



Click User Mapping:



Check and make sure all dngsm, dnmembership, dnserverlog, dnstaging, and dnworld are checked.



Make sure everything under: Database role membership is checked also like below:



Hit Ok and close out of SQL.

If you get issues with this (like an error with Dragon Nest user, look at troubleshooting)

Click here to go to Troubleshooting!

[protocolbeta]

Step 5: ODBC Connections:

Now we need to set ODBC connections:

Go to: C:\Windows\System32\odbcad32.exe and open it.



Click System DSN



Hit Add



Click SQL Server and hit finish.



For Name it's: dngsm, dnmembership, dnserverlog, dnstaging, or dnworld. You have to do ALL 5.

For Server it's your COMPUTERNAME-PC\SQLExpress.



Hit Next



Hit Next



Change the default database to the name of the database you used as the name in the first part.

DNGSM	DNGSM
dnmembership	dnmembership
dnstaging	dnstaging
dnserverlog	dnserverlog
dnworld	dnworld

Match it like those above.

Hit Next:



Hit Finish

Hit Test data source



Should get:



Hit Ok:



It should appear on the main page. Do this again for the other 4 databases till you have:



Once you have that you're good to go for ODBC.

[ProtocolBeta2]

Step 6: Some other stuff:

One of the main issues is that the files cannot connect to the SQL server. Let's fix this.

Open up: SQL Server Configuration Manager




You will be greeted with:



Click SQL Server Network Configuration:



Right click TCP/IP and hit Enable.



Enable Named Pipes and VIA also till it shows:



Now right click TCP/IP and hit properties




Click IP Addresses and scroll all the way down to the bottom:




In TCP Port type: 1433



Hit Apply and close out.

You might need to restart your computer at this time.


=======================================


Step 7: Starting Server


Remember in Step 1 with XAMMP? Open that now




On Apache: hit Start.



Now go to your dn > server > (all your server starting files) folder in windows.




Click ServiceManager ExD and run it, click NetLauncherD and run it.





If Netlauncher shows anything but: download [http://127.0.0.1/DNConfig/PatchList.xml] then check first step again.

Now it gets complicated.

Open your Server extract folder and open Dragon Nest Information Startup.txt

Keep it open, you will need:



Open up CMD and run it as administrator also:




So now you should have open: SeviceManager, NetLauncher, XAMMP, Dragon Nest Information Startup and CMD.



Now go to Change Date and Time on your calendar

.

Click Change Date and Time settings:



Hit Change Date and Time and scroll back and set your date to 4/16/14



Hit ok and go to your ServiceManager.




Hit Start on DB Server ONLY.





Enigma will pop up. DO NOT CLICK THE WINDOW. Move to CMD





Bring up this and CMD.

In cmd copy paste:

REG DELETE "HKEY_CURRENT_USER\Software\Enigma Protector" /f

hit enter

than copy paste

del %tmp%\????????

Once you do this CMD should show:



Don't worry if del %tmp% didn't show anything afterwards, it still worked.

Now click the window and type Enigma Password window and type the password: laowangsb1314




DB server should have started.

Change your date again now to 8/1/14



Hit ok and go back to your service manager.

You no longer need CMD open either.

After changing your date go back to your Service Manager and you can now start the other services.

Each will ask for Enigma but you only have to enter the password.



Now we start Master server.



Enter password and go.



Once it shows Exit move on.



Start Village.

Enter Password:



Now an Error will appear but don't fret.



Just hit Ok and the service will start.



Now let's do Game Service:



Enter password



You will get the same error as Village, but it will start

This service takes awhile to start so just wait.



It's started now we go to Cash.



Cash doesn't require Engima Password. Start's up easy.



Now we do Login



Start it, this service doesn't have Enigma either.



It will show LogServer fail until you turn on LogService.

Now let's do that.


This service doesn't require Enigma Password Either.

Should turn on very easy, and now all your services are online!

[protocolbeta]

Step 8: Account Setup


Open SQL and Login:




Hit New Query




In Query spot type:


USE [DNMembership]
GO
DECLARE @return_value int
EXEC @return_value = [dbo].[P_AddAccount]
@nvcAccountName = N'Username',
@inyAccountLevelCode = 99,
@inyCharacterCreateLimit = 4,
@inyCharacterMaxCount = 4,
@dt2LastLoginDate = NULL,
@vchLastLoginIP = NULL,
@IntLastSessionID = NULL,
@vchJoinIP = NULL,
@inyPublisherCode = 4,
@inyGenderCode = NULL,
@DaTBirthDate = NULL,
@vchPassphrase = N'Password',
@inyNationalityCode = NULL,
@inyChannelPartnerCode = NULL
SELECT 'Return Value' = @return_value
GO


In username and password fill in what you want:

Like shown below:



Hit execute and you're done.

You should get:



Done!

---

Step 9: Client


First Extract the: "Dragon Nest Client For 80 Cap Files.zip" you downloaded.

This is a modified version of Eternal DN's client.

Look for: DragonNestStartUp.bat





Right Click and hit Edit





Yours doesn't say this but where the old IP is, place you're public IP.




You're Public ip is the one listed on your game service.

So mine would look like:




Now save and close and start you're client with this .bat.

When you start your client and log in for the first time, you may get a "disconnected from server" when you make your character. This is normal.

Sometimes when logging in you may get a "error cannot open file" click ok and it will log you in.

But it works!

No crash when start new char:



Town:







Working on formating right now

[ProtocolBeta2]

Credits:


Server Files: Released Here

Eternal DN Client: Here (I recommend their server, it's super nice!)

Guide: ProtocolBeta

Do not repost this guide anywhere but RageZone

Thank the poster if you like it!

[protocolbeta]

Troubleshooting:

I have: -problem-
Here is -solution-

First off: Check logs

Find which service is crashing and look here in the logs folder:

Will be adding fixes as problems arise.

---

Problem: I get Create Failed for User "DragonNest"

When i try to edit info for DragonNest User.

Fix: Go In each Database and hit Security > Users, right click DragonNest and Delete.

---

[Luminor]

This is a REAL GUIDE! Thx so much! I can start again with this!

[protocolbeta]

This is a REAL GUIDE! Thx so much! I can start again with this!

Welcome!

[OuTDooR]

Good tutorial, this will be good to new people that want start, Congrats!
Edit: What have that GameRes? It is Lunix GameRes?

[protocolbeta]

Good tutorial, this will be good to new people that want start, Congrats!
Edit: What have that GameRes? It is Lunix GameRes?

Custom Gameres

[mcmlxxxix]

hello thanks for this wonderfull guide, i would like to ask if you can tell me where to put Playerleveltable.dnt fix . sorry i am new in this.

thanks

[protocolbeta]

hello thanks for this wonderfull guide, i would like to ask if you can tell me where to put Playerleveltable.dnt fix . sorry i am new in this.

thanks

It's already included in the GameRes!

[Andre Ycl]

nice but are you sure all just your guide??
lol

[protocolbeta]

nice but are you sure all just your guide??
lol

Yea? It's entirely my guide.

I also did the other one: http://forum.ragezone.com/f853/7-cla...0-cap-1022667/

The files arn't mine besides my custom GameRes.

But the entire guide is mine.



It's literately done all on my own computer too.