SQLManager.cs

using System.Threading.Tasks;
using UnityEngine;
using UnityEngine.Networking;
using System.Text;

public static class SQLManager
{
    private const string SERVER_URL = "localhost:80/new_sql";
    private const int REQUEST_TIMEOUT = 100;

    // Store the current username
    private static string _currentUsername = "";

    // to access the current user
    public static string CurrentUsername
    {
        get { return _currentUsername; }
        private set { _currentUsername = value; }
    }

    public static bool IsLoggedIn
    {
        get { return !string.IsNullOrEmpty(_currentUsername); }
    }

    public static async Task<(bool success, int errorCode, string message)> RegisterUser(string username, string password)
    {
        string REGISTER_USER_URL = $"{SERVER_URL}/RegisterUser.php";

        // Create JSON data
        var userData = new UserData
        {
            username = username,
            password = password
        };

        var result = await SendJsonRequest(REGISTER_USER_URL, userData);

        return (result.success, result.errorCode, result.returnMessage);
    }

    public static async Task<(bool success, int errorCode, string username)> LoginUser(string username, string password)
    {
        string LOGIN_USER_URL = $"{SERVER_URL}/login.php";

        
        // Create JSON data
        var userData = new UserData
        {
            username = username,
            password = password
        };

        var result = await SendJsonRequest(LOGIN_USER_URL, userData);

       
        // Store the username if login was successful
        if (result.success)
        {
            CurrentUsername = username;

            // Save username to PlayerPrefs for persistence across app restarts
            PlayerPrefs.SetString("Username", username);
            PlayerPrefs.Save();

        
        }

        return (result.success, result.errorCode, result.returnMessage);
    }

    public static void LoadSavedSession()
    {
        // Try to load a saved username
        if (PlayerPrefs.HasKey("Username"))
        {
            CurrentUsername = PlayerPrefs.GetString("Username");

        }
    }

    public static void Logout()
    {
        // Clear the session
        CurrentUsername = "";

        // Remove saved username
        PlayerPrefs.DeleteKey("Username");
        PlayerPrefs.Save();

    }


    private static async Task<(bool success,int errorCode, string returnMessage)> SendJsonRequest(string url, object data)
    {
        // Serialize the data object to JSON
        string jsonData = JsonUtility.ToJson(data);

        using (UnityWebRequest req = new UnityWebRequest(url, "POST"))
        {

            byte[] bodyRaw = Encoding.UTF8.GetBytes(jsonData);
            req.uploadHandler = new UploadHandlerRaw(bodyRaw);
            req.downloadHandler = new DownloadHandlerBuffer();

            // Set content type header for JSON
            req.SetRequestHeader("Content-Type", "application/json");

            // Send the request
            req.SendWebRequest();

            // Wait for the request
            while (!req.isDone) await Task.Delay(REQUEST_TIMEOUT);


            if (req.result != UnityWebRequest.Result.Success)
            {
                return (false, -1, req.error);
            }

            // Parse JSON response
            try
            {
                ServerResponse response = JsonUtility.FromJson<ServerResponse>(req.downloadHandler.text);

                if (response != null)
                {
                    if (response.success)
                    {
                        return (true, 0, response.message ?? "Success");
                    }
                    else
                    {
                        return (false, response.error, response.message ?? $"Error code: {response.error}");
                    }
                }
                else
                {
                    return (false, -1, "Invalid server response format");
                }
            }
            catch (System.Exception e)
            {
                return (false, -1, $"Error parsing response: {req.downloadHandler.text}");
            }
        }
    }

    
}

// Need to be serializable for JsonUtility
[System.Serializable]
public class UserData
{
    public string username;
    public string password;
}


[System.Serializable]
public class ServerResponse
{
    public bool success;
    public int error;
    public string message;
    public string username;
}