04.04.2013, 13:10
Hello.
Today my problem is my car spawning,here i go,this should spawn it:
And this is the query:
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.
And the printf in the spawning part,output 000!
NEWS: it works on second try....Thats not even logical..
Today my problem is my car spawning,here i go,this should spawn it:
pawn Код:
new VehicleKeys[MAX_PLAYERS],Keys[MAX_VEHICLES];
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");
And this is the query:
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;
}
And the printf in the spawning part,output 000!
NEWS: it works on second try....Thats not even logical..
