private void Form1_Load(object sender, EventArgs e)
{
items.Clear();
lblVersion.Text = "Version: " + Assembly.GetEntryAssembly().GetName().Version.ToString(4);
Text = Assembly.GetEntryAssembly().GetName().Name.ToString();
ckbInstant.Checked = false; ckbInstant.Checked = true;
Form1_Activated(null, EventArgs.Empty);
txtStyle.SelectedIndex = 0;
dat = dtpExp.SelectionRange.Start;
dat = dat.AddDays(30);
dtpExp.SelectionRange.Start = dat;
if (con.worldconn.State != ConnectionState.Open)
{
try
{
con.worldconn.Open();
con.charconn.Open();
}
catch
{
frm.ShowDialog();
}
}
MySqlCommand cmd = new MySqlCommand("SELECT `name`, `entry` FROM `item_template`", con.worldconn);
MySqlDataReader reader = cmd.ExecuteReader();
lstSearchItems.Items.Clear();
lstSearchItems.BeginUpdate();
while (reader.Read())
{
Mail_Tosser_1._4.Classes.Item it = new Mail_Tosser_1._4.Classes.Item();
it.Entry = reader.GetInt32("entry");
it.Name = reader.GetString("name");
items.Add(it);
ListViewItem item = lstSearchItems.Items.Add(it.Entry.ToString());
item.SubItems.Add(it.Name);
}
lstSearchItems.EndUpdate();
reader.Close();
cmd = new MySqlCommand("SELECT `name` FROM `characters`;", con.charconn);
reader = cmd.ExecuteReader();
txtSender.Items.Clear();
while (reader.Read())
{
names.Add(reader.GetString("name"));
txtSender.Items.Add(reader.GetString("name"));
}
reader.Close();
if (con.worldconn.State != ConnectionState.Open)
{
con.worldconn.Open();
}
cmd = new MySqlCommand("SELECT `name`, `entry` FROM `creature_template`", con.worldconn);
reader = cmd.ExecuteReader();
while (reader.Read())
{
Npcs.lstnpcs.Add(reader.GetString("name") + " {" + reader.GetInt32("entry").ToString() + "}");
}
reader.Close();
txtSender.SelectedIndex = 0;
txtStyle.SelectedIndex = 0;
if (lstSearchItems.Items.Count > 0)
{
lstSearchItems.Items[0].Selected = true;
}
}
private void Form1_Load(object sender, EventArgs e)
{
items.Clear();
lblVersion.Text = "Version: " +Assembly.GetEntryAssembly().GetName().Version.ToString(4);
Text = Assembly.GetEntryAssembly().GetName().Name.ToString();
ckbInstant.Checked = false; ckbInstant.Checked = true;
Form1_Activated(null, EventArgs.Empty);
txtStyle.SelectedIndex = 0;
dat = dtpExp.SelectionRange.Start;
dat = dat.AddDays(30);
dtpExp.SelectionRange.Start = dat;
if (con.worldconn.State != ConnectionState.Open)
{
try
{
con.worldconn.Open();
con.charconn.Open();
}
catch
{
frm.ShowDialog();
}
}
MySqlCommand cmd = new MySqlCommand("SELECT `name`, `entry` FROM `item_template`", con.worldconn);
MySqlDataReader reader = cmd.ExecuteReader();
lstSearchItems.Items.Clear();
lstSearchItems.BeginUpdate();
while (reader.Read())
{
Mail_Tosser_1._4.Classes.Item it = new Mail_Tosser_1._4.Classes.Item();
it.Entry = reader.GetInt32("entry");
it.Name = reader.GetString("name");
items.Add(it);
ListViewItem item = lstSearchItems.Items.Add(it.Entry.ToString());
item.SubItems.Add(it.Name);
}
lstSearchItems.EndUpdate();
reader.Close();
cmd = new MySqlCommand("SELECT `name` FROM `characters`;", con.charconn);
reader = cmd.ExecuteReader();
txtSender.Items.Clear();
while (reader.Read())
{
names.Add(reader.GetString("name"));
txtSender.Items.Add(reader.GetString("name"));
}
reader.Close();
if (con.worldconn.State != ConnectionState.Open) con.worldconn.Open();
cmd = new MySqlCommand("SELECT `name`, `entry` FROM `creature_template`", con.worldconn);
reader = cmd.ExecuteReader();
while (reader.Read()) Npcs.lstnpcs.Add(reader.GetString("name") + " {" + reader.GetInt32("entry").ToString() + "}");
reader.Close();
txtSender.SelectedIndex = 0;
txtStyle.SelectedIndex = 0;
if (lstSearchItems.Items.Count > 0)
lstSearchItems.Items[0].Selected = true;
}
