{Question} Need Guided on ACCOUNT DB

[kasuma11]

//

[Urbons]

The problem is obviously in the sp_acc_login procedure, indicated in the second screenshot first just check whether changing from global to korea or the other way around in data/script/localdefine/locale will fix it, if that doesn't work, find another account database because there's no way you're gonna fix it on your own.

Eh, click New Query and execute this script

WARNING : thats a long ass text

 Spoiler

USE [account]
GO
/****** Object: StoredProcedure [dbo].[SP_ACC_LOGIN] Script Date: 12/22/2014 12:39:54 ******/
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措惑.
-20 : DB Error
-21 : 促弗辑滚 肺弊牢吝
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
************************************************** ****************************/

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规 醚魄锅龋 -> 眠啊
@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



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

--************************************
-- 荤郴拌沥栏肺 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

BEGIN TRANSACTION

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

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
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 = -2
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. 肺弊牢惑怕咯何 眉农
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

[kasuma11]

thank you gonna try it now. Its been a while since i been in dekaron world. old DB user lmao!!!

I tried both the local.txt changed it from korea to global even tried HONGKONG still doesnt work so far and the script so far i still get the error. Thanks for trying.

[guesswho-.-]

start up profiler and see what info sessionserver sends to the db and what the result is. then go to the SP it called and edit it.

[kasuma11]

SESSION_SERVER_ID = 1100
SESSION_SERVER_PORT = 10000

WORLD_INDEX = 1

REGIST_DESKTOP = 0
REGIST_PK = 0
REGIST_MESSENGER = 0

LOG_PATH = LogFiles
BILLING = 0
NO_CHARGE_CODE = NODATA

DONATION_UPDATE = 1

NATIONALCODE = HONGKONG

CRC_ERROR_COUNT = 20
CRC_PENALTY_TICK = 1800000
CRC_BLACKLIST_USE_SWITCH = 1

this is what it shows in the config on session server

i left out the database login credits out lol

[Snaiil]

PM me, can help you

[guesswho-.-]

Originally Posted by kasuma11

SESSION_SERVER_ID = 1100
SESSION_SERVER_PORT = 10000

WORLD_INDEX = 1

REGIST_DESKTOP = 0
REGIST_PK = 0
REGIST_MESSENGER = 0

LOG_PATH = LogFiles
BILLING = 0
NO_CHARGE_CODE = NODATA

DONATION_UPDATE = 1

NATIONALCODE = HONGKONG

CRC_ERROR_COUNT = 20
CRC_PENALTY_TICK = 1800000
CRC_BLACKLIST_USE_SWITCH = 1

this is what it shows in the config on session server

i left out the database login credits out lol

this has nothing to do with what I said.

[kasuma11]

O LMAO, ok so whats profiler and i use this to find out which SP file in the stored procedure is pulling the information ?

[guesswho-.-]

sql profiler will tell you which server accesses what in SQL.
your goal is to see what is sessionserver accessing and which SP it's calling.

[kasuma11]

never used that before just opened it lol. basically its like wireshark sniffing packets, its just a real time log of whats going on on the server O.o

declare @p5 varchar(21)
set @p5=NULL
declare @p6 int
set @p6=NULL
declare @p7 int
set @p7=NULL
declare @p8 int
set @p8=NULL
declare @p9 varchar(21)
set @p9=NULL
declare @p10 varchar(21)
set @p10=NULL
declare @p11 varchar(6)
set @p11=NULL
declare @p12 int
set @p12=NULL
declare @p13 int
set @p13=NULL
declare @p14 int
set @p14=NULL
exec sp_acc_login 'dev','eb62f6b9306db575c2d596b1279627a4',1100,0xCF 90D76D,@p5 output,@p6 output,@p7 output,@p8 output,@p9 output,@p10 output,@p11 output,@p12 output,@p13 output,@p14 output
select @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @p13, @p14

so basically im wanting to look somewere in sp_acc_login ? and somthing is stoping login from there right

this is what is displayed

 Spoiler

USE [account]
GO
/****** Object: StoredProcedure [dbo].[SP_ACC_LOGIN] Script Date: 12/23/2014 00:40:39 ******/
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措惑.
-20 : DB Error
-21 : 促弗辑滚 肺弊牢吝
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
************************************************** ****************************/

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规 醚魄锅龋 -> 眠啊
@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



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

--************************************
-- 荤郴拌沥栏肺 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

BEGIN TRANSACTION

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

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
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 = -2
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. 肺弊牢惑怕咯何 眉农
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

also i noticed no matter what i try login with it says cannot use ID. even putting random letters as user and pass.

[guesswho-.-]

good I guess.
now copy the query and run it and see what the SP returns.
running a query will return something. it might say you're using too many arguments, or to few, I'm not gonna guess or look into your issue. once you solve that, the query should return a value, check the code for the value it returns and see under which conditions it gets returned.
I guess you'll be able to go alone from there

[kasuma11]

I parsed and executed it and it returns this and still doesn't change anything.

Command(s) completed successfully.

[baica123]

you try to edit the script/localedefine/locale.txt a global, korea or china . I hope it will work .

sorry for the english

[kasuma11]

Yea i have tried that to HONGKONG, KOREA, GLOBAL, and USA, i havnt tried china or japan guess i could try.......

[baica123]

sessionserver here

 Spoiler

SESSION_SERVER_ID = 20
SESSION_SERVER_PORT = 10000

WORLD_INDEX = 1

REGIST_DESKTOP = 0
REGIST_PK = 0
REGIST_MESSENGER = 0

LOG_PATH = .\LogFiles\
BILLING = 0
NO_CHARGE_CODE = NODATA

DONATION_UPDATE = 1

NATIONALCODE = HONGKONG

CRC_ERROR_COUNT = 20
CRC_PENALTY_TICK = 1800000
CRC_BLACKLIST_USE_SWITCH = 1

and locale you try to KOREA
ok