|
You last visited: Today at 11:46
Advertisement
After login back to login [Error]
Discussion on After login back to login [Error] within the Dekaron Private Server forum part of the Dekaron category.
08/30/2015, 00:49
|
#31
|
elite*gold: 0
Join Date: Jul 2015
Posts: 876
Received Thanks: 258
|
Problem is in DB i told you on FB
If you can login to account but when you try make char you get DC that mean one for me problem in DB.
and try change from hongkong to korean
|
|
|
08/30/2015, 00:51
|
#32
|
elite*gold: 0
Join Date: Jul 2015
Posts: 40
Received Thanks: 0
|
When i tried a2 login server the only thing it changed was the time logging it takes slower but still got error , i tried 10k and 10k1 port and its not about ports .
|
|
|
08/30/2015, 00:52
|
#33
|
elite*gold: 0
Join Date: Jul 2015
Posts: 876
Received Thanks: 258
|
make new account and try.
New account is clean no character noting on your new account.
(try login and try make new char - when you do this, try connect, and if you get DC that will mean you need do one query for account and character DB)
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
|
|
|
08/30/2015, 00:52
|
#34
|
elite*gold: 0
Join Date: Jul 2015
Posts: 40
Received Thanks: 0
|
Dekaron , you logged on teamviewer , and you see i even cant go TO CHAR SCREEN , it dont pass from login ...
Why now you saying i get dc when i make an char if i even cant go to char screen !
So how can it be a problem of db , and about localedefine if was about it i get sp error in dbmon , and you see too when you try login u dont get any error !
Ive tried with 4-7 account dbs and still the same so its not about db
OMGGGGG someone give me a pistol plz , i think this guy dont know to read for real , i said i cant make a char , i cant go at char selection and this guy keep saying i can go and i can make char
Im done , gg im death
|
|
|
08/30/2015, 01:03
|
#35
|
elite*gold: 0
Join Date: Jul 2015
Posts: 876
Received Thanks: 258
|
check share folder
two files
loginlist.csv must be the same config on DK Server side and Client side
channellist.csv must be the same on DK Server side and client
the same IP and Port
127.0.0.1,7880 <- loginlist
127.0.0.1,50005 <- channellist
|
|
|
08/30/2015, 01:07
|
#36
|
elite*gold: 0
Join Date: Jan 2012
Posts: 2,394
Received Thanks: 997
|
lol.... sessionserver port is set to 10000 while your dksvr sessionserver port is 10001
|
|
|
08/30/2015, 01:15
|
#37
|
elite*gold: 0
Join Date: Jul 2015
Posts: 40
Received Thanks: 0
|
Atm they got random yea but i had them matched, i just tried to do something
That doesnt matter as you know i just need cast , login and session and no more to login in a9 ...
This isnt a a16 and there you need to have all connected .
ShadoW i can tell you something ?
First you need to read attention because i told u and i SHOWED you in teamviewer the server not loggin to char screen and you keep saying on FB and here i need to run a querry for fix character creation when dc ...
I just keep my word its not about db or configs but yes about packets , this pc isnt the best for host , i just wanna make test server so as it has low ram and low processor it can affect much at process
|
|
|
08/30/2015, 01:27
|
#38
|
elite*gold: 0
Join Date: Jan 2012
Posts: 2,394
Received Thanks: 997
|
if the database connection is indeed fine then run sql profiler and see what the SPs called returns. then check the SP that doesnt return 0. usually they have a pretty good explanation
|
|
|
08/30/2015, 12:46
|
#39
|
elite*gold: 0
Join Date: Jul 2015
Posts: 40
Received Thanks: 0
|
ive runned sp and just get returns with 0
|
|
|
08/30/2015, 21:58
|
#40
|
elite*gold: 0
Join Date: Jun 2011
Posts: 415
Received Thanks: 139
|
OK, did you try logging in one of the default DEV accounts (I only asked you twice in this thread if you are trying to login a DEV, GM or player account!)? Do this first! Make sure you know the username and password to the account. If you don't know the password generate a MD5 password and put it in the database. Make sure your IP address is in the IPlist.csv in the dekaron server folder. If everything is local, make sure you have a static IP address for your server and client (so you can login as DEV or GM). For A9 you need to run the following servers:
- Cast
- Lobby
- Location
- Login
- Store
- Message
- Dekaron
- Session
- Accountgate
Don't skimp out, RUN these servers! Don't even try to run this on a PC with less than 4GB of RAM. It also runs best on a 64bit OS. Don't run the client on the same machine either because that just won't work on a PC with limited RAM.
|
|
|
09/01/2015, 15:14
|
#41
|
elite*gold: 1022
Join Date: Jul 2009
Posts: 17,431
Received Thanks: 5,034
|
Stop the Trash-talk.
Otherwise you'll get a warning/infraction!
|
|
|
09/01/2015, 17:43
|
#42
|
elite*gold: 0
Join Date: Jul 2015
Posts: 876
Received Thanks: 258
|
Request Close
Corex pls close this trash topic.
|
|
|
09/11/2015, 14:16
|
#43
|
elite*gold: 0
Join Date: Nov 2008
Posts: 64
Received Thanks: 12
|
can i ask question ? my friends and i wants to play together on my server.. but i dont know how to add another account on my data base...
|
|
|
09/12/2015, 00:13
|
#44
|
elite*gold: 0
Join Date: Jul 2015
Posts: 876
Received Thanks: 258
|
use search option.
|
|
|
|
|
Similar Threads
|
Login problem back to login screen
06/15/2020 - Metin2 Private Server - 4 Replies
Hey guys i have a problem with my server (its dns) when i login i select my char and i login normaly but when my friend try to login he login normaly he select the char and then he go back to login screen and the problem is i dont know is on client or in server.
if anyone know pls help me i have done alot of work on those server files.
sorry for my bad english
and HAPPY NEW YEAR :D
|
Warrock Pvp Server Complete Succesfully Game Login But Login Map Error :S
02/22/2011 - WarRock - 7 Replies
Hi friends succesfully warrock pvp server and game login ıd pw succesfully server list WREMU Create room friedns came friends ready game start do not be eniting please help :(
|
Login-Error: Cannot login to Server
04/10/2009 - Aion - 8 Replies
It works fine but 1 hour ago gameguard was updated with ggscan.des or something like this and now i have every time following error while login:
"Cannot connect to the authorization server"
can someone help me?
|
All times are GMT +2. The time now is 11:46.
|
|