USE [SA_BETA_WORLDDB_0002]
GO
/****** Object:  StoredProcedure [PaGamePublic].[uspIsGameMaster]    Script Date: 07.09.2022 11:37:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [PaGamePublic].[uspIsGameMaster]
    -- @nationCode      INT
        @rv             INT     OUTPUT
     ,@symNo            NVARCHAR(50)    OUTPUT
    ,@userNo            BIGINT
    ,@isGameMaster      BIT     OUTPUT
AS
/*!
 *  \brief      지엠인지 체크
 */
BEGIN
    SET NOCOUNT ON                                      -- Count-set결과를생성하지말아라.
    SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
    SET LOCK_TIMEOUT 3000                               -- 함부로변경금지, 변경필요시DBA와협의.
    SET XACT_ABORT ON

    -- DECLARE @rv      INT = 0


    /**********************************************************************************************
    ** 작업시작(이하에만기술)
    **********************************************************************************************/
    --BEGIN TRAN uspIsGameMaster__XXX_Tx1

    -- 없으면 거래소 이용 불가한 상태
    -- SELECT
    --  @isGameMaster = ISNULL(_isGameMaster,'true')
    --  FROM PaGamePrivate.TblWorldMarketWalletInfo
    --  WHERE   _nationCode = @nationCode
    --      AND _serverNo   = @serverNo
    --      AND _userNo     = @userNo

    -- SELECT
        -- @isGameMaster = ISNULL(_RoleGroupNo,0)
        -- FROM PaGamePrivate.TblRoleGroupMember
        -- WHERE _userNo = @userNo
    -- IF (1 <> @@ROWCOUNT)
    SET @isGameMaster = N'0'
    SET @rv = N'0'
    SET @symNo = N''
    IF ISNULL(@isGameMaster,0) <= (SELECT _RoleGroupNo FROM PaGamePrivate.TblRoleGroupMember WHERE _userNo = @userNo)
        BEGIN
            SET @isGameMaster = N'1'
            RETURN @isGameMaster
        END
    ELSE
        BEGIN
            SET @isGameMaster = N'0'
            RETURN @isGameMaster
        END

    /**********************************************************************************************
    ** 작업종료(이상에만기술)
    **********************************************************************************************/
LABEL_END:
    /*
    IF(0 = @rv)
     BEGIN
        COMMIT TRAN
     END
    ELSE
     BEGIN
        ROLLBACK TRAN
     END
    */
    --RETURN(@rv)
END