using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Diagnostics;

namespace ManagementSuite
{
    class MSSQLOperations : MSSQL
    {
        public MSSQLOperations(string server, string username, string password, string database)
        : base(server, username, password, database)
        {

        }
    }

    class MySQLOperations : MySQL
    {
        public MySQLOperations(string server, string username, string password, string database)
        : base(server, username, password, database)
        {

        }

        //Get MD% Hash for passwords
        public string GetMD5Hash(string input)
        {
            System.Security.Cryptography.MD5CryptoServiceProvider x = new System.Security.Cryptography.MD5CryptoServiceProvider();
            byte[] bs = System.Text.Encoding.UTF8.GetBytes(input);
            bs = x.ComputeHash(bs);
            System.Text.StringBuilder s = new System.Text.StringBuilder();
            foreach (byte b in bs)
            {
                s.Append(b.ToString("x2").ToLower());
            }

            string password = s.ToString();
            return password;
        }

        //Take bad words out of string
        public string Sanatize(string Input)
        {
            string[] BadCharacters = { "'", "\"", "%", "*", "#", "(", ")", ";", "--", "/", "NULL", "TRUNCATE", "DROP", "UPDATE", "SELECT", "LOAD FILE", "LOAD INFILE", "group_concat", "extractvalue", "0x27" };

            foreach (string Character in BadCharacters)
            {
                Input = Input.Replace(Character, "");
            }

            return Input;
        }

        public bool AdminLogin(string PacketData)
        {
            string[] Data = PacketData.Split('&');
            string User = Data[0];
            string password = Data[1];
            string Salt = "kikugalanet";
            User = Sanatize(User);

            Console.WriteLine("Username:  {0}\nPassword: {1}", User, password);

            string[] Password = ReturnQuery("SELECT flyff_passwordhash FROM flyff_accounts WHERE flyff_accountname='" + User + "'");
            string[] Auth = ReturnQuery("SELECT flyff_authoritylevel FROM flyff_accounts WHERE flyff_accountname='" + User + "'");

            if (Password[0] == GetMD5Hash(Salt + password) && Auth[0] == "120")
            {
                return true;
            }
            else
            {
                return false;
            }
        }

        public bool Login(string PacketData)
        {
            string[] Data = PacketData.Split('\t');
            string User = Data[0];
            string password = Data[1];
            string Salt = "kikugalanet";
            User = Sanatize(User);
            string[] Password = ReturnQuery("SELECT flyff_passwordhash FROM flyff_accounts WHERE flyff_accountname='" + User + "'");

            if (Password[0] == GetMD5Hash(Salt + password))
            {
                return true;
            }
            else
            {
                return false;
            }
        }

        public void Register(string PacketData)
        {
            string[] Data = PacketData.Split('\t');

            string Salt = "kikugalanet";
            string Account = Data[0];
            string Password = Data[1];
            string Email = Data[2];

            Account = Sanatize(Account);
            Password = GetMD5Hash(Salt + Password);
            Email = Sanatize(Email);

            NonReturnQuery("INSERT INTO flyff_accounts ('flyff_username', 'flyff_passwordhash', 'flyff_email') VALUES ('" + Account + "', '" + Password + "', '" + Email + "')");

            ConsoleOp.Email("Welcome!", "Welcome to our server " + Account + ". Your password is " + Password, Email);
        }

        public void MakeGM(string PacketData)
        {
            string accName = Sanatize(PacketData);
            NonReturnQuery("UPDATE flyff_accounts SET flyff_authoritylevel = '80' WHERE flyff_accountname = '" + accName + "'");
        }

        public void ChangePassword(string PacketData)
        {
            string[] Data = PacketData.Split('\t');

            string Salt = "kikugalanet";
            string Account = Data[0];
            string Password = Data[1];
            Account = Sanatize(Account);
            string PasswordHash = GetMD5Hash(Salt + Password);

            NonReturnQuery("UPDATE flyff_accounts SET flyff_passwordhash = '" + PasswordHash + "' WHERE flyff_accountname = '" + Account + "'");

            string[] Email = ReturnQuery("SELECT flyff_email FROM flyff_accounts WHERE flyff_accountname='" + Account + "'");

            ConsoleOp.Email("Password update", "Your new password is " + Password + " . Have a great day!", Email[0]);
        }

        public void ChangeEmail(string PacketData)
        {
            string[] Data = PacketData.Split('\t');

            string Account = Data[0];
            string Email = Data[1];

            Account = Sanatize(Account);
            Email = Sanatize(Email);

            NonReturnQuery("UPDATE flyff_accounts SET flyff_email = '" + Email + "' WHERE flyff_accountname = '" + Account + "'");

            ConsoleOp.Email("E-Mail update", "Thanks for letting us know about your new e-mail! Have a great day!", Email);
        }

        public void MakePlayer(string PacketData)
        {
            string accName = Sanatize(PacketData);
            NonReturnQuery("UPDATE flyff_accounts SET flyff_authoritylevel = '70' WHERE flyff_accountname = '" + accName + "'");
        }

        public void BanAcc(string PacketData)
        {
            string accName = Sanatize(PacketData);
            NonReturnQuery("UPDATE flyff_accounts SET flyff_authoritylevel = '0' WHERE flyff_accountname = '" + accName + "'");
            string[] Email = ReturnQuery("SELECT flyff_email FROM flyff_accounts WHERE flyff_accountname='" + accName + "'");
            //Email
            ConsoleOp.Email("Account status", "Your account has been temporarily banned while our team carries about an investigation. Please respond to this e-mail with character name and cluster so we may resolve this faster!", Email[0]);
        }

        public void UnBanAcc(string PacketData)
        {
            string accName = Sanatize(PacketData);
            NonReturnQuery("UPDATE flyff_accounts SET flyff_authoritylevel = '70' WHERE flyff_accountname = '" + accName + "'");
            string[] Email = ReturnQuery("SELECT flyff_email FROM flyff_accounts WHERE flyff_accountname='" + accName + "'");
            //Email
            ConsoleOp.Email("Account status", "Your account has been unbanned. Enjoy the game! Please don't respond to this e-mail unless you have further issues.", Email[0]);
        }
    }
}