SA-MP Forums Archive
offline ban mysql not working? - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: offline ban mysql not working? (/showthread.php?tid=657878)


offline ban mysql not working? - severance - 16.08.2018

PHP код:
CMD:oban(playerid, params[]) // Banning offline players
{
    if(connected[playerid] == true) return GameTextForPlayer(playerid, "~r~Spawn First", 5000, 5);
     if(pInfo[playerid][Admin] < 2) return 1;
      else
      {
          new PID, reason[64], target, query[259];
          if(sscanf(params, "us[64]", PID, reason)) return SendClientMessage(playerid, -1, "{c3c3c3}/oban [nickname] [reason]");
         mysql_format(g_SQL, query, sizeof query, "SELECT * FROM `players` WHERE `username` = '%s'", PlayerName[target]);
        mysql_tquery(g_SQL, query);
        
         new rows = cache_num_rows();
        if (rows){
        
         mysql_format(g_SQL, query, sizeof query, "UPDATE `players` SET `banned` = 1 WHERE `id` = '%d' LIMIT 1", pInfo[target][ID]);
        mysql_tquery(g_SQL, query);
        
        SendClientMessage(playerid, -1, "Command executed");
        
        }
    }
    return 1;
} 
Whats wrong?

Re: offline ban mysql not working? - d3ll - 16.08.2018

Try this:

pawn Код:
CMD:oban(playerid, params[]) // Banning offline players 
{ 
  if(connected[playerid] == true) return GameTextForPlayer(playerid, "~r~Spawn First", 5000, 5); 
  if(pInfo[playerid][Admin] >= 2)
  { 
    new reason[64], target[MAX_PLAYER_NAME], query[259]; 
    if(sscanf(params, "s[24]s[64]", target, reason))
      return SendClientMessage(playerid, -1, "{c3c3c3}/oban [nickname] [reason]"); 
    mysql_format(g_SQL, query, sizeof query, "SELECT `id` FROM `players` WHERE `username` = '%e'", target); 
    mysql_tquery(g_SQL, query); 
    new rows = cache_num_rows(); 
    if (rows)
    { 
      mysql_format(g_SQL, query, sizeof query, "UPDATE `players` SET `banned` = 1 WHERE `username` = '%e' LIMIT 1", target); 
      mysql_tquery(g_SQL, query);    
      SendClientMessage(playerid, -1, "Command executed");     
    }
    return 1;
  } 
  GameTextForPlayer(playerid, "~r~You cannot use this.", 5000, 5); 
  return 1; 
}


Re: offline ban mysql not working? - severance - 17.08.2018

fixed thanks it works.