private void AddVehicleData()
{
int TotalRoadKills = 0;
int Fav = 0;
int FavTime = 0;
Rows = Database.Query("SELECT * FROM vehicles WHERE id=@P0", Pid);
if (Rows.Count == 0)
{
// Vehicle Times
for (int i = 0; i < 7; i++)
Out.Add("vtm-" + i, "0");
// Vehicle kills
for (int i = 0; i < 7; i++)
Out.Add("vkl-" + i, "0");
// Vehicle Deaths
for (int i = 0; i < 7; i++)
Out.Add("vdt-" + i, "0");
// Vehicle Kill Death Ratio
for (int i = 0; i < 7; i++)
Out.Add("vkd-" + i, "0");
// Vehicle Roadkills
for (int i = 0; i < 7; i++)
Out.Add("vkr-" + i, "0");
}
else
{
// Vehicle Times
for (int i = 0; i < 7; i++)
{
int time = Int32.Parse(Rows[0]["time" + i].ToString());
if (time > FavTime)
{
Fav = i;
FavTime = time;
}
Out.Add("vtm-" + i, time);
}
// Vehicle kills
for (int i = 0; i < 7; i++)
Out.Add("vkl-" + i, Rows[0]["kills" + i]);
// Vehicle Deaths
for (int i = 0; i < 7; i++)
Out.Add("vdt-" + i, Rows[0]["deaths" + i]);
// Vehicle Kill Death Ratio
for (int i = 0; i < 7; i++)
{
int kills = Int32.Parse(Rows[0]["kills" + i].ToString());
int deaths = Int32.Parse(Rows[0]["deaths" + i].ToString());
int den = GetDenominator(kills, deaths);
if (kills == 0 && deaths == 0)
Out.Add("vkd-" + i, "0");
else if (deaths != 0)
Out.Add("vkd-" + i, kills / den + ":" + deaths / den);
else
Out.Add("vkd-" + i, kills + ":0");
}
// Vehicle Roadkills
for (int i = 0; i < 7; i++)
{
TotalRoadKills += int.Parse(Rows[0]["rk" + i].ToString());
Out.Add("vkr-" + i, Rows[0]["rk" + i]);
}
}
// Add total road kills
Out["vrk"] = TotalRoadKills;
Out["fveh"] = Fav;
}