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); }
public static void SetPlayerData(string playerData, string gamertag) { var playerDataModel = new DataModels.CachedPlayer() { Expires = DateTime.Now.AddHours(3), JsonCache = playerData, PlayerName = gamertag.Trim().ToLower() }; // TRUNCATE TABLE `cached_players` // INSERT INTO `cached_players` // Delete Row in Table var query = new MySqlCommand { CommandText = @"DELETE FROM `cached_players` WHERE `player_name` = @player_name" }; query.Parameters.AddWithValue("@player_name", playerDataModel.PlayerName); MySqlConnector.RunSQLUpdateQuery(query); // Add new PlayerData query = new MySqlCommand { CommandText = @"INSERT INTO `cached_players` ( `expires`, `json_cache`, `player_name` ) VALUES ( @expires, @json_cache, @player_name ); " }; query.Parameters.AddWithValue("@expires", playerDataModel.Expires); query.Parameters.AddWithValue("@json_cache", playerDataModel.JsonCache); query.Parameters.AddWithValue("@player_name", playerDataModel.PlayerName); MySqlConnector.RunSQLUpdateQuery(query); }
public static string GetServicesList() { var query = new MySqlCommand("SELECT * FROM `cached_services` LIMIT 0, 1;"); var sql = MySqlConnector.RunSQLSelectQuery(query); if (sql.Count == 0) { return(null); } // return dat services list, bro var result = new DataModels.CachedService { Expires = DateTime.Parse(sql[0][0]), JsonCache = sql[0][1] }; return(result.Expires.Ticks < DateTime.Now.Ticks ? null : result.JsonCache); }
public static void SetServicesList(string services) { var servicesData = new DataModels.CachedService { Expires = DateTime.Now.AddDays(1), JsonCache = services }; // TRUNCATE TABLE `cached_services` // INSERT INTO `cached_services` // Clear Table var query = new MySqlCommand { CommandText = @"TRUNCATE TABLE `cached_services`" }; MySqlConnector.RunSQLUpdateQuery(query); // Add new Service List query = new MySqlCommand { CommandText = @"INSERT INTO `cached_services` ( `expires`, `json_cache` ) VALUES ( @expires, @json_cache ); " }; query.Parameters.AddWithValue("@expires", servicesData.Expires); query.Parameters.AddWithValue("@json_cache", servicesData.JsonCache); MySqlConnector.RunSQLUpdateQuery(query); }