static bool InsertFTPCredential(MySqlCommand cmd, ulong countryId, FTPCredential item)
{
lock (cmd)
{
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("HOST", countryId);
cmd.Parameters.AddWithValue("PORT", item.Port);
cmd.Parameters.AddWithValue("TYPE", item.Type.ToString());
cmd.Parameters.AddWithValue("DATE", item.Date.Substring(0, 10));
cmd.Parameters.AddWithValue("HOUR", item.Date.Substring(11, 5));
cmd.Parameters.AddWithValue("USER", NotNull(item.User));
cmd.Parameters.AddWithValue("PASS", NotNull(item.Password));
cmd.Parameters.AddWithValue("VALID", item.IsValid ? 1 : 0);
cmd.CommandText = "INSERT IGNORE INTO credentials_ftp(HOST,PORT,TYPE,DATE,HOUR,USER,PASS,VALID)VALUES(@HOST,@PORT,@TYPE,@DATE,@HOUR,@USER,@PASS,@VALID);";
cmd.ExecuteNonQuery();
return(true);
}
}
static void InsertFTPCredential(MySqlCommand cmd, ulong id, FTPCredential item)
{
}
