public TargetEditor(ref EffectData _effectData, MySqlConn _mysqlconn)
{
InitializeComponent();
mysqlCon = _mysqlconn;
effectData = _effectData;
ChangeTargetTB.Text = ((uint)effectData.targets).ToString();
CurrentValueTB.Text = ((uint)effectData.targets).ToString();
foreach (SpellTargetType stt in Enum.GetValues(typeof(SpellTargetType)))
{
if (effectData.targets.HasFlag(stt))
{
CurrentValueLB.Items.Add(stt.ToString());
}
}
// AllEnumValuesLB
string[] spellTargetType = Enum.GetNames(typeof(SpellTargetType));
for (int cnt = 0; cnt < spellTargetType.Length; cnt++)
{
if (CurrentValueLB.Items.IndexOf(spellTargetType[cnt]) == -1)
{
AllEnumValuesLB.Items.Add(spellTargetType[cnt]);
}
}
}
private void Form1_FormClosing(object sender, FormClosingEventArgs e)
{
if (mysqlCon != null && mysqlCon.conn.State == ConnectionState.Open)
{
mysqlCon.conn.Close();
mysqlCon.Dispose();
mysqlCon = null;
}
}
void showInfo()
{
spellLevelL.Text = "Level " + selectedLevel;
dataGridView1.Columns.Clear();
//// recuperer le nom des colonnes
MySqlConn mysqlCon2 = new MySqlConn(Form1.userDB, Form1.passwordDB, "information_schema", Form1.adresseDB);
mysqlCon2.cmd.CommandText = "SELECT column_name FROM information_schema.columns WHERE table_schema = '" + Form1.DBName + "' AND table_name = '" + Form1.spells_levels + "'";
mysqlCon2.reader = mysqlCon2.cmd.ExecuteReader();
int count = 0;
columnName.Clear();
while (mysqlCon2.reader.Read())
{
count++;
string column = mysqlCon2.reader[0].ToString();
columnName.Add(column);
}
mysqlCon2.reader.Close();
for (int cnt = 0; cnt < count; cnt++)
{
DataGridViewTextBoxColumn column = new DataGridViewTextBoxColumn();
column.HeaderText = columnName[cnt];
column.Name = columnName[cnt];
column.ReadOnly = true;
column.Resizable = System.Windows.Forms.DataGridViewTriState.True;
column.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.NotSortable;
dataGridView1.Columns.Add(column);
}
///////////////////////////////// insertion des données
dataGridView1.Rows.Clear();
dataGridView1.CellDoubleClick -= DataGridView1_CellDoubleClick;
mysqlCon.cmd.CommandText = "select * from " + Form1.spells_levels + " where Id = '" + selectedId + "'";
mysqlCon.reader = mysqlCon.cmd.ExecuteReader();
while (mysqlCon.reader.Read())
{
object[] data = new object[count];
for (int cnt = 0; cnt < data.Length; cnt++)
{
data[cnt] = mysqlCon.reader[cnt];
}
dataGridView1.Rows.Add(data);
}
mysqlCon.reader.Close();
this.Width = Screen.PrimaryScreen.Bounds.Width;
this.Height = dataGridView1.Height + 120;
panel2.Visible = true;
this.Location = new Point(0, 0);
dataGridView1.CellDoubleClick += DataGridView1_CellDoubleClick;
}
public SelectionTable(MySqlConn mysqlConn)
{
InitializeComponent();
mysqlConn.cmd.CommandText = "show tables";
mysqlConn.reader = mysqlConn.cmd.ExecuteReader();
while (mysqlConn.reader.Read())
{
string column = mysqlConn.reader[0].ToString();
this.tablesName.Items.Add(column);
}
tablesName.SelectedIndex = 0;
mysqlConn.reader.Close();
}
public SelectSpellLevel(MySqlConn mysqlCon, int spellID)
{
InitializeComponent();
mysqlCon.cmd.CommandText = "select * from " + Form1.spells_levels + " where SpellId = '" + spellID + "'";
mysqlCon.reader = mysqlCon.cmd.ExecuteReader();
int counter = 0;
while (mysqlCon.reader.Read())
{
dataGridView1.Rows.Add(mysqlCon.reader["Id"].ToString(), mysqlCon.reader["SpellID"].ToString(), ++counter);
}
mysqlCon.reader.Close();
}
private void connection_Click(object sender, EventArgs e)
{
if (username.Text == "")
{
MessageBox.Show("Entrer le d'utilisateur");
return;
}
else if (DB.Text == "")
{
MessageBox.Show("Entrer la Base de donné");
return;
}
else if (Ip.Text == "")
{
MessageBox.Show("Entrer l'adresse Ip");
return;
}
if (clientVersionCB.Items.Count == 0)
{
MessageBox.Show("La base qui contiens les sorts des differents clients Dofus est vide.\nMerci de vérifier le répértoir 'clientVersion' qui dois contenir un répertoire pour chaque version comme 2.10, 2.29 ... et chaque répertoire dois contenir tous les sorts du client en question.\n pour récuperer les sorts il faut les extraires depuis le client");
return;
}
MySqlConn mysqlCon = new MySqlConn(username.Text, Password.Text, DB.Text, Ip.Text);
if (mysqlCon.conn.State == ConnectionState.Open)
{
userDB = username.Text;
passwordDB = Password.Text;
adresseDB = Ip.Text;
DBName = DB.Text;
clientVersion = clientVersionCB.SelectedItem.ToString() == "Par défaut (2.10)" ? "2.10" : clientVersionCB.SelectedItem.ToString();
this.Hide();
SpellEffect spellEffect = new SpellEffect(mysqlCon);
spellEffect.Show();
spellEffect.FormClosed += SpellEffect_FormClosed;
}
}
public SpellEffect(MySqlConn _mysqlCon)
{
InitializeComponent();
mysqlCon = _mysqlCon;
}
