5$
HTML Code:
USE [ND_GAME_0]
GO
/****** Object: StoredProcedure [dbo].[pr_DS_RandomBox_Get] Script Date: 10/5/2024 6:36:56 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROC [dbo].[pr_DS_RandomBox_Get]
[MENTION=3613419]cui[/MENTION]d int
, [MENTION=955363]rank[/MENTION] smallint
AS
SET NOCOUNT ON
IF EXISTS (SELECT 1 FROM ND_V03_RandomBox WHERE cuid = [MENTION=3613419]cui[/MENTION]d and rank = [MENTION=955363]rank[/MENTION])
SELECT cuid, rank, nBonusCount, nBonusIndex, checkNumber1, isLock1, checkNumber2, isLock2, checkNumber3, isLock3
FROM ND_V03_RandomBox WHERE cuid = [MENTION=3613419]cui[/MENTION]d and rank = [MENTION=955363]rank[/MENTION]
ELSE
SELECT [MENTION=3613419]cui[/MENTION]d AS cuid, -1 AS rank, -1 AS nBonusCount, -1 AS nBonusIndex, -1 AS checkNumber1, -1 AS isLock1, -1 AS checkNumber2, -1 AS isLock2, -1 AS checkNumber3, -1 AS isLock3
