Jack_Ander

enum pInfo
{
	SQLID,
	Ime,
	Lozinka,
	Skin,
	Level,
	Respekti,
	Novac,
	Spol,
	Godine,
	Drzava
};
new PlayerInfo;

new bool:Ulogovan;

enum
{
	DIALOG_REGISTER,
	DIALOG_LOGIN,
	DIALOG_SPOL,
	DIALOG_GODINE,
	DIALOG_DRZAVA
};

new MySQL:SQL;

stock GetName(playerid)
{
	new name;
	GetPlayerName(playerid, name,sizeof(name));
	return name;
}

stock udb_hash(buf[]) 
{
    new length=strlen(buf);
    new s1 = 1;
    new s2 = 0;
    new n;
    for (n=0; n    {
      s1 = (s1 + buf) % 65521;
      s2 = (s2 + s1)    % 65521;
    }
    return (s2 << 16) + s1;
}
 
main()
{
	print("BosniaSQL beta je ocitan");
}

public OnGameModeInit()
{
	SQL = mysql_connect(MYSQL_HOST,MYSQL_USER,"",MYSQL_DB);
	if(mysql_errno(SQL) != 0 || SQL == MYSQL_INVALID_HANDLE)
	{
        print("Mod nije uspjesno povezan sa databazom, gasim server");
        SendRconCommand("exit");
        return 1;
    }
	print("Uspjesno povezivanje moda sa bazom");
	DisableInteriorEnterExits();
	ShowPlayerMarkers(false);
	EnableStuntBonusForAll(false);
	return 1;
}
public OnPlayerConnect(playerid)
{
	PlayerInfo = -1;
	Ulogovan = false;
	new query;
	mysql_format(SQL,query,sizeof(query),"SELECT * FROM `korisnici` WHERE  `Ime` = '%e' LIMIT 1",GetName(playerid));
	mysql_tquery(SQL,query,"SQL_Provjera","i",playerid);
	return 1;
}

public OnPlayerDisconnect(playerid, reason)
{
	PlayerInfo = -1;
	Ulogovan = false;
	return 1;
}
public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
{
	switch(dialogid)
	{
		case DIALOG_LOGIN:
		{
			if(!response)return Kick(playerid);
			if(response)
			{
				if(udb_hash(inputtext) == PlayerInfo)
				{
					if(Ulogovan == true)return SCM(playerid,COLOR_RED,"Vi ste vec ulogovani");
					SetPlayerSkin(playerid, PlayerInfo);
					TogglePlayerSpectating(playerid,false);
					SetPlayerScore(playerid, PlayerInfo);
					ResetPlayerMoney(playerid);
					ResetPlayerWeapons(playerid);
					OcistiChat(playerid,25);
					Ulogovan = true;
					SCM(playerid,COLOR_LIME,"Uspjesno ste se ulogovali");
				    SetSpawnInfo(playerid,0,PlayerInfo,0.0,0.0,0.0,0.0,0,0,0,0,0,0);
				    SpawnPlayer(playerid);
				}
				else
				{
					ShowPlayerDialog(playerid, DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,"Login","Upisite svoju lozinku","Uloguj se","Odustani");
				}
			}
		}
		case DIALOG_REGISTER:
		{
			if(!response)return Kick(playerid);
			if(response)
			{
				if(strlen(inputtext) < 10 ||strlen(inputtext) > 65)
				{
					SCM(playerid,COLOR_RED,"Lozinka vam je kraca od 10 ili duza od 65 karaktera!");
					ShowPlayerDialog(playerid,DIALOG_REGISTER,DIALOG_STYLE_PASSWORD,"Registracija","Vasa lozinka moze biti samo manja 10 a ne duza od 65 ","Nasavi","Odustani");
				} 
				PlayerInfo = udb_hash(inputtext);
				new query;
				mysql_format(SQL,query,sizeof(query),"INSERT INTO `korisnici` (Ime,Lozinka) VALUES('%e', '%d') ",GetName(playerid),inputtext);
				mysql_tquery(SQL, query,"insertSQLID","d",playerid);

				ShowPlayerDialog(playerid,DIALOG_SPOL,DIALOG_STYLE_LIST,"Spol","Musko\nZensko","Unesi","Odustani");
			}
		}
		case DIALOG_SPOL:
		{
			if(!response)return Kick(playerid);
			if(response)
			{
				switch(listitem)
				{
					case 0:
					{
						PlayerInfo = 0;
						SCM(playerid,COLOR_LIME,"Vi ste musko!");
					}
					case 1:
					{
						PlayerInfo = 1;
						SCM(playerid,COLOR_LIME,"Vi ste zensko!");
					}
				}
				new query;
				mysql_format(SQL,query,sizeof(query),"UPDATE `korisnici` SET `Spol` = '%d' WHERE `ID` = '%d' ",PlayerInfo,PlayerInfo);
				mysql_tquery(SQL,query);
				ShowPlayerDialog(playerid,DIALOG_DRZAVA,DIALOG_STYLE_LIST,"Drzava","Bih\nHrvatska\nSrbija\nCrna Gora\nMakedonija\nSlovenija\nOstalo","Unesi","Odustani");
			}
		}
		case DIALOG_DRZAVA:
		{
			if(!response)return Kick(playerid);
			if(response)
			{
				switch(listitem)
				{
					case 0:
					{
						PlayerInfo = 0;
						SCM(playerid,COLOR_LIME,"Vi ste iz Bih!");
					}
					case 1:
					{
						PlayerInfo = 1;
						SCM(playerid,COLOR_LIME,"Vi ste iz Hrvatska!");
					}
					case 2:
					{
						PlayerInfo = 2;
						SCM(playerid,COLOR_LIME,"Vi ste iz Srbija!");
					}
					case 3:
					{
						PlayerInfo = 3;
						SCM(playerid,COLOR_LIME,"Vi ste iz Crna Gora!");
					}
					case 4:
					{
						PlayerInfo = 4;
						SCM(playerid,COLOR_LIME,"Vi ste iz Makedonije!");
					}
					case 5:
					{
						PlayerInfo = 5;
						SCM(playerid,COLOR_LIME,"Vi ste iz Slovenija!");
					}
					case 6:
					{
						PlayerInfo = 6;
						SCM(playerid,COLOR_LIME,"Vi ste iz Ostalo!");
					}
				}
				new query;
				mysql_format(SQL,query,sizeof(query),"UPDATE `korisnici` SET `Drzava` = '%d' WHERE `ID` = '%d' ",PlayerInfo,PlayerInfo);
				mysql_tquery(SQL,query);
				ShowPlayerDialog(playerid,DIALOG_GODINE,DIALOG_STYLE_INPUT,"Godine","Unesite vase godine!","Unesi","Odustani");
			}
		}
		case DIALOG_GODINE:
		{
			new god = strval(inputtext);
	    	if(god < 10)return ShowPlayerDialog(playerid, DIALOG_GODINE, DIALOG_STYLE_INPUT,"Unesite godine", "Godine ne mogu biti manje od 10 i vise od 65","Unesi", "Odustani");
	    	if(god > 65)return ShowPlayerDialog(playerid, DIALOG_GODINE, DIALOG_STYLE_INPUT,"Unesite godine", "Godine ne mogu biti manje od 10 i vise od 65","Unesi", "Odustani");
	    	PlayerInfo = god;
	    	new query;
			mysql_format(SQL,query,sizeof(query),"UPDATE `korisnici` SET `Godine` = '%d' WHERE `ID` = '%d' ",PlayerInfo,PlayerInfo);
			mysql_tquery(SQL,query);
		    SetSpawnInfo(playerid,0,PlayerInfo,0.0,0.0,0.0,0.0,0,0,0,0,0,0);
		    SpawnPlayer(playerid);
		    Ulogovan = true;

		}
	}
	return 1;
}
forward insertSQLID(playerid);
public insertSQLID(playerid)
{
	PlayerInfo = cache_insert_id();
	printf("Kreiran nalog SQLID %d IME %s",PlayerInfo,GetName(playerid));
	return 1;
}

forward SQL_Provjera(playerid);
public SQL_Provjera(playerid)
{
	switch(cache_num_rows())
	{
		case 0: 
		{
			ShowPlayerDialog(playerid,DIALOG_REGISTER,DIALOG_STYLE_PASSWORD,"Registracija","Vasa lozinka moze biti samo manja 10 a ne duza od 65 ","Nasavi","Odustani");
		}
		case 1: 
		{
			cache_get_value_name_int(0,"ID",PlayerInfo);
			cache_get_value_name(0,"Ime",PlayerInfo);
			cache_get_value_name_int(0,"Lozinka",PlayerInfo);
			cache_get_value_name_int(0,"Spol",PlayerInfo);
			cache_get_value_name_int(0,"Drzava",PlayerInfo);
			cache_get_value_name_int(0,"Godine",PlayerInfo);
			cache_get_value_name_int(0,"Novac",PlayerInfo);
			cache_get_value_name_int(0,"Level",PlayerInfo);
			cache_get_value_name_int(0,"Respekti",PlayerInfo);
			cache_get_value_name_int(0,"Skin",PlayerInfo);
			ShowPlayerDialog(playerid, DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,"Login","Upisite svoju lozinku","Uloguj se","Odustani");
		}
	}
}

//