Код:
LoadVehicles(playerid)
{
p_vehicles[playerid] = 0;
new str[49+(-2+MAX_PLAYER_NAME)+1];
format(str, sizeof(str), "SELECT * FROM `personal_car` WHERE `OWNER` = '%s'", u_name[playerid]);//форматируем запрос
mysql_tquery(v_db, str, "OnLoadVehicles", "i", playerid);//отправляем его и получаем результат в OnLoadVehicles
return true;
}
forward OnLoadVehicles(playerid);
public OnLoadVehicles(playerid)
{
if(!cache_num_rows())//если результата нет, пропускаем код
return true;
new Float:x, Float:y, Float:z, Float:a;
for(new j = cache_num_rows()-1; j != -1; --j)
{
if(j == MAX_CARS+1)
break;
cache_get_value_name(j, "OWNER", v_system[j][v_owner], MAX_PLAYER_NAME);
cache_get_value_name_int(j, "VEHICLE_ID", v_system[j][v_id]);
cache_get_value_name_float(j, "POS_X", x);
cache_get_value_name_float(j, "POS_Y", y);
cache_get_value_name_float(j, "POS_Z", z);
cache_get_value_name_float(j, "POS_A", a);
cache_get_value_name_int(j, "COLOR_1", v_system[j][v_color][0]);
cache_get_value_name_int(j, "COLOR_2", v_system[j][v_color][1]);
cache_get_value_name_int(j, "PAINTJOB", v_system[j][v_paintjob]);
v_system[j][v_car] = CreateVehicle( v_system[ j ][ v_id ], x, y, z, a, v_system[ j ][ v_color ][ 0 ], v_system[ j ][ v_color ][ 1 ], 999999);
p_vehicles[ playerid ]++;
}
return true;
}
Как-то вот так вот.