Mysql loading only four rows.
#1

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_Handlequerysizeof(query), "SELECT * FROM `vehicles`");
    
mysql_tquery(g_Handlequery"OnLoadVehicles""");
    return 
1;
}
public 
OnLoadVehicles()
{
    for(new 
0cache_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;

Reply
#2

PHP код:
stock LoadPlayerVehicles() 

    new 
query[120]; 
     
    
mysql_format(g_Handlequerysizeof(query), "SELECT * FROM `vehicles`"); 
    
mysql_tquery(g_Handlequery"OnLoadVehicles"""); 
    return 
1

public 
OnLoadVehicles() 

    for(new 
0cache_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

Reply
#3

PHP код:
public OnLoadVehicles()
{
    for(new 
0cache_get_row_count(); i++)
    {
        
g_VehicleInfo[i][vehicle_ModelID]   = cache_get_row_int(ifield_indexg_Handle);
        
        
g_VehicleInfo[i][vehicle_OwnerID]   = cache_get_row_int(ifield_indexg_Handle);

        
g_VehicleInfo[i][vehicle_Color1]    = cache_get_row_int(ifield_indexg_Handle);
        
g_VehicleInfo[i][vehicle_Color2]    = cache_get_row_int(ifield_indexg_Handle);

        
cache_get_row(ifield_indexg_VehicleInfo[i][vehicle_ParkX], g_Handle128);
        
cache_get_row(ifield_indexg_VehicleInfo[i][vehicle_ParkX], g_Handle128);
        
cache_get_row(ifield_indexg_VehicleInfo[i][vehicle_ParkX], g_Handle128);
        
cache_get_row(ifield_indexg_VehicleInfo[i][vehicle_Angle], g_Handle128);

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

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

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
Reply
#5

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_Handlequerysizeof(query), "SELECT * FROM `vehicles`");
    
mysql_tquery(g_Handlequery"OnLoadVehicles""");
    return 
1;
}
public 
OnLoadVehicles()
{
    for(new 
0cache_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.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)