public static void addNewIP(ref TmpEntry entry)
{
using (MySqlConnection connection = SQL.iniHandle()) {
using (MySqlCommand command = connection.CreateCommand()) {
if (SQL.Open(connection))
{
command.CommandText = "INSERT INTO `console_ip_history` (`cid`, `ip`) VALUES (@cid, @ip);";
command.Parameters.AddWithValue("@cid", entry.client_consoleID);
command.Parameters.AddWithValue("@ip", entry.client_ip);
command.ExecuteNonQuery();
connection.Close();
}
}
}
}
public static void addSpoofyFag(ref TmpEntry entry)
{
using (MySqlConnection connection = SQL.iniHandle()) {
using (MySqlCommand command = connection.CreateCommand()) {
if (SQL.Open(connection))
{
command.CommandText = "INSERT INTO `spoofy` (`cpukey`, `ip`, `attempts`, `time`, `kv`) VALUES (@cpukey, @ip, 1, NOW(), @kv) ON DUPLICATE KEY UPDATE `spoofy` SET `ip`=@ip, `attempts`=attempts+1, `kv`=@kv";
command.Parameters.AddWithValue("@cpukey", entry.client_cpukey);
command.Parameters.AddWithValue("@ip", entry.client_ip);
command.Parameters.AddWithValue("@kv", entry.client_kv);
command.ExecuteNonQuery();
connection.Close();
}
}
}
}
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 autoUpdateTime(ref TmpEntry entry) // Update to the original 24 hour timer.
{
if (getConsole(ref entry))
{
if (entry.client_days >= 1 && !entry.client_enabled)
{
using (MySqlConnection connection = SQL.iniHandle()) {
using (MySqlCommand command = connection.CreateCommand()) {
if (SQL.Open(connection))
{
command.CommandText = "UPDATE `consoles` SET `expire`=DATE_ADD(NOW(), INTERVAL 1 DAY ), `daysLeft`=`daysLeft`-1, `enabled`=1, `daysUsed`=`daysUsed`+1 WHERE `id`=@id";
command.Parameters.AddWithValue("@id", entry.client_consoleID);
command.ExecuteNonQuery();
connection.Close();
return(true);
}
}
}
}
}
return(false);
}
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); }
}
