EP8 Invalid id or password

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]

@[Only registered and activated users can see links. Click Here To Register...] varchar(18),
@InPassword varchar(32),

@SessionID bigint,
@[Only registered and activated users can see links. Click Here To Register...] varchar(15),


@[Only registered and activated users can see links. Click Here To Register...]ID int = 0,
@LoginType smallint = 1,
@LoginTime datetime = NULL

AS

SET NOCOUNT ON

DECLARE

@Leave tinyint,
@[Only registered and activated users can see links. Click Here To Register...] smallint,

@CompanyIP varchar(15),
@[Only registered and activated users can see links. Click Here To Register...]P varchar(15),
@Check int,
@LeaveDate datetime

SET @[Only registered and activated users can see links. Click Here To Register...] = -1
SET @LoginTime = GETDATE()

--------------------------------------------------
SET @CompanyIP = '127.0.0.1'
SET @[Only registered and activated users can see links. Click Here To Register...] = LTRIM( RTRIM @[Only registered and activated users can see links. Click Here To Register...]) )
--------------------------------------------------
SET @Check = 0
--------------------------------------------------

SELECT @[Only registered and activated users can see links. Click Here To Register...]ID=[UserUID], @[Only registered and activated users can see links. Click Here To Register...]=[Status], @Leave=[Leave], @LeaveDate=LeaveDate
FROM Users_Master
WHERE UserID = @[Only registered and activated users can see links. Click Here To Register...]


IF( @[Only registered and activated users can see links. Click Here To Register...]ID = 0 OR @Leave = 1 )
BEGIN
SET @[Only registered and activated users can see links. Click Here To Register...] = -2
END
ELSE
BEGIN

EXEC dbo.sp_LoginSuccessCheck @[Only registered and activated users can see links. Click Here To Register...], @InPassword, @Check output
IF ( @@ERROR = 0 )
BEGIN
IF( @Check <> 1 )
BEGIN
SET @[Only registered and activated users can see links. Click Here To Register...] = -1
END
END
ELSE
BEGIN
SET @[Only registered and activated users can see links. Click Here To Register...] = -1
END


END






IF( @[Only registered and activated users can see links. Click Here To Register...] >= 2) AND @[Only registered and activated users can see links. Click Here To Register...] <= 6) )
BEGIN

DECLARE @BlockEndDate datetime
SELECT @BlockEndDate = BlockEndDate FROM Users_Block WHERE UserUID = @[Only registered and activated users can see links. Click Here To Register...]ID
IF ( @@ROWCOUNT <> 0 )
BEGIN

IF ( @BlockEndDate <= @LoginTime )
BEGIN
SET @[Only registered and activated users can see links. Click Here To Register...] = 0
UPDATE Users_Master SET Status = @[Only registered and activated users can see links. Click Here To Register...] WHERE UserUID = @[Only registered and activated users can see links. Click Here To Register...]ID
END
END
END

SELECT @[Only registered and activated users can see links. Click Here To Register...] AS Status, @[Only registered and activated users can see links. Click Here To Register...]ID AS UserUID

IF( @[Only registered and activated users can see links. Click Here To Register...] = 0 OR @[Only registered and activated users can see links. Click Here To Register...] = 16 OR @[Only registered and activated users can see links. Click Here To Register...] = 32 OR @[Only registered and activated users can see links. Click Here To Register...] = 48 OR @[Only registered and activated users can see links. Click Here To Register...] = 64 OR @[Only registered and activated users can see links. Click Here To Register...] = 80 )
BEGIN
EXEC usp_Insert_LoginLog_E @SessionID=@SessionID, @[Only registered and activated users can see links. Click Here To Register...]ID @[Only registered and activated users can see links. Click Here To Register...]ID, @[Only registered and activated users can see links. Click Here To Register...] @[Only registered and activated users can see links. Click Here To Register...], @LogType=0, @LogTime=@LoginTime, @LoginType=@LoginType
if @[Only registered and activated users can see links. Click Here To Register...]id=(select useruid from PS_userdata.dbo.UserLoginStatus
where useruid @[Only registered and activated users can see links. Click Here To Register...]id)
update PS_userdata.dbo.UserLoginStatus
set loginstatus=1,LoginTime=@LoginTime,LogoutTime=@Log inTime,loginSession=@SessionID,lastplaytime=0
where useruid @[Only registered and activated users can see links. Click Here To Register...]id
else
insert into PS_userdata.dbo.UserLoginStatus(useruid,userid,log instatus,logintime,logouttime,loginsession,lastpla ytime) values @[Only registered and activated users can see links. Click Here To Register...]id @[Only registered and activated users can see links. Click Here To Register...],1,@LoginTime,@LoginTime,@SessionID,0)
END

IF( @[Only registered and activated users can see links. Click Here To Register...]ID = 0)
BEGIN
SET @[Only registered and activated users can see links. Click Here To Register...] = 9
END
ELSE IF (@Leave = 1)
BEGIN
SET @[Only registered and activated users can see links. Click Here To Register...] = -5
END
ELSE IF (DATEDIFF(SECOND, @LeaveDate, GETDATE()) < 6)
BEGIN
SET @[Only registered and activated users can see links. Click Here To Register...] = -7
END




SELECT @[Only registered and activated users can see links. Click Here To Register...] AS Status, @[Only registered and activated users can see links. Click Here To Register...]ID AS UserUID

IF( @[Only registered and activated users can see links. Click Here To Register...] = 0 OR @[Only registered and activated users can see links. Click Here To Register...] = 16 OR @[Only registered and activated users can see links. Click Here To Register...] = 32 OR @[Only registered and activated users can see links. Click Here To Register...] = 48 OR @[Only registered and activated users can see links. Click Here To Register...] = 64 OR @[Only registered and activated users can see links. Click Here To Register...] = 80 )
BEGIN
UPDATE Users_Master SET Leave = 0, JoinDate = GETDATE() WHERE UserUID = @[Only registered and activated users can see links. Click Here To Register...]ID



--送东西
if @[Only registered and activated users can see links. Click Here To Register...]id in (select useruid from ps_gamedata.dbo.offlinesend)
begin
exec ps_gamedata.dbo.rusend @[Only registered and activated users can see links. Click Here To Register...]id @[Only registered and activated users can see links. Click Here To Register...]id
END










END
SET NOCOUNT OFF

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]

@[Only registered and activated users can see links. Click Here To Register...] varchar(18),
@InPassword varchar(32),

@SessionID bigint,
@[Only registered and activated users can see links. Click Here To Register...] varchar(15),

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

@[Only registered and activated users can see links. Click Here To Register...]ID int = 0,
@LoginType smallint = 1,
@LoginTime datetime = NULL

AS

SET NOCOUNT ON

DECLARE

@Leave tinyint,
@[Only registered and activated users can see links. Click Here To Register...] smallint,

@CompanyIP varchar(15),
@[Only registered and activated users can see links. Click Here To Register...]P varchar(15),
@Check int

SET @[Only registered and activated users can see links. Click Here To Register...] = -1
SET @LoginTime = GETDATE()

--------------------------------------------------
SET @CompanyIP = '61.107.81'
SET @[Only registered and activated users can see links. Click Here To Register...] = LTRIM( RTRIM @[Only registered and activated users can see links. Click Here To Register...]) )
--------------------------------------------------
SET @Check = 0
--------------------------------------------------

SELECT @[Only registered and activated users can see links. Click Here To Register...]ID=UserUID, @[Only registered and activated users can see links. Click Here To Register...]=Status, @Leave=Leave FROM Users_Master WHERE UserID = @[Only registered and activated users can see links. Click Here To Register...]

-- NotExist User OR Leave User
IF( @[Only registered and activated users can see links. Click Here To Register...]ID = 0 OR @Leave = 1 )
BEGIN
SET @[Only registered and activated users can see links. Click Here To Register...] = -3
END
ELSE
BEGIN

-- Check Password
EXEC dbo.sp_LoginSuccessCheck @[Only registered and activated users can see links. Click Here To Register...], @InPassword, @Check output
IF ( @@ERROR = 0 )
BEGIN
IF( @Check <> 1 )
BEGIN
SET @[Only registered and activated users can see links. Click Here To Register...] = -1
END
END
ELSE
BEGIN
SET @[Only registered and activated users can see links. Click Here To Register...] = -1
END

/* Old
SET @InEnPassword = master.dbo.fn_md5(@InPassword)
IF ( @InEnPassword <> @EnPassword )
BEGIN
SET @[Only registered and activated users can see links. Click Here To Register...] = -1
END
*/
END

-- BlockUser Check
IF( @[Only registered and activated users can see links. Click Here To Register...] >= 2) AND @[Only registered and activated users can see links. Click Here To Register...] <= 6) )
BEGIN
-- Get Block Limit Date AND Replace date text
DECLARE @BlockEndDate datetime
SELECT @BlockEndDate = BlockEndDate FROM Users_Block WHERE UserUID = @[Only registered and activated users can see links. Click Here To Register...]ID
IF ( @@ROWCOUNT <> 0 )
BEGIN
-- Block Release
IF ( @BlockEndDate <= @LoginTime )
BEGIN
SET @[Only registered and activated users can see links. Click Here To Register...] = 0
UPDATE Users_Master SET Status = @[Only registered and activated users can see links. Click Here To Register...] WHERE UserUID = @[Only registered and activated users can see links. Click Here To Register...]ID
END
END
END

-- Admin IP Check(2006-02-21)
/*
IF( @[Only registered and activated users can see links. Click Here To Register...] = 16 OR @[Only registered and activated users can see links. Click Here To Register...] = 32 OR @[Only registered and activated users can see links. Click Here To Register...] = 48 OR @[Only registered and activated users can see links. Click Here To Register...] = 64 OR @[Only registered and activated users can see links. Click Here To Register...] = 80 )
BEGIN
SET @[Only registered and activated users can see links. Click Here To Register...]P = LEFT @[Only registered and activated users can see links. Click Here To Register...], 9)
IF( @[Only registered and activated users can see links. Click Here To Register...]P <> @CompanyIP )
BEGIN
SET @[Only registered and activated users can see links. Click Here To Register...] = -999
END
END
*/

-- Select
SELECT @[Only registered and activated users can see links. Click Here To Register...] AS Status, @[Only registered and activated users can see links. Click Here To Register...]ID AS UserUID

-- Log Insert
IF( @[Only registered and activated users can see links. Click Here To Register...] = 0 OR @[Only registered and activated users can see links. Click Here To Register...] = 16 OR @[Only registered and activated users can see links. Click Here To Register...] = 32 OR @[Only registered and activated users can see links. Click Here To Register...] = 48 OR @[Only registered and activated users can see links. Click Here To Register...] = 64 OR @[Only registered and activated users can see links. Click Here To Register...] = 80 )
BEGIN
EXEC usp_Insert_LoginLog_E @SessionID=@SessionID, @[Only registered and activated users can see links. Click Here To Register...]ID @[Only registered and activated users can see links. Click Here To Register...]ID, @[Only registered and activated users can see links. Click Here To Register...] @[Only registered and activated users can see links. Click Here To Register...], @LogType=0, @LogTime=@LoginTime, @LoginType=@LoginType
--送东西
if @[Only registered and activated users can see links. Click Here To Register...]id in (select useruid from ps_gamedata.dbo.offlinesend)
begin
exec ps_gamedata.dbo.rusend @[Only registered and activated users can see links. Click Here To Register...]id @[Only registered and activated users can see links. Click Here To Register...]id
END

END
SET NOCOUNT OFF

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

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]
@[Only registered and activated users can see links. Click Here To Register...]id int
as
declare @[Only registered and activated users can see links. Click Here To Register...] int,@bag int @[Only registered and activated users can see links. Click Here To Register...] int @[Only registered and activated users can see links. Click Here To Register...] tinyint @[Only registered and activated users can see links. Click Here To Register...]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 @[Only registered and activated users can see links. Click Here To Register...]id
open tmp
declare @[Only registered and activated users can see links. Click Here To Register...]d int
Fetch Next From tmp Into @[Only registered and activated users can see links. Click Here To Register...]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 @[Only registered and activated users can see links. Click Here To Register...]id and rowid @[Only registered and activated users can see links. Click Here To Register...]d
select @[Only registered and activated users can see links. Click Here To Register...]=type @[Only registered and activated users can see links. Click Here To Register...]id=typeid from ps_gamedefs.dbo.items where itemid=@itemid
while @bag<=5
begin
set @[Only registered and activated users can see links. Click Here To Register...]=0
while @[Only registered and activated users can see links. Click Here To Register...] <=23
begin
if not exists (select * from ps_gamedata.dbo.charitems where bag=@bag and slot @[Only registered and activated users can see links. Click Here To Register...] 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 @[Only registered and activated users can see links. Click Here To Register...] @[Only registered and activated users can see links. Click Here To Register...]id,@bag @[Only registered and activated users can see links. Click Here To Register...],0,@gem1,@gem2,@gem3,@gem4,@gem5,@gem6,@craftname, @count,getdate(),'s','0')
delete ps_gamedata.dbo.offlinesend where rowid @[Only registered and activated users can see links. Click Here To Register...]d
goto skip
end
set @[Only registered and activated users can see links. Click Here To Register...] @[Only registered and activated users can see links. Click Here To Register...]+1
end
set @bag=@bag+1
end
skip:
Fetch Next From tmp Into @[Only registered and activated users can see links. Click Here To Register...]d
end
close tmp
deallocate tmp

GO

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