[cut noguest=Вот сам код]
public LoadSqlCars()
{
new arrCoords[14][32];
new sql[80];
new row[512];
format(sql, sizeof(sql), "SELECT COUNT(*) FROM Vehicles");
samp_mysql_query(sql);
samp_mysql_store_result();
samp_mysql_fetch_row(row);
new totalcars = strval(row);
samp_mysql_free_result();
for (new idx=0; idx<totalcars; idx++)
{
format(sql, sizeof(sql), "SELECT * FROM Vehicles WHERE id=%d", idx+1);
samp_mysql_query(sql);
samp_mysql_store_result();
if (samp_mysql_num_rows() > 0)
{
samp_mysql_fetch_row(row);
samp_mysql_free_result();
split(row, arrCoords, '|');
Vehicles[idx][vModelID] = strval(arrCoords[1]);
Vehicles[idx][vPositionX] = floatstr(arrCoords[2]);
Vehicles[idx][vPositionY] = floatstr(arrCoords[3]);
Vehicles[idx][vPositionZ] = floatstr(arrCoords[4]);
Vehicles[idx][vAngleZ] = floatstr(arrCoords[5]);
Vehicles[idx][vColor1] = strval(arrCoords[6]);
Vehicles[idx][vColor2] = strval(arrCoords[7]);
Vehicles[idx][tWeapon1] = strval(arrCoords[8]);
Vehicles[idx][tWeapon2] = strval(arrCoords[9]);
Vehicles[idx][tWeapon3] = strval(arrCoords[10]);
Vehicles[idx][tAmmo1] = strval(arrCoords[11]);
Vehicles[idx][tAmmo2] = strval(arrCoords[12]);
Vehicles[idx][tAmmo3] = strval(arrCoords[13]);
}
AddStaticVehicleEx(Vehicles[idx][vModelID],Vehicles[idx][vPositionX],Vehicles[idx][vPositionY],Vehicles[idx][vPositionZ],Vehicles[idx][vAngleZ],Vehicles[idx][vColor1],Vehicles[idx][vColor2],30000);
}
printf("%d Cars loaded from mysql", totalcars);
return 0;
}
[/cut]