[Release] + [Tutorial] DragonNest Server

[major333]

Anyone getting this error at all ? , if so how can you get around it ?

It's the only thing i have a issue with at the current moment.

 

[FroZenFiRe]

I will make tutorials with different things (original launcher, modifying, writing own dialogs/quests etc.), but not now.
If we are getting an extra Dragon Nest section I'm going to share these things one by one if I see any own development from other users too.

Ty so much , I am here to learn not to go public or make $$ off this

Dont forget this part for the db's as i did:
7. create an user DragonNest with password qorhvk!@# and grant privileges db_owner to those databases,

 

[Keith]

Does anyone have a mirror for the client, lol..over a day to download.

 

[nimitz90]

Thanks Leechclown it work but yes ingameshop still crash and always got dced every 10minutes,btw did you know admin command?

 

[DaRealFreak]

but yes ingameshop still crash and always got dced every 10minutes

This was originally planned:

But leechclown is uploading with 20 kb/s so yeah he discarded the idea of uploading his client xD

Nevertheless we are coming from a section where the cash shop was always the first thing they worked on, so we decided to deny any request of help regarding the cash shop

Regarding your dc's I have no idea, didn't occur to me and we got a complete list of admin commands, but let's wait for the Dragon Nest section Mental promised in the other thread if there is a working tutorial for the servers.
So the item tables,.. are going to be published only in the new section^^

kind regards DaRealFreak

 

[ashlay]

Thanks leechclown and every1 who have helped to get these files.

 

[Shananigan]

Thanks Leechclown it work but yes ingameshop still crash and always got dced every 10minutes,btw did you know admin command?

What program do you use for the database ?

 

[kennethz008]

This was originally planned:

But leechclown is uploading with 20 kb/s so yeah he discarded the idea of uploading his client xD

Nevertheless we are coming from a section where the cash shop was always the first thing they worked on, so we decided to deny any request of help regarding the cash shop

Regarding your dc's I have no idea, didn't occur to me and we got a complete list of admin commands, but let's wait for the Dragon Nest section Mental promised in the other thread if there is a working tutorial for the servers.

kind regards DaRealFreak

That's the smart thing to do, as long as i can generate any items ingame i guess no need for a cashshop if you're playing as a solo player ^^ Thanks anyways

 

[leechclown]

btw did you know admin command?

Type "/? a" without "" in the chat.

Most important ones:
/setlevel [level]
/makeitem [id] [count] [grade] [potential]
/makecoin [count]
/summonmob [id] [count]

 

[major333]

Anyone? >.<

Microsoft SQL Server 2008 R2 Express + SQL Server Management Studio

 

[veenzaa]

Does anyone have a mirror for the client, lol..over a day to download.

download link frommy VPS

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

 

[nimitz90]

look here for item id:

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

 

[Muhamad NAbil]

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

where need change , sql ?

 

[major333]

Well where exactly the Item ID location? all i can see is Names

Edit: Found it Thanks

I thinks the item ID is the last bit for example:

American Bandana [805307135]

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

<---right here

 

[TriEdge]

someone got a english patch for it?

 

[kennethz008]

I thinks the item ID is the last bit for example:

American Bandana [805307135]

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

<---right here

yeah i already notice it, anyway thanks for pointing it out.

 

[major333]

yeah i already notice it, anyway thanks for pointing it out.

No worries dude, with those type of sites for different games normally have the ID at the end of it lol

 

[Rafael Carvalho]

Thank you leechclown for the release. You did a good thing.

Good night everyone!

 

[veenzaa]

i just gt disconnected from DB when select server :blink:
any module for xampp btw? to connect to DB...

 

[kaderebak]

irrelevant to the subject, but

Who sells the original file ?