USE [MuOnline]
GO
/****** Object: StoredProcedure [dbo].[WZ_DevilSquareFinal_RenewPartyRank] Script Date: 18/11/2022 08:10:05 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
CREATE PROC [dbo].[WZ_DevilSquareFinal_RenewPartyRank]
@mDSFType TINYINT,
@mEnterYear INT,
@mEnterMonth TINYINT,
@mEnterDay TINYINT
AS
SET NOCOUNT ON
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
DELETE FROM dbo.DevilSquareFinal_Ranking WHERE mDSFType = @mDSFType;
DECLARE @mTbl TABLE (
mRank INT IDENTITY (1,1) NOT NULL
, mUserName1 VARCHAR(10) NOT NULL
, mUserName2 VARCHAR(10) NOT NULL
, mServerCode1 INT NOT NULL
, mServerCode2 INT NOT NULL
, mDSFType TINYINT NOT NULL
, mPoint INT NOT NULL
, mEnterCount INT NOT NULL
)
INSERT INTO @mTbl (
mUserName1,mUserName2,mServerCode1,mServerCode2,mDSFType,mPoint,mEnterCount )
SELECT
A.mName1,A.mName2,B.ServerCode,C.ServerCode,@mDSFType,A.mPoint,A.mEnterCount
FROM DevilSquareFinal_Scores A JOIN dbo.BattleCoreUser B ON A.mName1 = B.Name JOIN dbo.BattleCoreUser C ON A.mName2 = C.Name
WHERE mDSFType = @mDSFType
ORDER BY A.mPoint desc, (A.mUserLevel1+A.mUserLevel2) asc
INSERT INTO dbo.DevilSquareFinal_Ranking WITH(TABLOCK) ( mRank, mUserName1, mUserName2, mServerCode1, mServerCode2, mDSFType, mPoint, mEnterCount, mDate )
SELECT mRank, mUserName1, mUserName2, mServerCode1, mServerCode2, mDSFType, mPoint, mEnterCount, GETDATE() FROM @mTbl
/****** Object: StoredProcedure [dbo].[WZ_DevilSquareFinal_GetFinalPartyList] Script Date: 07/18/2021 15:26:01 ******/
SET ANSI_NULLS ON
GO