Unban error

[KAKAN]

Previously i have a UNBAN cmd error which was fixed, but after making a PHP file for Ban(it will be like baninfo), my unban cmd doesn't works, actually it doesn't gives out any error, but after unbanning the data in the database files remains there, when i turn off my Apache and try it works, what's the error?

[Thijn]

You're probably not properly closing the database with apache. That way the file keeps locked for Apache and vcmp is unable to write to it.

[KAKAN]

Can ya tell me how to do it?

[Thijn]

Post some code.

[KAKAN]

Which code shall i post?
The PHP code or my unban cmd code?

[Thijn]

unban cmd.

Also, do any other commands work that change the same database? Logging in, kill stats etc.?

[KAKAN]

Oh yea, login, register, LMS, k/d stats, lastseen, aliases

[KAKAN]

here's the unban cmd

Code Select Expand

else if ( cmd ==  FBS_PREFIX + "unban" )
    {
        if ( level < 4 ) EchoMessage( "Error - You don't have access to it.");
       else if ( !text ) EchoMessage( "Error - Syntax: !unban <player name>");
       else
       {         
         local query = QuerySQL( sqliteDB, "SELECT * FROM Bans WHERE Name='" + text + "'" );
         if( GetSQLColumnData( query, 0 ) )
{
  QuerySQL( sqliteDB, "DELETE FROM Bans WHERE Name='" + text + "'" );
  EMessage( "Admin " + user + " has unbanned " + text );
}
         else EchoNotice( user, "This nick isn't banned. Please type the banned nick." );
         FreeSQLQuery( query );
   }
    }

[Thijn]

Try using S.L.C.'s SQLite plugin so you actually get an error message.

[KAKAN]

Actually, unban is working perfectly when  i turn off Apache, does the webstats and the server needs to be in one directory?
And how can  i use MySQL for WebStats, I use your WebStats PHP version, so will it harm when registering accounts?

[KAKAN]

FIXED