SA-MP Forums Archive
cache_get_row_int and cache_get_row_float - 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_int and cache_get_row_float (/showthread.php?tid=464529)


cache_get_row_int and cache_get_row_float - AphexCCFC - 17.09.2013

Hello, I've been reading up on the cacheing tutorial but this will not seem to work:

pawn Код:
new rows, fields;
    cache_get_data(rows, fields, dbHandle);
    if(rows)
    {
        PlayerInfo[playerid][pGender]       = cache_get_row_int(0, 5, dbHandle);
        PlayerInfo[playerid][pCash]         = cache_get_row_int(0, 6, dbHandle);
        PlayerInfo[playerid][pBank]         = cache_get_row_int(0, 7, dbHandle);
        PlayerInfo[playerid][pBankReg]      = cache_get_row_int(0, 8, dbHandle);
        PlayerInfo[playerid][pLevel]        = cache_get_row_int(0, 9, dbHandle);
        PlayerInfo[playerid][pSkin]         = cache_get_row_int(0, 10, dbHandle);
        PlayerInfo[playerid][pAdmin]        = cache_get_row_int(0, 11, dbHandle);
        PlayerInfo[playerid][pAdminDuty]    = cache_get_row_int(0, 12, dbHandle);
        PlayerInfo[playerid][pOwner]        = cache_get_row_int(0, 13, dbHandle);
        PlayerInfo[playerid][pJob]          = cache_get_row_int(0, 14, dbHandle);
        PlayerInfo[playerid][pInterior]     = cache_get_row_int(0, 15, dbHandle);
        PlayerInfo[playerid][pVirtualWorld] = cache_get_row_int(0, 16, dbHandle);
        PlayerInfo[playerid][pNewbMute]     = cache_get_row_int(0, 17, dbHandle);
        PlayerInfo[playerid][pGetHouseID]   = cache_get_row_int(0, 18, dbHandle);
        PlayerInfo[playerid][pVehID]        = cache_get_row_int(0, 19, dbHandle);
        PlayerInfo[playerid][pVehName]      = cache_get_row_int(0, 20, dbHandle);
        PlayerInfo[playerid][pVehX]         = cache_get_row_int(0, 21, dbHandle);
        PlayerInfo[playerid][pVehY]         = cache_get_row_int(0, 22, dbHandle);
        PlayerInfo[playerid][pVehZ]         = cache_get_row_int(0, 23, dbHandle);
        PlayerInfo[playerid][pVehA]         = cache_get_row_int(0, 24, dbHandle);
        PlayerInfo[playerid][pVeh2ID]       = cache_get_row_int(0, 25, dbHandle);
        PlayerInfo[playerid][pVeh2Name]     = cache_get_row_int(0, 26, dbHandle);
        PlayerInfo[playerid][pVeh2X]        = cache_get_row_int(0, 27, dbHandle);
        PlayerInfo[playerid][pVeh2Y]        = cache_get_row_int(0, 28, dbHandle);
        PlayerInfo[playerid][pVeh2Z]        = cache_get_row_int(0, 29, dbHandle);
        PlayerInfo[playerid][pVeh2A]        = cache_get_row_int(0, 30, dbHandle);
        PlayerInfo[playerid][pPos][0]       = cache_get_row_float(0, 31, dbHandle);
        PlayerInfo[playerid][pPos][1]       = cache_get_row_float(0, 32, dbHandle);
        PlayerInfo[playerid][pPos][2]       = cache_get_row_float(0, 33, dbHandle);
        PlayerInfo[playerid][pPos][3]       = cache_get_row_float(0, 34, dbHandle);
    }
I'm guessing the second lot of digits (the ones I've numbered) works like this, if ID was the first field in the table it'd be 1, then if username was next it'd be 2 and so forth?

Re: cache_get_row_int and cache_get_row_float - Misiur - 17.09.2013

Almost - but starts at 0.