i need help

[falconnnn]

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?

[RealChew]

PS_UserData > Programmability > Stored Procedures > usp_Try_GameLogin_Taiwan

You should have this line :

SELECT @UserUID=UserUID, @Status=Status,@UseQueue=UseQueue, @Leave=Leave FROM Users_Master WHERE UserID = @UserID

Just complete by adding below :

IF( @Leave = 1)
BEGIN
	SET @Status = -7
END

[falconnnn]

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

[RealChew]

-- 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)