Could not find stored procedure 'dbo.atum_CheckLoginItemEvent'.
So, as I've checked everywhere, there isn't such procedure in the released source code of 4.2, nor 3.5. Even in both databases.
If someone have it could please pm me with it? Thank you
Printable View
Could not find stored procedure 'dbo.atum_CheckLoginItemEvent'.
So, as I've checked everywhere, there isn't such procedure in the released source code of 4.2, nor 3.5. Even in both databases.
If someone have it could please pm me with it? Thank you
Code:SE [atum2_db_1]
GO
/****** Object: StoredProcedure [dbo].[atum_CheckLoginItemEvent] Script Date: 5/5/2014 7:13:22 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-----------------------------------------
-----------------------------------------
-- 체크 프로시?E
-----------------------------------------
-----------------------------------------
CREATE PROC [dbo].[atum_CheckLoginItemEvent] --이벤트 횟수를 찾는 프로시?E횟수는 count로 체크한다.)
@i_EventUniqueNumber INT,
@i_AccountUniqueNumber INT
-- // 2009-02-17 by cmkwon, MARK for Yedang -- // 2008-09-04 by cmkwon, 예?E보안?E?숨?E계정 적?E하?ESQL Server 2005이상만 지원하는 기능) -
AS
BEGIN
--카웝獸로 반환
DECLARE @Check_completeCount INT, @Successcount INT
SELECT @Check_completeCount=CompleteFlag FROM atum2_db_account.dbo.td_LoginEvent WHERE EventUniqueNumber = @i_EventUniqueNumber and AccountUniqueNumber = @i_AccountUniqueNumber;
if(0 <> @Check_completeCount) -- 0이 아니?E카웝獸를 반환하?E안된다. -1이?E아이템을 지급한 것이다.
RETURN -10;
if(0 = @Check_completeCount) -- 0이?E카웝獸를 반환한다.
SELECT @Successcount=count(*) FROM atum2_db_account.dbo.td_LoginEvent WHERE EventUniqueNumber = @i_EventUniqueNumber and AccountUniqueNumber = @i_AccountUniqueNumber;
RETURN @Successcount;
END