[severance]

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?

[d3ll]

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; 
}

[severance]

fixed thanks it works.