[CraftMan]

PHP код:

stock LoadVehicles(playerid, idx)
{
    new query[MAX_QUERY],result[MAX_RESULT],Float:x,Float:y,Float:z,Float:a;
    format(query,sizeof(query), "SELECT * FROM `"CarsTable"` WHERE id = '%d'", idx);
    mysql_query(query);
    mysql_store_result();
    
    allvehicles++;
    if(mysql_fetch_row(result))
    {
        new var[MAX_STRING];
        
        mysql_get_field("Model", var); CarInfo[idx][cModel] = strval(var);
        mysql_get_field("Color1", var); CarInfo[idx][cColorOne] = strval(var);
        mysql_get_field("Color2", var); CarInfo[idx][cColorTwo] = strval(var);
        mysql_get_field(CarInfo[idx][cOwned], "Owner");
        mysql_get_field("Owned", var); CarInfo[idx][cOwned] = strval(var);
        mysql_get_field("Price", var); CarInfo[idx][cPrice] = strval(var);
        
        mysql_get_field("Mod1", var); CarInfo[idx][cMod1] = strval(var); 
        mysql_get_field("Mod2", var); CarInfo[idx][cMod2] = strval(var); 
        mysql_get_field("Mod3", var); CarInfo[idx][cMod3] = strval(var); 
        mysql_get_field("Mod4", var); CarInfo[idx][cMod4] = strval(var); 
        mysql_get_field("Mod5", var); CarInfo[idx][cMod5] = strval(var); 
        mysql_get_field("Mod6", var); CarInfo[idx][cMod6] = strval(var); 
        mysql_get_field("Mod7", var); CarInfo[idx][cMod7] = strval(var); 
        mysql_get_field("Mod8", var); CarInfo[idx][cMod8] = strval(var); 
        mysql_get_field("Mod9", var); CarInfo[idx][cMod9] = strval(var); 
        mysql_get_field("Mod10", var); CarInfo[idx][cMod10] = strval(var); 
        mysql_get_field("Mod11", var); CarInfo[idx][cMod11] = strval(var); 
        mysql_get_field("Mod12", var); CarInfo[idx][cMod12] = strval(var); 
        mysql_get_field("Mod13", var); CarInfo[idx][cMod13] = strval(var); 
        mysql_get_field("Mod14", var); CarInfo[idx][cMod14] = strval(var); 
        mysql_get_field("Mod15", var); CarInfo[idx][cMod15] = strval(var); 
        mysql_get_field("PaintJob", var); CarInfo[idx][cPaintJob] = strval(var); 
        mysql_get_field("neon", var); CarInfo[idx][cNeon] = strval(var);
    }
} 


log

Код:

[01:29:20] CMySQLHandler::Query(SELECT * FROM `da_cars` WHERE id = '528') - Successfully executed.

[01:29:20] >> mysql_store_result( Connection handle: 1 )

[01:29:20] CMySQLHandler::StoreResult() - Result was stored.

[01:29:20] >> mysql_fetch_row_format( Connection handle: 1 )

[01:29:20] CMySQLHandler::FetchRow() - Return: 528|475|-1|-1|iDeepS|1|20000|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0

[01:29:20] >> mysql_fetch_field_row( Connection handle: 1 )

[01:29:20] CMySQLHandler::FetchField("Model") - 475

and then does not go

[CraftMan]

work

PHP код:

mysql_get_field("Model", var);
        mysql_get_field("Color1", var);
        mysql_get_field("Color2", var); 


no work

PHP код:

        mysql_get_field("Model", var); CarInfo[idx][cModel] = strval(var); 
        mysql_get_field("Color1", var); CarInfo[idx][cColorOne] = strval(var); 
        mysql_get_field("Color2", var); CarInfo[idx][cColorTwo] = strval(var); 


heeelp

[CraftMan]

Very strange problem in the query and return it to work so

PHP код:

1 | 475 | -1 | -1 | Mamont | 1 | 20 000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 


and so does not work, he will only ask for a Model 475 is

PHP код:

528 | 475 | -1 | -1 | iDeepS | 1 | 20 000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 


And yet, how to solve?

[Mean]

And yet, you didn't explain your problem properly.