stock SQL_SavePlayer(playerid)
{
	new query[256], name[MAX_PLAYER_NAME];
	GetPlayerName(playerid, name, sizeof(name));
	mysql_format(handle, query, sizeof(query), "INSERT INTO players SET \
 												name='%e',\
             									password='%e',\
                      							salt='%e',\
                             					regdate=NOW(),\
												pol='%d',\
												drzava='%d',\
												level='%d',\
												novacdzep='%d',\
												xspawn='%f',\
												yspawn='%f',\
												zspawn='%f',\
												aspawn='%f'", name, PlayerInfo[playerid][Password], PlayerInfo[playerid][Salt], PlayerInfo[playerid][Spol],PlayerInfo[playerid][Drzava],PlayerInfo[playerid][Level],PlayerInfo[playerid][NovacDzep],
												PlayerInfo[playerid][xspawn], PlayerInfo[playerid][yspawn], PlayerInfo[playerid][zspawn], PlayerInfo[playerid][aspawn]);

	mysql_tquery(handle, query, "OnPlayerRegister", "d", playerid);
}

	if(dialogid == DIALOG_DRZAVA)
	{
		if(!response) return Kick(playerid);
		if(response)
		{
			switch(listitem)
			{
				case 0:
				{
					new string[50];
					new dd = PostaviNovac(playerid,50000);
					format(string,sizeof(string), "Uredu gospodine , vi ste iz Srbije");
					SCM(playerid,-1, string);
					PlayerInfo[playerid][Drzava] = 1;
					PlayerInfo[playerid][Level] = 5;
					PlayerInfo[playerid][NovacDzep] = dd;
					PlayerInfo[playerid][xspawn] = DEFAULT_POS_X; // definisana je vec valuta za x y z a
					PlayerInfo[playerid][yspawn] = DEFAULT_POS_Y;
					PlayerInfo[playerid][zspawn] = DEFAULT_POS_Z;
					PlayerInfo[playerid][aspawn] = DEFAULT_POS_A;
					SQL_SavePlayer(playerid);
				}

//


forward CheckPlayerData(playerid);
public CheckPlayerData(playerid)
{
    if(cache_num_rows() > 0)
    {
        cache_get_value(0, "password", PlayerInfo[playerid][Password], 65);
        cache_get_value(0, "salt", PlayerInfo[playerid][Salt], 11);
        cache_get_value_int(0, "pol", PlayerInfo[playerid][Spol]);
        cache_get_value_int(0,"drzava", PlayerInfo[playerid][Drzava]);
        cache_get_value_int(0,"level", PlayerInfo[playerid][Level]);
        cache_get_value_int(0,"novacdzep", PlayerInfo[playerid][NovacDzep]);

		ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, "Prijava", "Vas racun je pronadjen, molimo vas upisite lozinku da se prijavite:", "Dalje", "Izlaz");
	}
	else {
	    ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_INPUT, "Registracija", "Vas racun nije pronadjen, molimo vas upisite lozinku da se registrujete:", "Dalje", "Izlaz");
	}
	return true;
}

forward OnAccountLoad(playerid);
public OnAccountLoad(playerid)
{
    if(cache_num_rows() > 0) {
        cache_get_value_int(0, "id", PlayerInfo[playerid][SQLID]);
        cache_get_value(0, "regdate", PlayerInfo[playerid][RegDate], 65);
        cache_get_value_float(0, "xspawn", PlayerInfo[playerid][xspawn]);
        cache_get_value_float(0, "yspawn", PlayerInfo[playerid][yspawn]);
        cache_get_value_float(0, "zspawn", PlayerInfo[playerid][zspawn]);
        cache_get_value_float(0, "aspawn", PlayerInfo[playerid][aspawn]);

        printf("SQLID: %d | Register date: %s", PlayerInfo[playerid][SQLID], PlayerInfo[playerid][RegDate]);

        SetSpawnInfo(playerid, 0 , 0 , PlayerInfo[playerid][xspawn],PlayerInfo[playerid][yspawn],PlayerInfo[playerid][zspawn],PlayerInfo[playerid][aspawn], 0, 0 , 0 ,0 ,0 , 0);
        SpawnPlayer(playerid);
        SetPlayerScore(playerid, PlayerInfo[playerid][Level]);
        GivePlayerMoney(playerid, PlayerInfo[playerid][NovacDzep]);
        TekstKodLogiReg(playerid);
    }
	return true;
}

forward OnPlayerRegister(playerid);
public OnPlayerRegister(playerid)
{
    PlayerInfo[playerid][SQLID] = cache_insert_id();
    SetSpawnInfo(playerid, 0 , 0 , PlayerInfo[playerid][xspawn],PlayerInfo[playerid][yspawn],PlayerInfo[playerid][zspawn],PlayerInfo[playerid][aspawn], 0, 0 , 0 ,0 ,0 , 0);
    SpawnPlayer(playerid);
    TekstKodLogiReg(playerid);
    SetPlayerScore(playerid, PlayerInfo[playerid][Level]);
	return true;
}