Error in SQL syntax "string"
#4

Welp i fixed that thing; now everything works, BUT, when i load up the server, the car didn't spawn, even tho it is in the database.
Full code:
PHP код:
forward onPlayerCarLoad(playerid);
public 
onPlayerCarLoad(playerid)
{
new 
num_fields,num_rows;
new 
temp_carowner[35],temp_plate[50];
cache_get_data(num_rows,num_fields,dbhandle);
if(!
num_rows)return 1;
 for(new 
i=0i<num_rowsi++)
 {
  
cInfo[i][db_id]=cache_get_field_content_int(i,"id",dbhandle);
  new 
id=cInfo[id][db_id];
  
cInfo[id][carmodelid]=cache_get_field_content_int(i,"model",dbhandle);
  
cInfo[id][c_x]=cache_get_field_content_float(i,"x",dbhandle);
  
cInfo[id][c_y]=cache_get_field_content_float(i,"y",dbhandle);
  
cInfo[id][c_z]=cache_get_field_content_float(i,"z",dbhandle);
  
cInfo[id][c_r]=cache_get_field_content_float(i,"a",dbhandle);
  
cInfo[id][c_color1]=cache_get_field_content_int(i,"color1",dbhandle);
  
cInfo[id][c_color2]=cache_get_field_content_int(i,"color1",dbhandle);
  
cInfo[id][c_respawntime]=cache_get_field_content_int(i,"autorespawn",dbhandle);
  
cache_get_field_content(0"plate"temp_plate);
cache_get_field_content(0"owner"temp_carowner);
format(cInfo[id][plate],30,"%s",temp_plate);
format(cInfo[id][carowner],24,"%s",temp_carowner);

CreateVehicle(cInfo[id][carmodelid],cInfo[id][c_x],cInfo[id][c_y],cInfo[id][c_z],cInfo[id][c_r],cInfo[id][c_color1],cInfo[id][c_color2],cInfo[id][c_respawntime]);
cInfo[id][cnitro]=cache_get_field_content_int(i,"nitro",dbhandle);
AddVehicleComponent(id,cInfo[id][cnitro]);
}
return 
1;
}
loadPlayerCars(playerid)
{
new 
query[128],name[35];
GetPlayerName(playerid,name,35);
format(query,sizeof(query),"SELECT * FROM vehicles WHERE owner='%s'",name);
mysql_function_query(dbhandle,query,true,"onPlayerCarLoad","i",playerid);

(OnPlayerConnect has loadPlayerCars(playerid); )
Reply


Messages In This Thread
Error in SQL syntax "string" - by justjamie - 24.05.2016, 15:24
Re: Error in SQL syntax "string" - by ilijap - 24.05.2016, 15:38
Re: Error in SQL syntax "string" - by justjamie - 24.05.2016, 15:44
Re: Error in SQL syntax "string" - by justjamie - 24.05.2016, 15:58
Re: Error in SQL syntax "string" - by justjamie - 24.05.2016, 16:01
Re: Error in SQL syntax "string" - by ilijap - 24.05.2016, 16:01
Re: Error in SQL syntax "string" - by justjamie - 24.05.2016, 16:03
Re: Error in SQL syntax "string" - by ilijap - 24.05.2016, 16:08
Re: Error in SQL syntax "string" - by Vince - 24.05.2016, 17:02
Re: Error in SQL syntax "string" - by ilijap - 24.05.2016, 17:03

Forum Jump:


Users browsing this thread: 1 Guest(s)