EP8 Invalid id or password

[Remarks24]

How to fix this ? im using ep8 server files and database

[balongskie123]

.

[Remarks24]

Originally Posted by failpvper

try admin admin123

shaiya shaiya123 is the default sql login. not your game login.

i know but even it matches the account in my user data still get this error

[Remarks24]

Originally Posted by failpvper

make another account and try...

if it doesn't work, would you mind posting that row of data in the user table, and your login procedure?

this is my gamelogin taiwan

 Spoiler

USE [PS_UserData]
GO
/****** Object: StoredProcedure [dbo].[usp_Try_GameLogin_Taiwan] Script Date: 10/13/2019 03:08:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
ALTER Proc [dbo].[usp_Try_GameLogin_Taiwan]

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

@SessionID bigint,
@ varchar(15),


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

AS

SET NOCOUNT ON

DECLARE

@Leave tinyint,
@ smallint,

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

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

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

SELECT @ID=[UserUID], @=[Status], @Leave=[Leave], @LeaveDate=LeaveDate
FROM Users_Master
WHERE UserID = @


IF( @ID = 0 OR @Leave = 1 )
BEGIN
SET @ = -2
END
ELSE
BEGIN

EXEC dbo.sp_LoginSuccessCheck @, @InPassword, @Check output
IF ( @@ERROR = 0 )
BEGIN
IF( @Check <> 1 )
BEGIN
SET @ = -1
END
END
ELSE
BEGIN
SET @ = -1
END


END






IF( @ >= 2) AND @ <= 6) )
BEGIN

DECLARE @BlockEndDate datetime
SELECT @BlockEndDate = BlockEndDate FROM Users_Block WHERE UserUID = @ID
IF ( @@ROWCOUNT <> 0 )
BEGIN

IF ( @BlockEndDate <= @LoginTime )
BEGIN
SET @ = 0
UPDATE Users_Master SET Status = @ WHERE UserUID = @ID
END
END
END

SELECT @ AS Status, @ID AS UserUID

IF( @ = 0 OR @ = 16 OR @ = 32 OR @ = 48 OR @ = 64 OR @ = 80 )
BEGIN
EXEC usp_Insert_LoginLog_E @SessionID=@SessionID, @ID @ID, @ @, @LogType=0, @LogTime=@LoginTime, @LoginType=@LoginType
if @id=(select useruid from PS_userdata.dbo.UserLoginStatus
where useruid @id)
update PS_userdata.dbo.UserLoginStatus
set loginstatus=1,LoginTime=@LoginTime,LogoutTime=@Log inTime,loginSession=@SessionID,lastplaytime=0
where useruid @id
else
insert into PS_userdata.dbo.UserLoginStatus(useruid,userid,log instatus,logintime,logouttime,loginsession,lastpla ytime) values @id @,1,@LoginTime,@LoginTime,@SessionID,0)
END

IF( @ID = 0)
BEGIN
SET @ = 9
END
ELSE IF (@Leave = 1)
BEGIN
SET @ = -5
END
ELSE IF (DATEDIFF(SECOND, @LeaveDate, GETDATE()) < 6)
BEGIN
SET @ = -7
END




SELECT @ AS Status, @ID AS UserUID

IF( @ = 0 OR @ = 16 OR @ = 32 OR @ = 48 OR @ = 64 OR @ = 80 )
BEGIN
UPDATE Users_Master SET Leave = 0, JoinDate = GETDATE() WHERE UserUID = @ID



--送东西
if @id in (select useruid from ps_gamedata.dbo.offlinesend)
begin
exec ps_gamedata.dbo.rusend @id @id
END










END
SET NOCOUNT OFF

and there is also gamelogi korea idk if this is needed

 Spoiler

USE [PS_UserData]
GO
/****** Object: StoredProcedure [dbo].[usp_try_gamelogin_korea] Script Date: 10/13/2019 03:11:19 ******/
SET ANSI_NULLS OFF
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_korea]

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

@SessionID bigint,
@ varchar(15),

-- 罹晦梱雖 蹂 檣濠, 釭該雖朝 頂睡 滲熱

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

AS

SET NOCOUNT ON

DECLARE

@Leave tinyint,
@ smallint,

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

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

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

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

-- NotExist User OR Leave User
IF( @ID = 0 OR @Leave = 1 )
BEGIN
SET @ = -3
END
ELSE
BEGIN

-- Check Password
EXEC dbo.sp_LoginSuccessCheck @, @InPassword, @Check output
IF ( @@ERROR = 0 )
BEGIN
IF( @Check <> 1 )
BEGIN
SET @ = -1
END
END
ELSE
BEGIN
SET @ = -1
END

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

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

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

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

-- Log Insert
IF( @ = 0 OR @ = 16 OR @ = 32 OR @ = 48 OR @ = 64 OR @ = 80 )
BEGIN
EXEC usp_Insert_LoginLog_E @SessionID=@SessionID, @ID @ID, @ @, @LogType=0, @LogTime=@LoginTime, @LoginType=@LoginType
--送东西
if @id in (select useruid from ps_gamedata.dbo.offlinesend)
begin
exec ps_gamedata.dbo.rusend @id @id
END

END
SET NOCOUNT OFF

[balongskie123]

.

[Remarks24]

i also tried to use ep6.4 and ep5.4 ps_userdata and still not working

[Remarks24]

Msg 102, Level 15, State 1, Procedure usp_Try_GameLogin_Taiwan, Line 33
Incorrect syntax near '@userip'.
Msg 102, Level 15, State 1, Procedure usp_Try_GameLogin_Taiwan, Line 67
Incorrect syntax near ')'.
Msg 102, Level 15, State 1, Procedure usp_Try_GameLogin_Taiwan, Line 83
Incorrect syntax near '@UserUID'.
Msg 137, Level 15, State 2, Procedure usp_Try_GameLogin_Taiwan, Line 86
Must declare the scalar variable "@Log".
Msg 102, Level 15, State 1, Procedure usp_Try_GameLogin_Taiwan, Line 89
Incorrect syntax near 'instatus'.
Msg 102, Level 15, State 1, Procedure usp_Try_GameLogin_Taiwan, Line 114
Incorrect syntax near '@UserUID'.


I use 2008 sql

[Remarks24]

Originally Posted by failpvper

try the one in this text file. if it doesn't work, upload your PS_UserData (MDF and LDF) and i'll fix it. also, upload the PS_GameData.dbo.OfflineSend table and the PS_GameData.dbo.rusend procedure so i can test it fully. i'm not using an EP8 database, so i don't have those. all you have to do is right click them, choose "script as", choose "create to" and copy/paste them to a text file.

not working

ps_gamedata.dbo.offlinesend

 Spoiler

USE [PS_GameData]
GO

/****** Object: Table [dbo].[offlinesend] Script Date: 10/13/2019 23:20:57 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[offlinesend](
[rowid] [int] IDENTITY(1,1) NOT NULL,
[useruid] [int] NULL,
[charid] [int] NULL,
[itemid] [int] NULL,
[count] [int] NULL,
[gem1] [int] NULL,
[gem2] [int] NULL,
[gem3] [int] NULL,
[gem4] [int] NULL,
[gem5] [int] NULL,
[gem6] [int] NULL,
[craftname] [varchar](50) NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

dbo.rusend

 Spoiler

USE [PS_GameData]
GO

/****** Object: StoredProcedure [dbo].[rusend] Script Date: 10/13/2019 23:25:39 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

create Proc [dbo].[rusend]
@id int
as
declare @ int,@bag int @ int @ tinyint @id tinyint,@charid int,@itemid bigint,@count tinyint,@gem1 tinyint,@gem2 tinyint,@gem3 tinyint,@gem4 tinyint,@gem5 tinyint,@gem6 tinyint,@craftname varchar(20),@itemuid bigint
set @bag=1
declare tmp cursor for select rowid from ps_gamedata.dbo.offlinesend where useruid @id
open tmp
declare @d int
Fetch Next From tmp Into @d
while @@fetch_status=0
begin
select @charid=charid,@itemid=itemid,@count=[count],@gem1=gem1,@gem2=gem2,@gem3=gem3,@gem4=gem4,@gem5 =gem5,@gem6=gem6,@craftname=craftname from ps_gamedata.dbo.offlinesend where useruid @id and rowid @d
select @=type @id=typeid from ps_gamedefs.dbo.items where itemid=@itemid
while @bag<=5
begin
set @=0
while @ <=23
begin
if not exists (select * from ps_gamedata.dbo.charitems where bag=@bag and slot @ and charid=@charid)
begin
insert into ps_gamedata.dbo.uidnumber(num)values('1')
set @itemuid=SCOPE_IDENTITY()
insert into charitems(charid,itemid,itemuid,type,typeid,bag,sl ot,quality,gem1,gem2,gem3,gem4,gem5,gem6,craftname ,[count],maketime,maketype,del)values(@charid,@itemid,@ite muid @ @id,@bag @,0,@gem1,@gem2,@gem3,@gem4,@gem5,@gem6,@craftname, @count,getdate(),'s','0')
delete ps_gamedata.dbo.offlinesend where rowid @d
goto skip
end
set @ @+1
end
set @bag=@bag+1
end
skip:
Fetch Next From tmp Into @d
end
close tmp
deallocate tmp

GO

[Remarks24]

there you go

 Spoiler

USE [PS_GameData]
GO

/****** Object: Table [dbo].[uidnumber] Script Date: 10/13/2019 23:39:22 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[uidnumber](
[Rowid] [bigint] IDENTITY(3400000000000000001,1) NOT NULL,
[num] [char](1) NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

[Remarks24]

still get the same error hehe, I can send the database I use if you want

[superklamus]

Try to use, MD5 has your password.

[Shaiya Galaxy]

Originally Posted by superklamus

Try to use, MD5 has your password.

Yeah and i keep searching on how to convert the MD5 Password

[MC Flip]

I was able to remove the MD5 hash conversion (or at least I think I did), just to be presented with Error10053 or Account doesn't exist after that and I'm stuck at this point.

[superklamus]

Originally Posted by Shaiya Galaxy

Yeah and i keep searching on how to convert the MD5 Password

Not a problem:

[Shaiya Galaxy]

Yeah3x, sorry for bumping this post but i already fixed it.

CONCLUSION:
EP8 is a dream