[OuDayas]

Hi, I'm trying to write a command for ban a player, technically only insert: username, the ban reason, name of admin, date and ip.

But when i insert the command in game, everything goes ok, but for the insert the data in the table don't work,
how can I fix that?

p.s: the part for if the target player is own player, I make like this in the comment for testing che cmd
My version of MySQL is r41 with zcmd, easydialog, foreach, sscanf and streamer

pawn Код:

CMD:ban(playerid, params[])
{   // admin lv: >=3 (moderatore)
    new TargetPlayer, banreason[128], str[128];
    if(Player[playerid][Admin] >= 3)
    {
        if(sscanf(params, "us[128]", TargetPlayer, banreason)) return SendClientMessage(playerid, COLOR_SYSTEM_ADMIN, "[COMANDO] Uso: /remoteban [Utente] [Motivo ban]");
        if(isvoid(banreason))
        {
            format(str, sizeof(str), "{FF0000}[ERRORE]: Devi inserire il motivo del ban per: %s", Player[TargetPlayer][RPName]);
            SendClientMessage(playerid, -1, str);
            return 1;
        }/*
        if(TargetPlayer == playerid)
        {
            format(str, sizeof(str), "{FF0000}[ERRORE]: Non puoi bannare te stesso!");
            SendClientMessage(playerid, -1, str);
            return 1;
        }*/
        if(!IsPlayerConnected(TargetPlayer))
        {
            format(str, sizeof(str), "{FF0000}[ERRORE]: Giocatore non trovato{FFFF}, se registrato al server usa /remoteban");
            SendClientMessage(playerid, -1, str);
            return 1;
        }
        if(TargetPlayer != INVALID_PLAYER_ID)
        {
            // messaggio all'admin
            format(str, sizeof(str), "{FFFFFF}[INFO]: Hai appena bannato: {AFAFAFAF}%s", Player[TargetPlayer][RPName]);
            SendClientMessage(TargetPlayer, -1, str);
            format(str, sizeof(str), "{FFFFFF}[INFO]: Motivo: {FF0000}%s", banreason);
            SendClientMessage(TargetPlayer, -1, str);

            // messaggio all'utente bannato
            format(str, sizeof(str), "{FF0000}[BAN]: Sei Stato bannato da: {FFFF00}%s", Player[playerid][RPName]);
            SendClientMessage(TargetPlayer, -1, str);
            format(str, sizeof(str), "{FF0000}[BAN]: Motivo: {FFFF00}%s", banreason);
            SendClientMessage(TargetPlayer, -1, str);

            new banquery[256];
            mysql_format(g_SQL, banquery, sizeof banquery,
            "INSERT INTO 'bans' ('username', 'bannedby', 'reason', 'date', 'ip?) VALUES ('%e', '%e', '%e', '%e', '%e')",
            Player[TargetPlayer][Name], Player[playerid][Password], banreason, ReturnDate(), Player[TargetPlayer][LastIP]);
            mysql_tquery(g_SQL, banquery);
            DelayedKickTime(TargetPlayer, 1500); // 1,5 secondi
            return 1;
        }
    }
    else if(Player[playerid][Admin] < 3)
    {
        SendErrorMessage(playerid, ERROR_ADMIN_LEVEL);
        return 1;
    }
    else if(Player[playerid][Admin] == 0)
    {
        SendErrorMessage(playerid, ERROR_ADMIN);
        return 1;
    }
    return 1;
}