private void pictureBox3_Click(object sender, EventArgs e)
{
// Login with specified account data
sqlFunctions sql = new sqlFunctions();
if (sql.login(textBox1.Text, textBox2.Text) == true)
{
// This will trigger a successfull login
string appPath = Path.GetDirectoryName(Application.ExecutablePath);
System.IO.StreamWriter file = new System.IO.StreamWriter(appPath + "/lastuser.txt");
file.WriteLine(textBox1.Text);
file.Close();
// Open the main GUI
Main main = new Main();
main.Show();
this.Hide();
}
else
{
// The login failed, since the user doesn't match anything in the database.
label3.Visible = true;
}
}
private void button1_Click(object sender, EventArgs e)
{
sqlFunctions sql = new sqlFunctions();
if (sql.login(textBox1.Text, textBox2.Text) == true)
{
toolStripStatusLabel1.ForeColor = Color.DarkGreen;
toolStripStatusLabel1.Text = "Logged In As:";
toolStripStatusLabel2.Text = textBox1.Text;
sqlFunctions sql2 = new sqlFunctions();
WebClient client = new WebClient();
string ip = client.DownloadString("http://www.merrimentgamestudio.com/smurfrp/srvtool/1.txt");
string usr = client.DownloadString("http://www.merrimentgamestudio.com/smurfrp/srvtool/2.txt");
string pw = client.DownloadString("http://www.merrimentgamestudio.com/smurfrp/srvtool/3.txt");
string ip2 = client.DownloadString("http://www.merrimentgamestudio.com/smurfrp/srvtool/4.txt");
string usr2 = client.DownloadString("http://www.merrimentgamestudio.com/smurfrp/srvtool/5.txt");
string pw2 = client.DownloadString("http://www.merrimentgamestudio.com/smurfrp/srvtool/6.txt");
MySqlConnection conn2 = new MySqlConnection("server=" + ip + ";userid=" + usr + ";password="******";database=114794-donations");
MySqlConnection conn4 = new MySqlConnection("server=" + ip + ";userid=" + usr + ";password="******";database=114794-donations");
MySqlConnection conn3 = new MySqlConnection("server=" + ip2 + ";userid=" + usr2 + ";password="******";database=114794-drpbans");
MySqlCommand getauth2 = new MySqlCommand("SELECT * FROM users WHERE username = '******';");
MySqlCommand getauth4 = new MySqlCommand("SELECT * FROM users");
MySqlCommand getauth3 = new MySqlCommand("SELECT * FROM u_globalbans");
getauth2.Parameters.AddWithValue("username", textBox1.Text);
getauth2.Connection = conn2;
getauth3.Connection = conn3;
getauth4.Connection = conn4;
conn2.Open();
conn3.Open();
conn4.Open();
MySqlDataReader Reader2 = getauth2.ExecuteReader();
MySqlDataReader Reader3 = getauth3.ExecuteReader();
MySqlDataReader Reader4 = getauth4.ExecuteReader();
// Set 'last login'
sql.writeLastLogin(DateTime.Now.ToString(), textBox1.Text);
// Lastly, set form title
this.Text = ("SmurfRP Server Tool :: " + textBox1.Text);
// Hide login panel
panel1.Visible = false;
// Show logout panel
panel10.Visible = true;
while (Reader2.Read())
{
// Set some shit.
pictureBox2.ImageLocation = (sql.GetDBString("avatar", Reader2));
label7.Text = textBox1.Text;
label9.Text = (sql.GetDBString("registerdate", Reader2));
label10.Text = (sql.GetDBString("lastlogin", Reader2));
label15.Text = "You Last Logged In: " + (sql.GetDBString("lastlogin", Reader2));
textBox6.Text = (sql.GetDBString("avatar", Reader2));
label13.Text = "Logged in as " + textBox1.Text;
panel7.Visible = true;
button6.Enabled = true;
button7.Enabled = true;
button8.Enabled = true;
// Show Ban Label
label24.Visible = true;
// Remember User?
if (checkBox1.Checked == true)
{
using (StreamWriter sw = File.CreateText("lastuser.txt"))
{
sw.WriteLine(textBox1.Text);
}
}
else
{
if (File.Exists("lastuser.txt"))
{
File.Delete("lastuser.txt");
}
}
}
while (Reader4.Read())
{
// Populate the new tab with even more shit!
ListViewItem userlist;
userlist = new ListViewItem(Reader4.GetString("username"));
userlist.SubItems.Add(Reader4.GetString("registerdate"));
userlist.SubItems.Add(sql.GetDBString("lastlogin", Reader4));
userlist.SubItems.Add(Reader4.GetString("isadmin"));
userlist.SubItems.Add(Reader4.GetString("canuseremote"));
userlist.SubItems.Add(Reader4.GetString("isbanned"));
listView2.Items.Add(userlist);
}
while (Reader3.Read())
{
ListViewItem item;
item = new ListViewItem(Reader3.GetString("_SteamID"));
item.UseItemStyleForSubItems = false;
if (Reader3.IsDBNull(1) == true)
{
item.SubItems.Add("Unknown", Color.Maroon, Color.White, new Font(label1.Font.Name, 8.0F, FontStyle.Bold));
}
else
{
item.SubItems.Add(Convert.ToString(Reader3.GetValue(1)));
}
if (Reader3.GetString("_Reason") == "")
{
item.SubItems.Add("No Reason Given", Color.Gray, Color.White, new Font(label1.Font.Name, 8.0F, FontStyle.Italic));
}
else
{
item.SubItems.Add(Reader3.GetString("_Reason").Replace(@"\", ""));
}
if (Reader3.GetString("_Length") == "0")
{
item.SubItems.Add("Permanently", Color.Maroon, Color.White, new Font(label1.Font.Name, 8.0F, FontStyle.Bold));
}
else
{
TimeSpan t2 = TimeSpan.FromSeconds(Convert.ToDouble(Reader3.GetString("_Length")));
item.SubItems.Add(string.Format("{0:D2}h {1:D2}m {2:D2}s",
t2.Hours,
t2.Minutes,
t2.Seconds));
}
TimeSpan t = TimeSpan.FromSeconds(Convert.ToDouble(Reader3.GetString("_Time")));
item.SubItems.Add(string.Format("{0:D2}h {1:D2}m {2:D2}s",
t.Hours,
t.Minutes,
t.Seconds));
item.SubItems.Add(Reader3.GetString("_ASteamName"));
item.SubItems.Add("lol");
listView1.Items.Add(item);
}
Reader2.Close();
conn2.Close();
Reader3.Close();
conn3.Close();
conn4.Close();
Reader4.Close();
label24.Text = ("Total Bans: ") + listView1.Items.Count.ToString();
}
else
{
label4.Text = "Authentication Failed. Check Username/Password.";
label4.Visible = true;
}
}