AMHE

using System;
using System.Configuration;
using System.Net.Mail;
using System.Net;

using MySql.Data.MySqlClient;

namespace AMHE
{
    public class Program
    {
        static void Main(string[] args)
        {
            DbInfos infos = new DbInfos();
            MySqlConnection mySqlConn = new MySqlConnection();
            MySqlCommand command;
            MySqlDataReader reader;


            string dbServerIp = ConfigurationSettings.AppSettings.Get("ServerIP");
            string dbPort = ConfigurationSettings.AppSettings.Get("DbPort");
            string dbUserId = ConfigurationSettings.AppSettings.Get("DbUserID");
            string dbPassword = ConfigurationSettings.AppSettings.Get("DbPassword");
            string dbName = ConfigurationSettings.AppSettings.Get("DbName");


            mySqlConn.ConnectionString = "Server=" + dbServerIp + "userid=" + dbUserId +
                                         "password=" + dbPassword + "port=" + dbPort + "database=" + dbName;

            string emailSubject = ConfigurationSettings.AppSettings.Get("EmailSubject");


            string toEmailAddress = ConfigurationSettings.AppSettings.Get("ToEmail");

            string fromEmailAddress = ConfigurationSettings.AppSettings.Get("FromEmail");
            string fromEmailPassword = ConfigurationSettings.AppSettings.Get("FromPassword");

            string smtpHost = ConfigurationSettings.AppSettings.Get("smtpHost");
            string smtpPort = ConfigurationSettings.AppSettings.Get("smtpPort");


            string maxAllowedCashOnHand = ConfigurationSettings.AppSettings.Get("CashOnHand");
            string maxAllowedBankCash = ConfigurationSettings.AppSettings.Get("BankCash");

            int counter = 0;

            try
            {
                mySqlConn.Open();

                string query = "SELECT * " +
                               "FROM " + dbName + ".players " +
                               "WHERE cash >= " + Int32.Parse(maxAllowedCashOnHand) +
                               "OR bankacc >= " + Int32.Parse(maxAllowedBankCash);

                command = new MySqlCommand(query, mySqlConn);
                reader = command.ExecuteReader();


                while (reader.Read())
                {

                    infos.suspectedPlayers[counter] = reader.GetString("name") + ",";
                    infos.playerId[counter] = reader.GetString("playerid") + ",";
                    infos.databaseId[counter] = reader.GetString("id") + ",";
                    infos.cashOnHand[counter] = reader.GetString("cash") + ",";
                    infos.moneyInBank[counter] = reader.GetString("bankacc") + ",";
                    counter++;
                }

                mySqlConn.Close();
            }

            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
            }

            finally
            {
                mySqlConn.Dispose();
            }

            for (int i = 0; i < counter; i++)
            {
                var fromMessage = new MailAddress(fromEmailAddress, "Possible Hacker Alert System");
                string fromPassword = fromEmailPassword;


                var toMessage = new MailAddress(toEmailAddress);

                string subject = emailSubject + infos.suspectedPlayers[i];

                string body = "Player name: " + infos.suspectedPlayers[i] +
                              "\n" + "Player ID: " + infos.playerId[i] +
                              "\n" + "Database ID: (UID)" + infos.databaseId[i] +
                              "\n" + "Player cash on hand: " + infos.cashOnHand[i] +
                              "\n" + "Player bank amount: " + infos.moneyInBank[i];

                Console.WriteLine(body);

                var smtp = new SmtpClient
                {
                    Host = smtpHost,
                    Port = Int32.Parse(smtpPort),
                    EnableSsl = true,
                    DeliveryMethod = SmtpDeliveryMethod.Network,
                    Credentials = new NetworkCredential(fromMessage.Address, fromPassword),
                    Timeout = 20000
                };

                using (var message = new MailMessage(fromMessage, toMessage)
                {
                    Subject = subject,
                    Body = body
                })
                {
                    smtp.Send(message);
                }

            }
            Console.WriteLine("Message Sent\nPlease Press any button to exit...");
            Console.ReadLine();
        }
    }
}