12.03.2019, 21:09
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
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;
}
