MySQL didn't insert data
#4

Oh i wrote the command wrong, sorry i didn't see that, this is the correct code. whit the code that L0K3D give me.
And the problem didn't fixed :\
(sorry for my bad English)
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: {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);


//                     da qua non inserisce niente non so perchй/ here don't insert nothing idk why                          
            new banquery[256];
            mysql_format(g_SQL, banquery, sizeof banquery,
            "INSERT INTO `bans` (`username`, `bannedby`, `reason`, `date`, `ip`) VALUES ('%s', '%s', '%s', '%s', '%s')",
            Player[TargetPlayer][Name], Player[TargetPlayer][RPName], 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;
}
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: 7 Guest(s)