[KarlZco]

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.

[KarlZco]

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

[S4t3K]

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.

[Konstantinos]

Change the format to:

pawn Код:

"iss"

instead of:

pawn Код:

"is[24]s[128]"

[KarlZco]

Thanks...