SA-MP Forums Archive
[MySQL] Get Info Error - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: [MySQL] Get Info Error (/showthread.php?tid=294013)


[MySQL] Get Info Error - CraftMan - 30.10.2011

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

Re: [MySQL] Get Info Error - CraftMan - 31.10.2011

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

Re: [MySQL] Get Info Error - CraftMan - 31.10.2011

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?

Re: [MySQL] Get Info Error - Mean - 31.10.2011

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