View Single Post
Old 26/07/2016, 10:01 AM   #3
justjamie
Huge Clucker
 
Join Date: May 2014
Posts: 424
Reputation: 5
Default Re: Reload a vehicle doesn't work

Quote:
Originally Posted by jlalt View Post
you forgot to put ,i in your format so vehicle id wasn't getting wrote on your query....

PHP Code:

/* ============================================================================= */
ReloadVehicle(i)
{
    new
        
query1[128]
    ;
    
mysql_format(connectionquery1sizeof(query1), "SELECT * FROM Vehicles WHERE id = '%i'"i);
    
mysql_tquery(connectionquery1"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], -10);
         new 
enginelightsalarmdoorsbonnetbootobjective;
      
GetVehicleParamsEx(sampidenginelightsalarmdoorsbonnetbootobjective);
      
SetVehicleParamsEx(sampid0lightsalarmdoorsbonnetbootobjective);
      
vSAMPID[id] = sampid;
      
vMYSQLID[sampid] = id;
      return 
1;
}
/* ============================================================================= */ 
about the stock read that:
http://forum.sa-mp.com/showthread.php?t=570635
wtf.

i wanna kick myself in my balls really hard
how could i forget that, XDDDDDDDD.

thanks for ur time, rep
justjamie is offline   Reply With Quote