SA-MP Forums Archive
Make this sqlite database please help - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Make this sqlite database please help (/showthread.php?tid=589087)



Make this sqlite database please help - PowerF - 15.09.2015

Код:
				db_get_field_assoc(qresult, "business_id", value, 5); // business ID 			
				business[i][business_id] = strval(value);

				db_get_field_assoc(qresult, "business_owner", value, 48); // business Owner 			
				format(business[i][business_owner], 48, value);
				
				db_get_field_assoc(qresult, "business_title", value, 48); // business Title 			
				format(business[i][business_title], 48, value); 
				
				db_get_field_assoc(qresult, "business_bought", value, 20); // business X Position
				business[i][business_bought] = strval(value);
				
				db_get_field_assoc(qresult, "business_price", value, 20); // business X Position
				business[i][business_price] = strval(value);

				db_get_field_assoc(qresult, "busX", value, 20); // business X Position
				business[i][busX] = floatstr(value);

				db_get_field_assoc(qresult, "busY", value, 20); // business Y Position
				business[i][busY] = floatstr(value);

				db_get_field_assoc(qresult, "busZ", value, 20); // business Z Position 	
				business[i][busZ] = floatstr(value);
				
				db_get_field_assoc(qresult, "interiorX", value, 20); // Interior X Position
				business[i][interiorX] = floatstr(value);

				db_get_field_assoc(qresult, "interiorY", value, 20); // Interior Y Position
				business[i][interiorY] = floatstr(value);

				db_get_field_assoc(qresult, "interiorZ", value, 20); // Interior Z Position 	
				business[i][interiorZ] = floatstr(value);
				
				db_get_field_assoc(qresult, "interiorAngle", value, 20); // Interior Angle Position 	
				business[i][interiorA] = floatstr(value);
				
				db_get_field_assoc(qresult, "interiorID", value, 20); // Interior ID 	
				business[i][interiorID] = strval(value);
i dont understand about sqlite..


Re: Make this sqlite database please help - Logofero - 15.09.2015

what's your question?


AW: Make this sqlite database please help - Nero_3D - 15.09.2015

I guess we should create the table for him, there is an example script on the wiki page how to do it with queries
But I think its easier if you download and use a sql editor to create the database + table, save the file in the scriptfiles folder