17.09.2013, 15:00
Hello, I've been reading up on the cacheing tutorial but this will not seem to work:
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?
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);
}