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); }