static bool SendEmail(string email, string username, string authCode = "", byte authType = 1)
{
try
{
bool isNull = string.IsNullOrWhiteSpace(authCode);
if (isNull)
authCode = GenerateAuthCode(email);
MySqlCommand q = new MySqlCommand("SELECT Count(*) FROM authcodes WHERE User=@User AND AuthType=" + authType, SQL);
q.Parameters.AddWithValue("@User", username);
MySqlDataReader r = q.ExecuteReader();
bool noAuth = r.Read() && r.GetInt16(0) == 0;
r.Close();
if (noAuth && isNull)
{
q.CommandText = "INSERT INTO authcodes VALUES (@AuthType,@Value,@User);";
q.Parameters.AddWithValue("@AuthType", authType);
q.Parameters.AddWithValue("@Value", authCode);
q.ExecuteNonQuery();
}
MailAddress from = new MailAddress(EmailUsername, "Auxilium");
MailMessage mail = new MailMessage
{
From = from,
Subject = "Registration code for Auxilium",
Body = "Your registration code for auxilium is: " + authCode
};
mail.To.Add(email);
EmailClient.Credentials = new NetworkCredential(from.Address, EmailPassword);
EmailClient.SendAsync(mail, null);
return true;
} catch {
return false;
}
}