[Mattakil]

I checked the mysql log, checked the query..all seems well, though the vehicle doesn't create.

pawn Код:

stock LoadVehicle(ID)
{
    new Query[300], Field[30], string1[MAX_PLAYER_NAME];
    format(Query, sizeof(Query), "SELECT * FROM `VEHICLES` WHERE `ID` = %d", ID);
    mysql_query(Query);

    mysql_store_result();
    while(mysql_fetch_row_format(Query,"|"))
    {
        mysql_fetch_field_row(Field, "MODEL");
        VehicleInfo[ID][vModel] = strval(Field);
        mysql_fetch_field_row(Field, "SPAWNX");
        VehicleInfo[ID][vSpawnX] = floatstr(Field);
        mysql_fetch_field_row(Field, "SPAWNY");
        VehicleInfo[ID][vSpawnY] = floatstr(Field);
        mysql_fetch_field_row(Field, "SPAWNZ");
        VehicleInfo[ID][vSpawnZ] = floatstr(Field);
        mysql_fetch_field_row(Field, "ANGLE");
        VehicleInfo[ID][vAngle] = floatstr(Field);
        mysql_fetch_field_row(Field, "COL1");
        VehicleInfo[ID][vColorOne] = strval(Field);
        mysql_fetch_field_row(Field, "COL2");
        VehicleInfo[ID][vColorTwo] = strval(Field);
        mysql_fetch_field_row(Field, "OWNER");
        VehicleInfo[ID][vOwner] = string1;
        mysql_fetch_field_row(Field, "PLATE");
        VehicleInfo[ID][vPlate] = strval(Field);
        mysql_fetch_field_row(Field, "FUEL");
        VehicleInfo[ID][vFuel] = strval(Field);
        mysql_fetch_field_row(Field, "IMPOUNDED");
        VehicleInfo[ID][vImpounded] = strval(Field);
        mysql_fetch_field_row(Field, "CASH");
        VehicleInfo[ID][vCash] = strval(Field);
        mysql_fetch_field_row(Field, "BATTERY");
        VehicleInfo[ID][vBattery] = strval(Field);
        mysql_fetch_field_row(Field, "FACTION");
        VehicleInfo[ID][vFaction] = strval(Field);
        mysql_fetch_field_row(Field, "RENTABLE");
        VehicleInfo[ID][vRentable] = strval(Field);
        mysql_fetch_field_row(Field, "PUBLIC");
        VehicleInfo[ID][vPublic] = strval(Field);
        mysql_fetch_field_row(Field, "ID");
        VehicleInfo[ID][vID] = strval(Field);
        VehicleInfo[ID][vCreated] = 1;
    }
    mysql_free_result();
    CreateVehicle(VehicleInfo[ID][vModel], VehicleInfo[ID][vSpawnX], VehicleInfo[ID][vSpawnY], VehicleInfo[ID][vSpawnZ], VehicleInfo[ID][vAngle], VehicleInfo[ID][vColorOne], VehicleInfo[ID][vColorTwo], -1);
    return 1;
}

[StreetGT]

turn mysql_debug on and check logs.

[Mattakil]

Quote:

Originally Posted by StreetGT turn mysql_debug on and check logs.

Quote:

Originally Posted by Mattakil I checked the mysql log, checked the query

Everything is fine :P

[newbienoob]

Try to debug it;
printf("%d \n%f \n%f ... and so on", VehicleInfo[ID][vModel], VehicleInfo[ID][vSpawnX], VehicleInfo[ID][vSpawnY] .. and so on.

[Mattakil]

Hmm, everything is set to 0, but I can't see anything wrong with the query to set it :P (Also, the Query loads the proper data)