private void bgwBuyVariant_DoWork(object sender, DoWorkEventArgs e) { string[] args = (string[])e.Argument; string fullFileName = args[0]; string saveDir = args[1]; try { //Decreasing Credit string sql = "UPDATE phpap_AKusers SET money = @DeductedCash WHERE Username=@User"; MySqlCommand cmd = new MySqlCommand(sql, Program.AKsqlcon); MySqlParameter DeductedCashP = new MySqlParameter(); DeductedCashP.ParameterName = "@DeductedCash"; DeductedCashP.Value = cash - variantCost; cmd.Parameters.Add(DeductedCashP); MySqlParameter EmailP = new MySqlParameter(); EmailP.ParameterName = "@User"; EmailP.Value = Program.username; cmd.Parameters.Add(EmailP); cmd.ExecuteNonQuery(); } catch (Exception ex) { if (ex != null) { OnBuyLog update = new OnBuyLog(Log.Info); update.Invoke(ex.Message); return; } } cash -= variantCost; string finalFilePath = string.Format("{0}\\{1}", saveDir, fullFileName); File.Create(finalFilePath).Close(); StreamWriter sw = new StreamWriter(finalFilePath); sw.Write(variant.DumpToString()); sw.Close(); }