Neišsaugo transporto pozicijos.

[wuPoR]

Kažkodėl neišsaugo transporto pozicijos, lentelėj būna 0..

Saugojimo kodas:

stock MySQL_Vehicle_Save(playerid)
{
    if(pDT[playerid][pMasina] != -1)
    {
         new
            Query[512],
            modelis = GetVehicleModel(playerid),
            vehicleids = pDT[playerid][pMasina];

        printf("Išsaugoma mašina. [%s]", GetPlayerNameEx(playerid));

        format( Query,sizeof( Query ),"UPDATE `transportas` SET lastpos1 = '%f', lastpos2 = '%f', lastpos3 = '%f',lastpos4 = '%f', model = '%i', WHERE vardas = '%s'",\
        vDT[vehicleids][lastpos][0],vDT[vehicleids][lastpos][1],vDT[vehicleids][lastpos][2],vDT[vehicleids][lastpos][3],modelis, GetPlayerNameEx( playerid ));
        mysql_query( Query );
    }
    return 1;
}

Last Pos nustatymas:

               vDT[vehicleids][lastpos][0] = 793.2609;
              vDT[vehicleids][lastpos][1] = posit;
              vDT[vehicleids][lastpos][2] = 16.1633;
              vDT[vehicleids][lastpos][3] = 268.7502;



new Float:posz[]=
            {-490.9190,-487.0200,-483.7587,-480.1901};
            

                iRandom = random( sizeof( posz ) ),
                Float:posit = posz[ iRandom ];

[MartynasK]

mySQL log?

[wuPoR]

WHERE vardas = 'Easy_Stiffler') - Successfully executed.

[21:27:25] >> mysql_query( Connection handle: 1 )

[21:27:25] CMySQLHandler::Query(UPDATE `transportas` SET lastpos1 = '793.260925', lastpos2 = '-490.919006', lastpos3 = '16.163299',lastpos4 = '268.750213', model = '0', WHERE vardas = 'Easy_Stiffler') - An error has occured. (Error ID: 1064, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE vardas = 'Easy_Stiffler'' at line 1)

Dabar jau matau kad erroras bet nežinau koks

[Diro`]

WHERE vardas = 'Easy_Stiffler') - Successfully executed.

[21:27:25] >> mysql_query( Connection handle: 1 )

[21:27:25] CMySQLHandler::Query(UPDATE `transportas` SET lastpos1 = '793.260925', lastpos2 = '-490.919006', lastpos3 = '16.163299',lastpos4 = '268.750213', model = '0', WHERE vardas = 'Easy_Stiffler') - An error has occured. (Error ID: 1064, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE vardas = 'Easy_Stiffler'' at line 1)

Dabar jau matau kad erroras bet nežinau koks

tiesiog kur WHERE vardas yra klaida su `rodos.

[wuPoR]

tiesiog kur WHERE vardas yra klaida su `rodos.

arba neižiūriu arba nėra.

[MartynasK]

Pabandyk taip

stock MySQL_Vehicle_Save(playerid)
{
    if(pDT[playerid][pMasina] != -1)
    {
         new
            Query[512],
            modelis = GetVehicleModel(playerid),
            vehicleids = pDT[playerid][pMasina];

        printf("Išsaugoma mašina. [%s]", GetPlayerNameEx(playerid));

        format( Query,sizeof( Query ),"UPDATE transportas SET lastpos1 = '%f', lastpos2 = '%f', lastpos3 = '%f',lastpos4 = '%f', model = '%i' WHERE vardas = '%s'",\
        vDT[vehicleids][lastpos][0],vDT[vehicleids][lastpos][1],vDT[vehicleids][lastpos][2],vDT[vehicleids][lastpos][3],modelis, GetPlayerNameEx( playerid ));
        mysql_query( Query );
    }
    return 1;
}

[wuPoR]

 

Pabandyk taip

stock MySQL_Vehicle_Save(playerid)
{
    if(pDT[playerid][pMasina] != -1)
    {
         new
            Query[512],
            modelis = GetVehicleModel(playerid),
            vehicleids = pDT[playerid][pMasina];

        printf("Išsaugoma mašina. [%s]", GetPlayerNameEx(playerid));

        format( Query,sizeof( Query ),"UPDATE transportas SET lastpos1 = '%f', lastpos2 = '%f', lastpos3 = '%f',lastpos4 = '%f', model = '%i' WHERE vardas = '%s'",\
        vDT[vehicleids][lastpos][0],vDT[vehicleids][lastpos][1],vDT[vehicleids][lastpos][2],vDT[vehicleids][lastpos][3],modelis, GetPlayerNameEx( playerid ));
        mysql_query( Query );
    }
    return 1;
}

same shit..

[wuPoR]

veikia ;D

[MartynasK]

veikia ;D

Kaip susitvarkei? Redaguok savo pranešimą ir parašyk. Gal kažkam nutiks tokia pati bėda ir jau bus atsakymas kitoje temoje.