#include <a_samp>
#include <a_mysql>
#include <ZCMD>
#include <sscanf2>

#define DIALOG_LOGIN 1
#define DIALOG_REGISTER 2

/*==============================================================================
									Colors
==============================================================================*/
#define COLOR_GREEN 0x00FF00FF
#define COLOR_RED 0xFF0000FF
#define COLOR_BLUE 0x0000FFFF
#define COLOR_ORANGE 0xFF8000FF
#define COLOR_YELLOY 0xFFFF00FF
#define COLOR_SIVO 0xC0C0C0FF
#define COLOR_SERVAR 0x2484BDFF
#define COLOR_NEWS 0xFF00FFFF //for bans,achievemnts,buy house/car ->sendclientmessagetoall



//dialog colors \/
#define PINK "{#FF00FF}"
#define YELLOY "{FFFF00}"
#define WHITE "{FFFFFF}"
#define RED "{F81414}"
#define GREEN "{00FF22}"
#define LIGHTBLUE "{00CED1}"
#define ORANGE "{FFAF00}"
#define BLUE "{0025E1}"
#define PURPLE "{FF00FF}"

/*==============================================================================
                               Global Variables
==============================================================================*/

new Rows, Fields;

/*==============================================================================
									Stocks
==============================================================================*/

stock PlayerName(i)
{
	new pname[MAX_PLAYER_NAME];
	GetPlayerName(i,pname,MAX_PLAYER_NAME);
	return pname;
}

stock GetPlayerIP(playerid)
{
    new Ip[25];
	GetPlayerIp(playerid, Ip, sizeof(Ip));
	return Ip;


stock load_player_data(playerid)
{
	new Query[256];
	format(Query,sizeof(Query),"SELECT * FROM playerdata WHERE username='%s'",PlayerName(playerid));
	mysql_function_query(1, Query, false, "", "");
	mysql_store_result();
	new datastr[20];
	while(mysql_fetch_row_format(Query,"|"))
	{
         mysql_fetch_field_row(datastr,"money"); GivePlayerMoney(playerid,strval(datastr));
         mysql_fetch_field_row(datastr,"score"); SetPlayerScore(playerid,strval(datastr));


	}

	mysql_free_result();

	SendClientMessage(playerid,-1,"Your data successful loaded");
	return 1;


stock update_player_data(playerid)
{
	new reg[256];
	format(reg,sizeof(reg),"UPDATE playerdata SET `money` = '%d', `score` = '%d' WHERE `username` = '%s' ",GetPlayerMoney(playerid),GetPlayerScore(playerid),PlayerName(playerid));
	mysql_function_query(1, reg, false, "", "");
	return true;
}
/*==============================================================================

==============================================================================*/

main()
{
	print("\n----------------------------------");
	print(" sectret");
	print("----------------------------------\n");
}


public OnGameModeInit()
{
    mysql_debug(1);
    mysql_connect("localhost","root","trucking","");

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

public OnGameModeExit()
{
    mysql_close();
    mysql_debug(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)
{
	new Query[256];
	format(Query,sizeof(Query),"SELECT `username` FROM `playerdata` WHERE `username` = '%s'",PlayerName(playerid));
	mysql_function_query(1, Query, true, "OnPlayerConnectQueryFinish", "i", playerid);

	return 1;
}

forward OnPlayerConnectQueryFinish(playerid);
public OnPlayerConnectQueryFinish(playerid) {
    new Rows, Fields;

    cache_get_data(Rows, Fields);

    if(Rows > 0) {
		new rstring[256];
		format(rstring,256,""WHITE"Welcome "GREEN"%s"WHITE" please type in password",PlayerName(playerid));
		ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,"Login",rstring,"Continue","Exit");
	} else {

		new rastring[256];
		format(rastring,256,""RED"You are not register "WHITE"%s "RED"please enter your password",PlayerName(playerid));
		ShowPlayerDialog(playerid,DIALOG_REGISTER,DIALOG_STYLE_PASSWORD,"Register",rastring,"Continue","Exit");

	}

    return 1; //Setting return 1 means clean the cache at the end of the function.
}

public OnPlayerDisconnect(playerid, reason)
{
	update_player_data(playerid);
	new string[50], giveplayerid;
	format(string,sizeof(string),"%s(%d) has left server.", PlayerName(playerid),(giveplayerid));
	SendClientMessageToAll(COLOR_SIVO, string);
	return 1;
}

public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
{
	if( dialogid == DIALOG_LOGIN )
	{
		new Query[256];
		if(!response) return
		Kick(playerid),
		SendClientMessage(playerid,COLOR_RED,"You have choise to not login");

		format(Query,sizeof(Query),"SELECT `username` FROM `playerdata` WHERE `username` ='%s' AND `password`='%s'",PlayerName(playerid),inputtext);
  		mysql_function_query(1, Query, false, "", "");
		print(Query);
		mysql_store_result();
		if(mysql_num_rows())
		{
			new hello[100];
			format(hello,sizeof(hello),"Hello %s,welcome back",PlayerName(playerid));
			SendClientMessage(playerid,COLOR_GREEN,hello);
			load_player_data(playerid);
			new string[50], giveplayerid;
			format(string,sizeof(string),"%s (%d) connected", PlayerName(playerid),(giveplayerid));
			SendClientMessageToAll(COLOR_SIVO, string);
			format(Query, sizeof(Query), "UPDATE playerdata SET `IP` = '%s' WHERE `username`='%s'",GetPlayerIP(playerid), PlayerName(playerid));
   			mysql_function_query(1, Query, false, "", "");
   			SendClientMessage(playerid,-1,"test");
		}
		else
		{
			SendClientMessage(playerid,COLOR_RED,"Invalid password");
			new rstring[256];
			format(rstring,256,""WHITE"Welcome "GREEN"%s"WHITE",please type in password",PlayerName(playerid));
			ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,"Login",rstring,"Continue","Exit");
		}

		mysql_free_result();
		return true;
	}
	if( dialogid == DIALOG_REGISTER )
	{
	    new Query[256];
		if(!response) return
		Kick(playerid),
		SendClientMessage(playerid,COLOR_RED,"You have cancel to register");

		format(Query,sizeof(Query),"INSERT INTO playerdata (`username`,`password`,`money`,`score`,`IP`) VALUES ('%s','%s',0,0,'%s')",PlayerName(playerid), inputtext, GetPlayerIP(playerid));
		mysql_function_query(1, Query, false, "", "");
		GivePlayerMoney(playerid,3000);
		print(Query);
		SpawnPlayer(playerid);
		GameTextForPlayer(playerid,"~b~Welcome To Our Servar",7000,0);
		SendClientMessage(playerid,COLOR_GREEN,"You succesful register");
		SendClientMessage(playerid,COLOR_GREEN,"Before start playing go read "RED"/rules"WHITE" and "RED"/cmds");

	}
	return 1;
}

/*==============================================================================
							   Player commands
==============================================================================*/

CMD:money(playerid,params[])
{
	GivePlayerMoney(playerid,513);
	SendClientMessage(playerid,-1,"You have give yourself 513$");
	SetPlayerScore(playerid,3);
	return true;
}