Unban problem

[Williams]

HI guys i need help i have Delban function it's not work so help me.. and tell me what is bug please!.

Command

Code Select Expand

else if ( cmd == "unban" )
{
   if ( IsNoob( player, cmd ) ) return 0;
   else if ( !text ) MessagePlayer(WHITE+"Syntax - /" + cmd + " <Full Nick>", player );
   else if ( CheckBan( text ) == 0 ) MessagePlayer( YELLOW+"Error - - [ " + text + " ] is not Banned.", player );
   else DelBan( player, text );
}
Function.

Code Select Expand

function DelBan( admin, banned )
{
    local type = "Nick-Banned";
    local q = QuerySQL( db, "SELECT * FROM Ban WHERE Name='" + banned + "'" );
    local name = GetSQLColumnData( q, 0 );
    if ( GetSQLColumnData( q, 6 ) == type )
   {
    QuerySQL( db, "DELETE FROM Ban WHERE Name='" + banned + "'" );
Message(RED+ "--> Admin [ " + admin + " ] Un-Banned Player:[ "  + banned +  " ]" );
EchoMessage(ICOL_GREEN+ICOL_BOLD+">> Admin [" + admin + "] Un-Banned Player:[ "  + banned +  " ]" );
}
}
Please tell me bug!

HAve a Nice day!!

[Diego^]

Try this:

Code Select Expand

function DelBan( admin, banned )
{
local q = QuerySQL( db, "SELECT * FROM Ban WHERE Name='" + banned + "'" );
if ( GetSQLColumnData( q, 0 ) == banned )
{
QuerySQL( db, "DELETE FROM Ban WHERE Name='" + banned + "'" );
Message(RED+ "--> Admin [ " + admin.Name + " ] Un-Banned Player:[ "  + banned +  " ]" );
EchoMessage(ICOL_GREEN+ICOL_BOLD+">> Admin [" + admin.Name + "] Un-Banned Player:[ "  + banned +  " ]" );
}
}


[EK.IceFlake]

Code Select Expand

if ( IsNoob( player, cmd ) )*condition true*
mainly because you need to tell us that ban table

[Williams]

Code Select Expand

if ( IsNoob( player, cmd ) )*condition true*
mainly because you need to tell us that ban table

Try this:

Code Select Expand

function DelBan( admin, banned )
{
local q = QuerySQL( db, "SELECT * FROM Ban WHERE Name='" + banned + "'" );
if ( GetSQLColumnData( q, 0 ) == banned )
{
QuerySQL( db, "DELETE FROM Ban WHERE Name='" + banned + "'" );
Message(RED+ "--> Admin [ " + admin.Name + " ] Un-Banned Player:[ "  + banned +  " ]" );
EchoMessage(ICOL_GREEN+ICOL_BOLD+">> Admin [" + admin.Name + "] Un-Banned Player:[ "  + banned +  " ]" );
}
}


Thanks NE.CrystalBlue @Diego