private void button15_Click(object sender, EventArgs e)
{
ArrayList alreadyBanned = new ArrayList();
alreadyBanned.AddRange(ArrayList.Adapter(ConfigLoadFunc.TimeBanLoad("banned.xml")));
Int64 unix_timebanned = (Int64)(DateTime.UtcNow - new DateTime(1970, 1, 1, 0, 0, 0)).TotalSeconds;
string connectionString;
connectionString = "Data Source=" + databaseHost + ";User Id=" + databaseUser + ";Password="******";Database=" + realmDatabase;
MySql.Data.MySqlClient.MySqlConnection conn = new MySql.Data.MySqlClient.MySqlConnection(connectionString);
conn.Open();
string query = "UPDATE account SET banned = \"1\" WHERE username = \"" + Convert.ToString(listBox1.SelectedItem) + "\"";
MySql.Data.MySqlClient.MySqlCommand resQuery = new MySql.Data.MySqlClient.MySqlCommand(query, conn);
resQuery.ExecuteNonQuery();
conn.Close();
string tobeBanned = Convert.ToString(listBox1.SelectedItem);
Int64 timeBan = unix_timebanned + (Convert.ToInt64(timebanBox.Text) * 60);
alreadyBanned.Add(tobeBanned + @"%" + timeBan + @";");
if ((string)alreadyBanned[0] == "none")
{
alreadyBanned.RemoveAt(0);
}
MainFunctions.WriteBans((string[])alreadyBanned.ToArray(typeof(string)));
WriteLog("Account: " + listBox1.SelectedItem + " BANNNED FOR " + timebanBox.Text + " minutes!", Color.Red);
button12_Click(null, null);
}
private void generalTimer_Tick(object sender, EventArgs e)
{
button3_Click(null, null);
label17.Text = Convert.ToString(oCount);
if (oCount > maxoCount)
{
label16.Text = Convert.ToString(oCount);
}
//Check TimeBans
string[] Banned = null;
Banned = ConfigLoadFunc.TimeBanLoad("banned.xml");
ArrayList toBanList = new ArrayList();
foreach (string s in Banned)
{
int a = 0;
string bannedname = "";
string bantime = "";
Int64 unix_time = (Int64)((DateTime.UtcNow - new DateTime(1970, 1, 1, 0, 0, 0)).TotalSeconds);
ArrayList indvBans = new ArrayList();
indvBans = ArrayList.Adapter(s.Split(Convert.ToChar(";")));
foreach (string i in indvBans)
{
a = i.IndexOf(@"%");
if (a != -1)
{
bannedname = i.Substring(0, a);
bantime = i.Substring(a + 1);
bantime.Remove(bantime.Length - 1);
if (Convert.ToInt64(bantime) < unix_time)
{
string connectionString;
connectionString = "Data Source=" + databaseHost + ";User Id=" + databaseUser + ";Password="******";Database=" + realmDatabase;
MySql.Data.MySqlClient.MySqlConnection conn = new MySql.Data.MySqlClient.MySqlConnection(connectionString);
conn.Open();
string query = "UPDATE account SET banned = \"0\" WHERE username = \"" + bannedname + "\"";
MySql.Data.MySqlClient.MySqlCommand resQuery = new MySql.Data.MySqlClient.MySqlCommand(query, conn);
resQuery.ExecuteNonQuery();
conn.Close();
WriteLog("Time ban on " + bannedname + " removed!", Color.Red);
}
else
{
toBanList.Add(i);
}
}
}
MainFunctions.WriteBans((string[])(toBanList.ToArray(typeof(string))));
}
}
