USE [Account]
GO
/****** Object: StoredProcedure [dbo].[cabal_sp_sub_Password_PW_Check] Script Date: 07.03.2016 19:51:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[cabal_sp_sub_Password_PW_Check]
(
You must be registered to see links
int, @pwKind int,
You must be registered to see links
varchar(10),
You must be registered to see links
int = -1)
AS
begin
SET NOCOUNT ON
set @password=@password
DECLARE @SavedPassword [varbinary](72)
DECLARE @SPwd [varbinary](72)
DECLARE @SPass[varchar](72)
set @SPass='PIN CODE'
set @SPwd=pwdencrypt(
You must be registered to see links
)
if(@pwKind = 1)
begin
SELECT @SavedPassword = CharPassword
FROM cabal_sub_password_table WITH(NOLOCK)
WHERE userNum =
You must be registered to see links
end
else if(@pwKind = 2)
begin
SELECT @SavedPassword = WareHousePassword
FROM cabal_sub_password_table WITH(NOLOCK)
WHERE userNum =
You must be registered to see links
end
else if(@pwKind = 3)
begin
SELECT @SavedPassword = EquipmentPassword
FROM cabal_sub_password_table WITH(NOLOCK)
WHERE userNum =
You must be registered to see links
end
if (PWDCOMPARE(
You must be registered to see links
, @SPwd) = 1) or (PWDCOMPARE(
You must be registered to see links
, @SavedPassword) = 1)
begin
IF
You must be registered to see links
<> -1
BEGIN
if(@pwKind = 2)
begin
update cabal_sub_password_table
set WareHouseLock =
You must be registered to see links
where userNum =
You must be registered to see links
end
else if(@pwKind = 3)
begin
update cabal_sub_password_table
set EquipmentLock =
You must be registered to see links
where userNum =
You must be registered to see links
end
END
select 1,
You must be registered to see links
end else
IF @@ROWCOUNT = 0 or PWDCOMPARE(
You must be registered to see links
, @SavedPassword) <> 1
begin
select 0
end
SET NOCOUNT OFF
end
