Vehicle doesn't get put in the database correctly -
justjamie - 30.05.2016
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)
Re: Vehicle doesn't get put in the database correctly -
saffierr - 30.05.2016
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.
Re: Vehicle doesn't get put in the database correctly -
Deroxi - 30.05.2016
Код:
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!
Re: Vehicle doesn't get put in the database correctly -
justjamie - 30.05.2016
fixed it thanks