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