26.07.2016, 09:59
you forgot to put ,i in your format so vehicle id wasn't getting wrote on your query....
about the stock read that:
https://sampforum.blast.hk/showthread.php?tid=570635
PHP Code:
/* ============================================================================= */
ReloadVehicle(i)
{
new
query1[128]
;
mysql_format(connection, query1, sizeof(query1), "SELECT * FROM Vehicles WHERE id = '%i'", i);
mysql_tquery(connection, query1, "LoadVehicle","d",i);
printf("Car id %i has been respawned!",i);
return 1;
}
/* ============================================================================= */
forward LoadVehicle(id);
public LoadVehicle(id)
{
new vSAMPID[120],vMYSQLID[120];
DestroyVehicle(id);
Vehicle[id][vModel] = cache_get_field_content_int(id, "vModel");
Vehicle[id][vColor1] = cache_get_field_content_int(id, "vColor1");
Vehicle[id][vColor2] = cache_get_field_content_int(id, "vColor2");
Vehicle[id][vX] = cache_get_field_content_int(id, "vX");
Vehicle[id][vY] = cache_get_field_content_int(id, "vY");
Vehicle[id][vZ] = cache_get_field_content_int(id, "vZ");
Vehicle[id][vA] = cache_get_field_content_int(id, "vA");
new owner[25];
cache_get_field_content(id, "vOwner", owner);
myStrcpy(Vehicle[id][vOwner], owner);
new sampid = CreateVehicle(Vehicle[id][vModel], Vehicle[id][vX], Vehicle[id][vY], Vehicle[id][vZ], Vehicle[id][vA], Vehicle[id][vColor1], Vehicle[id][vColor2], -1, 0);
new engine, lights, alarm, doors, bonnet, boot, objective;
GetVehicleParamsEx(sampid, engine, lights, alarm, doors, bonnet, boot, objective);
SetVehicleParamsEx(sampid, 0, lights, alarm, doors, bonnet, boot, objective);
vSAMPID[id] = sampid;
vMYSQLID[sampid] = id;
return 1;
}
/* ============================================================================= */
https://sampforum.blast.hk/showthread.php?tid=570635