MuServer Season6 PerfectZone Beta

[gallighanmaker]

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:

DROP PROCEDURE [dbo].[WZ_CustomRanking]

Criar procedure:

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