[Request]Reupload of setup dekaron pserver guide

12/04/2020 19:35 nemesisysf#1
Hi,
there was a video on youtube about how to setup a pserver
the video is called "Making a Dekaron private server tutorial on windows 7/8/10" ubifun has managed to delete the video if someone or the owner still has it could reupload ?

12/04/2020 19:46 thirdeye42#2
The one with SQL2000 and SP4?

I'm not the creator of the video, I downloaded it awhile ago for my keepsake. I won't
be reuploading it to Youtube for it to be removed again.

Here's a [Only registered and activated users can see links. Click Here To Register...].
12/04/2020 20:26 torianbg#3
Here are also the stuff the video had in its description as well:

First query :

Use master;
Go
EXEC sp_addlinkedserver 'LSV_GHBILL','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRACNT','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'DKRCASH','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRHELION','','MSDASQL',NULL,NULL,'DRIVER={SQ L Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRNUNVICE','','MSDASQL',NULL,NULL,'DRIVER={S QL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRQUNE','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRRONDOW','','MSDASQL',NULL,NULL,'DRIVER={SQ L Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRSIZ','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRTEST','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRZUTO','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRSTA','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'DKRACCOUNT01','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'


Second query :

Use master;
Go
exec sp_serveroption 'LSV_GHBILL','rpc out','true'
exec sp_serveroption 'LSV_GHBILL','rpc','true'
exec sp_serveroption 'LSV_DKRACNT','rpc out','true'
exec sp_serveroption 'LSV_DKRACNT','rpc','true'
exec sp_serveroption 'DKRCASH','rpc out','true'
exec sp_serveroption 'DKRCASH','rpc','true'
exec sp_serveroption 'LSV_DKRHELION','rpc out','true'
exec sp_serveroption 'LSV_DKRHELION','rpc','true'
exec sp_serveroption 'LSV_DKRNUNVICE','rpc out','true'
exec sp_serveroption 'LSV_DKRNUNVICE','rpc','true'
exec sp_serveroption 'LSV_DKRQUNE','rpc out','true'
exec sp_serveroption 'LSV_DKRQUNE','rpc','true'
exec sp_serveroption 'LSV_DKRRONDOW','rpc out','true'
exec sp_serveroption 'LSV_DKRRONDOW','rpc','true'
exec sp_serveroption 'LSV_DKRSIZ','rpc out','true'
exec sp_serveroption 'LSV_DKRSIZ','rpc','true'
exec sp_serveroption 'LSV_DKRTEST','rpc out','true'
exec sp_serveroption 'LSV_DKRTEST','rpc','true'
exec sp_serveroption 'LSV_DKRZUTO','rpc out','true'
exec sp_serveroption 'LSV_DKRZUTO','rpc','true'
exec sp_serveroption 'LSV_DKRSTA','rpc out','true'
exec sp_serveroption 'LSV_DKRSTA','rpc','true'
exec sp_serveroption 'DKRACCOUNT01','rpc out','true'
exec sp_serveroption 'DKRACCOUNT01','rpc','true'

Account registration query :

Use account;
Go
Insert Into [TBL_USER] Values ('09101410275532', 'ID', 'Password', 'E-Mail', 'Secret Answer', 'Secret Question', '127.0.0.1')
Insert Into [USER_PROFILE] Values ('09101410275532','ID','Password','801011000000',' 1','0','Y','01/01/2006 00:00:00',null,null,null,'000')

Starting order :

1. Dbmon
2. Cast Server
3. Login Server
4. Msg Server
5. Session Server
6. Game Server

Md5 hash generator used in the video :


Links for the files :

Download full client, server, win7 launcher from here :
[Only registered and activated users can see links. Click Here To Register...]

Database : [Only registered and activated users can see links. Click Here To Register...]

Sql2000 :
[Only registered and activated users can see links. Click Here To Register...]

Sql2000 SP4 :
[Only registered and activated users can see links. Click Here To Register...]

Personal note: Do not use the EVAL version given here because its like a trial that will last 180 days and will stop working after that, without telling you why, was pain to figure it out on my own, better torrent it from somewhere or I can upload what I got if you cant find anything

This thread will be more useful to you [Only registered and activated users can see links. Click Here To Register...] instead of the one linked in the video, or you can just get the files from thirdeye42's discord
12/04/2020 20:56 [DEV]Dekaron#4
Quote:
Originally Posted by thirdeye42 View Post
The one with SQL2000 and SP4? I have one on my Discord > Dekaron > downloads

I'm not the creator of the video, I downloaded it awhile ago for my keepsake. I won't
be reuploading it to Youtube for it to be removed again.
upload this vide and make this as non public and post on epvp
12/04/2020 21:36 thirdeye42#5
Quote:
Originally Posted by [DEV]Dekaron View Post
upload this vide and make this as non public and post on epvp
I actually did already and it was removed. [Only registered and activated users can see links. Click Here To Register...]
12/04/2020 22:24 torianbg#6
Reuploaded it myself and made a post here [Only registered and activated users can see links. Click Here To Register...]

Left it public in case someone outside of this forums also needs it. If it gets deleted will reupload.
12/04/2020 23:18 nemesisysf#7
Thanks for your support. I have noticed some of guide stuff missing or very messy. So i remebered that there was a video anyways going to dig forums some more

Trying get a9 server. but session server give an error ? am i missing something ?

[Critical Error SP_LOGIN_FLAG_SET is fail]
12/04/2020 23:59 [DEV]Dekaron#8
Quote:
Originally Posted by nemesisysf View Post
Thanks for your support. I have noticed some of guide stuff missing or very messy. So i remebered that there was a video anyways going to dig forums some more

Trying get a9 server. but session server give an error ? am i missing something ?

[Critical Error SP_LOGIN_FLAG_SET is fail]
If your session_server crash and you see

Quote:
Originally Posted by nemesisysf View Post
[Critical Error SP_LOGIN_FLAG_SET is fail]
you can have two issue

1) incorrect login or password in session_server folder file config.ini
2) user what you provide in config.ini is not bind to character.db

do you have same issue with cast_server?
12/05/2020 19:13 nemesisysf#9
Quote:
Originally Posted by [DEV]Dekaron View Post
If your session_server crash and you see



you can have two issue

1) incorrect login or password in session_server folder file config.ini
2) user what you provide in config.ini is not bind to character.db

do you have same issue with cast_server?
re extracted session server files and edited again not sure what i have done wrong but it worked thanks
02/06/2026 12:13 Xyzen528#10
someone help with this