#include <a_samp>
#include <a_mysql>
new SQL = -1, gQuery[256], gString[256];

#define function%0(%1)  forward %0(%1); public %0(%1)
#define SCM             SendClientMessage

#define COLOR_RED   0xff0000FF
#define COLOR_LGREEN    0x00ff00FF

new
    incercariParola[MAX_PLAYERS];

enum pInfo {
    pSQLID,
    pName[MAX_PLAYER_NAME],
    pPassword[32],
    pEmail[32],
    pGender
}

new PlayerInfo[MAX_PLAYERS][pInfo];

enum {
    // Register
    DIALOG_REGISTER,
    DIALOG_EMAIL,
    DIALOG_GENDER,

    // Login
    DIALOG_LOGIN
}

main() { print("Gamemode-ul este in curs de procesare..."); }

public OnGameModeInit()
{
    SQL = mysql_connect("localhost", "root", "database", "");

    // Don't use these lines if it's a filterscript
    SetGameModeText("Blank Script");
    AddPlayerClass(0, 1958.3783, 1343.1572, 15.3746, 269.1425, 0, 0, 0, 0, 0, 0);
    return 1;
}

public OnPlayerRequestClass(playerid, classid)
{
    TogglePlayerSpectating(playerid, false);

    SetPlayerPos(playerid, 1958.3783, 1343.1572, 15.3746);
    SetPlayerCameraPos(playerid, 1958.3783, 1343.1572, 15.3746);
    SetPlayerCameraLookAt(playerid, 1958.3783, 1343.1572, 15.3746);
    return 1;
}

public OnPlayerConnect(playerid) {
    incercariParola[playerid] = 0;

    gQuery[0] = EOS;
    mysql_format(SQL, gQuery, sizeof(gQuery), "SELECT * FROM `users` WHERE `Name`='%s' LIMIT 1", GetName(playerid));
    mysql_tquery(SQL, gQuery, "checkAccount", "i", playerid);
    return 1;
}

public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[]) {
    switch(dialogid) {
        case DIALOG_REGISTER: {
            if(!response)
                return Kick(playerid);

            if(strlen(inputtext) < 6 || strlen(inputtext) > 32)
                return ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_PASSWORD, "Register", "Scrie o parola pentru a te inregistra(min.6 caractere/max.32):", "Select", "Cancel");

            gQuery[0] = EOS;
            mysql_format(SQL, gQuery, sizeof(gQuery), "INSERT INTO `users` (`Name`, `Password`) VALUES ('%s', '%s')", GetName(playerid), inputtext);
            mysql_tquery(SQL, gQuery, "insertAccount", "i", playerid);

            SCM(playerid, -1, "Parola a fost setata.");

            format(PlayerInfo[playerid][pPassword], 32, inputtext);

            ShowPlayerDialog(playerid, DIALOG_EMAIL, DIALOG_STYLE_INPUT, "Email", "Introdu adresa ta de Email:", "Select", "Cancel");
        }
        case DIALOG_EMAIL: {
            if(!response)
                return Kick(playerid);

            if(strlen(inputtext) < 6 || strlen(inputtext) > 32)
                return ShowPlayerDialog(playerid, DIALOG_EMAIL, DIALOG_STYLE_INPUT, "Email", "Introdu adresa ta de Email:", "Select", "Cancel");

            gQuery[0] = EOS;
            mysql_format(SQL, gQuery, sizeof(gQuery), "UPDATE `users` SET `Email`='%s' WHERE `ID`='%d'", inputtext, PlayerInfo[playerid][pSQLID]);
            mysql_tquery(SQL, gQuery, "", "", playerid);

            gString[0] = EOS;
            format(gString, sizeof(gString), "Email setat: %s", inputtext);
            SCM(playerid, -1, gString);

            format(PlayerInfo[playerid][pEmail], 32, inputtext);

            ShowPlayerDialog(playerid, DIALOG_GENDER, DIALOG_STYLE_MSGBOX, "Gender", "Alege sexul:", "Masculin", "Feminin");
        }
        case DIALOG_GENDER: {
            switch(response) {
                case 0: {
                    PlayerInfo[playerid][pGender] = 1;
                    SCM(playerid, -1, "Ai ales sexul feminin.");
                    SCM(playerid, COLOR_LGREEN, "Te-ai inregistrat cu succes!");
                }
                case 1: {
                    PlayerInfo[playerid][pGender] = 0;
                    SCM(playerid, -1, "Ai ales sexul masculin.");
                    SCM(playerid, COLOR_LGREEN, "Te-ai inregistrat cu succes!");
                }
            }
            gQuery[0] = EOS;
            mysql_format(SQL, gQuery, sizeof(gQuery), "UPDATE `users` SET `Gender`='%d' WHERE ID='%d", PlayerInfo[playerid][pGender], PlayerInfo[playerid][pSQLID]);
            mysql_tquery(SQL, gQuery, "", "", playerid);

            SpawnPlayer(playerid);
        }
        case DIALOG_LOGIN: {
            if(!response)
                return Kick(playerid);

            mysql_format(SQL, gQuery, sizeof(gQuery), "SELECT * FROM `users` WHERE `Name`='%s' AND `Password`='%s' LIMIT 1", GetName(playerid), inputtext);
            mysql_tquery(SQL, gQuery, "onLogin", "i", playerid);
        }
    }
    return 1;
}

function onLogin(playerid) {
    switch(cache_num_rows()) {
        case 0: {
            incercariParola[playerid] ++;

            gString[0] = EOS;
            format(gString, sizeof(gString), "Parola incorecta! (%d/3 incercari ramase)", incercariParola[playerid]);
            SCM(playerid, COLOR_RED, gString);

            if(incercariParola[playerid] == 3) Kick(playerid);
            else ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, "Login", "Scrie parola pentru a te conecta:", "Select", "Cancel");
        }
        case 1: {
            new
                result[64];

            PlayerInfo[playerid][pSQLID] = cache_get_field_content_int(0, "ID");
            PlayerInfo[playerid][pGender] = cache_get_field_content_int(0, "Gender");

            cache_get_field_content(0, "Name", result); format(PlayerInfo[playerid][pName], MAX_PLAYER_NAME, result);
            cache_get_field_content(0, "Password", result); format(PlayerInfo[playerid][pPassword], 32, result);
            cache_get_field_content(0, "Email", result); format(PlayerInfo[playerid][pEmail], 32, result);

            printf("%s (user: %d) s-a conectat. [Password: %s, Email: %s, Gender:%d]", GetName(playerid), PlayerInfo[playerid][pSQLID], PlayerInfo[playerid][pPassword], PlayerInfo[playerid][pEmail], PlayerInfo[playerid][pGender]);

            for(new i = 0; i < 25; i++) SCM(playerid, -1, " ");
            SCM(playerid, COLOR_LGREEN, "Te-ai conectat cu succes!");

            SpawnPlayer(playerid);
        }
    }
    return 1;
}

function insertAccount(playerid) {
    PlayerInfo[playerid][pSQLID] = cache_insert_id();
    printf("%s s-a inregistrat cu SQLID-ul #%d.", GetName(playerid), PlayerInfo[playerid][pSQLID]);
    return 1;
}

function checkAccount(playerid) {
    switch(cache_num_rows()) {
        case 0: ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_PASSWORD, "Register", "Scrie o parola pentru a te inregistra(min.6 caractere/max.32):", "Select", "Cancel");
        case 1: ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, "Login", "Scrie parola pentru a te conecta:", "Select", "Cancel");
    }
    return 1;
}

stock GetName(playerid) {
    new playerName[MAX_PLAYER_NAME];
    GetPlayerName(playerid, playerName, MAX_PLAYER_NAME);
    return playerName;
}