Question about CertifyAT_User

[silkroadgamer]

Hello guys,
I searched in BR Files Account SP and found the name dbo_CertifyAT_User so anyone know what it is?

thanks

[MentaL]

[silkroadgamer]

bump! anyone know any information about that? :|

[lemoniscool]

copy the content of the SP and paste it here
im not that familiar with BR files, neither do i have the DB atm but if you post it here i can tell you what it does.

btw what exactly do you want to know about it?

greetz

[silkroadgamer]

Here it is:

USE [SRO_VT_ACCOUNT]GO
/****** Object:  StoredProcedure [dbo].[_CertifyAT_User]    Script Date: 06/09/2014 08:21:40 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


-- 4. ALTER PROCEDURE _CertifyTB_User
ALTER PROCEDURE [dbo].[_CertifyAT_User]
     @szuserID    varchar(25),
    @szPassword    varchar(50)
AS






    if exists ( 
        select 
            '' 
        from _Punishment with ( nolock )
        where SerialNo = ( 
            select 
                max( SerialNo ) from _BlockedUser with ( nolock ) 
            where UserJID = ( SELECT JID FROM TB_User WHERE StrUserID =  @szuserID ) and 
                Type = 99 and getdate() between timeBegin and timeEnd ) )
    begin
        select convert( tinyint, 3), ( select JID from TB_User where StrUserID =  @szuserID ), convert( tinyint, 0), convert( tinyint, 0)


        return
    end
    if exists (select 1 from TB_User where StrUserID  @szuserID and block=1 and expired>=GETDATE())
    begin
        select convert( tinyint, 3), ( select JID from TB_User where StrUserID =  @szuserID ), convert( tinyint, 0), convert( tinyint, 0)
        return
    end
    /* if not exists (select 1 from TB_User where StrUserID  @szuserID and at=1)
    begin
        select convert( tinyint, 3), ( select JID from TB_User where StrUserID =  @szuserID ), convert( tinyint, 0), convert( tinyint, 0)
        return
    end */
    declare  @NuserJID int
    declare @sec_primary tinyint
    declare @sec_content tinyint


    set     @NuserJID        = 0
    set    @sec_primary        = 0
    set    @sec_content        = 0


-- @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
-- ?????? ?????????? ???????? ??????
    declare  @ApplyType            tinyint
    declare @AccPlayTime             int        
    declare  @LatestUpdateTime_ToPlayTime     int            


    set  @ApplyType                 = 0        -- ?????? ?????????? ???????? ?????????? ???????? ???? ?????????? ???? ??????
    set @AccPlayTime             = 0        
    set  @LatestUpdateTime_ToPlayTime     = 0  
-- @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@


-- ?????? ?????? ???? ????
--    select  @NuserJID = JID, @sec_primary = sec_primary, @sec_content = sec_content from TB_User


    SELECT  @NuserJID = JID, @sec_primary = sec_primary, @sec_content = sec_content
    , @AccPlayTime = AccPlayTime,  @LatestUpdateTime_ToPlayTime = LatestUpdateTime_ToPlayTime FROM TB_User
    WHERE StrUserID =  @szuserID and password = @szPassword 
    --and AT=1


-- Edit For fatigue system
-- Please, fill value to  @ApplyType ( 1 : TEEN USER , 2 : ADULT USER ) from your web database
-- ex )  @ApplyType = exec web.proc.certify


    if(  @NuserJID = 0 or  @NuserJID is null or @@error <> 0 or @@rowcount = 0)
    begin
-- ?????? ?????? ???? ????
--        select convert( tinyint, 1), convert( int, 0), convert( tinyint, 0), convert( tinyint, 0)
        select convert( tinyint, 1), convert( int, 0), convert( tinyint, 0), convert( tinyint, 0), convert(tinyint, 0), convert(int, 0), convert(int, 0)
        return
    end
    if( exists( select Type from _BlockedUser where UserJID =  @NuserJID and Type = 1 and getdate() between timeBegin and timeEnd))
    begin
-- ?????? ?????? ???? ????
--        select convert( tinyint, 3),  @NuserJID, convert( tinyint, 0), convert( tinyint, 0)
        select convert( tinyint, 3),  @NuserJID, convert( tinyint, 0), convert( tinyint, 0), convert(tinyint, 0), convert(int, 0), convert(int, 0)
        return
    end
-- ?????? ?????? ???? ????
--    select convert(tinyint, 0),  @NuserJID, @sec_primary, @sec_content
    select convert(tinyint, 0),  @NuserJID, @sec_primary, @sec_content,  @ApplyType, @AccPlayTime,  @LatestUpdateTime_ToPlayTime
    return

It look like CertifyTB_User but when i replace CertifyTB_User with this SP (ofc I changed the name from AT_User to TB_User) then login game, I got an C7 Error. So My question is how can I fix that C7 error from AT_User SP?

Hope you understand me :)

[lemoniscool]

what this SP does is basicly the same as CertifyTB_User .. checking a few values, if the user is blocked etc after that its fetching data about the user being a GM or not, then checking fatigue system values and then again fetching the data about the block of the user, if any

why do you want to replace VSRO CertifyTB_User with BR CertifyAT_User?
if its because you want to use BR gateway together with VSRO files, use the following code as CertifyTB_User SP:

USE [SRO_VT_ACCOUNT]
GO
/****** Object:  StoredProcedure [dbo].[_CertifyTB_User]    Script Date: 06/10/2014 10:18:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

-- 4. ALTER PROCEDURE _CertifyTB_User
ALTER PROCEDURE [dbo].[_CertifyTB_User]
 @szuserID	varchar(25),
	@szPassword	varchar(50)
AS



	if exists ( 
		select 
			'' 
		from _Punishment with ( nolock )
		where SerialNo = ( 
			select 
				max( SerialNo ) from _BlockedUser with ( nolock ) 
			where UserJID = ( SELECT JID FROM TB_User WHERE StrUserID = @szuserID ) and 
				Type = 99 and getdate() between timeBegin and timeEnd ) )
	begin
		select convert( tinyint, 3), ( select JID from TB_User where StrUserID = @szuserID ), convert( tinyint, 0), convert( tinyint, 0)

		return
	end

	declare @NuserJID int
	declare @sec_primary tinyint
	declare @sec_content tinyint

	set @NuserJID		= 0
	set	@sec_primary		= 0
	set	@sec_content		= 0

-- @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
-- ?????? ?????????? ???????? ??????
	declare @ApplyType			tinyint
	declare @AccPlayTime 			int        
	declare @LatestUpdateTime_ToPlayTime 	int        	

	set @ApplyType 				= 0		-- ?????? ?????????? ???????? ?????????? ???????? ???? ?????????? ???? ??????
	set @AccPlayTime 			= 0        
	set @LatestUpdateTime_ToPlayTime 	= 0  
-- @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

-- ?????? ?????? ???? ????
--	select @NuserJID = JID, @sec_primary = sec_primary, @sec_content = sec_content from TB_User

	SELECT @NuserJID = JID, @sec_primary = sec_primary, @sec_content = sec_content
	, @AccPlayTime = AccPlayTime, @LatestUpdateTime_ToPlayTime = LatestUpdateTime_ToPlayTime FROM TB_User
	WHERE StrUserID = @szuserID and password = @szPassword 
	--and AT=1

-- Edit For fatigue system
-- Please, fill value to @ApplyType ( 1 : TEEN USER , 2 : ADULT USER ) from your web database
-- ex ) @ApplyType = exec web.proc.certify

	if( @NuserJID = 0 or @NuserJID is null or @@error <> 0 or @@rowcount = 0)
	begin
-- ?????? ?????? ???? ????
		select convert( tinyint, 1), convert( int, 0), convert( tinyint, 0), convert( tinyint, 0)
		--select convert( tinyint, 1), convert( int, 0), convert( tinyint, 0), convert( tinyint, 0), convert(tinyint, 0), convert(int, 0), convert(int, 0)
		return
	end
	if( exists( select Type from _BlockedUser where UserJID = @NuserJID and Type = 1 and getdate() between timeBegin and timeEnd))
	begin
-- ?????? ?????? ???? ????
		select convert( tinyint, 3), @NuserJID, convert( tinyint, 0), convert( tinyint, 0)
		--select convert( tinyint, 3), @NuserJID, convert( tinyint, 0), convert( tinyint, 0), convert(tinyint, 0), convert(int, 0), convert(int, 0)
		return
	end
-- ?????? ?????? ???? ????
select convert(tinyint, 0), @NuserJID, @sec_primary, @sec_content
	--select convert(tinyint, 0), @NuserJID, @sec_primary, @sec_content, @ApplyType, @AccPlayTime, @LatestUpdateTime_ToPlayTime
	return

[silkroadgamer]

Yes I tried BR Gateways and I just dont understand what is CertifyAT_User used for? :|

[lemoniscool]

its called when a user is logging in, as i already said, its checking some data to see if the user is blocked or even existing etc