public static string GetPlayerData(string gamertag)
{
var query = new MySqlCommand("SELECT * FROM `cached_players` WHERE (`player_name`= @player_name) LIMIT 0, 1;");
query.Parameters.AddWithValue("@player_name", gamertag.Trim().ToLower());
var sql = MySqlConnector.RunSQLSelectQuery(query);
if (sql.Count == 0)
return null;
// return dat services list, bro
var result = new DataModels.CachedPlayer()
{
Expires = DateTime.Parse(sql[0][0]),
JsonCache = sql[0][1],
PlayerName = sql[0][2]
};
return result.Expires.Ticks < DateTime.Now.Ticks
? null
: result.JsonCache;
}