MySQL didn't insert data
#6

Guys I fixed...Its because the timer of 1.5 seconds, is too short, and I inserted a timer at 5 sec.
I have tryied that and work, this is the code.
pawn Код:
CMD:ban(playerid, params[])
{   // admin lv: >=3 (moderatore)
    new TargetPlayer, banreason[128], str[128], banquery[256];
    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{FFFFFF}, 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: {AFAFAF}%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);

            mysql_format(g_SQL, banquery, sizeof(banquery),
            "INSERT INTO `bans` (`username`, `bannedby`, `banreason`, `date`, `ip`) VALUES ('%s', '%s', '%s', '%s', '%s')",
            Player[TargetPlayer][Name],
            Player[playerid][Name],
            banreason,
            ReturnDate(),
            Player[TargetPlayer][LastIP]);
            mysql_tquery(g_SQL, banquery);

            DelayedKickTime(TargetPlayer, 5000); // 1,5 secondi
            return 1;
        }
        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;
}
Reply


Messages In This Thread
MySQL didn't insert data - by OuDayas - 12.03.2019, 21:09
Re: MySQL didn't insert data - by SymonClash - 12.03.2019, 21:52
Re: MySQL didn't insert data - by L0K3D - 12.03.2019, 21:59
Re: MySQL didn't insert data - by OuDayas - 12.03.2019, 22:09
Re: MySQL didn't insert data - by SymonClash - 12.03.2019, 22:14
Re: MySQL didn't insert data - by OuDayas - 13.03.2019, 21:12
Re: MySQL didn't insert data - by Markski - 15.03.2019, 00:37
Re: MySQL didn't insert data - by SymonClash - 15.03.2019, 09:10

Forum Jump:


Users browsing this thread: 1 Guest(s)