RunSQLSelectQuery() public static method

Run an SQL query on the server
public static RunSQLSelectQuery ( MySqlCommand query ) : IList>
query MySql.Data.MySqlClient.MySqlCommand The MySQL Command to be executed
return IList>
MySqlConnector Class Documentation
Beispiel #1
0
        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);
        }
Beispiel #2
0
        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);
        }