unban probelm

Thijn · Jul 23, 2015, 08:36 AM

Removed your try { } catch block from the onPlayerCommand.

kokia · Jul 23, 2015, 08:42 AM

yes no work

MacTavish · Jul 23, 2015, 08:45 AM

Post the following things

Unban function
A screenshot of your ban table

Thijn · Jul 23, 2015, 08:54 AM

Quote from: Beztone on Jul 23, 2015, 08:45 AMPost the following things

Unban function
A screenshot of your ban table

He posted all those.

KAKAN · Jul 23, 2015, 09:00 AM

Post ur onPlayerCommand

MacTavish · Jul 23, 2015, 09:17 AM

Try it

Code Select

else if ( cmd == "unban" )
  {
   if ( IsNoob( player, cmd ) ) return 0;
     else if ( !text ) MessagePlayer("/" + cmd + " <Full Nick>", player );
         else 
    {
    local q = QuerySQL( db, "SELECT * FROM Bans WHERE Name='" + text + "' COLLATE NOCASE" ); 
    if ( GetSQLColumnData(q, 0) )
                {
       QuerySQL(db, "DELETE FROM Bans WHERE Name='" + text + "'");
    EchoMessage("Admin " + player.Name + " Has Un-Banned " + text + "");
      Message("Admin " + player.Name + " Has Un-Banned " + text + "");
       }
      else MessagePlayer("Invalid Nick/ID Specified!",player );
      FreeSQLQuery( q );
      }
}

If it didnt work then do as @Thijn says here

KAKAN · Jul 23, 2015, 09:51 AM

Yup post ur ban function as well as the ban cmd

kokia · Jul 23, 2015, 10:24 AM

@beztone thanks