// Include
#include <a_samp>
#include <a_mysql>
// Define
#define function%0(%1)   forward%0(%1); public%0(%1)
#define SCM 			SendClientMessage
// Colors
#define COLOR_RED 		0xff0000FF
#define COLOR_GREEN		0x04ff00FF
// New
new SQL = -1, gQuery[256], gString[256];
new
	incercariParola[MAX_PLAYERS];
// Enum
enum pInfo {
	pSQLID,
	pName[MAX_PLAYERS],
	pPassword[32],
	pEmail[32],
	pGender
}
new PlayerInfo[MAX_PLAYERS][pInfo];
enum {
	// Register
	DIALOG_REGISTER,
	DIALOG_EMAIL,
	DIALOG_GENDER,

	// Login
	DIALOG_LOGIN
}
// Started Gamemode
main()
{
	print("\n----------------------------------");
	print(" Starting gamemode by NighTeN");
	print("----------------------------------\n");
}

public OnGameModeInit()
{
	SQL = mysql_connect("localhost", "root", "NewGM", "");
	SetGameModeText("RPG ROMANIA v0.1");
	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) {
	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", "Parola trebuie sa contina 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", "Scrieti 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", "Parola trebuie sa contina 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, "", "", 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", "Seteaza-ti sexul", "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'", 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
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!", "Select", "Cancel");
		case 1:	ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, "Login", "Scrieti parola pe care o ai!", "Login", "Cancel");
	}
	return 1;
}
function insertAccount(playerid) {
	PlayerInfo[playerid][pSQLID] = cache_insert_id();
	printf("[REGISTER] %s s-a inregistrat cu SQLID-ul #%d.", GetName(playerid), PlayerInfo[playerid][pSQLID]);
	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]);
			SendClientMessage(playerid, COLOR_RED, gString);

			if(incercariParola[playerid] == 3) return Kick(playerid);

			else ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, "Login", "Scrieti parola pe care o ai!", "Login", "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 logat. [Gender: %d, Name: %s, Password: %s, Email: %s", GetName(playerid), PlayerInfo[playerid][pSQLID], PlayerInfo[playerid][pGender], PlayerInfo[playerid][pName], PlayerInfo[playerid][pPassword], PlayerInfo[playerid][pEmail]);

			for(new i = 0; i < 25; i++) SendClientMessage(playerid, -1, " ");
			SendClientMessage(playerid, COLOR_GREEN, "Te-ai logat cu succes");
		}
	}
	return 1;
}
// Stock
stock GetName(playerid) {
	new playerName[MAX_PLAYER_NAME];
	GetPlayerName(playerid, playerName, MAX_PLAYER_NAME);
	return playerName;
}