11.10.2012, 07:36
Quote:
А теперь поясните мне как вы связали данное число с количеством машин?
Я могу загрузить 1 модель 2000 раз. |
PHP Code:
forward LoadMySQLCar();
public LoadMySQLCar()
{
new rows, fields;
cache_get_data(rows, fields);
if(rows)
{
for(new c; c < rows; c++)
{
new mysqltext[1024];
cache_get_field_content(c, "CarID", mysqltext), CarsInfo[c][vID] = strval(mysqltext);
cache_get_field_content(c, "Saled", mysqltext), CarsInfo[c][vSaled] = strval(mysqltext);
cache_get_field_content(c, "Owner", CarsInfo[c][vOwner]);
cache_get_field_content(c, "Model", mysqltext), CarsInfo[c][vModel] = strval(mysqltext);
cache_get_field_content(c, "Pos_X", mysqltext), CarsInfo[c][vPosX] = floatstr(mysqltext);
cache_get_field_content(c, "Pos_Y", mysqltext), CarsInfo[c][vPosY] = floatstr(mysqltext);
cache_get_field_content(c, "Pos_Z", mysqltext), CarsInfo[c][vPosZ] = floatstr(mysqltext);
cache_get_field_content(c, "Pos_Angle", mysqltext), CarsInfo[c][vPosAngle] = floatstr(mysqltext);
cache_get_field_content(c, "ColorOne", mysqltext), CarsInfo[c][vColorOne] = strval(mysqltext);
cache_get_field_content(c, "ColorTwo", mysqltext), CarsInfo[c][vColorTwo] = strval(mysqltext);
cache_get_field_content(c, "Lock", mysqltext), CarsInfo[c][vLock] = strval(mysqltext);
cache_get_field_content(c, "BuyPrice", mysqltext), CarsInfo[c][vBuyPrice] = strval(mysqltext);
cache_get_field_content(c, "Park_X", mysqltext), CarsInfo[c][vParkX] = floatstr(mysqltext);
cache_get_field_content(c, "Park_Y", mysqltext), CarsInfo[c][vParkY] = floatstr(mysqltext);
cache_get_field_content(c, "Park_Z", mysqltext), CarsInfo[c][vParkZ] = floatstr(mysqltext);
cache_get_field_content(c, "Park_Angle", mysqltext), CarsInfo[c][vParkAngle] = floatstr(mysqltext);
cache_get_field_content(c, "Number", mysqltext), CarsInfo[c][vNumber] = strval(mysqltext);
cache_get_field_content(c, "Date", mysqltext), CarsInfo[c][vDate] = strval(mysqltext);
cache_get_field_content(c, "Pass", mysqltext), CarsInfo[c][vPTS] = strval(mysqltext);
printf("ТС %d загруженí",CarsInfo[c][vID]);
}
}
CreateVehicles();
return true;
}
PHP Code:
mysql_function_query(dbHandle,"SELECT * FROM `cars`",true,"LoadMySQLCar","");