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