MOD

//---------------------------------MYSQL MOD----------------------------------//
#include <a_samp>
#include <a_mysql>
#include <SKY>
//--------------------//
#define MYSQL_HOST "localhost"
#define MYSQL_USER "root"
#define MYSQL_DB "mysql.db"
#define MYSQL_PW ""
//--------------------//
new Query[1000], konekcija;
//--------------------//
enum pInfo()
{
	pAdmin,
	pNovac,
	pLevel,
	pUbistva,
	pSmrti
}
new PlayerInfo[MAX_PLAYERS][pInfo];
//--------------------//
public OnFilterScriptInit()
{
	return 1;
}
//--------------------//
public OnFilterScriptExit()
{
	return 1;
}
//--------------------//
main()
{
	print("\n----------------MYSQL------------------");
	print(">------------------MOD--------------------<");
	print("-------------------------------------------\n");
}
//--------------------//
public OnGameModeInit()
{
	mysql_debug(1);
	konekcija = mysql_connect(MYSQL_HOST, MYSQL_USER, MYSQL_DB, MYSQL_PW);
	return 1;
}
//--------------------//
public OnGameModeExit()
{
    mysql_close();
	return 1;
}
//--------------------//
public OnPlayerRequestClass(playerid, classid)
{
	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)
{
    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);
	return 1;
}
//--------------------//
public OnPlayerSpawn(playerid)
{
	return 1;
}
//--------------------//
public OnPlayerDeath(playerid, killerid, reason)
{
    PlayerInfo[killerid][pUbistva] ++;
    PlayerInfo[playerid][pSmrti] ++;
	return 1;
}
//--------------------//
public OnVehicleSpawn(vehicleid)
{
	return 1;
}
//--------------------//
public OnVehicleDeath(vehicleid, killerid)
{
	return 1;
}
//--------------------//
public OnPlayerText(playerid, text[])
{
	return 1;
}
//--------------------//
public OnPlayerCommandText(playerid, cmdtext[])
{
	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[])
{
	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;
}
//--------------------//
forward OnQueryFinish(gQuery[]);
public OnQueryFinish(gQuery[])
{
	print("Query se uspjesno izvrsio");
	return 1;
}
//--------------------//
public OnQueryError(errorid, error[], callback[], query[], connectionHandle)
{
    printf("EID: %d | Error: %s | Query: %s", errorid, error, query);
    return 1;
}
//--------------------//
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;
}
//--------------------//
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();
	return 1;
}
//--------------------//
stock RPIme(playerid)
{
	new Ime[MAX_PLAYER_NAME];
	GetPlayerName(playerid, Ime, MAX_PLAYER_NAME);
	return Ime;
}
//--------------------//
stock DBSpoji()
{
	if(mysql_connect(MYSQL_HOST, MYSQL_USER, MYSQL_DB, MYSQL_PW)) print("| Aggessive | Spajanje sa MySQL bazom je uspesno!");
	else print("| Aggressive | Spajanje sa MySQL bazom nije uspelo...");
}
//---------------------------------END----------------------------------------//