Dragon knight server files + database

[[DEV]AlphaOMEGA]

link back is on home page

alot of people we requesting to reupload of the files
I didnt get my hands on a client so if anyone has it send me link so i can
upload to my server

Query 1

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 [MENTION=2264375]User_[/MENTION]pwd parameter.
before : varchar(20) 
after : varchar(64)
1.7	2007.02.14	CHOI JI HWAN	1. ????? ip ?? ?? ??.
2. ???? MD5 ???
 [MENTION=2264375]User_[/MENTION]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]
 [MENTION=4436585]user_id[/MENTION]	varchar(40)	,	-- ????ID
 [MENTION=2264375]User_[/MENTION]pwd	varchar(64)	,	-- ???? ????
@LogiN_flag	int	,	-- ??????
 [MENTION=2264375]User_[/MENTION]ip_addr	varbinary(4)	,	-- ???IP??
 [MENTION=2264375]User_[/MENTION]no	varchar(14)	OUTPUT	,	-- ????????
 [MENTION=404551]sEsSiOn[/MENTION]_id	int	OUTPUT	,	-- ????ID
 [MENTION=4105143]Teen_[/MENTION]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 [MENTION=4268958]v_r[/MENTION]esident_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 [MENTION=2264375]User_[/MENTION]ip_addr as BIGINT)
SET @ipt_time	= GetDate()
SET @conn_rtn	= 0
SET [MENTION=2264375]User_[/MENTION]no	= '0000000000'
SET [MENTION=404551]sEsSiOn[/MENTION]_id	= 0
SET [MENTION=4105143]Teen_[/MENTION]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( [MENTION=2264375]User_[/MENTION]ip_addr )
IF @ip_tag = 1
BEGIN
SET @sp_rtn = -6
RETURN
END
--************************************
-- ?????? IP?? End
--************************************

--************************************
-- ??IP ?? ?? (2005.08.17 - Hanjiwook)
--************************************
IF dbo.FN_ExistBanIP [MENTION=2264375]User_[/MENTION]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
, [MENTION=2264375]User_[/MENTION]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 = [MENTION=2264375]User_[/MENTION]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,
 [MENTION=4268958]v_r[/MENTION]esident_no	= resident_no
FROM	dbo.user_profile WITH(UPDLOCK)
WHERE	user_id = [MENTION=4436585]user_id[/MENTION]
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( [MENTION=2264375]User_[/MENTION]ip_addr, [MENTION=2264375]User_[/MENTION]pwd ), 0) <> 1	--GM : no password check.
--BEGIN
--	--// 2. ???? ???? ??
--	SELECT [MENTION=2264375]User_[/MENTION]pwd = isnull [MENTION=2264375]User_[/MENTION]pwd, '')
--	IF @v_user_pwd <> [MENTION=2264375]User_[/MENTION]pwd or [MENTION=2264375]User_[/MENTION]pwd = ''
--	BEGIN
--	ROLLBACK TRANSACTION
--	SET @sp_rtn = -1	--old : -2
--	EXEC dbo.SP_LOGIN_FAILURE_LOG_C [MENTION=2264375]User_[/MENTION]ip_addr, [MENTION=4436585]user_id[/MENTION], [MENTION=2264375]User_[/MENTION]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 [MENTION=404551]sEsSiOn[/MENTION]_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 [MENTION=404551]sEsSiOn[/MENTION]_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 [MENTION=2264375]User_[/MENTION]no = @v_user_no
SET @v_user_age = dbo.FN_ResidentNoToAge [MENTION=4268958]v_r[/MENTION]esident_no,getDate()) 
SET @v_server_id	= dbo.FN_LoginFlagToServerID @LogiN_flag)
SET @v_user_sex	= dbo.FN_ResidentNoToSex [MENTION=4268958]v_r[/MENTION]esident_no)

SET [MENTION=4105143]Teen_[/MENTION]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= [MENTION=2264375]User_[/MENTION]ip_addr	,
server_id = @v_server_id
WHERE user_no = [MENTION=2264375]User_[/MENTION]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	
 [MENTION=2264375]User_[/MENTION]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 
 [MENTION=2264375]User_[/MENTION]no	, 
@LogiN_flag	, 
 [MENTION=2264375]User_[/MENTION]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

Query 2

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=;'

Query 3

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'

query to make 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

[Action10]

That's my work
Ty for Credits
All this other people you added on credits no have change nothing!

Credits: Ultimo ☼, Trac3r, Farius~, jaskile12, killerjp

they's only copy and share no change nothing and want credits for they's

[Farius~]

Originally Posted by Action10

That's my work
Ty for Credits
All this other people you added on credits no have change nothing!

Credits: Ultimo ☼, Trac3r, Farius~, jaskile12, killerjp

they's only copy and share no change nothing and want credits for they's

You know, here we have all contributed something, you released the files you are right but the millions of bugs that I had were resolved by the community, that is why he puts the credits.
I released the LobbyServer, AIServer And Location, and I know that it is not my job but I bought them from a person and released them, therefore we should thank them for that. do not think you're the only one who has worked in the files.

[Action10]

when i release thats files in 2014
i release with all files and all working normal

[ZenMast3r]

This proofs how ignorant and selfish are some people.. Action10, so you don't want anyone else get thanks and credits for the files, except you? ROFL.. You released files that were 99% bugged and not working good.. Thanks to all those people, they were fixed quickly, so you are not the only one who deserves a credit.. Also you released the files without Location, AI and Lobby and thanks to Farius we got them for free.

You are right. You released the files, but they get them to work, because let's be honest.. Your files were bugged as hell like dc every 5 minutes, ip for gms and much more.. So just stay on your **** and don't say nothing, because they deserve much more credits than you. :P

[Action10]

ZenMast3r
This proofs how ignorant and selfish are some people.. Action10, so you don't want anyone else get thanks and credits for the files, except you? ROFL.. You released files that were 99% bugged and not working good.. Thanks to all those people, they were fixed quickly, so you are not the only one who deserves a credit.. Also you released the files without Location, AI and Lobby and thanks to Farius we got them for free.

Firstly I do not see any work they did so tell me here what they did and this files .exe!
And another who put these files was ItsNobody he put the files without running!
I corrected the errors all these files if today you have this **** working that was thanks to me so beak shut!
and another one after not sending me a message in private asking me for files not!
I posted these files working for everyone and FREE
and many people sell THIS FILES!

[Cloddes93]

I don't think anyone will share an A9 client. I searched through all the links for those and they all got deleted. The only type of client that you can find are edited A3 (unless you're willing to buy it then i'm sure you can find plenty of people selling it)

[Ultimo ☼]

I did NOT edited the files in any way, i just released them again when all link was dead because "someone" was selling them

So i guess thanks goes to me too lol

Thanks for credits

[Cloddes93]

Originally Posted by Ultimo ☼

I did NOT edited the files in any way, i just released them again when all link was dead because "someone" was selling them

So i guess thanks goes to me too lol

Thanks for credits

Do you still happen to have any A9 client at all Ultimo? it seems that all links got hunted and deleted or brought down

[Ultimo ☼]

Sorry i don't have any A9 client.. i quitted dekaron long time ago

Why don't you guys download an official a9 client and start from there? I know it takes time to make it work with the exes we have now, like adding the new classes, new maps etc.. but you will have the best client to work with!

[Underfisk]

I've released some at DKVault check it out

[dbqoddl2]

Not working.. cast crash awwwwwwwww!!!!!!!!!

[kyrll]

Query 1 and 2 have errors xD