在游戏中实时显示排名信息CustomRanking_97K_Kayito_NTCong
Published: Comment: No Comments
Last Modified:2025-01-11 23:08:43
CustomRanking_97K_Kayito_NTCong
97k,游戏内实时显示排名榜
USE [MuOnline97]
GO
/****** Object: StoredProcedure [dbo].[WZ_CustomRanking] Script Date: 04/30/2024 19:10:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[WZ_CustomRanking]
@type SMALLINT
As
Begin
SET NOCOUNT ON
BEGIN
Select top 10 name as VALUE1, Resetcount as VALUE2 ,cLevel as VALUE3 , Class as VALUE4 , GrandResetCount as VALUE5 from Character order by GrandResetCount desc , ResetCount desc , cLevel desc
END
--WAITFOR DELAY '00:00:02';
SET NOCOUNT OFF
End
GO