private void CascReadBtn_Click(object sender, EventArgs e) { frmSQLFilter frm = new frmSQLFilter(); frm.ShowDialog(this); if (!con.Connected()) { con.Connection(); } if (con.Connected()) { tableColumn = getTableColumns(ConfigurationManager.AppSettings["Table"]); MySqlCommand query = new MySqlCommand(@"SELECT " + ConfigurationManager.AppSettings["Path"] + "," + ConfigurationManager.AppSettings["FileDataID"] + " FROM " + ConfigurationManager.AppSettings["Table"] + " WHERE " + ConfigurationManager.AppSettings["Path"] + " LIKE '%" + SQLFilter + "%' ORDER BY " + ConfigurationManager.AppSettings["FileDataID"], con.TheConnection); MySqlDataReader reader = query.ExecuteReader(); dt = new DataTable(); dt.Columns.Add(ConfigurationManager.AppSettings["Path"]); dt.Columns.Add(ConfigurationManager.AppSettings["FileDataID"]); if (reader.HasRows) { while (reader.Read()) { dt.Rows.Add(new Object[] { reader.GetString(0), reader.GetString(1) }); } } reader.Close(); dataGridView1.DataSource = dt; } }
private void ConnectionBtn_Click(object sender, EventArgs e) { con = new DBInstance(serverTxt.Text, databaseTxt.Text, usernameTxt.Text, passwordTxt.Text); if (con.Connected()) { lblWaiting.Text = "Connecting to " + con.ConnectionString().Substring(con.ConnectionString().IndexOf('=') + 1).Substring(0, con.ConnectionString().IndexOf(';') - (con.ConnectionString().IndexOf('=')) - 1); con.Disconnect(); Connection(); } else { con.Connection(); lblWaiting.Text = "Connecting to " + con.ConnectionString().Substring(con.ConnectionString().IndexOf('=') + 1).Substring(0, con.ConnectionString().IndexOf(';') - (con.ConnectionString().IndexOf('=')) - 1); con.Disconnect(); Connection(); } }
private void SQL_Script_Generation() { if (!con.Connected()) { con.Connection(); } if (con.Connected()) { timer = new Stopwatch(); timer.Start(); sb = new StringBuilder(); if (File.Exists(pathFile)) { File.Delete(pathFile); } File.AppendAllText(pathFile, "##Script " + TableName + " du " + DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss\n\n")); try { MySqlCommand cmd = new MySqlCommand(@"SELECT column_name as 'Column Name' FROM information_schema.columns WHERE table_name = '" + TableName + "'", con.TheConnection); MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { sb.Append(reader["Column Name"].ToString()); sb.Append(','); } tableColumns = sb.ToString().Substring(0, sb.ToString().LastIndexOf(',')); tableColumnsArray = tableColumns.Split(','); sb.Clear(); reader.Close(); cmd = new MySqlCommand("SELECT " + tableColumns + " FROM " + TableName, con.TheConnection); reader = cmd.ExecuteReader(); dt = new DataTable(); dt.Load(reader); nbRows = dt.Rows.Count; reader.Close(); cmd = new MySqlCommand("SELECT " + tableColumns + " FROM " + TableName, con.TheConnection); reader = cmd.ExecuteReader(); while (reader.Read()) { for (int i = 0; i < tableColumnsArray.Length; i++) { sb.Append(reader[tableColumnsArray[i]] + ","); } queryResult = sb.ToString().Substring(0, sb.ToString().LastIndexOf(',')); csvQuery = "INSERT INTO `" + TableName + "` (" + tableColumns + ") VALUES (" + queryResult + ");\n"; File.AppendAllText(pathFile, csvQuery); sb.Clear(); counter++; if (timer.ElapsedMilliseconds % 2 == 0) { backgroundWorker1.ReportProgress(counter * 100 / nbRows); } } reader.Close(); } catch (Exception e) { MessageBox.Show(e.Message); } } else { MessageBox.Show("No Active Connection", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } }
private void hotfixBtn_Click(object sender, EventArgs e) { if (!con.Connected()) { con.Connection(); } if (con.Connected()) { try { MySqlCommand cmd_1 = new MySqlCommand(@"INSERT INTO " + EnumDefinition.EnumType.Tables.item.ToString() + " (" + getTableColumns(EnumDefinition.EnumType.Tables.item.ToString()) + ") VALUES (@param1,@param2,4,4,1,@param3,@param4,0,11,0)", con.TheConnection); cmd_1.Parameters.AddWithValue("@param1", itemIDTxt.Text); cmd_1.Parameters.AddWithValue("@param2", iconFileDataIDTxt.Text); cmd_1.Parameters.AddWithValue("@param3", (int)(EnumDefinition.EnumType.MaterialArmor)Enum.Parse(typeof(EnumDefinition.EnumType.MaterialArmor), materialBox.Text)); cmd_1.Parameters.AddWithValue("@param4", (int)(EnumDefinition.EnumType.InventoryTypeArmor)Enum.Parse(typeof(EnumDefinition.EnumType.InventoryTypeArmor), inventoryTypeBox.Text)); MySqlCommand cmd_2 = new MySqlCommand(@"INSERT INTO " + EnumDefinition.EnumType.Tables.item_appearance.ToString() + " (" + getTableColumns(EnumDefinition.EnumType.Tables.item_appearance.ToString()) + ") VALUES (@param1,@param2,@param3,3472000,@param4,0)", con.TheConnection); cmd_2.Parameters.AddWithValue("@param1", itemID2Txt.Text); cmd_2.Parameters.AddWithValue("@param2", displayIDTxt.Text); cmd_2.Parameters.AddWithValue("@param3", iconFileDataIDTxt.Text); cmd_2.Parameters.AddWithValue("@param4", 3); MySqlCommand cmd_3 = new MySqlCommand(@"INSERT INTO " + EnumDefinition.EnumType.Tables.item_modified_appearance.ToString() + " (" + getTableColumns(EnumDefinition.EnumType.Tables.item_modified_appearance.ToString()) + ") VALUES (@param1,@param2,0,@param3,0,4,0)", con.TheConnection); cmd_3.Parameters.AddWithValue("@param1", itemIDTxt.Text); cmd_3.Parameters.AddWithValue("@param2", itemID3Txt.Text); cmd_3.Parameters.AddWithValue("@param3", itemID2Txt.Text); MySqlCommand cmd_4 = new MySqlCommand(@"INSERT INTO " + EnumDefinition.EnumType.Tables.item_sparse.ToString() + " (" + getTableColumns(EnumDefinition.EnumType.Tables.item_sparse.ToString()) + ") " + @" VALUES (@param1,-1,@param2,@param3,@param4,@param5,@param6,0,8192,0,0,0,0,0,1,1,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5,0,0,-1,930,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,@param7,@param8,110,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2,0,0,@param9,0,0,0,0,0,0,0,6,0)", con.TheConnection); cmd_4.Parameters.AddWithValue("@param1", itemIDTxt.Text); cmd_4.Parameters.AddWithValue("@param2", itemNameTxt.Text); cmd_4.Parameters.AddWithValue("@param3", itemNameTxt.Text); cmd_4.Parameters.AddWithValue("@param4", itemNameTxt.Text); cmd_4.Parameters.AddWithValue("@param5", itemNameTxt.Text); cmd_4.Parameters.AddWithValue("@param6", itemDescTxt.Text); cmd_4.Parameters.AddWithValue("@param7", (int)(EnumDefinition.EnumType.Quality)Enum.Parse(typeof(EnumDefinition.EnumType.Quality), qualityBox.Text)); cmd_4.Parameters.AddWithValue("@param8", (int)(EnumDefinition.EnumType.InventoryTypeArmor)Enum.Parse(typeof(EnumDefinition.EnumType.InventoryTypeArmor), inventoryTypeBox.Text)); cmd_4.Parameters.AddWithValue("@param9", (int)(EnumDefinition.EnumType.MaterialArmor)Enum.Parse(typeof(EnumDefinition.EnumType.MaterialArmor), materialBox.Text)); MySqlCommand cmd_5 = new MySqlCommand(@"INSERT INTO " + EnumDefinition.EnumType.Tables.hotfix_data.ToString() + " (" + getTableColumns(EnumDefinition.EnumType.Tables.hotfix_data.ToString()) + ") VALUES (@param1,@param2,@param3,0)", con.TheConnection); cmd_5.Parameters.AddWithValue("@param1", hotfixDataMaxID()); cmd_5.Parameters.AddWithValue("@param2", (UInt64)(EnumDefinition.EnumType.Tables)Enum.Parse(typeof(EnumDefinition.EnumType.Tables), EnumDefinition.EnumType.Tables.item.ToString())); cmd_5.Parameters.AddWithValue("@param3", itemIDTxt.Text); MySqlCommand cmd_6 = new MySqlCommand(@"INSERT INTO " + EnumDefinition.EnumType.Tables.hotfix_data.ToString() + " (" + getTableColumns(EnumDefinition.EnumType.Tables.hotfix_data.ToString()) + ") VALUES (@param1,@param2,@param3,0)", con.TheConnection); cmd_6.Parameters.AddWithValue("@param1", hotfixDataMaxID() + 1); cmd_6.Parameters.AddWithValue("@param2", (UInt64)(EnumDefinition.EnumType.Tables)Enum.Parse(typeof(EnumDefinition.EnumType.Tables), EnumDefinition.EnumType.Tables.item_appearance.ToString())); cmd_6.Parameters.AddWithValue("@param3", itemID2Txt.Text); MySqlCommand cmd_7 = new MySqlCommand(@"INSERT INTO " + EnumDefinition.EnumType.Tables.hotfix_data.ToString() + " (" + getTableColumns(EnumDefinition.EnumType.Tables.hotfix_data.ToString()) + ") VALUES (@param1,@param2,@param3,0)", con.TheConnection); cmd_7.Parameters.AddWithValue("@param1", hotfixDataMaxID() + 2); cmd_7.Parameters.AddWithValue("@param2", (UInt64)(EnumDefinition.EnumType.Tables)Enum.Parse(typeof(EnumDefinition.EnumType.Tables), EnumDefinition.EnumType.Tables.item_modified_appearance.ToString())); cmd_7.Parameters.AddWithValue("@param3", itemID3Txt.Text); MySqlCommand cmd_8 = new MySqlCommand(@"INSERT INTO " + EnumDefinition.EnumType.Tables.hotfix_data.ToString() + " (" + getTableColumns(EnumDefinition.EnumType.Tables.hotfix_data.ToString()) + ") VALUES (@param1,@param2,@param3,0)", con.TheConnection); cmd_8.Parameters.AddWithValue("@param1", hotfixDataMaxID() + 3); cmd_8.Parameters.AddWithValue("@param2", (UInt64)(EnumDefinition.EnumType.Tables)Enum.Parse(typeof(EnumDefinition.EnumType.Tables), EnumDefinition.EnumType.Tables.item_sparse.ToString())); cmd_8.Parameters.AddWithValue("@param3", itemIDTxt.Text); if (itemIDTxt.Text != "" && iconFileDataIDTxt.Text != "" && materialBox.Text != "" && inventoryTypeBox.Text != "" && qualityBox.Text != "" && itemID2Txt.Text != "" && itemID3Txt.Text != "" && itemNameTxt.Text != "" && itemDescTxt.Text != "" && displayIDTxt.Text != "") { cmd_1.ExecuteNonQuery(); cmd_2.ExecuteNonQuery(); cmd_3.ExecuteNonQuery(); cmd_4.ExecuteNonQuery(); cmd_5.ExecuteNonQuery(); cmd_6.ExecuteNonQuery(); cmd_7.ExecuteNonQuery(); cmd_8.ExecuteNonQuery(); MessageBox.Show("Your armor item has been hotfixed", "Result", MessageBoxButtons.OK, MessageBoxIcon.Information); con.Disconnect(); } else { MessageBox.Show("You haven't filled all the cells", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); con.Disconnect(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } } else { MessageBox.Show("No Active Connection", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } }