[Request]Reupload of setup dekaron pserver guide

[nemesisysf]

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 ?

[thirdeye42]

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 .

[torianbg]

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 :


Database :

Sql2000 :


Sql2000 SP4 :


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 instead of the one linked in the video, or you can just get the files from thirdeye42's discord

[[DEV]Dekaron]

Originally Posted by thirdeye42

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

[thirdeye42]

Originally Posted by [DEV]Dekaron

upload this vide and make this as non public and post on epvp

I actually did already and it was removed.

[torianbg]

Reuploaded it myself and made a post here

Left it public in case someone outside of this forums also needs it. If it gets deleted will reupload.

[nemesisysf]

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]

[[DEV]Dekaron]

Originally Posted by nemesisysf

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

Originally Posted by nemesisysf

[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?

[nemesisysf]

Originally Posted by [DEV]Dekaron

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