Montei uma query aqui pra puxar esses dados e realmente, não conhecia essa procedure, agora consigo montar até ranking de PK, kill etc...
Para quem quiser, fiz alguns rankings customizados, basta alterar a procedure mencionada pelo @[Somente membros podem ver os links. ], removi personagens que são ADM e GM.
Contem:
- Level + Master Level
- Kills
- Guild Ranking
- Blood Castle
- Devil Square
Deletar procedure:
Código:
DROP PROCEDURE [dbo].[WZ_CustomRanking]
Criar procedure:
Código:
USE [MuOnline]
GO
CREATE PROCEDURE [dbo].[WZ_CustomRanking]
@type SMALLINT
As
Begin
SET NOCOUNT ON
IF @type = 0
BEGIN
SELECT TOP 10
c.name AS VALUE1,
c.cLevel + mst.MasterLevel AS VALUE2
FROM Character as c
LEFT JOIN MasterSkillTree mst ON c.Name = mst.Name
WHERE c.CtlCode = 0
ORDER BY
VALUE2 DESC;
END
IF @type = 1
BEGIN
SELECT TOP 10
name AS VALUE1,
kills AS VALUE2
FROM
Character
WHERE CtlCode = 0
ORDER BY
kills DESC;
END
IF @type = 2
BEGIN
SELECT TOP 10
MAX(g.G_Name) AS VALUE1,
SUM((c.Strength + c.Dexterity + c.Vitality + c.Energy + c.Leadership + g.G_Score) * 0.001) AS VALUE2
FROM Guild g
LEFT JOIN
GuildMember gm ON g.G_Name = gm.G_Name
LEFT JOIN
Character c ON gm.Name = c.Name
WHERE c.CtlCode = 0
GROUP BY g.G_Name
ORDER BY VALUE2 DESC
END
IF @type = 3
BEGIN
Select top 10 name as VALUE1, Score as VALUE2 from RankingBloodCastle order by Score desc
END
IF @type = 4
BEGIN
Select top 10 name as VALUE1, Score as VALUE2 from RankingDevilSquare order by Score desc
END
SET NOCOUNT OFF
End