offline ban mysql not working?
#1

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

Whats wrong?
Reply


Messages In This Thread
offline ban mysql not working? - by severance - 16.08.2018, 20:29
Re: offline ban mysql not working? - by d3ll - 16.08.2018, 22:06
Re: offline ban mysql not working? - by severance - 17.08.2018, 00:10

Forum Jump:


Users browsing this thread: 1 Guest(s)