//Includes

#include <a_samp>
#include <a_mysql>

//Define Scurtaturi

#define SCM SendClientMessage
#define MONEY GivePlayerMoney
#define LEVEL SetPlayerScore

//Define Dialoguri

#define DIALOG_REGISTER 1
#define DIALOG_LOGIN 2
#define DIALOG_EMAIL 3
#define DIALOG_AGE 4
#define DIALOG_GENDER 5

//Define MySQL

#define mysql_host "localhost" // ip
#define mysql_db "server" //nume baza de date
#define mysql_user "root" //user care are acces la baza de date
#define mysql_pass "" //parola bazei de date

//Define Culori

#define COLOR_RED 0xFF0000FF
#define COLOR_LIGHTBLUE 0x00FFFFFF
#define COLOR_GREEN 0x66FF00FF
#define COLOR_YELLOW 0xFFFF00FF
#define COLOR_ORANGE 0xFF9900FF

//Enumuri

enum pInfo
{
   pID,
   pPassword,
   pEmail,
   pAge,
   pGender,
   pLevel,
   pMoney
}

new PlayerInfo[MAX_PLAYERS][pInfo];
new MySQL:g_Sql;

main()
{
	print("\n----------------------------------");
	print("Serverul a pornit!");
	print("----------------------------------\n");
}

public OnGameModeInit()
{
	MySQLConnect();
	SetGameModeText("RPG v0.1");
	AddPlayerClass(0, 1958.3783, 1343.1572, 15.3746, 269.1425, 0, 0, 0, 0, 0, 0);
	return 1;
}

public OnGameModeExit()
{
    mysql_close( g_Sql );
	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)
{
    new query[100];
	mysql_format(g_Sql, query, sizeof(query), "SELECT * FROM users WHERE Name = '%s'", GetName(playerid));
	mysql_tquery(g_Sql, query, "OnPlayerLogin", "i", playerid);
	return 1;
}

public OnPlayerDisconnect(playerid, reason)
{
	return 1;
}

public OnPlayerSpawn(playerid)
{
	return 1;
}

public OnPlayerDeath(playerid, killerid, reason)
{
	return 1;
}

public OnVehicleSpawn(vehicleid)
{
	return 1;
}

public OnVehicleDeath(vehicleid, killerid)
{
	return 1;
}

public OnPlayerText(playerid, text[])
{
	return 1;
}

public OnPlayerEnterVehicle(playerid, vehicleid, ispassenger)
{
	return 1;
}

public OnPlayerExitVehicle(playerid, vehicleid)
{
	return 1;
}

public OnPlayerStateChange(playerid, newstate, oldstate)
{
	return 1;
}

public OnPlayerEnterCheckpoint(playerid)
{
	return 1;
}

public OnPlayerLeaveCheckpoint(playerid)
{
	return 1;
}

public OnPlayerEnterRaceCheckpoint(playerid)
{
	return 1;
}

public OnPlayerLeaveRaceCheckpoint(playerid)
{
	return 1;
}

public OnRconCommand(cmd[])
{
	return 1;
}

public OnPlayerRequestSpawn(playerid)
{
	return 1;
}

public OnObjectMoved(objectid)
{
	return 1;
}

public OnPlayerObjectMoved(playerid, objectid)
{
	return 1;
}

public OnPlayerPickUpPickup(playerid, pickupid)
{
	return 1;
}

public OnVehicleMod(playerid, vehicleid, componentid)
{
	return 1;
}

public OnVehiclePaintjob(playerid, vehicleid, paintjobid)
{
	return 1;
}

public OnVehicleRespray(playerid, vehicleid, color1, color2)
{
	return 1;
}

public OnPlayerSelectedMenuRow(playerid, row)
{
	return 1;
}

public OnPlayerExitedMenu(playerid)
{
	return 1;
}

public OnPlayerInteriorChange(playerid, newinteriorid, oldinteriorid)
{
	return 1;
}

public OnPlayerKeyStateChange(playerid, newkeys, oldkeys)
{
	return 1;
}

public OnRconLoginAttempt(ip[], password[], success)
{
	return 1;
}

public OnPlayerUpdate(playerid)
{
	return 1;
}

public OnPlayerStreamIn(playerid, forplayerid)
{
	return 1;
}

public OnPlayerStreamOut(playerid, forplayerid)
{
	return 1;
}

public OnVehicleStreamIn(vehicleid, forplayerid)
{
	return 1;
}

public OnVehicleStreamOut(vehicleid, forplayerid)
{
	return 1;
}

public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
{
    new query[128], ip[25];
	switch(dialogid)
	{
	    case DIALOG_REGISTER:
	    {
			if(!response) return Kick(playerid);
			if(response)
			{
			    if(!strlen(inputtext)) return ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_PASSWORD, "Parola Incorecta!", "Introdu-ti o parola pentru a te  inregistra pe server!", "Inregistreaza", "Exit");
			    GetPlayerIp(playerid, ip, sizeof(ip));
				SCM(playerid, COLOR_LIGHTBLUE, "Te rog sa-ti introduci varsta.");
				mysql_format(g_Sql, query, sizeof(query), "INSERT INTO users (Name, Password, IP, Admin, Helper, Money) VALUES ('%s', '%e', '%s', '0','0','1500')", GetName(playerid), inputtext, ip);
			    mysql_query(g_Sql, query);
				ShowPlayerDialog(playerid, DIALOG_AGE, DIALOG_STYLE_INPUT, "Varsta!", "Te rog sa-ti introduci mai jos varsta.", "Continua", "Exit");
			}
			return 1;
		}
		case DIALOG_LOGIN:
		{
		    if(!response) return Kick(playerid);
		    if(response)
		    {
				if(!strlen(inputtext)) return ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, "Parola Incorecta!", "Te rog sa-ti introduci parola corecta mai jos\nDaca ai uitat parola o poti recupera pe panel.", "Login", "Exit");
				mysql_format(g_Sql, query, sizeof(query), "SELECT * FROM `users` WHERE `Name`='%e' AND `Password`='%s'", GetName(playerid), inputtext);
				mysql_tquery(g_Sql, query, "OnLogin", "i", playerid);
		    }
		    return 1;
		}
		case DIALOG_AGE:
		{
		    if(!response) return ShowPlayerDialog(playerid, DIALOG_AGE, DIALOG_STYLE_INPUT, "Varsta!", "Te rog sa-ti introduci mai jos varsta.", "Continua", "Exit");
		    if(response)
		    {
		    	if(!strlen(inputtext)) return ShowPlayerDialog(playerid, DIALOG_AGE, DIALOG_STYLE_INPUT, "Varsta!", "Te rog sa-ti introduci mai jos varsta.", "Continua", "Exit");
				SCM(playerid, COLOR_LIGHTBLUE, "Te rog sa-ti introduci email-ul, pentru contact si a pentru a-ti putea recupera contul.");
				mysql_format(g_Sql, query, sizeof(query), "UPDATE `users` SET `Age`='%e' WHERE `Name`='%e'", inputtext, GetName(playerid));
				mysql_query(g_Sql, query);
				ShowPlayerDialog(playerid, DIALOG_EMAIL, DIALOG_STYLE_INPUT, "Ă‹mail", "Te rog sa-ti introduci email-ul mai jos.", "Continua", "Exit");
			}
		    return 1;
		}
		case DIALOG_EMAIL:
		{
		    if(!response) return ShowPlayerDialog(playerid, DIALOG_EMAIL, DIALOG_STYLE_INPUT, "Ă‹mail", "Te rog sa-ti introduci email-ul mai jos.", "Continua", "Exit");
		    if(response)
		    {
		        if(!strlen(inputtext)) return ShowPlayerDialog(playerid, DIALOG_EMAIL, DIALOG_STYLE_INPUT, "Ă‹mail", "Te rog sa-ti introduci email-ul mai jos.", "Continua", "Exit");
		        SCM(playerid, COLOR_LIGHTBLUE, "Te rog sa-ti alegi sexul.");
                mysql_format(g_Sql, query, sizeof(query), "UPDATE `users` SET `Email`='%e' WHERE `Name`='%e'", inputtext, GetName(playerid));
				mysql_query(g_Sql, query);
				ShowPlayerDialog(playerid, DIALOG_GENDER, DIALOG_STYLE_MSGBOX, "Gen", "Te rog sa-ti alegi genul de mai jos.", "Masculin", "Feminin");
		    }
		    return 1;
		}
		case DIALOG_GENDER:
		{
			if(response)
			{
                mysql_format(g_Sql, query, sizeof(query), "UPDATE `users` SET `Sex`='1' WHERE `Name`='%e'", GetName(playerid));
				mysql_query(g_Sql, query);
				SCM(playerid, COLOR_LIGHTBLUE, "Inregistrarea a fost un succes!");
                ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, "Logheaza-te!", "Te rog sa-ti introduci parola mai jos", "Login", "Exit");
			}
			if(!response)
			{
			    mysql_format(g_Sql, query, sizeof(query), "UPDATE `users` SET `Sex`='0' WHERE `Name`='%e'", GetName(playerid));
				mysql_query(g_Sql, query);
				SCM(playerid, COLOR_LIGHTBLUE, "Inregistrarea a fost un succes!");
                ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, "Logheaza-te!", "Te rog sa-ti introduci parola mai jos", "Login", "Exit");
			}
			return 1;
		}
	}
	return 1;
}

public OnPlayerClickPlayer(playerid, clickedplayerid, source)
{
	return 1;
}

forward MySQLConnect();
public MySQLConnect()
{
    g_Sql = mysql_connect("localhost", "root", "", "");
    if(mysql_errno() != 0)
    {
        printf("Connexiunea la baza de date '%s' nu a reusit. ---> Server ShutDown!", mysql_db);
        SendRconCommand("exit"); //daca vor exista erori ne va afisamesajul si va inchide consola
    }
    else
    {
        printf("Conexiunea la baza de date '%s' cu userul '%s' a reusit", mysql_db, mysql_user);// daca nu vor exista erori ne va afisa mesajul
    }
	return 1;
}

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

forward OnPlayerLogin(playerid);
public OnPlayerLogin(playerid)
{
	new rows, fields;
	cache_get_row_count(rows);
	cache_get_field_count(fields);
	if(rows)
	{
	    ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, "Logheaza-te!", "Te rog sa-ti introduci parola mai jos", "Login", "Exit");//daca playerul are randuri i se va afisa dialogul de login
	}
	else
	{
	    ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_PASSWORD, "Inregistrare", "Trebuie sa iti creezi un cont pentru a juca pe server. \nTasteaza mai jos o paorla pentru a te inregistra.", "Inregistrare", "Exit");//daca playerul nu are randuri i se va afisa dialogul de inregistrare
	}
	return 1;
}

forward OnLogin(playerid);
public OnLogin(playerid)
{
	new rows, fields, temporar[200];
	cache_get_row_count(rows);
	cache_get_field_count(fields);
	if(rows)
	{
	    PlayerInfo[playerid][pPassword] = cache_get_value_name(0, "Password", temporar);
	    PlayerInfo[playerid][pID] = cache_get_value_name(0, "ID", temporar);
	    cache_get_value_int(0, "Money", PlayerInfo[playerid][pMoney]);
	    SpawnPlayer(playerid);
	}
	else
	{
	    ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, "Parola Incorecta!", "Te rog sa-ti introduci parola corecta mai jos\nDaca ai uitat parola o poti recupera pe panel.", "Login", "Exit");
	}
	MONEY(playerid, PlayerInfo[playerid][pMoney]);
	return 1;
}