xFORCERx

CMD:obrisifirmu(playerid, params[])
{
	
	if(IgracInfo[ AdminLevelIgraca] >= 4)
	{
		new string;
	    new Query;
        for (new i = 0; i < MAX_FIRMI; ++i)
		{
  			if(IsPlayerInRangeOfPoint(playerid,3.0,FirmaInfo,FirmaInfo,FirmaInfo))
	    	{
			    if(brisanjeutijeku == true && idfirmekojubrise != -1)
			    {
			        
			        
			        // kodovi za brisanje
			        format(Query,sizeof(Query),"UPDATE `firme` SET `IDFirme`= '0',`ImeVlasnika` = 'Obrisano',`Vrsta` = '0',`EXTX` = '0',`EXTY` = '0',`EXTZ` = '0',`Owned` = '0') WHERE `IDFirme` = '%d'",idfirmekojubrise);
			        db_query( Database, Query );
			        DestroyDynamic3DTextLabel(FirmaInfo);
		    		DestroyDynamicPickup(FirmaInfo);
		    		idfirmekojubrise = -1;
		    		brisanjeutijeku = false;
			        // =======================================
			        
			        return 1;
			    }
			    idfirmekojubrise = i;
			    brisanjeutijeku = true;
			    format(string, sizeof(string), "Zelite li sigurno obrisati firmu ID: "COL_RED"%d {FFFFFF}? Ukoliko zelite, ponovite ovu komandu ovdje unutar 4 sekunde!", i);
			    SCM(playerid, COLOR_WHITE,string);
			    SetTimerEx("UkloniBrisanjeFirmeVarijablu", 4000, false , "i" , playerid);
			    
			    
			}
			else return SendClientMessage(playerid, COLOR_NICERED, "Ne nalazite se blizu firme!");
		}
    	
	}
	else return SendClientMessage(playerid, COLOR_NICERED, "Samo Admini!");
	return 1;
}

CMD:napravifirmu(playerid, params[])
{
    if(IgracInfo[ AdminLevelIgraca] >= 4)
	{
	    new cijena,vrsta;
	    if(sscanf(params, "ii",vrsta,cijena))
		{
		    SendClientMessage(playerid, -1, " ");
			SendClientMessage(playerid,SVJETLOPLAVA,"ID Liste: {FFFFFF}1. Benzinska(Potrebno skriptati) ...");
			SendClientMessage(playerid,SVJETLOPLAVA,"Koristite: {FFFFFF}/napravifirmu ");
			
			return 1;
		}
		else
		{
		    new rowid = 0;
		    new DBResult: Result;
            new ID = SpawnanihFirmi+1;
            new FirmaString;
            new Query;
            new Float:xa,Float:ya,Float:za;
            new Field;
            
            
			
      		if(vrsta == 1)
			{
			    
				GetPlayerPos(playerid,xa,ya,za);
				FirmaInfo = xa;
				FirmaInfo = ya;
				FirmaInfo = za;
				FirmaInfo = cijena;
				FirmaInfo = vrsta;
				
				format(Query,sizeof(Query),"SELECT * FROM `firme` WHERE `IDFirme` = '0' LIMIT 1");
				Result = db_query( Database, Query );
				if( db_num_rows( Result ) )
				{
					rowid = db_get_field_assoc( Result, "IDFirme", Field, 4 );
					FirmaInfo = strval(Field);
				}
				db_free_result( Result );
				if(rowid > 0)
				{
					format(Query,sizeof(Query),"UPDATE `firme` SET `IDFirme`= '%d',`ImeVlasnika` = 'Nitko',`Vrsta` = '%d',`KolicinaGorivaNaPumpi` = '50',`NovacUFirmi` = '0',`Cijena` = '0',`EXTX` = '%f',`EXTY` = '%f',`EXTZ` = '%f',`Owned` = '0' WHERE `IDFirme` = '%d'",rowid, vrsta,cijena,xa,ya,za,rowid);
	                db_query( Database, Query );
				}
				else
				{
					
					format(Query,sizeof(Query),"INSERT INTO `firme` (`IDFirme`,`ImeVlasnika`,`Vrsta`,`KolicinaGorivaNaPumpi`,`NovacUFirmi`,`Cijena`,`EXTX`,`EXTY`,`EXTZ`,`Owned`) VALUES ('%d','Nitko','%d','50','0','%d','%f','%f','%f',0)",ID,vrsta,cijena,xa,ya,za);
                	db_query( Database, Query );
                	SpawnanihFirmi++;
                	format(FirmaString,sizeof(FirmaString),"{00C0FF}Firma na prodaju{FFFFFF} \n{00C0FF}Vrsta:{FFFFFF} Benzinska Pumpa\n{00C0FF}Cijena: {FFFFFF}%d$\n{48E31C}/kupifirmu",cijena);
			 		FirmaInfo = CreateDynamic3DTextLabel(FirmaString, 0xFFFFFFFF, FirmaInfo, FirmaInfo, FirmaInfo, 30.0);
	 				FirmaInfo =  CreateDynamicPickup(1274, 1, FirmaInfo, FirmaInfo, FirmaInfo, 0);
                }
			}

13:10:15] Incoming connection: 192.168.1.5:51504
[13:10:16] Test_Test has joined the server (0:192.168.1.5)
[13:10:16] Server crashed while executing MBO.amx
[13:10:16] AMX backtrace:
[13:10:16] #0 native fwrite () from samp-server.exe
[13:10:16] #1 00052e70 in public OnQueryError (0x0000041e, 0x0013d4b4, 0x00000002, 0x00000000, 0x0013d47c, 0x0013d390, 0x00000001) from MBO.amx
[13:10:16] Native backtrace:
[13:10:16] #0 779c77a2 in ?? () from C:\Windows\SYSTEM32\ntdll.dll
[13:10:16] #1 00492980 in ?? () from C:\Users\xForcer\Desktop\Rad\Modern Balkan - Origin\samp-server.exe
[13:10:16] #2 0040531e in ?? () from C:\Users\xForcer\Desktop\Rad\Modern Balkan - Origin\samp-server.exe

[13:10:16] >> mysql_query( Connection handle: 1 )

[13:10:16] CMySQLHandler::Query(resultID) - Threaded query with id 1 started. (Extra ID: 0)

[13:10:16] CMySQLHandler::ProcessQueryThread(SELECT * FROM `IP Banovi` WHERE `IP` = '192.168.1.5') - Data is getting passed to OnQueryFinish() - (Threadsafe: Yes)

[13:10:16] OnQueryFinish(1,"SELECT * FROM `IP Banovi` WHERE `IP` = '192.168.1.5'") - Called.

[13:10:16] >> mysql_store_result( Connection handle: 1 )

[13:10:16] CMySQLHandler::StoreResult() - Result was stored.

[13:10:16] >> mysql_num_rows( Connection handle: 1 )

[13:10:16] CMySQLHandler::NumRows() - Returned 0 row(s)

[13:10:16] >> mysql_free_result( Connection handle: 1 )

[13:10:16] CMySQLHandler::FreeResult() - Result was successfully free'd.

[13:10:16] >> mysql_query( Connection handle: 1 )

[13:10:16] CMySQLHandler::Query(resultID) - Threaded query with id 2 started. (Extra ID: 0)

[13:10:16] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()

[13:10:16] OnQueryError() - Called.

forward SpajanjeNaServer(playerid);
public SpajanjeNaServer(playerid)
{
    new rand = random(sizeof(LoginKamere));
	TogglePlayerControllable(playerid, 0);
	SetPlayerPos_X(playerid, LoginKamere, LoginKamere, LoginKamere-50);
	SetPlayerCameraPos(playerid, LoginKamere, LoginKamere, LoginKamere);
	SetPlayerCameraLookAt(playerid, LoginKamere, LoginKamere, LoginKamere);
    if(strfind(GetName(playerid), "_", true) != -1)
	{
		new ip, upit;
		GetPlayerIp(playerid, ip, 24);
		format(upit, sizeof(upit), "SELECT * FROM `IP Banovi` WHERE `IP` = '%s'", ip);
		mysql_query(upit, MYSQL_IPPROVJERA, playerid);
	}
	else
	{
		new string;
		format(string, sizeof(string), "{FF0000}Vase ime nije u dopustenome formatu!\n\n{FFFF00}\
		Kako se ovo ne bi u buducnosti dogadjalo, procitajte kako Vase ime treba izgledati:\n\n\
	  	- Vase ime mora biti u formatu {FFFFFF}Ime_Prezime {FFFF00}i obavezno mora sadrzavati donju crtu.\n\
	  	- Ime ne mora biti Vase pravo ime, ali ne smije biti niti ime neke javne osobe.\n\
	  	- Ime ne smije sadrzavati ime nekog poznatog brenda i ne smije nikoga vrijedjati.\n\
		Primjer dobrog imena: {FFFFFF}Mateo_Dukmenic, Petar_Papic");
		SPD(playerid, 9999, DIALOG_STYLE_MSGBOX, "Nedopusteno ime!", string, "U redu", "");
		KickEx(playerid);
		return 1;
	}
return 1;
}

new LoginPjesme[] = 
{
	"Prvi url pjesme",
      "Drugi url pjesme",
      " Treci "
};
//OnPlayerConnect
PlayAudioStreamForPlayer(playerid, LoginPjesme);