neatnaujina duomenų db

[Funkis]

stock SaveCar(playerid)
{
    new tr = playerCar1[playerid],
        Float:bukles,
        Float:lastPosition[4],
        Engine, Lights, Alarm, Doors, Bonnet, Boot, Objective;

    GetVehiclePos(tr, lastPosition[0], lastPosition[1], lastPosition[2]);
    GetVehicleZAngle(tr, lastPosition[3]);
    GetVehicleParamsEx (tr, Engine, Lights, Alarm, Doors, Bonnet, Boot, Objective);
    GetVehicleHealth(tr, bukles);

    if ( playerCar1 [ playerid ] != -1 )
    {
        format(g_szBuffer, sizeof g_szBuffer, 

        "UPDATE "MySQL_VEHICLE_TABLE" SET \
        \
            uzraktas = %i,\
            degalai = %f,\
            statusas = %i,\
            variklis = %i,\
            bukle = %f,\
            numeriai = %s,\
            rida = %f,\
            posX = %f,\
            posY = %f,\
            posZ = %f,\
            posA = %f,\
            technikine = %i,\
            techlaikas = %i\
        \
        WHERE savininkas = %s",
        masina[ tr ][ lock ],
        masina[ tr ][ Gas ],
        masina[ tr ][ status ],
        Engine,
        bukles,
        masina[ tr ][vehNumber],
        masina[ tr ][ vehRida ],
        lastPosition[0],
        lastPosition[1],
        lastPosition[2],
        lastPosition[3],
        masina[ tr ][ vehTech ],
        masina[ tr ][ vehTechtime ],
        getPlayerName(playerid));

        sql_query(sql, g_szBuffer, QUERY_THREADED);
        printf("%s transportas isaugotas ( %f , %f, %f, %f )", getPlayerName(playerid),lastPosition[0], lastPosition[1], lastPosition[2], lastPosition[3]);
    }
    DestroyVehicle(tr);
}

Print'as:

[07:52:43] Iam_Satan transportas isaugotas ( -2048.752929 , 307.547454, 40.620113, 49.947959 )

SQL log:

[07:52:43][debug] SQL_Worker[1]: Executing query (stmt->id = 63, stmt->query = UPDATE vehicles SET uzraktas = 0,degalai = 40.000000,statusas = 0,variklis = 1,bukle = 848.141967,numeriai = NEREGISTRUOTA,rida = 0.000000,posX = -2048.752929,posY = 307.547454,posZ = 40.620113,posA = 49.947959,technikine = 0,techlaikas = 0WHERE savininkas = Iam_Satan)...

dB:

help

[bebras]

Sakyčiau kad prieš "WHERE" dalį reikia tarpo... bet tokiu atveju turėtum gaut klaidą...

[Funkis]

Tarpai taip pat nieko nepakeičia..

[21:24:36][debug] Natives::sql_query: Scheduling statement (stmt->id = 16, stmt->query = UPDATE vehicles SET uzraktas = 0, degalai = 40.000000, statusas = 0, variklis = 1, bukle = 789.740234, numeriai = NEREGISTRUOTA, rida = 0.000000, posX = -2276.572265, posY = 365.594726, posZ = 33.922851, posA = 229.472518, technikine = 0, techlaikas = 0 WHERE savininkas = Iam_Satan, stmt->callback = ) for execution...

[21:24:36][debug] SQL_Worker[1]: Executing query (stmt->id = 16, stmt->query = UPDATE vehicles SET uzraktas = 0, degalai = 40.000000, statusas = 0, variklis = 1, bukle = 789.740234, numeriai = NEREGISTRUOTA, rida = 0.000000, posX = -2276.572265, posY = 365.594726, posZ = 33.922851, posA = 229.472518, technikine = 0, techlaikas = 0 WHERE savininkas = Iam_Satan)...

[xxxyiin]

WHERE savininkas = '%s'

 

Apskritai visi %f ir %s turi būti kabutėse, e.g. '%f', '%s'. Todėl ir numerius kur saugai įdėk %s į kabutes ' '

Redaguota Gruodžio 13, 2014, nario Yiin