[killergirl]

I'm having problems with my new plugin. If I retrieve (query) data from a database and the selected value from a column it's not existing, then I get errors in my server console. I'm looking for a native like SQL_Execute, if the query succes than return 1.

PHP Code:

...
formatex(szQuery, charsmax(szQuery), "SELECT * FROM `%s_player_id` WHERE name='%s'", l_prefix, name)

SQL_ThreadQuery(g_SqlTuple, "getPlayerID", szQuery, param, charsmax(param) )
...

public getPlayerID(...)

if(something like SQL_Execute(query))
   //query succes, than read result
else
  //print msg -> sorry no data found. 


It's it's very annoying if I get errors in my log folder and in my server console if data it's not existing.

[xPaw]

SQL_IsFail( const iFailState, const iError, const szError[ ] )
{
    if( iFailState == TQUERY_CONNECT_FAILED )
    {
        log_to_file( LogFile, "[Error] Could not connect to SQL database: %s", szError );
        return true;
    }
    else if( iFailState == TQUERY_QUERY_FAILED )
    {
        log_to_file( LogFile, "[Error] Query failed: %s", szError );
        return true;
    }
    else if( iError )
    {
        log_to_file( LogFile, "[Error] Error on query: %s", szError );
        return true;
    }
    
    return false;
}

public HandleSomeRandomQuery( iFailState, Handle:hQuery, szError[ ], iError, szData[ ], iSize, Float:flQueueTime )
{
    if( SQL_IsFail( iFailState, iError, szError ) )
    {
        return;
    }
    
    // Read results
}

[Sylwester]

PHP Code:

if(SQL_MoreResults(query))
   //query succes, than read result
else
  //print msg -> sorry no data found. 


This has nothing to do with query success. Query is successful even if no data was found.