Invalid ID and Password

04/24/2021 19:50 Bagon424#1
EP 4.5 DB
As Described i get following error when login to game, can anyone help me please?

Bagon
04/25/2021 03:52 kyoshiro3#2
Go learn nothing is free in this life
04/26/2021 15:57 blet93#3
see status players on data
04/27/2021 13:11 Bagon424#4
[Only registered and activated users can see links. Click Here To Register...]
04/27/2021 18:33 bogdanbosu#5
Quote:
Originally Posted by Bagon424 View Post
[Only registered and activated users can see links. Click Here To Register...]
use this query above to fix your column name "Rank"

04/27/2021 20:47 Bagon424#6
tyvm but i still cant login
04/27/2021 23:50 SnickQ#7
This is because your database requires OMG_GameWEB.dbo.GameAccountTBL
You can change this by open PS_UsersData--> programmability --> dbo.usp_Try_GameLogin_Taiwan and change line OMG_GameWeb to your account table.
Or You can change whole PS_UserData with EP 5+ Yes u can do this for ep 4
Or serch on forum usp_Try_GameLogin_Taiwan.
04/28/2021 11:19 Bagon424#8
now im getting account does not exist error
04/28/2021 17:14 SnickQ#9
For some reason you don't want to share information with us about this issue.
You figured "Hey guys, I have a problem" would be more than enough to solve your problem.
Possible solutions:
1 Check your Users_Masters that account exist there.
2
Quote:
USE [PS_UserData]
GO
/****** Object: StoredProcedure [dbo].[usp_Try_GameLogin_Taiwan] Script Date: 09/10/2011 01:45:17 ******/
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 = -1,
@LoginType smallint = 1,
@LoginTime datetime = NULL

AS

SET NOCOUNT ON

DECLARE



@Leave tinyint,
@Status smallint,

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

/*================================================= =
-1 Invalid ID and Password
-2 Can't connect with the account since it's not selected as free challenger
-3 Account doesn't exist
-4 ID inprocess of termination follwing user's request.
-5 Your account is blocked now. You can't log into the game.
-6 Your account is blocked now. You can't log into the game.
-7 Account still restricted
================================================== */

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], @LeaveDate=LeaveDate
FROM Users_Master
WHERE UserID = @UserID AND Pw = @InPassword

-- NotExist User OR Leave User
IF( @UserUID = 0)
BEGIN
SET @Status = -3
END
ELSE IF (@Leave = 1) --This blocks a logged in account from being kicked
BEGIN
SET @Status = -5
END
ELSE IF (DATEDIFF(SECOND, @LeaveDate, GETDATE()) < 6)--This is the time delay
BEGIN
SET @Status = -7
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
UPDATE Users_Master SET Leave = 1, JoinDate = GETDATE() WHERE UserUID = @UserUID
END
SET NOCOUNT OFF
04/28/2021 21:20 Bagon424#10
Quote:
Originally Posted by SnickQ View Post
For some reason you don't want to share information with us about this issue.
You figured "Hey guys, I have a problem" would be more than enough to solve your problem.
Possible solutions:
1 Check your Users_Masters that account exist there.
2
Invalid ID and PW
Just ask for mor informations
04/29/2021 22:10 SnickQ#11
Why i should ask for it? You should put it already.
Anyway if your users_Master account is corect and you run this query then you should check your game.exe IP
04/30/2021 09:22 Bagon424#12
Quote:
Originally Posted by SnickQ View Post
Why i should ask for it? You should put it already.
Anyway if your users_Master account is corect and you run this query then you should check your game.exe IP
Game.exe ip is 127.0.0.1
05/01/2021 02:09 Kyoshiro4#13
Quote:
Originally Posted by SnickQ View Post
Why i should ask for it? You should put it already.
Anyway if your users_Master account is corect and you run this query then you should check your game.exe IP
Wasting your time !
05/07/2021 20:17 Bagon424#14
Now ur help is very apporociated, i just get only that one error
05/08/2021 13:25 wurstbrot123#15
glad to see that "banned" :D
-1 troll for now :D

Good luck with your Server =)