15.01.2015, 02:09
Sorry for DP but I made something, correct me if I am wrong.
Creating the biz
//FirmaInfo[rowid][IDFirme] = strval(Field); - I put that in comment because I don't know should I attach it to a variable. Look at the codes below
For deleting I am sure its OK because it only UPDATES some values to zero and if Biz ID is 0, it won't load and that's it.
Creating the biz
//FirmaInfo[rowid][IDFirme] = strval(Field); - I put that in comment because I don't know should I attach it to a variable. Look at the codes below
Код:
if(vrsta == 1)
{
GetPlayerPos(playerid,xa,ya,za);
FirmaInfo[ID][EXTX] = xa;
FirmaInfo[ID][EXTY] = ya;
FirmaInfo[ID][EXTZ] = za;
FirmaInfo[ID][Cijena] = cijena;
FirmaInfo[ID][Vrsta] = 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[idfirme][IDFirme] = 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[ID][Label] = CreateDynamic3DTextLabel(FirmaString, 0xFFFFFFFF, FirmaInfo[ID][EXTX], FirmaInfo[ID][EXTY], FirmaInfo[ID][EXTZ], 30.0);
FirmaInfo[ID][Pickup] = CreateDynamicPickup(1212, 1, FirmaInfo[ID][EXTX], FirmaInfo[ID][EXTY], FirmaInfo[ID][EXTZ], 0);
}
}

