USE [SA_BETA_TRADEDB_0002]
GO
/****** Object:  StoredProcedure [PaGamePublic].[uspIsGameMaster__XXX]    Script Date: 07.09.2022 11:18:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [PaGamePublic].[uspIsGameMaster__XXX]
    -- @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
    --Declare @nationCode INT = 12

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

    -- 없으면 거래소 이용 불가한 상태
    /*
    SELECT
        @isGameMaster = _isGameMaster
        FROM PaGamePrivate.TblWorldMarketWalletInfo
        /*
        WHERE    _nationCode = @nationCode
            AND _serverNo   = @serverNo
            AND _userNo     = @userNo
        */
        WHERE _userNo = @userNo
        IF (1 <> @@ROWCOUNT)
     BEGIN
        SET @isGameMaster   = 0
     END
     */

    SET @isGameMaster = N'0'
    SET @rv = N'0'
    SET @symNo = N''
    IF ISNULL(@isGameMaster,0) <= (SELECT _isGameMaster FROM PaGamePrivate.TblWorldMarketWalletInfo 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