[k2168]

I'm making a system of vehicle. and I got a problem while loading rows from mysql.

mysql has 10 rows and when the server trying to load rows from table, it loads only 4 rows.

here's my code.

PHP код:

stock LoadPlayerVehicles()
{
    new query[120];
    
    mysql_format(g_Handle, query, sizeof(query), "SELECT * FROM `vehicles`");
    mysql_tquery(g_Handle, query, "OnLoadVehicles", "");
    return 1;
}
public OnLoadVehicles()
{
    for(new i = 0; i < cache_get_row_count(); i++)
    {
        g_VehicleInfo[i][vehicle_ModelID]   = cache_get_field_content_int(i, "vehicle_ModelID");
        g_VehicleInfo[i][vehicle_OwnerID]   = cache_get_field_content_int(i, "vehicle_OwnerID");
        
        g_VehicleInfo[i][vehicle_Color1]    = cache_get_field_content_int(i, "vehicle_Color1");
        g_VehicleInfo[i][vehicle_Color2]    = cache_get_field_content_int(i, "vehicle_Color1");
        
        g_VehicleInfo[i][vehicle_ParkX]    = cache_get_field_content_int(i, "vehicle_ParkX");
        g_VehicleInfo[i][vehicle_ParkX]    = cache_get_field_content_int(i, "vehicle_ParkY");
        g_VehicleInfo[i][vehicle_ParkX]    = cache_get_field_content_int(i, "vehicle_ParkZ");
        g_VehicleInfo[i][vehicle_Angle]    = cache_get_field_content_int(i, "vehicle_Angle");
        
        /*new vehicle = CreateVehicle();
        SetVehicleNumberPlate(vehicle, plate);*/
    }
    return 1;
} 


[Stones]

PHP код:

stock LoadPlayerVehicles() 
{ 
    new query[120]; 
     
    mysql_format(g_Handle, query, sizeof(query), "SELECT * FROM `vehicles`"); 
    mysql_tquery(g_Handle, query, "OnLoadVehicles", ""); 
    return 1; 
} 
public OnLoadVehicles() 
{ 
    for(new i = 0; i < cache_get_row_count(); i++) 
    { 
        g_VehicleInfo[i][vehicle_ModelID]   = cache_get_field_content_int(i, "vehicle_ModelID"); 
        g_VehicleInfo[i][vehicle_OwnerID]   = cache_get_field_content_int(i, "vehicle_OwnerID"); 
         
        g_VehicleInfo[i][vehicle_Color1]    = cache_get_field_content_int(i, "vehicle_Color1"); 
        g_VehicleInfo[i][vehicle_Color2]    = cache_get_field_content_int(i, "vehicle_Color2"); 
         
        g_VehicleInfo[i][vehicle_ParkX]    = cache_get_field_content_int(i, "vehicle_ParkX"); 
        g_VehicleInfo[i][vehicle_ParkY]    = cache_get_field_content_int(i, "vehicle_ParkY"); 
        g_VehicleInfo[i][vehicle_ParkZ]    = cache_get_field_content_int(i, "vehicle_ParkZ"); 
        g_VehicleInfo[i][vehicle_Angle]    = cache_get_field_content_int(i, "vehicle_Angle"); 
         
        /*new vehicle = CreateVehicle(); 
        SetVehicleNumberPlate(vehicle, plate);*/ 
    } 
    return 1; 
} 


[jlalt]

PHP код:

public OnLoadVehicles()
{
    for(new i = 0; i < cache_get_row_count(); i++)
    {
        g_VehicleInfo[i][vehicle_ModelID]   = cache_get_row_int(i, field_index, g_Handle);
        
        g_VehicleInfo[i][vehicle_OwnerID]   = cache_get_row_int(i, field_index, g_Handle);

        g_VehicleInfo[i][vehicle_Color1]    = cache_get_row_int(i, field_index, g_Handle);
        g_VehicleInfo[i][vehicle_Color2]    = cache_get_row_int(i, field_index, g_Handle);

        cache_get_row(i, field_index, g_VehicleInfo[i][vehicle_ParkX], g_Handle, 128);
        cache_get_row(i, field_index, g_VehicleInfo[i][vehicle_ParkX], g_Handle, 128);
        cache_get_row(i, field_index, g_VehicleInfo[i][vehicle_ParkX], g_Handle, 128);
        cache_get_row(i, field_index, g_VehicleInfo[i][vehicle_Angle], g_Handle, 128);

        /*new vehicle = CreateVehicle();
        SetVehicleNumberPlate(vehicle, plate);*/
    }
    return 1;
} 


change field index with your data field index,
note: field index start at 0

[PrO.GameR]

If you have 10 rows and it loads 4, then it crashes on 4 ... See whats wrong with your fourth row, stuff such as accessing an out-of-bound array index will crash a public function, stopping it from loading

[nl-videomaster]

IDK if jlalt's thing worked but rewriting those lines with floats might make sense, as if the number is any diffrent from an integer it won't work. The positions are Float's so retrieving them should be as easy as replacing int with float:

PHP код:

stock LoadPlayerVehicles()
{
    new query[120];
    
    mysql_format(g_Handle, query, sizeof(query), "SELECT * FROM `vehicles`");
    mysql_tquery(g_Handle, query, "OnLoadVehicles", "");
    return 1;
}
public OnLoadVehicles()
{
    for(new i = 0; i < cache_get_row_count(); i++)
    {
        g_VehicleInfo[i][vehicle_ModelID]   = cache_get_field_content_int(i, "vehicle_ModelID");
        g_VehicleInfo[i][vehicle_OwnerID]   = cache_get_field_content_int(i, "vehicle_OwnerID");
        
        g_VehicleInfo[i][vehicle_Color1]    = cache_get_field_content_int(i, "vehicle_Color1");
        g_VehicleInfo[i][vehicle_Color2]    = cache_get_field_content_int(i, "vehicle_Color1");
        
        g_VehicleInfo[i][vehicle_ParkX]    = cache_get_field_content_float(i, "vehicle_ParkX");
        g_VehicleInfo[i][vehicle_ParkX]    = cache_get_field_content_float(i, "vehicle_ParkY");
        g_VehicleInfo[i][vehicle_ParkX]    = cache_get_field_content_float(i, "vehicle_ParkZ");
        g_VehicleInfo[i][vehicle_Angle]    = cache_get_field_content_float(i, "vehicle_Angle");
        
        /*new vehicle = CreateVehicle();
        SetVehicleNumberPlate(vehicle, plate);*/
    }
    return 1;
} 


Good luck with your system.