[jamesb93]

Hey,

Can anyone help as to why this sometimes dosent load vehicles. Sometimes it does but now it seems like it does it alot more.

pawn Код:

public LoadVehicles()
{
    CheckSQL();
    new resultline[256],vehid,sqlid,model,Float:x,Float:y,Float:z,Float:angle,col1,col2,type,price,ownerid;
    mysql_query("SELECT * FROM `vehicles`");
    mysql_store_result();
    while(mysql_fetch_row_format(resultline,"|") == 1)
    {
      sscanf(resultline,"p|ddffffddddd",sqlid,model,x,y,z,angle,col1,col2,type,price,ownerid);
        vehid = CreateVehicle(model,x,y,z,angle,col1,col2,-1);
      vInfo[vehid][vSQLId] = sqlid;
      vInfo[vehid][vModelId] = model;
      vInfo[vehid][vPos_X] = x;
      vInfo[vehid][vPos_Y] = y;
      vInfo[vehid][vPos_Z] = z;
      vInfo[vehid][vPos_A] = angle;
      vInfo[vehid][vColor1] = col1;
      vInfo[vehid][vColor2] = col2;
      vInfo[vehid][vBuyAble] = type;
      vInfo[vehid][vPrice] = price;
      vInfo[vehid][vOwnerId] = ownerid;
    }
    mysql_free_result();
    return 1;
}

or is it this:

pawn Код:

public SaveVehicle(vehid)
{
    new query[256];
    format(query,sizeof(query),"UPDATE `vehicles` SET model=%d,x=%f,y=%f,z=%f,a=%f,col1=%d,col2=%d,type=%d,price=%d,ownerid=%d WHERE vehid=%d",
        vInfo[vehid][vModelId],vInfo[vehid][vPos_X],vInfo[vehid][vPos_Y],vInfo[vehid][vPos_Z],vInfo[vehid][vPos_A],vInfo[vehid][vColor1],
        vInfo[vehid][vColor2],vInfo[vehid][vBuyAble],vInfo[vehid][vPrice],vInfo[vehid][vOwnerId],vInfo[vehid][vSQLId]);
    mysql_query(query);
    return 1;
}

Any help is greatly appreciated

[jamesb93]

-Bump-

Anyone got any clue?