[justjamie]

title.


the x,y,z and angle in the database stay 0,00000000.

This is the code.

PHP код:

saveCarToDB(playerid,carid)
{
new query[128];
format(query,sizeof(query),"INSERT INTO vehicles(owner,model,x,y,z,a) VALUES ('%s','%i','%f','%f','%f','%f')",cInfo[playerid][carowner],cInfo[carid][carmodelid],cInfo[carid][c_x],cInfo[carid][c_y],cInfo[carid][c_z],cInfo[carid][c_r]);
mysql_function_query(dbhandle,query,true,"carSavedToDB","i",carid);
}
createPlayerCar(playerid,mID,Float:x,Float:y,Float:z,Float:r,temp_color1,temp_color2,temp_autorespawn)
{
    for(new i=0; i< sizeof(cInfo); i++)
    {
     if(cInfo[i][id_x]!=0)continue;
     format(cInfo[i][carowner],MAX_PLAYER_NAME,"%s",PlayerName(playerid));
     cInfo[i][c_x]=x;
     cInfo[i][c_y]=y;
     cInfo[i][c_z]=z;
     cInfo[i][c_r]=r;
     cInfo[i][c_color1]=temp_color1;
      cInfo[i][c_color2]=temp_color2;
      cInfo[i][c_autorespawn]=temp_autorespawn;
      cInfo[i][carmodelid]= mID;
     cInfo[i][id_x]= CreateVehicle(mID,x,y,z,r,temp_color1,temp_color2,temp_autorespawn);
     saveCarToDB(playerid,id_x);
     return 1;
    }
    return 1;
} 


edit: the model also stays 0 (carmodelid)

[saffierr]

PHP код:

format(query,sizeof(query),"INSERT INTO vehicles (`owner`, `model` ,`x` ,`y` ,`z` ,`a`) VALUES ('%s', %i, %f, %f, %f, %f)",cInfo[playerid][carowner],cInfo[carid][carmodelid],cInfo[carid][c_x],cInfo[carid][c_y],cInfo[carid][c_z],cInfo[carid][c_r]); 


Not sure if it is this, but you could try it.

[Deroxi]

Код:

format(query,sizeof(query),"INSERT INTO vehicles(owner,model,x,y,z,a) VALUES ('%s','%i','%f','%f','%f',

try making it into this:

Код:

format(query,sizeof(query),"INSERT INTO 'vehicles' (owner,model,x,y,z,a) VALUES ('%s','%i','%f','%f','%f',

Or combine my solution with the one above this command. Good luck!

[justjamie]

fixed it thanks