public static void updateOtherConsoles(ref TmpEntry entry, bool banned = false) // For BANNED and FAILED connections { try { using (MySqlConnection connection = SQL.iniHandle()) { using (MySqlCommand command = connection.CreateCommand()) { if (SQL.Open(connection)) { command.CommandText = String.Format("INSERT INTO `{0}` (`ip`, `kv`, `cpukey`) VALUES (@ipaddr, @kv, @cpukey) ON DUPLICATE KEY UPDATE `ip`=@ipaddr, `kv`=@kv", banned ? "banned" : "failed"); command.Parameters.AddWithValue("@cpukey", entry.client_cpukey); command.Parameters.AddWithValue("@ipaddr", entry.client_ip); command.Parameters.AddWithValue("@kv", entry.client_kv); command.ExecuteNonQuery(); connection.Close(); } } } } catch (MySqlException mysqlEx) { GlobalFunc.Write("MySQL Exception! Error Details: {0} || {1}", mysqlEx.Message, mysqlEx.StackTrace); } }
public static void setConsole(ref TmpEntry entry) { try { using (MySqlConnection connection = SQL.iniHandle()) { using (MySqlCommand command = connection.CreateCommand()) { if (SQL.Open(connection)) { command.CommandText = "UPDATE `consoles` SET `ip`=@curIP, `gamertag`=@gamertag, `titleID`=@titleID, `session`=@session, `lastSeen`=NOW() WHERE `cpukey`=@cpukey"; command.Parameters.AddWithValue("@curIP", entry.client_ip); command.Parameters.AddWithValue("@gamertag", entry.client_gt); command.Parameters.AddWithValue("@titleID", entry.client_title); command.Parameters.AddWithValue("@session", entry.client_session); command.Parameters.AddWithValue("@cpukey", entry.client_cpukey); command.ExecuteNonQuery(); connection.Close(); } } } } catch (MySqlException mysqlEx) { GlobalFunc.Write("MySQL Exception! Error Details: {0} || {1}", mysqlEx.Message, mysqlEx.StackTrace); } }
public static bool getConsole(ref TmpEntry entry, bool getConBySesh = false) // 2 functions in one ;) { try { using (MySqlConnection connection = SQL.iniHandle()) { using (MySqlCommand command = connection.CreateCommand()) { if (SQL.Open(connection)) { command.CommandText = String.Format("SELECT * FROM `consoles` WHERE `{0}`=@arg", getConBySesh ? "session" : "cpukey"); command.Parameters.AddWithValue("@arg", getConBySesh ? entry.client_session : entry.client_cpukey); using (MySqlDataReader reader = command.ExecuteReader()) { if (reader.Read()) { entry.client_cpukey = (string)reader["cpukey"]; entry.client_consoleID = (int)reader["id"]; entry.client_name = (string)reader["name"]; entry.client_db_curIP = (string)reader["ip"]; //entry.client_db_lastIP = (string)reader["lastIP"]; entry.client_session = (string)reader["session"]; //entry.client_xexVersion = (int)reader["version"]; //entry.client_gracePeriod_days = (int)reader["gracePeriod"]; entry.client_days = (int)reader["daysLeft"]; entry.client_daysUsed = (int)reader["daysUsed"]; entry.client_dateExpire = Convert.ToDateTime(reader["expire"]); entry.client_enabled = (bool)reader["enabled"]; entry.client_suspended = (bool)reader["suspended"]; entry.client_banned = (bool)reader["banned"]; //entry.client_xexChecks = (bool)reader["xexChecks"]; connection.Close(); return(true); } } } return(false); } } } catch (MySqlException mysqlEx) { GlobalFunc.Write("MySQL Exception! Error Details: {0} || {1}", mysqlEx.Message, mysqlEx.StackTrace); return(false); } }
public bool Open(MySqlConnection con) { try { con.Open(); return(true); } catch (MySqlException myEx) { GlobalFunc.Write("MySQL Exception: {0} || {1}", myEx.Source, myEx.Message); return(false); } catch { return(false); } }