[Release] + [Tutorial] DragonNest Server

[ctyjason]

all set up successful!! but why i can't open the Modified HShield.rar

 

[hakkibulut69]

When I log in with my character, there are no channels in the list? Need help.

 

[johnnyla]

Can anyone help me with this? Idk if I'm doing it correctly... I just made a new query and entered that but I got an error.

 

[gda123123]

Can anyone help me with this? Idk if I'm doing it correctly... I just made a new query and entered that but I got an error.

simply delete the ',' which is after @inyChannelPartnerCode = NULL

 

[Muhamad NAbil]

simply delete the ',' which is after @inyChannelPartnerCode = NULL

how about this ?

3. Database
To login you have to change something in the database functions:
DNMembership
P_Login ~Line 329:
--WHERE CAST(CONVERT(char(16), @dt2Now, 121) AS smalldatetime) BETWEEN StartDate AND EndDate;
WHERE @dt2Now BETWEEN StartDate AND EndDate;

DNWorld
P_ModPeriodicReset ~Line 42:
--VALUES (@inbCharacterID, @inyPeriodicResetCode, IntPeriodicResetValue, CAST(CONVERT(char(16), @dtmServerTime, 121) AS smalldatetime));
VALUES (@inbCharacterID, @inyPeriodicResetCode, IntPeriodicResetValue, @dtmServerTime);

P_ModPeriodicReset ~Line 36:
--, LastModifyDate = CAST(CONVERT(char(16), @dtmServerTime, 121) AS smalldatetime)
, LastModifyDate = @dtmServerTime

 

[outoflove]

how about this ?

3. Database
To login you have to change something in the database functions:
DNMembership
P_Login ~Line 329:
--WHERE CAST(CONVERT(char(16), @dt2Now, 121) AS smalldatetime) BETWEEN StartDate AND EndDate;
WHERE @dt2Now BETWEEN StartDate AND EndDate;

DNWorld
P_ModPeriodicReset ~Line 42:
--VALUES (@inbCharacterID, @inyPeriodicResetCode, IntPeriodicResetValue, CAST(CONVERT(char(16), @dtmServerTime, 121) AS smalldatetime));
VALUES (@inbCharacterID, @inyPeriodicResetCode, IntPeriodicResetValue, @dtmServerTime);

P_ModPeriodicReset ~Line 36:
--, LastModifyDate = CAST(CONVERT(char(16), @dtmServerTime, 121) AS smalldatetime)
, LastModifyDate = @dtmServerTime

i think
replace
WHERE CAST(CONVERT(char(16), @dt2Now, 121) AS smalldatetime) BETWEEN StartDate AND EndDate;
with WHERE @dt2Now BETWEEN StartDate AND EndDate;

 

[rainson]

THX SO MUCH~ leechclown.

I have already succeed to start my server and enter the game.

Here are the pictures I entered the game.

Hope you all success to build your private dn server !

 

[veenzaa]

btw my character invisible.
what GM command to make it visible.
already try
hide on/off
visible/invisible

but nothing. thanks

 

[notrukpnew]

it problem

I Can't Login ?

Incorrect request

To view the content, you need to sign in or register

:*::*::*::*::*::*::*::*:

 

[Senzoku]

Thx @leechclown for the Release and Tutorial


Some question can i change the mssql username and password for the DB

 

[Mantis-]

LeechClown, i wonder DnID_20120628. cannot unpack resource folders. hmm:blush:

 

[ctyjason]

THX SO MUCH~ leechclown.

I have already succeed to start my server and enter the game.

Here are the pictures I entered the game.

Hope you all success to build your private dn server !

I want to know why you have a chinese inteface?

 

[johnnyla]

Okay thanks guys I've gotten into the game successfully. But I have a question. Let's say.. I extract the resource files from GT70 client which has 70 cap and stuff into the GameRes folder of my server, would I be able to use the GT70 client to connect to the server? Looking at the pictures from LeechClown, it looks possible but it might take a bit of work

 

[thanasitboonsom]

Can anyone help me with this? Idk if I'm doing it correctly... I just made a new query and entered that but I got an error.

USE [DNMembership]
GO


DECLARE @return_value int
EXEC @return_value = [dbo].[P_AddAccount]
@nvcAccountName = N'USERNAME',
@inyAccountLevelCode = 0,
@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

 

[Muhamad NAbil]

i think
replace
WHERE CAST(CONVERT(char(16), @dt2Now, 121) AS smalldatetime) BETWEEN StartDate AND EndDate;
with WHERE @dt2Now BETWEEN StartDate AND EndDate;

ya i know hehe ,but where to replace .that my question huhu

 

[thanasitboonsom]

After restore your database dn_database_clean.

I'm cannot connect in the database

To view the content, you need to sign in or register

How to fix it ?

 

[veenzaa]

Okay thanks guys I've gotten into the game successfully. But I have a question. Let's say.. I extract the resource files from GT70 client which has 70 cap and stuff into the GameRes folder of my server, would I be able to use the GT70 client to connect to the server? Looking at the pictures from LeechClown, it looks possible but it might take a bit of work

i already extract Ina new res (v87)but after that, when i start server. GameServer gt critical error

 

[laukinfai001]

why this help.~~

 

[Melwin]

Btw can any1 share gameres.zip please > <

 

[kennethz008]

Btw can any1 share gameres.zip please > <

i guess it is available at the last page of the first thread release.