- Code: Select all
namespace MCDzienny
{
using System;
using System.Data;
public class CmdBestScores : Command
{
public override void Help(Player p)
{
Player.SendMessage(p, "/topten - Displays names of ten best players.");
}
public override void Use(Player p, string message)
{
Player.SendMessage(p, "Top ten round scores:");
DataTable table = DBInterface.fillData("SELECT * FROM `Players` ORDER BY bestScore DESC LIMIT 10", false);
for (int i = 0; i < table.Rows.Count; i++)
{
Player.SendMessage(p, string.Concat(new object[] { "%c", i + 1, ". ", table.Rows[i]["Name"].ToString(), " - best score: ", table.Rows[i]["bestScore"].ToString() }));
}
}
public override LevelPermission defaultRank
{
get
{
return LevelPermission.Banned;
}
}
public override bool museumUsable
{
get
{
return true;
}
}
public override string name
{
get
{
return "bestscores";
}
}
public override string shortcut
{
get
{
return "bs";
}
}
public override string type
{
get
{
return "other";
}
}
}
}
This is the actual code for /topten, just replace the bestscore with the row name of visits. (If u wait when i get home, i will change it.)