using System.Collections;
using System.Collections.Generic;
using UnityEngine;
using UnityEngine.UI;
using MySql;
using MySql.Data;
using MySql.Data.MySqlClient;

public class Clickevent : MonoBehaviour {

    const string Database_server = "localhost";
    const string Database_Username = "Admin";
    const string Database_Password = "1374";
    const string Database_Table = "oxide";

    public Text Input_Username;
    public Text Input_Password;

    // MYSQL
    MySqlConnection Mysqlconn;
    string ConnectionString = "server=" + Database_server + ";" + "user id=" + Database_Username + ";" + "password=" + Database_Password + ";" + "database=" + Database_Table;
    MySqlCommand MysqlLogin;
    MySqlDataReader MysqlReader;


    // Connect to Mysql Database
    private bool MysqlConnect()
    {
        // Connect to Database
        Mysqlconn.ConnectionString = ConnectionString;
        Mysqlconn.Open();

        if (Mysqlconn.State == System.Data.ConnectionState.Open)
        {

            Debug.Log("Connected to Database");

            return true;

        }
        else
        {

            Debug.Log("Can't Connect to Database");

            return false;

        }

    }

    // Login to Player Account
    public void Login()
    {

        MysqlConnect();

    }


    // Play Offline
    public void Playoffline()
    {



    }


    // Host a Game
	public void HostandPlay()
    {



    }


    // Connect to Server
    public void JoinGame()
    {



    }


    // Open the Setting Window
    public void Settings()
    {



    }


    // Exit the Game
    public void Exit()
    {

        Application.Quit();

    }


}