[Release] + [Tutorial] DragonNest Server

[Senzoku]

Can we use this server file for make 70cap (by use GameRes from 70Cap)

 

[Melwin]

I got DNDBServer64_DE crash problem.

How can I fix this > <

 

[OutOfMemory]

An excellent release, MentaL has been notified, and if you guys keep up the good work, I see a new section for DragonNest coming soon.

Good job guys, almost had to delete no posts in this thread of people breaking rules.

You guys should reward this guy really with something he really was not selfish and helped us with his release.

 

[outoflove]

I got DNDBServer64_DE crash problem.

How can I fix 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

 

[Twisted Fate]

You guys should reward this guy really with something he really was not selfish and helped us with his release.

We can not afford to give everyone with a release on RZ (which are LOTS) something. However if people want to reward him something, they can use the like button, give him some positive rep, or even gift him a subscription.

 

[TriEdge]

getting same error as laukinfai001, just translated

same :/ btw can you give me your english patch ?

 

[Melwin]

A new problem > <

 

[ashlay]

A new problem > <

you don't need to change nothing on db just use this query if you cant create a account.

USE [DNMembership]
GO

DECLARE    [USER=850422]return[/USER]_value int,
        [USER=874269]Int[/USER]AccountID int

EXEC    [USER=850422]return[/USER]_value = [dbo].[P_AddAccount]
        @nvcAccountName = N'LOGIN',
        @inyAccountLevelCode = 100,
        @inyCharacterCreateLimit = 6,
        @inyCharacterMaxCount = 6,
        @dt2LastLoginDate = NULL,
        @vchLastLoginIP = NULL,
        [USER=874269]Int[/USER]LastSessionID = NULL,
        @vchJoinIP = NULL,
        @inyPublisherCode = 4,
        @inyGenderCode = NULL,
        [USER=1333446700]DaT[/USER]BirthDate = NULL,
        @vchPassphrase = N'PASSWORD',
        @inyNationalityCode = NULL,
        @inyChannelPartnerCode = NULL,
        [USER=874269]Int[/USER]AccountID = [USER=874269]Int[/USER]AccountID OUTPUT

SELECT    [USER=874269]Int[/USER]AccountID as N [USER=874269]Int[/USER]AccountID'

SELECT    'Return Value' = [USER=850422]return[/USER]_value

GO

 

[Melwin]

@ashlay Thank you

But my problem is not create account it login problem.

i need to change like this but I don't know how

3. DatabaseTo 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

 

[jaeker1]

getting same error as laukinfai001, just translated

do you have link this client ?

 

[ashlay]

@Melwin
like i said im using databases posted in this topic and i just create my account and works fine.

 

[Melwin]

@ashlay

But for me I have a problem with my DNDBServer64_DE.exe

it crash :O

 

[Abry]

@ashlay

But for me I have a problem with my DNDBServer64_DE.exe

it crash :O

I guess the file only works on 64bit system, as the filename says. Correct me if I'm wrong.

 

[ashlay]

@Melwin
you have did this?

....
7. create an user DragonNest with password qorhvk!@# and grant privileges db_owner to those databases, you provably have to delete the old DragonNest user inside each database or mssql will show an error.
....

--edit-- Thorin
yes these files works only on x64 system.

 

[Melwin]

@Thorin Yes, I use windows 7 64 bits with 8 Gb RAM
ashlay Thank you I will try



Edit : Still have a problem with DNDBServer64_DE.exe

 

[Muhamad NAbil]

Hi guys , how to pack client version ? got any tools ? coz i use DNPacker , it not include version.cfg etc

 

[homura90]

what u guys put inside DB DNMembership>WorldConfig

i always start server with 0 worldID

 

[nimitz90]

Finally made SH work

 

[Muhamad NAbil]

Finally made SH work

btw how u do ? i adding new pack in client (want use autopatch but version.cfg not include) , but same not work etc

 

[veenzaa]

Finally made SH work

when i go to SH, client always crash :3 ==a
any clue?