[UnknownGamer]

Still not fixed, this is a pain now. Cars constantly messing up.

pawn Код:

[22:21:17] [DEBUG] mysql_tquery - scheduling query "INSERT INTO vehicles VALUES (0, 0, 0.00, 0.00, 0.00, 0.00, 0, 0, 0, '', 0, 0, 0, 0, '') ON DUPLICATE KEY UPDATE id = LAST_INSERT_ID(id), model = VALUES(model), locX = VALUES(locX), locY = VALUES(locY), locZ = VALUES(locZ), angle = VALUES(angle), color1 = VALUES(color1), color2 = VALUES(color2), ownerId = VALUES(ownerId), owner = VALUES(owner),locked = VALUES(locked), paintjob = VALUES(paintjob), virtualworld = VALUES(virtualworld), code = VALUES(code), plate = VALUES(plate)"..
[22:21:17] [DEBUG] mysql_format - connection: 1, len: 548, format: "INSERT INTO vehicles VALUES (%d, %d, %.2f, %.2f, %.2f, %.2f, %d, %d, %d, '%e', %d, %d, %d, %d, '%e') ON DUPLICATE KEY UPDATE    id ..."
[22:21:17] [DEBUG] mysql_tquery - connection: 1, query: "INSERT INTO vehicles VALUES (0, 0, 0.00, 0.00, 0.00, 0.00, 0, 0,", callback: "FJ37DH3JG_MYSQL_INTERNAL", format: "d"
[22:21:17] [DEBUG] CMySQLQuery::CMySQLQuery() - constructor called
[22:21:17] [DEBUG] CMySQLQuery::Create - inline function detected
[22:21:17] [DEBUG] mysql_tquery - scheduling query "INSERT INTO vehicles VALUES (0, 0, 0.00, 0.00, 0.00, 0.00, 0, 0, 0, '', 0, 0, 0, 0, '') ON DUPLICATE KEY UPDATE id = LAST_INSERT_ID(id), model = VALUES(model), locX = VALUES(locX), locY = VALUES(locY), locZ = VALUES(locZ), angle = VALUES(angle), color1 = VALUES(color1), color2 = VALUES(color2), ownerId = VALUES(ownerId), owner = VALUES(owner),locked = VALUES(locked), paintjob = VALUES(paintjob), virtualworld = VALUES(virtualworld), code = VALUES(code), plate = VALUES(plate)"..
[22:21:17] [DEBUG] CMySQLQuery::Execute[()] - starting query execution
[22:21:17] [DEBUG] CMySQLQuery::Execute[()] - query was successful

That's from the MYSQL log.

pawn Код:

else if(update == 4)
    {       
        new
            query[548];
            
        inline CarHandler() {
            CarInfo[idx][cdbID] = cache_insert_id(dbhandle);
            
            mysql_tquery(dbhandle, "START TRANSACTION", "", "");
            
            for(new i = 0; i != MAX_CAR_COMPONENTS; ++i) {
                mysql_format(dbhandle, query, sizeof query, "INSERT INTO vehicle_components SET slotId = %d, vehicleId = %d, value = %d ON DUPLICATE KEY UPDATE value = VALUES(value)", i, CarInfo[idx][cdbID], CarInfo[idx][cComponent][i]);
                mysql_tquery(dbhandle, query, "", "");
            }
            
            mysql_tquery(dbhandle, "COMMIT", "", "");
            printf("[SCRIPT] MySQL Vehicle Updated (carid: %d, dbid: %d)", idx, CarInfo[idx][cdbID]);

            if(erase) fixmemset(CarInfo[idx], 0, cInfo);
        }

        /* @FUTURE */
        mysql_format(dbhandle, query, sizeof query, "INSERT INTO vehicles VALUES (%d, %d, %.2f, %.2f, %.2f, %.2f, %d, %d, %d, '%e', %d, %d, %d, %d, '%e') \
        ON DUPLICATE KEY UPDATE id = LAST_INSERT_ID(id), model = VALUES(model), ",
        CarInfo[idx][cdbID], CarInfo[idx][cModel], CarInfo[idx][cLocationx],    CarInfo[idx][cLocationy], 
        CarInfo[idx][cLocationz], CarInfo[idx][cAngle], CarInfo[idx][cColorOne], CarInfo[idx][cColorTwo],
        0, CarInfo[idx][cOwner], CarInfo[idx][cLock], CarInfo[idx][cPaintjob], CarInfo[idx][cVirWorld], CarInfo[idx][cCode], CarInfo[idx][cPlate]);
        
        strcat(query, "locX = VALUES(locX), \
        locY = VALUES(locY), locZ = VALUES(locZ), angle = VALUES(angle), \
        color1 = VALUES(color1), color2 = VALUES(color2), ownerId = VALUES(ownerId), \
        owner = VALUES(owner),\
        locked = VALUES(locked), paintjob = VALUES(paintjob), \
        virtualworld = VALUES(virtualworld), code = VALUES(code), plate = VALUES(plate)");      
        
        mysql_tquery_inline(dbhandle, query, using CarHandler, "");

That's the code... What is the issue, I don't see nothing wrong?