Unban help
#5

[In a native language he can understand]
Zaљto i dalje traћiљ pozornost, kada sam ti već objasnio kako to napraviti, i zaљto ne napiљeљ rijeљeno na one probleme koji su rijeљeni?
Now for those who don't understand Balcan languages...
The correct code is:
pawn Код:
CMD:unban(playerid, params[])
{
    if(pInfo[playerid][pAdmin] < 3 && !IsPlayerAdmin(playerid)) return SendClientMessage(playerid, 0xFFFFFFFF, ""embed_red"[ERROR] "embed_white"You are not authorized to use this command!");
   
    new id,Query[250];
    if (sscanf(params, "u", id)) return SendUsage(playerid, "/unban [Player ID / Player Name]", "0");
   
    format(Query, 250, "SELECT * FROM `sampbans` WHERE `banusername`='%s'", pName[id]);
    mysql_query(Query);
    mysql_store_result();
   
    new rows = mysql_num_rows();
    mysql_free_result();
   
    if (rows != 0)
    {
        SendClientMessageEx(playerid, 0xFFFFFFF, ""embed_orange"[Unban] "embed_white"%s has been unbanned!", pName[id]);
       
        format(Query, 250, "DELETE * FROM `sampbans` WHERE `banusername`='%s'", pName[id]);
        mysql_query(Query);
    }
    else
    {
        SendClientMessageEx(playerid, 0xFFFFFFF, ""embed_orange"[Unban] "embed_white"%s is not in database!", pName[id]);
    }
    return 1;
}
Now, also check if your query gets executed or if there is an error. Check your mysql logs.
Reply


Messages In This Thread
Unban help - by Sanady - 15.08.2013, 10:36
Re: Unban help - by Sanady - 15.08.2013, 10:53
Re: Unban help - by Sanady - 15.08.2013, 11:16
Re: Unban help - by Sanady - 15.08.2013, 20:38
Re: Unban help - by Virtual1ty - 16.08.2013, 02:09

Forum Jump:


Users browsing this thread: 1 Guest(s)