Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

7 Classes Level 70 Cap Server Files + Database + Client + Tutorial

Status
Not open for further replies.
Junior Spellweaver
Joined
Jun 16, 2014
Messages
113
Reaction score
61
Source of Files: Here

This guide will NOT cover: SQL Setup.

First off you need:

A x64 system with at least 8GB of ram. These files do NOT support 4GB or x32 systems.


(Webfiles)
(Credits to adastmin)
(credits to keyrita1 for release, I repacked and added GameRes from Lunixx Repack 1.1)
(credits to: Lunixx for Client, jm0099 for Exe fix already added in client, uploaded by me)
(PatchList.xml webfiles made by me)


Step 1: Setup Webserver

Run XAMPP installer After it installs open up: XAMPP Control Panel. You should get a panel like this:

9dae84d399918819e6b0d346b1b04ef5 - 7 Classes Level 70 Cap Server Files + Database + Client + Tutorial - RaGEZONE Forums


Hit Start on Apache and make sure it's started all the way. Then unzip 0061.zip on to your desktop.
Then take the unzipped folder to C:\xampp\htdocs or wherever you installed XAMPP and then to htdocs.

Patch should look like this: Make sure the files shown below are in a folder named 0061 or your netlauncher won't work.

1b638abb483c0dd4319695a5211d9a5a - 7 Classes Level 70 Cap Server Files + Database + Client + Tutorial - RaGEZONE Forums



Congrats your webserver is set up.


Step 2: Server Files

Unzip Server.rar into Local Disk (C:) (Must be in C: or server won't connect correctly).

The paths of the server MUST look like: C:\Server and C:\Server\GameRes.

That's it for server for now.


Step 3: Databases

Unzip Database.zip and place the folder in your C:\Server (makes it easier to find)

Each Database must have the correct name when you restore them:


.Bak NameRestore Name
DNGSM.bakDNGSM
dnmembership.bakDNMembership
dnserverlog.bakdnserverlog
dnstaging.bakdnstaging
dnworld.bakDNWorld

To restore them:

Right Click System Databases:
a8fc89d625ad663f59a4527649c2d868 - 7 Classes Level 70 Cap Server Files + Database + Client + Tutorial - RaGEZONE Forums


Click Restore Database:

dcf1fcb7592660631543481452637774 - 7 Classes Level 70 Cap Server Files + Database + Client + Tutorial - RaGEZONE Forums


Click From Device:
a0628356a4bfebf07f5d11eb9a7ed486 - 7 Classes Level 70 Cap Server Files + Database + Client + Tutorial - RaGEZONE Forums

Click Add when this window pops up

aa5015044e2ecd7f550705ba27dde516 - 7 Classes Level 70 Cap Server Files + Database + Client + Tutorial - RaGEZONE Forums


Close excess windows till you just see C:\Server\Database

82091f82a6ad483f482e47ac3bb7f6b7 - 7 Classes Level 70 Cap Server Files + Database + Client + Tutorial - RaGEZONE Forums


Select a database to restore: Lets start with DNGSM

0096c3f73079c363ae4f72dd9d48a294 - 7 Classes Level 70 Cap Server Files + Database + Client + Tutorial - RaGEZONE Forums


Hit Ok: When you get back to the Restore Database screen, refer to the table to add the correct name. In this case the table said:
44eebb6d6335164b0edd73d902561da2 - 7 Classes Level 70 Cap Server Files + Database + Client + Tutorial - RaGEZONE Forums


So we do:

0af7c927f98e39e9f3910bbfad4798fb - 7 Classes Level 70 Cap Server Files + Database + Client + Tutorial - RaGEZONE Forums


Hit Check Mark by Restore, and OK.

594ec35d2b9a06cca09ab9e56cf37b0d - 7 Classes Level 70 Cap Server Files + Database + Client + Tutorial - RaGEZONE Forums


This should be the screen you get after hitting ok. It might take a few seconds to a minute to restore the databases. (Screenshot says DNGSM2 because i already had done DNGSM but it should say the name you typed)

Do the same process for the other 4 databases and this is what you should get in the end.

628fb0b66519f5167bb0fa1d377d1a07 - 7 Classes Level 70 Cap Server Files + Database + Client + Tutorial - RaGEZONE Forums


That's it for restoring databases: Now you must add the user.

Now with these database files a user: DragonNest is already in them, you must delete that.

On each database: DNGSM, DNMembership, dnserverlog, dnstaging, DNWorld, you must do the following.

Demonstrated with DNGSM: DNGSM > Security > User > Right Click on user DragonNest and delete.

YOU MUST DO THIS ON ALL DATABASES

4a5bf20ba9a319599f27f92fb38e32b0 - 7 Classes Level 70 Cap Server Files + Database + Client + Tutorial - RaGEZONE Forums


Next you must ADD the user DragonNest to your Security.

e8a3231b8f0bbbc46b7717027dc9368b - 7 Classes Level 70 Cap Server Files + Database + Client + Tutorial - RaGEZONE Forums


Hit New Login and add:

DragonNest3A6A7D31A8c6415

and

SPExecutor(Random Password)

Set it up exactly as this and it will work.

Do this twice for DragonNest user and SPExecutor user. Hit ok and you have made the new user.

52b25a11d2415793b5dd426e59d8d9cc - 7 Classes Level 70 Cap Server Files + Database + Client + Tutorial - RaGEZONE Forums


Next we must set the owner of the databases: DNGSM, DNMembership, dnstaging, dnserverlog and dnworld to DragonNest

Go to your newly created DragonNest login and right click and hit properties.

985c34c03f8965f0ef697b49f35ff535 - 7 Classes Level 70 Cap Server Files + Database + Client + Tutorial - RaGEZONE Forums


A new window will pop up: Don't edit anything on this screen, you are worried about: User Mapping, and Server Roles

2b33e73c76abb50296a93e28606f5799 - 7 Classes Level 70 Cap Server Files + Database + Client + Tutorial - RaGEZONE Forums


Click Server Roles: Make sure EVERYTHING is checked off as allowed.

856cecdccf2084837a4a2fbc4167eb10 - 7 Classes Level 70 Cap Server Files + Database + Client + Tutorial - RaGEZONE Forums


Next Click: User Mapping, make sure everything is checked off there as well: You must click DNGSM, DNMembership, dnserverlog, dnstaging, and DNWorld and check off each of the bottom boxes
checks.

bb1e104f70ce72a8030c616787b8669f - 7 Classes Level 70 Cap Server Files + Database + Client + Tutorial - RaGEZONE Forums


Hit ok and you're all done with that!



Step 4: Background Stuff:


A common issue that won't allow your server to work is Port 1433.

First off open: SQL Server Configuration Manager

b0a749b9bf602be3bfafa0665111fe04 - 7 Classes Level 70 Cap Server Files + Database + Client + Tutorial - RaGEZONE Forums


Should look like the image above: Click: Protocols for SQLExpress, make sure all of the items listed say ENABLED.

967b3e8f4d9ef237c6b7df77355f7edd - 7 Classes Level 70 Cap Server Files + Database + Client + Tutorial - RaGEZONE Forums


Next, right click and hit properties on TCP/IP and hit Properties, you will get a window like this:

e6c20eb8a76300c970631b0e281391f4 - 7 Classes Level 70 Cap Server Files + Database + Client + Tutorial - RaGEZONE Forums


Click IP Addresses and scroll down to: IPAll: Make sure TCP Port says 1433, if it doesn't, add it.

c7de6c660e9eda9c63af375516582cfd - 7 Classes Level 70 Cap Server Files + Database + Client + Tutorial - RaGEZONE Forums


Exit out and you are all done (Might need to restart computer because of services but not for sure)


Step 5: Setting up ODBC connections:

Go to: C:\Windows\System32\odbcad32 or in your search bar type "odbcad32.exe" and run as administrator.

29db94478c8d7802b61e8e004af755a1 - 7 Classes Level 70 Cap Server Files + Database + Client + Tutorial - RaGEZONE Forums


Click System DSN

c3a0945eca54e084e966a3dedb239c00 - 7 Classes Level 70 Cap Server Files + Database + Client + Tutorial - RaGEZONE Forums


Now you have to set up connections to each database:

You MUST know your SQLExpress log in: Usually its PC-NAME\SQLExpress.

Click Add

fb61224d7cb18080fea47bf1c3164636 - 7 Classes Level 70 Cap Server Files + Database + Client + Tutorial - RaGEZONE Forums


Click Finish on SQL Server and this window will appear:

You must do this for each database: DNGSM, DNMembership, dnstaging, dnserverlog and dnworld are the database names you use, and server is PC-NAME\SQLExpress unless you changed it.

980dc3a06bc35c67c999e0dbaa9f861b - 7 Classes Level 70 Cap Server Files + Database + Client + Tutorial - RaGEZONE Forums


Hit Next

0f6f1101e3e31ef6fee388f974eb29d4 - 7 Classes Level 70 Cap Server Files + Database + Client + Tutorial - RaGEZONE Forums


Next Again

a92088b66ab99a4a81aabfcc9306d5cd - 7 Classes Level 70 Cap Server Files + Database + Client + Tutorial - RaGEZONE Forums


On this window: Match the name of the database you named the connection to the default database

Database NameDefault Database
DNGSMDNGSM
DNMembershipDNMembership
dnserverlogdnseverlog
dnstagingdnstagin
DNWorldDNWorld

Click next when you select the matching Database.

110ca6c94ebbebd7c08f2b55a95f16f4 - 7 Classes Level 70 Cap Server Files + Database + Client + Tutorial - RaGEZONE Forums


Nothing here, click finish and Test Data Source..

7f1d6597457fa6c8f0a924ade9bf9e05 - 7 Classes Level 70 Cap Server Files + Database + Client + Tutorial - RaGEZONE Forums


Test it and hit ok if its successful. Your screen should look like this now:

51179de8acbf6830b3ecc049d5ab37f1 - 7 Classes Level 70 Cap Server Files + Database + Client + Tutorial - RaGEZONE Forums


That's the first one, repeat the steps till your screen has all 5 databases:

8b81365849d60248fb715ce502dc374e - 7 Classes Level 70 Cap Server Files + Database + Client + Tutorial - RaGEZONE Forums


That's it you're done with this part, your server is coming soon!

Step 6: Start your server!
Before you start this, extract DragonNest.rar, the client. When your server starts it would be hard for you to extract.

First off: Make Sure your webserver is on: refer to step 1 if it isn't.

Next open:
ServiceManagerExD wait till it loads and then load NetLauncherD

Things to Notice:

"All Launcher Connected"

and

"Download [

Make sure both of these things happen.


f0380d6fe7ce2a2bee6eb0ea544778b4 - 7 Classes Level 70 Cap Server Files + Database + Client + Tutorial - RaGEZONE Forums


Next SLOWLY start each server: Starting at DB: Right Click, Start.

4e03ab19b13623fcbd789876ada67c8d - 7 Classes Level 70 Cap Server Files + Database + Client + Tutorial - RaGEZONE Forums


Good Sign! Next Master

a33a13d7ca15c583ff3fbefeda723b8f - 7 Classes Level 70 Cap Server Files + Database + Client + Tutorial - RaGEZONE Forums


All Good! Next is Village! Village, game, and cash are ones you want to start slowly as they use the most resources, Don't stress if you don't get it started right away!

97d65df30cd1122eb51b8e11c902c0e1 - 7 Classes Level 70 Cap Server Files + Database + Client + Tutorial - RaGEZONE Forums



Village started! All 3 so far are green:

b80af120f9178aec9bd48e1cd1cbe930 - 7 Classes Level 70 Cap Server Files + Database + Client + Tutorial - RaGEZONE Forums


Next is Game, which may take up to 10 minutes to start. And if you have 8GB of Ram, may use up most of it, it will calm down in about 15 minutes.

f347414f379e4b7374a2e4333a51bcf9 - 7 Classes Level 70 Cap Server Files + Database + Client + Tutorial - RaGEZONE Forums


It will stay like this for a while, wait for it to look like the image below:

9d693c85b6cd62ed18db72298ba00229 - 7 Classes Level 70 Cap Server Files + Database + Client + Tutorial - RaGEZONE Forums


If it looks like that then you're all good to start up Cash! Cash also takes a little bit of time, but you can see it loading like below: This service doesnt have a ? at the end when start up but you can see it is on via Service Manager

2af2274075ecee1383cd6d0776928789 - 7 Classes Level 70 Cap Server Files + Database + Client + Tutorial - RaGEZONE Forums


It's fully loaded now so last server is Login!

b6af29fe3bb153e4396d531ce69f8882 - 7 Classes Level 70 Cap Server Files + Database + Client + Tutorial - RaGEZONE Forums



While Login is loading, it may show OldGameRes, this doesn't matter! Now that it has started up make sure all but Log are showing green lights are on in the Service Manager!

8927df1d207f13a17a8065bb6275dd2f - 7 Classes Level 70 Cap Server Files + Database + Client + Tutorial - RaGEZONE Forums


bfdf099d093042abfab8ba579fc0974c - 7 Classes Level 70 Cap Server Files + Database + Client + Tutorial - RaGEZONE Forums


Log service doesn't matter, you are all started up. Now for the client!





Step 7: Setting up client!

Go to your extracted DragonNest client and find 单机登录器.bat

Right click it and hit Edit.

ade2cb5a9b0294bb7a3517ffa85447de - 7 Classes Level 70 Cap Server Files + Database + Client + Tutorial - RaGEZONE Forums


Where it says IPHERE, take the IP from Game service you started named Public IP:

3594b7f60ff9bb82e251405fddc51663 - 7 Classes Level 70 Cap Server Files + Database + Client + Tutorial - RaGEZONE Forums


In this case the public IP would be 192.168.195.1

b54a97fabf7d4c039aa8a8906f65c877 - 7 Classes Level 70 Cap Server Files + Database + Client + Tutorial - RaGEZONE Forums


Go to file and save. Then you are done!





Step 8: Creating Account

Now you need to create an account before you open your client.

Open SQL Management Studio and login, then hit New Query.

be9916035b1a70849f0c655d73edaf01 - 7 Classes Level 70 Cap Server Files + Database + Client + Tutorial - RaGEZONE Forums



Next copy and paste in: (Credits to kennethz008


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


Fill in Username with Username, Password with Password and hit Execute

fd9fdb4a163942241fbb3993baec07d4 - 7 Classes Level 70 Cap Server Files + Database + Client + Tutorial - RaGEZONE Forums


Now you have an account! With Game Master status as well.




Step 9: Start Client!

With your edited
单机登录器.bat, double click it to start client.

All you have to do!





Extra stuff!

English Patch for Client:



Do not take this guide anywhere else but RageZone.

Created by ProtocolBeta
 

Attachments

You must be registered for see attachments list
Experienced Elementalist
Joined
Aug 13, 2007
Messages
210
Reaction score
14
who knows the merge resource
 
Junior Spellweaver
Joined
May 19, 2014
Messages
104
Reaction score
24
nice but few notes based on my experience:
there's no need to create ODBC just make sure the TCP/IP protocol is enabled.
there's no need to check all those boxes from the Server Roles, "public" and "sysadmin" are enough.
there's no need to check all those boxes from User Mapping, just leaving the "public" checked is enough.
database login "DragonNest" password depends on the server executable version.

bugs based on my experience:
level mismatch in-game vs char screen (fixed thanks to SePhII2oth from this thread: http://forum.ragezone.com/f853/recopilation-fixes-1020176/)
skill points rollback after clicking Apply (due to level mismatch)
some quest not working (Gameres/.pak or level mismatch)
unknown item names (missing entry from uistring.xml in .pak file)

and now we need better pak editor, if anyone know please share.
 
Last edited:
Junior Spellweaver
Joined
Aug 17, 2014
Messages
138
Reaction score
7
DNDB keeps crashing, and never lights green.
The only one that lights green is Master.
 
Junior Spellweaver
Joined
Aug 17, 2014
Messages
138
Reaction score
7
How do I post it?
I have several that are really long.

Here are links to log (Sorry don't know how to use forum):
DNDB:
CashServer:
Gameserver:
 
Last edited:
Junior Spellweaver
Joined
Jun 16, 2014
Messages
113
Reaction score
61
How do I post it?
I have several that are really long.

Here are links to log (Sorry don't know how to use forum):
DNDB:
CashServer:
Gameserver:


Main issue is this: '23:59:44' SQLError #SQLDriveConnect # (08001) 17, [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied.

'23:59:44' Not Connect MembershipDB Ip:127.0.0.1 Port:1433 DBName:DNMembership DBID:DragonNest


'23:59:51' SQLError #SQLDriveConnect # (08001) 17, [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied.


'23:59:51' Not Connect MembershipDB Ip:127.0.0.1 Port:1433 DBName:DNMembership DBID:DragonNest


'23:59:58' SQLError #SQLDriveConnect # (08001) 17, [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied.


'23:59:58' Not Connect MembershipDB Ip:127.0.0.1 Port:1433 DBName:DNMembership DBID:DragonNest

Check Step 4
 
Newbie Spellweaver
Joined
Jul 25, 2014
Messages
12
Reaction score
0
srry for this, how to make a step 3?, i don't know how, pls help me, im just make a test server for my builds its all, thanks, i have the files in C:\Server, so what next?
 
Last edited:
Newbie Spellweaver
Joined
Jul 25, 2014
Messages
12
Reaction score
0
as I do step 3? anyone can help me?
 
Last edited:
Junior Spellweaver
Joined
Aug 17, 2014
Messages
138
Reaction score
7
In step for on IPAII do i need to set the TCP Dynamic ports to the same as yours? Currently mine are at 0.
But I also did not restart my pc so i'm going to try that now.
 
Status
Not open for further replies.
Back
Top