Account does not exist (Leave=0)

[cypherxxl]

Hello dear Epvpers.

I got a very wired Problem.


None of my users can login to his Accound.

All seems Okay, but it isnt realy. (Account does not Exist)

/nptotectoff & /vchkoff is used.

here is a Screen of my Table that shows there is all ok.



Hope anyone can help me with this Problem.

[STIV123]

Hello,

Your problem is probably that you don't have Database "GM_Stuff".

I had this problem before, and adding "GM_Stuff" Database, It fixed it.

Just a suggestion.

(Btw, as I know, UserType=N, not 1.)

[cypherxxl]

GM_Stuff ?

I never hear about that Oo

[JohnHeatz]

GM_Stuff is just when you are using the release from Dash, else, it is not needed, as it is a completely custom database that was added to get some aspects of the adminCP to work properly

[cypherxxl]

I dont got this database.

Before i reinstalled my server all works great... hmm

[-FeaRs-]

Well i have the same prob , the first account i created was successful and next account , account does'nt exsist -.-

[..Zeus..]

Kalle Please Try this Query is my login Fix.

PHP Code:

USE [PS_UserData]
GO
/****** Objekt:  StoredProcedure [dbo].[usp_Try_GameLogin_Taiwan]    Skriptdatum: 04/23/2012 17:36:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO

/****** Object:  Stored Procedure dbo.usp_Try_GameLogin_Taiwan    Script Date: 2008-6-7 18:34:05 ******/

/*==================================================
@date    2007-12-04
@brief    Login Proc( Taiwan )
==================================================*/

ALTER  Proc [dbo].[usp_Try_GameLogin_Taiwan]

@UserID     varchar(18),
@InPassword    varchar(32),

@SessionID     bigint,
@UserIP     varchar(15),

-- ???? ??? ??, ???? ?? ??

@UserUID     int = 0,
@LoginType     smallint = 1, 
@LoginTime     datetime = NULL

AS

SET NOCOUNT ON

DECLARE 

@Leave         tinyint,
@Status         smallint,

@CompanyIP     varchar(15),
@TempIP     varchar(15),
@Check        int

SET @Status =         -1
SET @LoginTime =     GETDATE()

--------------------------------------------------
SET @CompanyIP =     '61.107.81'
SET @UserIP =        LTRIM( RTRIM(@UserIP) )
--------------------------------------------------
SET @Check = 0
--------------------------------------------------

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 dbo.sp_LoginSuccessCheck @UserID, @InPassword, @Check output
    IF ( @@ERROR = 0 )
    BEGIN
        IF( @Check <> 1 )
        BEGIN
            SET @Status = -1
        END
    END
    ELSE
    BEGIN
        SET @Status = -1
    END

    /* Old
    SET @InEnPassword = master.dbo.fn_md5(@InPassword)
    IF ( @InEnPassword <> @EnPassword )
    BEGIN
        SET @Status = -1
    END
    */
END

-- BlockUser Check
IF( (@Status >= 2) AND (@Status <= 6) )
BEGIN
    -- Get Block Limit Date AND Replace date text
    DECLARE @BlockEndDate datetime
    SELECT @BlockEndDate = BlockEndDate FROM Users_Block WHERE UserUID = @UserUID
    IF ( @@ROWCOUNT <> 0 )
    BEGIN
        -- Block Release
        IF ( @BlockEndDate <= @LoginTime )
        BEGIN
            SET @Status = 0
            UPDATE Users_Master SET Status = @Status WHERE UserUID = @UserUID
        END
    END
END

-- Admin IP Check(2006-02-21)
/*
IF( @Status = 16 OR @Status = 32 OR @Status = 48 OR @Status = 64 OR @Status = 80 )
BEGIN
    SET @TempIP = LEFT(@UserIP, 9)
    IF( @TempIP <> @CompanyIP )
    BEGIN
        SET @Status = -999
    END
END
*/

-- Select 
SELECT @Status AS Status, @UserUID AS UserUID

-- Log Insert
IF( @Status = 0 OR @Status = 16 OR @Status = 32 OR @Status = 48 OR @Status = 64 OR @Status = 80 )
BEGIN
    EXEC usp_Insert_LoginLog_E @SessionID=@SessionID, @UserUID=@UserUID, @UserIP=@UserIP, @LogType=0, @LogTime=@LoginTime, @LoginType=@LoginType
END
SET NOCOUNT OFF 


[cypherxxl]

what means this?

--------------------------------------------------
SET @CompanyIP = '61.107.81'
SET @UserIP = LTRIM( RTRIM(@UserIP) )
--------------------------------------------------

hm this query dont work for me.

[..Zeus..]

Try to reinstall the server or use a clean database

[cypherxxl]

oh nvm i got it allready.

Thank you.