Vehicle doesn't get put in the database correctly

Vehicle doesn't get put in the database correctly - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Vehicle doesn't get put in the database correctly (/showthread.php?tid=608287)

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