[faizal16]

I have problem my code

Error Result:

PHP код:

[16:09:53] [ERROR] cache_get_value_name: field 'reason' not found (E:\Sa-mp server\New Project\sa-mp.id\gamemodes\roleplay.pwn:654)
[16:09:53] [ERROR] cache_get_value_name_int: field 'id' not found (E:\Sa-mp server\New Project\sa-mp.id\gamemodes\roleplay.pwn:655)
[16:09:53] [ERROR] cache_get_value_name: field 'banner' not found (E:\Sa-mp server\New Project\sa-mp.id\gamemodes\roleplay.pwn:656)
[16:09:53] [ERROR] cache_get_value_name: field 'BanDate' not found (E:\Sa-mp server\New Project\sa-mp.id\gamemodes\roleplay.pwn:657)
[16:09:53] [ERROR] cache_get_value_name: field 'username' not found (E:\Sa-mp server\New Project\sa-mp.id\gamemodes\roleplay.pwn:658) 


Code pawno :

PHP код:

forward OnTempBanCheck(playerid);
public OnTempBanCheck(playerid)
{
    new Query[250],
        player_name[MAX_PLAYER_NAME];
    GetPlayerName(playerid, player_name, MAX_PLAYER_NAME);
    GetPlayerIp(playerid, ip, 16);
    mysql_format(g_SQL, Query, sizeof Query, "SELECT TIMESTAMPDIFF(SECOND,NOW(),expire) FROM tempaccblacklist WHERE username='%e'", player_name);
    mysql_tquery(g_SQL, Query, "onBanTempCheck", "i", playerid);
} 


PHP код:

forward onBanTempCheck(playerid);
public onBanTempCheck(playerid)
{
    if (!!cache_num_rows())
    {
        new seconds, 
            Query[75],
            banner[MAX_PLAYER_NAME],
            reason[128],
             str[550],
            name[MAX_PLAYER_NAME],
            BanDate[36],
            Banid;
        cache_get_value_int(0, 0, seconds);
        cache_get_value_name(0, "reason", reason); 
        cache_get_value_name_int(0, "id", Banid); 
        cache_get_value_name(0, "banner", banner); 
        cache_get_value_name(0, "BanDate", BanDate); 
        cache_get_value_name(0, "username", name); 


all not found, except cache_get_value_int(0, 0, seconds);. Whereas I am, put if (!!cache_num_rows()) first.