prorp-samp/gamemodes/todo/dealerships.pwn

forward SaveDealershipsMySql();
public SaveDealershipsMySql()
{

	for(new i = 1; i < MAX_DEALERS; i++)
	{
		new query[2500];
		mysql_format(sqlGameConnection, query, sizeof(query), "UPDATE `dealerships`  WHERE `dID` = %d SET `d_name` = %s, `d_spawned` = %d,",
		Dealerships[i][dID], Dealerships[i][dName], Dealerships[i][dSpawned]);

		mysql_format(sqlGameConnection, query, sizeof(query), "%s `d_posx` = %f, `d_posy` = %f, `dposz` = %f,",
		query, Dealerships[i][dPos][0], Dealerships[i][dPos][1], Dealerships[i][dPos][2]);

		mysql_format(sqlGameConnection, query, sizeof(query), "%s `d_carx` = %f, `d_cary` = %f, `d_carz` = %f, `dcara` = %f,",
		query, Dealerships[i][dPos][3], Dealerships[i][dPos][4], Dealerships[i][dPos][5], Dealerships[i][dPos][6]);
	
		new ca = 0, str1 [10], str2[10];
			for(new c = 0; c < 10; c++)
			{
				if(Dealerships[i][dCars][c] >= 400)
				{
					format(str1, sizeof(str1), "`car_%d`", ca);
					format(str2, sizeof(str2), "`car_%d_price`", ca);
					mysql_format(sqlGameConnection, query, sizeof(query), "%s %s = %d, %s = %d,",
					query, str1, Dealerships[i][dCars][c], str2, Dealerships[i][dCarPrice][c]);
					ca++;
				}
		}
		mysql_tquery(sqlGameConnection, query);

	}
	return 1;
}