#include <a_samp>

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

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

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
}

#define Script "#1"

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

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

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

public OnPlayerRequestClass(playerid, classid)
{
	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) {
	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 putea inregistra (minim 6 caractere / maxim 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);

                gString[0] = EOS;
                format(gString, sizeof(gString), "Parola ta contine %d caractere.", strlen(inputtext));
                SCM(playerid, -1, gString);

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

                ShowPlayerDialog(playerid, DIALOG_EMAIL, DIALOG_STYLE_INPUT, "Email", "Seteaza-ti adresa de email:", "Select", "Cancel");
        }
        case DIALOG_EMAIL: {
                   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 putea inregistra (minim 6 caractere / maxim 32:", "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, );

                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", "Seteaza-ti sex-ul:", "Masculin", "Feminin");
       }
       case DIALOG_GENDER: {
           switch(response) {
              case 0: {
                  PlayerInfo[playerid][pGender] = 1;
                  SCM(playerid, -1, "Sex setat: Feminin");
              }
              case 1: {
                  PlayerInfo[playerid][pGender] = 0;
                  SCM(playerid, -1, "Sex setat: Masculin");
           }
       }

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

                SpawnPlayer(playerid);
	}
	case DIALOG_LOGIN: {
       if(!response)
           return Kick(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 putea inregistra (minim 6 caractere / maxim 32 caractere):", "Select", "Cancel");
         case 1:ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, "Login", "Scrie parola pentru a te putea loga:", "Select", "Cancel");
     }
     return 1;
}


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