public editLootTemplate(MainForm opener, string LootTemplate_ID)
{
this.opener = opener;
InitializeComponent();
this.selectRealm.DataSource = this.opener.baseXMLData;
this.selectRealm.DisplayMember = "realm.name";
this.selectRealm.ValueMember = "realm.id";
try
{
if (opener.mysqlConnection.State != ConnectionState.Open) opener.mysqlConnection.Open();
string SQL = "SELECT LootTemplate_ID, TemplateName, ItemTemplateID, Chance FROM " + opener.mysqlRow.LootTemplateTable + " WHERE LootTemplate_ID = '" + LootTemplate_ID + "' LIMIT 0,1";
MySqlCommand cmd = new MySqlCommand(SQL, opener.mysqlConnection);
MySqlDataReader reader = cmd.ExecuteReader();
reader.Read();
lootTemplateIDTextbox.Text = reader.GetString("LootTemplate_ID");
templateNameTextBox.Text = reader.GetString("TemplateName");
itemTemplateIdTextBox.Text = reader.GetString("ItemTemplateID");
chanceTextBox.Text = reader.GetInt32("Chance").ToString();
//this.selectRealm.SelectedValue = reader.GetInt32("Realm");
}
catch (MySqlException ex)
{
MessageBox.Show(ex.Message + System.Environment.NewLine + "@ getting data of LootTemplate");
}
finally
{
opener.mysqlConnection.Close();
}
}
public exportItem(MainForm sender)
{
mainForm = sender;
InitializeComponent();
setSQLOptions();
}
public editMobAssignment(MainForm opener, string MobXLootTemplate_ID)
{
this.opener = opener;
InitializeComponent();
try
{
if (opener.mysqlConnection.State != ConnectionState.Open) opener.mysqlConnection.Open();
string SQL = "SELECT MobXLootTemplate_ID, MobName, LootTemplateName, DropCount FROM " + opener.mysqlRow.MobXLootTemplateTable + " WHERE MobXLootTemplate_ID = '" + MobXLootTemplate_ID + "' LIMIT 0,1";
MySqlCommand cmd = new MySqlCommand(SQL, opener.mysqlConnection);
MySqlDataReader reader = cmd.ExecuteReader();
reader.Read();
mobxtemplateIdTextBox.Text = reader.GetString("MobXLootTemplate_ID");
mobNameTextBox.Text = reader.GetString("MobName");
lootTemplateIdTextBox.Text = reader.GetString("LootTemplateName");
dropCountTextBox.Text = reader.GetInt32("DropCount").ToString();
}
catch (MySqlException ex)
{
MessageBox.Show(ex.Message + System.Environment.NewLine + "@ getting data of MobXLootTemplate");
}
finally
{
opener.mysqlConnection.Close();
}
}
public preferencesForm(MainForm mainForm, string filename)
{
this.mainForm = mainForm;
this.filename = filename;
InitializeComponent();
loadPreferences();
}
public spellIDs(MainForm sender)
{
this.mainForm = sender;
InitializeComponent();
loadSearchOptions();
getTableData(0);
}
public newMobAssignment(MainForm opener, string LootTemplateName)
{
this.opener = opener;
InitializeComponent();
this.lootTemplateIdTextBox.Text = LootTemplateName;
this.dropCountTextBox.Text = "1";
this.createGuid.Checked = true;
}
public newLootTemplate(MainForm opener)
{
this.opener = opener;
InitializeComponent();
this.itemTemplateIdTextBox.Text = opener.item.ItemTemplate[0].Id_nb;
this.selectRealm.DataSource = this.opener.baseXMLData;
this.selectRealm.DisplayMember = "realm.name";
this.selectRealm.ValueMember = "realm.id";
this.createGuid.Checked = true;
}
public mysqlItems(MainForm sender)
{
this.mainForm = sender;
InitializeComponent();
this.order_by.SelectedItem = "Id_nb";
this.data_per_page.SelectedItem = "50";
this.data_per_page.SelectedIndexChanged += new EventHandler(this.reloadData);
this.order_by.SelectedIndexChanged += new EventHandler(this.reloadData);
getTableData(0);
}
public updaterForm(MainForm mainForm)
{
this.mainForm = mainForm;
InitializeComponent();
this.checkVersions();
}