public List <CPlayerData> getTopFivePlayers()
{
List <CPlayerData> playerlist = new List <CPlayerData>();
try
{
command.CommandText = "SELECT playerId, COUNT(repGiven) As repTotal FROM `rep-bot`.`playreps` WHERE repGiven = '+rep' Group By playerId Order By repTotal Desc LIMIT 5;";
connection.Open();
reader = command.ExecuteReader();
while (reader.Read())
{
CPlayerData playerDataItem = new CPlayerData()
{
mPlayerId = Convert.ToUInt64(reader.GetValue(0)),
mpRepPoint = Convert.ToString(reader.GetValue(1))
};
playerlist.Add(playerDataItem);
}
}
catch (MySqlException)
{
}
finally
{
connection.Close();
}
return(playerlist);
}
public List <CPlayerData> getRecentRep(ulong playerId)
{
List <CPlayerData> playerlist = new List <CPlayerData>();
try
{
command.CommandText = $"SELECT `reppedById`, `reasonGiven`, `timeStamp`, `repGiven` FROM `rep-bot`.`playreps` WHERE `playerId` = '{playerId}' ORDER BY `primaryId` DESC LIMIT 4;";
connection.Open();
reader = command.ExecuteReader();
while (reader.Read())
{
CPlayerData playerDataItem = new CPlayerData()
{
mPlayerId = Convert.ToUInt64(reader.GetValue(0)),
mReason = Uri.UnescapeDataString(Convert.ToString(reader.GetValue(1))),
mTimeStamp = Convert.ToDateTime(reader.GetValue(2)),
mpRepPoint = Convert.ToString(reader.GetValue(3))
};
playerlist.Add(playerDataItem);
}
}
catch (MySqlException)
{
}
finally
{
connection.Close();
}
return(playerlist);
}
