在游戏中实时显示排名信息CustomRanking_97K_Kayito_NTCong

Published: Dec 25, 2024   Comment: No Comments

奇迹MU架设 如果觉得对你有帮助，并想支持我，可以适当打赏以作勉励，点击打赏

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