SQLite Inserting, Deleting and stuff
#4

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

Код:
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);
                }
			}
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.
Reply


Messages In This Thread
SQLite Inserting, Deleting and stuff - by Sime30 - 15.01.2015, 00:21
Re: SQLite Inserting, Deleting and stuff - by Jefff - 15.01.2015, 00:43
Re: SQLite Inserting, Deleting and stuff - by Sime30 - 15.01.2015, 00:57
Re: SQLite Inserting, Deleting and stuff - by Sime30 - 15.01.2015, 02:09
Re: SQLite Inserting, Deleting and stuff - by Sime30 - 15.01.2015, 16:07

Forum Jump:


Users browsing this thread: 1 Guest(s)