|
You last visited: Today at 11:09
Advertisement
thanks for all your help
Discussion on thanks for all your help within the Dekaron Private Server forum part of the Dekaron category.
09/04/2015, 03:06
|
#1
|
elite*gold: 0
Join Date: Dec 2009
Posts: 37
Received Thanks: 2
|
thanks for all your help
some people get on here to make server but they dont want to work for it i get on been making servers for many years and only ask a few questions and no one wants to help so if you really want something bad enough you will figure it out i have one final question for you guys what happened to the old days when you ask for help someone actually replies
|
|
|
09/04/2015, 03:52
|
#2
|
elite*gold: 0
Join Date: Jan 2012
Posts: 2,394
Received Thanks: 997
|
Back then most people made servers as a hobby. Now 98% of the servers runs for money. That's what happened. We don't support lazy kiddies who wanna make a quick buck on a 1month server. Work for your ****. Everyone here leeches stuff, nobody can be trusted.
I know, the point of this forum is to share stuff. But it's a different story when you make something and someone releases it as his own.
|
|
|
09/04/2015, 04:02
|
#3
|
elite*gold: 0
Join Date: Dec 2009
Posts: 37
Received Thanks: 2
|
ty
thank you for your honesty
|
|
|
09/04/2015, 07:45
|
#4
|
elite*gold: 0
Join Date: Jul 2015
Posts: 876
Received Thanks: 258
|
guesswho you have 100% right.
|
|
|
09/05/2015, 04:34
|
#5
|
elite*gold: 0
Join Date: Jun 2011
Posts: 415
Received Thanks: 139
|
The other side is that there are a lot newer games with much better graphics out there that attract new gamers. Dekaron is an old game. We have to work very hard to make the game exciting and fun to attract players, but most of the players aren't new to the game but players from other servers or players that quit the game and came back. I'd say 2% of the population is new players.
|
|
|
09/05/2015, 07:28
|
#6
|
elite*gold: 0
Join Date: Jul 2015
Posts: 876
Received Thanks: 258
|
thats why Nexon must start think about change. Engine for this game. (Unity Crytek or even Unreal Engine) (some game on my tablet, looks better)
|
|
|
09/05/2015, 16:04
|
#7
|
elite*gold: 0
Join Date: Jun 2011
Posts: 415
Received Thanks: 139
|
When Nexon took over they cancelled the development of Dekaron 2. So, there will be no new Dekaron:
|
|
|
09/07/2015, 09:44
|
#8
|
elite*gold: 0
Join Date: Nov 2008
Posts: 76
Received Thanks: 16
|
Thing is dekaron is basically a dieing breed. I mean I played a lot of official servers. Dekaron Thialand, SEA, TIAWAN, Old EU, 2moons, China, Global, and Indonesia.
didn't play japan and korea.
Out of all of those servers the only servers online anymore are Global and Korea.
Everyone one of them shutdown due to lack of players or play to win features to drive profit to keep the servers up.
Its sad to say they wont bring back dekaron in a new engine due to the fact its dieing off and I know a lot of gamers that never heard of dekaron to begin with.
I make servers for a hobby because in the end if global and korea shutdown
its us who keeps the servers alive.
|
|
|
09/07/2015, 22:03
|
#9
|
elite*gold: 0
Join Date: Dec 2009
Posts: 37
Received Thanks: 2
|
k so do you know how i can make gm character for my server
login and dc
|
|
|
09/07/2015, 22:59
|
#10
|
elite*gold: 0
Join Date: Jul 2015
Posts: 876
Received Thanks: 258
|
go here DekaronServer_Normal\Dekaronserver open IPlist and add your IP
1) 127.0.0.1
2) 192.x.x.x <- From DHCP (if you use router)
3) External IP (if you have)
Sample:
Code:
IP,Grade,XignCOde
127.0.0.1,0,0
192.168.x.x,0,0
193.x.x.x,0,0
And run AccountGateServer. (if you have)
|
|
|
09/08/2015, 00:24
|
#11
|
elite*gold: 0
Join Date: Dec 2009
Posts: 37
Received Thanks: 2
|
do i need to reset allserver
still dc
|
|
|
09/08/2015, 06:08
|
#12
|
elite*gold: 0
Join Date: Jul 2015
Posts: 876
Received Thanks: 258
|
you need restart dekaronserver.exe only
(can you write what you use A9 with 12 character or you use other files?)
And try use this query
Code:
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
|
|
|
All times are GMT +2. The time now is 11:09.
|
|