protected List<Player> GetTopFromQuery(int id, StatsDatabase Database)
{
List<Player> Players = new List<Player>(5);
var Rows = Database.Query(IndexQueries[id]);
for (int i = 0; i < 5; i++)
{
if (i < Rows.Count)
{
double ds = Double.Parse(Rows[i]["value"].ToString());
string Val = ((ds % 1) != 0) ? Math.Round(ds, 4).ToString() : FormatNumber(ds);
Players.Add(new Player
{
Pid = Int32.Parse(Rows[i]["id"].ToString()),
Name = Rows[i]["name"].ToString(),
Rank = Int32.Parse(Rows[i]["rank"].ToString()),
Value = Val
});
}
else
{
Players.Add(new Player { Name = "" });
}
}
return Players;
}