using UnityEngine;

using System.Collections;

using mClient = MySql.Data.MySqlClient; //Is used on every single mysql type in the script it may be taken out, it's being used to keep track of mysql types used in the script, so it's purely optional, take out or put in is your choice

using System;

using System.Text;



public class nTrol: MonoBehaviour

{

    public String Username;

    public String Password;

    public String tword;

    public int[] Data = new int[40];

    public String tempData;

    public bool loginSuccess;



    bool login()

    {

        string connectionString = "server=127.0.0.1;userid=user;password=pass;database=thebro"; //Command needed for the server to connect to the mysql server

        mClient.MySqlConnection myConnection = new mClient.MySqlConnection(connectionString); //Instantiates a new mysqlconnection object that will take in the connection parameters above

        mClient.MySqlCommand command = new mClient.MySqlCommand("SELECT Password FROM account WHERE Username IN ('" + Username + "')", myConnection); //Mysql command that gets the players password to check based on the username

        //Reads the mysql data we just requested

        mClient.MySqlDataReader reader;

        myConnection.Open();

        reader = command.ExecuteReader();



        while (reader.Read())

        {

            for (int i = 0; i < reader.FieldCount; i++)

            {

                tPassword = reader.GetValue(i).ToString()+ ""; //Set a temp password for the server to store the password we got back from the server

            }

        }



        myConnection.Close();



        if (tword == tempPad) //If login is a success return true and the password the player sent to the server equals the password we got back from the server

        {

            getClass();

            myConnection.Close();

            return true;

        }



        else //If login is a failure return false which is when the password we got back from the server does not match the password the player sent

        {

            rname = "";

            assword = "";

            myConnection.Close();

            return false;

        }

    }



    void OnPlayerDisconected(NetworkPlayer player)

    {

        Debug.Log("Clean up after player " + player);

        Network.RemoveRPCs(player);

        Network.DestroyPlayerObjects(player);

    }



    void CloseAllConnections()

    {

        Network.maxConnections = -1;

    }



    void noNewConnections()

    {

        Network.maxConnections = 0;

    }



    //Check to see if the username already exist

    bool ch(String name)

    {

        string tUseTest = "";

        string connectring = "server=127.0.0.1;userid=user;password=pass;database=thebro";

        mClient.MySqlConnection myConnection = new mClient.MySqlConnection(connectionString);

        mClient.MySqlCommand command = new mClient.MySqlCommand("SELECT Username FROM account WHERE Username IN ('" + n + "')", myConnection);

        mClient.MySqlDataReader reader;

        myConnection.Open();

        reader = command.ExecuteReader();



        while (reader.Read())

        {

            for (int i = 0; i < reader.FieldCount; i++)

            {

                tUsernameTest = reader.GetValue(i).ToString()+ "";

            }

        }



        myConnection.Close();



        if (tUsTest == na)

        {

            myConnection.Close();

            return true;

        }



        else

        {

            myConnection.Close();

            return false;

        }

    }



    void getClass()

    {

        string connectionString = "server=127.0.0.1;userid=user;password=pass;database=thebro";

        mClient.MySqlConnection myConnection = new mClient.MySqlConnection(connectionString);

        mClient.MySqlCommand commandStat = new mClient.MySqlCommand("SELECT Lv,Class,UserID FROM account WHERE Username IN ('" + tempUse + "')", myConnection);

        mClient.MySqlDataReader readerStat;

        myConnection.Open();

        readerStat = commandStat.ExecuteReader();



        while (readerStat.Read())

        {

            for (int i = 0; i < readerStat.FieldCount; i++)

            {

                tempData = readerStat.GetValue(i).ToString()+ " ";

                Data[i] = Convert.ToInt32(tempData);

            }

        }

        tempUame = "";

        tempPord = "";

        myConnection.Close();

    }



    //Creates a new account in the database

    void newAccountServer(String ne, String ps)

    {
pass;database=thebro"; //String to connect to the server

        mClient.MySqlConnection myConnection = new mClient.MySqlConnection(connectionString);

        mClient.MySqlCommand commandStat = new mClient.MySqlCommand("INSERT INTO account (Username,Password) VALUES('" + e + "','" + s + "')", myConnection);

        myConnection.Open();

        commandStat.ExecuteNonQuery();

        myConnection.Close();

    }



    //Method to be called to request a login from the client

    void startLogin(String name, String password)

    {

        networkView.RPC("remot", RPCMode.Server, networkView.viewID, na, passd);

    }



    void stare(String name, String password)

    {

        networkView.RPC("newAt", RPCMode.Server, networkView.viewID, na, passw);

        Network.Disconnect(); //We disconnect from the server after sending this message so that we can reconnect again when we want to login, which clears up any errors that may exist by just calling Network.Connect(); a second time while still connected

    }



    [RPC]

    void remotin(NetworkViewID teD, String loame, String loginord) //The message received by the server to log the player in

    {

        tempUame = logime;

        tempPaord = logissword;

        logccess = login();

        for (int d=0;d<40;d++)

        {

            networkView.RPC("recgin", RPCMode.Others, d, Data[d],pID, logcess);

        }

    }



    [RPC]

    void receilogin(int d, int data, NetworkViewID tID, bool Suess) //This is what the client receives to be added to the player

    {

        if (networkView.viewID == tempID && Success == true)

        {

            Data[d] = data;

        }



        if (Success == false)

        {

            Network.Disconnect();

        }

    }



    [RPC]

    void newA (NetworkViewID teD, String tUern, String tssn)

    {

        if (checkMe(tUn) == false)

        {

            newAccountServer(trn, tn);

        }

    }

}