// This is a comment
// uncomment the line below if you want to write a filterscript
//#define FILTERSCRIPT

#include <a_samp>
#include <a_mysql>

#define MYSQL_HOST "localhost"
#define MYSQL_USER "root"
#define MYSQL_DB "sany"
#define MYSQL_PW ""

new Query[1000], konekcija;

main()
{
	print("\n----------------------------------");
	print(" Blank Gamemode by your name here");
	print("----------------------------------\n");
}

enum pInfo()
{
	pAdmin,
	pNovac,
	pLevel,
	pUbistva,
	pSmrti
}
new PlayerInfo[MAX_PLAYERS][pInfo];

public OnGameModeInit()
{
	// Don't use these lines if it's a filterscript
	SetGameModeText("RG MYSQL v1");

	DBKonektiraj();

	mysql_debug(1);
	konekcija = mysql_connect(MYSQL_HOST, MYSQL_USER, MYSQL_DB, MYSQL_PW);
	return 1;
}

forward OnQueryFinish(gQuery[]);
public OnQueryFinish(gQuery[])
{
	print("Uspesno e zacuvana databazata");
	return 1;
}
forward ProvjeraIgraca(playerid);
public ProvjeraIgraca(playerid)
{
	new string[264];
	mysql_store_result();
	if(mysql_num_rows(konekcija) != 0)
	{
	    format(string, sizeof(string), "Dobrodosao nazad %s  !\n Molim vas da se prijavite!!", RPIme(playerid));
	    ShowPlayerDialog(playerid, 0, DIALOG_STYLE_PASSWORD, "Prijava", string, "Prijavi se", "Odustani");
	}
	else
	{
	    format(string, sizeof(string), "Dobrodosao %s na ovaj server !\n Upisite sifru da se registrujete!!", RPIme(playerid));
	    ShowPlayerDialog(playerid, 1, DIALOG_STYLE_PASSWORD, "Registracija", string, "Registracija", "Odustani");
	}
	mysql_free_result();

forward LogirajKorisnika(playerid, sifra);
public LogirajKorisnika(playerid, sifra)
{
	new string[264];
	mysql_store_result();
	if(mysql_num_rows(konekcija) == 1)
	{
	    if(mysql_retrieve_row())
	    {
	        mysql_fetch_field_row(string, "Admin"); PlayerInfo[playerid][pAdmin] = strval(string);
	        mysql_fetch_field_row(string, "Level"); PlayerInfo[playerid][pLevel] = strval(string);
	        mysql_fetch_field_row(string, "Novac"); PlayerInfo[playerid][pNovac] = strval(string);
	        mysql_fetch_field_row(string, "Ubistva"); PlayerInfo[playerid][pUbistva] = strval(string);
	        mysql_fetch_field_row(string, "Smrti"); PlayerInfo[playerid][pSmrti] = strval(string);
	        ShowPlayerDialog(playerid, 2, DIALOG_STYLE_MSGBOX, "Logiran", "Uspjesno ste prijavljeni!", "Uredu", "Izlaz");
	    }
	}
	else
	{
	    ShowPlayerDialog(playerid, 3, DIALOG_STYLE_MSGBOX, "Kriva sifra", "Vasa sifra je netacna!", "Uredu", "Izlaz");
	}
	mysql_free_result();
	return 1;
}


stock ZacuvajKorisnici(playerid)
{
    mysql_format(konekcija, Query, "UPDATE `korisnici` SET `Novac` = %d, `Level` = %d, `Admin` = %d, `Ubistva` = %d, `Smrti` = %d", GetPlayerMoney(playerid), GetPlayerScore(playerid), PlayerInfo[playerid][pAdmin], PlayerInfo[playerid][pUbistva], PlayerInfo[playerid][pSmrti]);
    mysql_function_query(konekcija, Query, false, "OnQueryFinish", "s", Query);
}

stock RPIme(playerid)
{
	new Ime[MAX_PLAYER_NAME];
	GetPlayerName(playerid, Ime, MAX_PLAYER_NAME);
	return Ime;
}

public OnQueryError(errorid, error[], callback[], query[], connectionHandle)
{
printf("EID: %d | Error: %s | Query: %s", errorid, error, query);
return 1;
}

stock DBKonektiraj()
{
	if(mysql_connect(MYSQL_HOST, MYSQL_USER, MYSQL_DB, MYSQL_PW)) print("|RGMYSQL|Konekcijata so databazata e uspesna");
	else print("|RGMYSQL|Konekcijata so databazata e neuspesna");
}

public OnGameModeExit()
{
    mysql_close();
	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)
{
    mysql_format(konekcija, Query, "SELECT * FROM `korisnici` WHERE `ImeKorisnika` = '%e'", RPIme(playerid));
	mysql_function_query(konekcija, Query, false, "ProvjeraIgraca", "d", 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 OnPlayerCommandText(playerid, cmdtext[])
{
	if (strcmp("/mycommand", cmdtext, true, 10) == 0)
	{
		// Do something here
		return 1;
	}
	return 0;
}

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[])
{
    switch(dialogid)
	{
	    case 0:
	    {
	        if(!response) return Kick(playerid);
	        mysql_format(konekcija, Query, " SELECT * FROM `korisnici` WHERE ImeKorisnika = '%e' AND Sifra = md5('%e')", RPIme(playerid), inputtext);
	        mysql_function_query(konekcija, Query, false, "LogirajKorisnika", "ds", playerid, inputtext);
		}
		case 1:
		{
		    new IP[50];
		    GetPlayerIp(playerid, IP, sizeof(IP));
		    if(!response) return Kick(playerid);
		    mysql_format(konekcija, Query, "INSERT INTO `korisnici` (ImeKorisnika, Sifra, Novac, Level, Admin, Ubistva, Smrti, IP) VALUES('%e', md5('%e'), 5000, 1, 0, 0, 0, '%e')", RPIme(playerid), inputtext, IP);
            mysql_function_query(konekcija, Query, false, "OnQueryFinish", "s", Query);
		}
	}
	if(dialogid == 2)
	{
	    if(!response) return Kick(playerid);
	    if(response)
	    {
	        SpawnPlayer(playerid);
	    }
	}
	if(dialogid == 3)
	{
	    new string[264];
	 	if(!response) return Kick(playerid);
	    if(response)
	    {
	        format(string, sizeof(string), "Login %s  !\nPokusaj ponovo da se logiras!!", RPIme(playerid));
	    	ShowPlayerDialog(playerid, 0, DIALOG_STYLE_PASSWORD, "Prijava", string, "Prijavi se", "Odustani");
	    }
	}
	return 1;
}

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