cache_get_row_int and cache_get_row_float
#1

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?
Reply
#2

Almost - but starts at 0.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)