SA-MP Forums Archive
Cache_get_row does not get anything! - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Cache_get_row does not get anything! (/showthread.php?tid=451461)



Cache_get_row does not get anything! - thimo - 17.07.2013

Hello so i have this:
pawn Код:
forward OnPlayerHousesVehiclesLoad(playerid, houseid_);
public OnPlayerHousesVehiclesLoad(playerid, houseid_)
{
    printf( "OnPlayerHousesVehiclesLoad::houseid_ = %d", houseid_ );
    new rows, fields;
    cache_get_data( rows, fields, Handle );

    if( rows )
    {
        print("There are rows - Vehicles");
        new
        idx = 0,
        cmodel2, Float: cx2, Float: cy2, Float: cz2, Float: crot2, ccol1, ccol2, _carid
        ;
        while( rows > idx )
        {
            _carid = cache_get_row_int(idx, 2);
            cmodel2 = cache_get_row_int( idx, 3 );
            cx2 = cache_get_row_float( idx, 4 );
            cy2 = cache_get_row_float( idx, 5 );
            cz2 = cache_get_row_float( idx, 6 );
            crot2 = cache_get_row_float( idx, 7 );
            ccol1 = cache_get_row_int( idx, 8 );
            ccol2 = cache_get_row_int( idx, 9 );

            printf("House_AddVehicle(%d,%d,%f,%f,%f,%f,%d,%d, %d);", houseid_, cmodel2, cx2, cy2, cz2, crot2, ccol1, ccol2, _carid);
            House_AddVehicle(houseid_, cmodel2, cx2, cy2, cz2, crot2, ccol1, ccol2, _carid);
            print("Car loaded");

            idx++;
        }
    }
    return 1;
}
Now this line doesnt work:
Код:
		_carid = cache_get_row_int(idx, 2);
But the problem is _Carid is always zero while theres a 0 and a 1 in the database:


Uploaded with ImageShack.us


Re: Cache_get_row does not get anything! - Misiur - 17.07.2013

Show your select query too

#e: Or are you using simply SELECT * FROM table?


Re: Cache_get_row does not get anything! - thimo - 17.07.2013

pawn Код:
forward OnPlayerHousesLoad(playerid);
public OnPlayerHousesLoad(playerid)
{
    new
        rows,
        fields
    ;
    cache_get_data( rows, fields, Handle );

    if( rows )
    {
        print("There are rows - Houses"); // Debugging
        new idx = 0, string[128];
        while( rows > idx )
        {
            APlayerData[playerid][Houses][idx] = cache_get_row_int( idx, 0 );
            format(string, sizeof(string), "SELECT * FROM `Vehicles` WHERE `HouseID`= %d", APlayerData[playerid][Houses][idx]);
            mysql_function_query( Handle, string, true, "OnPlayerHousesVehiclesLoad", "dd", playerid, APlayerData[playerid][Houses][idx] );
            idx++;
        }
    }
    return 1;
}



Re: Cache_get_row does not get anything! - Misiur - 17.07.2013

Fields indexes start from 0. On 2 you have owner name

pawn Код:
_carid = cache_get_row_int(idx, 2);
//change it to
_carid = cache_get_row_int(idx, 1);



Re: Cache_get_row does not get anything! - thimo - 17.07.2013

Thank you so much!