SA-MP Forums Archive
Gives string "NULL" - 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: Gives string "NULL" (/showthread.php?tid=511754)


Gives string "NULL" - KarlZco - 07.05.2014

Hello, I have the problem with stock... "OfflineBan"
In CMD every thing is alright, but when sendig info to stock, then ban reason[P6hjus] change to NULL

Here's cmd and stock.
PHP код:

//-------------------------- CMD: [/OfflineBan]-----------------------//
CMD:offlineban(playerid, params[])
{
    new playerb[MAX_PLAYER_NAME], str[128], strmysql[256];
    if(KasutajaInfo[playerid][pAdminTase]<3) return SendClientMessage(playerid, COLOR_RED, "Teil pole antud хigust kasutada!");
    if(sscanf(params, "s[24]s[128]", playerb, str)) return SendClientMessage(playerid, COLOR_ORANGE, "|NДPUNДIDE|: {FFFFFF}/OfflineBan {FF9900}[{FFFFFF}Nimi{FF9900}] [{FFFFFF}Pхhjus{FF9900}]");
    format(strmysql, sizeof(strmysql), "SELECT * FROM kasutajad WHERE Nimi = '%s' LIMIT 0,1", playerb);
    mysql_function_query(SQL, strmysql, true, "OfflineBan", "is[24]s[128]", playerid, playerb, str);
    return 1;
}
//---------------------------OfflineBan-----------------------//
forward OfflineBan(playerid, Nimi[], P6hjus[]);
public OfflineBan(playerid, Nimi[], P6hjus[])
{
    new rows, fields, Query[256], number[11], string[256], Bannitud;
    cache_get_data(rows, fields);
    if(!rows) return SendClientMessage(playerid, COLOR_RED, "Sellise nimega isikut ei eksisteeri andmebaasis.");
    else
    {
        cache_get_row(0, 26, number), Bannitud = strval(number);
        if(Bannitud == 1) return SendClientMessage(playerid, COLOR_RED, "Valitud mдngja on siit serverist juba banned.");
        else
        {
            format(Query, sizeof(Query), "UPDATE kasutajad SET Ban =1, BanP6hjus = '%s' WHERE Nimi = '%s'", P6hjus, Nimi);
            mysql_function_query(SQL, Query, false, "", "");
            format(string, sizeof(string), "[%s] %s lisas OfflineBanni mдngjale %s. | Pхhjus: %s", AdminLevel(playerid), PlayerName(playerid), Nimi, P6hjus);
            SendAdminMessage(COLOR_GREEN, 1, string);
        }
    }
    return 1;
} 
Some translation... Estonian to English
Nimi = Name
P6hjus = Reason
Mдngja = User/Accont

Waiting for help.
Sorry for bad English.

Re: Gives string "NULL" - KarlZco - 07.05.2014

Any help? Please,fast. I need this command tonight.

Re : Gives string "NULL" - S4t3K - 07.05.2014

cache_get_row is a function, means that it must have a semicolon after the ")".

Do like that, then tell me

PHP код:

 else 
    { 
        cache_get_row(0, 26, number);
        Bannitud = strval(number); 
        if(Bannitud == 1) return SendClientMessage(playerid, COLOR_RED, "Valitud mдngja on siit serverist juba banned."); 
But remember, cache_get_row_int exists. Means you don't have to use strval to have an integer.

Re: Gives string "NULL" - Konstantinos - 07.05.2014

Change the format to:
pawn Код:
"iss"
instead of:
pawn Код:
"is[24]s[128]"


Re: Gives string "NULL" - KarlZco - 07.05.2014

Thanks...