Hello.
pawn Код:
format(query,sizeof(query),"SELECT * FROM `vehicles` WHERE owner = '%s'",Name);
mysql_function_query(dbHandle,query,true,"OnVehicleLoad","i",playerid);
printf("%d",VehicleInfo[VehicleKeys[playerid]][model]);
printf("%f",VehicleInfo[VehicleKeys[playerid]][X]);
printf("%f",VehicleInfo[VehicleKeys[playerid]][Y]);
Keys[VehicleKeys[playerid]] = CreateVehicle(VehicleInfo[VehicleKeys[playerid]][model],VehicleInfo[VehicleKeys[playerid]][X],VehicleInfo[VehicleKeys[playerid]][Y],VehicleInfo[VehicleKeys[playerid]][Z],VehicleInfo[VehicleKeys[playerid]][R],VehicleInfo[VehicleKeys[playerid]][CColor1],VehicleInfo[VehicleKeys[playerid]][CColor2],-1);
SendClientMessage(playerid,0xFF0000FF,"Atsirado masina");
pawn Код:
forward OnVehicleLoad(playerid);
public OnVehicleLoad(playerid)
{
new tmp[16];
cache_get_row(0,9,VehicleInfo[VehicleKeys[playerid]][LPlate],dbHandle);
cache_get_row(0,1,VehicleInfo[VehicleKeys[playerid]][owner],dbHandle);
cache_get_row(0,3,tmp,dbHandle);
VehicleInfo[VehicleKeys[playerid]][model] = strval(tmp);
cache_get_row(0,4,tmp,dbHandle);
VehicleInfo[VehicleKeys[playerid]][X] = floatstr(tmp);
cache_get_row(0,5,tmp,dbHandle);
VehicleInfo[VehicleKeys[playerid]][Y] = floatstr(tmp);
cache_get_row(0,6,tmp,dbHandle);
VehicleInfo[VehicleKeys[playerid]][Z] = floatstr(tmp);
cache_get_row(0,7,tmp,dbHandle);
VehicleInfo[VehicleKeys[playerid]][R] = floatstr(tmp);
cache_get_row(0,8,tmp,dbHandle);
VehicleInfo[VehicleKeys[playerid]][Dauzta] = strval(tmp);
cache_get_row(0,10,tmp,dbHandle);
VehicleInfo[VehicleKeys[playerid]][Locked] = strval(tmp);
cache_get_row(0,12,tmp,dbHandle);
//VehicleInfo[VehicleKeys[playerid]][EngineHealth] = cache_get_row_float(0,11,dbHandle);
VehicleInfo[VehicleKeys[playerid]][PanelHealth] = strval(tmp);
cache_get_row(0,13,tmp,dbHandle);
VehicleInfo[VehicleKeys[playerid]][DoorHealth] = strval(tmp);
cache_get_row(0,14,tmp,dbHandle);
VehicleInfo[VehicleKeys[playerid]][LightsHealth] = strval(tmp);
cache_get_row(0,15,tmp,dbHandle);
VehicleInfo[VehicleKeys[playerid]][TiresHealth] = strval(tmp);
cache_get_row(0,16,tmp,dbHandle);
VehicleInfo[VehicleKeys[playerid]][Locks] = strval(tmp);
cache_get_row(0,17,tmp,dbHandle);
VehicleInfo[VehicleKeys[playerid]][Alarm] = strval(tmp);
cache_get_row(0,18,tmp,dbHandle);
VehicleInfo[VehicleKeys[playerid]][Insurance] = strval(tmp);
cache_get_row(0,19,tmp,dbHandle);
VehicleInfo[VehicleKeys[playerid]][CColor1] = strval(tmp);
cache_get_row(0,20,tmp,dbHandle);
VehicleInfo[VehicleKeys[playerid]][CColor2] = strval(tmp);
cache_get_row(0,21,tmp,dbHandle);
VehicleInfo[VehicleKeys[playerid]][Spawned] = strval(tmp);
cache_get_row(0,22,tmp,dbHandle);
VehicleInfo[VehicleKeys[playerid]][Wheels] = strval(tmp);
cache_get_row(0,23,tmp,dbHandle);
VehicleInfo[VehicleKeys[playerid]][Hydraulics] = strval(tmp);
return 1;
}
There is nothing wrong with it.I tried printing in the query,it works. Just so you won't think it might be the problem.