Vehicles loading from DB but not spawning?
#9

You have Define MAX_VEHICLES or w/e on top of your script? if not just add
pawn Код:
public LoadVehicles()
{
    new i;
    mysql_query("SELECT * FROM vehicles");
    mysql_store_result();
    new field[128][128];
    if(mysql_num_rows() != 0)
    {
        VehicleInfo[i][cID] = strval(field[0]);
        VehicleInfo[i][cModel] = strval(field[1]);
        VehicleInfo[i][cPosX] = floatstr(field[2]);
        VehicleInfo[i][cPosY] = floatstr(field[3]);
        VehicleInfo[i][cPosZ] = floatstr(field[4]);
        VehicleInfo[i][cAngle] = floatstr(field[5]);
        VehicleInfo[i][cInterior] = strval(field[6]);
        VehicleInfo[i][cWorld] = strval(field[7]);
        VehicleInfo[i][cColor1] = strval(field[8]);
        VehicleInfo[i][cColor2] = strval(field[9]);
        VehicleInfo[i][cFaction] = strval(field[10]);
        VehicleInfo[i][cAlarm] = 0;
        VehicleInfo[i][cEngine] = 0;
        VehicleInfo[vehid][cFuel] = 100.0;
        AddStaticVehicle(VehicleInfo[i][cModel],VehicleInfo[i][cPosX],VehicleInfo[i][cPosY],VehicleInfo[i][cPosZ],VehicleInfo[i][cAngle],VehicleInfo[i][cColor1],VehicleInfo[i][cColor2]);
        LinkVehicleToInterior(i,VehicleInfo[i][cInterior]);
        SetVehicleVirtualWorld(i,VehicleInfo[i][cWorld]);
    }
    mysql_free_result();
    return 1;
}
if you do add
pawn Код:
public LoadVehicles()
{
    for(new i=1; i<MAX_VEHICLE; i++)//edit the max_vehicle to urs
    {
    mysql_query("SELECT * FROM vehicles WHERE ID = '%d'",i);
    mysql_store_result();
    new field[128][128];
    if(mysql_num_rows() != 0)
    {
        VehicleInfo[i][cID] = strval(field[0]);
        VehicleInfo[i][cModel] = strval(field[1]);
        VehicleInfo[i][cPosX] = floatstr(field[2]);
        VehicleInfo[i][cPosY] = floatstr(field[3]);
        VehicleInfo[i][cPosZ] = floatstr(field[4]);
        VehicleInfo[i][cAngle] = floatstr(field[5]);
        VehicleInfo[i][cInterior] = strval(field[6]);
        VehicleInfo[i][cWorld] = strval(field[7]);
        VehicleInfo[i][cColor1] = strval(field[8]);
        VehicleInfo[i][cColor2] = strval(field[9]);
        VehicleInfo[i][cFaction] = strval(field[10]);
        VehicleInfo[i][cAlarm] = 0;
        VehicleInfo[i][cEngine] = 0;
        VehicleInfo[vehid][cFuel] = 100.0;
        AddStaticVehicle(VehicleInfo[i][cModel],VehicleInfo[i][cPosX],VehicleInfo[i][cPosY],VehicleInfo[i][cPosZ],VehicleInfo[i][cAngle],VehicleInfo[i][cColor1],VehicleInfo[i][cColor2]);
        LinkVehicleToInterior(i,VehicleInfo[i][cInterior]);
        SetVehicleVirtualWorld(i,VehicleInfo[i][cWorld]);
    }
    mysql_free_result();
    }
    return 1;
}
Reply


Messages In This Thread

Forum Jump:


Users browsing this thread: 2 Guest(s)