Error

[Cool]

in screenshot error is defined

Code Select Expand

function Loan( player )
{
      local query = QuerySQL( sqliteDB, "SELECT * FROM Loan WHERE Loan_nick='" + player.Name + "' COLLATE NOCASE" );
   if( GetSQLColumnData( query, 0 )  )
   {
         if( ( time() - GetSQLColumnData( query, 3 ).tointeger() )
   {
       local query2 = QuerySQL( sqliteDB, "DELETE FROM Loan WHERE Loan_nick" + player.Name + "'" );
    FreeSQLQuery( query2 );
       MessagePlayer(" you loan time finished.", player );
   }
}
   else MessagePlayer("ALERT: YOU DIDNOT PAYED LOAN" ,player);
}

[.]

Awwww, my eyes. MY EYES. What DAFUQ did I just read! Holy f* the messed up structuring on that code AND the number of missing closing braces. MY EEEEEYYYYYEEEEESSS!

[Cool]

Awwww, my eyes. MY EYES. What DAFUQ did I just read! Holy f* the messed up structuring on that code AND the number of missing closing braces. MY EEEEEYYYYYEEEEESSS!

i added already while testing but same result dear @S.L.C

[Luckshya]

Try changing this line

Code Select Expand

local query2 = QuerySQL( sqliteDB, "DELETE FROM Loan WHERE Loan_nick" + player.Name + "'" );
To

Code Select Expand

local query2 = QuerySQL( sqliteDB, "DELETE FROM Loan WHERE Loan_nick='" + player.Name + "'" );


[Cool]

not working

[Luckshya]

not working

Ok, i forgot one sign, try it again.

[.]

Try changing this line

Code Select Expand

local query2 = QuerySQL( sqliteDB, "DELETE FROM Loan WHERE Loan_nick" + player.Name + "'" );
To

Code Select Expand

local query2 = QuerySQL( sqliteDB, "DELETE FROM Loan WHERE Loan_nick='" + player.Name + "'" );


USELESS!

... AND the number of missing closing braces.

[Cool]

not working

[.]

Oh FFS do I have to spell it out loud:

Code Select Expand

function Loan( player )
{
    local query = QuerySQL( sqliteDB, "SELECT * FROM Loan WHERE Loan_nick='" + player.Name.tolower() + "';" );

    if ( !query )
    {
        return;
    }
    else if( GetSQLColumnData( query, 0 )  )
    {
        if( ( time() - GetSQLColumnData( query, 3 ).tointeger() )
        {
            local query2 = QuerySQL( sqliteDB, "DELETE FROM Loan WHERE Loan_nick='" + player.Name + "';" );
            FreeSQLQuery( query2 );
            MessagePlayer(" you loan time finished.", player );
        }
    }
    else
    {
        MessagePlayer("ALERT: YOU DIDNOT PAYED LOAN" ,player);
    }

    FreeSQLQuery( query );
}

[KAKAN]

I already answered it to him in PM, he just can't understand

[Cool]

@KAKAN I FORGET I WANT TO SHARE ABOUT YOUR HELP IN PM BUT SAME ERROR AND SLC ONE HAVE SAME ERROR ITS MEAN PROB IN MY DB
MY CAPLOCKS BUTTON NOT WORKING

[KAKAN]

@KAKAN I FORGET I WANT TO SHARE ABOUT YOUR HELP IN PM BUT SAME ERROR AND SLC ONE HAVE SAME ERROR ITS MEAN PROB IN MY DB

I said your DB has problems. Show us your table create code and one row from it.

[Cool]

Code Select Expand

  QuerySQL( sqliteDB , "CREATE TABLE IF NOT EXISTS Loan( Loan_nick TEXT, Loan_amount TEXT, Loan_time TEXT )" );


[KAKAN]

Code Select Expand

  QuerySQL( sqliteDB , "CREATE TABLE IF NOT EXISTS Loan( Loan_nick TEXT, Loan_amount TEXT, Loan_time TEXT )" );


What about a row? Show me Loan_time, I wanna see if you increase the loan time using time or not.