LoadVehicleStats()
{
mysql_tquery(Database, "SELECT * FROM Vehicles LIMIT" #MAX_PVEHICLES, "OnVehiclesAvailable");
return 1;
}
public OnVehiclesAvailable()
{
for(new i = 0; i < MAX_PVEHICLES; i++)
{
cache_get_value_int(i, "ID", VehicleInfo[i][ID]);
cache_get_value(i, "Owner", VehicleInfo[i][vOwner], 24);
cache_get_value_int(i, "vModel", VehicleInfo[i][vModel]);
cache_get_value_float(i, "Pos_x", VehicleInfo[i][vPos_x]);
cache_get_value_float(i, "Pos_y", VehicleInfo[i][vPos_y]);
cache_get_value_float(i, "Pos_z", VehicleInfo[i][vPos_z]);
cache_get_value_float(i, "Rot", VehicleInfo[i][vRot]);
cache_get_value_int(i, "Fuel", VehicleInfo[i][vFuel]);
cache_get_value_int(i, "Type", VehicleInfo[i][vType]);
cache_get_value(i, "Plate", VehicleInfo[i][vPlate], 120);
cache_get_value_int(i, "vLock", VehicleInfo[i][vLock]);
cache_get_value_int(i, "Color1", VehicleInfo[i][vColor1]);
cache_get_value_int(i, "Color2", VehicleInfo[i][vColor2]);
cache_get_value_int(i, "RespawnDelay", VehicleInfo[i][vRespawnDelay]);
cache_get_value_int(i, "Price", VehicleInfo[i][vPrice]);
VehicleInfo[i][Vehicle_Cache] = cache_save();
pvehicle[VehicleInfo[i][ID]] = CreateVehicle(VehicleInfo[i][vModel], VehicleInfo[i][vPos_x], VehicleInfo[i][vPos_y], VehicleInfo[i][vPos_z], VehicleInfo[i][vRot], VehicleInfo[i][vColor1], VehicleInfo[i][vColor2], VehicleInfo[i][vRespawnDelay]);
SetVehicleNumberPlate(pvehicle[VehicleInfo[i][ID]], VehicleInfo[i][vPlate]);
}
return 1;
}
CMD:testcar(playerid, params[])
{
new string[200], vid;
vid = GetPlayerVehicleID(playerid);
format(string, sizeof(string), "Vehicle ID: %d | Vehicle Type: %d, Plate: %s | Owner: %s", vid, VehicleInfo[vid][vType], VehicleInfo[vid][vPlate], VehicleInfo[vid][vOwner] );
SCM(playerid, COLOR_YELLOW, string);
return 1;
}
mysql_tquery(Database, "SELECT * FROM Vehicles LIMIT "#MAX_PVEHICLES"", "OnVehiclesAvailable");
maybe there is something wrong with the current query, try this one:
Код:
mysql_tquery(Database, "SELECT * FROM Vehicles LIMIT "#MAX_PVEHICLES"", "OnVehiclesAvailable"); |
LoadVehicleStats()
{
mysql_tquery(Database, "SELECT * FROM Vehicles" "OnVehiclesAvailable");
return 1;
}
REMOVE MAX_PVEHICLE as your limit coz it will read that...
or just remove the LIMIT part towards the MAX_PVEHICLE don't set any maximum if you are loading player cars Yiu should het it from the id. PHP код:
then remove that for loop |
new rows;
use cache_get_row_count(rows);
if(rows)
{
for(new i; i < rows; i++)
// your code here
}
mysql_tquery(MySQL, "SELECT * FROM Vehicle ORDER BY ID", "OnVehiclesLoad", "");
PUBLIC:OnVehiclesLoad()
{
for (new i, r = 1, j = cache_num_rows(); i != j; i++, r++)
{
cache_get_value_int(i, "ID", vStats[r][vSQLIB]);
cache_get_value_float(i, "x", vStats[r][vX]);
cache_get_value_float(i, "y", vStats[r][vY]);
cache_get_value_float(i, "z", vStats[r][vZ]);
cache_get_value_int(i, "Color1", vStats[r][vColor1]);
cache_get_value_int(i, "Color2", vStats[r][vColor2]);
cache_get_value_float(i, "Health", vStats[r][vHealth]);
cache_get_value_int(i, "Model", vStats[r][vModel]);
cache_get_value_int(i, "Respawn", vStats[r][vRespawn]);
cache_get_value_float(i, "Angle", vStats[r][vZr]);
cache_get_value(i, "Plate", vStats[r][vPlate], 20);
CreatedVehicle[r] = false;
#if DebugMode
printf("Vйhicule ID %i", r);
#endif
vStats[r][vID] = CreateVehicle(vStats[r][vModel], vStats[r][vX], vStats[r][vY], vStats[r][vZ], vStats[r][vZr], vStats[r][vColor1], vStats[r][vColor2], vStats[r][vRespawn]);
SetVehicleHealth(vStats[r][vID], vStats[r][vHealth]);
SetVehicleNumberPlate(vStats[r][vID], vStats[r][vPlate]);
#if DebugMode
GetVehicleDebugInfos(r);
#endif
}
print("[SERVER] All vehicle are loaded.\n\n");
}