/// <summary>
/// Execute NonQuery
/// </summary>
/// <param name="conn"></param>
/// <param name="cmdText"></param>
/// <param name="parameters"></param>
public static void ExecuteNonQuery(this MySqlConnection conn, string cmdText, MySqlParameter[] parameters)
{
conn.CheckNull(nameof(conn));
conn.ExecuteNonQuery(cmdText, parameters, CommandType.Text, null);
}
private void saveLoadout(string[] loadout_data)
{
Func<string, string> qP = quoteParam;
var player_uid = qP(loadout_data[0]);
var loadout = qP(loadout_data[1]);
log(tS(loadout_data));
var cmd = new MySqlConnection(conStr).CreateCommand();
cmd.CommandText = String.Format(@"INSERT INTO player(uid,loadout) VALUES ({0},{1}) ON DUPLICATE KEY UPDATE loadout={1}", player_uid, loadout);
log(cmd.CommandText);
cmd.Connection.Open();
cmd.ExecuteNonQuery();
cmd.Connection.Close();
}
/// <summary>
/// Execute NonQuery
/// </summary>
/// <param name="conn"></param>
/// <param name="cmdText"></param>
/// <param name="commandType"></param>
/// <param name="transaction"></param>
public static void ExecuteNonQuery(this MySqlConnection conn, string cmdText, CommandType commandType, MySqlTransaction transaction)
{
conn.CheckNull(nameof(conn));
conn.ExecuteNonQuery(cmdText, null, commandType, transaction);
}
