i need help

08/15/2014 20:43 falconnnn#1
i wanna change login system. if i open char no one can dc me untill i log off that char(same id/pw). my friend can join only after i log off that id. i wanna this anyone can do this for me?
08/15/2014 20:56 RealChew#2
PS_UserData > Programmability > Stored Procedures > usp_Try_GameLogin_Taiwan

You should have this line :
Code:
SELECT @UserUID=UserUID, @Status=Status,@UseQueue=UseQueue, @Leave=Leave FROM Users_Master WHERE UserID = @UserID
Just complete by adding below :

Code:
IF( @Leave = 1)
BEGIN
	SET @Status = -7
END
08/26/2014 10:11 falconnnn#3
am i delete anywhere and
SELECT @UserUID=UserUID, @Status=Status, @Leave=Leave FROM Users_Master WHERE UserID = @UserID

-- NotExist User OR Leave User
IF( @UserUID = 0 OR @Leave = 1 )
BEGIN
SET @Status = -3
END
ELSE
BEGIN
-- Check Password
--EXEC OMG_GameWeb.dbo.sp_OmgLoginSuccessCheck @UserID, @InPassword, @Check output
IF ( @@ERROR = 0 )
BEGIN
IF( @Check <> 1 )
BEGIN
SET @Status = -1
END
END
ELSE
BEGIN
SET @Status = -1
END

SELECT @UserUID=UserUID,@ChPw=Pw FROM Users_Master WHERE UserID = @UserID

IF ( @InPassword <> @ChPw)
BEGIN
RETURN -1;
END


which line i add this
08/26/2014 14:05 RealChew#4
Code:
-- NotExist User OR Leave User
IF( @UserUID = 0 OR @Leave = 1 )
BEGIN
SET @Status = -3
END
The verification is already done in your stored procedure.
"OR @Leave = 1"

It's the same thing as what i said.

Be sur you have a working Leave column in your Users_Master table (if the account is active, Leave = 1, or if nobody is connected to it, Leave = 0)