private void GenerateSQL()
{
string BuildSQL = "INSERT INTO " + form_MM.GetAuthDB() + ".account (username, sha_pass_hash, expansion, email) " + "\n" +
"VALUES (UPPER('" + textBox_username.Text + "'), (SHA1(CONCAT(UPPER('" + textBox_username.Text + "'), ':', UPPER('" + textBox_pass.Text + "')))), " + textBox_Expansion.Text + ", '" + textBox_email.Text + "'); " + "\n" +
"INSERT INTO " + form_MM.GetAuthDB() + ".account_access (id, gmlevel, RealmID) " + "\n" +
"VALUES ((SELECT id FROM " + form_MM.GetAuthDB() + ".account WHERE username = '******'), " + textBox_Account_Access_Level.Text + ", " + textBox_realmID.Text + "); \n";
stringSqlShare = BuildSQL;
}
public void ShowExistingAccounts()
{
GetMySqlConnection();
//string query = $"SELECT id, username, email FROM { form_MM.GetAuthDB() }.account;";
//MySqlCommand _command = new MySqlCommand(query, connection);
//try
//{
// connection.Open();
// MySqlDataAdapter sda = new MySqlDataAdapter();
// sda.SelectCommand = _command;
// DataTable dbdataset = new DataTable();
// sda.Fill(dbdataset);
// BindingSource bsource = new BindingSource();
// bsource.DataSource = dbdataset;
// dataGridView1.DataSource = bsource;
// sda.Update(dbdataset);
// _command.Connection.Close();
//}
//catch (MySqlException ex)
//{
// MessageBox.Show(ex.Message);
//}
string query = $"SELECT id, username, email FROM { form_MM.GetAuthDB() }.account;";
try
{
using (MySqlCommand cmd = new MySqlCommand(query, connection))
{
MySqlDataAdapter sda = new MySqlDataAdapter();
sda.SelectCommand = cmd;
DataTable dbdataset = new DataTable();
sda.Fill(dbdataset);
dataGridView1.DataSource = dbdataset;
dataGridView1.Columns[0].Width = 50; // Entry
dataGridView1.Columns[1].Width = 160; // Name
}
}
catch (MySqlException ex)
{
MessageBox.Show("Error No. " + ex.Number + ": " + ex.Message, "SpawnCreator", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
