Auxilium_Server.Program.HandleResendVerificationPacket C# (CSharp) Method

        static void HandleResendVerificationPacket(Client c)
        {
            MySqlCommand q = new MySqlCommand("SELECT * FROM authcodes WHERE User=@User AND AuthType=1", SQL);
            q.Parameters.AddWithValue("@User", c.Value.Username);

            MySqlDataReader r = q.ExecuteReader();
            bool available = r.Read();

            if (!available) return;

            string authCode = r.GetString("Value");

            SendEmail(c.Value.Email, c.Value.Username, authCode);
        }