[retard]

I have been studying few of the tutorials around here because I need a permanent gag plugin for my server with MySQL support. I have started editing one gag plugin and I'm currently stuck at this part:

PHP Code:

public CheckGag( id) 
{
    static szAuthid[ 35 ];
    get_user_authid( id, szAuthid, 34 );
    
    static szQuery[ 128 ];
    formatex( szQuery, 127, "SELECT `GagDate` FROM `Players` WHERE `SteamID` = '%s';", szAuthid );
    
    new iData[ 2 ];
    iData[ 0 ] = ENCODE_TEXT( szAuthid );
    
    new isGagged = SQL_ThreadQuery( g_SqlTuple, "QueryCheckGag", szQuery, iData, 2);
    
    
    server_print("iData: %i", isGagged)
    
    return PLUGIN_CONTINUE;
} 

public QueryCheckGag( iFailState, Handle:hQuery, szError[ ], iError, iData[ ], iDataSize, Float:fQueueTime ) 
{

    switch( iFailState ) {
        case TQUERY_CONNECT_FAILED: {
            log_amx( "Connection failed: %s", szError);
        }
        case TQUERY_QUERY_FAILED: {
            log_amx( "Query failed: %s", szError );
        }
        default: {
            new iTimeStamp = SQL_ReadResult( hQuery, 0 );
            log_amx("current time: %i, timestamp :%i", get_systime(), iTimeStamp)
            
            new iMonth, iDay, iYear, iHour, iMinute, iSecond;
            
            UnixToTime( iTimeStamp , iYear , iMonth , iDay , iHour , iMinute , iSecond );
            
            static szNewId[ 35 ];
            DECODE_TEXT( iData[ 0 ], szNewId, 34 )
            
            new pid = str_to_num(szNewId)
            
            client_print(pid, print_chat, "Gagged until: %02d/%02d/%02d %02d:%02d:%02d"  , iYear , iMonth , iDay , iHour , iMinute , iSecond );
            
            if( get_systime( ) >= iTimeStamp ) {
                
                static szQuery[ 128 ];
                formatex( szQuery, 127, "DELETE FROM `Players` WHERE `SteamID` = '%s';", szNewId  );
                
                SQL_ThreadQuery( g_SqlTuple, "QueryDeleteGag", szQuery )


            }
            
        }
        
    }
    
    
}

public QueryDeleteGag( iFailState, Handle:hQuery, szError[ ], iError, iData[ ], iDataSize, Float:fQueueTime ) {
    switch( iFailState ) {
        case TQUERY_CONNECT_FAILED: {
            log_amx( "Connection failed: %s", szError);
        }
        case TQUERY_QUERY_FAILED: {
            log_amx( "Query failed: %s", szError );
        }
        default: {
            
            
        }
        
        
    }
    
    
} 


The problem is that SQL_ThreadQuery always returns 1. I've tried it this way but still returns 1

PHP Code:

public CheckGag( id )
{
    static szAuthid[ 35 ];
    get_user_authid( id, szAuthid, 34 );
    
    static szQuery[ 128 ];
    formatex( szQuery, 127, "SELECT `GagDate` FROM `Players` WHERE `SteamID` = '%s';", szAuthid );
    
    new iData[ 2 ];
    iData[ 0 ] = ENCODE_TEXT( szAuthid );
    
    new iGag = SQL_ThreadQuery( g_SqlTuple, "QueryCheckGag", szQuery, iData, 2);
    server_print("iGag: %i", iGag);
    
    if ( iGag == 1 ) // gagged
    {
        return PLUGIN_HANDLED;
    }
    
    
    return PLUGIN_CONTINUE;
} 

public QueryCheckGag( iFailState, Handle:hQuery, szError[ ], iError, iData[ ], iDataSize, Float:fQueueTime ) 
{

    switch( iFailState ) {
        case TQUERY_CONNECT_FAILED: {
            log_amx( "Connection failed: %s", szError);
        }
        case TQUERY_QUERY_FAILED: {
            log_amx( "Query failed: %s", szError );
        }
        default: {
            new iTimeStamp = SQL_ReadResult( hQuery, 0 );
            log_amx("current time: %i, timestamp :%i", get_systime(), iTimeStamp)
            
            new iMonth, iDay, iYear, iHour, iMinute, iSecond;
            
            UnixToTime( iTimeStamp , iYear , iMonth , iDay , iHour , iMinute , iSecond );
            
            static szNewId[ 35 ];
            DECODE_TEXT( iData[ 0 ], szNewId, 34 )
            new pid = str_to_num(szNewId)
            
            client_print(pid, print_chat, "Gag until: %02d/%02d/%02d  %02d:%02d:%02d"  , iYear , iMonth , iDay , iHour , iMinute , iSecond );
            if( get_systime( ) >= iTimeStamp ) {
                
                static szQuery[ 128 ];
                formatex( szQuery, 127, "DELETE FROM `Players` WHERE `SteamID` = '%s';", szNewId  );
                
                SQL_ThreadQuery( g_SqlTuple, "QueryDeleteGag", szQuery )
                return 0;
                
            }
            
        }
        
    }

return 1;
    
    
} 


[undrex]

PHP Code:

if ( (time() - iTimeStamp) >= 120 ) {

}

//120 = num of seconds before gag should expire 


if the UnixToTime function does what it sounds like then i guess you have a unix_timestamp in your db so try code above

[retard]

Originally Posted by undrex PHP Code: if ( (time() - iTimeStamp) >= 120 ) { } //120 = num of seconds before gag should expire  if the UnixToTime function does what it sounds like then i guess you have a unix_timestamp in your db so try code above

Have I explained myself that poorly? The time check works completly fine, I have checked that. However, the return value is always 1. I guess I am not able to return values from threads?

[issen1]

Obviously you can't, because the function SQL_ThreadQuery returns immediately (see docs for return value) and your callback function is only called later, when the Query was executed (or failed).

[retard]

Originally Posted by issen1 Obviously you can't, because the function SQL_ThreadQuery returns immediately (see docs for return value) and your callback function is only called later, when the Query was executed (or failed).

I see. How do I deal with this problem then? I'm kinda lost at this point...

[issen1]

What are you trying to do? Blocking a message depending upon the return value of the MySQL query? That won't be possible.

You can either block the message entirely and print your own message in the query handler or just let the message through.

[retard]

Originally Posted by issen1 What are you trying to do? Blocking a message depending upon the return value of the MySQL query? That won't be possible. You can either block the message entirely and print your own message in the query handler or just let the message through.

Yeah. The MySQL Query checks if the player is gagged. I guess I will have to use a Trie to store the gagged players. Will do a query whenever a player connects if he's in the db, if yes then add him to the Trie. Thought I could do it without the use of an array/trie and simply do queries whenever required, oh well. Thanks for your help.

[Exolent[jNr]]

You can't use SQL_ThreadQuery() for instant results.
Therefore, you have to execute the query normally using the SQL_Connect() + SQL_PrepareQuery() + SQL_Execute() method or cache the value of a player being gagged.