Help MySQL cache - Printable Version

Help MySQL cache - 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: Help MySQL cache (/showthread.php?tid=643201)

Field Not Foud on mysql cache_get_value r41-3 - faizal16 - 15.10.2017

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.