Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

[Release] Dekaron real A9 Server files

Joined
Aug 20, 2010
Messages
1,388
Reaction score
253
Before you start asking, yes these are the real A9 server files. And i haven't gotten these to work myself yet.
You will need MsSQL 2008 R2 or newer.

So far Cast, Session and Store, i haven't been able to run without crashes. I'm guessing something must be wrong with the database or with the ODBC. Also keep in mind TCP needs to be enabled in mssql configuration manager.
___________________

Server Files

DekaronServer Files A9.rar 34.9 MB


Update (Optional)


Unpack the Dekaron_A9.exe and paste into DekaronServer folder, this adds all playable classes.
_____________________

Client:

_____________________

A9 regedit key : google this one up.
1º Open regedit - localmachine - software - WoW6432node - Make a key called GameHi and into GameHi make other called Dekaron , next only run key .


_____________________

Databases


Update: Working databases




_____________________

ODBC








__________________________

SQL Configuration Manager


__________________________

Querrys you will need to run:

Q1
USE [Account]
GO
/****** Object: StoredProcedure [dbo].[SP_ACC_LOGIN] Script Date: 04/05/2014 05:32:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO







/************************************************** ****************************
? ? : dbo.SP_ACC_LOGIN
? ? : ?? ???
???? :
???? : @sp_rtn
0 : ??.
-1 : ????? ???.
-2 : ????? ???? ???.
-3 : ?????? ?????? ??? ?? ??.
-4 : ???? ??? ???. (?? ????)
-5 : ????? ?? ??.
-6 : ??? ??? ????.
-7 : ???? ???? ??.
-8 : ?????.
-10 : Update Lock ??(DB ??)
-11 : ??IP??.
-12 : ???? ?? 5??? ??? ?? ?? IP.
-20 : DB Error
-21 : ???? ????
-22 : ???? ???
Ver Date Author Description
--------- ---------- -------------- ------------------------------------
1.0 2004-10-11 ??? 1. ?? ???
1.1 2005-09-07 ??? 1. ??IP?? ??? ??.
1.2 2005-09-12 ??? 1. IP????(@ip_addr_tag) OUTPUT???? ??.
(PC? IP??? ???? ?? ?)
1.3 2005-11-14 ??? 1. ????????Key, PC?????,
PC? ???? ??.
2. PC? IP???? ??(FN_IsPCBangIP)?
SP_GET_PCBANG_INFO_R? ??.
1.4 2006-01-04 ??? 1. ???? ???? ??? ??
1.5 2006-01-11 ??? 1. ?? ????(-4) : ???? (RollBack, Return ??)
1.6 2007.02.05 CHOI JI HWAN 1. modify user_pwd parameter.
before : varchar(20)
after : varchar(64)
1.7 2007.02.14 CHOI JI HWAN 1. ????? ip ?? ?? ??.
2. ???? MD5 ???
user_pwd : VARCHAR(20) -> VARCHAR(64)
1.8 2007.02.15 Han JI wook 1. User_ID -> Lower Casting
1.9 2007.02.20 Han JI wook 1. User_ID -> Lower Casting Cancel
2.0 2007.04.04 Choi JI Hwan 1. Change @sp_rtn value
Invalid passowrd : old=-2 >> new=-1
2.1 2007.04.17 Han JI Wook 1. Add Password Change Check
2.2 2007.04.24 CHOI JI HWAN 1. ???? ???? ??? ? ??? 5??? ???? ?? IP?? ???? ??????.
2.3 2007.04.26 CHOI JI HWAN 1. IP? ?? ?????? 30??? ??.
************************************************** ****************************/

ALTER PROCEDURE [dbo].[SP_ACC_LOGIN]
user_id varchar(40) , -- ????ID
user_pwd varchar(64) , -- ???? ????
LogiN_flag int , -- ??????
user_ip_addr varbinary(4) , -- ???IP??
user_no varchar(14) OUTPUT , -- ????????
Session_id int OUTPUT , -- ????ID
Teen_tag int OUTPUT , -- ?????? (0:18???, 1:18???)
@ip_addr_tag int OUTPUT , -- IP??????(0:??, 1:pC?)
@o_ac_conn_no char(20) OUTPUT , -- ????????Key -> ??
@o_pcbang_no varchar(14) OUTPUT , -- PC? ????. -> ( 2005-11-11 )??
@o_pc_agency_no varchar(5) OUTPUT , -- PC? ???? -> ??
@a int OUTPUT ,
@b int OUTPUT ,
@sp_rtn int OUTPUT -- ??? ?? (0:??)
AS
DECLARE @v_user_pwd varchar(64)
DECLARE @v_login_flag int
DECLARE @v_user_no varchar(14)
DECLARE @v_resident_no varchar(13)
DECLARE @v_login_tag char(1)
DECLARE @v_user_age int
DECLARE @ipt_time datetime
DECLARE conn_rtn int
DECLARE @ip_tag int
DECLARE Company_ip varbinary(3)
DECLARE @v_server_id varchar(3)
DECLARE @v_user_sex varchar(1)
DECLARE Rowcnt int

--// ????
DECLARE @o_p_step_no int --????
DECLARE @o_p_reason_sort varchar(2) --??????
DECLARE @o_p_expire_time datetime --??????
DECLARE @v_lo_block_tag varchar(1) --???????
DECLARE @o_wr_block_tag varchar(1) --??????
DECLARE @v_in_sp_rtn int
DECLARE @v_bigint_ip bigint

DECLARE @v_login_failure_count int
DECLARE @v_onlineIdCount int

BEGIN

SET LOCK_TIMEOUT 1000

SET @v_bigint_ip = CAST user_ip_addr as BIGINT)
SET @ipt_time = GetDate()
SET conn_rtn = 0
SET user_no = '0000000000'
SET Session_id = 0
SET Teen_tag = 0
SET @ip_addr_tag = 0
SET @sp_rtn = 0
SET @o_ac_conn_no = '0000000000000000'
SET @o_pcbang_no = ''
SET @o_pc_agency_no = ''

SET @a = 0
SET @b = 0
--************************************
-- ?????? IP?? Start
--************************************
SELECT @ip_tag = dbo.FN_IsBlockIP( user_ip_addr )
IF @ip_tag = 1
BEGIN
SET @sp_rtn = -6
RETURN
END
--************************************
-- ?????? IP?? End
--************************************

--************************************
-- ??IP ?? ?? (2005.08.17 - Hanjiwook)
--************************************
IF dbo.FN_ExistBanIP user_ip_addr) = 1
BEGIN
SET @sp_rtn = -11
RETURN
END

--************************************************** **********
-- ??? ?IP?? 5??? ??? ???? ??? ??.(CHOI JI HWAN - 2007.04.24)
--************************************************** **********
EXEC dbo.SP_LOGIN_FAILURE_LOG_GetCountByIp @ipt_time
, user_ip_addr
, @v_login_failure_count OUTPUT
, @v_in_sp_rtn OUTPUT
IF ( @v_login_failure_count >= 5 )
BEGIN
SET @sp_rtn = -12
RETURN
END

--************************************************** **********
-- IP? ?? ?????? 30??? ??. (CHOI JI HWAN - 2007.04.26)
--************************************************** **********
SELECT @v_onlineIdCount = COUNT(*)
FROM dbo.user_profile WITH(NOLOCK)
WHERE login_flag > 0
AND user_ip_addr = user_ip_addr
--AND login_tag = 'Y'
IF ( @v_onlineIdCount >= 30 )
BEGIN
SET @sp_rtn = -13
RETURN
END
--************************************************** **********

BEGIN TRANSACTION

--// Login_Tag
--// 'Y' : normal, 'P' : Password Not Change
SELECT @v_user_no = user_no,
@v_user_pwd = isnull(user_pwd, ''),
@v_login_flag = login_flag,
@v_login_tag = login_tag,
@v_resident_no = resident_no
FROM dbo.user_profile WITH(UPDLOCK)
WHERE user_id = user_id
AND login_tag IN ('Y', 'P')

SET Rowcnt = RowCOUNT

IF @@ERROR <> 0
BEGIN
ROLLBACK TRANSACTION
SET @sp_rtn = -10
RETURN
END

--************************************
-- ???? Check
--************************************
--// 1. ???? ?? ??
IF Rowcnt = 0
BEGIN
ROLLBACK TRANSACTION
SET @sp_rtn = -1 --old : -1
RETURN
END

--IF ISNULL(dbo.FN_CertifyIpPwd( user_ip_addr, user_pwd ), 0) <> 1 --GM : no password check.
--BEGIN
-- --// 2. ???? ???? ??
-- SELECT user_pwd = isnull user_pwd, '')
-- IF @v_user_pwd <> user_pwd or user_pwd = ''
-- BEGIN
-- ROLLBACK TRANSACTION
-- SET @sp_rtn = -1 --old : -2
-- EXEC dbo.SP_LOGIN_FAILURE_LOG_C user_ip_addr, user_id, user_pwd, @v_user_no, LogiN_flag, @sp_rtn, @v_in_sp_rtn OUTPUT
-- RETURN
-- END

-- --// 3.1 2006.05.01 ?? ??????? ???? ?? ?? ('P')
-- --// 3.2 ?????? ???? ???? login_tag? 'Y'? ???.
-- IF @v_login_tag = 'P'
-- BEGIN
-- ROLLBACK TRANSACTION
-- SET @sp_rtn = -22
-- RETURN
-- END
--END

/*
--// 3.1 ?????? ?????? ????? ??
--// 3.2 ?????? ???????? login_tag? 'Y'? ???.
IF @v_login_tag = 'C'
BEGIN
ROLLBACK TRANSACTION
SET @sp_rtn = -3
RETURN
END
*/

--// 4. Dont forget fix
--IF ( (@v_login_flag <> 0) AND (@v_login_flag = LogiN_flag) ) BEGIN
-- --// ROLLBACK TRANSACTION
-- SET Session_id = @v_login_flag
-- SET @sp_rtn = -4
-- --// RETURN
--END

IF ( (@v_login_flag <> 0) AND (@v_login_flag <> LogiN_flag) ) BEGIN
ROLLBACK TRANSACTION
SET Session_id = @v_login_flag
SET @sp_rtn = -4
RETURN
END

--************************************
-- ?????(????) ??
--************************************
EXEC dbo.MB_USR_PUN_CheckBlock_R @v_user_no , --????
@o_p_step_no OUTPUT, --????
@o_p_reason_sort OUTPUT, --??????
@o_p_expire_time OUTPUT, --??????
@v_lo_block_tag OUTPUT, --???????(Y=??, N=?????)
@o_wr_block_tag OUTPUT, --????(????? ????)
@v_in_sp_rtn OUTPUT --????(0:??)
IF @v_in_sp_rtn <> 0 OR @@Error <> 0
BEGIN
ROLLBACK TRANSACTION
SET @sp_rtn = -7
RETURN
END

IF Upper(@v_lo_block_tag) = 'Y' --?????? ??.
BEGIN
ROLLBACK TRANSACTION
SET @sp_rtn = -8
RETURN
END

SET user_no = @v_user_no
SET @v_user_age = dbo.FN_ResidentNoToAge(@v_resident_no,getDate())
SET @v_server_id = dbo.FN_LoginFlagToServerID LogiN_flag)
SET @v_user_sex = dbo.FN_ResidentNoToSex(@v_resident_no)

SET Teen_tag = CASE
WHEN @v_user_age < 18 THEN 1
ELSE 0
END

--// ????? ??
UPDATE dbo.user_profile
SET login_flag = LogiN_flag ,
login_time = @ipt_time ,
user_ip_addr= user_ip_addr ,
server_id = @v_server_id
WHERE user_no = user_no
AND login_flag = @v_login_flag

IF (@@ERROR <> 0 or RowCOUNT <> 1)
BEGIN
ROLLBACK TRANSACTION
SET @sp_rtn = -5
RETURN
END

--// IP???? ?? ??.
EXEC dbo.SP_GET_PCBANG_INFO_R
user_ip_addr , -- IP??.
@o_pcbang_no OUTPUT , -- PC? ????.
@o_pc_agency_no OUTPUT , -- PC? ????.
@ip_addr_tag OUTPUT , -- IP??????(0:??, 1:pC?)
NULL -- @o_sp_rtn
SELECT @ip_addr_tag = IsNull(@ip_addr_tag, 0)
-------------------------------------------------------------------

-- ???? ???? ??
EXEC dbo.SP_ACNT_CONNLOG_C
user_no ,
LogiN_flag ,
user_ip_addr ,
@ipt_time ,
@o_pcbang_no ,
@o_pc_agency_no ,
@v_user_age ,
@v_user_sex ,
@o_ac_conn_no OUTPUT ,
conn_rtn OUTPUT

IF @@ERROR <> 0 OR conn_rtn <> 0 BEGIN
IF @@TRANCOUNT > 0
ROLLBACK TRANSACTION
SET @sp_rtn = -20
RETURN
END

COMMIT TRANSACTION
--// SET @sp_rtn = 0
RETURN

END

Q2:
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={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRNUNVICE','','MSDASQL',NULL,NULL,'DRIVER={SQL 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={SQL 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=;'

Q3:
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'

Querry to create account:
INSERT INTO [account].[dbo].[USER_PROFILE]
([user_no],[user_id],[user_pwd],[resident_no],[user_type],[login_flag],[login_tag],[ipt_time],[login_time],[logout_time],[user_ip_addr],[server_id],[auth_tag])

VALUES ('09101410275532','user','your hash code','801011000000','1','0','Y','01/01/2006 00:00:00','01/01/2006 00:00:00',null,null,null,'000')

Credits: Ultimo ☼, Trac3r, Farius~, jaskile12, killerjp, ItsNobody, Action10
If i missed anyone let me know.

Edit: So i have been able to get these files to work.

  • Don't use the 64bit version of MsSQL 2008 R2, but instead the 32bits version. ( I recommend getting MsSQL 2008 R2 SP2)
  • Make sure TCP is enabled in configuration manager.
  • Do not rely on the 'sa' account disable this account, but instead make a new one and give it sysadmin rights.
  • Make sure the new account you made has db_owner rights over every database
  • And make sure you have added the needed things to ODBC.

If you did that cast server should work without any problems. Also make sure the server locale is set from HONGKONG to KOREA. As for the Store crash, change the config file from BILLING to RANKING.

To make yourself DEV or GM, change that inside tha database table dbo.user_character. Try logging in and you will crash at first(This is normal). Now look at your dbmon, there will be a ipadress there, copy this. Next go to IPList inside DekaronServer, and add the IPadress inside there.

Example:
Code:
IPADRESS,0,0,YOURNAME

Party - [Release] Dekaron real A9 Server files - RaGEZONE Forums Whatever - [Release] Dekaron real A9 Server files - RaGEZONE Forums
 

Attachments

You must be registered for see attachments list
Last edited:
Initiate Mage
Joined
Jun 11, 2014
Messages
33
Reaction score
2
Can you help me?

1. Can't download File reg A9 because it protected by password

2. Querry 1 is error


3. My Dkserver.exe response "need to close"
 
Initiate Mage
Joined
Jun 11, 2014
Messages
33
Reaction score
2
I got it. but DekaronServer_Normal.exe response "need to close". how to it works?
 
Joined
Aug 20, 2010
Messages
1,388
Reaction score
253
I got it. but DekaronServer_Normal.exe response "need to close". how to it works?

Code:
Make sure TCP is enabled in configuration manager.
Do not rely on the 'sa' account disable this account, but instead make a new one and give it sysadmin rights.
Make sure the new account you made has db_owner rights over every database
And make sure you have added the needed things to ODBC.
 
Initiate Mage
Joined
Jun 11, 2014
Messages
33
Reaction score
2
tidie
Can you help me via team view ? I cant run dkserver.exe . I did everything you said

 
Joined
Aug 20, 2010
Messages
1,388
Reaction score
253
Main post updated: Optinional server file added - Server Files Section of Main post
Pictures added
New Databases link. - Database Section of Main post


tidie
Can you help me via team view ? I cant run dkserver.exe . I did everything you said


Sorry, i don't offer help through teamviewer. I hate the use of that program, with a passion.
Instead post your Config files of server, all of them in CODE tag please. And i'll take a look, you probably mis-configured those.

Help me pls Run server Skype:lacixxx12

No, just no. You try yourself, that way you learn something out of it. Like everyone else does. And i don't use skype to help anymore.

Reasons:
People spamming me for help in the past.
People asking dumb questions.
 
Last edited:
Initiate Mage
Joined
Dec 20, 2013
Messages
5
Reaction score
0
Starting Server

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

yes?
 
Joined
Aug 20, 2010
Messages
1,388
Reaction score
253
Starting Server

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

yes?

That would work, yeah.

But i'd say:

  • 1. Dbmon
  • 2. AI Server
  • 3. Cast Server
  • 4. Location Server
  • 5. Lobby Server
  • 6. Login Server
  • 7. Message Server
  • 8. Store Server - Extra note on store server: If using updated databases, open the conig of store server, look for RANKINGDB and change this to dkrstoredb. This will make cash shop work. And also make sure the port matches with Dekaron Server config.
  • 9. Session Server
  • 10. Dekaron Server

This personally works best to me.
 
Initiate Mage
Joined
Apr 11, 2008
Messages
28
Reaction score
0
with sql server i need to make it?

have many:
SQL Server 2008 r2: DataCenter,Developer,Enterpise,web,WorkGrup?
 
Back
Top