Invalid ID and Password

[Bagon424]

EP 4.5 DB
As Described i get following error when login to game, can anyone help me please?

Bagon

[kyoshiro3]

Go learn nothing is free in this life

[blet93]

see status players on data

[Bagon424]

 Spoiler

2021-04-25 10:55:43 PS_DBAGENT__system log start (DBAgent01)

Module list:

C:\shaiyaserver\PSM_Client\Bin\ps_dbAgent.exe, loaded at 0x00400000 - 11/09/14 16:20:57

2021-04-25 10:55:45 ### Connect[2532] : Game[?][0x0106BBD8], Addr=127.0.0.1, DBJobEnd=1

2021-04-25 10:55:45 ### DB_SYSTEM_CONNECT[4768] :Game[1][0x0106BBD8], Name=Game01, Addr=127.0.0.1

2021-04-25 10:55:45 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Rank'., SQL STATE: 42S22, NATIVE ERROR: 207 (0xCF)

2021-04-25 10:55:45 LoadGuildList failed qerr=-1, EXEC usp_Read_Guild2_R

2021-04-25 10:55:45 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Rank'., SQL STATE: 42S22, NATIVE ERROR: 207 (0xCF)

2021-04-25 10:55:45 LoadGuildList failed qerr=-1, EXEC usp_Read_Guild2_R

2021-04-25 10:55:45 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Rank'., SQL STATE: 42S22, NATIVE ERROR: 207 (0xCF)

2021-04-25 10:55:45 LoadGuildList failed qerr=-1, EXEC usp_Read_Guild2_R

[bogdanbosu]

Originally Posted by Bagon424

 Spoiler

2021-04-25 10:55:43 PS_DBAGENT__system log start (DBAgent01)

Module list:

C:\shaiyaserver\PSM_Client\Bin\ps_dbAgent.exe, loaded at 0x00400000 - 11/09/14 16:20:57

2021-04-25 10:55:45 ### Connect[2532] : Game[?][0x0106BBD8], Addr=127.0.0.1, DBJobEnd=1

2021-04-25 10:55:45 ### DB_SYSTEM_CONNECT[4768] :Game[1][0x0106BBD8], Name=Game01, Addr=127.0.0.1

2021-04-25 10:55:45 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Rank'., SQL STATE: 42S22, NATIVE ERROR: 207 (0xCF)

2021-04-25 10:55:45 LoadGuildList failed qerr=-1, EXEC usp_Read_Guild2_R

2021-04-25 10:55:45 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Rank'., SQL STATE: 42S22, NATIVE ERROR: 207 (0xCF)

2021-04-25 10:55:45 LoadGuildList failed qerr=-1, EXEC usp_Read_Guild2_R

2021-04-25 10:55:45 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Rank'., SQL STATE: 42S22, NATIVE ERROR: 207 (0xCF)

2021-04-25 10:55:45 LoadGuildList failed qerr=-1, EXEC usp_Read_Guild2_R

use this query above to fix your column name "Rank"

 Spoiler

USE [PS_GameData]
GO
/****** Object: StoredProcedure [dbo].[usp_Read_Guild2_R]******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO






ALTER Proc [dbo].[usp_Read_Guild2_R]

AS

SET NOCOUNT ON

SELECT G.GuildID, G.GuildName, G.MasterName, G.Country, G.GuildPoint,
ISNULL(H.[Rank],31) [Rank], ISNULL(H.Etin,0) Etin, ISNULL(H.UseHouse,0) UseHouse, ISNULL(H.Remark, '') Remark, ISNULL( H.BuyHouse,0) BuyHouse, ISNULL(H.EtinReturnCnt, 0 ) EtinReturnCnt, ISNULL(H.KeepEtin, 0) KeepEtin
FROM Guilds G
LEFT OUTER JOIN GuildDetails H ON G.GuildID = H.GuildID
WHERE G.Del=0
ORDER BY H.[Rank] DESC

SET NOCOUNT OFF

[Bagon424]

tyvm but i still cant login

[SnickQ]

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.

[Bagon424]

now im getting account does not exist error

[SnickQ]

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

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

[Bagon424]

Originally Posted by SnickQ

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

[SnickQ]

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

[Bagon424]

Originally Posted by SnickQ

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

[Kyoshiro4]

Originally Posted by SnickQ

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 !

[Bagon424]

Now ur help is very apporociated, i just get only that one error

[wurstbrot123]

glad to see that "banned"
-1 troll for now

Good luck with your Server =)